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

Home -> Community -> Usenet -> c.d.o.misc -> Changing Datatype Part II

Changing Datatype Part II

From: KC <kchui_at_smtpgw.arms.ohio-state.edu>
Date: 19 Jan 1999 19:12:15 GMT
Message-ID: <01be43df$3b098440$719c9280@hli.arms.ohio-state.edu>


Newbie question:
I have a table with 4 columns and 74 rows of data. One of the fields is a VARCHAR2 datatype; the field size is 254. Because of size constraints, I would like to replace/change the VARCHAR2 column with a LONG column instead, while keeping the data intact. However, I've been reading that LONG datatypes cannot be referenced when creating a table with a query -or- when inserting into a table with a query. What I would like to now is: 1) does this hold true if it's in the target database, and 2) if it is true, what are some possible solutions around this scenario? Received on Tue Jan 19 1999 - 13:12:15 CST

Original text of this message

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