on 10-26-2016 3:19 PM
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
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.