Re: dropping a column in a production database

Giganews Newsgroups
Subject: Re: dropping a column in a production database
Posted by:  Ed Prochak (edproch…@gmail.com)
Date: Wed, 2 Jul 2008

On Jul 2, 7:47 am, yossarian <yossaria.…@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

Replies

In response to

dropping a column in a production database posted by yossarian on Wed, 02 Jul 2008