iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

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                   &nbs