Query dba_objects by owner : dba_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial
- Oracle PL/SQL Tutorial
- System Tables Data Dictionary
- dba_objects
SQL>
SQL>
SQL> SELECT * FROM dba_objects WHERE owner='SYSTEM' and rownum<50;
OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
------------------------------ ---------- -------------- ------------------- --------- ---------
TIMESTAMP STATUS T G S
------------------- ------- - - -
SYSTEM
SYSCATALOG
2563 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:05 VALID N N N
SYSTEM
CATALOG
2565 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:05 VALID N N N
SYSTEM
TAB
2567 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:05 VALID N N N
SYSTEM
COL
2570 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:06 VALID N N N
SYSTEM
TABQUOTAS
2574 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:06 VALID N N N
SYSTEM
SYSFILES
2576 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:06 VALID N N N
SYSTEM
PUBLICSYN
2579 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:06 VALID N N N
SYSTEM
MVIEW$_ADV_WORKLOAD
3621 3621 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:23 VALID N N N
SYSTEM
MVIEW$_ADV_WORKLOAD_PK
3622 3622 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_WORKLOAD_IDX_01
3623 3623 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_BASETABLE
3624 3624 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_BASETABLE_IDX_01
3625 3625 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_SQLDEPEND
3626 3626 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_SQLDEPEND_IDX_01
3627 3627 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_PRETTY
3628 3628 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_PRETTY_IDX_01
3629 3629 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_TEMP
3630 3630 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_TEMP_IDX_01
3631 3631 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FILTER
3632 3632 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FILTER_PK
3633 3633 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_LOG
3634 3634 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_LOG_PK
3635 3635 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FILTERINSTANCE
3636 3636 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_LEVEL
3637 3637 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_LEVEL_PK
3638 3638 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_ROLLUP
3639 3639 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_ROLLUP_PK
3640 3640 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_AJG
3641 3641 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_AJG_PK
3642 3642 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FJG
3643 3643 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FJG_PK
3644 3644 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_GC
3645 3645 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_GC_PK
3646 3646 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_CLIQUE
3647 3647 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_CLIQUE_PK
3648 3648 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_ELIGIBLE
3649 3649 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_ELIGIBLE_PK
3650 3650 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_OUTPUT
3651 3651 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
------------------------------ ---------- -------------- ------------------- --------- ---------
TIMESTAMP STATUS T G S
------------------- ------- - - -
MVIEW$_ADV_OUTPUT_PK
3652 3652 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_EXCEPTIONS
3653 3653 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_PARAMETERS
3654 3654 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_PARAMETERS_PK
3655 3655 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_INFO
3656 3656 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_INFO_PK
3657 3657 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_JOURNAL
3658 3658 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_JOURNAL_PK
3659 3659 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_PLAN
3660 3660 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADVSEQ_GENERIC
3661 SEQUENCE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADVSEQ_ID
3662 SEQUENCE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
49 rows selected.
SQL>
SQL>