RE: Export of Tables with lower case characters in the name.

Oooh - I didn't think about having two tables with the same name differentiated only by upper and lower case. That would be a bad thing that shouldn't be allowed to happen! Is that part of your problem Lee? Otherwise, at first glance, Hitarth's script looks like it would work.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Michael Ray [mailto:Michael.Ray_at_trw.com] Sent: Friday, January 19, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Export of Tables with lower case characters in the name.

Lee,
I don't know if you tried this one yet, but since I've seen you strike out several times now, I went over to Metalink and found this. Hopefully it will help you out.

RDBMS Version: 8.1.5
Operating System and Version: Solaris 2.6 Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Export Product Version:

Exp does not discrimate table's name in lowercase and uppercase

I have in my TEST schema two tables named: "A" and "a", they were created by TEST user as follow:

create table "A" ("A" number);
create table "a" ("a" number);

I tried to export these tables using the following parfile:

userid=test/test
file=test
direct=y
tables=("a","A")

and got the next message:

About to export specified tables via Direct Path ...
. . exporting table A 0 rows exported

Export terminated successfully without warnings.

Exp does not discrimate table's name in lowercase and uppercase.

I also tried to change doble quote for single quote but I didn't have succeed. Does somebody know how to export them using tables parameter?

uppercase

This seems to work:

tables=(\"a\","A")

Unfortunately, this only seems to do the trick when using a parfile, if I do it at the prompt the backslashes will only discriminate in 7.3.4 and not 8.1.6!

uppercase

Rick is right, and it does work in 8.1.6. The double quotes are only needed around the lower case tablename. By default we will look for the tablename in upper case.

In my test, I used the following parfile:

tables=(\"a\", A)

This worked:

Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option
JServer Release 8.1.6.2.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table a 0 rows exported
. . exporting table A 0 rows exported

Export terminated successfully without warnings.

Reem Munakash
Electronic Support

uppercase

Thanks a lot guys... Received on Fri Jan 19 2001 - 10:30:45 CST