Hi,

I need to move one table from one schema to another. Unfortunatelly one
of the column is a LONG datatype. I tried to do it in that way:
CREATE TABLE destination_table AS SELECT * FROM source_table

and in this way:
First I created Table and then: INSERT INTO destination_table SELECT *
FROM source_table

In both cases I received an error ORA-00997. Is there any solution of
this problem?

Best regards,
Krystian

sati_82 wrote:
> Hi,
>
> I need to move one table from one schema to another. Unfortunatelly one
> of the column is a LONG datatype. I tried to do it in that way:
> CREATE TABLE destination_table AS SELECT * FROM source_table
>
> and in this way:
> First I created Table and then: INSERT INTO destination_table SELECT *
> FROM source_table
>
> In both cases I received an error ORA-00997. Is there any solution of
> this problem?
>
> Best regards,
> Krystian

Basically the first hit on google web (search: ORA-00997) describes
this problem, and this http://www.dbaxchange.com/3_4_longdatatypes.htm
looks like a nice description and workaround to me.

- cheers -

sati_82 wrote:
> Hi,
>
> I need to move one table from one schema to another. Unfortunatelly one
> of the column is a LONG datatype. I tried to do it in that way:
> CREATE TABLE destination_table AS SELECT * FROM source_table
>
> and in this way:
> First I created Table and then: INSERT INTO destination_table SELECT *
> FROM source_table
>
> In both cases I received an error ORA-00997. Is there any solution of
> this problem?
>
> Best regards,
> Krystian

DBMS_SCHEMA_COPY will move the entire schema.
Export/Import or DataPump to move one table.

Demos in Morgan's Library at www.psoug.org.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org