PROBLEM:
-----------
expdp schemas=USERNAME directory=DUMP_DIR content=metadata_only dumpfile=USERNAME.dmp logfile=USERNAME.log userid=USERNAME/USERNAME Export: Release 12.1.0.1.0 - Production on .......... Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c ...................... With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options ORA-31626: job does not exist ORA-31633: unable to create master table "USERNAME.SYS_EXPORT_SCHEMA_XX" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 1031 ORA-30511: invalid DDL operation in system triggers ORA-06512: at line 1288 ORA-30511: invalid DDL operation in system triggersSolution:
--------------
SQL@USERNAME>Purge DBA_RECYCLEBIN; DBA Recyclebin purged. SQL@USERNAME>purge recyclebin; Recyclebin purged.If does not works Restart database and do the above steps again... All should be fine....
No comments:
Post a Comment