Re: modifying and adding columns to a big table

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,
>

Should be near instantaneous and yes it will invalidate the packages requiring a recompile.
Look in $ORACLE_HOME/rdbms/admin for the utlrp.sql script. Read the header before
running it to make sure it will do what you want.

Two comments though:

1. You version of Oracle barely qualifies as better than Beta. Why not upgrade to 9.2?
2. 1.3M rows is so small it is hardly worth partitioning. This is a very small table. I hope you didn't expend the money for EE just for this.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)