RE: truncate ORA-01552

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Mon, 5 Dec 2005 15:36:26 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF38125B@WIN02.hotsos.com>

I think Lex's point is probably that the dictionary tables are enduring quite a bit of activity during your truncate operation, and that it's likely the undo required to preserve those recursive activities that are causing your problem.

Cary Millsap

Hotsos Enterprises, Ltd.

http://www.hotsos.com

Nullius in verba

Hotsos Symposium 2006 / March 5-9 / Dallas

Visit www.hotsos.com for curriculum and schedule details...

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Knight, Jon
Sent: Monday, December 05, 2005 1:10 PM
To: 'lex.de.haan_at_naturaljoin.nl'; oracle-l_at_freelists.org Subject: RE: truncate ORA-01552

Yes.

Thanks,
Jon Knight

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Lex de Haan
Sent: Lunes, 05 de Diciembre de 2005 11:33 a.m. To: jknight_at_concordefs.com; oracle-l_at_freelists.org Subject: RE: truncate ORA-01552

is this from a dictionary managed tablespace, by any chance?

kind regards,

Lex.

Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html <http://www.naturaljoin.nl/events/seminars.html>

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Knight, Jon
Sent: Monday, December 05, 2005 16:46
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

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

Received on Mon Dec 05 2005 - 17:11:09 CST