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;

RESERVED WORDS (SQL)-Oracle 10g

An asterisk (*) indicates words are also ANSI Reserved Words.

                                                                            

ACCESS                   DEFAULT*              INTEGER*              ONLINE                  START

 ADD*                     DELETE*                  INTERSECT*         OPTION*               SUCCESSFUL

 ALL*                       DESC*                      INTO*                     OR*                       SYNONYM

 ALTER*                 DISTINCT*             IS*                         ORDER*                SYSDATE

 AND*                    DROP*                   LEVEL*                     PCTFREE                TABLE*

 ANY*                    ELSE*                      LIKE*                         PRIOR*                  THEN*

 AS*                       EXCLUSIVE               LOCK                      PRIVILEGES*         TO*

 ASC*                    EXISTS                        LONG                     PUBLIC*                TRIGGER

 AUDIT                  FILE                             MAXEXTENTS      RAW                     UID

 BETWEEN*        FLOAT*                      MINUS                  RENAME             UNION*

 BY*                       FOR*                          MLSLABEL            RESOURCE          UNIQUE*

 CHAR*                 FROM*                     MODE                     REVOKE*             UPDATE*

 CHECK*               GRANT*                   MODIFY               ROW                     USER*

 CLUSTER             GROUP*                  NOAUDIT            ROWID                  VALIDATE

 COLUMN            HAVING*                NOCOMPRESS    ROWNUM           VALUES*

 COMMENT        IDENTIFIED              NOT*                     ROWS*               VARCHAR*

 COMPRESS        IMMEDIATE*         NOWAIT              SELECT*             VARCHAR2

 CONNECT*        IN*                          NULL*                  SESSION*           VIEW*

 CREATE*             INCREMENT          NUMBER             SET*                   WHENEVER*

 CURRENT*        INDEX                     OF*                         SHARE                WHERE

 DATE*                  INITIAL                   OFFLINE                SIZE*                  WITH*

 DECIMAL*          INSERT*                 ON*                        SMALLINT*

Know your user,database,global_name,context

Select  'User: '|| user || ' on database ' || global_name,'(term='||USERENV('TERMINAL')||', audsid='||USERENV('SESSIONID')||')' from global_name;