Re: Remove default value from table definition

On Mon, 16 Jan 2006 20:40:29 +0100, "Jürg Schaufelberger" <juerg.schaufelberger_at_tele2.ch> wrote:

>Hello
>
>I want to remove a default value. I tried the following statement:
>alter table myTable
>modify(myColumn default null)
>The default value is now removed, but not the definition.
>Is there a other way to clear the old definition ?
>(Oracle 8.1.7)
>Thanks for your help !
>
>Jürg
>

create a new table
insert the data
drop the table
rename the new table to the original one

would obviously work.
Other than that there are only unsupported methods imaginable to update the dictionary directly.

--
Sybrand Bakker, Senior Oracle DBA