on 10-22-2008 11:03 AM
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
Hi Andreas,
Increase the size of the tablespaces and repeat the import.
Regards
Ashok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello all, thanks for your replies
What I do not understand is that I have so much contiguous space in both tablespaces and still the import will stop with the same issue. The indexes that need to be created are 1.2 GB and 700MB in size , I have 4 GB contiguous space as I can see from brspace (see my previous message). Why should I need to add more space?
Anyway, I added 10GB in both tablespaces. I got the same issue again. Any ideas?
Regards
Andreas
Edited by: support team on Oct 22, 2008 2:07 PM
Please also check if your filesystem is not full.
Regards Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
follow Note 3155 - Termination due to tablespace overflow
cheers,
-Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.