Drop the default oracle users

[castlerock]

Hi,
I want to drop the default oracle users except sys and system.Is there any .sql file in the rdbms/admin folder.

DBSNMP 17
AURORA$JIS$UTILITY$ 26
AURORA$ORB$UNAUTHENTICATED 28
SCOTT 66
OEMUSER 76
SCOTT1 79
ADMIN 74
OSE$HTTP$ADMIN 27
OUTLN 11
WKSYS 34
QS_CBADM 62
QS_OS 61
QS_ES 60
SH 56
PM 55
OE 54
HR 53
QS_WS 59
QS 58
QS_ADM 57
QS_CS 64
QS_CB 63
RMAN 65
OLAPDBA 40
CTXSYS 32
OLAPSVR 39
OLAPSYS 37
MDSYS 31
ORDPLUGINS 30
ORDSYS 29


Thanks

[adewri]

select 'drop user '||username||' cascade;' from dba_users where username not in ('SYS','SYSTEM');

or

select 'drop user '||username||' cascade;' from dba_users where username in ('give all the usernames');

HTH
Amar

[SANJAY_G]

See these docs on Metalink.

160861.1
207560.1

[castlerock]

hi,
Where can i find the oracle docs (160861.1 ,207560.1)in the metalink...I can see links like Database ,installation,performance....

Thanks,
Ramesh

[castlerock]

Hi,
Found the docs!! thanks

Thanks
Ramesh