[Translated from mos] When par file is not used, export or import tables with case-insensitive table names, mospar

[Translated from mos] When par file is not used, export or import tables with case-insensitive table names, mospar
Export or import tables with case-insensitive table names without using the par file

Reference Original:
How to Export or Import Case Sensitive Tables Without Using a Par File (docid 1622134.1) 1

Applicable:
Oracle Database-Enterprise Edition-Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.


Objectives:

Export or import tables with case-insensitive table names without using the par file

Solution:

An expdp with par file can be used for tables with case-sensitive table names. However, for exp from the command line, the double quotation marks must be escaped (escaped)

The following example shows how to use a table with a case-insensitive table name.


Create a test table:
Connect/as sysdba
Create use test identified by test;
Grant connect, resource, dba to test;
Create table test. "TEst" as select * from dba_users;


Run the following command to export the table:
Expdp test/test directory = DATA_PUMP_DIR dumpfile = a1.dmp tables = TEST. "TEst"


Expdp test/test directory = DATA_PUMP_DIR dumpfile = a1.dmp tables = TEST. "TEst"

Export: Release 11.2.0.2.0-Production on Sat Feb 8 00:17:17 2014

Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "TEST". "SYS_EXPORT_TABLE_01": test/********* directory = DATA_PUMP_DIR dumpfile = a1.dmp tables = TEST. TEst
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
A ORA-39166: Object TEST. TEST was not found. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>> it says table not found.
ORA-31655: no data or metadata objects selected for job
Job "TEST". "SYS_EXPORT_TABLE_01" completed with 2 error (s) at 00:19:05


In order to successfully export the table from the export, You must escape double quotation marks.
Expdp test/test directory = DATA_PUMP_DIR dumpfile = a. dmp tables = test. \ "TEst \"


Export: Release 11.2.0.2.0-Production on Sat Feb 8 00:04:13 2014

Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "TEST". "SYS_EXPORT_TABLE_01": test/********* directory = DATA_PUMP_DIR dumpfile = a. dmp tables = AMIT. "TEst"
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE
... Exported "TEST". "TEst" 16.10 KB 51 rows
Master table "TEST". "SYS_EXPORT_TABLE_01" successfully loaded/unloaded
**************************************** **************************************
 
/Home/oracle/app/oracle/admin/orcl/dpdump/a. dmp
Job "TEST". "SYS_EXPORT_TABLE_01" successfully completed at 00:05:35