ORA-01659 during system import
Dear all,
I am in the middle of a Unicode conversion. I have exported the system and I am trying to import it now. I get a couple of ORA-01659 as per below on the creation of two big indexes
INDEX 1
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(SQL) INFO: Trying to open /oracle/export2/ABAP/DB/ORA/USER4.SQL
(SQL) INFO: /oracle/export2/ABAP/DB/ORA/USER4.SQL opened
(DB) ERROR: DDL statement failed
(DROP INDEX "/BI0/AFIGL_O0200~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "/BI0/AFIGL_O0200~0" ON "/BI0/AFIGL_O0200" ( "COMP_CODE", "CHRT_ACCTS", "GL_ACCOUNT", "FISCVARNT", "FIS
CPER", "AC_DOC_NO", "ITEM_NUM" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 1267089408 NEXT 0000010240K MINEXTENTS 0000000001 MAXEXT
ENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P021
ORA-01659: unable to allocate MINEXTENTS beyond 3 in tablespace PSAPSR3
(DB) INFO: disconnected from DB
/usr/sap/BWD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/BWD/SYS/exe/run/R3load: END OF LOG: 20081022094428
INDEX 2
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "D010TAB~0" ON "D010TAB" ( "MASTER", "TABNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 717358080 NEXT
0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P086
ORA-01659: unable to allocate MINEXTENTS beyond 18 in tablespace PSAPSR3700
(DB) INFO: disconnected from DB
/usr/sap/BWD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/BWD/SYS/exe/run/R3load: END OF LOG: 20081022094720
I could add more space (actually, I added 2 GB in each tablespace autoextensible to 10GB) but I got the same error again and I do not understand why. As per below, there is plenty of contiguous space both in PSAPSR3 and PSAPSR3700
BR0280I BRSPACE time stamp: 2008-10-22 10.17.05
BR0659I List menu 259 + you can select one or more entries
-
List of database tablespaces
Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.
Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt. Largest[KB]
1 - PSAPSR3 DATA ONLINE LOCAL AUTO NO 7/7
71634944 68.70 22421760 71680000 45056 188 4063232:4063232:2080704:909312 :417792
2 - PSAPSR3700 DATA ONLINE LOCAL AUTO NO 2/2
20480000 39.64 12361920 20480000 0 6 4063232:4063232:2113472:211347 2:8192
3 - PSAPSR3USR DATA ONLINE LOCAL AUTO NO 1/1
20480 3.75 19712 10240000 10219520 1 10219520+:19712:0:0:0
4 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 1/1
1290240 0.00 1290240 10240000 8949760 0 8949760+:0:0:0:0
5 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO 1/1
1474560 0.00 1474496 10240000 8765440 6167 8765440+:8192:8192:8192:8192
6 - SYSAUX DATA ONLINE LOCAL AUTO NO 1/1
204800 32.78 137664 10240000 10035200 2 10035200+:137152:512:0:0
7 - SYSTEM DATA ONLINE LOCAL MANUAL NO 1/1
378880 96.64 12736 10240000 9861120 1 9861120+:12736:0:0:0
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your selection:
Any ideas
Thank you
Andreas