Database Utilities (MOSC)

MOSC Banner

impdp ORA-39168: Object path xxx was not found.

edited Mar 9, 2015 8:53AM in Database Utilities (MOSC) 4 commentsAnswered ✓

I am import from 11.2.0.2 (EE) to 11.2.0.4(SE) using network_link.

when import just one schema, no problem.

When import using par file like:

include=SCHEMA:"IN (SELECT USERNAME FROM dba_users where user_id > 200)",ROLE,USER,SYSTEM_GRANT,ROLE_GRANT,DEFAULT_ROLE,TABLESPACE_QUOTA

cluster=n

full=y

Hit error:

>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled

>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled

Tagged:

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