Problem solve Get help with specific problems with your technologies, process and projects.

Limit of fragments in a table

I am using Oracle 8.1.7 in a 64-bit version together with SAP and HP. My tables are very much fragmented, and I...

heard that there is a limit of the fragments of a table. Do you know something about it, and what is the limit for the number of fragments that ORACLE can handle? I intend to mirate to ORACLE 9.2. Are there the same limitations of the fragments? What are the limits depending on?

See the following link for some great info on this topic with additional resources quoted as well: http://www.jlcomp.demon.co.uk/faq/table_frag.html.

If you're still concerned, you can get a script from Metalink (you have to have a Metalink account) for looking at fragmentation.

For More Information

This was last published in March 2003

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.