Long Raw data types cannot be included in the CREATE TABLE AS syntax. This is documented in the Oracle 7.3 or 8.0 Server SQL Reference Guide 'AS subquery' clause explanation of the CREATE TABLE syntax. The INSERT INTO statement results in the same error (see example). Use export/import to workaround this limitation of long raw usage.

Use the following workaround to create a table using the "CREATE TABLE AS" syntax:

SQL> create table test1 (
col1 int primary key,
col2 long raw);

Table created.

SQL> create table test2 as select col1 from test1;

Table created.

SQL> alter table test2 add (col2 long raw);

Table altered.

You may now export from one table (test1) and import into the other table (test2).

Export table test1
Rename table test1 to test3
Rename table test2 to test1
Import table test3 into the new test1
Rename table test1 back to test2
Rename table test3 back to test1

CREATE TABLE AS and LONG RAW[from akadia]