upuaut_at_yahoo.com wrote:
> I need help understanding whether I should invest in the scenario below
>
> Scenario:
>
> 1- I create a table table1, with colmns c1 (varchar32) ,c2 (number),c3
> (number), and partition on column c3
> 2- I load data into table1 where c3 is null, on a daily basis. 7
> million records on average per day.
> 3- I later update c3, with a calculated value.
>
> Questions:
> 1- how does the data get partitioned on the initial load?
> 2- Once I update c3, what happens? does data get moved to the proper
> partition? stay where it was loaded?
>
> Should I follow this scenario?
>
> thanks in advance.
No Oracle version
No information on the volume of data
On its face it is a bad idea. But that doesn't mean it isn't the one
to be chosen.
You need to run a test and examine the impact.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Jun 13 2005 - 21:51:34 CDT
