To get a listing of all tables that you own : USER_TABLES « System Tables Views « Oracle PL / SQL






To get a listing of all tables that you own

 


SQL>
SQL> -- To get a listing of all tables that you own
SQL>
SQL> SELECT table_name FROM USER_TABLES;

TABLE_NAME
------------------------------
CON$
UNDO$
CDEF$
CCOL$
PROXY_ROLE_DATA$
FILE$
FET$
TS$
PROXY_DATA$
SEG$
UET$

TABLE_NAME
------------------------------
TSQ$
USER$
BOOTSTRAP$
OBJ$
ICOLDEP$
LIBRARY$
OPQTYPE$
REFCON$
NTAB$
TYPE_MISC$
VIEWTRCOL$

TABLE_NAME
------------------------------
ATTRCOL$
SUBCOLTYPE$
COLTYPE$
LOB$
TAB$
CLU$
COL$
IND$
ICOL$
OBJAUTH$
UGROUP$

TABLE_NAME
------------------------------
SYN$
VIEW$
TYPED_VIEW$
SUPEROBJ$
SEQ$
PROCEDURE$
PROCEDUREINFO$
ARGUMENT$
SOURCE$
IDL_UB1$
IDL_CHAR$

TABLE_NAME
------------------------------
IDL_UB2$
IDL_SB4$
DIR$
JAVAOBJ$
ERROR$
SETTINGS$
TRIGGER$
TRIGGERCOL$
TRIGGERJAVAF$
TRIGGERJAVAS$
TRIGGERJAVAC$

TABLE_NAME
------------------------------
TRIGGERJAVAM$
SYSAUTH$
OBJPRIV$
DEFROLE$
PROFILE$
PROFNAME$
DEPENDENCY$
ACCESS$
LINK$
TRUSTED_LIST$
PROPS$

TABLE_NAME
------------------------------
COM$
RESOURCE_COST$
INCEXP
INCVID
INCFIL
_default_auditing_options_
AUDIT$
PENDING_TRANS$
PENDING_SESSIONS$
PENDING_SUB_SESSIONS$
SUMPARTLOG$

TABLE_NAME
------------------------------
SUMDELTA$
SNAP_LOGDEP$
SNAP_LOADERTIME$
SLOG$
MLOG$
ID_GENS$
OID$
RESULT$
PARAMETER$
METHOD$
ATTRIBUTE$

TABLE_NAME
------------------------------
COLLECTION$
TYPE$
TYPEHIERARCHY$
VIEWCON$
SNAP$
SNAP_REFTIME$
MLOG_REFCOL$
SNAP_REFOP$
SNAP_COLMAP$
SNAP_OBJCOL$
REG_SNAP$

TABLE_NAME
------------------------------
SNAP_SITE$
JOB$
RGCHILD$
RGROUP$
DUC$
HISTGRM$
HIST_HEAD$
DUAL
PARTOBJ$
PARTCOL$
TABPART$

TABLE_NAME
------------------------------
INDPART$
SUBPARTCOL$
TABSUBPART$
INDSUBPART$
TABCOMPART$
INDCOMPART$
PARTLOB$
LOBFRAG$
LOBCOMPPART$
DEFSUBPART$
DEFSUBPARTLOB$

TABLE_NAME
------------------------------
SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGE_MAP
STMT_AUDIT_OPTION_MAP
RESOURCE_MAP
USER_ASTATUS_MAP
EXPACT$
NOEXP$
PROCEDUREJAVA$
PROCEDUREC$
PROCEDUREPLSQL$
KOPM$

TABLE_NAME
------------------------------
VTABLE$
USER_HISTORY$
MIGRATE$
OPERATOR$
OPBINDING$
OPANCILLARY$
OPARG$
INDTYPES$
INDOP$
INDARRAYTYPE$
SECOBJ$

TABLE_NAME
------------------------------
ASSOCIATION$
USTATS$
JAVASNM$
SUM$
SUMDETAIL$
SUMINLINE$
SUMKEY$
SUMAGG$
SUMJOIN$
SUMDEP$
SUMPRED$

TABLE_NAME
------------------------------
SUMQB$
DIM$
DIMLEVEL$
DIMLEVELKEY$
DIMJOINKEY$
DIMATTR$
HIER$
HIERLEVEL$
RLS$
RLS_SC$
RLS_GRP$

TABLE_NAME
------------------------------
RLS_CTX$
CONTEXT$
RULESET$
INDPART_PARAM$
SQL$
SQL$TEXT
SQLPROF$
SQLPROF$DESC
SQLPROF$ATTR
EXPPKGOBJ$
EXPPKGACT$

TABLE_NAME
------------------------------
EXPDEPOBJ$
EXPDEPACT$
MON_MODS$
MON_MODS_ALL$
METAVIEW$
METAFILTER$
METAXSL$
METAXSLPARAM$
METASTYLESHEET
METASCRIPT$
METASCRIPTFILTER$

TABLE_NAME
------------------------------
METANAMETRANS$
METAPATHMAP$
EXTERNAL_TAB$
EXTERNAL_LOCATION$
SQL_VERSION$
COL_USAGE$
CDC_SYSTEM$
CDC_CHANGE_SOURCES$
CDC_CHANGE_SETS$
CDC_CHANGE_TABLES$
CDC_SUBSCRIBERS$

TABLE_NAME
------------------------------
CDC_SUBSCRIBED_TABLES$
CDC_SUBSCRIBED_COLUMNS$
CDC_CHANGE_COLUMNS$
CDC_PROPAGATIONS$
CDC_PROPAGATED_SETS$
JIJOIN$
JIREFRESHSQL$
LOG$
APPROLE$
FGA$
FGACOL$

TABLE_NAME
------------------------------
AUD$
FGA_LOG$
OBJECT_USAGE
AUX_STATS$
SMON_SCN_TIME
AW$
PS$
AW_OBJ$
AW_PROP$
MAP_FILE$
MAP_FILE_EXTENT$

TABLE_NAME
------------------------------
MAP_SUBELEMENT$
MAP_ELEMENT$
MAP_EXTELEMENT$
MAP_COMPLIST$
STREAMS$_CAPTURE_PROCESS
STREAMS$_APPLY_PROCESS
STREAMS$_PROPAGATION_PROCESS
STREAMS$_PROCESS_PARAMS
STREAMS$_EXTRA_ATTRS
STREAMS$_PREPARE_OBJECT
STREAMS$_PREPARE_DDL

TABLE_NAME
------------------------------
STREAMS$_APPLY_MILESTONE
STREAMS$_APPLY_PROGRESS
STREAMS$_KEY_COLUMNS
STREAMS$_DEF_PROC
STREAMS$_RULES
APPLY$_SOURCE_OBJ
APPLY$_SOURCE_SCHEMA
APPLY$_VIRTUAL_OBJ_CONS
APPLY$_CONSTRAINT_COLUMNS
APPLY$_DEST_OBJ
APPLY$_DEST_OBJ_CMAP

TABLE_NAME
------------------------------
APPLY$_DEST_OBJ_OPS
APPLY$_ERROR
APPLY$_ERROR_TXN
APPLY$_ERROR_HANDLER
APPLY$_CONF_HDLR_COLUMNS
STREAMS$_DEST_OBJS
STREAMS$_DEST_OBJ_COLS
STREAMS$_PRIVILEGED_USER
STREAMS$_MESSAGE_RULES
WARNING_SETTINGS$
STREAMS$_MESSAGE_CONSUMERS

TABLE_NAME
------------------------------
STREAMS$_APPLY_SPILL_TXN
STREAMS$_APPLY_SPILL_TXN_LIST
FGR$_FILE_GROUPS
FGR$_FILE_GROUP_VERSIONS
FGR$_FILE_GROUP_EXPORT_INFO
FGR$_FILE_GROUP_FILES
FGR$_TABLESPACE_INFO
FGR$_TABLE_INFO
RECYCLEBIN$
FIXED_OBJ$
TAB_STATS$

TABLE_NAME
------------------------------
IND_STATS$
PROXY_INFO$
PROXY_ROLE_INFO$
REDEF$
REDEF_OBJECT$
REDEF_DEP_ERROR$
NCOMP_DLL$
IND_ONLINE$
SERVICE$
EXPIMP_TTS_CT$
TSM_SRC$

TABLE_NAME
------------------------------
TSM_DST$
DIR$MIGRATE_OPERATIONS
DIR$SERVICE_OPERATIONS
DIR$ESCALATE_OPERATIONS
DIR$QUIESCE_OPERATIONS
DIR$INSTANCE_ACTIONS
DIR$RESONATE_OPERATIONS
DIR$ALERT_HISTORY
DIR$REASON_STRINGS
DIR$DATABASE_ATTRIBUTES
DIR$VICTIM_POLICY

TABLE_NAME
------------------------------
DIR$NODE_ATTRIBUTES
DIR$SERVICE_ATTRIBUTES
CACHE_STATS_1$
CACHE_STATS_0$
STATS_TARGET$
RESOURCE_PLAN$
RESOURCE_CONSUMER_GROUP$
RESOURCE_PLAN_DIRECTIVE$
RESOURCE_GROUP_MAPPING$
RESOURCE_MAPPING_PRIORITY$
ENC$

TABLE_NAME
------------------------------
RECO_SCRIPT$
RECO_SCRIPT_PARAMS$
RECO_SCRIPT_BLOCK$
RECO_SCRIPT_ERROR$
REGISTRY$
REGISTRY$SCHEMAS
REGISTRY$LOG
REGISTRY$HISTORY
AUDIT_ACTIONS
WRI$_ADV_DEFINITIONS
WRI$_ADV_TASKS

TABLE_NAME
------------------------------
WRI$_ADV_DEF_PARAMETERS
WRI$_ADV_PARAMETERS
WRI$_ADV_OBJECTS
WRI$_ADV_FINDINGS
WRI$_ADV_RECOMMENDATIONS
WRI$_ADV_ACTIONS
WRI$_ADV_RATIONALE
WRI$_ADV_REC_ACTIONS
WRI$_ADV_DIRECTIVES
WRI$_ADV_JOURNAL
WRI$_ADV_MESSAGE_GROUPS

TABLE_NAME
------------------------------
WRI$_ADV_USAGE
WRI$_ADV_SQLW_SUM
WRI$_ADV_SQLW_STMTS
WRI$_ADV_SQLW_TABLES
WRI$_ADV_SQLW_TABVOL
WRI$_ADV_SQLW_COLVOL
WRI$_ADV_SQLA_MAP
WRI$_ADV_SQLA_STMTS
WRI$_ADV_SQLA_TMP
WRI$_ADV_SQLA_FAKE_REG
WRI$_SEGADV_OBJLIST

TABLE_NAME
------------------------------
WRI$_SEGADV_CNTRLTAB
WRI$_OPTSTAT_TAB_HISTORY
WRI$_OPTSTAT_IND_HISTORY
WRI$_OPTSTAT_HISTHEAD_HISTORY
WRI$_OPTSTAT_HISTGRM_HISTORY
WRI$_OPTSTAT_AUX_HISTORY
WRI$_OPTSTAT_OPR
OPTSTAT_HIST_CONTROL$
DBMS_LOCK_ALLOCATED
DBMS_ALERT_INFO
TRANSFORMATIONS$

TABLE_NAME
------------------------------
ATTRIBUTE_TRANSFORMATIONS$
RULE_SET_IEUAC$
RULE_SET$
RULE$
RULE_MAP$
RULE_EC$
REC_TAB$
REC_VAR$
RULE_SET_EE$
RULE_SET_TE$
RULE_SET_VE$

TABLE_NAME
------------------------------
RULE_SET_RE$
RULE_SET_ROR$
RULE_SET_FOB$
RULE_SET_NL$
SYS_IOT_OVER_4468
RULE_SET_RDEP$
SYS_IOT_OVER_4474
SYS_IOT_OVER_4478
REG$
LOC$
AQ$_REPLAY_INFO

TABLE_NAME
------------------------------
AQ$_QUEUE_TABLE_AFFINITIES
AQ$_SCHEDULES
AQ$_MESSAGE_TYPES
AQ$_PROPAGATION_STATUS
AQ$_PENDING_MESSAGES
AQ$_QUEUE_STATISTICS
AQ$_PUBLISHER
AQ_EVENT_TABLE
AQ_SRVNTFN_TABLE
SCHEDULER$_PROGRAM
SCHEDULER$_CLASS

TABLE_NAME
------------------------------
SCHEDULER$_JOBQTAB
AQ$_SCHEDULER$_JOBQTAB_S
SYS_IOT_OVER_5062
SCHEDULER$_JOB
SCHEDULER$_JOB_ARGUMENT
SCHEDULER$_WINDOW
SCHEDULER$_PROGRAM_ARGUMENT
SCHEDULER$_SRCQ_INFO
SCHEDULER$_SRCQ_MAP
SCHEDULER$_EVTQ_SUB
SCHEDULER$_EVENT_LOG

TABLE_NAME
------------------------------
SCHEDULER$_JOB_RUN_DETAILS
SCHEDULER$_WINDOW_DETAILS
SCHEDULER$_WINDOW_GROUP
SCHEDULER$_WINGRP_MEMBER
SCHEDULER$_SCHEDULE
SCHEDULER$_CHAIN
SCHEDULER$_STEP
SCHEDULER$_STEP_STATE
SCHEDULER$_GLOBAL_ATTRIBUTE
SCHEDULER$_EVENT_QTAB
AQ$_SCHEDULER$_EVENT_QTAB_S

TABLE_NAME
------------------------------
SYS_IOT_OVER_5148
SCHEDULER$_OLDOIDS
LOGMNRG_SEED$
LOGMNRG_DICTIONARY$
LOGMNRG_OBJ$
LOGMNRG_TAB$
LOGMNRG_COL$
LOGMNRG_ATTRCOL$
LOGMNRG_TS$
LOGMNRG_IND$
LOGMNRG_USER$

TABLE_NAME
------------------------------
LOGMNRG_TABPART$
LOGMNRG_TABSUBPART$
LOGMNRG_TABCOMPART$
LOGMNRG_TYPE$
LOGMNRG_COLTYPE$
LOGMNRG_ATTRIBUTE$
LOGMNRG_LOB$
LOGMNRG_CDEF$
LOGMNRG_CCOL$
LOGMNRG_ICOL$
LOGMNRG_LOBFRAG$

TABLE_NAME
------------------------------
LOGMNRG_INDPART$
LOGMNRG_INDSUBPART$
LOGMNRG_INDCOMPART$
LOGMNR_BUILDLOG
LOGMNR_INTERESTING_COLS
KU_NOEXP_TAB
KUPC$DATAPUMP_QUETAB
AQ$_KUPC$DATAPUMP_QUETAB_S
SYS_IOT_OVER_7141
STREAMS$_APPLY_SPILL_MESSAGES
STREAMS$_INTERNAL_TRANSFORM

TABLE_NAME
------------------------------
HS$_FDS_CLASS
HS$_FDS_INST
HS$_BASE_CAPS
HS$_CLASS_CAPS
HS$_INST_CAPS
HS$_BASE_DD
HS$_CLASS_DD
HS$_INST_DD
HS$_CLASS_INIT
HS$_INST_INIT
HS$_FDS_CLASS_DATE

TABLE_NAME
------------------------------
DBMS_UPG_LOG$
DBMS_UPG_SYSAUTH_C0$
DBMS_UPG_SYSAUTH_CS$
DBMS_UPG_SYSAUTH_CT$
DBMS_UPG_OBJAUTH_C0$
DBMS_UPG_OBJAUTH_CS$
DBMS_UPG_OBJAUTH_CT$
DBMS_UPG_RLS_C0$
DBMS_UPG_RLS_CS$
DBMS_UPG_RLS_CT$
DBMS_UPG_CHANGE$

TABLE_NAME
------------------------------
DBMS_UPG_STATUS$
DBMS_UPG_OBJECT$
DBMS_UPG_ACTION_QUEUE
DBMS_UPG_CON_MAPPING
DBMS_UPG_DEBUG
AQ$_MEM_MC
AQ$_AQ$_MEM_MC_S
SYS_IOT_OVER_8638
UTL_RECOMP_ERRORS
INVALIDATION_REGISTRY$
WRI$_DBU_FEATURE_USAGE

TABLE_NAME
------------------------------
WRI$_DBU_FEATURE_METADATA
WRI$_DBU_HIGH_WATER_MARK
WRI$_DBU_HWM_METADATA
WRI$_DBU_USAGE_SAMPLE
WRI$_DBU_CPU_USAGE
WRI$_DBU_CPU_USAGE_SAMPLE
WRI$_ALERT_OUTSTANDING
WRI$_ALERT_HISTORY
ALERT_QT
AQ$_ALERT_QT_S
SYS_IOT_OVER_8748

TABLE_NAME
------------------------------
WRI$_ALERT_THRESHOLD
WRI$_ALERT_THRESHOLD_LOG
WRI$_TRACING_ENABLED
WRI$_AGGREGATION_ENABLED
WRH$_FILESTATXS_BL
WRH$_TEMPSTATXS
WRH$_DATAFILE
WRH$_TEMPFILE
WRH$_COMP_IOSTAT
WRH$_SQLSTAT_BL
WRH$_SQLTEXT

TABLE_NAME
------------------------------
WRH$_SQL_SUMMARY
WRH$_SQL_PLAN
WRH$_SQL_BIND_METADATA
WRH$_OPTIMIZER_ENV
WRH$_SYSTEM_EVENT_BL
WRH$_EVENT_NAME
WRH$_LATCH_NAME
WRH$_BG_EVENT_SUMMARY
WRH$_WAITSTAT_BL
WRH$_ENQUEUE_STAT
WRH$_LATCH_BL

TABLE_NAME
------------------------------
WRH$_LATCH_CHILDREN_BL
WRH$_LATCH_PARENT_BL
WRH$_LATCH_MISSES_SUMMARY_BL
WRH$_LIBRARYCACHE
WRH$_DB_CACHE_ADVICE_BL
WRH$_BUFFER_POOL_STATISTICS
WRH$_ROWCACHE_SUMMARY_BL
WRH$_SGA
WRH$_SGASTAT_BL
WRH$_PGASTAT
WRH$_PROCESS_MEMORY_SUMMARY

TABLE_NAME
------------------------------
WRH$_RESOURCE_LIMIT
WRH$_SHARED_POOL_ADVICE
WRH$_STREAMS_POOL_ADVICE
WRH$_SQL_WORKAREA_HISTOGRAM
WRH$_PGA_TARGET_ADVICE
WRH$_SGA_TARGET_ADVICE
WRH$_INSTANCE_RECOVERY
WRH$_JAVA_POOL_ADVICE
WRH$_THREAD
WRH$_SYSSTAT_BL
WRH$_SYS_TIME_MODEL_BL

TABLE_NAME
------------------------------
WRH$_OSSTAT_BL
WRH$_PARAMETER_BL
WRH$_STAT_NAME
WRH$_OSSTAT_NAME
WRH$_PARAMETER_NAME
WRH$_UNDOSTAT
WRH$_SEG_STAT_BL
WRH$_SEG_STAT_OBJ
WRH$_METRIC_NAME
WRH$_SYSMETRIC_HISTORY
WRH$_SYSMETRIC_SUMMARY

TABLE_NAME
------------------------------
WRH$_SESSMETRIC_HISTORY
WRH$_FILEMETRIC_HISTORY
WRH$_WAITCLASSMETRIC_HISTORY
WRH$_DLM_MISC_BL
WRH$_CR_BLOCK_SERVER
WRH$_CURRENT_BLOCK_SERVER
WRH$_INST_CACHE_TRANSFER_BL
WRH$_ACTIVE_SESSION_HISTORY_BL
WRH$_TABLESPACE_STAT_BL
WRH$_LOG
WRH$_MTTR_TARGET_ADVICE

TABLE_NAME
------------------------------
WRH$_TABLESPACE_SPACE_USAGE
WRH$_SERVICE_NAME
WRH$_SERVICE_STAT_BL
WRH$_SERVICE_WAIT_CLASS_BL
WRH$_SESS_TIME_STATS
WRH$_STREAMS_CAPTURE
WRH$_STREAMS_APPLY_SUM
WRH$_BUFFERED_QUEUES
WRH$_BUFFERED_SUBSCRIBERS
WRH$_RULE_SET
WRI$_SCH_CONTROL

TABLE_NAME
------------------------------
WRI$_SCH_VOTES
WRM$_DATABASE_INSTANCE
WRM$_SNAPSHOT
WRM$_SNAP_ERROR
WRM$_BASELINE
WRM$_WR_CONTROL
WRI$_ADV_SQLT_BINDS
WRI$_ADV_SQLT_STATISTICS
WRI$_ADV_SQLT_PLANS
WRI$_ADV_SQLT_RTN_PLAN
WRI$_SQLSET_DEFINITIONS

TABLE_NAME
------------------------------
WRI$_SQLSET_REFERENCES
WRI$_SQLSET_STATEMENTS
WRI$_SQLSET_PLANS
WRI$_SQLSET_STATISTICS
WRI$_SQLSET_MASK
WRI$_SQLSET_PLAN_LINES
WRI$_SQLSET_BINDS
WRI$_SQLSET_WORKSPACE
SYS_IOT_OVER_9641
SYS$SERVICE_METRICS_TAB
AQ$_SYS$SERVICE_METRICS_TAB_S

TABLE_NAME
------------------------------
SYS_IOT_OVER_10125
XDB_INSTALLATION_TAB
EPG$_AUTH
AQ$_SYS$SERVICE_METRICS_TAB_I
AQ$_SYS$SERVICE_METRICS_TAB_G
AQ$_SYS$SERVICE_METRICS_TAB_H
AQ$_SYS$SERVICE_METRICS_TAB_T
RECENT_RESOURCE_INCARNATIONS$
WRI$_SQLSET_PLANS_TOCAP
WRH$_SERVICE_WAIT_CLASS
WRH$_SERVICE_STAT

TABLE_NAME
------------------------------
WRH$_TABLESPACE_STAT
WRH$_ACTIVE_SESSION_HISTORY
WRH$_INST_CACHE_TRANSFER
WRH$_DLM_MISC
WRH$_SEG_STAT
WRH$_PARAMETER
WRH$_OSSTAT
WRH$_SYS_TIME_MODEL
WRH$_SYSSTAT
WRH$_SGASTAT
WRH$_ROWCACHE_SUMMARY

TABLE_NAME
------------------------------
WRH$_DB_CACHE_ADVICE
WRH$_LATCH_MISSES_SUMMARY
WRH$_LATCH_PARENT
WRH$_LATCH_CHILDREN
WRH$_LATCH
WRH$_WAITSTAT
WRH$_SYSTEM_EVENT
WRH$_SQLSTAT
WRH$_FILESTATXS
AQ$_ALERT_QT_I
AQ$_ALERT_QT_G

TABLE_NAME
------------------------------
AQ$_ALERT_QT_H
AQ$_ALERT_QT_T
PLAN_TABLE$
AQ$_AQ$_MEM_MC_I
AQ$_AQ$_MEM_MC_G
AQ$_AQ$_MEM_MC_H
AQ$_AQ$_MEM_MC_T
DBMS_APPS_UPG_WORKING
DBMS_UPG_INVALIDATE
DBMS_UPG_CAT_CT$
DBMS_UPG_CAT_CS$

TABLE_NAME
------------------------------
DBMS_UPG_CAT_C0$
STREAMS$_APPLY_SPILL_MSGS_PART
AQ$_KUPC$DATAPUMP_QUETAB_I
AQ$_KUPC$DATAPUMP_QUETAB_G
AQ$_KUPC$DATAPUMP_QUETAB_H
AQ$_KUPC$DATAPUMP_QUETAB_T
IMPDP_STATS
KU$NOEXP_TAB
LOGMNRT_INDCOMPART$
LOGMNRT_INDSUBPART$
LOGMNRT_INDPART$

TABLE_NAME
------------------------------
LOGMNRT_LOBFRAG$
LOGMNRT_ICOL$
LOGMNRT_CCOL$
LOGMNRT_CDEF$
LOGMNRT_LOB$
LOGMNRT_ATTRIBUTE$
LOGMNRT_COLTYPE$
LOGMNRT_TYPE$
LOGMNRT_TABCOMPART$
LOGMNRT_TABSUBPART$
LOGMNRT_TABPART$

TABLE_NAME
------------------------------
LOGMNRT_USER$
LOGMNRT_IND$
LOGMNRT_TS$
LOGMNRT_ATTRCOL$
LOGMNRT_COL$
LOGMNRT_TAB$
LOGMNRT_OBJ$
LOGMNRT_DICTIONARY$
LOGMNRT_SEED$
AQ$_SCHEDULER$_EVENT_QTAB_I
AQ$_SCHEDULER$_EVENT_QTAB_G

TABLE_NAME
------------------------------
AQ$_SCHEDULER$_EVENT_QTAB_H
AQ$_SCHEDULER$_EVENT_QTAB_T
AQ$_SCHEDULER$_JOBQTAB_I
AQ$_SCHEDULER$_JOBQTAB_G
AQ$_SCHEDULER$_JOBQTAB_H
AQ$_SCHEDULER$_JOBQTAB_T
RULE_SET_ROP$
RULE_SET_IOT$
RULE_SET_PR$
ODCI_WARNINGS$
ODCI_SECOBJ$

TABLE_NAME
------------------------------
WRI$_ADV_ASA_RECO_DATA
PSTUBTBL
CLUSTER_INSTANCES
CLUSTER_NODES
CLUSTER_DATABASES
MAP_OBJECT
ATEMPTAB$
UTL_RECOMP_COMPILED
UTL_RECOMP_SORTED

669 rows selected.

SQL>
SQL>
           
         
  








Related examples in the same category

1.query table_name, tablespace_name from user_tables
2.Query a table in user_table by table_name
3.Query user_tables for the table just created
4.User_tables structure
5.Get table name and table space for a table by its name
6.alter table emp move tablespace users and then check the result by querying user_tables
7.Create sql statements from user_tables
8.Verify the creation of the statistics by running the following queries: