iSelfSchooling.com - Since 1999 References | Job Openings |

Home | Search more | Oracle Syntax | Instructor-Led in Class | (Members to access to VIDEOS)

Suggestions | Email2aFriend | Homepage us! | Bookmark

Services

Vision/Mission

ShareUrNotes

...

Acknowledgement

Who is who

University Directory

Links...

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_APPLY: Details about the apply process

iSelfSchooling-SQL> desc DBA_APPLY;

Name Null? Type

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

APPLY_NAME NOT NULL VARCHAR2(30)

QUEUE_NAME NOT NULL VARCHAR2(30)

QUEUE_OWNER NOT NULL VARCHAR2(30)

APPLY_CAPTURED VARCHAR2(3)

RULE_SET_NAME VARCHAR2(30)

RULE_SET_OWNER VARCHAR2(30)

APPLY_USER VARCHAR2(30)

APPLY_DATABASE_LINK VARCHAR2(128)

APPLY_TAG RAW(2000)

DDL_HANDLER VARCHAR2(98)

PRECOMMIT_HANDLER VARCHAR2(98)

MESSAGE_HANDLER VARCHAR2(98)

STATUS VARCHAR2(8)

MAX_APPLIED_MESSAGE_NUMBER NUMBER

NEGATIVE_RULE_SET_NAME VARCHAR2(30)

NEGATIVE_RULE_SET_OWNER VARCHAR2(30)

STATUS_CHANGE_TIME DATE

ERROR_NUMBER NUMBER

ERROR_MESSAGE VARCHAR2(4000)

DBA_APPLY_CONFLICT_COLUMNS: Details about conflict resolution

iSelfSchooling-SQL> desc DBA_APPLY_CONFLICT_COLUMNS;

Name Null? Type

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

OBJECT_OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

METHOD_NAME VARCHAR2(92)

RESOLUTION_COLUMN VARCHAR2(4000)

COLUMN_NAME VARCHAR2(30)

APPLY_DATABASE_LINK VARCHAR2(128)

DBA_APPLY_DML_HANDLERS: Details about the dml handler

iSelfSchooling-SQL> desc DBA_APPLY_DML_HANDLERS;

Name Null? Type

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

OBJECT_OWNER NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

OPERATION_NAME VARCHAR2(13)

USER_PROCEDURE VARCHAR2(98)

ERROR_HANDLER VARCHAR2(1)

APPLY_DATABASE_LINK VARCHAR2(128)

APPLY_NAME VARCHAR2(30)

ASSEMBLE_LOBS VARCHAR2(1)

DBA_APPLY_ENQUEUE: Details about the apply enqueue action

iSelfSchooling-SQL> desc DBA_APPLY_ENQUEUE;

Name Null? Type

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

RULE_OWNER NOT NULL VARCHAR2(30)

RULE_NAME NOT NULL VARCHAR2(30)

DESTINATION_QUEUE_NAME VARCHAR2(4000)

DBA_APPLY_ERROR: Error transactions

iSelfSchooling-SQL> desc DBA_APPLY_ERROR;

Name Null? Type

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

APPLY_NAME VARCHAR2(30)

QUEUE_NAME NOT NULL VARCHAR2(30)

QUEUE_OWNER NOT NULL VARCHAR2(30)

LOCAL_TRANSACTION_ID VARCHAR2(22)

SOURCE_DATABASE VARCHAR2(128)

SOURCE_TRANSACTION_ID VARCHAR2(22)

SOURCE_COMMIT_SCN NUMBER

MESSAGE_NUMBER NUMBER

ERROR_NUMBER NUMBER

ERROR_MESSAGE VARCHAR2(4000)

RECIPIENT_ID NUMBER

RECIPIENT_NAME VARCHAR2(30)

MESSAGE_COUNT NUMBER

ERROR_CREATION_TIME DATE

DBA_APPLY_EXECUTE: Details about the apply execute action

iSelfSchooling-SQL> desc DBA_APPLY_EXECUTE;

Name Null? Type

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

RULE_OWNER NOT NULL VARCHAR2(30)

RULE_NAME NOT NULL VARCHAR2(30)

EXECUTE_EVENT VARCHAR2(2)

DBA_APPLY_INSTANTIATED_GLOBAL: Details about database instantiated

iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_GLOBAL;

Name Null? Type

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

SOURCE_DATABASE NOT NULL VARCHAR2(128)

INSTANTIATION_SCN NUMBER

APPLY_DATABASE_LINK VARCHAR2(128)

DBA_APPLY_INSTANTIATED_OBJECTS: Details about objects instantiated

iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_OBJECTS;

Name Null? Type

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

SOURCE_DATABASE NOT NULL VARCHAR2(128)

SOURCE_OBJECT_OWNER NOT NULL VARCHAR2(30)

SOURCE_OBJECT_NAME NOT NULL VARCHAR2(30)

SOURCE_OBJECT_TYPE VARCHAR2(11)

INSTANTIATION_SCN NUMBER

IGNORE_SCN NUMBER

APPLY_DATABASE_LINK VARCHAR2(128)

DBA_APPLY_INSTANTIATED_SCHEMAS: Details about schemas instantiated

iSelfSchooling-SQL> desc DBA_APPLY_INSTANTIATED_SCHEMAS;

Name Null? Type

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

SOURCE_DATABASE NOT NULL VARCHAR2(128)

SOURCE_SCHEMA VARCHAR2(30)

INSTANTIATION_SCN NUMBER

APPLY_DATABASE_LINK VARCHAR2(128)

DBA_APPLY_KEY_COLUMNS: alternative key columns for a table for STREAMS

iSelfSchooling-SQL> desc DBA_APPLY_KEY_COLUMNS;

Name Null? Type

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

OBJECT_OWNER NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

APPLY_DATABASE_LINK VARCHAR2(128)

DBA_APPLY_OBJECT_DEPENDENCIES: Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS

iSelfSchooling-SQL> desc DBA_APPLY_OBJECT_DEPENDENCIES;

Name Null? Type

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

OBJECT_OWNER NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

PARENT_OBJECT_OWNER NOT NULL VARCHAR2(30)

PARENT_OBJECT_NAME NOT NULL VARCHAR2(30)

DBA_APPLY_PARAMETERS: All parameters for apply process

iSelfSchooling-SQL> desc DBA_APPLY_PARAMETERS;

Name Null? Type

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

APPLY_NAME NOT NULL VARCHAR2(30)

PARAMETER NOT NULL VARCHAR2(128)

VALUE VARCHAR2(4000)

SET_BY_USER VARCHAR2(3)

DBA_APPLY_PROGRESS: Information about the progress made by apply process

iSelfSchooling-SQL> desc DBA_APPLY_PROGRESS;

Name Null? Type

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

APPLY_NAME NOT NULL VARCHAR2(30)

SOURCE_DATABASE NOT NULL VARCHAR2(128)

APPLIED_MESSAGE_NUMBER NOT NULL NUMBER

OLDEST_MESSAGE_NUMBER NOT NULL NUMBER

APPLY_TIME DATE

APPLIED_MESSAGE_CREATE_TIME DATE

OLDEST_TRANSACTION_ID VARCHAR2(22)

DBA_APPLY_SPILL_TXNS: treams apply spilled transactions info

iSelfSchooling-SQL> desc DBA_APPLY_SPILL_TXN;

Name Null? Type

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

APPLY_NAME NOT NULL VARCHAR2(30)

XIDUSN NOT NULL NUMBER

XIDSLT NOT NULL NUMBER

XIDSQN NOT NULL NUMBER

FIRST_SCN NOT NULL NUMBER

MESSAGE_COUNT NUMBER

FIRST_MESSAGE_CREATE_TIME DATE

SPILL_CREATION_TIME DATE

DBA_APPLY_TABLE_COLUMNS: Details about the destination table columns

iSelfSchooling-SQL> desc DBA_APPLY_TABLE_COLUMNS;

Name Null? Type

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

OBJECT_OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

COMPARE_OLD_ON_DELETE VARCHAR2(3)

COMPARE_OLD_ON_UPDATE VARCHAR2(3)

APPLY_DATABASE_LINK VARCHAR2(128)

DBA_APPLY_VALUE_DEPENDENCIES: Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS

iSelfSchooling-SQL> desc DBA_APPLY_VALUE_DEPENDENCIES;

Name Null? Type

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

DEPENDENCY_NAME NOT NULL VARCHAR2(30)

OBJECT_OWNER NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME NOT NULL VARCHAR2(30)

COLUMN_POSITION NUMBER

DBA_AQ_AGENTS

iSelfSchooling-SQL> desc DBA_AQ_AGENTS;

Name Null? Type

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

AGENT_NAME NOT NULL VARCHAR2(30)

HTTP_ENABLED VARCHAR2(4)

SMTP_ENABLED VARCHAR2(4)

DBA_AQ_AGENT_PRIVS

iSelfSchooling-SQL> desc DBA_AQ_AGENT_PRIVS;

Name Null? Type

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

AGENT_NAME NOT NULL VARCHAR2(30)

DB_USERNAME VARCHAR2(30)

HTTP_ENABLED VARCHAR2(4)

SMTP_ENABLED VARCHAR2(4)

DBA_ASSOCIATIONS: All associations

iSelfSchooling-SQL> desc DBA_ASSOCIATIONS;

Name Null? Type

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

OBJECT_OWNER NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

COLUMN_NAME VARCHAR2(30)

OBJECT_TYPE VARCHAR2(9)

STATSTYPE_SCHEMA VARCHAR2(30)

STATSTYPE_NAME VARCHAR2(30)

DEF_SELECTIVITY NUMBER

DEF_CPU_COST NUMBER

DEF_IO_COST NUMBER

DEF_NET_COST NUMBER

INTERFACE_VERSION NUMBER

DBA_ATTRIBUTE_TRANSFORMATIONS

iSelfSchooling-SQL> desc DBA_ATTRIBUTE_TRANSFORMATIONS;

Name Null? Type

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

TRANSFORMATION_ID NOT NULL NUMBER

OWNER NOT NULL VARCHAR2(30)

NAME NOT NULL VARCHAR2(30)

FROM_TYPE VARCHAR2(61)

TO_TYPE VARCHAR2(91)

ATTRIBUTE NOT NULL NUMBER

ATTRIBUTE_TRANSFORMATION VARCHAR2(4000)

DBA_AUDIT_EXISTS: Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS

iSelfSchooling-SQL> desc DBA_AUDIT_EXISTS;

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_OWNER VARCHAR2(30)

NEW_NAME VARCHAR2(128)

OBJ_PRIVILEGE VARCHAR2(16)

SYS_PRIVILEGE VARCHAR2(40)

GRANTEE VARCHAR2(30)

SESSIONID NOT NULL NUMBER

ENTRYID NOT NULL NUMBER

STATEMENTID NOT NULL NUMBER

RETURNCODE NOT NULL NUMBER

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)

DBA_AUDIT_OBJECT: Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user

iSelfSchooling-SQL> desc DBA_AUDIT_OBJECT;

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_OWNER VARCHAR2(30)

NEW_NAME VARCHAR2(128)

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)

DBA_AUDIT_POLICIES: Fine grained auditing policies in the database

iSelfSchooling-SQL> desc DBA_AUDIT_POLICIES;

Name Null? Type

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

OBJECT_SCHEMA NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

POLICY_NAME NOT NULL VARCHAR2(30)

POLICY_TEXT VARCHAR2(4000)

POLICY_COLUMN VARCHAR2(30)

PF_SCHEMA VARCHAR2(30)

PF_PACKAGE VARCHAR2(30)

PF_FUNCTION VARCHAR2(30)

ENABLED VARCHAR2(3)

SEL VARCHAR2(3)

INS VARCHAR2(3)

UPD VARCHAR2(3)

DEL VARCHAR2(3)

AUDIT_TRAIL VARCHAR2(12)

POLICY_COLUMN_OPTIONS VARCHAR2(11)

DBA_AUDIT_POLICY_COLUMNS: All fine grained auditing policy columns in the database

iSelfSchooling-SQL> desc DBA_AUDIT_POLICY_COLUMNS;

Name Null? Type

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

OBJECT_SCHEMA NOT NULL VARCHAR2(30)

OBJECT_NAME NOT NULL VARCHAR2(30)

POLICY_NAME NOT NULL VARCHAR2(30)

POLICY_COLUMN NOT NULL VARCHAR2(30)

DBA_AUDIT_SESSION: All audit trail records concerning CONNECT and DISCONNECT

iSelfSchooling-SQL> desc DBA_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)

DBA_AUDIT_STATEMENT: Audit trail records concerning grant, revoke, audit, noaudit and alter system

iSelfSchooling-SQL> desc DBA_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)

DBA_AUDIT_TRAIL: All audit trail entries

iSelfSchooling-SQL> desc DBA_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)

DBA_AWS: Analytic Workspaces in the database

iSelfSchooling-SQL> desc DBA_AWS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

AW_NUMBER NOT NULL NUMBER

AW_NAME VARCHAR2(30)

AW_VERSION VARCHAR2(4)

PAGESPACES NUMBER

GENERATIONS NUMBER

DBA_AW_OBJ: Objects in Analytic Workspaces in the database

iSelfSchooling-SQL> desc DBA_AW_OBJ;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

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)

DBA_AW_PROP: Object properties in Analytic Workspaces in the database

iSelfSchooling-SQL> desc DBA_AW_PROP;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

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

DBA_AW_PS: Pagespaces in Analytic Workspaces owned by the user

iSelfSchooling-SQL> desc DBA_AW_PS;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

AW_NUMBER NOT NULL NUMBER

AW_NAME VARCHAR2(30)

PSNUMBER NUMBER(10)

GENERATIONS NUMBER

MAXPAGES NUMBER

DBA_BASE_TABLE_MVIEWS: All materialized views with log(s) in the database

iSelfSchooling-SQL> desc DBA_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)

DBA_BLOCKERS

iSelfSchooling-SQL> desc DBA_BLOCKERS;

Name Null? Type

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

HOLDING_SESSION NUMBER

DBA_CACHEABLE_NONTABLE_OBJECTS

iSelfSchooling-SQL> desc DBA_CACHEABLE_NONTABLE_OBJECTS;

Name Null? Type

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

OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(128)

OBJECT_TYPE VARCHAR2(19)

DBA_CACHEABLE_OBJECTS

iSelfSchooling-SQL> desc DBA_CACHEABLE_OBJECTS;

Name Null? Type

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

OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(128)

OBJECT_TYPE VARCHAR2(19)

DBA_CACHEABLE_OBJECTS_BASE

iSelfSchooling-SQL> desc DBA_CACHEABLE_OBJECTS_BASE;

Name Null? Type

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

OWNER VARCHAR2(30)

OBJECT_NAME VARCHAR2(128)

OBJECT_TYPE VARCHAR2(19)

DBA_CACHEABLE_TABLES

iSelfSchooling-SQL> desc DBA_CACHEABLE_TABLES;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

DBA_CACHEABLE_TABLES_BASE

iSelfSchooling-SQL> desc DBA_CACHEABLE_TABLES_BASE;

Name Null? Type

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

OWNER NOT NULL VARCHAR2(30)

TABLE_NAME NOT NULL VARCHAR2(30)

TEMPORARY VARCHAR2(1)

PROPERTY NOT NULL NUMBER

DBA_CAPTURE: Details about the capture process

iSelfSchooling-SQL> desc DBA_CAPTURE;

Name Null? Type

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

CAPTURE_NAME NOT NULL VARCHAR2(30)

QUEUE_NAME NOT NULL VARCHAR2(30)

QUEUE_OWNER NOT NULL VARCHAR2(30)

RULE_SET_NAME VARCHAR2(30)

RULE_SET_OWNER VARCHAR2(30)

CAPTURE_USER VARCHAR2(30)

START_SCN NUMBER

STATUS VARCHAR2(8)

CAPTURED_SCN NUMBER

APPLIED_SCN NUMBER

USE_DATABASE_LINK VARCHAR2(3)

FIRST_SCN NUMBER

SOURCE_DATABASE VARCHAR2(128)

SOURCE_DBID NUMBER

SOURCE_RESETLOGS_SCN NUMBER

SOURCE_RESETLOGS_TIME NUMBER

LOGMINER_ID NUMBER

NEGATIVE_RULE_SET_NAME VARCHAR2(30)

NEGATIVE_RULE_SET_OWNER VARCHAR2(30)

MAX_CHECKPOINT_SCN NUMBER

REQUIRED_CHECKPOINT_SCN NUMBER

LOGFILE_ASSIGNMENT VARCHAR2(8)

STATUS_CHANGE_TIME DATE

ERROR_NUMBER NUMBER

ERROR_MESSAGE VARCHAR2(4000)

VERSION VARCHAR2(64)

CAPTURE_TYPE VARCHAR2(10)

LAST_ENQUEUED_SCN NUMBER

CHECKPOINT_RETENTION_TIME NUMBER