Re: modifying and adding columns to a big table

From: Rob Cowell <rjc4687_at_hotmail.com>
Date: Mon, 10 Nov 2003 15:12:51 +0000 (UTC)
Message-ID: <3FAFAAF2.54BB2687@hotmail.com>

Cris Carampa wrote:
>
> I have to enlarge the precision of a numeric column and add two new
> columns on a partitioned table that counts 1,300,000 records. This on
> Oracle 9.0.1.3 on SuSE SLES 7. Is this a resource-consuming operation or
> a "light" one? Does this operation will invalidate the packages based on
> this table?
>
> Thanks in advance - Kind regards,
>
> --
> Cris Carampa (spamto:cris119_at_operamail.com)
>
> "Poveri fanatici comunisti, noglobal e affetti dalla sindrome
> anti-microsoft" (gli utenti Linux secondo un poster di ICOD)

Adding and modifying columns is "light". It's dropping them that hurts.

It will invalidate your packages. Received on Mon Nov 10 2003 - 09:12:51 CST