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

Moving a kludged Oracle 8i database to Oracle 10g

Currently I am working on Oracle 8.1.7. I have a table with a CLOB field, which has more than 2,500,000 records. I have also indexed (InterMedia text, CTXSYS.context) the CLOB field and retrieving records using the "contains" keyword in Oracle. I designed the database by applying a trial and error method. Even though it works, I know that my design is not optimal. Now I want to shift the database to Oracle 10g (64-bit). Please give me suggestions for designing an optimal database such as data file size, initial, next values, etc.

Currently I am working on Oracle 8.1.7. I have a table with a CLOB field, which has more than 2,500,000 records. I have also indexed (InterMedia text, CTXSYS.context) the CLOB field and retrieving records using the "contains" keyword in Oracle. I designed the database by applying a trial and error method. Even though it works, I know that my design is not optimal. Now I want to shift the database to Oracle 10g (64-bit). Please give me suggestions for designing an optimal database such as data file size, initial, next values, etc.
The principles that work for you in Oracle8i should work in Oracle10g as well. You can take advantage of features such as automatic segment space management and local extent management to ease administration of data files and object extents. Doing so will relieve you of the need to specify initial and next extent sizes.

I generally create three or four tablespaces based on object sizes. For each tablespace, I use local extent management with extents of uniform sizes -- one size per tablespace, usually 128 KB, 4 MB, 16 MB and 64 MB. Objects are assigned to tablespaces based on their sizes. Specifying uniform extent sizes means that free space within a tablespace can always be reused, as every object's extents are the same size.

This was last published in January 2006

Dig Deeper on Oracle database export, import and migration

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