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: bikle@bikle.com

Author's url: http://www.bikle.com

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:

Author

Title/URL

Suggested by

Referee's comments

Dan Bikle

http://www.bikle.com/TThier/DBAtips/shrinkEventTable/

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: http://www.google.com/search?sourceid=navclient&q=oracle+monitoring


Back to top

Back to index of questions