Friday, June 16, 2023

How to drop an user?

 SQL> drop user 8900308 cascade;

drop user 8900908 cascade   
*ERROR at line 1:
ORA-01935: missing user or role name

SQL> !oerr ora 1935

01935, 00000, "missing user or role name"
// *Cause:  A user or role name was expected.
// *Action: Specify a user or role name.

SQL> drop user "8900908" cascade;

User dropped.


Normal user :

Syntax:

Drop user <username> cascade;

No comments:

Post a Comment

Find the external table details along with dirctories

col OWNER for a20 col TABLE_NAME for a30 col DIRECTORY_PATH for a50 set lines 250 pages 100 select a.OWNER,TABLE_NAME,DEFAULT_DIRECTORY_NAME...