Archived discussions are read-only. Learn more about SAP Q&A

ORA-01659: unable to allocate MINEXTENTS beyond 28 in tablespace PSAPSR3700

hi everyone

When I install ECC6.00 sr3 with oracle&HP-UX

I come across an error at the set u201Cimport abapu201D

my oracle version is 10.2.0.4

my HP-UX is 11-23

*********************import monitor log********************

ERROR: 2010-01-22 02:42:37 com.sap.inst.migmon.LoadTask run

Loading of 'DD03L' import package is interrupted with R3load error.

Process '/usr/sap/R3T/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4102 -l DD03L.

log -stop_on_error' exited with return code 9.

For mode details see 'DD03L.log' file.

Standard error output:

/usr/lib/hpux64/dld.so: Unable to find library 'libclntsh.so.10.1'.

*******************************************************************

                                              • 'DD03L.log' ****************************

(DB) ERROR: DDL statement failed

(DROP INDEX "DD03L~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 "DD03L~0" ON "DD03L" ( "TABNAME", "FIELDNAME", "AS4LOCAL",

"AS4VERS", "POSITION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 712194033 NEXT 0

000002560K 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 P015

ORA-01659: unable to allocate MINEXTENTS beyond 28 in tablespace PSAPSR3700

(DB) INFO: disconnected from DB

**********************************************************

********************tablespace view****************

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 20/20

41328640 75.99 9922304 204800000 20008960 93 8192000:8192000:3624960+:1157056:866304

2 - PSAPSR3700 DATA ONLINE LOCAL AUTO NO 21/21

43868160 76.44 10337472 215040000 20008960 44 8151040:8151040:3706880+:2088896:2071488

3 - PSAPSR3USR DATA ONLINE LOCAL AUTO NO 1/1

20480 9.38 18560 10240000 10219520 1 10219520+:18560:0:0:0

4 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 3/1

6144000 0.00 6144000 14336000 8192000 0 8192000+:0:0:0:0

5 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO 3/1

6266880 0.00 6266688 14417920 8151040 4854 8151040+:2083776:2073344:8192:8192

6 - SYSAUX DATA ONLINE LOCAL AUTO NO 1/1

204800 24.72 154176 10240000 10035200 1 10035200+:154176:0:0:0

7 - SYSTEM DATA ONLINE LOCAL MANUAL NO 2/2

1392640 49.76 699712 20480000 19087360 2 9543680:9543680:696256:3456:0

**********************************************************

I do need yours helps

any advise will be much appreciated!

Thanks&Regards

Peter

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question