Create Table with LONG datatype, shows error..!!

From:  niladri chatterjee  30-Jun-09 16:24
I have a table called MFG_PROGRAM_C with a long datatype.
I am trying to bring the Structure and the data from another Database (ORA10GR2) to my Test database ALPHA10GR2.
It fails.... need your help....

This is what I am performing:

CREATE TABLE MFG_PROGRAM_C AS
SELECT * FROM MFG_PROGRAM_C@ORA10GR2 ;

I get the following error:

Error report:
SQL Error: ORA-00997: illegal use of LONG datatype
00997. 00000 - "illegal use of LONG datatype"

Table Structure:

DESC MFG_PROGRAM_C ;
Name          Null     Type
------------  -------- ------------------
ITEM_CDE               VARCHAR2(50)
DESCRIPTION            VARCHAR2(50)
REV_CDE                NUMBER(15)