Hi people:
I am trying to import into NT Oracle 9i 9.2.0.1.0 server a dump file created from another NT. When I perform the import, specifying the FROM USER TOUSER parameters, the import kicks off happily but stalls at :
Import: Release 8.1.6.0.0 - Production on Thu Jun 26 15:54:30 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V08.01.06 via direct path
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)......
TOAD tells me that the current statement is:
ALTER SESSION SET EVENTS '22825 TRACE NAME CONTEXT FOREVER, LEVEL 1'
and it has been for about 3.5 hours.
Is there a way to see, what the import is attempting to accomplish? What should I be looking for? I see no blocks nor any significant events in v$waitstat, no active session and no resource activities on the system.
Thanks,
I am trying to import into NT Oracle 9i 9.2.0.1.0 server a dump file created from another NT. When I perform the import, specifying the FROM USER TOUSER parameters, the import kicks off happily but stalls at :
Import: Release 8.1.6.0.0 - Production on Thu Jun 26 15:54:30 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V08.01.06 via direct path
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)......
TOAD tells me that the current statement is:
ALTER SESSION SET EVENTS '22825 TRACE NAME CONTEXT FOREVER, LEVEL 1'
and it has been for about 3.5 hours.
Is there a way to see, what the import is attempting to accomplish? What should I be looking for? I see no blocks nor any significant events in v$waitstat, no active session and no resource activities on the system.
Thanks,
