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_RECYCLEBIN: Description of the Recyclebin view accessible to the user

 

iSelfSchooling-SQL> desc DBA_RECYCLEBIN;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 ORIGINAL_NAME                          VARCHAR2(32)

 OPERATION                              VARCHAR2(9)

 TYPE                                   VARCHAR2(25)

 TS_NAME                                VARCHAR2(30)

 CREATETIME                             VARCHAR2(19)

 DROPTIME                               VARCHAR2(19)

 DROPSCN                                NUMBER

 PARTITION_NAME                         VARCHAR2(32)

 CAN_UNDROP                             VARCHAR2(3)

 CAN_PURGE                              VARCHAR2(3)

 RELATED                       NOT NULL NUMBER

 BASE_OBJECT                   NOT NULL NUMBER

 PURGE_OBJECT                  NOT NULL NUMBER

 SPACE                                  NUMBER

 

DBA_REFRESH: All the refresh groups

 

iSelfSchooling-SQL> desc DBA_REFRESH;

 Name                          Null?    Type

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

 ROWNER                        NOT NULL VARCHAR2(30)

 RNAME                         NOT NULL VARCHAR2(30)

 REFGROUP                               NUMBER

 IMPLICIT_DESTROY                       VARCHAR2(1)

 PUSH_DEFERRED_RPC                      VARCHAR2(1)

 REFRESH_AFTER_ERRORS                   VARCHAR2(1)

 ROLLBACK_SEG                           VARCHAR2(30)

 JOB                                    NUMBER

 NEXT_DATE                              DATE

 INTERVAL                               VARCHAR2(200)

 BROKEN                                 VARCHAR2(1)

 PURGE_OPTION                           NUMBER(38)

 PARALLELISM                            NUMBER(38)

 HEAP_SIZE                              NUMBER(38)

 

DBA_REFRESH_CHILDREN: All the objects in refresh groups

 

iSelfSchooling-SQL> desc DBA_REFRESH_CHILDREN;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(30)

 ROWNER                        NOT NULL VARCHAR2(30)

 RNAME                         NOT NULL VARCHAR2(30)

 REFGROUP                               NUMBER

 IMPLICIT_DESTROY                       VARCHAR2(1)

 PUSH_DEFERRED_RPC                      VARCHAR2(1)

 REFRESH_AFTER_ERRORS                   VARCHAR2(1)

 ROLLBACK_SEG                           VARCHAR2(30)

 JOB                                    NUMBER

 NEXT_DATE                              DATE

 INTERVAL                               VARCHAR2(200)

 BROKEN                                 VARCHAR2(1)

 PURGE_OPTION                           NUMBER(38)

 PARALLELISM                            NUMBER(38)

 HEAP_SIZE                              NUMBER(38)

 

DBA_REFS: Description of REF columns contained in all tables

 

iSelfSchooling-SQL> desc DBA_REFS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 WITH_ROWID                             VARCHAR2(3)

 IS_SCOPED                              VARCHAR2(3)

 SCOPE_TABLE_OWNER                      VARCHAR2(30)

 SCOPE_TABLE_NAME                       VARCHAR2(30)

 OBJECT_ID_TYPE                         VARCHAR2(33)

 

DBA_REGISTERED_ARCHIVED_LOG: Details about the registered log files

 

iSelfSchooling-SQL> desc DBA_REGISTERED_ARCHIVED_LOG;

 Name                          Null?    Type

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

 CONSUMER_NAME                 NOT NULL VARCHAR2(30)

 SOURCE_DATABASE                        VARCHAR2(128)

 THREAD#                       NOT NULL NUMBER

 SEQUENCE#                     NOT NULL NUMBER

 FIRST_SCN                     NOT NULL NUMBER

 NEXT_SCN                               NUMBER

 FIRST_TIME                             DATE

 NEXT_TIME                              DATE

 NAME                                   VARCHAR2(513)

 MODIFIED_TIME                          DATE

 DICTIONARY_BEGIN                       VARCHAR2(3)

 DICTIONARY_END                         VARCHAR2(3)

 PURGEABLE                              VARCHAR2(3)

 RESETLOGS_CHANGE#             NOT NULL NUMBER

 RESET_TIMESTAMP               NOT NULL NUMBER

 

DBA_REGISTERED_MVIEWS: Remote materialized views of local tables

 

iSelfSchooling-SQL> desc DBA_REGISTERED_MVIEWS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 MVIEW_SITE                    NOT NULL VARCHAR2(128)

 CAN_USE_LOG                            VARCHAR2(3)

 UPDATABLE                              VARCHAR2(3)

 REFRESH_METHOD                         VARCHAR2(11)

 MVIEW_ID                               NUMBER(38)

 VERSION                                VARCHAR2(26)

 QUERY_TXT                              LONG

 

DBA_REGISTERED_MVIEW_GROUPS: Materialized view repgroup registration information

 

iSelfSchooling-SQL> desc DBA_REGISTERED_MVIEW_GROUPS;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(30)

 MVIEW_SITE                             VARCHAR2(128)

 GROUP_COMMENT                          VARCHAR2(80)

 VERSION                                VARCHAR2(8)

 FNAME                                  VARCHAR2(30)

 OWNER                                  VARCHAR2(30)

 

DBA_REGISTERED_SNAPSHOTS: Remote snapshots of local tables

 

iSelfSchooling-SQL> desc DBA_REGISTERED_SNAPSHOTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 SNAPSHOT_SITE                 NOT NULL VARCHAR2(128)

 CAN_USE_LOG                            VARCHAR2(3)

 UPDATABLE                              VARCHAR2(3)

 REFRESH_METHOD                         VARCHAR2(11)

 SNAPSHOT_ID                            NUMBER(38)

 VERSION                                VARCHAR2(17)

 QUERY_TXT                              LONG

 

DBA_REGISTERED_SNAPSHOT_GROUPS: Snapshot repgroup registration information

 

iSelfSchooling-SQL> desc DBA_REGISTERED_SNAPSHOT_GROUPS;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(30)

 SNAPSHOT_SITE                          VARCHAR2(128)

 GROUP_COMMENT                          VARCHAR2(80)

 VERSION                                VARCHAR2(8)

 FNAME                                  VARCHAR2(30)

 OWNER                                  VARCHAR2(30)

 

DBA_REGISTRY

 

iSelfSchooling-SQL> desc DBA_REGISTRY;

 Name                          Null?    Type

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

 COMP_ID                       NOT NULL VARCHAR2(30)

 COMP_NAME                              VARCHAR2(255)

 VERSION                                VARCHAR2(30)

 STATUS                                 VARCHAR2(11)

 MODIFIED                               VARCHAR2(20)

 NAMESPACE                     NOT NULL VARCHAR2(30)

 CONTROL                       NOT NULL VARCHAR2(30)

 SCHEMA                        NOT NULL VARCHAR2(30)

 PROCEDURE                              VARCHAR2(61)

 STARTUP                                VARCHAR2(8)

 PARENT_ID                              VARCHAR2(30)

 OTHER_SCHEMAS                          VARCHAR2(4000)

 

DBA_REGISTRY_HIERARCHY

 

iSelfSchooling-SQL> desc DBA_REGISTRY_HIERARCHY;

 Name                          Null?    Type

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

 NAMESPACE                     NOT NULL VARCHAR2(30)

 COMP_ID                                VARCHAR2(4000)

 VERSION                                VARCHAR2(30)

 STATUS                                 VARCHAR2(11)

 MODIFIED                               VARCHAR2(20)

 

DBA_REGISTRY_HISTORY

 

iSelfSchooling-SQL> desc DBA_REGISTRY_HISTORY;

 Name                          Null?    Type

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

 ACTION_TIME                            TIMESTAMP(6)

 ACTION                                 VARCHAR2(30)

 NAMESPACE                              VARCHAR2(30)

 VERSION                                VARCHAR2(30)

 ID                                     NUMBER

 COMMENTS                               VARCHAR2(255)

 

DBA_REGISTRY_LOG

 

iSelfSchooling-SQL> desc DBA_REGISTRY_LOG;

 Name                          Null?    Type

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

 OPTIME                                 TIMESTAMP(6)

 NAMESPACE                              VARCHAR2(30)

 COMP_ID                                VARCHAR2(30)

 OPERATION                              VARCHAR2(11)

 MESSAGE                                VARCHAR2(1000)

 

DBA_REPAUDIT_ATTRIBUTE: Information about attributes automatically maintained for replication

 

iSelfSchooling-SQL> desc DBA_REPAUDIT_ATTRIBUTE;

 Name                          Null?    Type

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

 ATTRIBUTE                     NOT NULL VARCHAR2(30)

 DATA_TYPE                              VARCHAR2(9)

 DATA_LENGTH                            NUMBER(38)

 SOURCE                        NOT NULL VARCHAR2(92)

 

DBA_REPAUDIT_COLUMN: Information about columns in all shadow tables for all replicated tables in the database

 

iSelfSchooling-SQL> desc DBA_REPAUDIT_COLUMN;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 COLUMN_NAME                   NOT NULL VARCHAR2(30)

 BASE_SNAME                    NOT NULL VARCHAR2(30)

 BASE_ONAME                    NOT NULL VARCHAR2(30)

 BASE_CONFLICT_TYPE                     VARCHAR2(10)

 BASE_REFERENCE_NAME           NOT NULL VARCHAR2(30)

 ATTRIBUTE                     NOT NULL VARCHAR2(30)

 

DBA_REPCAT

 

iSelfSchooling-SQL> desc DBA_REPCAT;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 MASTER                                 VARCHAR2(1)

 STATUS                                 VARCHAR2(9)

 SCHEMA_COMMENT                         VARCHAR2(80)

 GNAME                         NOT NULL VARCHAR2(30)

 FNAME                                  VARCHAR2(30)

 RPC_PROCESSING_DISABLED                VARCHAR2(1)

 OWNER                         NOT NULL VARCHAR2(30)

 

DBA_REPCATLOG: Information about asynchronous administration requests

 

iSelfSchooling-SQL> desc DBA_REPCATLOG;

 Name                          Null?    Type

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

 ID                            NOT NULL NUMBER

 SOURCE                        NOT NULL VARCHAR2(128)

 STATUS                                 VARCHAR2(14)

 USERID                                 VARCHAR2(30)

 TIMESTAMP                              DATE

 ROLE                                   VARCHAR2(9)

 MASTER                        NOT NULL VARCHAR2(128)

 SNAME                                  VARCHAR2(30)

 REQUEST                                VARCHAR2(29)

 ONAME                                  VARCHAR2(30)

 TYPE                                   VARCHAR2(12)

 MESSAGE                                VARCHAR2(200)

 ERRNUM                                 NUMBER

 GNAME                                  VARCHAR2(30)

 

DBA_REPCAT_EXCEPTIONS: Repcat processing exceptions table.

 

iSelfSchooling-SQL> desc DBA_REPCAT_EXCEPTIONS;

 Name                          Null?    Type

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

 EXCEPTION_ID                  NOT NULL NUMBER

 USER_NAME                              VARCHAR2(30)

 REQUEST                                CLOB

 JOB                                    NUMBER

 ERROR_DATE                             DATE

 ERROR_NUMBER                           NUMBER

 ERROR_MESSAGE                          VARCHAR2(4000)

 LINE_NUMBER                            NUMBER

 

DBA_REPCOLUMN: Replicated top-level columns (table) sorted alphabetically in ascending order

 

iSelfSchooling-SQL> desc DBA_REPCOLUMN;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(8)

 CNAME                                  VARCHAR2(4000)

 ID                                     NUMBER

 POS                                    NUMBER

 COMPARE_OLD_ON_DELETE                  VARCHAR2(1)

 COMPARE_OLD_ON_UPDATE                  VARCHAR2(1)

 SEND_OLD_ON_DELETE                     VARCHAR2(1)

 SEND_OLD_ON_UPDATE                     VARCHAR2(1)

 CTYPE                                  VARCHAR2(106)

 CTYPE_TOID                             RAW(16)

 CTYPE_OWNER                            VARCHAR2(30)

 CTYPE_HASHCODE                         VARCHAR2(34)

 CTYPE_MOD                              VARCHAR2(3)

 DATA_LENGTH                            VARCHAR2(40)

 DATA_PRECISION                         VARCHAR2(40)

 DATA_SCALE                             VARCHAR2(40)

 NULLABLE                               VARCHAR2(1)

 CHARACTER_SET_NAME                     VARCHAR2(44)

 TOP                                    VARCHAR2(30)

 CHAR_LENGTH                            NUMBER

 CHAR_USED                              VARCHAR2(1)

 

DBA_REPCOLUMN_GROUP: All column groups of replicated tables in the database

 

iSelfSchooling-SQL> desc DBA_REPCOLUMN_GROUP;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 GROUP_NAME                    NOT NULL VARCHAR2(30)

 GROUP_COMMENT                          VARCHAR2(80)

 

DBA_REPCONFLICT: All conflicts for which users have specified resolutions in the database

 

iSelfSchooling-SQL> desc DBA_REPCONFLICT;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CONFLICT_TYPE                          VARCHAR2(10)

 REFERENCE_NAME                NOT NULL VARCHAR2(30)

 

DBA_REPDDL: Arguments that do not fit in a single repcat log record

 

iSelfSchooling-SQL> desc DBA_REPDDL;

 Name                          Null?    Type

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

 LOG_ID                                 NUMBER

 SOURCE                                 VARCHAR2(128)

 ROLE                                   VARCHAR2(1)

 MASTER                                 VARCHAR2(128)

 LINE                                   NUMBER(38)

 TEXT                                   VARCHAR2(2000)

 DDL_NUM                                NUMBER(38)

 

DBA_REPEXTENSIONS: Information about replication extension requests

 

iSelfSchooling-SQL> desc DBA_REPEXTENSIONS;

 Name                          Null?    Type

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

 EXTENSION_ID                  NOT NULL RAW(16)

 REQUEST                                VARCHAR2(15)

 MASTERDEF                              VARCHAR2(128)

 EXPORT_REQUIRED                        VARCHAR2(3)

 REPCATLOG_ID                           NUMBER

 EXTENSION_STATUS                       VARCHAR2(13)

 FLASHBACK_SCN                          NUMBER

 BREAK_TRANS_TO_MASTERDEF               VARCHAR2(3)

 BREAK_TRANS_TO_NEW_MASTERS             VARCHAR2(3)

 PERCENTAGE_FOR_CATCHUP_MDEF            NUMBER

 CYCLE_SECONDS_MDEF                     NUMBER

 PERCENTAGE_FOR_CATCHUP_NEW             NUMBER

 CYCLE_SECONDS_NEW                      NUMBER

 

DBA_REPFLAVORS: Flavors defined for replicated object groups

 

iSelfSchooling-SQL> desc DBA_REPFLAVORS;

 Name                          Null?    Type

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

 FLAVOR_ID                     NOT NULL NUMBER

 GNAME                         NOT NULL VARCHAR2(30)

 FNAME                                  VARCHAR2(30)

 CREATION_DATE                          DATE

 CREATED_BY                             VARCHAR2(30)

 PUBLISHED                              VARCHAR2(1)

 GROUP_OWNER                            VARCHAR2(30)

 

DBA_REPFLAVOR_COLUMNS: Replicated columns in flavors

 

iSelfSchooling-SQL> desc DBA_REPFLAVOR_COLUMNS;

 Name                          Null?    Type

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

 FNAME                                  VARCHAR2(30)

 GNAME                         NOT NULL VARCHAR2(30)

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CNAME                                  VARCHAR2(4000)

 TYPE                                   VARCHAR2(30)

 POS                                    NUMBER

 GROUP_OWNER                   NOT NULL VARCHAR2(30)

 TYPE_TOID                              RAW(16)

 TYPE_OWNER                             VARCHAR2(30)

 TYPE_HASHCODE                          VARCHAR2(34)

 TYPE_MOD                               VARCHAR2(3)

 TOP                                    VARCHAR2(30)

 

DBA_REPFLAVOR_OBJECTS: Replicated objects in flavors

 

iSelfSchooling-SQL> desc DBA_REPFLAVOR_OBJECTS;

 Name                          Null?    Type

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

 FNAME                                  VARCHAR2(30)

 GNAME                         NOT NULL VARCHAR2(30)

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(12)

 GROUP_OWNER                   NOT NULL VARCHAR2(30)

 

DBA_REPGENERATED: Objects generated to support replication

 

iSelfSchooling-SQL> desc DBA_REPGENERATED;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(12)

 BASE_SNAME                    NOT NULL VARCHAR2(30)

 BASE_ONAME                    NOT NULL VARCHAR2(30)

 BASE_TYPE                              VARCHAR2(12)

 PACKAGE_PREFIX                         VARCHAR2(30)

 PROCEDURE_PREFIX                       VARCHAR2(30)

 DISTRIBUTED                            VARCHAR2(1)

 REASON                                 VARCHAR2(30)

 

DBA_REPGENOBJECTS: Objects generated to support replication

 

iSelfSchooling-SQL> desc DBA_REPGENOBJECTS;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(12)

 BASE_SNAME                    NOT NULL VARCHAR2(30)

 BASE_ONAME                    NOT NULL VARCHAR2(30)

 BASE_TYPE                              VARCHAR2(12)

 PACKAGE_PREFIX                         VARCHAR2(30)

 PROCEDURE_PREFIX                       VARCHAR2(30)

 DISTRIBUTED                            VARCHAR2(1)

 REASON                                 VARCHAR2(30)

 

DBA_REPGROUP: Information about all replicated object groups

 

iSelfSchooling-SQL> desc DBA_REPGROUP;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 MASTER                                 VARCHAR2(1)

 STATUS                                 VARCHAR2(9)

 SCHEMA_COMMENT                         VARCHAR2(80)

 GNAME                         NOT NULL VARCHAR2(30)

 FNAME                                  VARCHAR2(30)

 RPC_PROCESSING_DISABLED                VARCHAR2(1)

 OWNER                         NOT NULL VARCHAR2(30)

 

DBA_REPGROUPED_COLUMN: Columns in the all column groups of replicated tables in the database

 

iSelfSchooling-SQL> desc DBA_REPGROUPED_COLUMN;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 GROUP_NAME                    NOT NULL VARCHAR2(30)

 COLUMN_NAME                   NOT NULL VARCHAR2(30)

 

DBA_REPGROUP_PRIVILEGES: Information about users who are registered for object group privileges

 

iSelfSchooling-SQL> desc DBA_REPGROUP_PRIVILEGES;

 Name                          Null?    Type

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

 USERNAME                      NOT NULL VARCHAR2(30)

 GNAME                                  VARCHAR2(30)

 CREATED                       NOT NULL DATE

 RECEIVER                               VARCHAR2(1)

 PROXY_SNAPADMIN                        VARCHAR2(1)

 OWNER                                  VARCHAR2(30)

 

DBA_REPKEY_COLUMNS: Primary columns for a table using column-level replication

 

iSelfSchooling-SQL> desc DBA_REPKEY_COLUMNS;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 COL                                    VARCHAR2(4000)

 

DBA_REPOBJECT: Information about replicated objects

 

iSelfSchooling-SQL> desc DBA_REPOBJECT;

 Name                          Null?    Type

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

 SNAME                                  VARCHAR2(30)

 ONAME                                  VARCHAR2(30)

 TYPE                                   VARCHAR2(16)

 STATUS                                 VARCHAR2(10)

 GENERATION_STATUS                      VARCHAR2(9)

 ID                                     NUMBER

 OBJECT_COMMENT                         VARCHAR2(80)

 GNAME                                  VARCHAR2(30)

 MIN_COMMUNICATION                      VARCHAR2(1)

 REPLICATION_TRIGGER_EXISTS             VARCHAR2(1)

 INTERNAL_PACKAGE_EXISTS                VARCHAR2(1)

 GROUP_OWNER                            VARCHAR2(30)

 NESTED_TABLE                           VARCHAR2(1)

 

DBA_REPPARAMETER_COLUMN: All columns used for resolving conflicts in the database

 

iSelfSchooling-SQL> desc DBA_REPPARAMETER_COLUMN;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CONFLICT_TYPE                          VARCHAR2(10)

 REFERENCE_NAME                NOT NULL VARCHAR2(30)

 SEQUENCE_NO                   NOT NULL NUMBER

 METHOD_NAME                   NOT NULL VARCHAR2(80)

 FUNCTION_NAME                 NOT NULL VARCHAR2(92)

 PRIORITY_GROUP                         VARCHAR2(30)

 PARAMETER_TABLE_NAME          NOT NULL VARCHAR2(30)

 PARAMETER_COLUMN_NAME                  VARCHAR2(4000)

 PARAMETER_SEQUENCE_NO         NOT NULL NUMBER

 

DBA_REPPRIORITY: Values and their corresponding priorities in all priority groups in the database

 

iSelfSchooling-SQL> desc DBA_REPPRIORITY;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 PRIORITY_GROUP                NOT NULL VARCHAR2(30)

 PRIORITY                      NOT NULL NUMBER

 DATA_TYPE                              VARCHAR2(9)

 FIXED_DATA_LENGTH                      NUMBER(38)

 CHAR_VALUE                             CHAR(255)

 VARCHAR2_VALUE                         VARCHAR2(4000)

 NUMBER_VALUE                           NUMBER

 DATE_VALUE                             DATE

 RAW_VALUE                              RAW(2000)

 GNAME                         NOT NULL VARCHAR2(30)

 NCHAR_VALUE                            NCHAR(500)

 NVARCHAR2_VALUE                        NVARCHAR2(1000)

 LARGE_CHAR_VALUE                       CHAR(2000)

 

DBA_REPPRIORITY_GROUP: Information about all priority groups in the database

 

iSelfSchooling-SQL> desc DBA_REPPRIORITY_GROUP;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 PRIORITY_GROUP                NOT NULL VARCHAR2(30)

 DATA_TYPE                              VARCHAR2(9)

 FIXED_DATA_LENGTH                      NUMBER(38)

 PRIORITY_COMMENT                       VARCHAR2(80)

 GNAME                         NOT NULL VARCHAR2(30)

 

DBA_REPPROP: Propagation information about replicated objects

 

iSelfSchooling-SQL> desc DBA_REPPROP;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 TYPE                                   VARCHAR2(16)

 DBLINK                        NOT NULL VARCHAR2(128)

 HOW                                    VARCHAR2(13)

 PROPAGATE_COMMENT                      VARCHAR2(80)

 

DBA_REPRESOLUTION: Description of all conflict resolutions in the database

 

iSelfSchooling-SQL> desc DBA_REPRESOLUTION;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CONFLICT_TYPE                          VARCHAR2(10)

 REFERENCE_NAME                NOT NULL VARCHAR2(30)

 SEQUENCE_NO                   NOT NULL NUMBER

 METHOD_NAME                   NOT NULL VARCHAR2(80)

 FUNCTION_NAME                 NOT NULL VARCHAR2(92)

 PRIORITY_GROUP                         VARCHAR2(30)

 RESOLUTION_COMMENT                     VARCHAR2(80)

 

DBA_REPRESOLUTION_METHOD: All conflict resolution methods in the database

 

iSelfSchooling-SQL> desc DBA_REPRESOLUTION_METHOD;

 Name                          Null?    Type

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

 CONFLICT_TYPE                          VARCHAR2(10)

 METHOD_NAME                   NOT NULL VARCHAR2(80)

 

DBA_REPRESOLUTION_STATISTICS: Statistics for conflict resolutions for all replicated tables in the database

 

iSelfSchooling-SQL> desc DBA_REPRESOLUTION_STATISTICS;

 Name                          Null?    Type

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

 SNAME                         NOT NULL VARCHAR2(30)

 ONAME                         NOT NULL VARCHAR2(30)

 CONFLICT_TYPE                          VARCHAR2(10)

 REFERENCE_NAME                NOT NULL VARCHAR2(30)

 METHOD_NAME                   NOT NULL VARCHAR2(80)

 FUNCTION_NAME                          VARCHAR2(92)

 PRIORITY_GROUP                         VARCHAR2(30)

 RESOLVED_DATE                 NOT NULL DATE

 PRIMARY_KEY_VALUE             NOT NULL VARCHAR2(2000)

 

 

 

Google
 
Web web site