OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » impdp (os 10.2.0.1)

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

impdp [message #414648]

Thu, 23 July 2009 01:50

tcsdba
Messages: 6
Registered: July 2009

Junior Member

Hi
I imported data using impdp,Now there are no primary keys on the tables imported. Please suggest what should be done.

Report message to a moderator

Re: impdp [message #414668 is a reply to message #414648]

Thu, 23 July 2009 02:36

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

Senior Member
Account Moderator

Create them?

Regards
Michel

Report message to a moderator

Re: impdp [message #414677 is a reply to message #414668]

Thu, 23 July 2009 03:14

tcsdba
Messages: 6
Registered: July 2009

Junior Member

Hi
Thanks for your reply.I used the the following command:
impdp system/sys123@bpsd directory=AUTO_BACKUP_DIR dumpfile=BPSD_PRD_SAT.DMP

but as I forgot to include the log file so I terminated import in between and restarted import using the command:

impdp system/sys123@bpsd directory=AUTO_BACKUP_DIR dumpfile=BPSD_PRD_SAT.DMP TABLE_EXIST_ACTION=REPLACE logfile=logimp2.log

so is there any fault on my side due to which primary keys were not generated for tables imported????? Shocked

[Updated on: Thu, 23 July 2009 03:21]

Report message to a moderator

Re: impdp [message #414685 is a reply to message #414677]

Thu, 23 July 2009 03:49

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

Senior Member
Account Moderator

It seems they didn't exist in the dump file.

Regards
Michel

Report message to a moderator

Re: impdp [message #415357 is a reply to message #414685]

Mon, 27 July 2009 06:32

tcsdba
Messages: 6
Registered: July 2009

Junior Member

Hi
Thanks for your support.
I finally got the workaround Laughing

At client site ,they had some batch process that shuts down the database automatically at 9:45am everyday.So database got shut down before completion of import. Confused

due to this tables got imported but constraints couldnt.
workaround for this: clean the database(or just recreate it) and start the import again.(KEEP IN MIND TO DISABLE ALL THE BATCH PROCESSES THAT MAY CAUSE PROBLEM WITH IMPORT PROCESS)

Regards
Jyoti

Report message to a moderator

Re: impdp [message #415365 is a reply to message #415357]

Mon, 27 July 2009 07:19

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Congragelation to find solution for your problem

Thanks

Report message to a moderator

Previous Topic:	Gather Statistics
Next Topic:	topspeed database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 10:59:30 CST 2024