Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange user account problem
10:31:31 ::SQL> create user song identified by "song";
User created.
10:33:18 ::SQL> drop user song;
User dropped.
10:33:24 ::SQL> create user "song" identified by "song";
User created.
10:33:36 ::SQL> drop user song;
drop user song
*
ERROR at line 1:
ORA-01918: user 'SONG' does not exist
10:33:43 ::SQL> drop user "song";
User dropped.
HTH, Tod
"Rahul Tikekar" <TikekarR_at_sou.edu> wrote in message
news: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:35:16 CDT