Re: full exp followed by full imp

Ken Brouillette <kabroui_at_obelisk.plk.af.mil> wrote:

>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

I had problems doing this, but can't remember exactly what went wrong. We ended up not exporting constraints, and making them later with SQL. We now dont export constraints at all. For some reason we were unable to import if we exported with constraints. We were moving data between instances.

(Solaris 2.4 Oracle 7.0.16) Received on Sat Jan 20 1996 - 00:00:00 CET