From oracle-l-bounce@freelists.org Thu Apr 22 02:26:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3M7QZs28966 for ; Thu, 22 Apr 2004 02:26:35 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3M7QZ628961 for ; Thu, 22 Apr 2004 02:26:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5116672CCDE; Thu, 22 Apr 2004 02:13:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25157-47; Thu, 22 Apr 2004 02:13:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9C8A672D039; Thu, 22 Apr 2004 02:13:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 22 Apr 2004 02:12:42 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DD7AA72CC1A for ; Thu, 22 Apr 2004 02:12:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23062-86 for ; Thu, 22 Apr 2004 02:12:41 -0500 (EST) Received: from lakermmtao10.cox.net (lakermmtao10.cox.net [68.230.240.29]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1F08572CC10 for ; Thu, 22 Apr 2004 02:12:41 -0500 (EST) Received: from dilbert ([68.96.142.184]) by lakermmtao10.cox.net (InterMail vM.6.01.03.02 201-2131-111-104-20040324) with SMTP id <20040422072420.MPGJ18696.lakermmtao10.cox.net@dilbert> for ; Thu, 22 Apr 2004 03:24:20 -0400 Message-ID: <2d6b01c428b0$3b463af0$6401a8c0@dilbert> From: "Don Granaman" To: Subject: Antique hunter - looking for info on insert into partion (union-all) view Date: Thu, 22 Apr 2004 03:24:20 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3526 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: granaman@cox.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Orig-Date: Thu, 22 Apr 2004 14:03:49 -0700 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@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 -----------------------------------------------------------------