SQL*Plus: Release 10.2.0.5.0 - Production on Mon Aug 1 14:33:08 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> connect sys/qqq@dbcentr
Connected.
SQL> SELECT username
2 FROM dba_users
3 WHERE default_tablespace = 'SYSTEM' AND username NOT IN ('SYS', 'SYSTEM');
USERNAME
------------------------------
OUTLN
MGMT_VIEW
SQL> SELECT owner, 'T' typ, table_name
2 FROM dba_tables
3 WHERE tablespace_name = 'SYSTEM' AND owner NOT IN ('SYS', 'SYSTEM')
4 UNION
5 SELECT owner, 'I', index_name
6 FROM dba_indexes
7 WHERE tablespace_name = 'SYSTEM' AND owner NOT IN ('SYS', 'SYSTEM')
8 ORDER BY 1, 2, 3;
OWNER T TABLE_NAME
------------------------------ - ------------------------------
OUTLN I OL$HNT_NUM
OUTLN I OL$NAME
OUTLN I OL$NODE_OL_NAME
OUTLN I OL$SIGNATURE
OUTLN I SYS_IL0000000453C00021$$
OUTLN T OL$
OUTLN T OL$HINTS
OUTLN T OL$NODES
TOAD I SYS_C0010105
TOAD I SYS_C0010106
TOAD I SYS_C0010108
OWNER T TABLE_NAME
------------------------------ - ------------------------------
TOAD I SYS_C0010111
TOAD I SYS_C0010115
TOAD I TC_MASK_PK
TOAD I TC_OBJSTATUS_NDX
TOAD I TC_OBJSTATUS_PK
TOAD I TC_OBJSTATUS_VCS_PK
TOAD I TOAD_RES_PK
TOAD I TPSQL_IDX
TOAD I TPTBL_IDX
TOAD T PLSQL_PROFILER_DATA
TOAD T PLSQL_PROFILER_RUNS
OWNER T TABLE_NAME
------------------------------ - ------------------------------
TOAD T PLSQL_PROFILER_UNITS
TOAD T TC_CONFIG
TOAD T TC_FILEEXT
TOAD T TC_GROUP
TOAD T TC_MASK
TOAD T TC_OBJSTATUS
TOAD T TC_OBJSTATUS_VCS
TOAD T TC_TIMESTAMP
TOAD T TC_USERMAPPING
TOAD T TOAD_PLAN_SQL
TOAD T TOAD_PLAN_TABLE
OWNER T TABLE_NAME
------------------------------ - ------------------------------
TOAD T TOAD_RESTRICTIONS
34 rows selected.
SQL>