man先森
2021-05-20 15:26
采纳率: 33.3%
浏览 226

求助大神看看 oracle 使用impdp导入时创建索引缓慢,并以下错

以下是导入日志的报错


Failing sql is:
GRANT DELETE ON "SI3"."PER_MOVE" TO "ZH"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'ZH' does not exist

Failing sql is:
GRANT UPDATE ON "SI3"."DECL_RATE" TO "ZH"
Processing object type SCHEMA_EXPORT/VIEW/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-31625: Schema SI0001 is needed to import this object, but is unaccessible
ORA-01435: user does not exist

Failing sql is:
CREATE INDEX "MHS5"."PATIENT_SCRIPT_ITEM$YYXMBM" ON "MHS5"."PATIENT_SCRIPT_ITEM" ("YYXMBM", "YYBM") PCTFREE 10 INITRANS 2 MAXTRANS 
255  STORAGE(INITIAL 17825792 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO
OL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TS_MHS5" PARALLEL 1 
ORA-39083: Object type INDEX failed to create with error:
ORA-31625: Schema SI0002 is needed to import this object, but is unaccessible
ORA-01435: user does not exist

Failing sql is:
CREATE INDEX "SI0002"."INDEX_AEV2" ON "SEAP"."AEV2" ("CAEK75", "CAZ124", "CAEE71") PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INIT
IAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CAC
HE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" PARALLEL 1 
ORA-39083: Object type INDEX:"SI3U"."PK_AC06" failed to create with error:
ORA-30032: the suspended (resumable) statement has timed out
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Failing sql is:
CREATE UNIQUE INDEX "SI3U"."PK_AC06" ON "SI3U"."AC06" ("AAZ039", "AAZ158", "AAE140", "AAE149") PCTFREE 10 INITRANS 2 MAXTRANS 255 N
OLOGGING  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_
POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TSI_SI3U" PARALLEL 1

以下是alert日志的报错

Resize operation completed for file# 675, old size 6885376K, new size 6987776K
2021-05-19T01:08:03.691876+08:00
Resize operation completed for file# 3, old size 1679360K, new size 1689600K
2021-05-19T01:08:15.214478+08:00
Resize operation completed for file# 674, old size 7090176K, new size 7192576K
2021-05-19T01:09:30.167033+08:00
Resize operation completed for file# 673, old size 7192576K, new size 7294976K
2021-05-19T01:10:10.304667+08:00
ALTER SYSTEM SET _disable_file_resize_logging=TRUE SCOPE=BOTH;
2021-05-19T02:00:00.765960+08:00
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
2021-05-19T02:00:03.545700+08:00
opidrv aborting process J002 ospid (14233) as a result of ORA-1013
2021-05-19T02:00:28.922414+08:00
opidrv aborting process J001 ospid (14231) as a result of ORA-1013
2021-05-19T12:38:33.214765+08:00
ALTER SYSTEM SET _disable_file_resize_logging=TRUE SCOPE=BOTH;
2021-05-19T12:39:11.313833+08:00
ALTER SYSTEM SET _disable_file_resize_logging=TRUE SCOPE=BOTH;
2021-05-19T22:00:01.107028+08:00
Setting Resource Manager plan SCHEDULER[0x4AC5]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2021-05-19T22:00:10.556519+08:00
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2021-05-19T22:00:55.553428+08:00
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2021-05-19T22:02:37.714935+08:00
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P367 (44334) VALUES LESS THAN (TO_DATE(' 2021-05-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P370 (44334) VALUES LESS THAN (TO_DATE(' 2021-05-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2021-05-20T00:01:36.379217+08:00
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P371 (4157) VALUES LESS THAN (TO_DATE(' 2021-05-20 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2021-05-20T01:01:08.413266+08:00
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P372 (4158) VALUES LESS THAN (TO_DATE(' 2021-05-21 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P373 (4158) VALUES LESS THAN (TO_DATE(' 2021-05-21 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2021-05-20T02:00:01.141585+08:00
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
2021-05-20T02:00:05.653167+08:00
opidrv aborting process J002 ospid (1578) as a result of ORA-1013
2021-05-20T02:00:38.425940+08:00
opidrv aborting process J001 ospid (1559) as a result of ORA-1013

1条回答 默认 最新

相关推荐 更多相似问题