iSelfSchooling.com - Since 1999  References  |  Job Openings  |  Post Notes
    Home  | Search more  | Oracle Syntax  | Suggestions  | Computer Institute   | (Login or Register to access to all VIDEOS)
 

Copyright & User Agreement

    Email2aFriend  | Homepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

...

  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_HIST_SQLBIND: SQL Bind Information

 

iSelfSchooling-SQL> desc DBA_HIST_SQLBIND;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 SQL_ID                                 VARCHAR2(13)

 NAME                                   VARCHAR2(30)

 POSITION                               NUMBER

 DUP_POSITION                           NUMBER

 DATATYPE                               NUMBER

 DATATYPE_STRING                        VARCHAR2(15)

 CHARACTER_SID                          NUMBER

 PRECISION                              NUMBER

 SCALE                                  NUMBER

 MAX_LENGTH                             NUMBER

 WAS_CAPTURED                           VARCHAR2(3)

 LAST_CAPTURED                          DATE

 VALUE_STRING                           VARCHAR2(4000)

 VALUE_ANYDATA                          ANYDATA

 

DBA_HIST_SQLSTAT: SQL Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_SQLSTAT;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 SQL_ID                                 VARCHAR2(13)

 PLAN_HASH_VALUE                        NUMBER

 OPTIMIZER_COST                         NUMBER

 OPTIMIZER_MODE                         VARCHAR2(10)

 OPTIMIZER_ENV_HASH_VALUE               NUMBER

 SHARABLE_MEM                           NUMBER

 LOADED_VERSIONS                        NUMBER

 VERSION_COUNT                          NUMBER

 MODULE                                 VARCHAR2(64)

 ACTION                                 VARCHAR2(64)

 SQL_PROFILE                            VARCHAR2(64)

 FORCE_MATCHING_SIGNATURE               NUMBER

 PARSING_SCHEMA_ID                      NUMBER

 PARSING_SCHEMA_NAME                    VARCHAR2(30)

 FETCHES_TOTAL                          NUMBER

 FETCHES_DELTA                          NUMBER

 END_OF_FETCH_COUNT_TOTAL               NUMBER

 END_OF_FETCH_COUNT_DELTA               NUMBER

 SORTS_TOTAL                            NUMBER

 SORTS_DELTA                            NUMBER

 EXECUTIONS_TOTAL                       NUMBER

 EXECUTIONS_DELTA                       NUMBER

 PX_SERVERS_EXECS_TOTAL                 NUMBER

 PX_SERVERS_EXECS_DELTA                 NUMBER

 LOADS_TOTAL                            NUMBER

 LOADS_DELTA                            NUMBER

 INVALIDATIONS_TOTAL                    NUMBER

 INVALIDATIONS_DELTA                    NUMBER

 PARSE_CALLS_TOTAL                      NUMBER

 PARSE_CALLS_DELTA                      NUMBER

 DISK_READS_TOTAL                       NUMBER

 DISK_READS_DELTA                       NUMBER

 BUFFER_GETS_TOTAL                      NUMBER

 BUFFER_GETS_DELTA                      NUMBER

 ROWS_PROCESSED_TOTAL                   NUMBER

 ROWS_PROCESSED_DELTA                   NUMBER

 CPU_TIME_TOTAL                         NUMBER

 CPU_TIME_DELTA                         NUMBER

 ELAPSED_TIME_TOTAL                     NUMBER

 ELAPSED_TIME_DELTA                     NUMBER

 IOWAIT_TOTAL                           NUMBER

 IOWAIT_DELTA                           NUMBER

 CLWAIT_TOTAL                           NUMBER

 CLWAIT_DELTA                           NUMBER

 APWAIT_TOTAL                           NUMBER

 APWAIT_DELTA                           NUMBER

 CCWAIT_TOTAL                           NUMBER

 CCWAIT_DELTA                           NUMBER

 DIRECT_WRITES_TOTAL                    NUMBER

 DIRECT_WRITES_DELTA                    NUMBER

 PLSEXEC_TIME_TOTAL                     NUMBER

 PLSEXEC_TIME_DELTA                     NUMBER

 JAVEXEC_TIME_TOTAL                     NUMBER

 JAVEXEC_TIME_DELTA                     NUMBER

 BIND_DATA                              RAW(2000)

 

DBA_HIST_SQLTEXT: SQL Text

 

iSelfSchooling-SQL> desc DBA_HIST_SQLTEXT;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 SQL_ID                        NOT NULL VARCHAR2(13)

 SQL_TEXT                               CLOB

 COMMAND_TYPE                           NUMBER

 

DBA_HIST_SQL_BIND_METADATA: SQL Bind Metadata Information

 

iSelfSchooling-SQL> desc DBA_HIST_SQL_BIND_METADATA;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 SQL_ID                        NOT NULL VARCHAR2(13)

 NAME                                   VARCHAR2(30)

 POSITION                      NOT NULL NUMBER

 DUP_POSITION                           NUMBER

 DATATYPE                               NUMBER

 DATATYPE_STRING                        VARCHAR2(15)

 CHARACTER_SID                          NUMBER

 PRECISION                              NUMBER

 SCALE                                  NUMBER

 MAX_LENGTH                             NUMBER

 

DBA_HIST_SQL_PLAN: SQL Plan Information

 

iSelfSchooling-SQL> desc DBA_HIST_SQL_PLAN;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 SQL_ID                        NOT NULL VARCHAR2(13)

 PLAN_HASH_VALUE               NOT NULL NUMBER

 ID                            NOT NULL NUMBER

 OPERATION                              VARCHAR2(30)

 OPTIONS                                VARCHAR2(30)

 OBJECT_NODE                            VARCHAR2(128)

 OBJECT#                                NUMBER

 OBJECT_OWNER                           VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(31)

 OBJECT_ALIAS                           VARCHAR2(65)

 OBJECT_TYPE                            VARCHAR2(20)

 OPTIMIZER                              VARCHAR2(20)

 PARENT_ID                              NUMBER

 DEPTH                                  NUMBER

 POSITION                               NUMBER

 SEARCH_COLUMNS                         NUMBER

 COST                                   NUMBER

 CARDINALITY                            NUMBER

 BYTES                                  NUMBER

 OTHER_TAG                              VARCHAR2(35)

 PARTITION_START                        VARCHAR2(5)

 PARTITION_STOP                         VARCHAR2(5)

 PARTITION_ID                           NUMBER

 OTHER                                  VARCHAR2(4000)

 DISTRIBUTION                           VARCHAR2(20)

 CPU_COST                               NUMBER

 IO_COST                                NUMBER

 TEMP_SPACE                             NUMBER

 ACCESS_PREDICATES                      VARCHAR2(4000)

 FILTER_PREDICATES                      VARCHAR2(4000)

 PROJECTION                             VARCHAR2(4000)

 TIME                                   NUMBER

 QBLOCK_NAME                            VARCHAR2(31)

 REMARKS                                VARCHAR2(4000)

 TIMESTAMP                              DATE

 OTHER_XML                              CLOB

 

DBA_HIST_SQL_SUMMARY: Summary of SQL Statistics

 

iSelfSchooling-SQL> desc DBA_HIST_SQL_SUMMARY;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 TOTAL_SQL                     NOT NULL NUMBER

 TOTAL_SQL_MEM                 NOT NULL NUMBER

 SINGLE_USE_SQL                NOT NULL NUMBER

 SINGLE_USE_SQL_MEM            NOT NULL NUMBER

 

DBA_HIST_SQL_WORKAREA_HSTGRM: SQL Workarea Histogram History

 

iSelfSchooling-SQL> desc DBA_HIST_SQL_WORKAREA_HSTGRM;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 LOW_OPTIMAL_SIZE              NOT NULL NUMBER

 HIGH_OPTIMAL_SIZE             NOT NULL NUMBER

 OPTIMAL_EXECUTIONS                     NUMBER

 ONEPASS_EXECUTIONS                     NUMBER

 MULTIPASSES_EXECUTIONS                 NUMBER

 TOTAL_EXECUTIONS                       NUMBER

 

DBA_HIST_STAT_NAME: Statistic Names

 

iSelfSchooling-SQL> desc DBA_HIST_STAT_NAME;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 STAT_ID                       NOT NULL NUMBER

 STAT_NAME                     NOT NULL VARCHAR2(64)

 

DBA_HIST_STREAMS_APPLY_SUM: STREAMS Apply Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_STREAMS_APPLY_SUM;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 APPLY_NAME                    NOT NULL VARCHAR2(30)

 STARTUP_TIME                  NOT NULL DATE

 READER_TOTAL_MESSAGES_DEQUEUE          NUMBER

 READER_LAG                             NUMBER

 COORD_TOTAL_RECEIVED                   NUMBER

 COORD_TOTAL_APPLIED                    NUMBER

 COORD_TOTAL_ROLLBACKS                  NUMBER

 COORD_TOTAL_WAIT_DEPS                  NUMBER

 COORD_TOTAL_WAIT_CMTS                  NUMBER

 COORD_LWM_LAG                          NUMBER

 SERVER_TOTAL_MESSAGES_APPLIED          NUMBER

 SERVER_ELAPSED_DEQUEUE_TIME            NUMBER

 SERVER_ELAPSED_APPLY_TIME              NUMBER

 

DBA_HIST_STREAMS_CAPTURE: STREAMS Capture Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_STREAMS_CAPTURE;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 CAPTURE_NAME                  NOT NULL VARCHAR2(30)

 STARTUP_TIME                  NOT NULL DATE

 LAG                                    NUMBER

 TOTAL_MESSAGES_CAPTURED                NUMBER

 TOTAL_MESSAGES_ENQUEUED                NUMBER

 ELAPSED_RULE_TIME                      NUMBER

 ELAPSED_ENQUEUE_TIME                   NUMBER

 ELAPSED_REDO_WAIT_TIME                 NUMBER

 ELAPSED_PAUSE_TIME                     NUMBER

 

DBA_HIST_STREAMS_POOL_ADVICE: Streams Pool Advice History

 

iSelfSchooling-SQL> desc DBA_HIST_STREAMS_POOL_ADVICE;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 SIZE_FOR_ESTIMATE             NOT NULL NUMBER

 SIZE_FACTOR                            NUMBER

 ESTD_SPILL_COUNT                       NUMBER

 ESTD_SPILL_TIME                        NUMBER

 ESTD_UNSPILL_COUNT                     NUMBER

 ESTD_UNSPILL_TIME                      NUMBER

 

DBA_HIST_SYSMETRIC_HISTORY: System Metrics History

 

iSelfSchooling-SQL> desc DBA_HIST_SYSMETRIC_HISTORY;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 BEGIN_TIME                    NOT NULL DATE

 END_TIME                      NOT NULL DATE

 INTSIZE                       NOT NULL NUMBER

 GROUP_ID                      NOT NULL NUMBER

 METRIC_ID                     NOT NULL NUMBER

 METRIC_NAME                   NOT NULL VARCHAR2(64)

 VALUE                         NOT NULL NUMBER

 METRIC_UNIT                   NOT NULL VARCHAR2(64)

 

DBA_HIST_SYSMETRIC_SUMMARY: System Metrics History

 

iSelfSchooling-SQL> desc DBA_HIST_SYSMETRIC_SUMMARY;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 BEGIN_TIME                    NOT NULL DATE

 END_TIME                      NOT NULL DATE

 INTSIZE                       NOT NULL NUMBER

 GROUP_ID                      NOT NULL NUMBER

 METRIC_ID                     NOT NULL NUMBER

 METRIC_NAME                   NOT NULL VARCHAR2(64)

 METRIC_UNIT                   NOT NULL VARCHAR2(64)

 NUM_INTERVAL                  NOT NULL NUMBER

 MINVAL                        NOT NULL NUMBER

 MAXVAL                        NOT NULL NUMBER

 AVERAGE                       NOT NULL NUMBER

 STANDARD_DEVIATION            NOT NULL NUMBER

 

DBA_HIST_SYSSTAT: System Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_SYSSTAT;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 STAT_ID                                NUMBER

 STAT_NAME                              VARCHAR2(64)

 VALUE                                  NUMBER

 

DBA_HIST_SYSTEM_EVENT: System Event Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_SYSTEM_EVENT;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 EVENT_ID                               NUMBER

 EVENT_NAME                             VARCHAR2(64)

 WAIT_CLASS_ID                          NUMBER

 WAIT_CLASS                             VARCHAR2(64)

 TOTAL_WAITS                            NUMBER

 TOTAL_TIMEOUTS                         NUMBER

 TIME_WAITED_MICRO                      NUMBER

 

DBA_HIST_SYS_TIME_MODEL: System Time Model Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_SYS_TIME_MODEL;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 STAT_ID                                NUMBER

 STAT_NAME                              VARCHAR2(64)

 VALUE                                  NUMBER

 

DBA_HIST_TABLESPACE_STAT: Tablespace Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_TABLESPACE_STAT;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 TS#                                    NUMBER

 TSNAME                                 VARCHAR2(30)

 CONTENTS                               VARCHAR2(9)

 STATUS                                 VARCHAR2(9)

 SEGMENT_SPACE_MANAGEMENT               VARCHAR2(6)

 EXTENT_MANAGEMENT                      VARCHAR2(10)

 IS_BACKUP                              VARCHAR2(5)

 

DBA_HIST_TBSPC_SPACE_USAGE: Tablespace Usage Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_TBSPC_SPACE_USAGE;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                          NOT NULL NUMBER

 TABLESPACE_ID                          NUMBER

 TABLESPACE_SIZE                        NUMBER

 TABLESPACE_MAXSIZE                     NUMBER

 TABLESPACE_USEDSIZE                    NUMBER

 RTIME                                  VARCHAR2(25)

 

DBA_HIST_TEMPFILE: Names of Temporary Datafiles

 

iSelfSchooling-SQL> desc DBA_HIST_TEMPFILE;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 FILE#                         NOT NULL NUMBER

 CREATION_CHANGE#              NOT NULL NUMBER

 FILENAME                      NOT NULL VARCHAR2(513)

 TS#                           NOT NULL NUMBER

 TSNAME                        NOT NULL VARCHAR2(30)

 BLOCK_SIZE                             NUMBER

 

DBA_HIST_TEMPSTATXS: Temporary Datafile Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_TEMPSTATXS;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 FILE#                         NOT NULL NUMBER

 CREATION_CHANGE#              NOT NULL NUMBER

 FILENAME                      NOT NULL VARCHAR2(513)

 TS#                           NOT NULL NUMBER

 TSNAME                        NOT NULL VARCHAR2(30)

 BLOCK_SIZE                             NUMBER

 PHYRDS                                 NUMBER

 PHYWRTS                                NUMBER

 SINGLEBLKRDS                           NUMBER

 READTIM                                NUMBER

 WRITETIM                               NUMBER

 SINGLEBLKRDTIM                         NUMBER

 PHYBLKRD                               NUMBER

 PHYBLKWRT                              NUMBER

 WAIT_COUNT                             NUMBER

 TIME                                   NUMBER

 

DBA_HIST_THREAD: Thread Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_THREAD;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 THREAD#                       NOT NULL NUMBER

 THREAD_INSTANCE_NUMBER                 NUMBER

 STATUS                                 VARCHAR2(6)

 OPEN_TIME                              DATE

 CURRENT_GROUP#                         NUMBER

 SEQUENCE#                              NUMBER

 

DBA_HIST_UNDOSTAT: Undo Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_UNDOSTAT;

 Name                          Null?    Type

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

 BEGIN_TIME                    NOT NULL DATE

 END_TIME                      NOT NULL DATE

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 SNAP_ID                       NOT NULL NUMBER

 UNDOTSN                       NOT NULL NUMBER

 UNDOBLKS                               NUMBER

 TXNCOUNT                               NUMBER

 MAXQUERYLEN                            NUMBER

 MAXQUERYSQLID                          VARCHAR2(13)

 MAXCONCURRENCY                         NUMBER

 UNXPSTEALCNT                           NUMBER

 UNXPBLKRELCNT                          NUMBER

 UNXPBLKREUCNT                          NUMBER

 EXPSTEALCNT                            NUMBER

 EXPBLKRELCNT                           NUMBER

 EXPBLKREUCNT                           NUMBER

 SSOLDERRCNT                            NUMBER

 NOSPACEERRCNT                          NUMBER

 ACTIVEBLKS                             NUMBER

 UNEXPIREDBLKS                          NUMBER

 EXPIREDBLKS                            NUMBER

 TUNED_UNDORETENTION                    NUMBER

 

DBA_HIST_WAITCLASSMET_HISTORY: Wait Class Metric History

 

iSelfSchooling-SQL> desc DBA_HIST_WAITCLASSMET_HISTORY;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 WAIT_CLASS_ID                 NOT NULL NUMBER

 WAIT_CLASS                             VARCHAR2(64)

 BEGIN_TIME                    NOT NULL DATE

 END_TIME                      NOT NULL DATE

 INTSIZE                       NOT NULL NUMBER

 GROUP_ID                      NOT NULL NUMBER

 AVERAGE_WAITER_COUNT          NOT NULL NUMBER

 DBTIME_IN_WAIT                NOT NULL NUMBER

 TIME_WAITED                   NOT NULL NUMBER

 WAIT_COUNT                    NOT NULL NUMBER

 

DBA_HIST_WAITSTAT: Wait Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_WAITSTAT;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 CLASS                                  VARCHAR2(18)

 WAIT_COUNT                             NUMBER

 TIME                                   NUMBER

 

DBA_HIST_WR_CONTROL: Workload Repository Control Information

 

iSelfSchooling-SQL> desc DBA_HIST_WR_CONTROL;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 SNAP_INTERVAL                 NOT NULL INTERVAL DAY(5)

 RETENTION                     NOT NULL INTERVAL DAY(5)

 TOPNSQL                                VARCHAR2(10)

 

DBA_IAS_CONSTRAINT_EXP

 

iSelfSchooling-SQL> desc DBA_IAS_CONSTRAINT_EXP;

 Name                          Null?    Type

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

 PKEXISTS                               NUMBER

 OBJ#                          NOT NULL NUMBER

 

DBA_IAS_GEN_STMTS

 

iSelfSchooling-SQL> desc DBA_IAS_GEN_STMTS;

 Name                          Null?    Type

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

 IAS_TEMPLATE_NAME             NOT NULL VARCHAR2(30)

 LINENO                                 NUMBER

 DDL_TEXT                               CLOB

 

DBA_IAS_GEN_STMTS_EXP

 

iSelfSchooling-SQL> desc DBA_IAS_GEN_STMTS_EXP;

 Name                          Null?    Type

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

 IAS_TEMPLATE_ID               NOT NULL NUMBER

 LINENO                                 NUMBER

 DDL_TEXT                               CLOB

 

DBA_IAS_OBJECTS

 

iSelfSchooling-SQL> desc DBA_IAS_OBJECTS;

 Name                          Null?    Type

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

 IAS_TEMPLATE_NAME             NOT NULL VARCHAR2(30)

 SCHEMA_NAME                            VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(200)

 DERIVED_FROM_SNAME                     VARCHAR2(30)

 DERIVED_FROM_ONAME                     VARCHAR2(30)

 

DBA_IAS_OBJECTS_BASE

 

iSelfSchooling-SQL> desc DBA_IAS_OBJECTS_BASE;

 Name                          Null?    Type

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

 IAS_TEMPLATE_NAME             NOT NULL VARCHAR2(30)

 SCHEMA_NAME                            VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 OBJECT_TYPE_ID                NOT NULL NUMBER

 OBJECT_TYPE                            VARCHAR2(200)

 DERIVED_FROM_SNAME                     VARCHAR2(30)

 DERIVED_FROM_ONAME                     VARCHAR2(30)

 

DBA_IAS_OBJECTS_EXP

 

iSelfSchooling-SQL> desc DBA_IAS_OBJECTS_EXP;

 Name                          Null?    Type

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

 TEMPLATE_ID                   NOT NULL NUMBER

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 SCHEMA_NAME                            VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(200)

 

DBA_IAS_POSTGEN_STMTS

 

iSelfSchooling-SQL> desc DBA_IAS_POSTGEN_STMTS;

 Name                          Null?    Type

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

 IAS_TEMPLATE_ID               NOT NULL NUMBER

 LINENO                                 NUMBER

 DDL_TEXT                               CLOB

 

DBA_IAS_PREGEN_STMTS

 

iSelfSchooling-SQL> desc DBA_IAS_PREGEN_STMTS;

 Name                          Null?    Type

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

 IAS_TEMPLATE_ID               NOT NULL NUMBER

 LINENO                                 NUMBER

 DDL_TEXT                               CLOB

 

DBA_IAS_SITES

 

iSelfSchooling-SQL> desc DBA_IAS_SITES;

 Name                          Null?    Type

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

 IAS_TEMPLATE_NAME             NOT NULL VARCHAR2(30)

 USER_NAME                     NOT NULL VARCHAR2(30)

 SITE_NAME                              VARCHAR2(128)

 

DBA_IAS_TEMPLATES

 

iSelfSchooling-SQL> desc DBA_IAS_TEMPLATES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 REFRESH_GROUP_NAME            NOT NULL VARCHAR2(30)

 IAS_TEMPLATE_NAME             NOT NULL VARCHAR2(30)

 IAS_TEMPLATE_ID               NOT NULL NUMBER

 TEMPLATE_COMMENT                       VARCHAR2(2000)

 

 

 

 
 
Google
 
Web web site