Create Table as select * from & long datatypes - what to do?

[gpsingh]

use export/import but be sure of dependencies,grants and constraints.