DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-01652: unable to extend temp segment by 128 in tablespace TS_LCT_TMP

  1. #1
    Join Date
    Nov 2002
    Location
    hydreabad
    Posts
    34

    Thumbs up ORA-01652: unable to extend temp segment by 128 in tablespace TS_LCT_TMP

    Hi,
    I have the dtabase in oracle 9i running windowsxp.
    I have the space in D reive has 40 GB. Oracke Installed in Cdrive which is also 40GB.
    I have most of the tables have the clob columns
    I create the temp Table space like below
    CREATE
    TEMPORARY TABLESPACE TS_NMT_TMP TEMPFILE
    'D:\ORACLE\ORADATA\LCT\TS_NMT_TMP.ora' SIZE 400M AUTOEXTEND
    ON NEXT 512K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
    UNIFORM SIZE 10M

    So I have one opration called UPdate All. It updates the 4000 clobs. each clob updated and comiited for each clob. first i will get the clob and update the clob and do commit.
    after some time i am getting the exceprtion ORA-01652: unable to extend temp segment by 128 in tablespace TS_LCT_TMP

    I look at the temp file size is 4GB. here in d drivre has 20GB free space and temp file has auto extend on still is giving the unable to extend the exception.

    Why the temp file is growing the like that ??? and why it is not flush by oracle server even it is full?

    pl give me advice???

    Thanks & Regards
    Venkata Vara Prasad Kosaraju
    Venkata vara Prasad Kosaraju

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    its not the temp tablespace, it is tablespace TS_LCT_TMP which needs to be bigger

  3. #3
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    and windows has limit on size of file,create more dbfiles on tablespace.

    I dont know what xp's limit is
    Able was I ere I saw Elba

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    It's not the version of Windows, but the type of file system. W2K and XP can use NTFS.

    http://www.microsoft.com/resources/d...c_fil_tdrn.asp

Posting Permissions

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


Click Here to Expand Forum to Full Width