OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » alter column type !

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

alter column type ! [message #171539]

Wed, 10 May 2006 06:45

ozmartin
Messages: 7
Registered: March 2006
Location: MILANO

Junior Member

Please,I need help! How can i change column type in a table with rows from number to varchar2 in oracle9 ?

Report message to a moderator

Re: alter column type ! [message #171549 is a reply to message #171539]

Wed, 10 May 2006 06:55

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

A workaround

-- Create a table to store the rows temporarily using CTAS.

-- Truncate the original table.

-- Modify the column datatype.

-- Load the data back.

Report message to a moderator

Re: alter column type ! [message #171555 is a reply to message #171549]

Wed, 10 May 2006 07:05

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Or save youself space and time,
create a new column n the existing table, transfer the data from old to new column, drop the old column.

Jim

Report message to a moderator

Re: alter column type ! [message #171559 is a reply to message #171555]

Wed, 10 May 2006 07:08

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Hey! that's a cool way. Cool

Report message to a moderator

Re: alter column type ! [message #171563 is a reply to message #171539]

Wed, 10 May 2006 07:15

gajini
Messages: 262
Registered: January 2006

Senior Member

ALTER TABLE table_name MODIFY column_name VARCHAR2(5);

But the table should be empty.

[Updated on: Wed, 10 May 2006 07:15]

Report message to a moderator

Re: alter column type ! [message #171568 is a reply to message #171563]

Wed, 10 May 2006 07:18

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

please clarify. your snippet of info means very little as it has no context.

Report message to a moderator

Re: alter column type ! [message #171570 is a reply to message #171568]

Wed, 10 May 2006 07:23

ozmartin
Messages: 7
Registered: March 2006
Location: MILANO

Junior Member

Thanks 4 all Jim ! all done Smile

)

Report message to a moderator

Previous Topic:	ERROR:ORA-04098??
Next Topic:	Change to UTF8 character set

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:42:32 CDT 2024