SQL> set long 4000000
SQL> COPY FROM sys@db_link –
> TO sys@target –
> CREATE XX.DBA_VIEWS_OLD_TABLE_TEST –
> USING SELECT * FROM sys.DBA_VIEWS
Enter FROM password:
Enter TO password:

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 4000000. (long is 4000000)
Table XX.DBA_VIEWS_OLD_TABLE_TEST created.

4487 rows selected from sys@db_link.
4487 rows inserted into XX.DBA_VIEWS_OLD_TABLE_TEST.
4487 rows committed into XX.DBA_VIEWS_OLD_TABLE_TEST at sys@target.

One limitation is that data more than 64K (65535) characters will be truncated.

Advertisements