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_CAPTURE_EXTRA_ATTRIBUTES: Extra attributes for a capture process

 

iSelfSchooling-SQL> desc DBA_CAPTURE_EXTRA_ATTRIBUTES;

 Name                          Null?    Type

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

 CAPTURE_NAME                  NOT NULL VARCHAR2(30)

 ATTRIBUTE_NAME                NOT NULL VARCHAR2(30)

 INCLUDE                                VARCHAR2(3)

 ROW_ATTRIBUTE                          VARCHAR2(3)

 DDL_ATTRIBUTE                          VARCHAR2(3)

 

DBA_CAPTURE_PARAMETERS: All parameters for capture process

 

iSelfSchooling-SQL> desc DBA_CAPTURE_PARAMETERS;

 Name                          Null?    Type

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

 CAPTURE_NAME                  NOT NULL VARCHAR2(30)

 PARAMETER                     NOT NULL VARCHAR2(128)

 VALUE                                  VARCHAR2(4000)

 SET_BY_USER                            VARCHAR2(3)

 

DBA_CAPTURE_PREPARED_DATABASE: Is the local database prepared for instantiation?

 

iSelfSchooling-SQL> desc DBA_CAPTURE_PREPARED_DATABASE;

 Name                          Null?    Type

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

 TIMESTAMP                              DATE

 SUPPLEMENTAL_LOG_DATA_PK               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_UI               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_FK               VARCHAR2(8)

 SUPPLEMENTAL_LOG_DATA_ALL              VARCHAR2(8)

 

DBA_CAPTURE_PREPARED_SCHEMAS: All schemas at the local database that are prepared for instantiation

 

iSelfSchooling-SQL> desc DBA_CAPTURE_PREPARED_SCHEMAS;

 Name                          Null?    Type

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

 SCHEMA_NAME                   NOT NULL VARCHAR2(30)

 TIMESTAMP                              DATE

 SUPPLEMENTAL_LOG_DATA_PK               VARCHAR2(8)