Re: dropping a column in a production database
From: Ed Prochak <edprochak_at_gmail.com>
Date: Wed, 2 Jul 2008 05:26:32 -0700 (PDT)
Message-ID: <9857a229-e066-419b-9a7f-a875f9e736ea@x35g2000hsb.googlegroups.com>
Date: Wed, 2 Jul 2008 05:26:32 -0700 (PDT)
Message-ID: <9857a229-e066-419b-9a7f-a875f9e736ea@x35g2000hsb.googlegroups.com>
On Jul 2, 7:47 am, yossarian <yossaria..._at_operamail.com> wrote:
> Is this a safe operation? According to the docs, it should be. Any
> contraindications?
>
> (Oracle 10.2.0.3 on SUSE Linux)
>
> Thank you. Kind regards, Y.
when was the last time you tested your backup and restore processes?
It is safe in the sense that it will do exactly what you ask. Any data in that dropped column will be gone (forever if you do not have it in a backup). Note that any applications that used that column will need to be rewritten. Packages, functions and procedures dependent on that column will become invalid and need to be rewritten. It's all standard stuff.
HTH,
ed
Received on Wed Jul 02 2008 - 07:26:32 CDT