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

ADV... | AUD... | FIL... | LOB... | PAR... | REP... | SEQ... | TAB...

USER_AUDIT_SESSION: All audit trail records concerning CONNECT and DISCONNECT

iSelfSchooling-SQL> desc USER_AUDIT_SESSION;

Name Null? Type

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

OS_USERNAME VARCHAR2(255)

USERNAME VARCHAR2(30)

USERHOST VARCHAR2(128)

TERMINAL VARCHAR2(255)

TIMESTAMP DATE

ACTION_NAME VARCHAR2(28)

LOGOFF_TIME DATE

LOGOFF_LREAD NUMBER

LOGOFF_PREAD NUMBER

LOGOFF_LWRITE NUMBER

LOGOFF_DLOCK VARCHAR2(40)

SESSIONID NOT NULL NUMBER

RETURNCODE NOT NULL NUMBER

CLIENT_ID VARCHAR2(64)

SESSION_CPU NUMBER

EXTENDED_TIMESTAMP TIMESTAMP(6)

PROXY_SESSIONID NUMBER

GLOBAL_UID VARCHAR2(32)

INSTANCE_NUMBER NUMBER

OS_PROCESS VARCHAR2(16)

USER_AUDIT_STATEMENT: Audit trail records concerning grant, revoke, audit, no-audit and alter system

iSelfSchooling-SQL> desc USER_AUDIT_STATEMENT;

Name Null? Type

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

OS_USERNAME VARCHAR2(255)

USERNAME VARCHAR2(30)

USERHOST VARCHAR2(128)

TERMINAL VARCHAR2(255)

TIMESTAMP DATE

OWNER VARCHAR2(30)

OBJ_NAME VARCHAR2(128)

ACTION_NAME VARCHAR2(28)

NEW_NAME VARCHAR2(128)

OBJ_PRIVILEGE VARCHAR2(16)

SYS_PRIVILEGE VARCHAR2(40)

ADMIN_OPTION VARCHAR2(1)

GRANTEE VARCHAR2(30)

AUDIT_OPTION VARCHAR2(40)

SES_ACTIONS VARCHAR2(19)

COMMENT_TEXT VARCHAR2(4000)

SESSIONID NOT NULL NUMBER

ENTRYID NOT NULL NUMBER

STATEMENTID NOT NULL NUMBER

RETURNCODE NOT NULL NUMBER

PRIV_USED VARCHAR2(40)

CLIENT_ID VARCHAR2(64)

ECONTEXT_ID VARCHAR2(64)

SESSION_CPU NUMBER

EXTENDED_TIMESTAMP TIMESTAMP(6)

PROXY_SESSIONID NUMBER

GLOBAL_UID VARCHAR2(32)

INSTANCE_NUMBER NUMBER

OS_PROCESS VARCHAR2(16)

TRANSACTIONID RAW(8)

SCN NUMBER

SQL_BIND NVARCHAR2(2000)

SQL_TEXT NVARCHAR2(2000)

USER_AUDIT_TRAIL: Audit trail entries relevant to the user

iSelfSchooling-SQL> desc USER_AUDIT_TRAIL;

Name Null? Type

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

OS_USERNAME VARCHAR2(255)

USERNAME VARCHAR2(30)

USERHOST VARCHAR2(128)

TERMINAL VARCHAR2(255)

TIMESTAMP DATE

OWNER VARCHAR2(30)

OBJ_NAME VARCHAR2(128)

ACTION NOT NULL NUMBER

ACTION_NAME VARCHAR2(28)

NEW_OWNER VARCHAR2(30)

NEW_NAME VARCHAR2(128)

OBJ_PRIVILEGE VARCHAR2(16)

SYS_PRIVILEGE VARCHAR2(40)

ADMIN_OPTION VARCHAR2(1)

GRANTEE VARCHAR2(30)

AUDIT_OPTION VARCHAR2(40)

SES_ACTIONS VARCHAR2(19)

LOGOFF_TIME DATE

LOGOFF_LREAD NUMBER

LOGOFF_PREAD NUMBER

LOGOFF_LWRITE NUMBER

LOGOFF_DLOCK VARCHAR2(40)

COMMENT_TEXT VARCHAR2(4000)

SESSIONID NOT NULL NUMBER

ENTRYID NOT NULL NUMBER

STATEMENTID NOT NULL NUMBER

RETURNCODE NOT NULL NUMBER

PRIV_USED VARCHAR2(40)

CLIENT_ID VARCHAR2(64)

ECONTEXT_ID VARCHAR2(64)

SESSION_CPU NUMBER

EXTENDED_TIMESTAMP TIMESTAMP(6)

PROXY_SESSIONID NUMBER

GLOBAL_UID VARCHAR2(32)

INSTANCE_NUMBER NUMBER

OS_PROCESS VARCHAR2(16)

TRANSACTIONID RAW(8)

SCN NUMBER

SQL_BIND NVARCHAR2(2000)

SQL_TEXT NVARCHAR2(2000)

USER_AWS: Analytic Workspaces owned by the user

iSelfSchooling-SQL> desc USER_AWS;

Name Null? Type

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

AW_NUMBER NOT NULL NUMBER

AW_NAME VARCHAR2(30)

PAGESPACES NUMBER

GENERATIONS NUMBER

USER_AW_OBJ: Objects in Analytic Workspaces owned by the user

iSelfSchooling-SQL> desc USER_AW_OBJ;

Name Null? Type

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

AW_NUMBER NOT NULL NUMBER

AW_NAME VARCHAR2(30)

OBJ_ID NUMBER(20)

OBJ_NAME VARCHAR2(256)

OBJ_TYPE NUMBER(4)

PART_NAME VARCHAR2(256)

USER_AW_PROP: Object properties in Analytic Workspaces owned by the user

iSelfSchooling-SQL> desc USER_AW_PROP;

Name Null? Type

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

AW_NUMBER NOT NULL NUMBER

AW_NAME VARCHAR2(30)

OBJ_ID NUMBER(20)

OBJ_NAME VARCHAR2(256)

PROPERTY_NAME VARCHAR2(256)

PROPERTY_TYPE VARCHAR2(4000)

PROPERTY_VALUE VARCHAR2(4000)

FULL_PROPERTY_VALUE CLOB

PROPERTY_VALUE_LENGTH NUMBER

USER_AW_PS: Pagespaces in Analytic Workspaces owned by the user

iSelfSchooling-SQL> desc USER_AW_PS;

Name Null? Type

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

AW_NUMBER NOT NULL NUMBER

AW_NAME VARCHAR2(30)

PSNUMBER NUMBER(10)

GENERATIONS NUMBER

MAXPAGES NUMBER

USER_BASE_TABLE_MVIEWS: All materialized views with log(s) owned by the user in the database

iSelfSchooling-SQL> desc USER_BASE_TABLE_MVIEWS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

MASTER NOT NULL VARCHAR2(30)

MVIEW_LAST_REFRESH_TIME NOT NULL DATE

MVIEW_ID NUMBER(38)

USER_CATALOG: Tables, Views, Synonyms and Sequences owned by the user

iSelfSchooling-SQL> desc USER_CATALOG;

Name Null? Type

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

TABLE_NAME NOT NULL VARCHAR2(30)

TABLE_TYPE VARCHAR2(11)

USER_CHANGE_NOTIFICATION_REGS: change notification registrations for current user

iSelfSchooling-SQL> desc USER_CHANGE_NOTIFICATION_REGS;

Name Null? Type

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

REGID NUMBER

REGFLAGS NUMBER

CALLBACK VARCHAR2(256)

OPERATIONS_FILTER NUMBER

CHANGELAG NUMBER

TIMEOUT NUMBER

TABLE_NAME VARCHAR2(63)

USER_CLUSTERS: Descriptions of user's own clusters

iSelfSchooling-SQL> desc USER_CLUSTERS;

Name Null? Type

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

CLUSTER_NAME NOT NULL VARCHAR2(30)

TABLESPACE_NAME NOT NULL VARCHAR2(30)

PCT_FREE NUMBER

PCT_USED NUMBER

KEY_SIZE NUMBER

INI_TRANS NOT NULL NUMBER

MAX_TRANS NOT NULL NUMBER

INITIAL_EXTENT NUMBER

NEXT_EXTENT NUMBER

MIN_EXTENTS NOT NULL NUMBER

MAX_EXTENTS NOT NULL NUMBER

PCT_INCREASE NUMBER

FREELISTS NUMBER

FREELIST_GROUPS NUMBER

AVG_BLOCKS_PER_KEY NUMBER

CLUSTER_TYPE VARCHAR2(5)

FUNCTION VARCHAR2(15)

HASHKEYS NUMBER

DEGREE VARCHAR2(10)

INSTANCES VARCHAR2(10)

CACHE VARCHAR2(5)

BUFFER_POOL VARCHAR2(7)

SINGLE_TABLE VARCHAR2(5)

DEPENDENCIES VARCHAR2(8)

USER_CLUSTER_HASH_EXPRESSIONS: Hash functions for the user's hash clusters

iSelfSchooling-SQL> desc USER_CLUSTER_HASH_EXPRESSIONS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

CLUSTER_NAME NOT NULL VARCHAR2(30)

HASH_EXPRESSION LONG

USER_CLU_COLUMNS: Mapping of table columns to cluster columns

iSelfSchooling-SQL> desc USER_CLU_COLUMNS;

Name Null? Type

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

CLUSTER_NAME NOT NULL VARCHAR2(30)

CLU_COLUMN_NAME NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

TAB_COLUMN_NAME VARCHAR2(4000)

USER_COLL_TYPES: Description of the user's own named collection types

iSelfSchooling-SQL> desc USER_COLL_TYPES;

Name Null? Type

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

TYPE_NAME NOT NULL VARCHAR2(30)

COLL_TYPE NOT NULL VARCHAR2(30)

UPPER_BOUND NUMBER

ELEM_TYPE_MOD VARCHAR2(7)

ELEM_TYPE_OWNER VARCHAR2(30)

ELEM_TYPE_NAME VARCHAR2(30)

LENGTH NUMBER

PRECISION NUMBER

SCALE NUMBER

CHARACTER_SET_NAME VARCHAR2(44)

ELEM_STORAGE VARCHAR2(7)

NULLS_STORED VARCHAR2(3)

USER_COL_COMMENTS: Comments on columns of user's tables and views

iSelfSchooling-SQL> desc USER_COL_COMMENTS;

Name Null? Type

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

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

COMMENTS VARCHAR2(4000)

USER_COL_PRIVS: Grants on columns for which the user is the owner, grantor or grantee

iSelfSchooling-SQL> desc USER_COL_PRIVS;

Name Null? Type

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

GRANTEE NOT NULL VARCHAR2(30)

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

GRANTOR NOT NULL VARCHAR2(30)

PRIVILEGE NOT NULL VARCHAR2(40)

GRANTABLE VARCHAR2(3)

USER_COL_PRIVS_MADE: All grants on columns of objects owned by the user

iSelfSchooling-SQL> desc USER_COL_PRIVS_MADE;

Name Null? Type

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

GRANTEE NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

GRANTOR NOT NULL VARCHAR2(30)

PRIVILEGE NOT NULL VARCHAR2(40)

GRANTABLE VARCHAR2(3)

USER_COL_PRIVS_RECD: Grants on columns for which the user is the grantee

iSelfSchooling-SQL> desc USER_COL_PRIVS_RECD;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

GRANTOR NOT NULL VARCHAR2(30)

PRIVILEGE NOT NULL VARCHAR2(40)

GRANTABLE VARCHAR2(3)

USER_CONSTRAINTS: Constraint definitions on user's own tables

iSelfSchooling-SQL> desc USER_CONSTRAINTS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

CONSTRAINT_NAME NOT NULL VARCHAR2(30)

CONSTRAINT_TYPE VARCHAR2(1)

TABLE_NAME NOT NULL VARCHAR2(30)

SEARCH_CONDITION LONG

R_OWNER VARCHAR2(30)

R_CONSTRAINT_NAME VARCHAR2(30)

DELETE_RULE VARCHAR2(9)

STATUS VARCHAR2(8)

DEFERRABLE VARCHAR2(14)

DEFERRED VARCHAR2(9)

VALIDATED VARCHAR2(13)

GENERATED VARCHAR2(14)

BAD VARCHAR2(3)

RELY VARCHAR2(4)

LAST_CHANGE DATE

INDEX_OWNER VARCHAR2(30)

INDEX_NAME VARCHAR2(30)

INVALID VARCHAR2(7)

VIEW_RELATED VARCHAR2(14)

USER_CONS_COLUMNS: Information about accessible columns in constraint definitions

iSelfSchooling-SQL> desc USER_CONS_COLUMNS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

CONSTRAINT_NAME NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

POSITION NUMBER

USER_CONS_OBJ_COLUMNS: List of types an object column or attribute is constrained to in the tables owned by the user

iSelfSchooling-SQL> desc USER_CONS_OBJ_COLUMNS;

Name Null? Type

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

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

CONS_TYPE_OWNER VARCHAR2(30)

CONS_TYPE_NAME VARCHAR2(30)

CONS_TYPE_ONLY VARCHAR2(15)

USER_DATAPUMP_JOBS: Datapump jobs for current user

iSelfSchooling-SQL> desc USER_DATAPUMP_JOBS;

Name Null? Type

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

JOB_NAME VARCHAR2(30)

OPERATION VARCHAR2(30)

JOB_MODE VARCHAR2(30)

STATE VARCHAR2(30)

DEGREE NUMBER

ATTACHED_SESSIONS NUMBER

DATAPUMP_SESSIONS NUMBER

USER_DB_LINKS: Database links owned by the user

iSelfSchooling-SQL> desc USER_DB_LINKS;

Name Null? Type

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

DB_LINK NOT NULL VARCHAR2(128)

USERNAME VARCHAR2(30)

PASSWORD VARCHAR2(30)

HOST VARCHAR2(2000)

CREATED NOT NULL DATE

USER_DEPENDENCIES: Dependencies to and from a users objects

iSelfSchooling-SQL> desc USER_DEPENDENCIES;

Name Null? Type

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

NAME NOT NULL VARCHAR2(30)

TYPE VARCHAR2(17)

REFERENCED_OWNER VARCHAR2(30)

REFERENCED_NAME VARCHAR2(64)

REFERENCED_TYPE VARCHAR2(17)

REFERENCED_LINK_NAME VARCHAR2(128)

SCHEMAID NUMBER

DEPENDENCY_TYPE VARCHAR2(4)

USER_DIMENSIONS: Description of the dimension objects accessible to the DBA

iSelfSchooling-SQL> desc USER_DIMENSIONS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

DIMENSION_NAME NOT NULL VARCHAR2(30)

INVALID VARCHAR2(1)

COMPILE_STATE VARCHAR2(13)

REVISION NUMBER

USER_DIM_ATTRIBUTES: Representation of the relationship between a dimension level and a functionally dependent column

iSelfSchooling-SQL> desc USER_DIM_ATTRIBUTES;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

DIMENSION_NAME NOT NULL VARCHAR2(30)

ATTRIBUTE_NAME VARCHAR2(30)

LEVEL_NAME VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

INFERRED CHAR(1)

USER_DIM_CHILD_OF: Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension

iSelfSchooling-SQL> desc USER_DIM_CHILD_OF;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

DIMENSION_NAME NOT NULL VARCHAR2(30)

HIERARCHY_NAME VARCHAR2(30)

POSITION NOT NULL NUMBER

CHILD_LEVEL_NAME VARCHAR2(30)

JOIN_KEY_ID VARCHAR2(40)

PARENT_LEVEL_NAME VARCHAR2(30)

USER_DIM_HIERARCHIES: Representation of a dimension hierarchy

iSelfSchooling-SQL> desc USER_DIM_HIERARCHIES;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

DIMENSION_NAME NOT NULL VARCHAR2(30)

HIERARCHY_NAME VARCHAR2(30)

USER_DIM_JOIN_KEY: Representation of a join between two dimension tables.

iSelfSchooling-SQL> desc USER_DIM_JOIN_KEY;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

DIMENSION_NAME NOT NULL VARCHAR2(30)

DIM_KEY_ID NOT NULL NUMBER

LEVEL_NAME VARCHAR2(30)

KEY_POSITION NOT NULL NUMBER

HIERARCHY_NAME VARCHAR2(30)

CHILD_JOIN_OWNER NOT NULL VARCHAR2(30)

CHILD_JOIN_TABLE NOT NULL VARCHAR2(30)

CHILD_JOIN_COLUMN NOT NULL VARCHAR2(30)

CHILD_LEVEL_NAME VARCHAR2(30)

USER_DIM_LEVELS: Description of dimension levels visible to DBA

iSelfSchooling-SQL> desc USER_DIM_LEVELS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

DIMENSION_NAME NOT NULL VARCHAR2(30)

LEVEL_NAME VARCHAR2(30)

NUM_COLUMNS NUMBER

DETAILOBJ_OWNER NOT NULL VARCHAR2(30)

DETAILOBJ_NAME NOT NULL VARCHAR2(30)

SKIP_WHEN_NULL VARCHAR2(1)

USER_DIM_LEVEL_KEY: Representations of columns of a dimension level

iSelfSchooling-SQL> desc USER_DIM_LEVEL_KEY;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

DIMENSION_NAME NOT NULL VARCHAR2(30)

LEVEL_NAME VARCHAR2(30)

KEY_POSITION NOT NULL NUMBER

COLUMN_NAME NOT NULL VARCHAR2(30)

USER_ENCRYPTED_COLUMNS: Encryption information on columns of tables owned by the user

iSelfSchooling-SQL> desc USER_ENCRYPTED_COLUMNS;

Name Null? Type

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

TABLE_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

ENCRYPTION_ALG VARCHAR2(29)

SALT VARCHAR2(3)

USER_EPG_DAD_AUTHORIZATION: DADs authorized to use the user's privileges

iSelfSchooling-SQL> desc USER_EPG_DAD_AUTHORIZATION;

Name Null? Type

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

DAD_NAME NOT NULL VARCHAR2(64)

USER_ERRORS: Current errors on stored objects owned by the user

iSelfSchooling-SQL> desc USER_ERRORS;

Name Null? Type

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

NAME NOT NULL VARCHAR2(30)

TYPE VARCHAR2(12)

SEQUENCE NOT NULL NUMBER

LINE NOT NULL NUMBER

POSITION NOT NULL NUMBER

TEXT NOT NULL VARCHAR2(4000)

ATTRIBUTE VARCHAR2(9)

MESSAGE_NUMBER NUMBER

USER_EVALUATION_CONTEXTS: rule evaluation contexts owned by user

iSelfSchooling-SQL> desc USER_EVALUATION_CONTEXTS;

Name Null? Type

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

EVALUATION_CONTEXT_NAME NOT NULL VARCHAR2(30)

EVALUATION_FUNCTION VARCHAR2(4000)

EVALUATION_CONTEXT_COMMENT VARCHAR2(4000)

USER_EVALUATION_CONTEXT_TABLES: tables in user rule evaluation contexts

iSelfSchooling-SQL> desc USER_EVALUATION_CONTEXT_TABLES;

Name Null? Type

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

EVALUATION_CONTEXT_NAME NOT NULL VARCHAR2(30)

TABLE_ALIAS VARCHAR2(30)

TABLE_NAME VARCHAR2(4000)

USER_EVALUATION_CONTEXT_VARS: variables in user rule evaluation contexts

iSelfSchooling-SQL> desc USER_EVALUATION_CONTEXT_VARS;

Name Null? Type

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

EVALUATION_CONTEXT_NAME NOT NULL VARCHAR2(30)

VARIABLE_NAME VARCHAR2(30)

VARIABLE_TYPE VARCHAR2(4000)

VARIABLE_VALUE_FUNCTION VARCHAR2(4000)

VARIABLE_METHOD_FUNCTION VARCHAR2(228)

USER_EXTENTS: Extents comprising segments owned by the user

iSelfSchooling-SQL> desc USER_EXTENTS;

Name Null? Type

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

SEGMENT_NAME VARCHAR2(81)

PARTITION_NAME VARCHAR2(30)

SEGMENT_TYPE VARCHAR2(18)

TABLESPACE_NAME VARCHAR2(30)

EXTENT_ID NUMBER

BYTES NUMBER

BLOCKS NUMBER

USER_EXTERNAL_LOCATIONS: Description of the user's external tables locations

iSelfSchooling-SQL> desc USER_EXTERNAL_LOCATIONS;

Name Null? Type

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

TABLE_NAME NOT NULL VARCHAR2(30)

LOCATION VARCHAR2(4000)

DIRECTORY_OWNER CHAR(3)

DIRECTORY_NAME VARCHAR2(30)

USER_EXTERNAL_TABLES: Description of the user's own external tables

iSelfSchooling-SQL> desc USER_EXTERNAL_TABLES;

Name Null? Type

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

TABLE_NAME NOT NULL VARCHAR2(30)

TYPE_OWNER CHAR(3)

TYPE_NAME NOT NULL VARCHAR2(30)

DEFAULT_DIRECTORY_OWNER CHAR(3)

DEFAULT_DIRECTORY_NAME NOT NULL VARCHAR2(30)

REJECT_LIMIT VARCHAR2(40)

ACCESS_TYPE VARCHAR2(7)

ACCESS_PARAMETERS VARCHAR2(4000)

PROPERTY VARCHAR2(10)

USER_FILE_GROUPS: Details about file groups

iSelfSchooling-SQL> desc USER_FILE_GROUPS;

Name Null? Type

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

FILE_GROUP_NAME NOT NULL VARCHAR2(30)

KEEP_FILES NOT NULL VARCHAR2(1)

MIN_VERSIONS NOT NULL NUMBER

MAX_VERSIONS NOT NULL NUMBER

RETENTION_DAYS NOT NULL NUMBER

CREATED NOT NULL TIMESTAMP(6)

COMMENTS VARCHAR2(4000)

DEFAULT_DIRECTORY VARCHAR2(30)

USER_FILE_GROUP_EXPORT_INFO: Details about export information of file group versions

iSelfSchooling-SQL> desc USER_FILE_GROUP_EXPORT_INFO;

Name Null? Type

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

FILE_GROUP_NAME NOT NULL VARCHAR2(30)

VERSION_NAME NOT NULL VARCHAR2(30)

VERSION NOT NULL NUMBER

EXPORT_VERSION NOT NULL VARCHAR2(30)

PLATFORM_NAME NOT NULL VARCHAR2(101)

EXPORT_TIME NOT NULL DATE

EXPORT_SCN NUMBER

SOURCE_GLOBAL_NAME VARCHAR2(128)