Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Dropping a User with single-quote in the username
One of the developers at my site was using a tool to create database
objects, including tables, users, etc. One of the users ended up with
a single-quote as part of the username. i.e. Claxton,John. I have
duplicated this with
SQL> Create User "Claxton,John";
However, when I try and drop the user
SQL> Drop User "Claxton,John";
I get:
drop user "Claxton'John"
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-00933: SQL command not properly ended ORA-06512: at line 7