Hello,

I basically want to create a table at run time for which the schema and data
will be coming from the SELECT statement. The source (SELECT statement) and
the destination (new table) are on different schemas'. I tried with CREATE
TABLE AS ABC SELECT *FROM ABC. This works great in almost all the scenarios.
However, when the source schema has a column with LONG datatype it runs into
errors. ORA-00997: illegal use of LONG datatype.



I also tried to use the COPY command to achieve the required functionality.
This resolves the problem for LONG datatype. However, it fails for CLOB
datatype.



I cannot modify the source destination schema.



I am sure someone would have a resolution to the problem that I am
encountering. Please let us know the best possible way to deal with all the
above mentioned problems. Thanks in advance.



Tushar Dave

Intrack Inc




Oracle LazyDBA home page