导入优化,数据量过多时,需添加commit=y参数,避免回滚段溢出;
以下导入了将近1.5亿行数据,耗时380分钟:
[oracle@mdb ~]$ imp username/password file=/home/oracle/dmp/temp.dmp
feedback=10000 ignore=y buffer=40960000 rows=y indexes=n tables=T_TEMP commit=y
Import: Release 11.2.0.1.0 - Production on Sun Sep 24 14:43:11 2017
Copyright (c) 1982, 2009,
Oracle and/or its affiliates. All rights reserved.
导入某张数据表(数据量1.5亿行)时,耗时19小时之后,出现中断;
采用以上方式之后,成功导入数据。
IMP-00058: ORACLE error 12552 encountered
ORA-12552: TNS:operation was interrupted
Cause: An internal operation was interrupted and could not complete.
Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. If error persists, contact Oracle Customer Support.