Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle alter table question
Rayden wrote:
> hey,
>
> i have a table with which i need to change one of the columns, however
> because i have data in the tables it will not let me do this (oracle 8i).the
> column change is to increase a varchar in size. how in the world do i do
> this? i tried to exp the data, however it does the table as well. i am a
> little lost here, so any help would be appreciated.
>
> tom
CREATE TABLE temp AS
SELECT *
FROM table_name;
TRUNCATE TABLE table_name
ALTER TABLE table_name
MODIFY (...
INSERT INTO table_name
SELECT *
FROM temp;
DROP TABLE temp;
Daniel Morgan Received on Thu May 09 2002 - 10:45:44 CDT