http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FUSER_TABLES
Oracle PL/SQL/System Tables Views/USER TABLES - История изменений
2026-04-03T23:14:48Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/USER_TABLES&diff=2220&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/USER_TABLES&diff=2221&oldid=prev
Admin: 1 версия
2010-05-26T10:01:12Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==alter table emp move tablespace users and then check the result by querying user_tables==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create table EMP (<br />
2 course_id number not null,<br />
3 course_name varchar2(60) not null,<br />
4 subject_id number not null,<br />
5 duration number(2),<br />
6 skill_lvl varchar2(12) not null<br />
7 );<br />
Table created.<br />
SQL><br />
SQL> select tablespace_name, table_name<br />
2 from user_tables<br />
3 where table_name in ("EMP", "DEPT")<br />
4 order by 1, 2;<br />
TABLESPACE_NAME TABLE_NAME<br />
------------------------------ ------------------------------<br />
SYSTEM EMP<br />
SQL><br />
SQL><br />
SQL> select segment_name, tablespace_name<br />
2 from user_segments<br />
3 where segment_name = "EMP";<br />
SEGMENT_NAME TABLESPACE_NAME<br />
--------------------------------------------------------------------------------- ------------------------------<br />
EMP SYSTEM<br />
SQL><br />
SQL> alter table emp move<br />
2 tablespace users;<br />
Table altered.<br />
SQL><br />
SQL><br />
SQL> select segment_name, tablespace_name<br />
2 from user_segments<br />
3 where segment_name = "EMP";<br />
SEGMENT_NAME TABLESPACE_NAME<br />
--------------------------------------------------------------------------------- ------------------------------<br />
EMP USERS<br />
SQL><br />
SQL> drop table emp;<br />
Table dropped.<br />
SQL><br />
SQL><br />
SQL><br />
select default_tablespace, temporary_tablespace from dba_users by username<br />
select username, default_tablespace, temporary_tablespace<br />
from dba_users<br />
where default_tablespace = "SYSTEM" or temporary_tablespace = "SYSTEM";<br />
<br />
alter user scott<br />
default tablespace users;<br />
select default_tablespace, temporary_tablespace<br />
from dba_users<br />
where username = "SCOTT";<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Create sql statements from user_tables==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> SELECT "DROP TABLE " || table_name || " CASCADE CONSTRAINTS;" FROM user_tables;<br />
"DROPTABLE"||TABLE_NAME||"CASCADECONSTRAINTS;"<br />
--------------------------------------------------------------<br />
DROP TABLE SYSTEM_STATS CASCADE CONSTRAINTS;<br />
DROP TABLE INVENTORY_TBL CASCADE CONSTRAINTS;<br />
DROP TABLE DEPT$AUDIT CASCADE CONSTRAINTS;<br />
DROP TABLE PASSWORD_AUDIT CASCADE CONSTRAINTS;<br />
DROP TABLE EMP_DELTAS CASCADE CONSTRAINTS;<br />
DROP TABLE CUSTLOG CASCADE CONSTRAINTS;<br />
DROP TABLE P CASCADE CONSTRAINTS;<br />
DROP TABLE DEMO CASCADE CONSTRAINTS;<br />
DROP TABLE CUST_NO_KEY_TABLE CASCADE CONSTRAINTS;<br />
DROP TABLE IT CASCADE CONSTRAINTS;<br />
DROP TABLE P1 CASCADE CONSTRAINTS;<br />
DROP TABLE MYSTATS CASCADE CONSTRAINTS;<br />
DROP TABLE WORKING_EMPS CASCADE CONSTRAINTS;<br />
DROP TABLE WORKING_EMPLOYEES CASCADE CONSTRAINTS;<br />
DROP TABLE EMPTEMPTABLE CASCADE CONSTRAINTS;<br />
DROP TABLE TEMP_TABLE CASCADE CONSTRAINTS;<br />
DROP TABLE EMPLOYEETEMPTABLE CASCADE CONSTRAINTS;<br />
DROP TABLE TMP CASCADE CONSTRAINTS;<br />
DROP TABLE PARMS CASCADE CONSTRAINTS;<br />
DROP TABLE IX CASCADE CONSTRAINTS;<br />
DROP TABLE CUST_WITH_VARRAY_TEMP_TABLE CASCADE CONSTRAINTS;<br />
DROP TABLE WORKING_CUSTOMERS CASCADE CONSTRAINTS;<br />
22 rows selected.<br />
<br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Get table name and table space for a table by its name==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create table foo (a int );<br />
Table created.<br />
SQL><br />
SQL><br />
SQL> select table_name, tablespace_name<br />
2 from user_tables<br />
3 where table_name = "FOO";<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
FOO SYSTEM<br />
SQL><br />
SQL> drop table foo;<br />
Table dropped.<br />
SQL><br />
SQL> create table foo (a int ) tablespace users;<br />
Table created.<br />
SQL><br />
SQL> select table_name, tablespace_name<br />
2 from user_tables<br />
3 where table_name = "FOO";<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
FOO USERS<br />
SQL><br />
SQL> drop table foo;<br />
Table dropped.<br />
SQL><br />
SQL><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Query a table in user_table by table_name==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create table t(<br />
2 a int<br />
3 );<br />
Table created.<br />
SQL><br />
SQL><br />
SQL> select table_name, tablespace_name<br />
2 from user_tables<br />
3 where table_name = "T";<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
T SYSTEM<br />
SQL><br />
SQL> drop table t;<br />
Table dropped.<br />
SQL><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==query table_name, tablespace_name from user_tables==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> select table_name, tablespace_name<br />
2 from user_tables where rownum < 50<br />
3 order by table_name;<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
ARGUMENT$ SYSTEM<br />
ATTRCOL$ SYSTEM<br />
BOOTSTRAP$ SYSTEM<br />
CCOL$ SYSTEM<br />
CDEF$ SYSTEM<br />
CLU$ SYSTEM<br />
COL$ SYSTEM<br />
COLTYPE$ SYSTEM<br />
CON$ SYSTEM<br />
DIR$ SYSTEM<br />
ERROR$ SYSTEM<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
FET$ SYSTEM<br />
FILE$ SYSTEM<br />
ICOL$ SYSTEM<br />
ICOLDEP$ SYSTEM<br />
IDL_CHAR$ SYSTEM<br />
IDL_SB4$ SYSTEM<br />
IDL_UB1$ SYSTEM<br />
IDL_UB2$ SYSTEM<br />
IND$ SYSTEM<br />
JAVAOBJ$ SYSTEM<br />
LIBRARY$ SYSTEM<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
LOB$ SYSTEM<br />
NTAB$ SYSTEM<br />
OBJ$ SYSTEM<br />
OBJAUTH$ SYSTEM<br />
OPQTYPE$ SYSTEM<br />
PROCEDURE$ SYSTEM<br />
PROCEDUREINFO$ SYSTEM<br />
PROXY_DATA$ SYSTEM<br />
PROXY_ROLE_DATA$ SYSTEM<br />
REFCON$ SYSTEM<br />
SEG$ SYSTEM<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
SEQ$ SYSTEM<br />
SOURCE$ SYSTEM<br />
SUBCOLTYPE$ SYSTEM<br />
SUPEROBJ$ SYSTEM<br />
SYN$ SYSTEM<br />
TAB$ SYSTEM<br />
TS$ SYSTEM<br />
TSQ$ SYSTEM<br />
TYPED_VIEW$ SYSTEM<br />
TYPE_MISC$ SYSTEM<br />
UET$ SYSTEM<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
UGROUP$ SYSTEM<br />
UNDO$ SYSTEM<br />
USER$ SYSTEM<br />
VIEW$ SYSTEM<br />
VIEWTRCOL$ SYSTEM<br />
49 rows selected.<br />
SQL><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Query user_tables for the table just created==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create table foo (a int)<br />
2 tablespace users;<br />
Table created.<br />
SQL><br />
SQL> select table_name, tablespace_name<br />
2 from user_tables<br />
3 where table_name = "FOO";<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
FOO USERS<br />
SQL><br />
SQL> select username, default_tablespace, temporary_tablespace<br />
2 from dba_users<br />
3 where default_tablespace = "SYSTEM" or temporary_tablespace = "SYSTEM";<br />
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE<br />
------------------------------ ------------------------------ ------------------------------<br />
SYSTEM SYSTEM TEMP<br />
SYS SYSTEM TEMP<br />
DIP SYSTEM TEMP<br />
OUTLN SYSTEM TEMP<br />
MDSYS SYSTEM TEMP<br />
TSMSYS SYSTEM TEMP<br />
6 rows selected.<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==To get a listing of all tables that you own==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
<br />
SQL><br />
SQL> -- To get a listing of all tables that you own<br />
SQL><br />
SQL> SELECT table_name FROM USER_TABLES;<br />
TABLE_NAME<br />
------------------------------<br />
CON$<br />
UNDO$<br />
CDEF$<br />
CCOL$<br />
PROXY_ROLE_DATA$<br />
FILE$<br />
FET$<br />
TS$<br />
PROXY_DATA$<br />
SEG$<br />
UET$<br />
TABLE_NAME<br />
------------------------------<br />
TSQ$<br />
USER$<br />
BOOTSTRAP$<br />
OBJ$<br />
ICOLDEP$<br />
LIBRARY$<br />
OPQTYPE$<br />
REFCON$<br />
NTAB$<br />
TYPE_MISC$<br />
VIEWTRCOL$<br />
TABLE_NAME<br />
------------------------------<br />
ATTRCOL$<br />
SUBCOLTYPE$<br />
COLTYPE$<br />
LOB$<br />
TAB$<br />
CLU$<br />
COL$<br />
IND$<br />
ICOL$<br />
OBJAUTH$<br />
UGROUP$<br />
TABLE_NAME<br />
------------------------------<br />
SYN$<br />
VIEW$<br />
TYPED_VIEW$<br />
SUPEROBJ$<br />
SEQ$<br />
PROCEDURE$<br />
PROCEDUREINFO$<br />
ARGUMENT$<br />
SOURCE$<br />
IDL_UB1$<br />
IDL_CHAR$<br />
TABLE_NAME<br />
------------------------------<br />
IDL_UB2$<br />
IDL_SB4$<br />
DIR$<br />
JAVAOBJ$<br />
ERROR$<br />
SETTINGS$<br />
TRIGGER$<br />
TRIGGERCOL$<br />
TRIGGERJAVAF$<br />
TRIGGERJAVAS$<br />
TRIGGERJAVAC$<br />
TABLE_NAME<br />
------------------------------<br />
TRIGGERJAVAM$<br />
SYSAUTH$<br />
OBJPRIV$<br />
DEFROLE$<br />
PROFILE$<br />
PROFNAME$<br />
DEPENDENCY$<br />
ACCESS$<br />
LINK$<br />
TRUSTED_LIST$<br />
PROPS$<br />
TABLE_NAME<br />
------------------------------<br />
COM$<br />
RESOURCE_COST$<br />
INCEXP<br />
INCVID<br />
INCFIL<br />
_default_auditing_options_<br />
AUDIT$<br />
PENDING_TRANS$<br />
PENDING_SESSIONS$<br />
PENDING_SUB_SESSIONS$<br />
SUMPARTLOG$<br />
TABLE_NAME<br />
------------------------------<br />
SUMDELTA$<br />
SNAP_LOGDEP$<br />
SNAP_LOADERTIME$<br />
SLOG$<br />
MLOG$<br />
ID_GENS$<br />
OID$<br />
RESULT$<br />
PARAMETER$<br />
METHOD$<br />
ATTRIBUTE$<br />
TABLE_NAME<br />
------------------------------<br />
COLLECTION$<br />
TYPE$<br />
TYPEHIERARCHY$<br />
VIEWCON$<br />
SNAP$<br />
SNAP_REFTIME$<br />
MLOG_REFCOL$<br />
SNAP_REFOP$<br />
SNAP_COLMAP$<br />
SNAP_OBJCOL$<br />
REG_SNAP$<br />
TABLE_NAME<br />
------------------------------<br />
SNAP_SITE$<br />
JOB$<br />
RGCHILD$<br />
RGROUP$<br />
DUC$<br />
HISTGRM$<br />
HIST_HEAD$<br />
DUAL<br />
PARTOBJ$<br />
PARTCOL$<br />
TABPART$<br />
TABLE_NAME<br />
------------------------------<br />
INDPART$<br />
SUBPARTCOL$<br />
TABSUBPART$<br />
INDSUBPART$<br />
TABCOMPART$<br />
INDCOMPART$<br />
PARTLOB$<br />
LOBFRAG$<br />
LOBCOMPPART$<br />
DEFSUBPART$<br />
DEFSUBPARTLOB$<br />
TABLE_NAME<br />
------------------------------<br />
SYSTEM_PRIVILEGE_MAP<br />
TABLE_PRIVILEGE_MAP<br />
STMT_AUDIT_OPTION_MAP<br />
RESOURCE_MAP<br />
USER_ASTATUS_MAP<br />
EXPACT$<br />
NOEXP$<br />
PROCEDUREJAVA$<br />
PROCEDUREC$<br />
PROCEDUREPLSQL$<br />
KOPM$<br />
TABLE_NAME<br />
------------------------------<br />
VTABLE$<br />
USER_HISTORY$<br />
MIGRATE$<br />
OPERATOR$<br />
OPBINDING$<br />
OPANCILLARY$<br />
OPARG$<br />
INDTYPES$<br />
INDOP$<br />
INDARRAYTYPE$<br />
SECOBJ$<br />
TABLE_NAME<br />
------------------------------<br />
ASSOCIATION$<br />
USTATS$<br />
JAVASNM$<br />
SUM$<br />
SUMDETAIL$<br />
SUMINLINE$<br />
SUMKEY$<br />
SUMAGG$<br />
SUMJOIN$<br />
SUMDEP$<br />
SUMPRED$<br />
TABLE_NAME<br />
------------------------------<br />
SUMQB$<br />
DIM$<br />
DIMLEVEL$<br />
DIMLEVELKEY$<br />
DIMJOINKEY$<br />
DIMATTR$<br />
HIER$<br />
HIERLEVEL$<br />
RLS$<br />
RLS_SC$<br />
RLS_GRP$<br />
TABLE_NAME<br />
------------------------------<br />
RLS_CTX$<br />
CONTEXT$<br />
RULESET$<br />
INDPART_PARAM$<br />
SQL$<br />
SQL$TEXT<br />
SQLPROF$<br />
SQLPROF$DESC<br />
SQLPROF$ATTR<br />
EXPPKGOBJ$<br />
EXPPKGACT$<br />
TABLE_NAME<br />
------------------------------<br />
EXPDEPOBJ$<br />
EXPDEPACT$<br />
MON_MODS$<br />
MON_MODS_ALL$<br />
METAVIEW$<br />
METAFILTER$<br />
METAXSL$<br />
METAXSLPARAM$<br />
METASTYLESHEET<br />
METASCRIPT$<br />
METASCRIPTFILTER$<br />
TABLE_NAME<br />
------------------------------<br />
METANAMETRANS$<br />
METAPATHMAP$<br />
EXTERNAL_TAB$<br />
EXTERNAL_LOCATION$<br />
SQL_VERSION$<br />
COL_USAGE$<br />
CDC_SYSTEM$<br />
CDC_CHANGE_SOURCES$<br />
CDC_CHANGE_SETS$<br />
CDC_CHANGE_TABLES$<br />
CDC_SUBSCRIBERS$<br />
TABLE_NAME<br />
------------------------------<br />
CDC_SUBSCRIBED_TABLES$<br />
CDC_SUBSCRIBED_COLUMNS$<br />
CDC_CHANGE_COLUMNS$<br />
CDC_PROPAGATIONS$<br />
CDC_PROPAGATED_SETS$<br />
JIJOIN$<br />
JIREFRESHSQL$<br />
LOG$<br />
APPROLE$<br />
FGA$<br />
FGACOL$<br />
TABLE_NAME<br />
------------------------------<br />
AUD$<br />
FGA_LOG$<br />
OBJECT_USAGE<br />
AUX_STATS$<br />
SMON_SCN_TIME<br />
AW$<br />
PS$<br />
AW_OBJ$<br />
AW_PROP$<br />
MAP_FILE$<br />
MAP_FILE_EXTENT$<br />
TABLE_NAME<br />
------------------------------<br />
MAP_SUBELEMENT$<br />
MAP_ELEMENT$<br />
MAP_EXTELEMENT$<br />
MAP_COMPLIST$<br />
STREAMS$_CAPTURE_PROCESS<br />
STREAMS$_APPLY_PROCESS<br />
STREAMS$_PROPAGATION_PROCESS<br />
STREAMS$_PROCESS_PARAMS<br />
STREAMS$_EXTRA_ATTRS<br />
STREAMS$_PREPARE_OBJECT<br />
STREAMS$_PREPARE_DDL<br />
TABLE_NAME<br />
------------------------------<br />
STREAMS$_APPLY_MILESTONE<br />
STREAMS$_APPLY_PROGRESS<br />
STREAMS$_KEY_COLUMNS<br />
STREAMS$_DEF_PROC<br />
STREAMS$_RULES<br />
APPLY$_SOURCE_OBJ<br />
APPLY$_SOURCE_SCHEMA<br />
APPLY$_VIRTUAL_OBJ_CONS<br />
APPLY$_CONSTRAINT_COLUMNS<br />
APPLY$_DEST_OBJ<br />
APPLY$_DEST_OBJ_CMAP<br />
TABLE_NAME<br />
------------------------------<br />
APPLY$_DEST_OBJ_OPS<br />
APPLY$_ERROR<br />
APPLY$_ERROR_TXN<br />
APPLY$_ERROR_HANDLER<br />
APPLY$_CONF_HDLR_COLUMNS<br />
STREAMS$_DEST_OBJS<br />
STREAMS$_DEST_OBJ_COLS<br />
STREAMS$_PRIVILEGED_USER<br />
STREAMS$_MESSAGE_RULES<br />
WARNING_SETTINGS$<br />
STREAMS$_MESSAGE_CONSUMERS<br />
TABLE_NAME<br />
------------------------------<br />
STREAMS$_APPLY_SPILL_TXN<br />
STREAMS$_APPLY_SPILL_TXN_LIST<br />
FGR$_FILE_GROUPS<br />
FGR$_FILE_GROUP_VERSIONS<br />
FGR$_FILE_GROUP_EXPORT_INFO<br />
FGR$_FILE_GROUP_FILES<br />
FGR$_TABLESPACE_INFO<br />
FGR$_TABLE_INFO<br />
RECYCLEBIN$<br />
FIXED_OBJ$<br />
TAB_STATS$<br />
TABLE_NAME<br />
------------------------------<br />
IND_STATS$<br />
PROXY_INFO$<br />
PROXY_ROLE_INFO$<br />
REDEF$<br />
REDEF_OBJECT$<br />
REDEF_DEP_ERROR$<br />
NCOMP_DLL$<br />
IND_ONLINE$<br />
SERVICE$<br />
EXPIMP_TTS_CT$<br />
TSM_SRC$<br />
TABLE_NAME<br />
------------------------------<br />
TSM_DST$<br />
DIR$MIGRATE_OPERATIONS<br />
DIR$SERVICE_OPERATIONS<br />
DIR$ESCALATE_OPERATIONS<br />
DIR$QUIESCE_OPERATIONS<br />
DIR$INSTANCE_ACTIONS<br />
DIR$RESONATE_OPERATIONS<br />
DIR$ALERT_HISTORY<br />
DIR$REASON_STRINGS<br />
DIR$DATABASE_ATTRIBUTES<br />
DIR$VICTIM_POLICY<br />
TABLE_NAME<br />
------------------------------<br />
DIR$NODE_ATTRIBUTES<br />
DIR$SERVICE_ATTRIBUTES<br />
CACHE_STATS_1$<br />
CACHE_STATS_0$<br />
STATS_TARGET$<br />
RESOURCE_PLAN$<br />
RESOURCE_CONSUMER_GROUP$<br />
RESOURCE_PLAN_DIRECTIVE$<br />
RESOURCE_GROUP_MAPPING$<br />
RESOURCE_MAPPING_PRIORITY$<br />
ENC$<br />
TABLE_NAME<br />
------------------------------<br />
RECO_SCRIPT$<br />
RECO_SCRIPT_PARAMS$<br />
RECO_SCRIPT_BLOCK$<br />
RECO_SCRIPT_ERROR$<br />
REGISTRY$<br />
REGISTRY$SCHEMAS<br />
REGISTRY$LOG<br />
REGISTRY$HISTORY<br />
AUDIT_ACTIONS<br />
WRI$_ADV_DEFINITIONS<br />
WRI$_ADV_TASKS<br />
TABLE_NAME<br />
------------------------------<br />
WRI$_ADV_DEF_PARAMETERS<br />
WRI$_ADV_PARAMETERS<br />
WRI$_ADV_OBJECTS<br />
WRI$_ADV_FINDINGS<br />
WRI$_ADV_RECOMMENDATIONS<br />
WRI$_ADV_ACTIONS<br />
WRI$_ADV_RATIONALE<br />
WRI$_ADV_REC_ACTIONS<br />
WRI$_ADV_DIRECTIVES<br />
WRI$_ADV_JOURNAL<br />
WRI$_ADV_MESSAGE_GROUPS<br />
TABLE_NAME<br />
------------------------------<br />
WRI$_ADV_USAGE<br />
WRI$_ADV_SQLW_SUM<br />
WRI$_ADV_SQLW_STMTS<br />
WRI$_ADV_SQLW_TABLES<br />
WRI$_ADV_SQLW_TABVOL<br />
WRI$_ADV_SQLW_COLVOL<br />
WRI$_ADV_SQLA_MAP<br />
WRI$_ADV_SQLA_STMTS<br />
WRI$_ADV_SQLA_TMP<br />
WRI$_ADV_SQLA_FAKE_REG<br />
WRI$_SEGADV_OBJLIST<br />
TABLE_NAME<br />
------------------------------<br />
WRI$_SEGADV_CNTRLTAB<br />
WRI$_OPTSTAT_TAB_HISTORY<br />
WRI$_OPTSTAT_IND_HISTORY<br />
WRI$_OPTSTAT_HISTHEAD_HISTORY<br />
WRI$_OPTSTAT_HISTGRM_HISTORY<br />
WRI$_OPTSTAT_AUX_HISTORY<br />
WRI$_OPTSTAT_OPR<br />
OPTSTAT_HIST_CONTROL$<br />
DBMS_LOCK_ALLOCATED<br />
DBMS_ALERT_INFO<br />
TRANSFORMATIONS$<br />
TABLE_NAME<br />
------------------------------<br />
ATTRIBUTE_TRANSFORMATIONS$<br />
RULE_SET_IEUAC$<br />
RULE_SET$<br />
RULE$<br />
RULE_MAP$<br />
RULE_EC$<br />
REC_TAB$<br />
REC_VAR$<br />
RULE_SET_EE$<br />
RULE_SET_TE$<br />
RULE_SET_VE$<br />
TABLE_NAME<br />
------------------------------<br />
RULE_SET_RE$<br />
RULE_SET_ROR$<br />
RULE_SET_FOB$<br />
RULE_SET_NL$<br />
SYS_IOT_OVER_4468<br />
RULE_SET_RDEP$<br />
SYS_IOT_OVER_4474<br />
SYS_IOT_OVER_4478<br />
REG$<br />
LOC$<br />
AQ$_REPLAY_INFO<br />
TABLE_NAME<br />
------------------------------<br />
AQ$_QUEUE_TABLE_AFFINITIES<br />
AQ$_SCHEDULES<br />
AQ$_MESSAGE_TYPES<br />
AQ$_PROPAGATION_STATUS<br />
AQ$_PENDING_MESSAGES<br />
AQ$_QUEUE_STATISTICS<br />
AQ$_PUBLISHER<br />
AQ_EVENT_TABLE<br />
AQ_SRVNTFN_TABLE<br />
SCHEDULER$_PROGRAM<br />
SCHEDULER$_CLASS<br />
TABLE_NAME<br />
------------------------------<br />
SCHEDULER$_JOBQTAB<br />
AQ$_SCHEDULER$_JOBQTAB_S<br />
SYS_IOT_OVER_5062<br />
SCHEDULER$_JOB<br />
SCHEDULER$_JOB_ARGUMENT<br />
SCHEDULER$_WINDOW<br />
SCHEDULER$_PROGRAM_ARGUMENT<br />
SCHEDULER$_SRCQ_INFO<br />
SCHEDULER$_SRCQ_MAP<br />
SCHEDULER$_EVTQ_SUB<br />
SCHEDULER$_EVENT_LOG<br />
TABLE_NAME<br />
------------------------------<br />
SCHEDULER$_JOB_RUN_DETAILS<br />
SCHEDULER$_WINDOW_DETAILS<br />
SCHEDULER$_WINDOW_GROUP<br />
SCHEDULER$_WINGRP_MEMBER<br />
SCHEDULER$_SCHEDULE<br />
SCHEDULER$_CHAIN<br />
SCHEDULER$_STEP<br />
SCHEDULER$_STEP_STATE<br />
SCHEDULER$_GLOBAL_ATTRIBUTE<br />
SCHEDULER$_EVENT_QTAB<br />
AQ$_SCHEDULER$_EVENT_QTAB_S<br />
TABLE_NAME<br />
------------------------------<br />
SYS_IOT_OVER_5148<br />
SCHEDULER$_OLDOIDS<br />
LOGMNRG_SEED$<br />
LOGMNRG_DICTIONARY$<br />
LOGMNRG_OBJ$<br />
LOGMNRG_TAB$<br />
LOGMNRG_COL$<br />
LOGMNRG_ATTRCOL$<br />
LOGMNRG_TS$<br />
LOGMNRG_IND$<br />
LOGMNRG_USER$<br />
TABLE_NAME<br />
------------------------------<br />
LOGMNRG_TABPART$<br />
LOGMNRG_TABSUBPART$<br />
LOGMNRG_TABCOMPART$<br />
LOGMNRG_TYPE$<br />
LOGMNRG_COLTYPE$<br />
LOGMNRG_ATTRIBUTE$<br />
LOGMNRG_LOB$<br />
LOGMNRG_CDEF$<br />
LOGMNRG_CCOL$<br />
LOGMNRG_ICOL$<br />
LOGMNRG_LOBFRAG$<br />
TABLE_NAME<br />
------------------------------<br />
LOGMNRG_INDPART$<br />
LOGMNRG_INDSUBPART$<br />
LOGMNRG_INDCOMPART$<br />
LOGMNR_BUILDLOG<br />
LOGMNR_INTERESTING_COLS<br />
KU_NOEXP_TAB<br />
KUPC$DATAPUMP_QUETAB<br />
AQ$_KUPC$DATAPUMP_QUETAB_S<br />
SYS_IOT_OVER_7141<br />
STREAMS$_APPLY_SPILL_MESSAGES<br />
STREAMS$_INTERNAL_TRANSFORM<br />
TABLE_NAME<br />
------------------------------<br />
HS$_FDS_CLASS<br />
HS$_FDS_INST<br />
HS$_BASE_CAPS<br />
HS$_CLASS_CAPS<br />
HS$_INST_CAPS<br />
HS$_BASE_DD<br />
HS$_CLASS_DD<br />
HS$_INST_DD<br />
HS$_CLASS_INIT<br />
HS$_INST_INIT<br />
HS$_FDS_CLASS_DATE<br />
TABLE_NAME<br />
------------------------------<br />
DBMS_UPG_LOG$<br />
DBMS_UPG_SYSAUTH_C0$<br />
DBMS_UPG_SYSAUTH_CS$<br />
DBMS_UPG_SYSAUTH_CT$<br />
DBMS_UPG_OBJAUTH_C0$<br />
DBMS_UPG_OBJAUTH_CS$<br />
DBMS_UPG_OBJAUTH_CT$<br />
DBMS_UPG_RLS_C0$<br />
DBMS_UPG_RLS_CS$<br />
DBMS_UPG_RLS_CT$<br />
DBMS_UPG_CHANGE$<br />
TABLE_NAME<br />
------------------------------<br />
DBMS_UPG_STATUS$<br />
DBMS_UPG_OBJECT$<br />
DBMS_UPG_ACTION_QUEUE<br />
DBMS_UPG_CON_MAPPING<br />
DBMS_UPG_DEBUG<br />
AQ$_MEM_MC<br />
AQ$_AQ$_MEM_MC_S<br />
SYS_IOT_OVER_8638<br />
UTL_RECOMP_ERRORS<br />
INVALIDATION_REGISTRY$<br />
WRI$_DBU_FEATURE_USAGE<br />
TABLE_NAME<br />
------------------------------<br />
WRI$_DBU_FEATURE_METADATA<br />
WRI$_DBU_HIGH_WATER_MARK<br />
WRI$_DBU_HWM_METADATA<br />
WRI$_DBU_USAGE_SAMPLE<br />
WRI$_DBU_CPU_USAGE<br />
WRI$_DBU_CPU_USAGE_SAMPLE<br />
WRI$_ALERT_OUTSTANDING<br />
WRI$_ALERT_HISTORY<br />
ALERT_QT<br />
AQ$_ALERT_QT_S<br />
SYS_IOT_OVER_8748<br />
TABLE_NAME<br />
------------------------------<br />
WRI$_ALERT_THRESHOLD<br />
WRI$_ALERT_THRESHOLD_LOG<br />
WRI$_TRACING_ENABLED<br />
WRI$_AGGREGATION_ENABLED<br />
WRH$_FILESTATXS_BL<br />
WRH$_TEMPSTATXS<br />
WRH$_DATAFILE<br />
WRH$_TEMPFILE<br />
WRH$_COMP_IOSTAT<br />
WRH$_SQLSTAT_BL<br />
WRH$_SQLTEXT<br />
TABLE_NAME<br />
------------------------------<br />
WRH$_SQL_SUMMARY<br />
WRH$_SQL_PLAN<br />
WRH$_SQL_BIND_METADATA<br />
WRH$_OPTIMIZER_ENV<br />
WRH$_SYSTEM_EVENT_BL<br />
WRH$_EVENT_NAME<br />
WRH$_LATCH_NAME<br />
WRH$_BG_EVENT_SUMMARY<br />
WRH$_WAITSTAT_BL<br />
WRH$_ENQUEUE_STAT<br />
WRH$_LATCH_BL<br />
TABLE_NAME<br />
------------------------------<br />
WRH$_LATCH_CHILDREN_BL<br />
WRH$_LATCH_PARENT_BL<br />
WRH$_LATCH_MISSES_SUMMARY_BL<br />
WRH$_LIBRARYCACHE<br />
WRH$_DB_CACHE_ADVICE_BL<br />
WRH$_BUFFER_POOL_STATISTICS<br />
WRH$_ROWCACHE_SUMMARY_BL<br />
WRH$_SGA<br />
WRH$_SGASTAT_BL<br />
WRH$_PGASTAT<br />
WRH$_PROCESS_MEMORY_SUMMARY<br />
TABLE_NAME<br />
------------------------------<br />
WRH$_RESOURCE_LIMIT<br />
WRH$_SHARED_POOL_ADVICE<br />
WRH$_STREAMS_POOL_ADVICE<br />
WRH$_SQL_WORKAREA_HISTOGRAM<br />
WRH$_PGA_TARGET_ADVICE<br />
WRH$_SGA_TARGET_ADVICE<br />
WRH$_INSTANCE_RECOVERY<br />
WRH$_JAVA_POOL_ADVICE<br />
WRH$_THREAD<br />
WRH$_SYSSTAT_BL<br />
WRH$_SYS_TIME_MODEL_BL<br />
TABLE_NAME<br />
------------------------------<br />
WRH$_OSSTAT_BL<br />
WRH$_PARAMETER_BL<br />
WRH$_STAT_NAME<br />
WRH$_OSSTAT_NAME<br />
WRH$_PARAMETER_NAME<br />
WRH$_UNDOSTAT<br />
WRH$_SEG_STAT_BL<br />
WRH$_SEG_STAT_OBJ<br />
WRH$_METRIC_NAME<br />
WRH$_SYSMETRIC_HISTORY<br />
WRH$_SYSMETRIC_SUMMARY<br />
TABLE_NAME<br />
------------------------------<br />
WRH$_SESSMETRIC_HISTORY<br />
WRH$_FILEMETRIC_HISTORY<br />
WRH$_WAITCLASSMETRIC_HISTORY<br />
WRH$_DLM_MISC_BL<br />
WRH$_CR_BLOCK_SERVER<br />
WRH$_CURRENT_BLOCK_SERVER<br />
WRH$_INST_CACHE_TRANSFER_BL<br />
WRH$_ACTIVE_SESSION_HISTORY_BL<br />
WRH$_TABLESPACE_STAT_BL<br />
WRH$_LOG<br />
WRH$_MTTR_TARGET_ADVICE<br />
TABLE_NAME<br />
------------------------------<br />
WRH$_TABLESPACE_SPACE_USAGE<br />
WRH$_SERVICE_NAME<br />
WRH$_SERVICE_STAT_BL<br />
WRH$_SERVICE_WAIT_CLASS_BL<br />
WRH$_SESS_TIME_STATS<br />
WRH$_STREAMS_CAPTURE<br />
WRH$_STREAMS_APPLY_SUM<br />
WRH$_BUFFERED_QUEUES<br />
WRH$_BUFFERED_SUBSCRIBERS<br />
WRH$_RULE_SET<br />
WRI$_SCH_CONTROL<br />
TABLE_NAME<br />
------------------------------<br />
WRI$_SCH_VOTES<br />
WRM$_DATABASE_INSTANCE<br />
WRM$_SNAPSHOT<br />
WRM$_SNAP_ERROR<br />
WRM$_BASELINE<br />
WRM$_WR_CONTROL<br />
WRI$_ADV_SQLT_BINDS<br />
WRI$_ADV_SQLT_STATISTICS<br />
WRI$_ADV_SQLT_PLANS<br />
WRI$_ADV_SQLT_RTN_PLAN<br />
WRI$_SQLSET_DEFINITIONS<br />
TABLE_NAME<br />
------------------------------<br />
WRI$_SQLSET_REFERENCES<br />
WRI$_SQLSET_STATEMENTS<br />
WRI$_SQLSET_PLANS<br />
WRI$_SQLSET_STATISTICS<br />
WRI$_SQLSET_MASK<br />
WRI$_SQLSET_PLAN_LINES<br />
WRI$_SQLSET_BINDS<br />
WRI$_SQLSET_WORKSPACE<br />
SYS_IOT_OVER_9641<br />
SYS$SERVICE_METRICS_TAB<br />
AQ$_SYS$SERVICE_METRICS_TAB_S<br />
TABLE_NAME<br />
------------------------------<br />
SYS_IOT_OVER_10125<br />
XDB_INSTALLATION_TAB<br />
EPG$_AUTH<br />
AQ$_SYS$SERVICE_METRICS_TAB_I<br />
AQ$_SYS$SERVICE_METRICS_TAB_G<br />
AQ$_SYS$SERVICE_METRICS_TAB_H<br />
AQ$_SYS$SERVICE_METRICS_TAB_T<br />
RECENT_RESOURCE_INCARNATIONS$<br />
WRI$_SQLSET_PLANS_TOCAP<br />
WRH$_SERVICE_WAIT_CLASS<br />
WRH$_SERVICE_STAT<br />
TABLE_NAME<br />
------------------------------<br />
WRH$_TABLESPACE_STAT<br />
WRH$_ACTIVE_SESSION_HISTORY<br />
WRH$_INST_CACHE_TRANSFER<br />
WRH$_DLM_MISC<br />
WRH$_SEG_STAT<br />
WRH$_PARAMETER<br />
WRH$_OSSTAT<br />
WRH$_SYS_TIME_MODEL<br />
WRH$_SYSSTAT<br />
WRH$_SGASTAT<br />
WRH$_ROWCACHE_SUMMARY<br />
TABLE_NAME<br />
------------------------------<br />
WRH$_DB_CACHE_ADVICE<br />
WRH$_LATCH_MISSES_SUMMARY<br />
WRH$_LATCH_PARENT<br />
WRH$_LATCH_CHILDREN<br />
WRH$_LATCH<br />
WRH$_WAITSTAT<br />
WRH$_SYSTEM_EVENT<br />
WRH$_SQLSTAT<br />
WRH$_FILESTATXS<br />
AQ$_ALERT_QT_I<br />
AQ$_ALERT_QT_G<br />
TABLE_NAME<br />
------------------------------<br />
AQ$_ALERT_QT_H<br />
AQ$_ALERT_QT_T<br />
PLAN_TABLE$<br />
AQ$_AQ$_MEM_MC_I<br />
AQ$_AQ$_MEM_MC_G<br />
AQ$_AQ$_MEM_MC_H<br />
AQ$_AQ$_MEM_MC_T<br />
DBMS_APPS_UPG_WORKING<br />
DBMS_UPG_INVALIDATE<br />
DBMS_UPG_CAT_CT$<br />
DBMS_UPG_CAT_CS$<br />
TABLE_NAME<br />
------------------------------<br />
DBMS_UPG_CAT_C0$<br />
STREAMS$_APPLY_SPILL_MSGS_PART<br />
AQ$_KUPC$DATAPUMP_QUETAB_I<br />
AQ$_KUPC$DATAPUMP_QUETAB_G<br />
AQ$_KUPC$DATAPUMP_QUETAB_H<br />
AQ$_KUPC$DATAPUMP_QUETAB_T<br />
IMPDP_STATS<br />
KU$NOEXP_TAB<br />
LOGMNRT_INDCOMPART$<br />
LOGMNRT_INDSUBPART$<br />
LOGMNRT_INDPART$<br />
TABLE_NAME<br />
------------------------------<br />
LOGMNRT_LOBFRAG$<br />
LOGMNRT_ICOL$<br />
LOGMNRT_CCOL$<br />
LOGMNRT_CDEF$<br />
LOGMNRT_LOB$<br />
LOGMNRT_ATTRIBUTE$<br />
LOGMNRT_COLTYPE$<br />
LOGMNRT_TYPE$<br />
LOGMNRT_TABCOMPART$<br />
LOGMNRT_TABSUBPART$<br />
LOGMNRT_TABPART$<br />
TABLE_NAME<br />
------------------------------<br />
LOGMNRT_USER$<br />
LOGMNRT_IND$<br />
LOGMNRT_TS$<br />
LOGMNRT_ATTRCOL$<br />
LOGMNRT_COL$<br />
LOGMNRT_TAB$<br />
LOGMNRT_OBJ$<br />
LOGMNRT_DICTIONARY$<br />
LOGMNRT_SEED$<br />
AQ$_SCHEDULER$_EVENT_QTAB_I<br />
AQ$_SCHEDULER$_EVENT_QTAB_G<br />
TABLE_NAME<br />
------------------------------<br />
AQ$_SCHEDULER$_EVENT_QTAB_H<br />
AQ$_SCHEDULER$_EVENT_QTAB_T<br />
AQ$_SCHEDULER$_JOBQTAB_I<br />
AQ$_SCHEDULER$_JOBQTAB_G<br />
AQ$_SCHEDULER$_JOBQTAB_H<br />
AQ$_SCHEDULER$_JOBQTAB_T<br />
RULE_SET_ROP$<br />
RULE_SET_IOT$<br />
RULE_SET_PR$<br />
ODCI_WARNINGS$<br />
ODCI_SECOBJ$<br />
TABLE_NAME<br />
------------------------------<br />
WRI$_ADV_ASA_RECO_DATA<br />
PSTUBTBL<br />
CLUSTER_INSTANCES<br />
CLUSTER_NODES<br />
CLUSTER_DATABASES<br />
MAP_OBJECT<br />
ATEMPTAB$<br />
UTL_RECOMP_COMPILED<br />
UTL_RECOMP_SORTED<br />
669 rows selected.<br />
SQL><br />
SQL><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==User_tables structure==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> describe user_tables;<br />
Name Null? Type<br />
----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------<br />
TABLE_NAME NOT NULL VARCHAR2(30)<br />
TABLESPACE_NAME VARCHAR2(30)<br />
CLUSTER_NAME VARCHAR2(30)<br />
IOT_NAME VARCHAR2(30)<br />
STATUS VARCHAR2(8)<br />
PCT_FREE NUMBER<br />
PCT_USED NUMBER<br />
INI_TRANS NUMBER<br />
MAX_TRANS NUMBER<br />
INITIAL_EXTENT NUMBER<br />
NEXT_EXTENT NUMBER<br />
MIN_EXTENTS NUMBER<br />
MAX_EXTENTS NUMBER<br />
PCT_INCREASE NUMBER<br />
FREELISTS NUMBER<br />
FREELIST_GROUPS NUMBER<br />
LOGGING VARCHAR2(3)<br />
BACKED_UP VARCHAR2(1)<br />
NUM_ROWS NUMBER<br />
BLOCKS NUMBER<br />
EMPTY_BLOCKS NUMBER<br />
AVG_SPACE NUMBER<br />
CHAIN_CNT NUMBER<br />
AVG_ROW_LEN NUMBER<br />
AVG_SPACE_FREELIST_BLOCKS NUMBER<br />
NUM_FREELIST_BLOCKS NUMBER<br />
DEGREE VARCHAR2(10)<br />
INSTANCES VARCHAR2(10)<br />
CACHE VARCHAR2(5)<br />
TABLE_LOCK VARCHAR2(8)<br />
SAMPLE_SIZE NUMBER<br />
LAST_ANALYZED DATE<br />
PARTITIONED VARCHAR2(3)<br />
IOT_TYPE VARCHAR2(12)<br />
TEMPORARY VARCHAR2(1)<br />
SECONDARY VARCHAR2(1)<br />
NESTED VARCHAR2(3)<br />
BUFFER_POOL VARCHAR2(7)<br />
ROW_MOVEMENT VARCHAR2(8)<br />
GLOBAL_STATS VARCHAR2(3)<br />
USER_STATS VARCHAR2(3)<br />
DURATION VARCHAR2(15)<br />
SKIP_CORRUPT VARCHAR2(8)<br />
MONITORING VARCHAR2(3)<br />
CLUSTER_OWNER VARCHAR2(30)<br />
DEPENDENCIES VARCHAR2(8)<br />
COMPRESSION VARCHAR2(8)<br />
DROPPED VARCHAR2(3)<br />
SQL><br />
SQL> select table_name, tablespace_name<br />
2 from user_tables<br />
3 where rownum < 10<br />
4 order by table_name;<br />
TABLE_NAME TABLESPACE_NAME<br />
------------------------------ ------------------------------<br />
CCOL$ SYSTEM<br />
CDEF$ SYSTEM<br />
CON$ SYSTEM<br />
FET$ SYSTEM<br />
FILE$ SYSTEM<br />
PROXY_DATA$ SYSTEM<br />
PROXY_ROLE_DATA$ SYSTEM<br />
TS$ SYSTEM<br />
UNDO$ SYSTEM<br />
9 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Verify the creation of the statistics by running the following queries:==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> SELECT table_name FROM user_tables WHERE last_analyzed IS NULL;<br />
<br />
TABLE_NAME<br />
------------------------------<br />
WORKING_EMPLOYEES<br />
TEMP_TABLE<br />
EMPLOYEETEMPTABLE<br />
TMP<br />
PARMS<br />
WORKING_CUSTOMERS<br />
CUST_WITH_VARRAY_TEMP_TABLE<br />
7 rows selected.<br />
SQL><br />
SQL> SELECT index_name FROM user_indexes WHERE last_analyzed IS NULL;<br />
<br />
INDEX_NAME<br />
------------------------------<br />
SYS_C004799<br />
SYS_C008156<br />
HD_CLUSTER_INDEX<br />
3 rows selected.<br />
SQL><br />
<br />
<br />
<br />
<br />
</source></div>
Admin