OraFAQ Forum: Server Utilities » impdp bypassing DUMPFILE

Home » RDBMS Server » Server Utilities » impdp bypassing DUMPFILE (12.2 Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

impdp bypassing DUMPFILE [message #683724]

Tue, 16 February 2021 13:42

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

Hello
I don't know if its possible, but I'm looking the fastest way of cloning an oracle schema using datapump. I'm trying to by pass the DUMPFILE as both schemas reside on the same oracle instance, therefore I don't need a database link?

impdp system/passs directory=BACKUP DUMPFILE=test.dmp logfile=logfile .log schemas=1,2 exclude=statistics

is there a way for not using the DUMPFILE and go straight from schema 1 into schema 2?
thank you!!!!

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683725 is a reply to message #683724]

Tue, 16 February 2021 14:07

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must use a database link even in the same database!
It is a restriction of Data Pump engine.
I opened an enhancement SR in version 10.2 but still no answer.

You can also use McDP COPY command.

[Updated on: Tue, 16 February 2021 14:10]

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683726 is a reply to message #683725]

Tue, 16 February 2021 14:52

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

thank you, it works using the database link. -:)

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683727 is a reply to message #683726]

Tue, 16 February 2021 14:59

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

Quick question, have you ever used a SP to call the data pump from a schema into another?

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683730 is a reply to message #683727]

Wed, 17 February 2021 00:02

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, I did.

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683739 is a reply to message #683730]

Wed, 17 February 2021 07:53

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

what is better to quick copy data from one schema into another on the same database instance
the db link or the SP using the data pump?
thank you!!!!

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683742 is a reply to message #683739]

Wed, 17 February 2021 09:57

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The SP also use a db link unless you meant a SP that doesn't use the Data Pump engine.

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683748 is a reply to message #683742]

Wed, 17 February 2021 12:19

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

I know it uses the link, sorry my question is
what is better SP or no SP. are there any advantages using SP to call the datapump job ?

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683749 is a reply to message #683748]

Wed, 17 February 2021 12:51

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can package exactly what you want in your custom SP (including some checks to prevent from a user to do it or to do it outside a desired period or outside the server or a specific network...).
You can easily use Oracle scheduler to plan your schema copy.
You can then allow some accounts to do the copy without giving them DATAPUMP_EXP_FULL_DATABASE or DATAPUMP_IMP_FULL_DATABASE role.
...

Report message to a moderator

Re: impdp bypassing DUMPFILE [message #683750 is a reply to message #683749]

Wed, 17 February 2021 12:57

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

thank you very much

Report message to a moderator

Previous Topic:	Unable to load CSV file to Oracle Table
Next Topic:	Import datapump issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 15:48:10 CST 2025