From oracle-l-bounce@freelists.org Wed Jun 23 13:23:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5NIN0p13586 for ; Wed, 23 Jun 2004 13:23:10 -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 i5NIMn613555 for ; Wed, 23 Jun 2004 13:23:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BA4972CC68; Wed, 23 Jun 2004 13:06:18 -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 32428-90; Wed, 23 Jun 2004 13:06:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9F69572C99C; Wed, 23 Jun 2004 13:06:17 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 23 Jun 2004 13:04:48 -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 5B79972CB62 for ; Wed, 23 Jun 2004 13:04:48 -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 31257-86 for ; Wed, 23 Jun 2004 13:04:48 -0500 (EST) Received: from mx1.sonypictures.com (mx1.sonypictures.com [66.77.63.116]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id B418972CB96 for ; Wed, 23 Jun 2004 13:04:47 -0500 (EST) Received: (qmail 4678 invoked by uid 0); 23 Jun 2004 18:26:23 -0000 Received: from unknown (HELO spde-mail1.spde.net) (160.33.16.160) by 0 with SMTP; 23 Jun 2004 18:26:23 -0000 Received: from SL-MAIL2a.spde.net ([160.33.16.155]) by spde-mail1.spde.net with Microsoft SMTPSVC(5.0.2195.6713); Wed, 23 Jun 2004 11:26:22 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Subject: RE: Partition Question Date: Wed, 23 Jun 2004 11:26:23 -0700 Message-ID: <32EFAEA4102B7041842430B3B3938573041C2C18@sl-mail2a.spde.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Partition Question Thread-Index: AcRZR7wJyry2oQw7SiCnOPA59n5FpQAB8hqw From: "Yen, Eric" To: X-OriginalArrivalTime: 23 Jun 2004 18:26:22.0963 (UTC) FILETIME=[9626CC30:01C4594F] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3467 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: EYen@sonypictures.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Two real solid article on how to do this and real life considerations. http://www.dbazine.com/nanda6.shtml http://www.dbazine.com/nanda7.shtml -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Lex de Haan Sent: Wednesday, June 23, 2004 10:30 AM To: oracle-l@freelists.org Subject: RE: Partition Question Hi Hamid, this sounds like range partitioning to me ... if you say you want to always have 12 partitions, I am getting a little bit "nervous" -- I guess you mean that you want to add a new partition each time, while dropping one partition at the end, right? in other words, you don't "reuse" partitions. =20 Kind regards, Lex. =20 --------------------------------------------- visit my website at http://www.naturaljoin.nl =20 --------------------------------------------- =20 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Hamid Alavi Sent: Wednesday, June 23, 2004 18:28 To: 'Oracle-L (E-mail) Subject: Partition Question List - I have a column in all of my tables named partition_date but I want to partition tables based on the Month of this Date any body have any Idea? I want to have always 12 partition for each table Independent from a date Just Month .One partition for month 01, another for Month 02 etc till Month 12 then the next year is back again to Month 01 with using the partition date in each table my partition_date is TRUNC(sysdate). Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 ---------------------------------------------------------------- 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 ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: text/x-vcard -- File: Lex de Haan.vcf ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------