Monday, January 19, 2009

Oracle DataPump INCLUDE/EXCLUDE Part 2

Hi all,

I ran into another little problem with the expdp utility off oracle.
For my purposes i called the utility with a parfile, this parfile was generated by another step in the scripting progress.

The oracle documentation listed that i could repeat INCLUDE statemets, so my script generates something like this:

INCLUDE=FUNCTION:"='FUNC_NAME'"
INCLUDE=FUNCTION:"='FUNC_NAME_OTHER'"
INCLUDE=FUNCTION:"='FUNCY_NAME'"
INCLUDE=PACKAGE:"='THE_PACKAGE'"

However when running this, i kept getting the error:
- ORA-39168: Object path function was not found.

It took a while but i finally found out that you CAN repeat include statements but you CANT repeat object paths.

above sample should thus be:

INCLUDE=FUNCTION:"IN ('FUNC_NAME','FUNC_NAME_OTHER','FUNCY_NAME')"
INCLUDE=PACKAGE:"='THE_PACKAGE'"

Here you go, Some more 'wisdom' shared with the internet-connected world

No comments:

Search This Blog