RE: Help!Help!!Help!!!

From: <gregory.t.norris_at_mail.sprint.com>
Date: Tue, 14 Nov 2000 12:31:32 -0600
Message-Id: <10680.122021@fatcity.com>

--openmail-part-1595647b-00000001

Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline

;Creation-Date="Tue, 14 Nov 2000 12:31:31 -0600" Content-Transfer-Encoding: 7bit

Make sure that SQLCASE is set to MIXED. It might be getting set to UPPER in glogin.sql, or some such...

     SQL> set sqlcase mixed
     SQL> select 'test' from dual;

     test

     SQL> set sqlcase upper
     SQL> select 'test' from dual;

     TEST

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

From: raj.gopalan [mailto:raj.gopalan_at_netdecisions.co.uk] Sent: Tuesday, November 14, 2000 10:32 AM To: ORACLE-L
Subject: Help!Help!!Help!!!

I have a script for Hot backup. This script generates a .sql file, which will be eventually executed to take a hot backup.

The problem is that, in one of the server the .sql file generated has all
the statements in capital letters. This is causing an issue when it tries to
execute the unix cp comment.

Any suggestion?

TIA
Raj
--

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

Author: Raj Gopalan
INET: raj.gopalan_at_netdecisions.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). Received on Tue Nov 14 2000 - 12:31:32 CST