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 ;)

SharePoint: Content Deployment Paths and Jobs

Today I was using the content deployment functionality of SharePoint. All configuration seemed to go well but when i started the Job it just kept hanging on Preparing.

After a simple google search I found out that many people had ran into this problem, but most had not found an answer.

For some it was the Windows SharePoint Timer Service that had to be started, for some it was the target Site collection that had to be created based on a Blank Site template ...

For me however I only got it working by changing the "Content Deployment Settings" on both servers so that in the "Connection Security" part both had the "Do not require encryption" functionality selected.

Maybe this can help somebody, someday, somewhere ;)

For a good start ...

I'm going to try something new for myself, and that something is ...

yeah you guessed it! It's writing a blog :)
Because I don't believe you can start off with the serious stuff all of a sudden, I'm going to start of with something easier. Last month a colleague stumbled upon the movies of 'Greg the architect'.

For people in the IT business, I certainly recommend having a look. Me and my colleagues had a good laugh with them.

www.gregthearchitect.com


Cya next blog