Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dynamically add partition

Re: dynamically add partition

From: Ben de Boer <cbdeboer_at_planet.nl>
Date: Wed, 8 Feb 2006 15:59:56 +0100
Message-ID: <dsd11g$d33l$1@news3.infoave.net>


It would be helpfull to be more specific. Range or hash partition?

Use alter table add partition or something Do it with dynamic sql and you are quite flexibel.

Remeber that alter table will make depending objects invalid.

Regards, Ben de Boer

"o" <new2unix_at_gmail.com> wrote in message news:1139380929.528009.162030_at_g43g2000cwa.googlegroups.com...
> 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 !
>
Received on Wed Feb 08 2006 - 08:59:56 CST

Original text of this message

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