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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Lower Case Table Name ( Help me get rid of it )

Re: Lower Case Table Name ( Help me get rid of it )

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1998/01/15
Message-ID: <34BE9706.5D05@deere.com>#1/1

TurkBear wrote:
>
> Using a conversion utility I am evaluating, I managed to create an
> Oracle ( 7.3.2.1.1, Netware ) table with lower case ( i.e. Test_1 ) -
> Now, of course, I need to get rid of it since SqlPlus will not work
> with it ( Table not Found when I try a Select * from Test_1 and
> 'Object does not exist' when I try a desc test_1 ) - How do I get rid
> of this odd little table?
>
> PS I have learned to specify the Table name in Upper case only when
> using this conversion tool, so I won't have this problem again.
>
> Thanks for any hints :
> Post here or Email to john.greco_at_dot.state.mn.us

rename "MixedCase" to "MIXEDCASE"; Received on Thu Jan 15 1998 - 00:00:00 CST

Original text of this message

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