To move tables with a LONG column you can

1. export/import
2. use SQL*Plus COPY command. note that COPY is a SQL*Plus command, not a SQL command.

d.