Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.

Wednesday, January 13, 2010

Check for Default Tablespace

Select username from dba_users
where (default_tablespace= 'SYSTEM' or temporary_tablespace= 'SYSTEM')
and username not in
('AURORA$JIS$UTILITY$', 'AURORA$ORB$UNAUTHENTICATED', 'DBSNMP',
'MDSYS', 'ORDPLUGINS', 'ORDSYS', 'OSE$HTTP$ADMIN', 'OUTLN', 'REPADMIN',
'SYS', 'SYSTEM','TRACESVR','MTSSYS','DIP');

No comments: