暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

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

2011-01-01
581

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


【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论