Oracle PL/SQL Tutorial/System Tables Data Dictionary/temp all objects
Get all temporary objects from table temp_all_objects
SQL>
SQL> create global temporary table temp_all_objects
2 as
3 select * from all_objects where 1=0
4 /
SQL>
SQL>
SQL> create index temp_all_objects_idx on temp_all_objects(object_id)
2 /
SQL>
SQL>
SQL> insert into temp_all_objects
2 select * from all_objects where rownum < 51
3 /
50 rows created.
SQL>
SQL> select * from temp_all_objects;
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_ TIMESTAMP STATUS T G S
------------------------------ ------------------------------ ------------------------------ ---------- -------------- ------------------- --------- --------- ------------------- ------- - - -
SYS ICOL$ 20 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_USER1 44 44 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS CON$ 28 28 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS UNDO$ 15 15 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS C_COBJ# 29 29 CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_OBJ# 3 3 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS PROXY_ROLE_DATA$ 25 25 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_IND1 39 39 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_CDEF2 51 51 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_PROXY_ROLE_DATA$_1 26 26 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS FILE$ 17 17 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS UET$ 13 8 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_FILE#_BLOCK# 9 9 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_FILE1 41 41 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_CON1 48 48 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_OBJ3 38 38 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_TS# 7 7 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_CDEF4 53 53 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS IND$ 19 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS SEG$ 14 8 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS C_TS# 6 6 CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_FILE2 42 42 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS COL$ 21 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_TS1 43 43 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_UNDO2 35 35 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS CLU$ 5 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS PROXY_DATA$ 23 23 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_PROXY_DATA$ 24 24 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_OBJ1 36 36 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_COL2 46 46 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_OBJ2 37 37 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_CCOL1 54 54 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS TS$ 16 6 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS C_FILE#_BLOCK# 8 8 CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS C_USER# 10 10 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_UNDO1 34 34 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS BOOTSTRAP$ 56 56 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS FET$ 12 6 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_TAB1 33 33 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS CCOL$ 32 29 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS USER$ 22 10 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_CON2 49 49 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_COBJ# 30 30 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS OBJ$ 18 18 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_COL3 47 47 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS C_OBJ# 2 2 CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS TAB$ 4 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS CDEF$ 31 29 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_CDEF1 50 50 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
SYS I_ICOL1 40 40 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N
50 rows selected.
SQL>