RE: truncate ORA-01552

From: Knight, Jon <jknight_at_concordefs.com>
Date: Mon, 5 Dec 2005 13:10:25 -0600
Message-ID: <17ECCBDCF27C544583F2CAD928F953260221FD68@memex1.corp.cefs.int>

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 - 15:14:48 CST