Structure of dba_errors

Name                                                        Null?                            Type
 -----------------------------------                               --------                  ----------------------------
 OWNER                                                   NOT NULL               VARCHAR2(30)
 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

Structure of dba_tablespace

Name                                                                   Null?                          Type
 -----------------------------------------                             --------                     ----------------------------
 TABLESPACE_NAME                                    NOT NULL              VARCHAR2(30)
 BLOCK_SIZE                                                  NOT NULL               NUMBER
 INITIAL_EXTENT                                                                             NUMBER
 NEXT_EXTENT                                                                                 NUMBER
 MIN_EXTENTS                                               NOT NULL               NUMBER
 MAX_EXTENTS                                                                                NUMBER
 PCT_INCREASE                                                                                 NUMBER
 MIN_EXTLEN                                                                                     NUMBER
 STATUS                                                                                              VARCHAR2(9)
 CONTENTS                                                                                        VARCHAR2(9)
 LOGGING                                                                                           VARCHAR2(9)
 FORCE_LOGGING                                                                             VARCHAR2(3)
 EXTENT_MANAGEMENT                                                                VARCHAR2(10)
 ALLOCATION_TYPE                                                                         VARCHAR2(9)
 PLUGGED_IN                                                                                     VARCHAR2(3)
 SEGMENT_SPACE_MANAGEMENT                                              VARCHAR2(6)
 DEF_TAB_COMPRESSION                                                               VARCHAR2(8)
 RETENTION                                                                                       VARCHAR2(11)
 BIGFILE                                                                                                VARCHAR2(3)

Structure of dba_users

Name                                                          Null?                Type
 -----------------------------------------                           --------           ----------------------------
 USERNAME                                              NOT NULL     VARCHAR2(30)
 USER_ID                                                   NOT NULL       NUMBER
 PASSWORD                                                                        VARCHAR2(30)
 ACCOUNT_STATUS                                NOT NULL       VARCHAR2(32)
 LOCK_DATE                                                                       DATE
 EXPIRY_DATE                                                                    DATE
 DEFAULT_TABLESPACE                        NOT NULL       VARCHAR2(30)
 TEMPORARY_TABLESPACE                 NOT NULL        VARCHAR2(30)
 CREATED                                                  NOT NULL          DATE
 PROFILE                                                   NOT NULL         VARCHAR2(30)
 INITIAL_RSRC_CONSUMER_GROUP                              VARCHAR2(30)
 EXTERNAL_NAME                                                              VARCHAR2(4000)

Structure Of dba_indexes

Name                                                           Null?                                  Type
 -----------------------------------------                        --------                               ----------------------------
 OWNER                                                  NOT NULL                       VARCHAR2(30)
 INDEX_NAME                                       NOT NULL                        VARCHAR2(30)
 INDEX_TYPE                                                                                     VARCHAR2(27)
 TABLE_OWNER                                    NOT NULL                        VARCHAR2(30)
 TABLE_NAME                                       NOT NULL                        VARCHAR2(30)
 TABLE_TYPE                                                                                    VARCHAR2(11)
 UNIQUENESS                                                                                    VARCHAR2 (9)
 COMPRESSION                                                                                  VARCHAR2(8)
 PREFIX_LENGTH                                                                               NUMBER
 TABLESPACE_NAME                                                                       VARCHAR2(30)
 INI_TRANS                                                                                          NUMBER
 MAX_TRANS                                                                                     NUMBER
 INITIAL_EXTENT                                                                            NUMBER
 NEXT_EXTENT                                                                                NUMBER
 MIN_EXTENTS                                                                                 NUMBER
 MAX_EXTENTS                                                                               NUMBER
 PCT_INCREASE                                                                               NUMBER
 PCT_THRESHOLD                                                                           NUMBER
 INCLUDE_COLUMN                                                                       NUMBER
 FREELISTS                                                                                       NUMBER
 FREELIST_GROUPS                                                                       NUMBER
 PCT_FREE                                                                                        NUMBER
 LOGGING                                                                                        VARCHAR2(3)
 BLEVEL                                                                                            NUMBER
 LEAF_BLOCKS                                                                               NUMBER
 DISTINCT_KEYS                                                                            NUMBER
 AVG_LEAF_BLOCKS_PER_KEY                                                 NUMBER
 AVG_DATA_BLOCKS_PER_KEY                                                NUMBER
 CLUSTERING_FACTOR                                                               NUMBER
 STATUS                                                                                           VARCHAR2(8)
 NUM_ROWS                                                                                  NUMBER
 SAMPLE_SIZE                                                                               NUMBER
 LAST_ANALYZED                                                                        DATE
 DEGREE                                                                                         VARCHAR2(40)
 INSTANCES                                                                                   VARCHAR2(40)
 PARTITIONED                                                                               VARCHAR2(3)
 TEMPORARY                                                                                VARCHAR2(1)
 GENERATED                                                                                 VARCHAR2(1)
 SECONDARY                                                                                 VARCHAR2(1)
 BUFFER_POOL                                                                             VARCHAR2(7)
 USER_STATS                                                                                 VARCHAR2(3)
 DURATION                                                                                   VARCHAR2(15)
 PCT_DIRECT_ACCESS                                                              NUMBER
 ITYP_OWNER                                                                             VARCHAR2(30)
 ITYP_NAME                                                                               VARCHAR2(30)
 PARAMETERS                                                                           VARCHAR2(1000)
 GLOBAL_STATS                                                                        VARCHAR2(3)
 DOMIDX_STATUS                                                                     VARCHAR2(12)
 DOMIDX_OPSTATUS                                                                VARCHAR2(6)
 FUNCIDX_STATUS                                                                   VARCHAR2(8)
 JOIN_INDEX                                                                               VARCHAR2(3)
 IOT_REDUNDANT_PKEY_ELIM                                            VARCHAR2(3)
 DROPPED                                                                                    VARCHAR2(3)

Structure of Oracle dba_trigers

Name                                                Null?                             Type
 -----------------------------------------             --------                 ----------------------------
 OWNER                                                                        VARCHAR2(30)
 TRIGGER_NAME                                                       VARCHAR2(30)
 TRIGGER_TYPE                                                         VARCHAR2(16)
 TRIGGERING_EVENT                                               VARCHAR2(227)
 TABLE_OWNER                                                          VARCHAR2(30)
 BASE_OBJECT_TYPE                                                 VARCHAR2(16)
 TABLE_NAME                                                              VARCHAR2(30)
 COLUMN_NAME                                                        VARCHAR2(4000)
 REFERENCING_NAMES                                             VARCHAR2(128)
 WHEN_CLAUSE                                                            VARCHAR2(4000)
 STATUS                                                                           VARCHAR2(8)
 DESCRIPTION                                                              VARCHAR2(4000)
 ACTION_TYPE                                                             VARCHAR2(11)
 TRIGGER_BODY                                                           LONG

Structure of Oracle System(dba) Procedures

Name                                                  Null?                       Type
 -----------------------------------------                 --------                    ----------------------------
 OWNER                                           NOT NULL            VARCHAR2(30)
 VIEW_NAME                                 NOT NULL              VARCHAR2(30)
 TEXT_LENGTH                                                              NUMBER
 TEXT                                                                                LONG
 TYPE_TEXT_LENGTH                                                  NUMBER
 TYPE_TEXT                                                                    VARCHAR2(4000)
 OID_TEXT_LENGTH                                                      NUMBER
 OID_TEXT                                                                      VARCHAR2(4000)
 VIEW_TYPE_OWNER                                                   VARCHAR2(30)
 VIEW_TYPE                                                                   VARCHAR2(30)
 SUPERVIEW_NAME                                                      VARCHAR2(30)

Structure of System tables views

Name                                                              Null?              Type
 -----------------------------------------                         --------              ----------------------------
 OWNER                                                      NOT NULL      VARCHAR2(30)
 VIEW_NAME                                            NOT NULL      VARCHAR2(30)
 TEXT_LENGTH                                                                  NUMBER
 TEXT                                                                                     LONG
 TYPE_TEXT_LENGTH                                                      NUMBER
 TYPE_TEXT                                                                        VARCHAR2(4000)
 OID_TEXT_LENGTH                                                         NUMBER
 OID_TEXT                                                                           VARCHAR2(4000)
 VIEW_TYPE_OWNER                                                        VARCHAR2(30)
 VIEW_TYPE                                                                        VARCHAR2(30)
 SUPERVIEW_NAME                                                          VARCHAR2(30)

Structure of oracle system table

Name                                                               Null?                                            Type
 -----------------------------------------                            --------                               ----------------------------
 OWNER                                                       NOT NULL                         VARCHAR2(30)
 TABLE_NAME                                           NOT NULL                         VARCHAR2(30)
 TABLESPACE_NAME                                                                            VARCHAR2(30)
 CLUSTER_NAME                                                                                   VARCHAR2(30)
 IOT_NAME                                                                                              VARCHAR2(30)
 STATUS                                                                                                     VARCHAR2(8)
 PCT_FREE                                                                                                NUMBER
 PCT_USED                                                                                                NUMBER
 INI_TRANS                                                                                               NUMBER
 MAX_TRANS                                                                                            NUMBER
 INITIAL_EXTENT                                                                                     NUMBER
 NEXT_EXTENT                                                                                         NUMBER
 MIN_EXTENTS                                                                                          NUMBER
 MAX_EXTENTS                                                                                        NUMBER
 PCT_INCREASE                                                                                        NUMBER
 FREELISTS                                                                                                 NUMBER
 FREELIST_GROUPS                                                                                NUMBER
 LOGGING                                                                                               VARCHAR2(3)
 BACKED_UP                                                                                          VARCHAR2(1)
 NUM_ROWS                                                                                          NUMBER
 BLOCKS                                                                                                  NUMBER
 EMPTY_BLOCKS                                                                                   NUMBER
 AVG_SPACE                                                                                            NUMBER
 CHAIN_CNT                                                                                            NUMBER
 AVG_ROW_LEN                                                                                     NUMBER
 AVG_SPACE_FREELIST_BLOCKS                                                      NUMBER
 NUM_FREELIST_BLOCKS                                                                   NUMBER
 DEGREE                                                                                                  VARCHAR2(10)
 INSTANCES                                                                                            VARCHAR2(10)
 CACHE                                                                                                    VARCHAR2(5)
 TABLE_LOCK                                                                                        VARCHAR2(8)
 SAMPLE_SIZE                                                                                        NUMBER
 LAST_ANALYZED                                                                                DATE
 PARTITIONED                                                                                       VARCHAR2(3)
 IOT_TYPE                                                                                              VARCHAR2(12)
 TEMPORARY                                                                                         VARCHAR2(1)
 SECONDARY                                                                                         VARCHAR2(1)
 NESTED                                                                                                  VARCHAR2(3)
 BUFFER_POOL                                                                                      VARCHAR2(7)
 ROW_MOVEMENT                                                                               VARCHAR2(8)
 GLOBAL_STATS                                                                                    VARCHAR2(3)
 USER_STATS                                                                                          VARCHAR2(3)
 DURATION                                                                                             VARCHAR2(15)
 SKIP_CORRUPT                                                                                    VARCHAR2(8)
 MONITORING                                                                                       VARCHAR2(3)
 CLUSTER_OWNER                                                                              VARCHAR2(30)
 DEPENDENCIES                                                                                   VARCHAR2(8)
 COMPRESSION                                                                                     VARCHAR2(8)
 DROPPED                                                                                               VARCHAR2(3)

Copy Command-copy data from one database to another database

Copies data from a query to a table in the same or another database. COPY supports CHAR, DATE, LONG, NUMBER and VARCHAR2.

Syntax:

COPY {FROM database | TO database | FROM database TO database{APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)] USING query

where database has the following syntax:     username[/password]@connect_identifier

Example:

copy from hr/hr@orcl to hr/hr@orcl insert emp2 using select * from emp;

copy from hr/hr@orcl to scott/tiger@orcl insert abc using select * from employees;

copy from hr/hr@orcl to scott/tiger@orcl create dep_id (dep_id,dep_name,man_id,loc_id) using select * from departments;

copy from hr/hr@orcl to scott/tiger@orcl replace employee using select * from employees;