Q
Manage Learn to apply best practices and optimize your operations.

Upgrading a database with locally managed tablespaces

You recently had a question about upgrading a database with locally managed tablespaces and ASSM to Oracle 9.2.0.5. Please warn the user who asked this question that this version has a bug in this combination in version 9.2.0.5 that gives rise to spurious data or index corruption errors. It is probably fixed in 10, but it's been giving me fits on my system (this version on HP-UX). The errors are intermittent and appear to be data-related, but they are severe enough that I'm using manual segment space management until I get version 10.
Thanks for the tip. Since you offer that the issue may be data-related (and I haven't seen such issues in the HPUX environments I've worked on), I would still suggest that ASSM is a good feature to use. If there are bugs, file them, raise their priority and get them addressed. You may also want to consider upgrading to 9.2.0.6 since that release would be more likely to be patched if a backport is required.

Dig Deeper on Oracle database design and architecture

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close