Database Utilities (MOSC)

MOSC Banner

Export datapump with INCLUDE=DIRECTORY

edited Oct 8, 2009 3:13AM in Database Utilities (MOSC) 5 commentsAnswered
 Hallo,

I need to export with datapump several objects that belong to owner SYS.

Same of this objects are DIRECTORY. My sintax in expdp command is :

INCLUDE=VIEW:"='SYS.WEBMON_X$KGLPN'"
INCLUDE=VIEW:"='SYS.WEBMON_X$KGLOB'"
INCLUDE=DIRECTORY:"='SYS.dpump'"
INCLUDE=DIRECTORY:"='SYS.TRAS_DIR'"
INCLUDE=DIRECTORY:"='SYS.TRAS_BCK_DIR'"
INCLUDE=DIRECTORY:"='SYS.STORICO_DIR'"

but I always get this error message :

ORA-39001: invalid argument value
ORA-39038: Object path "DIRECTORY" is not supported for SCHEMA jobs.

Need help to correct my sintax for exporting DIRECTORY, is this type of object exportable ?

Thanks

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