It does get to the last table (and imports the data OK).
There are no locks/blocks on the DB
(whilst the import is running, i do see a lock on each table in turn, there are none once the data has been imported.. however IMP.EXE is still present... and there is no 'success' message)
This happens every time I run it (including following a reboot of the machine, or a restart of oracle).. i'm testing this locally on a laptop so there are no other users ..
I'm using the following to check locks..
------------
set lines 132 pages 24
col object format a35
select session_id,object_type,own
from dba_objects obj,v$session ses,v$locked_object lobj
where lobj.object_id = obj.object_id
and lobj.session_id = ses.sid
------------
And the following for blocks
------------
set feedback off
set lines 132 pages 24
col username format a10
col object format a30
col "Mode held" format a14
col "Mode requested" format a14
col "Idle" format 999999
col type format a4
select l.sid,s.username,s.last_ca
decode(lmode,0, 'None',
1, 'Null (NULL)',
2, 'Row-S (SS)',
3, 'Row-X (SX)',
4, 'Share (S)',
5, 'S/Row-X (SSX)',
6, 'Exclusive (X)') "Mode held",
decode(request,0, 'None',
1, 'Null (NULL)',
2, 'Row-S (SS)',
3, 'Row-X (SX)',
4, 'Share (S)',
5, 'S/Row-X (SSX)',
6, 'Exclusive (X)') "Mode requested",
ctime,
decode(block,0,'',1,'Block
from v$lock l,v$session s
where id1 in (select id1 from v$lock where request <> 0)
and l.sid = s.sid
order by id1,id2
/
select session_id,object_type,own
from dba_objects obj,v$session ses,v$locked_object lobj
where lobj.object_id = obj.object_id
and lobj.session_id = ses.sid
and lobj.session_id in (
select l.sid
from v$lock l,v$session s
where id1 in (select id1 from v$lock where request <> 0)
and l.sid = s.sid )
/
------------
Main Topics
Browse All Topics





by: chedgeyPosted on 2008-06-18 at 04:58:10ID: 21811911
Has it reached the end of the lis tof tables? If so it sounds as if it is some kind of locking issue - are there other sessions using this schema in the database? Check for locks in the database and clear them or, for a quick solution, shutdown and re-start the database then run again.
Regards
chedgey