OraFAQ Forum: Server Utilities » Too many errors while importing full db export

Home » RDBMS Server » Server Utilities » Too many errors while importing full db export (oracle server 11.2)

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

Too many errors while importing full db export [message #582807]

Mon, 22 April 2013 13:56

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 .

Attachment: palbe_full_22042013.log
(Size: 805.83KB, Downloaded 2214 times)

Report message to a moderator

Re: Too many errors while importing full db export [message #582808 is a reply to message #582807]

Mon, 22 April 2013 14:08

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

Senior Member
Account Moderator

Only import the application accounts.

Regards
Michel

Report message to a moderator

Re: Too many errors while importing full db export [message #582865 is a reply to message #582808]

Tue, 23 April 2013 03:01

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

Report message to a moderator

Re: Too many errors while importing full db export [message #582877 is a reply to message #582865]

Tue, 23 April 2013 03:27

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

Senior Member
Account Moderator

This is a silly advice (again).
You suggest to drop Oracle synonyms and objects!?

Regards
Michel

Report message to a moderator

Re: Too many errors while importing full db export [message #582878 is a reply to message #582877]

Tue, 23 April 2013 03:28

nlnkapardi
Messages: 26
Registered: April 2013
Location: India

Junior Member

Report message to a moderator

Re: Too many errors while importing full db export [message #582880 is a reply to message #582878]

Tue, 23 April 2013 03:31

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

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

Report message to a moderator

Previous Topic:	import on dblink
Next Topic:	Error while exporting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:46:16 CST 2025