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

Thread: error message

  1. 02-05-2002, 11:42 AM #1
    UKDBA
    UKDBA is offline Member
    Join Date
    Jun 2001
    Posts
    150
    Hi
    I saw this error in alert.log when trying to rebuild materialised view
    ORA-1652: unable to extend temp segment by 19200 in tablespace MATVIEWS_IDX

    This tablespace is not temorary but why it has been used to create temporary segments. Is it in the process of creating materialised view that it generates temp segment within tablespace
    thanks
    UKDBA
    Reply With Quote Reply With Quote
  2. 02-05-2002, 11:46 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You just don't have enough space in MATVIEWS_IDX.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 02-05-2002, 01:52 PM #3
    UKDBA
    UKDBA is offline Member
    Join Date
    Jun 2001
    Posts
    150
    This is the answer i got from a friend
    When you create a segment in Oracle, the first thing it does is creating one of type "TEMPORARY" while the object is being built. Once the object built, the segment_type becomes the type of the object created (i.e. TABLE or INDEX) and the segment_name is changed to the object type you created (during creation it is some name like 20.2.5). THis error generally means you don't have enough free space in your tablespace to create the object (beyond the initial extent).


    UKDBA
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width