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

Thread: UNDO TBS Error

  1. 07-15-2004, 08:57 AM #1
    vr76413
    vr76413 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    284

    UNDO TBS Error

    hello all...

    ORacle901

    our developers are trying to do some inserts and they are getting the following msg:

    ORA-30036 unable to extend segment by 1024 in undo tablespace 'UNDOTBS'

    my undo is in automatic mode...why am i getting this message ?...how i can i fix it ?...

    any help is appreciated..

    Ron
    Reply With Quote Reply With Quote
  2. 07-15-2004, 09:02 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Are you running out of space in UNDO tablespace ??
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  3. 07-15-2004, 09:27 AM #3
    vr76413
    vr76413 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    284
    no..i allocated 610mb and it has used 15mb. that is what i see on OEM.


    Thanks
    ron
    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