Database Utilities (MOSC)

MOSC Banner

ORA-39002 followed by ORA-39168 on impdp with sqlfile parameter

edited Sep 16, 2020 9:42PM in Database Utilities (MOSC) 4 commentsAnswered ✓

Hi Gurus,

I am with the following environment.  Oracle Linux 7(64 bit) with Oracle EE Database 12.2.0.1.0.

I am doing expdp at schema level.  I issued the following command.

expdp 'username/password' directory=directory_name dumpfile=dump_filename logfile=logfile.log schemas=schema_name

The above command exported the schema_name I wanted successfully.

Now I want to gather constraints sql statements only in an sqlfile.

I used the following command:

impdp 'username/password' directory_name=dir_name dumpfile=dump_filename logfile=logfile.log include=constraint sqlfile=const.sql

It produces the following error:

ORA-39002: invalid operation

ORA-39168: Object path CONSTRAINT was not found.

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