Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Changing Datatype Part II
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
![]() |
![]() |