Hi All,
I'm trying to import a table to my new created Oracle 11g DB (11.2.0.3.0), but repeatedly encountering below error.
Note: No issue with the user privilege or directory/path. All of those are fine.
Import: Release 11.2.0.3.0 - Production on Fri Apr 22 04:48:37 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
UDI-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1
When i tried various checks, i found below objects to be INVALID in DB level.
I also tried running "@?/rdbms/admin/utlrp.sql", but no use. these objects are INVALID even after that.
STATUS OBJECT_ID OBJECT_TYPE OWNER.OBJECT
--------- ---------- -------------------- --------------------------------------------------
INVALID 12731 VIEW SYS.AQ$ALERT_QT_R
INVALID 12970 VIEW SYS.AQ$AQ_PROP_TABLE_R
INVALID 12611 VIEW SYS.AQ$SCHEDULER$_EVENT_QTAB_R
INVALID 12639 VIEW SYS.AQ$SCHEDULER$_REMDB_JOBQTAB
INVALID 12645 VIEW SYS.AQ$SCHEDULER$_REMDB_JOBQTAB_R
INVALID 12675 VIEW SYS.AQ$SCHEDULER_FILEWATCHER_QT_R
INVALID 12726 VIEW SYS.AQ$_ALERT_QT_F
INVALID 12929 VIEW SYS.AQ$_AQ$_MEM_MC_F
INVALID 12965 VIEW SYS.AQ$_AQ_PROP_TABLE_F
INVALID 12606 VIEW SYS.AQ$_SCHEDULER$_EVENT_QTAB_F
INVALID 12640 VIEW SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_F
INVALID 12670 VIEW SYS.AQ$_SCHEDULER_FILEWATCHER_QT_F
INVALID 13416 SYNONYM SYS.PRODUCT_USER_PROFILE
INVALID 6040 TYPE SYS.SCHEDULER$_REMOTE_ARG
INVALID 6041 TYPE SYS.SCHEDULER$_REMOTE_ARG_LIST
INVALID 6042 TYPE SYS.SCHEDULER$_REMOTE_DB_JOB_INFO
Please check and let me know fix. Thanks in advance.