Oracle impdp [message #226484] |
Sat, 24 March 2007 01:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|