ksandbergfl
Programmer
I am migrating a 6GB database from 8.1.7.4 to 9.2.0.4. The hardware is Sun v450's running Solaris 9.
I use the 8.1.7.4 EXPORT command to create my dump file. I have no tables with LONG's.
I use the 9.2.0.4 IMPORT command to load the dump file, using the following syntax:
IMP file= full=y ignore=y indexes=n constraints=n analyze=n feedback=5000 commit=n buffer=10000000
The import screams through the first 50 tables... over 1GB worth of data is loaded within 45 minutes, which is pretty good. There are two tables with over 3M rows in this bunch. But then, for no reason I can determine -- IMP gets really slow. Right now, a 170MB table with 1.8M rows has taken over 2 hours, and it's still not done. Again, there are NO LONG's in my data (I know enough not to IMP tables with LONG's). I have disabled all triggers and constraints. The data should simply be zooming right in.
Any ideas what might be going on? My UNDO and my TEMP tablespaces appear to be fine.
Thanks in advance for any help you can provide.
I use the 8.1.7.4 EXPORT command to create my dump file. I have no tables with LONG's.
I use the 9.2.0.4 IMPORT command to load the dump file, using the following syntax:
IMP file= full=y ignore=y indexes=n constraints=n analyze=n feedback=5000 commit=n buffer=10000000
The import screams through the first 50 tables... over 1GB worth of data is loaded within 45 minutes, which is pretty good. There are two tables with over 3M rows in this bunch. But then, for no reason I can determine -- IMP gets really slow. Right now, a 170MB table with 1.8M rows has taken over 2 hours, and it's still not done. Again, there are NO LONG's in my data (I know enough not to IMP tables with LONG's). I have disabled all triggers and constraints. The data should simply be zooming right in.
Any ideas what might be going on? My UNDO and my TEMP tablespaces appear to be fine.
Thanks in advance for any help you can provide.