Re: Block DML!?

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 07 Aug 2004 02:38:47 GMT
Message-ID: <XgXQc.2736$5Z3.2422@newssvr29.news.prodigy.com>

Daniel Morgan wrote:

> Howard J. Rogers wrote:
>

>> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
>> news:1091770680.453840_at_yasure...
>>
>>> DBMS_REDEFINITION does insert records into a new table .
>>

[...]

>>> .. the one
>>> defined in the redefinition procedure as the interim table. And, as you
>>> indicate, the price is quite a bit lower.
>>
>> The price is irrelevant if the package doesn't do what the poster has 
>> quite
>[...]

> All valid points. And, BTW, who or what has turned you into a top
> poster?
>
> One could, of course, alwayss do "partitioning" the way the sold that
> bill of goods to the DB2 folks. Make a bunch of tables. Create a view
> putting them all together with UNION ALL. Give it the name of the
> original table. Spend money advertising that you have partitioning and
> didn't send any money to Redwood Shores. Yech!
>

"Wait, I know this! It's a Unix system..." <Jurassic Park>

Wait, I know this! It's partitioned views! (from Oracle v7). I knew them well...

--Mark Bole Received on Fri Aug 06 2004 - 21:38:47 CDT