Home » RDBMS Server » Server Utilities » Too many errors while importing full db export (oracle server 11.2)
Too many errors while importing full db export [message #582807] Mon, 22 April 2013 13:56 Go to next message
samiraly
Messages: 57
Registered: June 2009
Member

Hello

i am trying to import full db export using datapump , i have too many errors for objects that is already exist .
attached is the log file .
thae steps i did so far

1- created the database .
2- imported the full db backup using
impdp system/xxxxxxx full=yes directory=datapump  dumpfile=palbe_full_20130322.dp log=palbe_full_22042013.log


Thank you for help .
Re: Too many errors while importing full db export [message #582808 is a reply to message #582807] Mon, 22 April 2013 14:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only import the application accounts.

Regards
Michel
Re: Too many errors while importing full db export [message #582865 is a reply to message #582808] Tue, 23 April 2013 03:01 Go to previous messageGo to next message
nlnkapardi
Messages: 26
Registered: April 2013
Location: India
Junior Member

Hello Sami

I can that drop the Existing imported synonyms,table and then Re-import again. I hope this helps

Regards
Kapardi
Re: Too many errors while importing full db export [message #582877 is a reply to message #582865] Tue, 23 April 2013 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a silly advice (again).
You suggest to drop Oracle synonyms and objects!?

Regards
Michel
Re: Too many errors while importing full db export [message #582878 is a reply to message #582877] Tue, 23 April 2013 03:28 Go to previous messageGo to next message
nlnkapardi
Messages: 26
Registered: April 2013
Location: India
Junior Member

ya
Re: Too many errors while importing full db export [message #582880 is a reply to message #582878] Tue, 23 April 2013 03:31 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you assume that Oracle will still support the database where you delete its objects?
Please answer more seriously and avoid to send people to hell.

Regards
Michel
Previous Topic: import on dblink
Next Topic: Error while exporting
Goto Forum:
  


Current Time: Thu Mar 28 14:03:06 CDT 2024