Using 10g datapump and scheduler to copy schemas
By Andrew Fraser
This entry was posted on Thursday 1 February 2007 at 4:10 pm and is filed under rac, scripts. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Wednesday 16 May 2007 at 1:43 am
Nice script…
How about an Export?
Wednesday 16 May 2007 at 9:18 am
This was on RAC, so an export/import running from cron on one node wouldn’t work when that node was down. Would have to introduce failover detection or run the export/import on a third server over sqlnet.
But given the issues I ran into doing this with datapump compared to export, it would have been easier – and more supportable for other DBAs – to stick with old fashioned export/import. Datapump does not work easily in practice as easily as the documentation implies.
Tuesday 25 September 2007 at 12:27 pm
[...] http://andrewfraser.wordpress.com/2007/02/01/using-10g-datapump-and-scheduler-to-copy-schemas/ Posted in Datapump. Tags: Datapump. [...]
Thursday 3 January 2008 at 5:31 pm
I am trying use a db link to perform an import, but am running into various errors.
Do you know where I could find a list of the required privileges I’d need to use dbms_datapump from a stored procedure to import a schema using a db link?
Thanks…
Wednesday 6 February 2008 at 9:24 am
Hello Rob,
I have just install this procedure and I put this privileges and roles :
GRANT CONNECT TO MYUSER;
GRANT RESOURCE TO MYUSER;
GRANT IMP_FULL_DATABASE TO MYUSER;
GRANT UNLIMITED TABLESPACE TO MYUSER;
GRANT create table TO MYUSER;
GRANT SELECT ANY TABLE TO MYUSER;
GRANT create session TO MYUSER;
GRANT DBA TO MYUSER;
ALTER USER MYUSER DEFAULT ROLE ALL;
GRANT READ,WRITE ON DIRECTORY DUMPDIR TO MYUSER;
Saturday 27 September 2008 at 6:05 am
Great, Thanks. That solved my problem.
Yet, I am running two different schema exports in one Package, however the current user/schema runs succesfully… the next dynamically formed user schema based on some input, is not exported. it donot see any errors but not the export too doesnot happen.
I tried grant permissions as you had said, to the second user/schema also. No result! Any guess about it?
Friday 13 March 2009 at 5:29 pm
[...] not just an academic issue either: it caused this code of mine to fail to find and drop the objects it was meant to [...]