Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> long fields - create table xyz as select ... doesnt work

long fields - create table xyz as select ... doesnt work

From: Josef Graef <CURSOR_at_t-online.de>
Date: Tue, 27 Apr 1999 16:46:15 +0100
Message-ID: <3725DBC7.67CA1EE4@t-online.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US