iSelfSchooling.com - Since 1999  References  |  Job Openings  |
    Home  | Search more  | Oracle Syntax  | Instructor-Led in Class   | (Members to access to VIDEOS)
 

Copyright & User Agreement

   Suggestions Email2aFriendHomepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

  ShareUrNotes

...

  Acknowledgement

  Who is who

  University Directory

  Links...

 

 

 

Complete Syntax  |  Oracle Functions  |  PL/SQL Syntax  |  SQL Syntax  |  Tables

 

Oracle Dictionary Tables

ALL_  |  DBA_  |  USER_  |  GV$  |  V$  |  Others

2PC... | APP... | CAP... | EXP... | HIS... | HIS... | IND... | LOC... | OPA... | REC... | REP... | SCH... | STR... | TAB...

 

DBA_APPLY: Details about the apply process

 

iSelfSchooling-SQL> desc DBA_APPLY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 APPLY_NAME                    NOT NULL VARCHAR2(30)

 QUEUE_NAME                    NOT NULL VARCHAR2(30)

 QUEUE_OWNER                   NOT NULL VARCHAR2(30)

 APPLY_CAPTURED                         VARCHAR2(3)

 RULE_SET_NAME                          VARCHAR2(30)

 RULE_SET_OWNER                         VARCHAR2(30)

 APPLY_USER                             VARCHAR2(30)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 APPLY_TAG                              RAW(2000)

 DDL_HANDLER                            VARCHAR2(98)

 PRECOMMIT_HANDLER                      VARCHAR2(98)

 MESSAGE_HANDLER                        VARCHAR2(98)

 STATUS                                 VARCHAR2(8)

 MAX_APPLIED_MESSAGE_NUMBER             NUMBER

 NEGATIVE_RULE_SET_NAME                 VARCHAR2(30)

 NEGATIVE_RULE_SET_OWNER                VARCHAR2(30)

 STATUS_CHANGE_TIME                     DATE

 ERROR_NUMBER                           NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 

DBA_APPLY_CONFLICT_COLUMNS: Details about conflict resolution

 

iSelfSchooling-SQL> desc DBA_APPLY_CONFLICT_COLUMNS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 METHOD_NAME                            VARCHAR2(92)

 RESOLUTION_COLUMN                      VARCHAR2(4000)

 COLUMN_NAME                            VARCHAR2(30)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

DBA_APPLY_DML_HANDLERS: Details about the dml handler

 

iSelfSchooling-SQL> desc DBA_APPLY_DML_HANDLERS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 OPERATION_NAME                         VARCHAR2(13)

 USER_PROCEDURE                         VARCHAR2(98)

 ERROR_HANDLER                          VARCHAR2(1)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 APPLY_NAME                             VARCHAR2(30)

 ASSEMBLE_LOBS                          VARCHAR2(1)

 

DBA_APPLY_ENQUEUE: Details about the apply enqueue action

 

iSelfSchooling-SQL> desc DBA_APPLY_ENQUEUE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 DESTINATION_QUEUE_NAME                 VARCHAR2(4000)

 

DBA_APPLY_ERROR: Error transactions

 

iSelfSchooling-SQL> desc DBA_APPLY_ERROR;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 APPLY_NAME                             VARCHAR2(30)

 QUEUE_NAME                    NOT NULL VARCHAR2(30)

 QUEUE_OWNER                   NOT NULL VARCHAR2(30)

 LOCAL_TRANSACTION_ID                   VARCHAR2(22)

 SOURCE_DATABASE                        VARCHAR2(128)

 SOURCE_TRANSACTION_ID                  VARCHAR2(22)

 SOURCE_COMMIT_SCN                      NUMBER

 MESSAGE_NUMBER                         NUMBER

 ERROR_NUMBER                           NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 RECIPIENT_ID                           NUMBER

 RECIPIENT_NAME                         VARCHAR2(30)

 MESSAGE_COUNT                          NUMBER

 ERROR_CREATION_TIME                    DATE

 

DBA_APPLY_EXECUTE: Details about the apply execute action

 

iSelfSchooling-SQL> desc DBA_APPLY_EXECUTE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 RULE_OWNER                    NOT NULL VARCHAR2(30)

 RULE_NAME                     NOT NULL VARCHAR2(30)

 EXECUTE_EVENT                          VARCHAR2(2)

 

DBA_APPLY_INSTANTIATED_GLOBAL: Details about database instantiated

 

iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_GLOBAL;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SOURCE_DATABASE               NOT NULL VARCHAR2(128)

 INSTANTIATION_SCN                      NUMBER

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

DBA_APPLY_INSTANTIATED_OBJECTS: Details about objects instantiated

 

iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_OBJECTS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SOURCE_DATABASE               NOT NULL VARCHAR2(128)

 SOURCE_OBJECT_OWNER           NOT NULL VARCHAR2(30)

 SOURCE_OBJECT_NAME            NOT NULL VARCHAR2(30)

 SOURCE_OBJECT_TYPE                     VARCHAR2(11)

 INSTANTIATION_SCN                      NUMBER

 IGNORE_SCN                             NUMBER

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

DBA_APPLY_INSTANTIATED_SCHEMAS: Details about schemas instantiated

 

iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_SCHEMAS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SOURCE_DATABASE               NOT NULL VARCHAR2(128)

 SOURCE_SCHEMA                          VARCHAR2(30)

 INSTANTIATION_SCN                      NUMBER

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

DBA_APPLY_KEY_COLUMNS: alternative key columns for a table for STREAMS

 

iSelfSchooling-SQL> desc DBA_APPLY_KEY_COLUMNS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 COLUMN_NAME                   NOT NULL VARCHAR2(30)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

DBA_APPLY_OBJECT_DEPENDENCIES: Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS

 

iSelfSchooling-SQL> desc DBA_APPLY_OBJECT_DEPENDENCIES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 PARENT_OBJECT_OWNER           NOT NULL VARCHAR2(30)

 PARENT_OBJECT_NAME            NOT NULL VARCHAR2(30)

 

DBA_APPLY_PARAMETERS: All parameters for apply process

 

iSelfSchooling-SQL> desc DBA_APPLY_PARAMETERS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 APPLY_NAME                    NOT NULL VARCHAR2(30)

 PARAMETER                     NOT NULL VARCHAR2(128)

 VALUE                                  VARCHAR2(4000)

 SET_BY_USER                            VARCHAR2(3)

 

DBA_APPLY_PROGRESS: Information about the progress made by apply process

 

iSelfSchooling-SQL> desc DBA_APPLY_PROGRESS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 APPLY_NAME                    NOT NULL VARCHAR2(30)

 SOURCE_DATABASE               NOT NULL VARCHAR2(128)

 APPLIED_MESSAGE_NUMBER        NOT NULL NUMBER

 OLDEST_MESSAGE_NUMBER         NOT NULL NUMBER

 APPLY_TIME                             DATE

 APPLIED_MESSAGE_CREATE_TIME            DATE

 OLDEST_TRANSACTION_ID                  VARCHAR2(22)

 

DBA_APPLY_SPILL_TXNS: treams apply spilled transactions info

 

iSelfSchooling-SQL> desc DBA_APPLY_SPILL_TXN;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 APPLY_NAME                    NOT NULL VARCHAR2(30)

 XIDUSN                        NOT NULL NUMBER

 XIDSLT                        NOT NULL NUMBER

 XIDSQN                        NOT NULL NUMBER

 FIRST_SCN                     NOT NULL NUMBER

 MESSAGE_COUNT                          NUMBER

 FIRST_MESSAGE_CREATE_TIME              DATE

 SPILL_CREATION_TIME                    DATE

 

DBA_APPLY_TABLE_COLUMNS: Details about the destination table columns

 

iSelfSchooling-SQL> desc DBA_APPLY_TABLE_COLUMNS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 COMPARE_OLD_ON_DELETE                  VARCHAR2(3)

 COMPARE_OLD_ON_UPDATE                  VARCHAR2(3)

 APPLY_DATABASE_LINK                    VARCHAR2(128)

 

DBA_APPLY_VALUE_DEPENDENCIES: Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS

 

iSelfSchooling-SQL> desc DBA_APPLY_VALUE_DEPENDENCIES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DEPENDENCY_NAME               NOT NULL VARCHAR2(30)

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 COLUMN_NAME                   NOT NULL VARCHAR2(30)

 COLUMN_POSITION                        NUMBER

 

DBA_AQ_AGENTS

 

iSelfSchooling-SQL> desc DBA_AQ_AGENTS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 AGENT_NAME                    NOT NULL VARCHAR2(30)

 HTTP_ENABLED                           VARCHAR2(4)

 SMTP_ENABLED                           VARCHAR2(4)

 

DBA_AQ_AGENT_PRIVS

 

iSelfSchooling-SQL> desc DBA_AQ_AGENT_PRIVS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 AGENT_NAME                    NOT NULL VARCHAR2(30)

 DB_USERNAME                            VARCHAR2(30)

 HTTP_ENABLED                           VARCHAR2(4)

 SMTP_ENABLED                           VARCHAR2(4)

 

DBA_ASSOCIATIONS: All associations

 

iSelfSchooling-SQL> desc DBA_ASSOCIATIONS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OBJECT_OWNER                  NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(9)

 STATSTYPE_SCHEMA                       VARCHAR2(30)

 STATSTYPE_NAME                         VARCHAR2(30)

 DEF_SELECTIVITY                        NUMBER

 DEF_CPU_COST                           NUMBER

 DEF_IO_COST                            NUMBER

 DEF_NET_COST                           NUMBER

 INTERFACE_VERSION                      NUMBER

 

DBA_ATTRIBUTE_TRANSFORMATIONS

 

iSelfSchooling-SQL> desc DBA_ATTRIBUTE_TRANSFORMATIONS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 TRANSFORMATION_ID             NOT NULL NUMBER

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 FROM_TYPE                              VARCHAR2(61)

 TO_TYPE                                VARCHAR2(91)

 ATTRIBUTE                     NOT NULL NUMBER

 ATTRIBUTE_TRANSFORMATION               VARCHAR2(4000)

 

DBA_AUDIT_EXISTS: Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS

 

iSelfSchooling-SQL> desc DBA_AUDIT_EXISTS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OS_USERNAME                            VARCHAR2(255)

 USERNAME                               VARCHAR2(30)

 USERHOST                               VARCHAR2(128)

 TERMINAL                               VARCHAR2(255)

 TIMESTAMP                              DATE

 OWNER                                  VARCHAR2(30)

 OBJ_NAME                               VARCHAR2(128)

 ACTION_NAME                            VARCHAR2(28)

 NEW_OWNER                              VARCHAR2(30)

 NEW_NAME                               VARCHAR2(128)

 OBJ_PRIVILEGE                          VARCHAR2(16)

 SYS_PRIVILEGE                          VARCHAR2(40)

 GRANTEE                                VARCHAR2(30)

 SESSIONID                     NOT NULL NUMBER

 ENTRYID                       NOT NULL NUMBER

 STATEMENTID                   NOT NULL NUMBER

 RETURNCODE                    NOT NULL NUMBER

 CLIENT_ID                              VARCHAR2(64)

 ECONTEXT_ID                            VARCHAR2(64)

 SESSION_CPU                            NUMBER

 EXTENDED_TIMESTAMP                     TIMESTAMP(6)

 PROXY_SESSIONID                        NUMBER

 GLOBAL_UID                             VARCHAR2(32)

 INSTANCE_NUMBER                        NUMBER

 OS_PROCESS                             VARCHAR2(16)

 TRANSACTIONID                          RAW(8)

 SCN                                    NUMBER

 SQL_BIND                               NVARCHAR2(2000)

 SQL_TEXT                               NVARCHAR2(2000)

 

DBA_AUDIT_OBJECT: 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

 

iSelfSchooling-SQL> desc DBA_AUDIT_OBJECT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OS_USERNAME                            VARCHAR2(255)

 USERNAME                               VARCHAR2(30)

 USERHOST                               VARCHAR2(128)

 TERMINAL                               VARCHAR2(255)

 TIMESTAMP                              DATE

 OWNER                                  VARCHAR2(30)

 OBJ_NAME                               VARCHAR2(128)

 ACTION_NAME                            VARCHAR2(28)

 NEW_OWNER                              VARCHAR2(30)

 NEW_NAME                               VARCHAR2(128)

 SES_ACTIONS                            VARCHAR2(19)

 COMMENT_TEXT                           VARCHAR2(4000)

 SESSIONID                     NOT NULL NUMBER

 ENTRYID                       NOT NULL NUMBER

 STATEMENTID                   NOT NULL NUMBER

 RETURNCODE                    NOT NULL NUMBER

 PRIV_USED                              VARCHAR2(40)

 CLIENT_ID                              VARCHAR2(64)

 ECONTEXT_ID                            VARCHAR2(64)

 SESSION_CPU                            NUMBER

 EXTENDED_TIMESTAMP                     TIMESTAMP(6)

 PROXY_SESSIONID                        NUMBER

 GLOBAL_UID                             VARCHAR2(32)

 INSTANCE_NUMBER                        NUMBER

 OS_PROCESS                             VARCHAR2(16)

 TRANSACTIONID                          RAW(8)

 SCN                                    NUMBER

 SQL_BIND                               NVARCHAR2(2000)

 SQL_TEXT                               NVARCHAR2(2000)

 

DBA_AUDIT_POLICIES: Fine grained auditing policies in the database

 

iSelfSchooling-SQL> desc DBA_AUDIT_POLICIES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OBJECT_SCHEMA                 NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 POLICY_NAME                   NOT NULL VARCHAR2(30)

 POLICY_TEXT                            VARCHAR2(4000)

 POLICY_COLUMN                          VARCHAR2(30)

 PF_SCHEMA                              VARCHAR2(30)

 PF_PACKAGE                             VARCHAR2(30)

 PF_FUNCTION                            VARCHAR2(30)

 ENABLED                                VARCHAR2(3)

 SEL                                    VARCHAR2(3)

 INS                                    VARCHAR2(3)

 UPD                                    VARCHAR2(3)

 DEL                                    VARCHAR2(3)

 AUDIT_TRAIL                            VARCHAR2(12)

 POLICY_COLUMN_OPTIONS                  VARCHAR2(11)

 

DBA_AUDIT_POLICY_COLUMNS: All fine grained auditing policy columns in the database

 

iSelfSchooling-SQL> desc DBA_AUDIT_POLICY_COLUMNS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OBJECT_SCHEMA                 NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 POLICY_NAME                   NOT NULL VARCHAR2(30)

 POLICY_COLUMN                 NOT NULL VARCHAR2(30)

 

DBA_AUDIT_SESSION: All audit trail records concerning CONNECT and DISCONNECT

 

iSelfSchooling-SQL> desc DBA_AUDIT_SESSION;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OS_USERNAME                            VARCHAR2(255)

 USERNAME                               VARCHAR2(30)

 USERHOST                               VARCHAR2(128)

 TERMINAL                               VARCHAR2(255)

 TIMESTAMP                              DATE

 ACTION_NAME                            VARCHAR2(28)

 LOGOFF_TIME                            DATE

 LOGOFF_LREAD                           NUMBER

 LOGOFF_PREAD                           NUMBER

 LOGOFF_LWRITE                          NUMBER

 LOGOFF_DLOCK                           VARCHAR2(40)

 SESSIONID                     NOT NULL NUMBER

 RETURNCODE                    NOT NULL NUMBER

 CLIENT_ID                              VARCHAR2(64)

 SESSION_CPU                            NUMBER

 EXTENDED_TIMESTAMP                     TIMESTAMP(6)

 PROXY_SESSIONID                        NUMBER

 GLOBAL_UID                             VARCHAR2(32)

 INSTANCE_NUMBER                        NUMBER

 OS_PROCESS                             VARCHAR2(16)

 

DBA_AUDIT_STATEMENT: Audit trail records concerning  grant, revoke, audit, noaudit and alter system

 

iSelfSchooling-SQL> desc DBA_AUDIT_STATEMENT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OS_USERNAME                            VARCHAR2(255)

 USERNAME                               VARCHAR2(30)

 USERHOST                               VARCHAR2(128)

 TERMINAL                               VARCHAR2(255)

 TIMESTAMP                              DATE

 OWNER                                  VARCHAR2(30)

 OBJ_NAME                               VARCHAR2(128)

 ACTION_NAME                            VARCHAR2(28)

 NEW_NAME                               VARCHAR2(128)

 OBJ_PRIVILEGE                          VARCHAR2(16)

 SYS_PRIVILEGE                          VARCHAR2(40)

 ADMIN_OPTION                           VARCHAR2(1)

 GRANTEE                                VARCHAR2(30)

 AUDIT_OPTION                           VARCHAR2(40)

 SES_ACTIONS                            VARCHAR2(19)

 COMMENT_TEXT                           VARCHAR2(4000)

 SESSIONID                     NOT NULL NUMBER

 ENTRYID                       NOT NULL NUMBER

 STATEMENTID                   NOT NULL NUMBER

 RETURNCODE                    NOT NULL NUMBER

 PRIV_USED                              VARCHAR2(40)

 CLIENT_ID                              VARCHAR2(64)

 ECONTEXT_ID                            VARCHAR2(64)

 SESSION_CPU                            NUMBER

 EXTENDED_TIMESTAMP                     TIMESTAMP(6)

 PROXY_SESSIONID                        NUMBER

 GLOBAL_UID                             VARCHAR2(32)

 INSTANCE_NUMBER                        NUMBER

 OS_PROCESS                             VARCHAR2(16)

 TRANSACTIONID                          RAW(8)

 SCN                                    NUMBER

 SQL_BIND                               NVARCHAR2(2000)

 SQL_TEXT                               NVARCHAR2(2000)

 

DBA_AUDIT_TRAIL: All audit trail entries

 

iSelfSchooling-SQL> desc DBA_AUDIT_TRAIL;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OS_USERNAME                            VARCHAR2(255)

 USERNAME                               VARCHAR2(30)

 USERHOST                               VARCHAR2(128)

 TERMINAL                               VARCHAR2(255)

 TIMESTAMP                              DATE

 OWNER                                  VARCHAR2(30)

 OBJ_NAME                               VARCHAR2(128)

 ACTION                        NOT NULL NUMBER

 ACTION_NAME                            VARCHAR2(28)

 NEW_OWNER                              VARCHAR2(30)

 NEW_NAME                               VARCHAR2(128)

 OBJ_PRIVILEGE                          VARCHAR2(16)

 SYS_PRIVILEGE                          VARCHAR2(40)

 ADMIN_OPTION                           VARCHAR2(1)

 GRANTEE                                VARCHAR2(30)

 AUDIT_OPTION                           VARCHAR2(40)

 SES_ACTIONS                            VARCHAR2(19)

 LOGOFF_TIME                            DATE

 LOGOFF_LREAD                           NUMBER

 LOGOFF_PREAD                           NUMBER

 LOGOFF_LWRITE                          NUMBER

 LOGOFF_DLOCK                           VARCHAR2(40)

 COMMENT_TEXT                           VARCHAR2(4000)

 SESSIONID                     NOT NULL NUMBER

 ENTRYID                       NOT NULL NUMBER

 STATEMENTID                   NOT NULL NUMBER

 RETURNCODE                    NOT NULL NUMBER

 PRIV_USED                              VARCHAR2(40)

 CLIENT_ID                              VARCHAR2(64)

 ECONTEXT_ID                            VARCHAR2(64)

 SESSION_CPU                            NUMBER

 EXTENDED_TIMESTAMP                     TIMESTAMP(6)

 PROXY_SESSIONID                        NUMBER

 GLOBAL_UID                             VARCHAR2(32)

 INSTANCE_NUMBER                        NUMBER

 OS_PROCESS                             VARCHAR2(16)

 TRANSACTIONID                          RAW(8)

 SCN                                    NUMBER

 SQL_BIND                               NVARCHAR2(2000)

 SQL_TEXT                               NVARCHAR2(2000)

 

DBA_AWS: Analytic Workspaces in the database

 

iSelfSchooling-SQL> desc DBA_AWS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 AW_VERSION                             VARCHAR2(4)

 PAGESPACES                             NUMBER

 GENERATIONS                            NUMBER

 

DBA_AW_OBJ: Objects in Analytic Workspaces in the database

 

iSelfSchooling-SQL> desc DBA_AW_OBJ;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 OBJ_ID                                 NUMBER(20)

 OBJ_NAME                               VARCHAR2(256)

 OBJ_TYPE                               NUMBER(4)

 PART_NAME                              VARCHAR2(256)

 

DBA_AW_PROP: Object properties in Analytic Workspaces in the database

 

iSelfSchooling-SQL> desc DBA_AW_PROP;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 OBJ_ID                                 NUMBER(20)

 OBJ_NAME                               VARCHAR2(256)

 PROPERTY_NAME                          VARCHAR2(256)

 PROPERTY_TYPE                          VARCHAR2(4000)

 PROPERTY_VALUE                         VARCHAR2(4000)

 FULL_PROPERTY_VALUE                    CLOB

 PROPERTY_VALUE_LENGTH                  NUMBER

 

DBA_AW_PS: Pagespaces in Analytic Workspaces owned by the user

 

iSelfSchooling-SQL> desc DBA_AW_PS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 AW_NUMBER                     NOT NULL NUMBER

 AW_NAME                                VARCHAR2(30)

 PSNUMBER                               NUMBER(10)

 GENERATIONS                            NUMBER

 MAXPAGES                               NUMBER

 

DBA_BASE_TABLE_MVIEWS: All materialized views with log(s) in the database

 

iSelfSchooling-SQL> desc DBA_BASE_TABLE_MVIEWS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 MASTER                        NOT NULL VARCHAR2(30)

 MVIEW_LAST_REFRESH_TIME       NOT NULL DATE

 MVIEW_ID                               NUMBER(38)

 

DBA_BLOCKERS

 

iSelfSchooling-SQL> desc DBA_BLOCKERS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 HOLDING_SESSION                        NUMBER

 

DBA_CACHEABLE_NONTABLE_OBJECTS

 

iSelfSchooling-SQL> desc DBA_CACHEABLE_NONTABLE_OBJECTS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                                  VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(128)

 OBJECT_TYPE                            VARCHAR2(19)

 

DBA_CACHEABLE_OBJECTS

 

iSelfSchooling-SQL> desc DBA_CACHEABLE_OBJECTS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                                  VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(128)

 OBJECT_TYPE                            VARCHAR2(19)

 

DBA_CACHEABLE_OBJECTS_BASE

 

iSelfSchooling-SQL> desc DBA_CACHEABLE_OBJECTS_BASE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                                  VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(128)

 OBJECT_TYPE                            VARCHAR2(19)

 

DBA_CACHEABLE_TABLES

 

iSelfSchooling-SQL> desc DBA_CACHEABLE_TABLES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 

DBA_CACHEABLE_TABLES_BASE

 

iSelfSchooling-SQL> desc DBA_CACHEABLE_TABLES_BASE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 TEMPORARY                              VARCHAR2(1)

 PROPERTY                      NOT NULL NUMBER

 

DBA_CAPTURE: Details about the capture process

 

iSelfSchooling-SQL> desc DBA_CAPTURE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 CAPTURE_NAME                  NOT NULL VARCHAR2(30)

 QUEUE_NAME                    NOT NULL VARCHAR2(30)

 QUEUE_OWNER                   NOT NULL VARCHAR2(30)

 RULE_SET_NAME                          VARCHAR2(30)

 RULE_SET_OWNER                         VARCHAR2(30)

 CAPTURE_USER                           VARCHAR2(30)

 START_SCN                              NUMBER

 STATUS                                 VARCHAR2(8)

 CAPTURED_SCN                           NUMBER

 APPLIED_SCN                            NUMBER

 USE_DATABASE_LINK                      VARCHAR2(3)

 FIRST_SCN                              NUMBER

 SOURCE_DATABASE                        VARCHAR2(128)

 SOURCE_DBID                            NUMBER

 SOURCE_RESETLOGS_SCN                   NUMBER

 SOURCE_RESETLOGS_TIME                  NUMBER

 LOGMINER_ID                            NUMBER

 NEGATIVE_RULE_SET_NAME                 VARCHAR2(30)

 NEGATIVE_RULE_SET_OWNER                VARCHAR2(30)

 MAX_CHECKPOINT_SCN                     NUMBER

 REQUIRED_CHECKPOINT_SCN                NUMBER

 LOGFILE_ASSIGNMENT                     VARCHAR2(8)

 STATUS_CHANGE_TIME                     DATE

 ERROR_NUMBER                           NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 VERSION                                VARCHAR2(64)

 CAPTURE_TYPE                           VARCHAR2(10)

 LAST_ENQUEUED_SCN                      NUMBER

 CHECKPOINT_RETENTION_TIME              NUMBER

 

 

 

 
 
Google
 
Web web site