Home » RDBMS Server » Server Utilities » Changing Data structure
Changing Data structure [message #71296] Thu, 10 October 2002 05:58 Go to next message
Smoke Williamss
Messages: 6
Registered: October 2002
Junior Member
Hi, not sure if this is the right place to post this. I have a small group of tables and I need to change one column in several of the tables from a VARCHAR2(2000) to a CLOB. I have to keep the data that already exists in the tables. How can I move the data out, make the changes to the structure and then move the data back in? Any help would be greatly appreciated. Thanks.

Report message to a moderator

Re: Changing Data structure [message #71308 is a reply to message #71296] Mon, 14 October 2002 05:58 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
Create TABLE_TEMP as select * from [[TABLE]]

Drop TABLE [[TABLE]]

Recreate it and insert all the rows.

Report message to a moderator

Previous Topic: clustered tables
Next Topic: Urgent: Problems with Creating Database, Servermanager, Internal PWD
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 10:12:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.