Home » RDBMS Server » Server Utilities » Oracle impdp
Oracle impdp [message #226484] Sat, 24 March 2007 01:48 Go to next message
dannywcw
Messages: 24
Registered: March 2007
Junior Member
URGENTLY need help. hi all i am not sure about this. It's about impdp. Note the data is from NONVCE_USG_WK_FCT and partition "505056"
command

impdp username/passwd@DB Directory=ci_exp_dir DUMPFILE=PRE_NONVCE_USG_WK_FCT_w50506.dmp table_exists_action=append

correct me if i'm wrong. the command will import data from the dmp file to DB.

I would like to specify that data is to import back to username.NONVCE_USG_WK_FCT table at partition "50506", how do i do that?

Re: Oracle impdp [message #226490 is a reply to message #226484] Sat, 24 March 2007 02:29 Go to previous message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You never give the target partition, Oracle knows in which partition to insert the rows, it is determined by the definition of the partitions and nothing else.

Regards
Michel
Previous Topic: SQL*LOADER - Inserting values in wrong column
Next Topic: SQL*Loader Help.
Goto Forum:
  


Current Time: Thu Dec 08 06:07:05 CST 2016

Total time taken to generate the page: 0.17253 seconds