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?
b) SQL*Plus COPY command
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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?
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
Click Here to Expand Forum to Full Width