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:
Post a Comment