OracleDB‎ > ‎

Copy Table

You can use

CREATE TABLE AS SELECT

however sometimes the talbe you are trying to copy is too big and you run out of undo log segment. In that case just use the copy command.

SQL> COPY FROM sysadm/sysadm1@finance1- > CREATE test01 - > USING SELECT * FROM employee; Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 80. (long is 80) Table TEST01 created. 4954 rows selected from sysadm@finance1 4954 rows inserted into TEST01. 4954 rows committed into TEST01 at DEFAULT HOST connection. SQL>
Comments