Skip to Content
0

Issue with phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE during SP upgrade of an ERP system

Oct 26, 2016 at 02:19 PM

51

avatar image

We are upgrading an ERP from SPS 05 to SPS 18. We are facing issue in DBCLONE step during pre-processing phase.

Error message: 1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3701X
1EETGCLN SFW_BFT
1EETGCLN Error copying table data

We have analysed the issue further and found that INITIAL extent for segment in tablespace PSAPSR3701X is set 1 TB.

TABLESPACE_NAME
-------------------------------------------------------------------------------
INITIAL_EXTENT
--------------
PSAPSR3701X
1073741824

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLONING ERRORS and RETURN CODE in DBCLONE02.SID~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 3 ETGCLN CREATE TABLE "SFW_BFT~" ("BFUNCTION" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "SPRAS" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "NAME32" VARCHAR2 (000032) DEFAULT ' ' NOT NULL, "NAME80" VARCHAR2 (000080) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3701X STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01) 3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'SFW_BFT~' AND INDEXNAME = ' ' 3 ETGCLN CREATE UNIQUE INDEX "SFW_BFT^0" ON "SFW_BFT~" ("BFUNCTION", "SPRAS") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3701X STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001) 3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'SFW_BFT~' AND INDEXNAME = '0' 3 ETGCLN insert /*+ APPEND */ into "SFW_BFT~" ( "BFUNCTION", "SPRAS", "NAME32", "NAME80" ) select "BFUNCTION", "SPRAS", "NAME32", "NAME80" from "SFW_BFT" 1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3701X 1EETGCLN SFW_BFT 1EETGCLN Error copying table data 3 ETGCLN CREATE TABLE "SFW_BF_DEPEND~" ("BFUNCTION" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "VERSION" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "DEPTYPE" VARCHAR2 (000001) DEFAULT ' ' NOT NULL, "BFUNCTION2" VARCHAR2 (000030) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3701X STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01) 3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'SFW_BF_DEPEND~' AND INDEXNAME = ' ' 3 ETGCLN CREATE UNIQUE INDEX "SFW_BF_DEPEND^0" ON "SFW_BF_DEPEND~" ("BFUNCTION", "VERSION", "DEPTYPE", "BFUNCTION2") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3701X STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001) 3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'SFW_BF_DEPEND~' AND INDEXNAME = '0' 3 ETGCLN insert /*+ APPEND */ into "SFW_BF_DEPEND~" ( "BFUNCTION", "VERSION", "DEPTYPE", "BFUNCTION2" ) select "BFUNCTION", "VERSION", "DEPTYPE", "BFUNCTION2" from "SFW_BF_DEPEND" 1EETGCLN ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3701X 1EETGCLN SFW_BF_DEPEND 1EETGCLN Error copying table data

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers