Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export of Tables with lower case characters in the name.

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

From: Trivedi, Hitarth <HTrivedi_at_telergy.net>
Date: Thu, 18 Jan 2001 13:55:57 -0500
Message-Id: <10745.127045@fatcity.com> 





This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.



------_=_NextPart_000_01C08180.4AC47580


Content-Type: text/plain;


        charset="iso-8859-1"



Here is the shell script!! Well, I couldn't resist writing the script.



Hitarth


Oracle Certified DBA (7.3)


Sun Certified Java 2 Programmer


MCSE, MCP+I



315-362-1162


trivedh_at_telergy.net



-----Original Message-----


From: David Barbour [mailto:dbarbour_at_connectsouth.com]
Sent: Thursday, January 18, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Export of Tables with lower case characters in the name.




Lee,



Can you use a shell script for the export which includes a SQL query 'Select
upper(table-name) from user tables' to create a list?



David A. Barbour


Oracle DBA - ConnectSouth


512-681-9438


dbarbour_at_connectsouth.com




-----Original Message-----


Sent: Thursday, January 18, 2001 9:01 AM
To: Multiple recipients of list ORACLE-L




Yes, it is UNIX and this doesn't work either, thanks for the response.



> Lee Robertson

> Acxiom

> Tel: 	0191 525 7344

> Fax: 	0191 525 7007

> Email: lerobe_at_acxiom.co.uk

> 





-----Original Message-----


Sent: 18 January 2001 14:32


To: Multiple recipients of list ORACLE-L




Is this unix?  Unless you escape the quote (") character
with a backslash (\), it get interperted by the shell.



Try 



exp .... tables=(\"tab1\",\"tab2\"...,\"tabn\")





Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
Those that do not archive the past are


condemned to retype it.




> -----Original Message-----

> From: lerobe - Lee Robertson [mailto:LEROBE_at_acxiom.co.uk]

> Sent: Thursday, January 18, 2001 9:07 AM

> To: Multiple recipients of list ORACLE-L

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

> 

> 

> Yup, tried that and also putting the table names in a par 

> file with the

> quotes around them. Still no luck. Thanks for the response anyway.

> 

> Regards

> 

> Lee

> 

> 

> -----Original Message-----

> Sent: 18 January 2001 12:47

> To: Multiple recipients of list ORACLE-L

> 

> 

> I have never tried it but you can try

> 

> exp .... tables=("tab1","tab2"...,"tabn")

> 

> Rick

> 

> > -----Original Message-----

> > From:	lerobe - Lee Robertson [SMTP:LEROBE_at_acxiom.co.uk]

> > Sent:	Thursday, January 18, 2001 5:46 AM

> > To:	Multiple recipients of list ORACLE-L

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

> > 

> > All,

> >  

> > One of the applications here has hard coded tablenames of 

> mixed case. How

> > do

> > I get the export command to recognise the mixed case 

> tablenames. At the

> > moment it is coming back with the tablename (in upper case) not

> > recognised. 

> >  

> > TIA 


> >  

> > Lee

> >  

> > 

> > 

> > The information contained in this communication is

> > confidential, is intended only for the use of the recipient

> > named above, and may be legally privileged. If the reader 

> > of this message is not the intended recipient, you are

> > hereby notified that any dissemination, distribution or

> > copying of this communication is strictly prohibited.  

> > If you have received this communication in error, please 

> > re-send this communication to the sender and delete the 

> > original message or any copy of it from your computer

> > system.

> > -- 

> > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > -- 

> > Author: lerobe - Lee Robertson

> >   INET: LEROBE_at_acxiom.co.uk

> > 

> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > San Diego, California        -- Public Internet access / 

> Mailing Lists

> > --------------------------------------------------------------------

> > To REMOVE yourself from this mailing list, send an E-Mail message

> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > the message BODY, include a line containing: UNSUB ORACLE-L

> > (or the name of mailing list you want to be removed from).  You may

> > also send the HELP command for other information (like subscribing).

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> -- 

> Author: Cale, Rick T (Richard)

>   INET: RICHARD.T.CALE_at_saic.com

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> -- 

> Author: lerobe - Lee Robertson

>   INET: LEROBE_at_acxiom.co.uk

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).

> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adams, Matthew (GEA, 088130)
  INET: MATT.ADAMS_at_APPL.GE.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: lerobe - Lee Robertson
  INET: LEROBE_at_acxiom.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Barbour
  INET: dbarbour_at_connectsouth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


------_=_NextPart_000_01C08180.4AC47580
Content-Type: application/octet-stream;
	name="tables.sh"
Content-Disposition: attachment;
	filename="tables.sh"

echo "tables=" > tablist
sqlplus $SYSPASS @tables.sql | grep "999" | cut -f1 >> tablist
exp parfile=tablist

------_=_NextPart_000_01C08180.4AC47580
Content-Type: application/octet-stream;


Received on Thu Jan 18 2001 - 12:55:57 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US