Skip to Main Content
  • Questions

  • Non partition to composite partition.

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Pradeep.

Asked: January 17, 2017 - 1:37 pm UTC

Last updated: January 20, 2017 - 12:07 pm UTC

Version: 11gr2

Viewed 1000+ times

You Asked

Hi team,


Can you please let me know steps to convert non partition table to partition table.

suppose i have sales table in that i want year wise range partition and later in range partition i want list partition.

Please help to achieve this.

Thank's
Pradeep

and Connor said...

Simply use DBMS_REDEFINITION and the process will be down online

Good examples here

https://uhesse.com/2010/02/15/partitioning-a-table-online-with-dbms_redefinition/

https://oracle-base.com/articles/misc/partitioning-an-existing-table

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:869096700346654484

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Non partition table to composite range list partition convert.

Pradeep prajapati, January 18, 2017 - 12:30 pm UTC

Hello ,

You revert is quite useful for normal non partition table to partition table. but when i try exchange option for non partition table to composite range list partition convert it giving "ora-14291 cannot exchange a composite".

please suggest for same.

Thank's
Pradeep
Connor McDonald
January 20, 2017 - 12:07 pm UTC

exchange is for 'swapping' two like-for-like database structures.

So would exchange a table into a sub-partition, or exchange a partitioned table with one of the partitions in the composite table

non Partition to composite partition

Pradeep prajapati, January 20, 2017 - 1:30 pm UTC

Thanks ..for making me to understand.

I'll check and comeback to you soon.

Thank's
Pradeep
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.