Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Antique hunter - looking for info on insert into partion (union-all) view
I think Michael Möller from Miracle implemented PV with one of our
Support customers, and it works nicely. Inserts will have to be guided
to the right table/partition by the application or by the instead-of
trigger on the view, I believe.
Mogens
Don Granaman wrote:
> The subject line really says it all. Someone I know is seriously
> considering it and asked me about this v7.3-compatible form of "logical"
> partitioning (in 9i no less!) with an "instead of " insert trigger on the
> view. It has been *way* too long. It hasn't been in my memory cache for
> years and only small fragments even seem to be in "secondary storage". The
> google mine doesn't yield much of use except for Jonathan's papers like
> pv.doc, but I haven't yet found the one with any discussion of insert. So,
> I am now looking for examples or papers. Pointers anyone? Someone must
> know where some dusty info on this is squirreled away. Perhaps circa 1995?
> At the Smithsonian? ;-)
>
> Don Granaman
> Resurrected OraSaurus
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 22 2004 - 14:51:33 CDT
![]() |
![]() |