| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export of Tables with lower case characters in the name.
--=_ECB7B3B4.C6A7CA4C
Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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):=20
Product (i.e. SQL*Loader, Import, etc.): Export
Product Version:=20
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:=20
create table "A" ("A" number);=20
create table "a" ("a" number);=20
I tried to export these tables using the following parfile:=20
userid=3Dtest/test=20
file=3Dtest=20
direct=3Dy=20
tables=3D("a","A")=20
and got the next message:=20
About to export specified tables via Direct Path ...=20 . . exporting table A 0 rows exported=20 Export terminated successfully without warnings.=20
Exp does not discrimate table's name in lowercase and uppercase.=20
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?=20
---------------------------------------------------------------------------=
From: Rick Bakker 14-Nov-00 12:54=20
Subject: Re : Exp does not discrimate table's name in lowercase and =
uppercase=20
This seems to work:=20
tables=3D(\"a\","A")=20
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!=20
---------------------------------------------------------------------------=
From: Oracle, Reem Munakash 15-Nov-00 17:03=20 Subject: Re : Exp does not discrimate table's name in lowercase and = uppercase=20
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.=20
In my test, I used the following parfile:=20
tables=3D(\"a\", A)=20
This worked:=20
Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production=20=
With the Partitioning option=20
JServer Release 8.1.6.2.0 - Production=20
Export done in US7ASCII character set and US7ASCII NCHAR character set=20
About to export specified tables via Conventional Path ...=20 . . exporting table a 0 rows exported=20 . . exporting table A 0 rows exported=20 Export terminated successfully without warnings.=20
Reem Munakash=20
Electronic Support=20
---------------------------------------------------------------------------=
From: Juan Angel Alcantara Garcia 15-Nov-00 20:57=20 Subject: Re : Exp does not discrimate table's name in lowercase and = uppercase=20
Thanks a lot guys...=20
It is working fine...=20
Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438
--=_ECB7B3B4.C6A7CA4C
Content-Type: text/plain
Content-Disposition: attachment; filename="TEXT.htm"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY style="FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">
<DIV>Lee,</DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>RDBMS Version: 8.1.5<BR>Operating System and Version: Solaris 2.6<BR>Error
Number (if applicable): <BR>Product (i.e. SQL*Loader, Import, etc.):
Export<BR>Product Version: </DIV>
<DIV> </DIV>
<DIV>Exp does not discrimate table's name in lowercase and uppercase</DIV>
<DIV> </DIV>
<DIV>I have in my TEST schema two tables named: "A" and "a", they were created
by TEST user as follow: </DIV>
<DIV> </DIV>
<DIV>create table "A" ("A" number); <BR>create table "a" ("a" number); </DIV>
<DIV> </DIV>
<DIV>I tried to export these tables using the following parfile: </DIV>
<DIV> </DIV>
<DIV>userid=test/test <BR>file=test <BR>direct=y <BR>tables=("a","A") </DIV>
<DIV> </DIV>
<DIV>and got the next message: </DIV>
<DIV> </DIV>
<DIV>About to export specified tables via Direct Path ... <BR>. . exporting
table A 0 rows exported <BR>Export terminated successfully without warnings.
</DIV>
<DIV> </DIV>
<DIV>Exp does not discrimate table's name in lowercase and uppercase. </DIV>
<DIV> </DIV>
<DIV>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? </DIV>
<DIV> </DIV>
<DIV><BR>--------------------------------------------------------------------------------</DIV>
<DIV> </DIV>
<DIV>From: Rick Bakker 14-Nov-00 12:54 <BR>Subject: Re : Exp does not discrimate
table's name in lowercase and uppercase </DIV>
<DIV> </DIV>
<DIV><BR>This seems to work: </DIV>
<DIV> </DIV>
<DIV>tables=(\"a\","A") </DIV>
<DIV> </DIV>
<DIV>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! </DIV>
<DIV> </DIV>
<DIV><BR>--------------------------------------------------------------------------------</DIV>
<DIV> </DIV>
<DIV>From: Oracle, Reem Munakash 15-Nov-00 17:03 <BR>Subject: Re : Exp does not
discrimate table's name in lowercase and uppercase </DIV>
<DIV> </DIV>
<DIV><BR>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. </DIV>
<DIV> </DIV>
<DIV>In my test, I used the following parfile: </DIV>
<DIV> </DIV>
<DIV>tables=(\"a\", A) </DIV>
<DIV> </DIV>
<DIV>This worked: </DIV>
<DIV> </DIV>
<DIV>Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
<BR>With the Partitioning option <BR>JServer Release 8.1.6.2.0 - Production
<BR>Export done in US7ASCII character set and US7ASCII NCHAR character set
</DIV>
<DIV> </DIV>
<DIV>About to export specified tables via Conventional Path ... <BR>. .
exporting table a 0 rows exported <BR>. . exporting table A 0 rows exported
<BR>Export terminated successfully without warnings. </DIV>
<DIV> </DIV>
<DIV>Reem Munakash <BR>Electronic Support </DIV>
<DIV> </DIV>
<DIV><BR>--------------------------------------------------------------------------------</DIV>
<DIV> </DIV>
<DIV>From: Juan Angel Alcantara Garcia 15-Nov-00 20:57 <BR>Subject: Re : Exp
does not discrimate table's name in lowercase and uppercase </DIV>
<DIV> </DIV>
<DIV>Thanks a lot guys... </DIV>
Received on Fri Jan 19 2001 - 09:40:32 CST
 |
 |