ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ADV...
| AUD...
| FIL...
| LOB...
| PAR...
| REP...
| SEQ...
| TAB...
USER_PART_KEY_COLUMNS
iSelfSchooling-SQL> desc USER_PART_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(30)
OBJECT_TYPE
CHAR(5)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NUMBER
USER_PART_LOBS
iSelfSchooling-SQL> desc USER_PART_LOBS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
LOB_NAME
NOT NULL VARCHAR2(30)
LOB_INDEX_NAME
NOT NULL VARCHAR2(30)
DEF_CHUNK
NOT NULL NUMBER
DEF_PCTVERSION
NOT NULL NUMBER
DEF_CACHE
VARCHAR2(10)
DEF_IN_ROW
VARCHAR2(3)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
VARCHAR2(40)
DEF_FREELIST_GROUPS
VARCHAR2(40)
DEF_LOGGING
VARCHAR2(7)
DEF_BUFFER_POOL
VARCHAR2(7)
USER_PART_TABLES
iSelfSchooling-SQL> desc USER_PART_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
VARCHAR2(30)
PARTITIONING_TYPE
VARCHAR2(7)
SUBPARTITIONING_TYPE
VARCHAR2(7)
PARTITION_COUNT
NUMBER
DEF_SUBPARTITION_COUNT
NUMBER
PARTITIONING_KEY_COUNT
NUMBER
SUBPARTITIONING_KEY_COUNT
NUMBER
STATUS
VARCHAR2(8)
DEF_TABLESPACE_NAME
VARCHAR2(30)
DEF_PCT_FREE
NUMBER
DEF_PCT_USED
NUMBER
DEF_INI_TRANS
NUMBER
DEF_MAX_TRANS
NUMBER
DEF_INITIAL_EXTENT
VARCHAR2(40)
DEF_NEXT_EXTENT
VARCHAR2(40)
DEF_MIN_EXTENTS
VARCHAR2(40)
DEF_MAX_EXTENTS
VARCHAR2(40)
DEF_PCT_INCREASE
VARCHAR2(40)
DEF_FREELISTS
NUMBER
DEF_FREELIST_GROUPS
NUMBER
DEF_LOGGING
VARCHAR2(7)
DEF_COMPRESSION
VARCHAR2(8)
DEF_BUFFER_POOL
VARCHAR2(7)
USER_PASSWORD_LIMITS: Display password limits of the user
iSelfSchooling-SQL> desc USER_PASSWORD_LIMITS;
Name
Null? Type
----------------------------- -------- --------------------
RESOURCE_NAME
NOT NULL VARCHAR2(32)
LIMIT
VARCHAR2(40)
USER_PENDING_CONV_TABLES: All user's tables which are not
upgraded to the latest type version
iSelfSchooling-SQL> desc USER_PENDING_CONV_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_NAME
NOT NULL VARCHAR2(30)
USER_PLSQL_OBJECT_SETTINGS: Compiler settings of stored objects
owned by the user
iSelfSchooling-SQL> desc USER_PLSQL_OBJECT_SETTINGS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
TYPE
VARCHAR2(12)
PLSQL_OPTIMIZE_LEVEL
NUMBER
PLSQL_CODE_TYPE
VARCHAR2(4000)
PLSQL_DEBUG
VARCHAR2(4000)
PLSQL_WARNINGS
VARCHAR2(4000)
NLS_LENGTH_SEMANTICS
VARCHAR2(4000)
PLSQL_CCFLAGS
VARCHAR2(4000)
USER_POLICIES: All row level security policies for
synonyms, tables, or views owned by the user
iSelfSchooling-SQL> desc USER_POLICIES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_GROUP
NOT NULL VARCHAR2(30)
POLICY_NAME
NOT NULL VARCHAR2(30)
PF_OWNER
NOT NULL VARCHAR2(30)
PACKAGE
VARCHAR2(30)
FUNCTION
NOT NULL VARCHAR2(30)
SEL
VARCHAR2(3)
INS
VARCHAR2(3)
UPD
VARCHAR2(3)
DEL
VARCHAR2(3)
IDX
VARCHAR2(3)
CHK_OPTION
VARCHAR2(3)
ENABLE
VARCHAR2(3)
STATIC_POLICY
VARCHAR2(3)
POLICY_TYPE
VARCHAR2(24)
LONG_PREDICATE
VARCHAR2(3)
USER_POLICY_CONTEXTS: All policy driving context defined for
synonyms, tables, or views in current schema
iSelfSchooling-SQL> desc USER_POLICY_CONTEXTS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
NAMESPACE
NOT NULL VARCHAR2(30)
ATTRIBUTE
NOT NULL VARCHAR2(30)
USER_POLICY_GROUPS: All policy groups defined for any
synonym, table, or view
iSelfSchooling-SQL> desc USER_POLICY_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
POLICY_GROUP
NOT NULL VARCHAR2(30)
USER_PROCEDURES: Description of the users own procedures
iSelfSchooling-SQL> desc USER_PROCEDURES;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_NAME
NOT NULL VARCHAR2(30)
PROCEDURE_NAME
VARCHAR2(30)
AGGREGATE
VARCHAR2(3)
PIPELINED
VARCHAR2(3)
IMPLTYPEOWNER
VARCHAR2(30)
IMPLTYPENAME
VARCHAR2(30)
PARALLEL
VARCHAR2(3)
INTERFACE
VARCHAR2(3)
DETERMINISTIC
VARCHAR2(3)
AUTHID
VARCHAR2(12)
USER_PROXIES: Description of connections the user is
allowed to proxy
iSelfSchooling-SQL> desc USER_PROXIES;
Name
Null? Type
----------------------------- -------- --------------------
CLIENT
NOT NULL VARCHAR2(30)
AUTHENTICATION
VARCHAR2(3)
AUTHORIZATION_CONSTRAINT
VARCHAR2(35)
ROLE
VARCHAR2(30)
USER_PUBLISHED_COLUMNS: Source columns available for Change
Data Capture
iSelfSchooling-SQL> desc USER_PUBLISHED_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
CHANGE_SET_NAME
NOT NULL VARCHAR2(30)
PUB_ID
NOT NULL NUMBER
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
DATA_TYPE VARCHAR2(106)
DATA_LENGTH
NOT NULL NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
NULLABLE
VARCHAR2(1)
USER_QUEUES: All queues owned by the user
iSelfSchooling-SQL> desc USER_QUEUES;
Name
Null? Type
----------------------------- -------- --------------------
NAME
NOT NULL VARCHAR2(30)
QUEUE_TABLE
NOT NULL VARCHAR2(30)
QID
NOT NULL NUMBER
QUEUE_TYPE
VARCHAR2(20)
MAX_RETRIES
NUMBER
RETRY_DELAY
NUMBER
ENQUEUE_ENABLED
VARCHAR2(7)
DEQUEUE_ENABLED
VARCHAR2(7)
RETENTION
VARCHAR2(40)
USER_COMMENT
VARCHAR2(50)
NETWORK_NAME
VARCHAR2(512)
USER_QUEUE_PUBLISHERS
iSelfSchooling-SQL> desc USER_QUEUE_PUBLISHERS;
Name
Null? Type
----------------------------- -------- --------------------
QUEUE_NAME
NOT NULL VARCHAR2(30)
PUBLISHER_NAME
VARCHAR2(30)
PUBLISHER_ADDRESS
VARCHAR2(1024)
PUBLISHER_PROTOCOL
NUMBER
PUBLISHER_RULE
VARCHAR2(2000)
PUBLISHER_RULE_NAME
VARCHAR2(61)
PUBLISHER_RULESET
VARCHAR2(61)
PUBLISHER_TRANSFORMATION
VARCHAR2(61)
USER_QUEUE_SCHEDULES
iSelfSchooling-SQL> desc USER_QUEUE_SCHEDULES;
Name
Null? Type
----------------------------- -------- --------------------
QNAME
VARCHAR2(30)
DESTINATION
VARCHAR2(128)
START_DATE
DATE
START_TIME
VARCHAR2(8)
PROPAGATION_WINDOW
NUMBER
NEXT_TIME
VARCHAR2(200)
LATENCY
NUMBER
SCHEDULE_DISABLED
VARCHAR2(1)
PROCESS_NAME
VARCHAR2(8)
SESSION_ID
VARCHAR2(82)
INSTANCE
NUMBER
LAST_RUN_DATE
DATE
LAST_RUN_TIME
VARCHAR2(8)
CURRENT_START_DATE
DATE
CURRENT_START_TIME
VARCHAR2(8)
NEXT_RUN_DATE
DATE
NEXT_RUN_TIME
VARCHAR2(8)
TOTAL_TIME
NUMBER
TOTAL_NUMBER
NUMBER
TOTAL_BYTES
NUMBER
MAX_NUMBER
NUMBER
MAX_BYTES
NUMBER
AVG_NUMBER
NUMBER
AVG_SIZE
NUMBER
AVG_TIME
NUMBER
FAILURES
NUMBER
LAST_ERROR_DATE
DATE
LAST_ERROR_TIME
VARCHAR2(8)
LAST_ERROR_MSG
VARCHAR2(4000)
MESSAGE_DELIVERY_MODE
VARCHAR2(10)
ELAPSED_DEQUEUE_TIME
NUMBER
ELAPSED_PICKLE_TIME
NUMBER
USER_QUEUE_SUBSCRIBERS: queue subscribers under a user’
schema
iSelfSchooling-SQL> desc USER_QUEUE_SUBSCRIBERS;
Name
Null? Type
----------------------------- -------- --------------------
QUEUE_NAME
NOT NULL VARCHAR2(30)
QUEUE_TABLE
NOT NULL VARCHAR2(30)
CONSUMER_NAME
VARCHAR2(30)
ADDRESS
VARCHAR2(1024)
PROTOCOL
NUMBER
TRANSFORMATION
VARCHAR2(61)
DELIVERY_MODE
VARCHAR2(22)
QUEUE_TO_QUEUE
VARCHAR2(5)
USER_QUEUE_TABLES: All queue tables created by the user
iSelfSchooling-SQL> desc USER_QUEUE_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
QUEUE_TABLE
VARCHAR2(30)
TYPE
VARCHAR2(7)
OBJECT_TYPE
VARCHAR2(61)
SORT_ORDER
VARCHAR2(22)
RECIPIENTS
VARCHAR2(8)
MESSAGE_GROUPING
VARCHAR2(13)
COMPATIBLE
VARCHAR2(6)
PRIMARY_INSTANCE
NUMBER
SECONDARY_INSTANCE
NUMBER
OWNER_INSTANCE
NUMBER
USER_COMMENT
VARCHAR2(50)
SECURE
VARCHAR2(3)
USER_RECYCLEBIN: User view of his recyclebin
iSelfSchooling-SQL> desc USER_RECYCLEBIN;
Name
Null? Type
----------------------------- -------- --------------------
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
USER_REFRESH: All the refresh groups
iSelfSchooling-SQL> desc USER_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)
USER_REFRESH_CHILDREN: All the objects in refresh groups,
where the user owns the refresh group
iSelfSchooling-SQL> desc USER_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)
USER_REFS: Description of the user's own REF
columns contained in the user's own tables
iSelfSchooling-SQL> desc USER_REFS;
Name
Null? Type
----------------------------- -------- --------------------
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)
USER_REGISTERED_MVIEWS: Remote materialized views of local
tables currently using logs owned by the user
iSelfSchooling-SQL> desc USER_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
USER_REGISTERED_SNAPSHOTS: Remote snapshots of local tables
currently using logs owned by the user
iSelfSchooling-SQL> desc USER_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
USER_REGISTRY
iSelfSchooling-SQL> desc USER_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)
USER_REPAUDIT_ATTRIBUTE: Information about attributes
automatically maintained for replication
iSelfSchooling-SQL> desc USER_REPAUDIT_ATTRIBUTE;
Name
Null? Type
----------------------------- -------- --------------------
ATTRIBUTE
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(9)
DATA_LENGTH
NUMBER(38)
SOURCE
NOT NULL VARCHAR2(92)
USER_REPAUDIT_COLUMN: Information about columns in all shadow
tables for user's replicated tables
iSelfSchooling-SQL> desc USER_REPAUDIT_COLUMN;
Name
Null?
Type
----------------------------- -------- --------------------
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)
USER_REPCAT
iSelfSchooling-SQL> desc USER_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)
USER_REPCATLOG: Information about the current user's
asynchronous administration requests
iSelfSchooling-SQL> desc USER_REPCATLOG;
Name
Null? Type
----------------------------- -------- --------------------
ID
NOT
NULL NUMBER
SOURCE
NOT NULL VARCHAR2(128)
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)
STATUS
VARCHAR2(14)
MESSAGE
VARCHAR2(200)
ERRNUM
NUMBER
GNAME
VARCHAR2(30)
USER_REPCOLUMN: Replicated columns for the current
user's table in ascending order
iSelfSchooling-SQL> desc USER_REPCOLUMN;
Name
Null? Type
----------------------------- -------- --------------------
SNAME
VARCHAR2(30)
ONAME
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)
USER_REPCOLUMN_GROUP: All column groups of user's replicated
tables
iSelfSchooling-SQL> desc USER_REPCOLUMN_GROUP;
Name
Null? Type
----------------------------- -------- --------------------
ONAME
NOT NULL VARCHAR2(30)
GROUP_NAME
NOT NULL VARCHAR2(30)
GROUP_COMMENT
VARCHAR2(80)
USER_REPCONFLICT
iSelfSchooling-SQL> desc USER_REPCONFLICT;
Name
Null? Type
----------------------------- -------- --------------------
ONAME
NOT NULL VARCHAR2(30)
CONFLICT_TYPE
VARCHAR2(10)
REFERENCE_NAME
NOT NULL VARCHAR2(30)
USER_REPDDL: Arguments that do not fit in a single
repcat log record
iSelfSchooling-SQL> desc USER_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)
USER_REPFLAVORS: Flavors current user created for
replicated object groups
iSelfSchooling-SQL> desc USER_REPFLAVORS;
Name
Null? Type
----------------------------- -------- --------------------
FLAVOR_ID
NOT NULL NUMBER
GNAME
NOT NULL VARCHAR2(30)
FNAME
VARCHAR2(30)
CREATION_DATE
DATE
CREATED_BY
NOT NULL VARCHAR2(30)
PUBLISHED
VARCHAR2(1)
GROUP_OWNER
VARCHAR2(30)
USER_REPFLAVOR_COLUMNS: Replicated columns from current user's
tables in flavors
iSelfSchooling-SQL> desc USER_REPFLAVOR_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
FNAME
VARCHAR2(30)
GNAME
VARCHAR2(30)
SNAME
VARCHAR2(30)
ONAME
VARCHAR2(30)
CNAME
VARCHAR2(4000)
TYPE
VARCHAR2(30)
POS
NUMBER
GROUP_OWNER
VARCHAR2(30)
TYPE_TOID
RAW(16)
TYPE_OWNER
VARCHAR2(30)
TYPE_HASHCODE
VARCHAR2(34)
TYPE_MOD
VARCHAR2(3)
TOP
VARCHAR2(30)
USER_REPFLAVOR_OBJECTS: Replicated user objects in flavors
iSelfSchooling-SQL> desc USER_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)
USER_REPGENERATED: Objects generated for the current user
to support replication
iSelfSchooling-SQL> desc USER_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)
USER_REPGENOBJECTS: Objects generated for the current user
to support replication
iSelfSchooling-SQL> desc USER_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)
USER_REPGROUP: Replication information about the
current user
iSelfSchooling-SQL> desc USER_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)
|