Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Import on 8.1.6 hanging?

Import on 8.1.6 hanging?

From: hellothere <hellothere_at_ibm.net>
Date: Sat, 10 Feb 2001 16:15:28 -0800
Message-ID: <3A85D99F.5C5481DB@ibm.net>

I am importing a very large database from an Oracle 8.0.5 Instance to an 8.1.6 instance.

All tablespace parameters were set, and the table storage parameters were stripped from the export files.

The export is split into several files, and the import cat's and pipes these files to a pipefile, which the import then reads from. However, one of the index tablespaces ran out of room for the next extent (yikes), and I have added space, but I am not sure if the import process will continue or not.

I still see the process when ps -ef | greping it, but when trussing the import process, there is no output any more. When trussing the shell script, it says it's sleeping.

The status of the import process within Oracle is INACTIVE, however, the two indexes that attempted to extend
still have ACTIVE locks...which don't go away.

The actual tablespace % used is not growing....

Has the import actually failed, is it suspended, or????? If it is no longer capable of running, why doesn't the process just die?...

Any ideas on this one?

Thanks Received on Sat Feb 10 2001 - 18:15:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US