Unanswered: COPY Command to same schema..possible?
We are testing set of scripts which we have to use it at client site. But, unfortunately currently we are not having two schemas/DBs to test the same. So we are coping the table info to some other table in the same schema. Is it possible to use the COPY FROM ..TO..USING command to the same schema??
I tried, but i am getting errors saying "ORA-00900: invalid SQL statement"
SQL> copy from tandrews/xxxxxx@irbproc create emp2 using select * from emp
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 EMP2 created.
14 rows selected from tandrews@irbproc.
14 rows inserted into EMP2.
14 rows committed into EMP2 at DEFAULT HOST connection.
SQL> desc emp2
Name Null? Type
------------------------------- -------- ----
EMPNO NOT NULL NUMBER(4)
I don't often use COPY: is there any reason why using it here would be preferable to: