home - keyword index

Keyword: TABLE

jump to Columns back to index

Tables

Table Name Description
ALL_ALL_TABLES Description of all object and relational tables accessible to the user
ALL_BASE_TABLE_MVIEWS All materialized views with log(s) in the database that the user can see
ALL_CAPTURE_PREPARED_TABLES All tables visible to the current user that are prepared for instantiation
ALL_EVALUATION_CONTEXT_TABLES tables in all rule evaluation contexts seen by the user
ALL_EXTERNAL_TABLES Description of the external tables accessible to the user
ALL_NESTED_TABLES Description of nested tables in tables accessible to the user
ALL_OBJECT_TABLES Description of all object tables accessible to the user
ALL_PART_TABLES
ALL_PENDING_CONV_TABLES All tables accessible to the user which are not upgraded to the latest type version
ALL_QUEUE_TABLES All queue tables accessible to the user
ALL_SOURCE_TABLES
ALL_SOURCE_TAB_COLUMNS
ALL_STREAMS_TABLE_RULES Rules created by streams administrative APIs on tables visible to the current user
ALL_SUBSCRIBED_TABLES
ALL_SUMMARY_DETAIL_TABLES
ALL_TABLES Description of relational tables accessible to the user
ALL_TAB_COLS Columns of user's tables, views and clusters
ALL_TAB_COLUMNS Columns of user's tables, views and clusters
ALL_TAB_COL_STATISTICS Columns of user's tables, views and clusters
ALL_TAB_COMMENTS Comments on tables and views accessible to the user
ALL_TAB_HISTOGRAMS Histograms on columns of all tables visible to user
ALL_TAB_MODIFICATIONS Information regarding modifications to tables
ALL_TAB_PARTITIONS
ALL_TAB_PRIVS Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ALL_TAB_PRIVS_MADE User's grants and grants on user's objects
ALL_TAB_PRIVS_RECD Grants on objects for which the user, PUBLIC or enabled role is the grantee
ALL_TAB_SUBPARTITIONS
DBA_ALL_TABLES Description of all object and relational tables in the database
DBA_BASE_TABLE_MVIEWS All materialized views with log(s) in the database
DBA_CACHEABLE_TABLES
DBA_CACHEABLE_TABLES_BASE
DBA_CAPTURE_PREPARED_TABLES All tables prepared for instantiation
DBA_EVALUATION_CONTEXT_TABLES tables in all rule evaluation contexts in the database
DBA_EXTERNAL_TABLES Description of the external tables accessible to the DBA
DBA_NESTED_TABLES Description of nested tables contained in all tables
DBA_OBJECT_TABLES Description of all object tables in the database
DBA_PART_TABLES
DBA_PENDING_CONV_TABLES All tables which are not upgraded to the latest type version in the database
DBA_QUEUE_TABLES All queue tables created in the database
DBA_SOURCE_TABLES
DBA_SOURCE_TAB_COLUMNS
DBA_STREAMS_TABLE_RULES Table rules created by streams administrative APIs
DBA_SUBSCRIBED_TABLES
DBA_SUMMARY_DETAIL_TABLES
DBA_TABLES Description of all relational tables in the database
DBA_TAB_COLS Columns of user's tables, views and clusters
DBA_TAB_COLUMNS Columns of user's tables, views and clusters
DBA_TAB_COL_STATISTICS Columns of user's tables, views and clusters
DBA_TAB_COMMENTS Comments on all tables and views in the database
DBA_TAB_HISTOGRAMS Histograms on columns of all tables
DBA_TAB_MODIFICATIONS Information regarding modifications to tables
DBA_TAB_PARTITIONS
DBA_TAB_PRIVS All grants on objects in the database
DBA_TAB_SUBPARTITIONS
GV$FIXED_TABLE Synonym for GV_$FIXED_TABLE
ROLE_TAB_PRIVS Table privileges granted to roles
TABLE_PRIVILEGES Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
USER_ALL_TABLES Description of all object and relational tables owned by the user's
USER_BASE_TABLE_MVIEWS All materialized views with log(s) owned by the user in the database
USER_EVALUATION_CONTEXT_TABLES tables in user rule evaluation contexts
USER_EXTERNAL_TABLES Description of the user's own external tables
USER_NESTED_TABLES Description of nested tables contained in the user's own tables
USER_OBJECT_TABLES Description of the user's own object tables
USER_PART_TABLES
USER_PENDING_CONV_TABLES All user's tables which are not upgraded to the latest type version
USER_QUEUE_TABLES All queue tables created by the user
USER_SOURCE_TABLES
USER_SOURCE_TAB_COLUMNS
USER_SUBSCRIBED_TABLES
USER_SUMMARY_DETAIL_TABLES
USER_TABLES Description of the user's own relational tables
USER_TAB_COLS Columns of user's tables, views and clusters
USER_TAB_COLUMNS Columns of user's tables, views and clusters
USER_TAB_COL_STATISTICS Columns of user's tables, views and clusters
USER_TAB_COMMENTS Comments on the tables and views owned by the user
USER_TAB_HISTOGRAMS Histograms on columns of user's tables
USER_TAB_MODIFICATIONS Information regarding modifications to tables
USER_TAB_PARTITIONS
USER_TAB_PRIVS Grants on objects for which the user is the owner, grantor or grantee
USER_TAB_PRIVS_MADE All grants on objects owned by the user
USER_TAB_PRIVS_RECD Grants on objects for which the user is the grantee
USER_TAB_SUBPARTITIONS
V$FIXED_TABLE Synonym for V_$FIXED_TABLE
top back to index

Columns

Column Name Description
BASE_TABLE (USER_RULESETS) name of the evaluation context for the rule set
BASE_TABLE (DBA_RULESETS) name of the evaluation context for the rule set
BASE_TABLE (ALL_RULESETS) name of the evaluation context for the rule set
CHANGE_TABLE_NAME (DBA_PUBLISHED_COLUMNS)
CHANGE_TABLE_SCHEMA (DBA_PUBLISHED_COLUMNS)
DEF_TAB_COMPRESSION (DBA_TABLESPACES) Default compression enabled or not: "ENABLED" or "DISABLED"
DEF_TAB_COMPRESSION (USER_TABLESPACES) Default table compression enabled or not: "ENABLED" or "DISABLED"
FIXED_TABLE_SEQUENCE (V$SESSION)
FIXED_TABLE_SEQUENCE (GV$SESSION)
INNER_TABLE_COLUMN (DBA_JOIN_IND_COLUMNS) Column name of inner table (table closer to the fact table)
INNER_TABLE_COLUMN (ALL_JOIN_IND_COLUMNS) Column name of inner table (table closer to the fact table)
INNER_TABLE_COLUMN (USER_JOIN_IND_COLUMNS) Column name of inner table (table closer to the fact table)
INNER_TABLE_NAME (USER_JOIN_IND_COLUMNS) Table name of inner table (table closer to the fact table)
INNER_TABLE_NAME (ALL_JOIN_IND_COLUMNS) Table name of inner table (table closer to the fact table)
INNER_TABLE_NAME (DBA_JOIN_IND_COLUMNS) Table name of inner table (table closer to the fact table)
INNER_TABLE_OWNER (ALL_JOIN_IND_COLUMNS) Table owner of inner table (table closer to the fact table)
INNER_TABLE_OWNER (DBA_JOIN_IND_COLUMNS) Table owner of inner table (table closer to the fact table)
INNER_TABLE_OWNER (USER_JOIN_IND_COLUMNS) Table owner of inner table (table closer to the fact table)
LOG_TABLE (DBA_SNAPSHOT_LOGS) Log table; with rowids and timestamps of rows which changed in the master
LOG_TABLE (USER_SNAPSHOT_LOGS) Log table; with rowids and timestamps of rows which changed in the master
LOG_TABLE (ALL_MVIEW_LOGS) Log table; with rowids and timestamps of rows which changed in the master
LOG_TABLE (DBA_MVIEW_LOGS) Log table; with rowids and timestamps of rows which changed in the master
LOG_TABLE (ALL_SNAPSHOT_LOGS) Log table; with rowids and timestamps of rows which changed in the master
LOG_TABLE (USER_MVIEW_LOGS) Log table; with rowids and timestamps of rows which changed in the master
MVIEW_TABLE_OWNER (ALL_MVIEW_ANALYSIS) Owner of the container table
MVIEW_TABLE_OWNER (USER_MVIEW_ANALYSIS) Owner of the container table
MVIEW_TABLE_OWNER (DBA_MVIEW_ANALYSIS) Owner of the container table
NESTED_TABLE (DBA_REPOBJECT) Storage table for a nested table column?
NESTED_TABLE (ALL_REPOBJECT) Storage table for a nested table column?
NESTED_TABLE (USER_REPOBJECT) Storage table for a nested table column?
OUTER_TABLE_COLUMN (ALL_JOIN_IND_COLUMNS) Column name of outer table (table closer to the fact table)
OUTER_TABLE_COLUMN (DBA_JOIN_IND_COLUMNS) Column name of outer table (table closer to the fact table)
OUTER_TABLE_COLUMN (USER_JOIN_IND_COLUMNS) Column name of outer table (table closer to the fact table)
OUTER_TABLE_NAME (DBA_JOIN_IND_COLUMNS) Table name of outer table (table closer to the fact table)
OUTER_TABLE_NAME (USER_JOIN_IND_COLUMNS) Table name of outer table (table closer to the fact table)
OUTER_TABLE_NAME (ALL_JOIN_IND_COLUMNS) Table name of outer table (table closer to the fact table)
OUTER_TABLE_OWNER (USER_JOIN_IND_COLUMNS) Table owner of outer table (table closer to the fact table)
OUTER_TABLE_OWNER (ALL_JOIN_IND_COLUMNS) Table owner of outer table (table closer to the fact table)
OUTER_TABLE_OWNER (DBA_JOIN_IND_COLUMNS) Table owner of outer table (table closer to the fact table)
PARAMETER_TABLE_NAME (DBA_REPPARAMETER_COLUMN) Name of the table to which the parameter column belongs
PARAMETER_TABLE_NAME (ALL_REPPARAMETER_COLUMN) Name of the table to which the parameter column belongs
PARAMETER_TABLE_NAME (USER_REPPARAMETER_COLUMN) Name of the table to which the parameter column belongs
PARENT_TABLE_COLUMN (DBA_NESTED_TABLES) Column name of the parent table that corresponds to the nested table
PARENT_TABLE_COLUMN (ALL_NESTED_TABLES) Column name of the parent table that corresponds to the nested table
PARENT_TABLE_COLUMN (ALL_VARRAYS) Column name of the parent table that corresponds to the varray
PARENT_TABLE_COLUMN (USER_NESTED_TABLES) Column name of the parent table that corresponds to the nested table
PARENT_TABLE_COLUMN (USER_VARRAYS) Column name of the parent table that corresponds to the varray
PARENT_TABLE_COLUMN (DBA_VARRAYS) Column name of the parent table that corresponds to the varray
PARENT_TABLE_NAME (DBA_VARRAYS) Name of the parent table containing the varray
PARENT_TABLE_NAME (USER_NESTED_TABLES) Name of the parent table containing the nested table
PARENT_TABLE_NAME (DBA_NESTED_TABLES) Name of the parent table containing the nested table
PARENT_TABLE_NAME (USER_VARRAYS) Name of the parent table containing the varray
PARENT_TABLE_NAME (ALL_NESTED_TABLES) Name of the parent table containing the nested table
PARENT_TABLE_NAME (ALL_VARRAYS) Name of the parent table containing the varray
QUEUE_TABLE (USER_QUEUES) Name of the table the queue data resides in
QUEUE_TABLE (DBA_QUEUE_TABLES) Name of the queue table
QUEUE_TABLE (ALL_QUEUES) Name of the table the queue data resides in
QUEUE_TABLE (DBA_QUEUES) Name of the table the queue data resides in
QUEUE_TABLE (ALL_QUEUE_TABLES) Name of the queue table
QUEUE_TABLE (USER_QUEUE_TABLES) Name of the queue table
RULESET_STORAGE_TABLE (ALL_RULESETS) name of the table to store rules in the ruleset
RULESET_STORAGE_TABLE (USER_RULESETS) name of the table to store rules in the ruleset
RULESET_STORAGE_TABLE (DBA_RULESETS) name of the table to store rules in the ruleset
SCOPE_TABLE_NAME (ALL_REFS) Name of the scope table, if it exists
SCOPE_TABLE_NAME (USER_REFS) Name of the scope table, if it exists
SCOPE_TABLE_NAME (DBA_REFS) Name of the scope table, if it exists
SCOPE_TABLE_OWNER (ALL_REFS) Owner of the scope table, if it exists
SCOPE_TABLE_OWNER (USER_REFS) Owner of the scope table, if it exists
SCOPE_TABLE_OWNER (DBA_REFS) Owner of the scope table, if it exists
SINGLE_TABLE (ALL_CLUSTERS) Whether the cluster can contain only a single table
SINGLE_TABLE (CLU) Whether the cluster can contain only a single table
SINGLE_TABLE (DBA_CLUSTERS) Whether the cluster can contain only a single table
SINGLE_TABLE (USER_CLUSTERS) Whether the cluster can contain only a single table
SOURCE_TABLE_NAME (USER_SUBSCRIBED_TABLES)
SOURCE_TABLE_NAME (ALL_PUBLISHED_COLUMNS)
SOURCE_TABLE_NAME (USER_PUBLISHED_COLUMNS)
SOURCE_TABLE_NAME (DBA_SOURCE_TAB_COLUMNS)
SOURCE_TABLE_NAME (DBA_SOURCE_TABLES)
SOURCE_TABLE_NAME (ALL_SOURCE_TAB_COLUMNS)
SOURCE_TABLE_NAME (ALL_SUBSCRIBED_TABLES)
SOURCE_TABLE_NAME (DBA_SUBSCRIBED_TABLES)
SOURCE_TABLE_NAME (USER_SUBSCRIBED_COLUMNS)
SOURCE_TABLE_NAME (DBA_SUBSCRIBED_COLUMNS)
SOURCE_TABLE_NAME (USER_SOURCE_TABLES)
SOURCE_TABLE_NAME (USER_SOURCE_TAB_COLUMNS)
SOURCE_TABLE_NAME (ALL_SUBSCRIBED_COLUMNS)
SOURCE_TABLE_NAME (ALL_SOURCE_TABLES)
SOURCE_TABLE_NAME (DBA_PUBLISHED_COLUMNS)
TABLE_ALIAS (ALL_EVALUATION_CONTEXT_TABLES) Alias of the table
TABLE_ALIAS (DBA_EVALUATION_CONTEXT_TABLES) Alias of the table
TABLE_ALIAS (USER_EVALUATION_CONTEXT_TABLES) Alias of the table
TABLE_LOCK (DBA_ALL_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (ALL_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (USER_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (DBA_OBJECT_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (ALL_OBJECT_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (DBA_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (USER_OBJECT_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (ALL_ALL_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (USER_ALL_TABLES) Whether table locking is enabled or disabled
TABLE_LOCK (TABS) Whether table locking is enabled or disabled
TABLE_NAME (USER_UNUSED_COL_TABS) Name of the table
TABLE_NAME (USER_TAB_COMMENTS) Name of the object
TABLE_NAME (DBA_IND_EXPRESSIONS) Table or cluster name
TABLE_NAME (USER_INDEXES) Name of the indexed object
TABLE_NAME (ALL_TAB_SUBPARTITIONS)
TABLE_NAME (USER_PART_LOBS)
TABLE_NAME (ALL_EXTERNAL_LOCATIONS) Name of the corresponding external table
TABLE_NAME (DBA_SYNONYMS) Name of the object referenced by the synonym
TABLE_NAME (DBA_EXTERNAL_LOCATIONS) Name of the corresponding external table
TABLE_NAME (USER_IND_EXPRESSIONS) Table or cluster name
TABLE_NAME (DBA_LOG_GROUP_COLUMNS) Name associated with table with log group definition
TABLE_NAME (USER_CATALOG) Name of the object
TABLE_NAME (ALL_COL_PRIVS_MADE) Name of the object
TABLE_NAME (ALL_LOG_GROUP_COLUMNS) Name associated with table with log group definition
TABLE_NAME (ALL_COL_COMMENTS) Name of the object
TABLE_NAME (ALL_OBJ_COLATTRS) Name of the table containing the object column or attribute
TABLE_NAME (DBA_PENDING_CONV_TABLES) Name of the table
TABLE_NAME (USER_ALL_TABLES) Name of the table
TABLE_NAME (DBA_PART_COL_STATISTICS)
TABLE_NAME (DBA_LOBS) Name of the table containing the LOB
TABLE_NAME (DBA_CONS_COLUMNS) Name associated with table with constraint definition
TABLE_NAME (ALL_PART_TABLES)
TABLE_NAME (USER_IND_COLUMNS) Table or cluster name
TABLE_NAME (DBA_LOB_PARTITIONS)
TABLE_NAME (ALL_EXTERNAL_TABLES) Name of the external table
TABLE_NAME (DBA_TRIGGER_COLS) Name of the table on which the trigger is defined
TABLE_NAME (DBA_PARTIAL_DROP_TABS) Name of the table
TABLE_NAME (USER_TAB_PRIVS_RECD) Name of the object
TABLE_NAME (USER_TAB_PRIVS) Name of the object
TABLE_NAME (USER_INTERNAL_TRIGGERS) Name of the table
TABLE_NAME (USER_TAB_HISTOGRAMS) Table name
TABLE_NAME (DBA_REFS) Name of the table containing the REF column
TABLE_NAME (ALL_TAB_COLUMNS) Table, view or cluster name
TABLE_NAME (GV$INDEXED_FIXED_COLUMN)
TABLE_NAME (DBA_NESTED_TABLES) Name of the nested table
TABLE_NAME (SYN) Name of the object referenced by the synonym
TABLE_NAME (ALL_LOB_PARTITIONS)
TABLE_NAME (ALL_PENDING_CONV_TABLES) Name of the table
TABLE_NAME (ALL_SUBPARTITION_TEMPLATES)
TABLE_NAME (DBA_INTERNAL_TRIGGERS) Name of the table
TABLE_NAME (DBA_CATALOG) Name of the object
TABLE_NAME (DBA_EVALUATION_CONTEXT_TABLES) Name of the table
TABLE_NAME (USER_OBJ_COLATTRS) Name of the table containing the object column or attribute
TABLE_NAME (USER_CONS_OBJ_COLUMNS) Name of the table containing the object column or attribute
TABLE_NAME (DBA_SUBPART_COL_STATISTICS)
TABLE_NAME (ALL_CATALOG) Name of the object
TABLE_NAME (ALL_TAB_COLS) Table, view or cluster name
TABLE_NAME (ALL_TAB_PRIVS_MADE) Name of the object
TABLE_NAME (DBA_TAB_COMMENTS) Name of the object
TABLE_NAME (DBA_TAB_PARTITIONS)
TABLE_NAME (V$INDEXED_FIXED_COLUMN)
TABLE_NAME (USER_PART_TABLES)
TABLE_NAME (DBA_EXTERNAL_TABLES) Name of the external table
TABLE_NAME (DBA_STREAMS_TABLE_RULES) Name of the table selected by this rule
TABLE_NAME (DBA_SUBPARTITION_TEMPLATES)
TABLE_NAME (ALL_SNAPSHOTS) Table the snapshot is stored in -- has an extra column for the master rowid
TABLE_NAME (USER_PART_HISTOGRAMS)
TABLE_NAME (DBA_ALL_TABLES) Name of the table
TABLE_NAME (DBA_TAB_PRIVS) Name of the object
TABLE_NAME (ALL_HISTOGRAMS) Table name
TABLE_NAME (ALL_PART_INDEXES)
TABLE_NAME (ALL_LOB_SUBPARTITIONS)
TABLE_NAME (USER_CLU_COLUMNS) Clustered table name
TABLE_NAME (ALL_TABLES) Name of the table
TABLE_NAME (USER_PART_COL_STATISTICS)
TABLE_NAME (USER_TRIGGERS) Name of the table that this trigger is associated with
TABLE_NAME (USER_COL_PRIVS_RECD) Name of the object
TABLE_NAME (DBA_TAB_MODIFICATIONS) Modified table
TABLE_NAME (ALL_LOG_GROUPS)
TABLE_NAME (USER_UPDATABLE_COLUMNS) Table name
TABLE_NAME (USER_HISTOGRAMS) Table name
TABLE_NAME (USER_TAB_COLUMNS) Table, view or cluster name
TABLE_NAME (USER_COL_PRIVS) Name of the object
TABLE_NAME (DBA_TAB_SUBPARTITIONS)
TABLE_NAME (ALL_TRIGGER_COLS) Name of the table on which the trigger is defined
TABLE_NAME (ALL_TRIGGERS) Name of the table that this trigger is associated with
TABLE_NAME (DBA_TAB_HISTOGRAMS) Table name
TABLE_NAME (COLS) Table, view or cluster name
TABLE_NAME (DBA_CONS_OBJ_COLUMNS) Name of the table containing the object column or attribute
TABLE_NAME (ALL_OBJECT_TABLES) Name of the table
TABLE_NAME (ALL_IND_EXPRESSIONS) Table or cluster name
TABLE_NAME (ALL_TAB_COL_STATISTICS) Table, view or cluster name
TABLE_NAME (USER_TAB_SUBPARTITIONS)
TABLE_NAME (DBA_UNUSED_COL_TABS) Name of the table
TABLE_NAME (DBA_PART_HISTOGRAMS)
TABLE_NAME (USER_CONSTRAINTS) Name associated with table with constraint definition
TABLE_NAME (USER_OBJECT_TABLES) Name of the table
TABLE_NAME (ALL_NESTED_TABLES) Name of the nested table
TABLE_NAME (USER_SYNONYMS) Name of the object referenced by the synonym
TABLE_NAME (ALL_CONS_COLUMNS) Name associated with table with constraint definition
TABLE_NAME (ALL_STREAMS_TABLE_RULES) Name of the table selected by this rule
TABLE_NAME (DBA_CAPTURE_PREPARED_TABLES) Name of the table prepared for instantiation
TABLE_NAME (ALL_IND_COLUMNS) Table or cluster name
TABLE_NAME (ALL_PART_COL_STATISTICS)
TABLE_NAME (USER_LOB_TEMPLATES)
TABLE_NAME (ALL_REFS) Name of the table containing the REF column
TABLE_NAME (ALL_TAB_COMMENTS) Name of the object
TABLE_NAME (USER_TAB_PRIVS_MADE) Name of the object
TABLE_NAME (DBA_CACHEABLE_TABLES)
TABLE_NAME (ALL_EVALUATION_CONTEXT_TABLES) Name of the table
TABLE_NAME (ALL_TAB_PRIVS_RECD) Name of the object
TABLE_NAME (USER_LOB_PARTITIONS)
TABLE_NAME (USER_PARTIAL_DROP_TABS) Name of the table
TABLE_NAME (USER_TAB_MODIFICATIONS) Modified table
TABLE_NAME (ALL_SYNONYMS) Name of the object referenced by the synonym
TABLE_NAME (DBA_LOB_TEMPLATES)
TABLE_NAME (DBA_INDEXES) Name of the indexed object
TABLE_NAME (DBA_OBJECT_TABLES) Name of the table
TABLE_NAME (DBA_TABLES) Name of the table
TABLE_NAME (USER_TAB_PARTITIONS)
TABLE_NAME (DBA_HISTOGRAMS) Table name
TABLE_NAME (ALL_SUBPART_COL_STATISTICS)
TABLE_NAME (ALL_REFRESH_DEPENDENCIES) Name of the dependent table
TABLE_NAME (USER_TABLES) Name of the table
TABLE_NAME (DBA_PART_INDEXES)
TABLE_NAME (USER_NESTED_TABLES) Name of the nested table
TABLE_NAME (USER_PENDING_CONV_TABLES) Name of the table
TABLE_NAME (USER_EXTERNAL_TABLES) Name of the external table
TABLE_NAME (ALL_LOBS) Name of the table containing the LOB
TABLE_NAME (USER_SUBPART_COL_STATISTICS)
TABLE_NAME (DBA_TAB_COLS) Table, view or cluster name
TABLE_NAME (DBA_IND_COLUMNS) Table or cluster name
TABLE_NAME (USER_LOBS) Name of the table containing the LOB
TABLE_NAME (ALL_TAB_HISTOGRAMS) Table name
TABLE_NAME (ALL_SUBPART_HISTOGRAMS)
TABLE_NAME (USER_LOG_GROUPS)
TABLE_NAME (DBA_PART_LOBS)
TABLE_NAME (USER_SUBPARTITION_TEMPLATES)
TABLE_NAME (DICT_COLUMNS) Name of the object that contains the column
TABLE_NAME (ALL_INTERNAL_TRIGGERS) Name of the table
TABLE_NAME (ALL_PART_LOBS)
TABLE_NAME (DBA_CONSTRAINTS) Name associated with table with constraint definition
TABLE_NAME (USER_COL_COMMENTS) Object name
TABLE_NAME (USER_SUBPART_HISTOGRAMS)
TABLE_NAME (DBA_TRIGGERS) Name of the table that this trigger is associated with
TABLE_NAME (ALL_CAPTURE_PREPARED_TABLES) Name of the table prepared for instantiation
TABLE_NAME (USER_TAB_COLS) Table, view or cluster name
TABLE_NAME (CAT) Name of the object
TABLE_NAME (DBA_LOGSTDBY_NOT_UNIQUE) Table name of the non-unique table
TABLE_NAME (ALL_COL_PRIVS_RECD) Name of the object
TABLE_NAME (ALL_TAB_PRIVS) Name of the object
TABLE_NAME (ALL_PARTIAL_DROP_TABS) Name of the table
TABLE_NAME (USER_TAB_COL_STATISTICS) Table, view or cluster name
TABLE_NAME (USER_EVALUATION_CONTEXT_TABLES) Name of the table
TABLE_NAME (DBA_LOG_GROUPS)
TABLE_NAME (USER_LOG_GROUP_COLUMNS) Name associated with table with log group definition
TABLE_NAME (DBA_CLU_COLUMNS) Clustered table name
TABLE_NAME (USER_REFS) Name of the table containing the REF column
TABLE_NAME (ALL_PART_HISTOGRAMS)
TABLE_NAME (ALL_CONS_OBJ_COLUMNS) Name of the table containing the object column or attribute
TABLE_NAME (USER_SNAPSHOTS) Table the snapshot is stored in -- has an extra column for the master rowid
TABLE_NAME (DBA_COL_COMMENTS) Name of the object
TABLE_NAME (ALL_ALL_TABLES) Name of the table
TABLE_NAME (ALL_TAB_MODIFICATIONS) Modified table
TABLE_NAME (USER_TRIGGER_COLS) Name of the table on which the trigger is defined
TABLE_NAME (DBA_OBJ_COLATTRS) Name of the table containing the object column or attribute
TABLE_NAME (USER_PART_INDEXES)
TABLE_NAME (TABS) Name of the table
TABLE_NAME (USER_CONS_COLUMNS) Name associated with table with constraint definition
TABLE_NAME (ALL_COL_PRIVS) Name of the object
TABLE_NAME (DBA_PART_TABLES)
TABLE_NAME (DBA_CACHEABLE_TABLES_BASE)
TABLE_NAME (ALL_INDEXES) Name of the indexed object
TABLE_NAME (ALL_CONSTRAINTS) Name associated with table with constraint definition
TABLE_NAME (ALL_LOB_TEMPLATES)
TABLE_NAME (ALL_TAB_PARTITIONS)
TABLE_NAME (DBA_TAB_COLUMNS) Table, view or cluster name
TABLE_NAME (USER_COL_PRIVS_MADE) Name of the object
TABLE_NAME (DICT) Name of the object
TABLE_NAME (IND) Name of the indexed object
TABLE_NAME (DBA_TAB_COL_STATISTICS) Table, view or cluster name
TABLE_NAME (DICTIONARY) Name of the object
TABLE_NAME (USER_LOB_SUBPARTITIONS)
TABLE_NAME (USER_EXTERNAL_LOCATIONS) Name of the corresponding external table
TABLE_NAME (DBA_UPDATABLE_COLUMNS) table name
TABLE_NAME (DBA_SUBPART_HISTOGRAMS)
TABLE_NAME (ALL_UNUSED_COL_TABS) Name of the table
TABLE_NAME (DBA_LOGSTDBY_UNSUPPORTED) Table name of unsupported column
TABLE_NAME (DBA_SNAPSHOTS) Table the snapshot is stored in -- has an extra column for the master rowid
TABLE_NAME (ALL_UPDATABLE_COLUMNS) Table name
TABLE_NAME (DBA_COL_PRIVS) Name of the object
TABLE_NAME (DBA_LOB_SUBPARTITIONS)
TABLE_NUM (V$FIXED_TABLE)
TABLE_NUM (GV$FIXED_TABLE)
TABLE_OWNER (DBA_TAB_MODIFICATIONS) Owner of modified table
TABLE_OWNER (ALL_INDEXES) Owner of the indexed object
TABLE_OWNER (DBA_CAPTURE_PREPARED_TABLES) Owner of the table prepared for instantiation
TABLE_OWNER (DBA_TAB_SUBPARTITIONS)
TABLE_OWNER (DBA_TAB_PARTITIONS)
TABLE_OWNER (DBA_STREAMS_TABLE_RULES) Owner of the table selected by this rule
TABLE_OWNER (USER_TRIGGER_COLS) Owner of the table
TABLE_OWNER (DBA_IND_EXPRESSIONS) Table or cluster owner
TABLE_OWNER (IND) Owner of the indexed object
TABLE_OWNER (ALL_PART_LOBS)
TABLE_OWNER (DBA_PART_LOBS)
TABLE_OWNER (DBA_TRIGGERS) Owner of the table that this trigger is associated with
TABLE_OWNER (ALL_CAPTURE_PREPARED_TABLES) Owner of the table prepared for instantiation
TABLE_OWNER (DBA_INDEXES) Owner of the indexed object
TABLE_OWNER (DBA_IND_COLUMNS) Table or cluster owner
TABLE_OWNER (DBA_LOB_PARTITIONS)
TABLE_OWNER (ALL_IND_EXPRESSIONS) Table or cluster owner
TABLE_OWNER (ALL_SYNONYMS) Owner of the object referenced by the synonym
TABLE_OWNER (ALL_STREAMS_TABLE_RULES) Owner of the table selected by this rule
TABLE_OWNER (USER_SYNONYMS) Owner of the object referenced by the synonym
TABLE_OWNER (ALL_LOB_SUBPARTITIONS)
TABLE_OWNER (DBA_SYNONYMS) Owner of the object referenced by the synonym
TABLE_OWNER (DBA_TRIGGER_COLS) Owner of the table
TABLE_OWNER (USER_INDEXES) Owner of the indexed object
TABLE_OWNER (ALL_TRIGGER_COLS) Owner of the table
TABLE_OWNER (ALL_TRIGGERS) Owner of the table that this trigger is associated with
TABLE_OWNER (ALL_TAB_PARTITIONS)
TABLE_OWNER (SYN) Owner of the object referenced by the synonym
TABLE_OWNER (ALL_TAB_SUBPARTITIONS)
TABLE_OWNER (USER_TRIGGERS) Owner of the table that this trigger is associated with
TABLE_OWNER (DBA_LOB_SUBPARTITIONS)
TABLE_OWNER (ALL_TAB_MODIFICATIONS) Owner of modified table
TABLE_OWNER (ALL_LOB_PARTITIONS)
TABLE_OWNER (ALL_IND_COLUMNS) Table or cluster owner
TABLE_SCHEMA (ALL_COL_PRIVS) Schema of the object
TABLE_SCHEMA (ALL_TAB_PRIVS) Schema of the object
TABLE_SPACE (GV$LOGMNR_CONTENTS)
TABLE_SPACE (V$LOGMNR_CONTENTS)
TABLE_TYPE (DBA_OBJECT_TABLES) Type of the table if the table is an object table
TABLE_TYPE (DBA_ALL_TABLES) Type of the table if the table is an object table
TABLE_TYPE (USER_INDEXES) Type of the indexed object
TABLE_TYPE (ALL_OBJECT_TABLES) Type of the table if the table is an object table
TABLE_TYPE (DBA_INDEXES) Type of the indexed object
TABLE_TYPE (USER_ALL_TABLES) Type of the table if the table is an object table
TABLE_TYPE (DBA_CATALOG) Type of the object
TABLE_TYPE (USER_CATALOG) Type of the object
TABLE_TYPE (CAT) Type of the object
TABLE_TYPE (USER_TAB_COMMENTS) Type of the object: "TABLE" or "VIEW"
TABLE_TYPE (ALL_ALL_TABLES) Type of the table if the table is an object table
TABLE_TYPE (ALL_TAB_COMMENTS) Type of the object
TABLE_TYPE (ALL_INDEXES) Type of the indexed object
TABLE_TYPE (USER_OBJECT_TABLES) Type of the table if the table is an object table
TABLE_TYPE (DBA_TAB_COMMENTS) Type of the object
TABLE_TYPE (ALL_CATALOG) Type of the object
TABLE_TYPE (IND) Type of the indexed object
TABLE_TYPE_NAME (ALL_NESTED_TABLES) Name of the type of the nested table
TABLE_TYPE_NAME (DBA_NESTED_TABLES) Name of the type of the nested table
TABLE_TYPE_NAME (USER_NESTED_TABLES) Name of the type of the nested table
TABLE_TYPE_OWNER (USER_ALL_TABLES) Owner of the type of the table if the table is an object table
TABLE_TYPE_OWNER (DBA_ALL_TABLES) Owner of the type of the table if the table is an object table
TABLE_TYPE_OWNER (USER_OBJECT_TABLES) Owner of the type of the table if the table is an object table
TABLE_TYPE_OWNER (ALL_ALL_TABLES) Owner of the type of the table if the table is an object table
TABLE_TYPE_OWNER (ALL_OBJECT_TABLES) Owner of the type of the table if the table is an object table
TABLE_TYPE_OWNER (DBA_NESTED_TABLES) Owner of the type of which the nested table was created
TABLE_TYPE_OWNER (ALL_NESTED_TABLES) Owner of the type of which the nested table was created
TABLE_TYPE_OWNER (USER_NESTED_TABLES) Owner of the type of which the nested table was created
TABLE_TYPE_OWNER (DBA_OBJECT_TABLES) Owner of the type of the table if the table is an object table
TAB_COLUMN_NAME (USER_CLU_COLUMNS) Key column or attribute of object column in the table
TAB_COLUMN_NAME (DBA_CLU_COLUMNS) Key column or attribute of object column in the table
UNKNOWN_EXTERNAL_TABLE (USER_MVIEWS) Indicates if the materialized view contains external tables
UNKNOWN_EXTERNAL_TABLE (ALL_MVIEWS) Indicates if the materialized view contains external tables
UNKNOWN_EXTERNAL_TABLE (DBA_MVIEWS) Indicates if the materialized view contains external tables
top back to index

Comment on this page:




home - keyword index