1. check the v$session_longops for that session and see what is happening.
if you are on 9i and resume is enabled, then query
"select * from dba_resumable" and see any suspended session due to space
issue.

Pls post what you see for that session on v$session-longops view.

----- Original Message -----
From: "tom sauyer" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, November 28, 2003 2:11 PM
Subject: import help needed desparately


> Hello friends
>
> I'm presently importing data into a table emp. the number of rows that i'm
expecting is 6785, however, only 3997 rows have been imported, while
monitory the progress of the import by running a count(*) from emp, i
noticed that the rows imported has stopped at 3997 and this has been the
case for the past 2hrs. Please any suggestion, how can i get oracle to
import all the data in the dump file
>
>
> ---------------------------------
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
Oracle LazyDBA home page