Re: Oracle upgrade
Date: Mon, 20 Feb 2012 14:44:02 +0000
Can't say I've noticed it myself, but did it change to "$ORACLE_BASE/admin/SID/dpdump"?
This is the default for that directory, so it is not beyond the realms of possibility that the upgrade updates the directory to the default path. The catalog and catproc scripts contain loads of stuff, inicluding all the DP stuff, so it is likely the CREATE OR REPACE DIRECTORY command was run.heers
You should probably not have a rant at your colleague. I know it feels good sometimes, but "Just because it feels good, doesn't make it right!".
On Mon, Feb 20, 2012 at 2:25 PM, Goulet, Richard
> Before I go off like a gun in a colleagues face, has anyone had their DATA_PUMP_DIR changed when doing an Oracle upgrade? A colleague of mine did an upgrade of a dev database the other day for me from 220.127.116.11 to 18.104.22.168. I had the DATA_PUMP_DIR pointed to an NFS mount to a san disk that is also shared out with windows. This way our developers can ask for a data dump and have access to it from their desktops. Well, today someone did & the file did not appears as expected, so after the 3rd try I looked at the definition and sure enough it had changed. Anyone else have a similar experience so I can blame Oracle.
> Richard Goulet
> Senior Oracle DBA/Na Team Leader