Home » RDBMS Server » Backup & Recovery » impdp bypassing DUMPFILE (12.2 Linux)
impdp bypassing DUMPFILE [message #683724] Tue, 16 February 2021 13:42 Go to next message
evoradba
Messages: 136
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!!!!
Re: impdp bypassing DUMPFILE [message #683725 is a reply to message #683724] Tue, 16 February 2021 14:07 Go to previous messageGo to next message
Michel Cadot
Messages: 67997
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
evoradba
Messages: 136
Registered: April 2005
Location: Canada
Senior Member
thank you, it works using the database link. -:)
Re: impdp bypassing DUMPFILE [message #683727 is a reply to message #683726] Tue, 16 February 2021 14:59 Go to previous messageGo to next message
evoradba
Messages: 136
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?
Re: impdp bypassing DUMPFILE [message #683730 is a reply to message #683727] Wed, 17 February 2021 00:02 Go to previous messageGo to next message
Michel Cadot
Messages: 67997
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes, I did.

Re: impdp bypassing DUMPFILE [message #683739 is a reply to message #683730] Wed, 17 February 2021 07:53 Go to previous messageGo to next message
evoradba
Messages: 136
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!!!!
Re: impdp bypassing DUMPFILE [message #683742 is a reply to message #683739] Wed, 17 February 2021 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 67997
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: impdp bypassing DUMPFILE [message #683748 is a reply to message #683742] Wed, 17 February 2021 12:19 Go to previous messageGo to next message
evoradba
Messages: 136
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 ?
Re: impdp bypassing DUMPFILE [message #683749 is a reply to message #683748] Wed, 17 February 2021 12:51 Go to previous messageGo to next message
Michel Cadot
Messages: 67997
Registered: March 2007
Location: Nanterre, France, http://...
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.
...

Re: impdp bypassing DUMPFILE [message #683750 is a reply to message #683749] Wed, 17 February 2021 12:57 Go to previous message
evoradba
Messages: 136
Registered: April 2005
Location: Canada
Senior Member
thank you very much
Previous Topic: Restoring Oracle db to new server
Next Topic: Incremental level backup 1 without level 0
Goto Forum:
  


Current Time: Thu Oct 21 22:57:31 CDT 2021