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

Oracle DataPump INCLUDE/EXCLUDE

Hi

I needed to create some oracle scripts for a project i am working on.
However when making my datapump scripts for the export I ran into some trouble:

ORA-39168: Object path function was not found.

After some searching I find out that I was using the wrong export type to be using that path.
The question is how did I find this out?

well ...
Just use the DATAPUMP_PATHS view in oracle !
It's a realy handy little thing :)

Edit: In Part 2 You can find another reason for this error ;)