Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export a table partition with name having a :

user5732639Jun 29 2010 — edited Jul 14 2010
Hey all, I feel so silly asking this Q but its making my brain hurt. M trying to take an export of a table (mgmt) in 'User' schema of a 10g DB with partition name: "2010-05-30 00:00". Now I know that for exporting a partition we use -- schemaname.tablename:partition_name

Tried out various options but unable to instruct the Exp utility to ignore the " : " that itself is a part of the partition name

exp user/pswd tables=user.mgmt:"2010-05-30 00:00" compress=n
exp user/pswd tables=user.mgmt:2010-05-30\ 00\:00 compress=n
exp user/pswd tables=user."mgmt:2010-05-30\ 00\:00" compress=n
exp user/pswd tables=user."mgmt:2010-05-30 00:00" compress=n

And hence I either get errors like :
. . exporting table MGMT
EXP-00051: "2010-05-30" - given partition or subpartition name is not part of "mgmt" table
EXP-00011: user.00 does not exist
EXP-00051: "00" - given partition or subpartition name is not part of "00" table

Or else:

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

I feel I m missing something basic but not able to find out. Tried out these links for clues but didnt help
http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1005947
http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1006395

I cannot even give just take an export of the entire table since there are more than 30 partitions and size of dmp will be huge :(
This post has been answered by Toni Lazarin on Jul 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2010
Added on Jun 29 2010
10 comments
5,985 views