Re: Problem with LONG datatype column

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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org