Re: Roll Back Segs

From the doc:

Cause: Failure occurred when trying to extend rollback segment Action: This is normally followed by another error message that caused

       the failure. You may take the rollback segment offline to perform
       maintainence. Use the alter rollback segment offline command
       to take the rollback segment offline.

----------------

You may not have enough space in your tablespace to extend the rollback segment
--> make the tablespace bigger
or
You may have reached maxextents for the rollback segment --> alter rollback segment storage ...

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"rc" <rc_at_spam.com> a écrit dans le message de
news:prcaf0t2ni43fqvsttdvfsu8l8tbifkd0m_at_4ax.com...


> Hi

>

> We use Oracle 8.1.7.4 on Solaris 8

> On a very larger insert operation I got

> ora-01562, which is to do with roll back segment size

>

> I have 8 20Mb roll back segs on 2GB of tablespace.

>

> Does the above erro mean that a single Roll back segment tried to

> extend beyond the size of the tablespace ?

>

> And, do I get round this by having a very large temp tablespace

>

> Thanks

>

>