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