Oracle Database Discussions

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!

How to export a table with a mixed case name using EXP untility

519674Aug 14 2006 — edited Aug 14 2006

i'm trying to export a table which has a name with mixed upper and lower case. The command i'm trying is

exp USER/password TABLES=("MyTableName") FILE=ExportCNCS1.dat

and does not work.

Error:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
EXP-00011: USER.MYTABLENAME does not exist
Export terminated successfully with warnings.

----------------------------

I presume its saying the table doesnt exist because its looking for MYTABLENAME rather than MyTableName and doing this because its ignoring the double quotes. Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2006

Added on Aug 14 2006

#general-database-discussions

12 comments

1,515 views