Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dynamically add partition
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