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!

CTAS on partition table

520889May 8 2009 — edited May 8 2009
9R2

I'm wondering how

create table xxxx as select * from yyyy

would work on partition table?

Would the structure be mirrored in terms of partitions?

Is there a way to mirror /copy all partitions ?

Thx,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2009
Added on May 8 2009
3 comments
1,135 views