Re: Select into or create <table> as & LONG datatypes - what to do?

Export and import the entire table.
Use proper storage clauses.

"Glen A. Sromquist" <stromqgl_at_alpac.ca> wrote in message news:FHar6.10379$Lm2.1287744_at_news0.telusplanet.net...
> I am trying to correct a table with a high number of chained rows, so I've
> ran the UTLCHAIN script, analyze <table> list chained rows into
> chained_rows, now I want to insert the chained rows from table_a into a
 temp
> table by using:
>
> create table table_a_chained
> as select * from table_ a
> where rownum in (select head_rownum from chained_rows
> where table_name = 'table_a')
>
> Then delete the rows from table_a and re-insert them from the temp table.
>
> unfortunatly one of the columns in table_a is a LONG RAW datatype and it
> wont allow this.
>
>
> Can I work around this?
>
>
> thanks in advance...
>
>
Received on Mon Mar 12 2001 - 15:20:43 CST