Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> long fields - create table xyz as select ... doesnt work
We are facing a problem when we try to create a new table using the 'AS'
keyword such as :
CREATE TABLE temp_table AS SELECT * FROM original_table
when the table original_table contains a field with the datatype LONG.
If the table doesn't contain a field with this type everything works
fine, that means the table
temp_table is created and all the data of table original_table is
inserted into temp_table.
We need a possibility to move the whole data of table original_table
into a temporary table,
destroy original_table, create a new table with the name original_table
(maybe with a
different structure) and as the last point move the data from temp_table
back to the new
original_table.
Is there any solution or a workaround ? (We need this long fields in
special tables !!!)
Thanks in advance Received on Tue Apr 27 1999 - 10:46:15 CDT