Home » RDBMS Server » Server Utilities » impdp (Oracle 11.2.0.3)
impdp [message #609609] Mon, 10 March 2014 05:45 Go to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Hi,

I have database which got many schemas, we are tryting to setup new database on different server, so we are using impdp/expdp.

I would like to know how can I drop all the objects created by impdp on newserver incase if it fails in between. I read I can use table_exists_action but it will consider only tables,
I want to clean all things created by impdp which is failed in between like schemas, sequences etc.. Basically i wanted to try the impdp manier times

Thank you in advance.

Regards,
Pointers
Re: impdp [message #609613 is a reply to message #609609] Mon, 10 March 2014 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

drop user ... cascade;

Re: impdp [message #609616 is a reply to message #609613] Mon, 10 March 2014 07:07 Go to previous message
pointers
Messages: 451
Registered: May 2008
Senior Member
Thank you Micheal.

Regards,
Pointers
Previous Topic: EXTERNAL TABLE
Next Topic: impdp
Goto Forum:
  


Current Time: Thu Mar 28 07:54:26 CDT 2024