RE: truncate ORA-01552

Truncate is a data dictionary update. The truncate translates into recursive SQL that does updates to various data dictionary base tables, such as superobj$, tab$, seg$, obj$ and tsq$. Each of those DMLs must write redo AND undo.  

-Mark

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Knight, Jon
Sent: Monday, December 05, 2005 10:46 AM To: oracle-l_at_freelists.org
Subject: truncate ORA-01552

All,

  When trying to "truncate <table_name>", I'm getting the following:  

  ORA-01552: cannot use system rollback segment for non-system tablespace 'AMA30_DATA'  

  Since truncate can't be rolled back, why is this a problem?  

Thanks,
Jon Knight  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Niall Litchfield
Sent: Lunes, 05 de Diciembre de 2005 08:11 a.m. To: bbellows_at_usg.com
Cc: oracle-l_at_freelists.org
Subject: Re: This shouldn't be this tough...  

Won't you get it from the alert.log starting with 10gr1?

On 12/2/05, oracle-l-bounce_at_freelists.org < oracle-l-bounce_at_freelists.org> wrote:

Hello Friends!

We just went to OEM v10.2 and for the life of me, I can't see how to set an alert for when the archive log destination reaches a x% full. Anyone? Anyone? Bueller?

TIA,
Bambi.

--
http://www.freelists.org/webpage/oracle-l






-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com 

________________________________

The information in this message may be proprietary and/or confidential,
and protected from disclosure. If the reader of this message is not
the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify First Data immediately by
replying to this message and deleting it from your computer. 


--
http://www.freelists.org/webpage/oracle-l