Export a table partition with name having a :
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 :(