The Oracle (tm) Users' Co-Operative FAQ

Is there a good way to turn a simple table into a partitioned table ?

Author's name: Dan Bikle

Author's Email:

Author's url:

Date written: Jan 06 2002

Oracle version(s): All Versions

The scope for easy maintenance of aging data appeared in Oracle 8 with the introduction of partitoned tables. However, what are you supposed to do if you already have a production system with very large busy tables, and want to convert them into partiitoned tables ?

Back to index of questions

This question is addressed by the following documents:



Suggested by

Referee's comments

Dan Bikle

Dan Bikle

A hands-on documente demonstrating methods

Howard Rogers

Redefining a table

Jonathan Lewis

One of several “discussion documents” on the Dizwell website that take the time and space to examine Oracle features properly.


Further reading:

Back to top

Back to index of questions