If you are very much comfortable with MOVE try to move all the tables WOTHout LONG column and user export/Import for LONG column tables.

Or

You can get the list of tables as follows

select object_name
From dba_objects
where owner not in ('SYS', 'SYSTEM') and
object_type='TABLE';

Export all this tables using the TABLE option. So in one step it is over..



Thomas