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)
|