Re: partitioning on column with initial null value

upuaut_at_yahoo.com wrote:
> Sorry for the oversight.
>
> select * from v$version
> where banner like 'Oracle%'; returns
>
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
>
> Volume: 3 to 7 million records daily.
>
> What I'm trying to do is partition by week. Data is loaded into the
> table without the week value. I later would calculate it using oracle's
> date functions.
>
> each week's worth of data lives in the DB for few weeks, then gets
> deleted.
>
> I run weekly reports against the data using the week column. Ideally,
> all tables will be partitioned that way... if it is a viable opproach.
>
> thanking you in advance.

This has bad idea written all over it. There is no reason I can think of not to put the week number in during the insert. If you can think of one ... what is it?

And why 9.2.0.1? Doesn't your DBA believe in patches?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)