Copying a table with LONG

[hemanr]

Hi gurus,

I need to copy a table from one schema to another.

This table has a LONG datatype column.

What is the best way to do this?

Thanks!

[jmodic]

a) export/import
b) SQL*Plus COPY command

[hemanr]

Thanks Jmodic!

I did hear that there are problems in exp/im with a LONG though.

Is there any resource you could point me to for more info on this?

Thanks again!

[julian]

Here are the known restrictions on LONGs. There should be no big problems with their export or import.

*Only one LONG column allowed per table
*LONG column cannot be indexed
*LONG columns cannot appear in integrity constraints
*LONG columns cannot be used in WHERE,GROUP BY,ORDER BY, or CONNECT BY clauses, or with the DISTINCT operator in SELECT statements.
*LONG columns cannot be used referenced by SQL functions (such as SUBSTR or INSTR).
*LONG columns cannot be used in the SELECT list of a subquery or queries combined by set operators (UNION, UNION ALL, INTERSECT, or MINUS).
*LONG columns cannot be used in SQL expressions.
*LONG columns cannot be referenced when creating a table with query (CREATE TABLE...AS SELECT...) or when inserting into a table(or view) with a query (INSERT INTO ... SELECT...).
*LONG columns cannot be referenced in a sub-query A variable or argument of a PL/SQL program unit cannot be declared using the LONG datatype.
*A LONG or LONG RAW column can be referenced in a SQL statement within a trigger if the data from a LONG or LONG RAW column can be converted to a constrained datatype (such as CHAR and VARCHAR2).
*Variable cannot be declared using the LONG or LONG RAW datatypes.