Re: full exp followed by full imp

The export/import routine you describe will rebuild the entire database for you. However, since you are going to go through the excercise, it might be a good time to check the sys.dba_segments table and see if your tables are overextended. You might see significant performance gains by importing your data into one a single presized table segment. Also, depending on the size of your database, number of indexes and foreign key constraints, the import facility can take a VERY long time. You can break this up by having the database precreated, importing only the data, and then running sql scripts to create your indexes and constraints. Hope this helps.

Ken Brouillette
Database Administrator
CSC - PLK-FMBJ
Albuquerque, NM Received on Thu Jan 18 1996 - 00:00:00 CET