WEB REPORTS

Table comments OWNER = SYS and COMMENTS like %  23.10.2002 14:39

Result
OWNER
sort asc
TABLE_NAME
sort asc
TABLE_TYPE
sort asc
COMMENTS
sort asc
SYS
ALL_ALL_TABLES
VIEW
Description of all object and relational tables accessible to the user
SYS
ALL_ARGUMENTS
VIEW
Arguments in object accessible to the user
SYS
ALL_ASSOCIATIONS
VIEW
All associations available to the user
SYS
ALL_CATALOG
VIEW
All tables, views, synonyms, sequences accessible to the user
SYS
ALL_CLUSTERS
VIEW
Description of clusters accessible to the user
SYS
ALL_CLUSTER_HASH_EXPRESSIONS
VIEW
Hash functions for all accessible clusters
SYS
ALL_COLL_TYPES
VIEW
Description of named collection types accessible to the user
SYS
ALL_COL_COMMENTS
VIEW
Comments on columns of accessible tables and views
SYS
ALL_COL_PRIVS
VIEW
Grants on columns for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
SYS
ALL_COL_PRIVS_MADE
VIEW
Grants on columns for which the user is owner or grantor
SYS
ALL_COL_PRIVS_RECD
VIEW
Grants on columns for which the user, PUBLIC or enabled role is the grantee
SYS
ALL_CONSTRAINTS
VIEW
Constraint definitions on accessible tables
SYS
ALL_CONS_COLUMNS
VIEW
Information about accessible columns in constraint definitions
SYS
ALL_CONTEXT
VIEW
Description of all active context namespaces under the current session
SYS
ALL_DB_LINKS
VIEW
Database links accessible to the user
SYS
ALL_DEF_AUDIT_OPTS
VIEW
Auditing options for newly created objects
SYS
ALL_DEPENDENCIES
VIEW
Dependencies to and from objects accessible to the user
SYS
ALL_DIMENSIONS
VIEW
Description of the dimension objects accessible to the DBA
SYS
ALL_DIM_ATTRIBUTES
VIEW
Representation of the relationship between a dimension level and
a functionally dependent column
SYS
ALL_DIM_CHILD_OF
VIEW
Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension
SYS
ALL_DIM_HIERARCHIES
VIEW
Representation of a dimension hierarchy
SYS
ALL_DIM_JOIN_KEY
VIEW
Representation of a join between two dimension tables.
SYS
ALL_DIM_LEVELS
VIEW
Description of dimension levels visible to DBA
SYS
ALL_DIM_LEVEL_KEY
VIEW
Representations of columns of a dimension level
SYS
ALL_DIRECTORIES
VIEW
Description of all directories accessible to the user
SYS
ALL_ERRORS
VIEW
Current errors on stored objects that user is allowed to create
SYS
ALL_INDEXES
VIEW
Descriptions of indexes on tables accessible to the user
SYS
ALL_INDEXTYPES
VIEW
All indextypes available to the user
SYS
ALL_INDEXTYPE_OPERATORS
VIEW
All operators available to the user
SYS
ALL_IND_COLUMNS
VIEW
COLUMNs comprising INDEXes on accessible TABLES
SYS
ALL_IND_EXPRESSIONS
VIEW
FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
SYS
ALL_INTERNAL_TRIGGERS
VIEW
Description of the internal triggers on the tables accessible to the user
SYS
ALL_LIBRARIES
VIEW
Description of libraries accessible to the user
SYS
ALL_LOBS
VIEW
Description of LOBs contained in tables accessible to the user
SYS
ALL_METHOD_PARAMS
VIEW
Description of method parameters of types accessible
to the user
SYS
ALL_METHOD_RESULTS
VIEW
Description of method results of types accessible
to the user
SYS
ALL_MVIEWS
VIEW
All materialized views in the database
SYS
ALL_MVIEW_AGGREGATES
VIEW
Description of the materialized view aggregates accessible to the user
SYS
ALL_MVIEW_ANALYSIS
VIEW
Description of the materialized views accessible to the user
SYS
ALL_MVIEW_DETAIL_RELATIONS
VIEW
Description of the materialized view detail tables accessible to the user
SYS
ALL_MVIEW_JOINS
VIEW
Description of a join between two columns in the
WHERE clause of a materialized view accessible to the user
SYS
ALL_MVIEW_KEYS
VIEW
Description of the columns that appear in the GROUP BY
list of a materialized view accessible to the user
SYS
ALL_NESTED_TABLES
VIEW
Description of nested tables in tables accessible to the user
SYS
ALL_OBJECTS
VIEW
Objects accessible to the user
SYS
ALL_OBJECT_TABLES
VIEW
Description of all object tables accessible to the user
SYS
ALL_OPANCILLARY
VIEW
All ancillary operators available to the user
SYS
ALL_OPARGUMENTS
VIEW
All arguments of the operators available to the user
SYS
ALL_OPBINDINGS
VIEW
All binding functions for operators available to the user
SYS
ALL_OPERATORS
VIEW
All operators available to the user
SYS
ALL_PARTIAL_DROP_TABS
VIEW
All tables with patially dropped columns accessible to the user
SYS
ALL_POLICIES
VIEW
All policies for objects if the user has system privileges or owns the objects
SYS
ALL_QUEUES
VIEW
All queues accessible to the user
SYS
ALL_QUEUE_TABLES
VIEW
All queue tables accessible to the user
SYS
ALL_REFRESH
VIEW
All the refresh groups that the user can touch
SYS
ALL_REFRESH_CHILDREN
VIEW
All the objects in refresh groups, where the user can touch the group
SYS
ALL_REFRESH_DEPENDENCIES
VIEW
Description of the detail tables that materialized views depend on for
refresh
SYS
ALL_REFS
VIEW
Description of REF columns contained in tables accessible to the user
SYS
ALL_REGISTERED_SNAPSHOTS
VIEW
Remote snapshots of local tables that the user can see
SYS
ALL_REPAUDIT_ATTRIBUTE
VIEW
Information about attributes automatically maintained for replication
SYS
ALL_REPAUDIT_COLUMN
VIEW
Information about columns in all shadow tables for replicated tables which are accessible to the user
SYS
ALL_REPCATLOG
VIEW
Information about asynchronous administration requests
SYS
ALL_REPCOLUMN
VIEW
Replicated columns for a table sorted alphabetically in ascending order
SYS
ALL_REPCOLUMN_GROUP
VIEW
All column groups of replicated tables which are accessible to the user
SYS
ALL_REPCONFLICT
VIEW
All conflicts with available resolutions for user's replicated tables
SYS
ALL_REPDDL
VIEW
Arguments that do not fit in a single repcat log record
SYS
ALL_REPFLAVORS
VIEW
Flavors defined for replicated object groups
SYS
ALL_REPFLAVOR_COLUMNS
VIEW
Replicated columns in flavors
SYS
ALL_REPFLAVOR_OBJECTS
VIEW
Replicated objects in flavors
SYS
ALL_REPGENERATED
VIEW
Objects generated to support replication
SYS
ALL_REPGENOBJECTS
VIEW
Objects generated to support replication
SYS
ALL_REPGROUP
VIEW
Information about replicated object groups
SYS
ALL_REPGROUPED_COLUMN
VIEW
Columns in the all column groups of replicated tables which are accessible to the user
SYS
ALL_REPGROUP_PRIVILEGES
VIEW
Information about users who are registered for object group privileges
SYS
ALL_REPKEY_COLUMNS
VIEW
Primary columns for a table using column-level replication
SYS
ALL_REPOBJECT
VIEW
Information about replicated objects
SYS
ALL_REPPARAMETER_COLUMN
VIEW
All columns used for resolving conflicts in replicated tables which are accessible to the user
SYS
ALL_REPPRIORITY
VIEW
Values and their corresponding priorities in all priority groups which are accessible to the user
SYS
ALL_REPPRIORITY_GROUP
VIEW
Information about all priority groups which are accessible to the user
SYS
ALL_REPPROP
VIEW
Propagation information about replicated objects
SYS
ALL_REPRESOLUTION
VIEW
Description of all conflict resolutions for replicated tables which are accessible to the user
SYS
ALL_REPRESOLUTION_METHOD
VIEW
All conflict resolution methods accessible to the user
SYS
ALL_REPRESOLUTION_STATISTICS
VIEW
Statistics for conflict resolutions for replicated tables which are accessible to the user
SYS
ALL_REPRESOL_STATS_CONTROL
VIEW
Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
SYS
ALL_REPSCHEMA
VIEW
N-way replication information
SYS
ALL_REPSITES
VIEW
N-way replication information
SYS
ALL_SEQUENCES
VIEW
Description of SEQUENCEs accessible to the user
SYS
ALL_SNAPSHOTS
VIEW
Snapshots the user can access
SYS
ALL_SNAPSHOT_LOGS
VIEW
All snapshot logs in the database that the user can see
SYS
ALL_SNAPSHOT_REFRESH_TIMES
VIEW
Snapshots and their last refresh times for each master table that the user can look at
SYS
ALL_SOURCE
VIEW
Current source on stored objects that user is allowed to create
SYS
ALL_SUMDELTA
VIEW
Direct path load entries accessible to the user
SYS
ALL_SUMMARIES
VIEW
Description of the summaries accessible to the user
SYS
ALL_SYNONYMS
VIEW
All synonyms accessible to the user
SYS
ALL_TABLES
VIEW
Description of relational tables accessible to the user
SYS
ALL_TAB_COLUMNS
VIEW
Columns of user's tables, views and clusters
SYS
ALL_TAB_COL_STATISTICS
VIEW
Columns of user's tables, views and clusters
SYS
ALL_TAB_COMMENTS
VIEW
Comments on tables and views accessible to the user
SYS
ALL_TAB_HISTOGRAMS
VIEW
Histograms on columns of all tables visible to user
SYS
ALL_TAB_MODIFICATIONS
VIEW
Information regarding modifications to tables
SYS
ALL_TAB_PRIVS
VIEW
Grants on objects for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
SYS
ALL_TAB_PRIVS_MADE
VIEW
User's grants and grants on user's objects
SYS
ALL_TAB_PRIVS_RECD
VIEW
Grants on objects for which the user, PUBLIC or enabled role is the grantee
SYS
ALL_TRIGGERS
VIEW
Triggers accessible to the current user
SYS
ALL_TRIGGER_COLS
VIEW
Column usage in user's triggers or in triggers on user's tables
SYS
ALL_TYPES
VIEW
Description of types accessible to the user
SYS
ALL_TYPE_ATTRS
VIEW
Description of attributes of types accessible to the user
SYS
ALL_TYPE_METHODS
VIEW
Description of methods of types accessible to the user
SYS
ALL_UNUSED_COL_TABS
VIEW
All tables with unused columns accessible to the user
SYS
ALL_UPDATABLE_COLUMNS
VIEW
Description of all updatable columns
SYS
ALL_USERS
VIEW
Information about all users of the database
SYS
ALL_USTATS
VIEW
All statistics
SYS
ALL_VARRAYS
VIEW
Description of varrays in tables accessible to the user
SYS
ALL_VIEWS
VIEW
Description of views accessible to the user
SYS
ATEMPTAB$
TABLE
Temporary table whose definition is used internally. Never contains data
SYS
AUDIT_ACTIONS
TABLE
Description table for audit trail action type codes. Maps action type numbers to action type names
SYS
COLUMN_PRIVILEGES
VIEW
Grants on columns for which the user is the grantor, grantee, owner, or
an enabled role or PUBLIC is the grantee
SYS
DATABASE_COMPATIBLE_LEVEL
VIEW
Database compatible parameter set via init.ora
SYS
DBA_2PC_NEIGHBORS
VIEW
information about incoming and outgoing connections for pending transactions
SYS
DBA_2PC_PENDING
VIEW
info about distributed transactions awaiting recovery
SYS
DBA_ALL_TABLES
VIEW
Description of all object and relational tables in the database
SYS
DBA_ASSOCIATIONS
VIEW
All associations
SYS
DBA_AUDIT_EXISTS
VIEW
Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
SYS
DBA_AUDIT_OBJECT
VIEW
Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user
SYS
DBA_AUDIT_SESSION
VIEW
All audit trail records concerning CONNECT and DISCONNECT
SYS
DBA_AUDIT_STATEMENT
VIEW
Audit trail records concerning grant, revoke, audit, noaudit and alter system
SYS
DBA_AUDIT_TRAIL
VIEW
All audit trail entries
SYS
DBA_CATALOG
VIEW
All database Tables, Views, Synonyms, Sequences
SYS
DBA_CLUSTERS
VIEW
Description of all clusters in the database
SYS
DBA_CLUSTER_HASH_EXPRESSIONS
VIEW
Hash functions for all clusters
SYS
DBA_CLU_COLUMNS
VIEW
Mapping of table columns to cluster columns
SYS
DBA_COLL_TYPES
VIEW
Description of all named collection types in the database
SYS
DBA_COL_COMMENTS
VIEW
Comments on columns of all tables and views
SYS
DBA_COL_PRIVS
VIEW
All grants on columns in the database
SYS
DBA_CONSTRAINTS
VIEW
Constraint definitions on all tables
SYS
DBA_CONS_COLUMNS
VIEW
Information about accessible columns in constraint definitions
SYS
DBA_CONTEXT
VIEW
Description of all context namespace information
SYS
DBA_DATA_FILES
VIEW
Information about database data files
SYS
DBA_DB_LINKS
VIEW
All database links in the database
SYS
DBA_DEPENDENCIES
VIEW
Dependencies to and from objects
SYS
DBA_DIMENSIONS
VIEW
Description of the dimension objects accessible to the DBA
SYS
DBA_DIM_ATTRIBUTES
VIEW
Representation of the relationship between a dimension level and
a functionally dependent column
SYS
DBA_DIM_CHILD_OF
VIEW
Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension
SYS
DBA_DIM_HIERARCHIES
VIEW
Representation of a dimension hierarchy
SYS
DBA_DIM_JOIN_KEY
VIEW
Representation of a join between two dimension tables.
SYS
DBA_DIM_LEVELS
VIEW
Description of dimension levels visible to DBA
SYS
DBA_DIM_LEVEL_KEY
VIEW
Representations of columns of a dimension level
SYS
DBA_DIRECTORIES
VIEW
Description of all directories
SYS
DBA_DMT_FREE_SPACE
VIEW
Free extents in all dictionary managed tablespaces
SYS
DBA_DMT_USED_EXTENTS
VIEW
All extents in the dictionary managed tablespaces
SYS
DBA_ERRORS
VIEW
Current errors on all stored objects in the database
SYS
DBA_EXP_FILES
VIEW
Description of export files
SYS
DBA_EXP_OBJECTS
VIEW
Objects that have been incrementally exported
SYS
DBA_EXP_VERSION
VIEW
Version number of the last export session
SYS
DBA_EXTENTS
VIEW
Extents comprising all segments in the database
SYS
DBA_FREE_SPACE
VIEW
Free extents in all tablespaces
SYS
DBA_FREE_SPACE_COALESCED
VIEW
Statistics on Coalesced Space in Tablespaces
SYS
DBA_INDEXES
VIEW
Description for all indexes in the database
SYS
DBA_INDEXTYPES
VIEW
All indextypes
SYS
DBA_INDEXTYPE_OPERATORS
VIEW
All indextype operators
SYS
DBA_IND_COLUMNS
VIEW
COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
SYS
DBA_IND_EXPRESSIONS
VIEW
FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
SYS
DBA_INTERNAL_TRIGGERS
VIEW
Description of the internal triggers on all tables in the database
SYS
DBA_JAVA_POLICY
VIEW
java security Permissions for all users
SYS
DBA_JOBS
VIEW
All jobs in the database
SYS
DBA_JOBS_RUNNING
VIEW
All jobs in the database which are currently running, join v$lock and job$
SYS
DBA_LIBRARIES
VIEW
Description of all libraries in the database
SYS
DBA_LMT_FREE_SPACE
VIEW
Free extents in all locally managed tablespaces
SYS
DBA_LMT_USED_EXTENTS
VIEW
All extents in the locally managed tablespaces
SYS
DBA_LOBS
VIEW
Description of LOBs contained in all tables
SYS
DBA_METHOD_PARAMS
VIEW
Description of method parameters of all types in the database
SYS
DBA_METHOD_RESULTS
VIEW
Description of method results of all types in the database
SYS
DBA_MVIEWS
VIEW
All materialized views in the database
SYS
DBA_MVIEW_AGGREGATES
VIEW
Description of the materialized view aggregates accessible to dba
SYS
DBA_MVIEW_ANALYSIS
VIEW
Description of the materialized views accessible to dba
SYS
DBA_MVIEW_DETAIL_RELATIONS
VIEW
Description of the materialized view detail tables accessible to dba
SYS
DBA_MVIEW_JOINS
VIEW
Description of a join between two columns in the
WHERE clause of a materialized view accessible to dba
SYS
DBA_MVIEW_KEYS
VIEW
Description of the columns that appear in the GROUP BY
list of a materialized view accessible to dba
SYS
DBA_NESTED_TABLES
VIEW
Description of nested tables contained in all tables
SYS
DBA_OBJECTS
VIEW
All objects in the database
SYS
DBA_OBJECT_SIZE
VIEW
Sizes, in bytes, of various pl/sql objects
SYS
DBA_OBJECT_TABLES
VIEW
Description of all object tables in the database
SYS
DBA_OBJ_AUDIT_OPTS
VIEW
Auditing options for all tables and views
SYS
DBA_OPANCILLARY
VIEW
All ancillary operators
SYS
DBA_OPARGUMENTS
VIEW
All operator arguments
SYS
DBA_OPBINDINGS
VIEW
All operator binding functiosn or methods
SYS
DBA_OPERATORS
VIEW
All operators
SYS
DBA_OUTLINES
VIEW
Stored outlines
SYS
DBA_OUTLINE_HINTS
VIEW
Hints stored in outlines
SYS
DBA_PARTIAL_DROP_TABS
VIEW
All tables with partially dropped columns in the database
SYS
DBA_PENDING_TRANSACTIONS
VIEW
information about unresolved global transactions
SYS
DBA_POLICIES
VIEW
All row level security policies in the database
SYS
DBA_PRIV_AUDIT_OPTS
VIEW
Describes current system privileges being audited across the system and by user
SYS
DBA_PROFILES
VIEW
Display all profiles and their limits
SYS
DBA_QUEUES
VIEW
All database queues
SYS
DBA_QUEUE_TABLES
VIEW
All queue tables created in the database
SYS
DBA_RCHILD
VIEW
All the children in any refresh group. This view is not a join.
SYS
DBA_REFRESH
VIEW
All the refresh groups
SYS
DBA_REFRESH_CHILDREN
VIEW
All the objects in refresh groups
SYS
DBA_REFS
VIEW
Description of REF columns contained in all tables
SYS
DBA_REGISTERED_SNAPSHOTS
VIEW
Remote snapshots of local tables
SYS
DBA_REGISTERED_SNAPSHOT_GROUPS
VIEW
Snapshot repgroup registration information
SYS
DBA_REPAUDIT_ATTRIBUTE
VIEW
Information about attributes automatically maintained for replication
SYS
DBA_REPAUDIT_COLUMN
VIEW
Information about columns in all shadow tables for all replicated tables in the database
SYS
DBA_REPCATLOG
VIEW
Information about asynchronous administration requests
SYS
DBA_REPCOLUMN
VIEW
Replicated columns for a table sorted alphabetically in ascending order
SYS
DBA_REPCOLUMN_GROUP
VIEW
All column groups of replicated tables in the database
SYS
DBA_REPCONFLICT
VIEW
All conflicts for which users have specified resolutions in the database
SYS
DBA_REPDDL
VIEW
Arguments that do not fit in a single repcat log record
SYS
DBA_REPFLAVORS
VIEW
Flavors defined for replicated object groups
SYS
DBA_REPFLAVOR_COLUMNS
VIEW
Replicated columns in flavors
SYS
DBA_REPFLAVOR_OBJECTS
VIEW
Replicated objects in flavors
SYS
DBA_REPGENERATED
VIEW
Objects generated to support replication
SYS
DBA_REPGENOBJECTS
VIEW
Objects generated to support replication
SYS
DBA_REPGROUP
VIEW
Information about all replicated object groups
SYS
DBA_REPGROUPED_COLUMN
VIEW
Columns in the all column groups of replicated tables in the database
SYS
DBA_REPGROUP_PRIVILEGES
VIEW
Information about users who are registered for object group privileges
SYS
DBA_REPKEY_COLUMNS
VIEW
Primary columns for a table using column-level replication
SYS
DBA_REPOBJECT
VIEW
Information about replicated objects
SYS
DBA_REPPARAMETER_COLUMN
VIEW
All columns used for resolving conflicts in the database
SYS
DBA_REPPRIORITY
VIEW
Values and their corresponding priorities in all priority groups in the database
SYS
DBA_REPPRIORITY_GROUP
VIEW
Information about all priority groups in the database
SYS
DBA_REPPROP
VIEW
Propagation information about replicated objects
SYS
DBA_REPRESOLUTION
VIEW
Description of all conflict resolutions in the database
SYS
DBA_REPRESOLUTION_METHOD
VIEW
All conflict resolution methods in the database
SYS
DBA_REPRESOLUTION_STATISTICS
VIEW
Statistics for conflict resolutions for all replicated tables in the database
SYS
DBA_REPRESOL_STATS_CONTROL
VIEW
Information about statistics collection for conflict resolutions for all replicated tables in the database
SYS
DBA_REPSCHEMA
VIEW
N-way replication information
SYS
DBA_REPSITES
VIEW
N-way replication information
SYS
DBA_RGROUP
VIEW
All refresh groups. This view is not a join.
SYS
DBA_ROLES
VIEW
All Roles which exist in the database
SYS
DBA_ROLE_PRIVS
VIEW
Roles granted to users and roles
SYS
DBA_ROLLBACK_SEGS
VIEW
Description of rollback segments
SYS
DBA_RSRC_CONSUMER_GROUPS
VIEW
all the resource consumer groups
SYS
DBA_RSRC_CONSUMER_GROUP_PRIVS
VIEW
Switch privileges for consumer groups
SYS
DBA_RSRC_MANAGER_SYSTEM_PRIVS
VIEW
system privileges for the resource manager
SYS
DBA_RSRC_PLANS
VIEW
All the resource plans
SYS
DBA_RSRC_PLAN_DIRECTIVES
VIEW
all the resource plan directives
SYS
DBA_RULESETS
VIEW
All rulesets in the database
SYS
DBA_SEGMENTS
VIEW
Storage allocated for all database segments
SYS
DBA_SEQUENCES
VIEW
Description of all SEQUENCEs in the database
SYS
DBA_SNAPSHOTS
VIEW
All snapshots in the database
SYS
DBA_SNAPSHOT_LOGS
VIEW
All snapshot logs in the database
SYS
DBA_SNAPSHOT_LOG_FILTER_COLS
VIEW
All filter columns (excluding PK cols) being logged in the snapshot logs
SYS
DBA_SNAPSHOT_REFRESH_TIMES
VIEW
All fast refreshable snapshots and their last refresh times for each master table
SYS
DBA_SOURCE
VIEW
Source of all stored objects in the database
SYS
DBA_STMT_AUDIT_OPTS
VIEW
Describes current system auditing options across the system and by user
SYS
DBA_SUMMARIES
VIEW
Description of the summaries accessible to dba
SYS
DBA_SYNONYMS
VIEW
All synonyms in the database
SYS
DBA_SYS_PRIVS
VIEW
System privileges granted to users and roles
SYS
DBA_TABLES
VIEW
Description of all relational tables in the database
SYS
DBA_TABLESPACES
VIEW
Description of all tablespaces
SYS
DBA_TAB_COLUMNS
VIEW
Columns of user's tables, views and clusters
SYS
DBA_TAB_COL_STATISTICS
VIEW
Columns of user's tables, views and clusters
SYS
DBA_TAB_COMMENTS
VIEW
Comments on all tables and views in the database
SYS
DBA_TAB_HISTOGRAMS
VIEW
Histograms on columns of all tables
SYS
DBA_TAB_MODIFICATIONS
VIEW
Information regarding modifications to tables
SYS
DBA_TAB_PRIVS
VIEW
All grants on objects in the database
SYS
DBA_TEMP_FILES
VIEW
Information about database temp files
SYS
DBA_TRIGGERS
VIEW
All triggers in the database
SYS
DBA_TRIGGER_COLS
VIEW
Column usage in all triggers
SYS
DBA_TS_QUOTAS
VIEW
Tablespace quotas for all users
SYS
DBA_TYPES
VIEW
Description of all types in the database
SYS
DBA_TYPE_ATTRS
VIEW
Description of attributes of all types in the database
SYS
DBA_TYPE_METHODS
VIEW
Description of methods of all types in the database
SYS
DBA_UNUSED_COL_TABS
VIEW
All tables with unused columns in the database
SYS
DBA_UPDATABLE_COLUMNS
VIEW
Description of dba updatable columns
SYS
DBA_USERS
VIEW
Information about all users of the database
SYS
DBA_USTATS
VIEW
All statistics collected on either tables or indexes
SYS
DBA_VARRAYS
VIEW
Description of varrays in tables accessible to the user
SYS
DBA_VIEWS
VIEW
Description of all views in the database
SYS
DEFCALL
VIEW
Information about all deferred remote procedure calls
SYS
DEFCALLDEST
VIEW
Information about call destinations for deferred transactions
SYS
DEFDEFAULTDEST
VIEW
Default destinations for deferred remote procedure calls
SYS
DEFERRCOUNT
VIEW
Summary information about deferred transactions that caused an error
SYS
DEFERROR
VIEW
Information about all deferred transactions that caused an error
SYS
DEFLOB
VIEW
Storage for LOB parameters to deferred RPCs
SYS
DEFPROPAGATOR
VIEW
Information about the propagator for all deferred remote procedure calls
SYS
DEFSCHEDULE
VIEW
Information about propagation to different destinations
SYS
DEFTRAN
VIEW
Information about all deferred transactions
SYS
DICTIONARY
VIEW
Description of data dictionary tables and views
SYS
DICT_COLUMNS
VIEW
Description of columns in data dictionary tables and views
SYS
FILEXT$
VIEW
Information about extensible files
SYS
GLOBAL_NAME
VIEW
global database name
SYS
INDEX_HISTOGRAM
VIEW
statistics on keys with repeat count
SYS
INDEX_STATS
VIEW
statistics on the b-tree
SYS
NLS_DATABASE_PARAMETERS
VIEW
Permanent NLS parameters of the database
SYS
NLS_INSTANCE_PARAMETERS
VIEW
NLS parameters of the instance
SYS
NLS_SESSION_PARAMETERS
VIEW
NLS parameters of the user session
SYS
PRODUCT_COMPONENT_VERSION
VIEW
version and status information for component products
SYS
PROXY_USERS
VIEW
Describes users who can assume the identity of other users
SYS
PUBLIC_DEPENDENCY
VIEW
Dependencies to and from objects, by object number
SYS
QUEUE_PRIVILEGES
VIEW
Grants on queues for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
SYS
REPCAT_GENERATED
VIEW
Objects generated to support replication
SYS
REPCAT_REPCAT
VIEW
Information about all replicated object groups
SYS
REPCAT_REPCATLOG
VIEW
Information about asynchronous administration requests
SYS
REPCAT_REPOBJECT
VIEW
Information about replicated objects
SYS
REPCAT_REPOBJECT_BASE
VIEW
Information about replicated objects
SYS
REPCAT_REPPROP
VIEW
Propagation information about replicated objects
SYS
REPCAT_REPSCHEMA
VIEW
N-way replication information
SYS
RESOURCE_COST
VIEW
Cost for each resource
SYS
RESOURCE_MAP
TABLE
Description table for resources. Maps resource name to number
SYS
ROLE_ROLE_PRIVS
VIEW
Roles which are granted to roles
SYS
ROLE_SYS_PRIVS
VIEW
System privileges granted to roles
SYS
ROLE_TAB_PRIVS
VIEW
Table privileges granted to roles
SYS
SESSION_CONTEXT
VIEW
Description of all context attributes set under the current session
SYS
SESSION_PRIVS
VIEW
Privileges which the user currently has set
SYS
SESSION_ROLES
VIEW
Roles which the user currently has enabled.
SYS
STMT_AUDIT_OPTION_MAP
TABLE
Description table for auditing option type codes. Maps auditing option type numbers to type names
SYS
SYSTEM_PRIVILEGE_MAP
TABLE
Description table for privilege type codes. Maps privilege type numbers to type names
SYS
TABLE_PRIVILEGES
VIEW
Grants on objects for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
SYS
TABLE_PRIVILEGE_MAP
TABLE
Description table for privilege (auditing option) type codes. Maps privilege (auditing option) type numbers to type names
SYS
TRUSTED_SERVERS
VIEW
Trustedness of Servers
SYS
USER_ALL_TABLES
VIEW
Description of all object and relational tables owned by the user's
SYS
USER_ARGUMENTS
VIEW
Arguments in object accessible to the user
SYS
USER_ASSOCIATIONS
VIEW
All assocations defined by the user
SYS
USER_AUDIT_OBJECT
VIEW
Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user
SYS
USER_AUDIT_SESSION
VIEW
All audit trail records concerning CONNECT and DISCONNECT
SYS
USER_AUDIT_STATEMENT
VIEW
Audit trail records concerning grant, revoke, audit, noaudit and alter system
SYS
USER_AUDIT_TRAIL
VIEW
Audit trail entries relevant to the user
SYS
USER_CATALOG
VIEW
Tables, Views, Synonyms and Sequences owned by the user
SYS
USER_CLUSTERS
VIEW
Descriptions of user's own clusters
SYS
USER_CLUSTER_HASH_EXPRESSIONS
VIEW
Hash functions for the user's hash clusters
SYS
USER_CLU_COLUMNS
VIEW
Mapping of table columns to cluster columns
SYS
USER_COLL_TYPES
VIEW
Description of the user's own named collection types
SYS
USER_COL_COMMENTS
VIEW
Comments on columns of user's tables and views
SYS
USER_COL_PRIVS
VIEW
Grants on columns for which the user is the owner, grantor or grantee
SYS
USER_COL_PRIVS_MADE
VIEW
All grants on columns of objects owned by the user
SYS
USER_COL_PRIVS_RECD
VIEW
Grants on columns for which the user is the grantee
SYS
USER_CONSTRAINTS
VIEW
Constraint definitions on user's own tables
SYS
USER_CONS_COLUMNS
VIEW
Information about accessible columns in constraint definitions
SYS
USER_DB_LINKS
VIEW
Database links owned by the user
SYS
USER_DEPENDENCIES
VIEW
Dependencies to and from a users objects
SYS
USER_DIMENSIONS
VIEW
Description of the dimension objects accessible to the DBA
SYS
USER_DIM_ATTRIBUTES
VIEW
Representation of the relationship between a dimension level and
a functionally dependent column
SYS
USER_DIM_CHILD_OF
VIEW
Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension
SYS
USER_DIM_HIERARCHIES
VIEW
Representation of a dimension hierarchy
SYS
USER_DIM_JOIN_KEY
VIEW
Representation of a join between two dimension tables.
SYS
USER_DIM_LEVELS
VIEW
Description of dimension levels visible to DBA
SYS
USER_DIM_LEVEL_KEY
VIEW
Representations of columns of a dimension level
SYS
USER_ERRORS
VIEW
Current errors on stored objects owned by the user
SYS
USER_EXTENTS
VIEW
Extents comprising segments owned by the user
SYS
USER_FREE_SPACE
VIEW
Free extents in tablespaces accessible to the user
SYS
USER_INDEXES
VIEW
Description of the user's own indexes
SYS
USER_INDEXTYPES
VIEW
All user indextypes
SYS
USER_INDEXTYPE_OPERATORS
VIEW
All user indextype operators
SYS
USER_IND_COLUMNS
VIEW
COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
SYS
USER_IND_EXPRESSIONS
VIEW
Functional index expressions in user's indexes and indexes on user's tables
SYS
USER_INTERNAL_TRIGGERS
VIEW
Description of the internal triggers on the user's own tables
SYS
USER_JAVA_POLICY
VIEW
java security Permissions for current user
SYS
USER_JOBS
VIEW
All jobs owned by this user
SYS
USER_LIBRARIES
VIEW
Description of the user's own libraries
SYS
USER_LOBS
VIEW
Description of the user's own LOBs contained in the user's own tables
SYS
USER_METHOD_PARAMS
VIEW
Description of method parameters of the user's own types
SYS
USER_METHOD_RESULTS
VIEW
Description of method results of the user's own types
SYS
USER_MVIEWS
VIEW
All materialized views in the database
SYS
USER_MVIEW_AGGREGATES
VIEW
Description of the materialized view aggregates created by the user
SYS
USER_MVIEW_ANALYSIS
VIEW
Description of the materialized views created by the user
SYS
USER_MVIEW_DETAIL_RELATIONS
VIEW
Description of the materialized view detail tables of the materialized
views created by the user
SYS
USER_MVIEW_JOINS
VIEW
Description of a join between two columns in the
WHERE clause of a materialized view created by the user
SYS
USER_MVIEW_KEYS
VIEW
Description of the columns that appear in the GROUP BY
list of a materialized view created by the user
SYS
USER_NESTED_TABLES
VIEW
Description of nested tables contained in the user's own tables
SYS
USER_OBJECTS
VIEW
Objects owned by the user
SYS
USER_OBJECT_SIZE
VIEW
Sizes, in bytes, of various pl/sql objects
SYS
USER_OBJECT_TABLES
VIEW
Description of the user's own object tables
SYS
USER_OBJ_AUDIT_OPTS
VIEW
Auditing options for user's own tables and views
SYS
USER_OPANCILLARY
VIEW
All ancillary opertors defined by user
SYS
USER_OPARGUMENTS
VIEW
All operator arguments of operators defined by user
SYS
USER_OPBINDINGS
VIEW
All binding functions or methods on operators defined by the user
SYS
USER_OPERATORS
VIEW
All user operators
SYS
USER_OUTLINES
VIEW
Stored outlines owned by the user
SYS
USER_OUTLINE_HINTS
VIEW
Hints stored in outlines owned by the user
SYS
USER_PARTIAL_DROP_TABS
VIEW
User tables with unused columns
SYS
USER_PASSWORD_LIMITS
VIEW
Display password limits of the user
SYS
USER_POLICIES
VIEW
All row level security policies for tables or views owned by the user
SYS
USER_QUEUES
VIEW
All queues owned by the user
SYS
USER_QUEUE_TABLES
VIEW
All queue tables created by the user
SYS
USER_REFRESH
VIEW
All the refresh groups
SYS
USER_REFRESH_CHILDREN
VIEW
All the objects in refresh groups, where the user owns the refresh group
SYS
USER_REFS
VIEW
Description of the user's own REF columns contained in the user's own tables
SYS
USER_REGISTERED_SNAPSHOTS
VIEW
Remote snapshots of local tables currently using logs owned by the user
SYS
USER_REPAUDIT_ATTRIBUTE
VIEW
Information about attributes automatically maintained for replication
SYS
USER_REPAUDIT_COLUMN
VIEW
Information about columns in all shadow tables for user's replicated tables
SYS
USER_REPCATLOG
VIEW
Information about the current user's asynchronous administration requests
SYS
USER_REPCOLUMN
VIEW
Replicated columns for the current user's table in ascending order
SYS
USER_REPCOLUMN_GROUP
VIEW
All column groups of user's replicated tables
SYS
USER_REPDDL
VIEW
Arguments that do not fit in a single repcat log record
SYS
USER_REPFLAVORS
VIEW
Flavors current user created for replicated object groups
SYS
USER_REPFLAVOR_COLUMNS
VIEW
Replicated columns from current user's tables in flavors
SYS
USER_REPFLAVOR_OBJECTS
VIEW
Replicated user objects in flavors
SYS
USER_REPGENERATED
VIEW
Objects generated for the current user to support replication
SYS
USER_REPGENOBJECTS
VIEW
Objects generated for the current user to support replication
SYS
USER_REPGROUP
VIEW
Replication information about the current user
SYS
USER_REPGROUPED_COLUMN
VIEW
Columns in the all column groups of user's replicated tables
SYS
USER_REPGROUP_PRIVILEGES
VIEW
Information about users who are registered for object group privileges
SYS
USER_REPKEY_COLUMNS
VIEW
Primary columns for a table using column-level replication
SYS
USER_REPOBJECT
VIEW
Replication information about the current user's objects
SYS
USER_REPPARAMETER_COLUMN
VIEW
All columns used for resolving conflicts in user's replicated tables
SYS
USER_REPPRIORITY
VIEW
Values and their corresponding priorities in user's priority groups
SYS
USER_REPPRIORITY_GROUP
VIEW
Information about user's priority groups
SYS
USER_REPPROP
VIEW
Propagation information about the current user's objects
SYS
USER_REPRESOLUTION
VIEW
Description of all conflict resolutions for user's replicated tables
SYS
USER_REPRESOLUTION_METHOD
VIEW
All conflict resolution methods accessible to the user
SYS
USER_REPRESOLUTION_STATISTICS
VIEW
Statistics for conflict resolutions for user's replicated tables
SYS
USER_REPRESOL_STATS_CONTROL
VIEW
Information about statistics collection for conflict resolutions for user's replicated tables
SYS
USER_REPSCHEMA
VIEW
N-way replication information about the current user
SYS
USER_REPSITES
VIEW
N-way replication information about the current user
SYS
USER_RESOURCE_LIMITS
VIEW
Display resource limit of the user
SYS
USER_ROLE_PRIVS
VIEW
Roles granted to current user
SYS
USER_RSRC_CONSUMER_GROUP_PRIVS
VIEW
Switch privileges for consumer groups for the user
SYS
USER_RSRC_MANAGER_SYSTEM_PRIVS
VIEW
system privileges for the resource manager for the user
SYS
USER_RULESETS
VIEW
Rulesets owned by the user
SYS
USER_SEGMENTS
VIEW
Storage allocated for all database segments
SYS
USER_SEQUENCES
VIEW
Description of the user's own SEQUENCEs
SYS
USER_SNAPSHOTS
VIEW
Snapshots the user can look at
SYS
USER_SNAPSHOT_LOGS
VIEW
All snapshot logs owned by the user
SYS
USER_SNAPSHOT_REFRESH_TIMES
VIEW
Snapshots and their last refresh times for each master table that the user can look at
SYS
USER_SOURCE
VIEW
Source of stored objects accessible to the user
SYS
USER_SUMMARIES
VIEW
Description of the summaries created by the user
SYS
USER_SYNONYMS
VIEW
The user's private synonyms
SYS
USER_SYS_PRIVS
VIEW
System privileges granted to current user
SYS
USER_TABLES
VIEW
Description of the user's own relational tables
SYS
USER_TABLESPACES
VIEW
Description of accessible tablespaces
SYS
USER_TAB_COLUMNS
VIEW
Columns of user's tables, views and clusters
SYS
USER_TAB_COL_STATISTICS
VIEW
Columns of user's tables, views and clusters
SYS
USER_TAB_COMMENTS
VIEW
Comments on the tables and views owned by the user
SYS
USER_TAB_HISTOGRAMS
VIEW
Histograms on columns of user's tables
SYS
USER_TAB_MODIFICATIONS
VIEW
Information regarding modifications to tables
SYS
USER_TAB_PRIVS
VIEW
Grants on objects for which the user is the owner, grantor or grantee
SYS
USER_TAB_PRIVS_MADE
VIEW
All grants on objects owned by the user
SYS
USER_TAB_PRIVS_RECD
VIEW
Grants on objects for which the user is the grantee
SYS
USER_TRIGGERS
VIEW
Triggers owned by the user
SYS
USER_TRIGGER_COLS
VIEW
Column usage in user's triggers
SYS
USER_TS_QUOTAS
VIEW
Tablespace quotas for the user
SYS
USER_TYPES
VIEW
Description of the user's own types
SYS
USER_TYPE_ATTRS
VIEW
Description of attributes of the user's own types
SYS
USER_TYPE_METHODS
VIEW
Description of methods of the user's own types
SYS
USER_UNUSED_COL_TABS
VIEW
User tables with unused columns
SYS
USER_UPDATABLE_COLUMNS
VIEW
Description of updatable columns
SYS
USER_USERS
VIEW
Information about the current user
SYS
USER_USTATS
VIEW
All statistics on tables or indexes owned by the user
SYS
USER_VARRAYS
VIEW
Description of varrays contained in the user's own tables
SYS
USER_VIEWS
VIEW
Description of the user's own views
SYS
_ALL_REPCOLUMN
VIEW
Replicated columns for a table sorted alphabetically in ascending order
SYS
_ALL_REPFLAVOR_OBJECTS
VIEW
Replicated objects in flavors

444 row(s) retrieved.

Copyright © Oekosoft - all rights reserved.