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>
|