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

Thread: tablespace problem

  1. #1
    Join Date
    Jun 2003
    Posts
    108

    tablespace problem

    Hi DBAs,

    I tried to run a big process, but i failed.
    The following error occured.

    unable to extend temp segment by 8091 in tablespace PROCESS01.

    Please give some suggestions to avoid this error.

    Very urgent.

    Thanx in advance.

  2. #2
    Join Date
    Aug 2002
    Posts
    115
    does your tablespace PROCESS1 have maxsize?

    ALTER TABLESPACE PROCESS1 ADD DATAFILE XXXX 100M;

  3. #3
    Join Date
    Jun 2003
    Posts
    108
    I added the datafile earlier but still the error comes

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    Which Oracle version ?
    Check for any hung or active transactions which might have occupied space from v$sort_segment, v$sort_usage.
    Try to coalesce. If no usage and still no free space, try to take it offline and then online again else add more space.
    Last edited by vinit; 01-21-2004 at 03:07 AM.
    Vinit

  5. #5
    Join Date
    Jun 2003
    Posts
    108
    Both tables have no rows.

  6. #6
    Join Date
    Aug 2002
    Posts
    115
    what is the default and temp table space for the user

    ALTER USER
    DEFAULT TABLESPACE
    TEMPORARY TABLESPACE

  7. #7
    Join Date
    Jun 2003
    Posts
    108
    Problem is solved.

    Thanx for ur all info.

  8. #8
    Join Date
    Apr 2003
    Posts
    353
    Is the version before 9i?
    If so use the below option.

    Increase MAXTEXTENTS for Temp tablespace

  9. #9
    Join Date
    Jun 2003
    Posts
    108
    yes engiri...

    It is production DB 8.1.5,, so i increased it and it is ok now.

    Thanx for ur info.

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