7 Replies Latest reply on Aug 25, 2009 7:50 AM by NavneetU

    ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128

    KSG
      Hi all,

      Oracle 10g. Linux.

      I'm facing the below error while trying to import a dumpfile

      IMP-00003: ORACLE error 604 encountered
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128 in tablespace SYSTEM
      IMP-00017: following statement failed with ORACLE error 604:
      "CREATE TABLE "EBFA25_RGS_MM0001" ("RECID" VARCHAR2(255), "XMLRECORD" BLOB) "
      " PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELI"
      "STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T24DATAXML" LOGGIN"
      "G NOCOMPRESS LOB ("XMLRECORD") STORE AS "LOB_EBFA25_RGS_MM0001" (TABLESPAC"
      "E "T24DATAXML" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION CACHE STORAGE(IN"
      "ITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"

      Thanks
      KSG
        • 1. Re: ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
          Satish Kandi
          Why are you importing in SYSTEM schema? Shouldn't this be imported in application schema?
          • 2. Re: ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
            VipinK
            don't import into system schema... try to import into another schema with desired privileges.


            for "ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128 in tablespace SYSTEM" : Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated

            or increase space in system tablespace.
            1 person found this helpful
            • 3. Re: ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
              KSG
              Hi Sathish,

              I have imported to application schema only.

              I used the command

              imp tprd/tprd file=schematprd.dmp full=y ignore=y logfile=schimp.log


              Thanks
              KSG
              • 4. Re: ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
                Satish Kandi
                Is your application schema residing in SYSTEM tablespace?

                SQL> select default_tablespace from dba_users where username = 'TPRD';

                Sorry I misread your post.

                Your SYSTEM tablespace is running out of space during this import. You need to either enable the auto-extend for existing files or add a new file to SYSTEM tablespace.

                Edited by: Satish Kandi on Aug 25, 2009 12:14 PM
                1 person found this helpful
                • 5. Re: ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
                  KSG
                  Hi Satish,

                  I imported the dump into my user schema..

                  Now I get the following error

                  IMP-00003: ORACLE error 1659 encountered
                  ORA-01659: unable to allocate MINEXTENTS beyond 56 in tablespace TDATAXML
                  IMP-00017: following statement failed with ORACLE error 1659:
                  "CREATE TABLE "ACFBNK_STMT022" ("RECID" VARCHAR2(255), "XMLRECORD" "SYS"."XM"
                  "LTYPE") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 4294"
                  "967294 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T24DA"
                  "TAXML" LOGGING NOCOMPRESS XMLTYPE "XMLRECORD" STORE AS CLOB "LOB_ACFBNK_STM"
                  "T022" (TABLESPACE "T24DATAXML" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION "
                  "CACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFA"
                  "ULT))"
                  IMP-00003: ORACLE error 1659 encountered
                  ORA-01659: unable to allocate MINEXTENTS beyond 56 in tablespace TDATAXML
                  IMP-00017: following statement failed with ORACLE error 1659:
                  "CREATE TABLE "DEF_DE_O_HA000" ("RECID" VARCHAR2(255), "XMLRECORD" BLOB) PC"
                  "TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 4294967294 FREE"
                  "LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T24DATAXML" LOGG"
                  "ING NOCOMPRESS LOB ("XMLRECORD") STORE AS "LOB_DEF_DE_O_HA000" (TABLESPACE"
                  " "T24DATAXML" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION CACHE STORAGE(INI"
                  "TIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
                  IMP-00003: ORACLE error 1658 encountered
                  ORA-01658: unable to create INITIAL extent for segment in tablespace TDATAXML
                  IMP-00017: following statement failed with ORACLE error 1659:
                  "CREATE TABLE "DMFBNK_CUST001" ("RECID" VARCHAR2(255), "XMLRECORD" "SYS"."XM"
                  "LTYPE") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 1929"
                  "37984 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T24DAT"
                  "AXML" LOGGING NOCOMPRESS XMLTYPE "XMLRECORD" STORE AS CLOB "LOB_DMFBNK_CUST"
                  "001" (TABLESPACE "T24DATAXML" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION C"
                  "ACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
                  "LT))"
                  IMP-00003: ORACLE error 1659 encountered
                  ORA-01659: unable to allocate MINEXTENTS beyond 8 in tablespace TDATAXML
                  IMP-00017: following statement failed with ORACLE error 1659:
                  "CREATE TABLE "DMFBNK_DM_C000" ("RECID" VARCHAR2(255), "XMLRECORD" BLOB) PC"
                  "TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 197132288 FREEL"
                  "ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "T24DATAXML" LOGGI"
                  "NG NOCOMPRESS LOB ("XMLRECORD") STORE AS "LOB_DMFBNK_DM_C000" (TABLESPACE "
                  ""T24DATAXML" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION CACHE STORAGE(INIT"
                  "IAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"

                  Thanks
                  KSG
                  • 6. Re: ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
                    Satish Kandi
                    ORA-01659:     unable to allocate MINEXTENTS beyond string in tablespace string
                    Cause:      Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.
                    Action:      Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with smaller value for MINEXTENTS, NEXT or PCTINCREASE
                    1 person found this helpful
                    • 7. Re: ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
                      NavneetU
                      It seems that value of minextents for your tablespace is set to 56 and tablespace doesnot have sufficient contiguoes space to allocate this much amount of memory in terms of extents. So either you should add a datafile to the tablespace or resize the existing tablespace. You can also try decreasing the value of Minextents for the tablespace if you think that tablespace have sufficient space to accommodate the segments. Better would be to add a file or resize a file.