|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_REPGROUPED_COLUMN: Columns in the all column groups of
user's replicated tables
iSelfSchooling-SQL> desc USER_REPGROUPED_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
ONAME
VARCHAR2(30)
GROUP_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
USER_REPGROUP_PRIVILEGES: Information about users who are
registered for object group privileges
iSelfSchooling-SQL> desc USER_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)
USER_REPKEY_COLUMNS: Primary columns for a table using
column-level replication
iSelfSchooling-SQL> desc USER_REPKEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
ONAME
NOT NULL VARCHAR2(30)
COL
VARCHAR2(4000)
USER_REPOBJECT: Replication information about the current user's objects
iSelfSchooling-SQL> desc USER_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)
USER_REPPARAMETER_COLUMN: All columns used for resolving
conflicts in user's replicated tables
iSelfSchooling-SQL> desc USER_REPPARAMETER_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
VARCHAR2(30)
SEQUENCE_NO
NUMBER
METHOD_NAME
VARCHAR2(80)
FUNCTION_NAME
VARCHAR2(92)
PRIORITY_GROUP
VARCHAR2(30)
PARAMETER_TABLE_NAME
VARCHAR2(30)
PARAMETER_COLUMN_NAME
VARCHAR2(4000)
PARAMETER_SEQUENCE_NO
NUMBER
USER_REPPRIORITY: Values and their corresponding
priorities in user's priority groups
iSelfSchooling-SQL> desc USER_REPPRIORITY;
Name
Null? Type
----------------------------- -------- --------------------
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)
NCHAR_VALUE
NCHAR(500)
NVARCHAR2_VALUE
NVARCHAR2(1000)
LARGE_CHAR_VALUE
CHAR(2000)
USER_REPPRIORITY_GROUP: Information about user's priority
groups
iSelfSchooling-SQL> desc USER_REPPRIORITY_GROUP;
Name
Null? Type
----------------------------- -------- --------------------
PRIORITY_GROUP
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(9)
FIXED_DATA_LENGTH
NUMBER(38)
PRIORITY_COMMENT
VARCHAR2(80)
USER_REPPROP: Propagation information about the
current user's objects
iSelfSchooling-SQL> desc USER_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)
USER_REPRESOLUTION: Description of all conflict resolutions
for users replicated tables
iSelfSchooling-SQL> desc USER_REPRESOLUTION;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_REPRESOLUTION_METHOD: All conflict resolution methods
accessible to the user
iSelfSchooling-SQL> desc USER_REPRESOLUTION_METHOD;
Name
Null? Type
----------------------------- -------- --------------------
CONFLICT_TYPE
VARCHAR2(10)
METHOD_NAME
NOT NULL VARCHAR2(80)
USER_REPRESOLUTION_STATISTICS: Statistics for conflict resolutions for
user's replicated tables
iSelfSchooling-SQL> desc USER_REPRESOLUTION_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_REPRESOL_STATS_CONTROL: Information about statistics collection
for conflict resolutions for user's replicated tables
iSelfSchooling-SQL> desc USER_REPRESOL_STATS_CONTROL;
Name
Null? Type
----------------------------- -------- --------------------
ONAME
NOT NULL VARCHAR2(30)
CREATED
NOT NULL DATE
STATUS
VARCHAR2(9)
STATUS_UPDATE_DATE
NOT NULL DATE
PURGED_DATE
DATE
LAST_PURGE_START_DATE
DATE
LAST_PURGE_END_DATE
DATE
USER_REPSCHEMA: N-way replication information about the
current user
iSelfSchooling-SQL> desc USER_REPSCHEMA;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT
NULL VARCHAR2(128)
MASTERDEF
VARCHAR2(1)
SNAPMASTER
VARCHAR2(1)
MASTER_COMMENT
VARCHAR2(80)
GNAME
NOT NULL VARCHAR2(30)
MASTER
VARCHAR2(1)
GROUP_OWNER
NOT NULL VARCHAR2(30)
USER_REPSITES: N-way replication information about the
current user
iSelfSchooling-SQL> desc USER_REPSITES;
Name
Null? Type
----------------------------- -------- --------------------
GNAME
NOT NULL VARCHAR2(30)
DBLINK
NOT NULL VARCHAR2(128)
MASTERDEF
VARCHAR2(1)
SNAPMASTER
VARCHAR2(1)
MASTER_COMMENT
VARCHAR2(80)
MASTER
VARCHAR2(1)
GROUP_OWNER
NOT NULL VARCHAR2(30)
USER_RESOURCE_LIMITS: Display resource limit of the user
iSelfSchooling-SQL> desc USER_RESOURCE_LIMITS;
Name
Null? Type
----------------------------- -------- --------------------
RESOURCE_NAME
NOT NULL VARCHAR2(32)
LIMIT
VARCHAR2(40)
USER_RESUMABLE: Resumable session information for
current user
iSelfSchooling-SQL> desc USER_RESUMABLE;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
INSTANCE_ID
NUMBER
COORD_INSTANCE_ID
NUMBER
COORD_SESSION_ID
NUMBER
STATUS
VARCHAR2(9)
TIMEOUT
NUMBER
START_TIME
VARCHAR2(20)
SUSPEND_TIME
VARCHAR2(20)
RESUME_TIME
VARCHAR2(20)
NAME
VARCHAR2(4000)
SQL_TEXT
VARCHAR2(1000)
ERROR_NUMBER
NUMBER
ERROR_PARAMETER1
VARCHAR2(80)
ERROR_PARAMETER2
VARCHAR2(80)
ERROR_PARAMETER3
VARCHAR2(80)
ERROR_PARAMETER4
VARCHAR2(80)
ERROR_PARAMETER5
&n |