| Oracle impdp [message #226484] |
Sat, 24 March 2007 01:48  |
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  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
