iSelfSchooling.com - Copyright © 1999-2007 iSelfSchooling.com  References  Job Openings  |  Secure Login
    Home  | Search more...  |  FREE Online VIDEO Oracle Training  |  Gift Store  |  Bookstore

   Unlimited access!   

    Oracle  Syntax  | Suggestions Your Contribution  |  FREE Legal Forms

 

Email2aFriend Homepage us! |  Bookmark   -  Copyright & User Agreement

Products/Services

 Vision/Mission

 Community Sharing

 Services

  Products

 Biography

 Contact Us

 FAQ

 Current News

 Website Traffic

 Bookstore

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

Oracle SYNTAX

 Oracle Functions

 Oracle Syntax

 Oracle 10g Syntax

  PL/SQL Syntax

UNIX and more...

 UNIX for DBAs

 LINUX for DBAs

 DB using PHP

  A+ Certification

 Basics of JAVA  

 Tips of  SEO

Finance/Jobs

 Financial Aid

 Skilled

 Oracle

 Jobs

  Magazine

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

 Community Sharing

More to know...

Acknowledgement**

 FREE Legal Forms

 Who is who

 Market Place

 University Directory

 Advisory Articles

 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)