Using 10g datapump and scheduler to copy schemas

This page has been moved to http://andrewfraserdba.com/?p=19

Advertisements

7 Responses to “Using 10g datapump and scheduler to copy schemas”

  1. Adoer Says:

    Nice script…

    How about an Export?

  2. Andrew Fraser Says:

    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.

  3. Using 10g datapump and scheduler to copy schemas « Ridvan EKER’s Weblog - Oracle Says:

    […] https://andrewfraser.wordpress.com/2007/02/01/using-10g-datapump-and-scheduler-to-copy-schemas/ Posted in Datapump. Tags: Datapump. […]

  4. Rob Prince Says:

    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…

  5. Moise Says:

    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;

  6. vishnu Says:

    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?

  7. Bug? with wrong results from all_objects in stored plsql procedures « Andrew Fraser DBA Says:

    […] not just an academic issue either: it caused this code of mine to fail to find and drop the objects it was meant to […]

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: