Copy a table or view with a Long datatype column into another
SQL> set long 4000000 SQL> COPY FROM sys@db_link – > TO sys@target – > CREATE XX.DBA_VIEWS_OLD_TABLE_TEST – > USING SELECT …
SQL> set long 4000000 SQL> COPY FROM sys@db_link – > TO sys@target – > CREATE XX.DBA_VIEWS_OLD_TABLE_TEST – > USING SELECT …