我把4000万的数据导入了一张新表.
在导入之前.我将所有约束都置失效,
SET CONSTRAINTS, INDEXES, TRIGGERS FOR 表名 DISABLED;
导入成功之后.
SET CONSTRAINTS, INDEXES, TRIGGERS FOR 表名 ENABLED;
打算把所有约束重建起来.
建了很久.都没有反应.查看日志.发现.报.
WARNING: Not enough temp space for parallel index build.
Space required = 7026482 pages; space available = 4954397 pages
临时表空间不足.
我有2个临时表空间.都有.10G.. 空间是足够的.可是为什么还会报.表空间不足了...求高手.帮忙....该如何是好?
数据库也没办法重起!!
报错如下:
19:42:26 WARNING: Not enough temp space for parallel index build.
Space required = 2163756 pages; space available = 2038818 pages.
Partial index build started.
20:34:37 Checkpoint Completed: duration was 0 seconds.
20:34:37 Fri Jun 15 - loguniq 110, logpos 0x3d85018, timestamp: 0xdc40bbc Interval: 1006
20:34:37 Maximum server connections 18
20:34:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 75, Llog used 52
21:54:37 Checkpoint Completed: duration was 1191 seconds.
21:54:37 Fri Jun 15 - loguniq 110, logpos 0x3daf038, timestamp: 0xde1790a Interval: 1007
21:54:37 Maximum server connections 18
21:54:37 Checkpoint Statistics - Avg. Txn Block Time 1192.118, # Txns blocked 3, Plog used 413, Llog used 42
收起