记录多不代表数据量大,还跟表的字段多少有关系。可能你那个2万多条记录的表字段很多,数据量比较大,回退空间不够。
建议:
imp 加参数 commit=y如果你比较了解oracle,当imp不动的时候,查询v$session_wait看看具体是什么原因阻塞。
(或者你把v$session_wait内容贴出来)
建议:
imp 加参数 commit=y如果你比较了解oracle,当imp不动的时候,查询v$session_wait看看具体是什么原因阻塞。
(或者你把v$session_wait内容贴出来)
--查看v$session_wait
connect system/manager@oracle;
select * from v$session_wait;
SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SECONDS_IN_WAIT STATE
---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- -------- ---------------------------------------------------------------- ---------- -------- ---------------------------------------------------------------- ---------- -------- ---------- --------------- -------------------
11 243 SQL*Net break/reset to client driver id 1413697536 54435000 break? 0 00 0 00 0 20 WAITING
The server sends a break or reset message to the client. The session running on the server waits for a reply from the client.原因:
SQL*Net break/reset to client. The wait events occur when the Database
unexpectedly looses Net8 connectivity with a remote client . Frequent occurrences of these
events could indicate a networking issue.检查网络问题,或者不使用net8登录数据库,直接用IPC方式登录数据库