Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Drop a user with special characters

User_KYWTCOct 13 2020

HI Team,
How to drop a user which was created with special characters. I tried dropping by enclosing double quotes, but it did not worked.
select username from dba_users where username like '%DUM%';
USERNAME
--------------------------------------------------------------------------------
RES_DUM_S02?

SQL> drop user "RES_DUM_S02?" cascade;
drop user "RES_DUM_S02?" cascade
*
ERROR at line 1:
ORA-01918: user 'RES_DUM_S02?' does not exist

Comments
Post Details
Added on Oct 13 2020
6 comments
1,768 views