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

Oracle PL / SQL
1. Aggregate Functions
2. Analytical Functions
3. Char Functions
4. Constraints
5. Cursor
6. Data Type
7. Date Timezone
8. Hierarchical Query
9. Index
10. Insert Delete Update
11. Numeric Math Functions
12. Object Oriented Database
13. PL SQL
14. Regular Expressions
15. Report Column Page
16. Result Set
17. Select Query
18. Sequence
19. SQLPlus
20. Store Procedure Function
21. Subquery
22. System Tables
23. Table
24. Table Joins
25. Trigger
26. User Previliege
27. View
28. XML
Microsoft Office Word 2007 Tutorial
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
C# / C Sharp
C# / CSharp Tutorial
ASP.Net
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
PHP
Python
SQL Server / T-SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Oracle PL / SQL » System Tables » USER_TABLES 
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. User_tables structure
2. Get table name and table space for a table by its name
www.java2java.com | Contact Us
Copyright 2010 - 2030 Java Source and Support. All rights reserved.
All other trademarks are property of their respective owners.