ORA-01652 unable to extend temp segment by num in tablespace name 
Author Message
 ORA-01652 unable to extend temp segment by num in tablespace name

I have a developer that received this error when executing a query.
The TEMP tablespace was created as a 50 meg file with initial 1M, next
1M, minextents 1 maxextents unlimited pctincrease 0. (Oracle 8.0.5 on
Solaris 2.6)

Upon receving this error I added another 50  meg datafile to this
tablespace but the error persisted.

Here is the query:

SELECT
    ACACCTCATX."ACTIVITY", ACACCTCATX."ACCT_CATEGORY",
ACACCTCATX."ACCT_CAT_CLASS",
    ACLEVEL."POSTING_FLAG",
    ACACCTCLSS."DESCRIPTION",
    ACACTIVITY."ACTIVITY", ACACTIVITY."DESCRIPTION",
    ACBUDDTLX."FISCAL_YEAR", ACBUDDTLX."PERIOD", ACBUDDTLX."AMOUNT",
    ACTRANS."TRAN_AMOUNT", ACTRANS."PERIOD", ACTRANS."FISCAL_YEAR"
FROM
    "LAWDEV"."ACACCTCATX" ACACCTCATX,
    "LAWDEV"."ACLEVEL" ACLEVEL,
    "LAWDEV"."ACACCTCLSS" ACACCTCLSS,
    "LAWDEV"."ACMASTERX" ACMASTERX,
    "LAWDEV"."ACACTIVITY" ACACTIVITY,
    "LAWDEV"."ACBUDDTLX" ACBUDDTLX,
    "LAWDEV"."ACTRANS" ACTRANS
WHERE
    ACACCTCATX."ACTIVITY_GRP" = ACLEVEL."ACTIVITY_GRP" AND
    ACACCTCATX."ACTIVITY" = ACLEVEL."ACTIVITY" AND
    ACACCTCATX."ACCT_CAT_CLASS" = ACACCTCLSS."ACCT_CAT_CLASS" AND
    ACACCTCATX."ACTIVITY" = ACMASTERX."ACTIVITY" AND
    ACACCTCATX."ACCT_CATEGORY" = ACMASTERX."ACCT_CATEGORY" AND
    ACACCTCATX."ACTIVITY" = ACACTIVITY."ACTIVITY" AND
    ACMASTERX."ACTIVITY" = ACBUDDTLX."ACTIVITY" AND
    ACMASTERX."ACCT_CATEGORY" = ACBUDDTLX."ACCT_CATEGORY" AND
    ACMASTERX."ACTIVITY" = ACTRANS."ACTIVITY" AND
    ACMASTERX."ACCT_CATEGORY" = ACTRANS."ACCT_CATEGORY" AND
    ACLEVEL."POSTING_FLAG" = 'P' AND
    ACTRANS."FISCAL_YEAR" = 1999. AND
    ACBUDDTLX."PERIOD" >= 1. AND
    ACBUDDTLX."PERIOD" <= 10. AND
    ACACCTCATX."ACTIVITY" = '01995-01-01'
   ORDER BY
    ACACCTCATX."ACCT_CAT_CLASS" ASC,
    ACACCTCLSS."DESCRIPTION" ASC

However, if I change the last few lines as follows, it works:

    ACLEVEL."POSTING_FLAG" = 'P' AND
    ACTRANS."FISCAL_YEAR" = 1999. AND
    ACBUDDTLX."PERIOD" >= 1. AND
    ACBUDDTLX."PERIOD" <= 10. AND
    (ACACCTCATX."ACTIVITY" = '01995-01-01' OR
    ACACCTCATX."ACTIVITY" = '01596-19-05')
ORDER BY
    ACACCTCATX."ACCT_CAT_CLASS" ASC,
    ACACCTCLSS."DESCRIPTION" ASC

Any help is grealt appreciated,

Thanks,
Chuck



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

2. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

3. ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

4. ORA-01652: unable to extend temp segment by 1598 in tablespace

5. ORA-01652: unable to extend temp segment by 1598 in tablespace

6. 01652: unable to extend temp segment

7. extend temp segment - ora 01652

8. ORA-1652: unable to extend temp segment by 7680 in tablespace

9. ORA-1652: unable to extend temp segment by 8192 in tablespace

10. TEMP tablespace, resizing (ORA-01652)

11. ORA-1652: unable to extend temp segment

12. rebuild tablespace HELP ORA 01652


 
Powered by phpBB® Forum Software