Wednesday, January 13, 2016

RA-31633: unable to create master table '' ORA-30511: invalid DDL operation in system triggers


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 triggers







Solution:
--------------



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