Import data from Table A into Table B

[Ablakios]

Thanks for the prompt response.
Here is the problem.

We are trying to do some reorg.

I moved most the tables into a new created LMT.

I have attempted to move a couple of tables and was getting ora- 00997
illigal use of LONG datatype.

So I created a new table with varchar2 (2000)in the new LMT and trying to get the data into it.


SQL> insert into Table B SELECT * FROM A;
Failed with *
ERROR at line 1:
ORA-00997: illegal use of LONG datatype

any other easy way and advise will be highly appreciated.
Thanks