Data pump Import Error ORA-31625: Schema ORDSYS is needed to import this object, but is unaccessible ( Doc ID 2160112.1 )
ORA-01435 for ORDSYS schema during import is expected behavior because Oracle Multimedia component is not installed on target database.
Solution
----------------
To prevent this error, you can install Oracle Multimedia on target database, or exclude Oracle Multimedia schemas from export/import. Exclude ORDSYS, ORDPLUGINS , SI_INFORMTN_SCHEMA , ORDDATA , MDSYS with the data pump EXCLUDE parameter.
ORA-01435 for ORDSYS schema during import is expected behavior because Oracle Multimedia component is not installed on target database.
Solution
----------------
To prevent this error, you can install Oracle Multimedia on target database, or exclude Oracle Multimedia schemas from export/import. Exclude ORDSYS, ORDPLUGINS , SI_INFORMTN_SCHEMA , ORDDATA , MDSYS with the data pump EXCLUDE parameter.
No comments:
Post a Comment