Re: dynamically add partition

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 08 Feb 2006 09:10:32 -0800
Message-ID: <1139418623.765192@jetspin.drizzle.com>

o wrote:
> if I have a table and partitioned based it on date. Then how can I
> extend the partitions
> dynamically ! That is I want to generate a partition everyday !
> As the data is very large ! So help me out !

Oracle 9i or earlier .... DBMS_JOB
Oracle 10g .... DBMS_SCHEDULER

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Feb 08 2006 - 11:10:32 CST

This message: [ Message body ]
Next message: Walt: "Re: Use a trigger to remove NULL values?"
Previous message: DA Morgan: "Re: DBMS Job not running (time change)"
In reply to: o: "dynamically add partition"
Next in thread: Ben de Boer: "Re: dynamically add partition"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US