Database Backup and Recovery (MOSC)

MOSC Banner

impdp error,ORA-06550: line 1, column 33: PLS-00302: component 'IS_IMPORT_TRANSPORTABLE' must be dec

edited Nov 18, 2016 4:08PM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE ORA-39083: Object type TABLE:"NMS"."STATISTICSRPLINSTANCEINFO" failed to create with error: ORA-06550: line 1, column 33: PLS-00302: component 'IS_IMPORT_TRANSPORTABLE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Failing sql is: CREATE TABLE "NMS"."STATISTICSRPLINSTANCEINFO" ("ID" NUMBER(10,0) NOT NULL ENABLE, "DEVICEID" NUMBER(10,0) NOT NULL ENABLE, "REPORTTIME" DATE NOT NULL ENABLE, "ISJOINED" NUMBER(3,0) NOT NULL ENABLE, "ISROUTER" NUMBER(3,0) NOT NULL ENABLE, "CURRENTDTSN"

we are currently on 11.2.0.3 enterprise edition database.

we have not seen this error on any of our previous instances of using impdp

any information would be helpful

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center