Copy a table or view with a Long datatype column into another

May 29, 2012

SQL> set long 4000000 SQL> COPY FROM sys@db_link – > TO sys@target – > CREATE XX.DBA_VIEWS_OLD_TABLE_TEST – > USING SELECT …