Home » RDBMS Server » Server Utilities » Oracle impdp
Oracle impdp [message #226484] Sat, 24 March 2007 01:48 Go to next message
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"

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: 65082
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.

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

Current Time: Fri Jul 21 10:17:34 CDT 2017

Total time taken to generate the page: 0.04602 seconds