Cannot drop user
633384May 29 2008 — edited Jun 2 2008Hello,
I have a user in my database that has an apostrophe in the username. "abc'de"
I am surprised that Oracle even allowed the user to be created in the first place.
The database is in 9i
The user does not own any objects in the database. Since a full export is failing because of this user I tried to drop and recreate the user without the apostrophe, but got the following error.
Has anyone had this situation before?
SQL> DROP USER "O'NEILR" CASCADE
DROP USER "O'NEILR" CASCADE
Error at line 2
ORA-00604: error occurred at recursive SQL level 1
ORA-00933: SQL command not properly ended
ORA-06512: at line 7
Thank you in advance for any help
Shobha