| is dropping column supported in 814 db [message #79994] |
Wed, 31 July 2002 10:24  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
I'm about to add a column onto an 814 db. I need to be able to drop the column if something fails! Does 814 support the dropping of columns?
Thanks a bunch,
T
|
|
|
|
| Re: is dropping column supported in 814 db [message #80002 is a reply to message #79994] |
Thu, 01 August 2002 10:19  |
Ricardo
Messages: 7
Registered: November 1999
|
Junior Member |
|
|
Hi,
The parameter COMPATIBLE of init.ora need value of 8.1.0 or upper.
And to drop a column would you try this:
ALTER TABLE "schema"."table_name"
SET UNUSED ("column_name") CASCADE CONSTRAINTS;
Or:
ALTER TABLE "schema"."table_name"
DROP ("column_name") CASCADE CONSTRAINTS;
But, this value of parameter you can not change already.
Better is drop and create the table with the columns that you need.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
