on 06-23-2015 11:27 AM
Hi ,
I am getting the below error during the support pack upgrade using SUM. Please help.
1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3702Xh
Regards,
Prashanth Raja
Hello Prashanth,
You have to extend the tablespace PSAPSR3702Xh and retry the sum. If you still face issue after extend also again you have to extend tablespace and retry the sum till the issue is resolved. I think extending the tablespace is only the solution for this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mahendra,
PFB, for your reference.
3 ETGCLN CREATE TABLE "WDY_VS_PROPERTY~" ("COMPONENT_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "WINDOW_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VSH_NODE_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VERSION" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "VS_PROP_DEF_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "X" NUMBER (000010) DEFAULT 0 NOT NULL, "Y" NUMBER (000010) DEFAULT 0 NOT NULL, "Z" NUMBER (000010) DEFAULT 0 NOT NULL, "PROPERTY_TYPE" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VALUE" VARCHAR2 (000765) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3702X NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WDY_VS_PROPERTY~' AND INDEXNAME = ' '
3 ETGCLN CREATE UNIQUE INDEX "WDY_VS_PROPERTY^0" ON "WDY_VS_PROPERTY~" ("COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3702X NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WDY_VS_PROPERTY~' AND INDEXNAME = '0'
3 ETGCLN insert /*+ APPEND */ into "WDY_VS_PROPERTY~" ( "COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME", "X", "Y", "Z", "PROPERTY_TYPE", "VALUE" ) select "COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME", "X", "Y", "Z", "PROPERTY_TYPE", "VALUE" from "WDY_VS_PROPERTY"
1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3702X
1EETGCLN WDY_VS_PROPERTY
1EETGCLN Error copying table data
Regards,
Prashanth Raja
Hi Mahendra,
I have added another 60 GB and got the same error. PFB, the latest log, Thanks.
3 ETGCLN CREATE TABLE "WDY_VS_PROPERTY~" ("COMPONENT_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "WINDOW_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VSH_NODE_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VERSION" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "VS_PROP_DEF_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "X" NUMBER (000010) DEFAULT 0 NOT NULL, "Y" NUMBER (000010) DEFAULT 0 NOT NULL, "Z" NUMBER (000010) DEFAULT 0 NOT NULL, "PROPERTY_TYPE" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VALUE" VARCHAR2 (000765) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3702X NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WDY_VS_PROPERTY~' AND INDEXNAME = ' '
3 ETGCLN CREATE UNIQUE INDEX "WDY_VS_PROPERTY^0" ON "WDY_VS_PROPERTY~" ("COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3702X NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'WDY_VS_PROPERTY~' AND INDEXNAME = '0'
3 ETGCLN insert /*+ APPEND */ into "WDY_VS_PROPERTY~" ( "COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME", "X", "Y", "Z", "PROPERTY_TYPE", "VALUE" ) select "COMPONENT_NAME", "WINDOW_NAME", "VSH_NODE_NAME", "VERSION", "VS_PROP_DEF_NAME", "X", "Y", "Z", "PROPERTY_TYPE", "VALUE" from "WDY_VS_PROPERTY"
1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3702X
1EETGCLN WDY_VS_PROPERTY
1EETGCLN Error copying table data
Regards,
Prashanth Raja
Hi Raja
Could you check this SAP KBA and note
1500199 - Insufficient tablespace to write data.
139078 - ORA-01658 during hierarchy processing in BW
ORA-01658: unable to create INITIAL extent tips
Regards
SS
Hello Prashanth,
Extend the tablespace PSAPSR3702Xh and try to run SUM again. if it does not work then
Please check the output of the following statement:
select tablespace_name, allocation_type from dba_tablespaces where tablespace_name = 'PSAPSR3702Xh';
If the output is "ALLOCATION" column show 'UNIFORM' then please proceed as follows:
- Recreate PSAPSR3702Xh as an LMTS tablespace with the allocation_type auto. Please refer to os note #214995 regarding LMTS;
- Reorganize PSAPSR3702Xh as per oss note #646681.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
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.