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

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange user account problem

Re: Strange user account problem

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Thu, 3 Oct 2002 19:34:30 +0200
Message-ID: <anhv2i$4ho$1@news1.xs4all.nl>


drop user "song";

Rahul Tikekar <TikekarR_at_sou.edu> schreef in berichtnieuws anhsd5$r3v$1_at_news.orst.edu...
| Using Oracle 8.1.5.
|
| Somehow I created a user 'song' (lowercase). Now I'd
| like to delete this user. So I say
| drop user song;
|
| Oracle replies:
| ORA-01918: user 'SONG' does not exist
|
| So Oracle is converting the user name to upper case and
| looking for SONG. But a user with the lower case song does
| exits. How do I tell Oracle to look for the lower case song
| and not SONG?
|
| Thank you.
|
| - Rahul Tikekar
|
|
|
Received on Thu Oct 03 2002 - 12:34:30 CDT

Original text of this message

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