Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter existing big partitioned table to add partitions automatically

Joaquin GonzalezMar 1 2013 — edited Mar 1 2013
Hi everyone,

I think it's not possible to alter a existing big partitioned table, to add partitions automatically as you insert into it. What would be the best way to do this? Dbms_redefinition? CTAS+copy dependents+rename?

Any ideas?

Thank you.

current version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
This post has been answered by unknown-7404 on Mar 1 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2013
Added on Mar 1 2013
3 comments
541 views