Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    Cochin, INDIA
    Posts
    9

    Unanswered: TableSpaces and Datafiles

    I am met with the following error while importing data. I want to overcome this by creating my on TableSpace and Data Files. But I am not sure of how to proceeed. Can any of you provide me with a detailed answer to this problem
    Thanking you in advance,
    Saju Joseph

    IMP-00017: following statement failed with ORACLE error 1652:
    "CREATE INDEX "IDX_ALL_EST_CHROM_START_END" ON "ALL_EST" ("CHROM" , "CHROM_S"
    "TART" , "CHROM_END" ) PCTFREE 5 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 14"
    "8480000 NEXT 5120000 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 "
    "FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING"
    IMP-00003: ORACLE error 1652 encountered
    ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

  2. #2
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: TableSpaces and Datafiles

    Originally posted by peruvachira
    I am met with the following error while importing data. I want to overcome this by creating my on TableSpace and Data Files. But I am not sure of how to proceeed. Can any of you provide me with a detailed answer to this problem
    Thanking you in advance,
    Saju Joseph

    IMP-00017: following statement failed with ORACLE error 1652:
    "CREATE INDEX "IDX_ALL_EST_CHROM_START_END" ON "ALL_EST" ("CHROM" , "CHROM_S"
    "TART" , "CHROM_END" ) PCTFREE 5 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 14"
    "8480000 NEXT 5120000 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 "
    "FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING"
    IMP-00003: ORACLE error 1652 encountered
    ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
    Hi Joseph.

    This error means that you have not enough space in the TEMP tablespace to create the temporary informations, that oracle db engines needs meanwhile is computing the index.

    try this :
    ALTER DATABASE TEMPFILE '/...../temp.....dbf' RESIZE 50M;

    or this depending on the release and you TEMP configuration:
    ALTER DATABASE DATA FILE '/...../temp.....dbf' RESIZE 50M;

    If the actual size is bigger than 50M try doubling it, but the problem you are faceing is not due to the create index statement but likely depends on the load.

    greetings from italy.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •