RE: truncate ORA-01552

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 5 Dec 2005 18:33:24 +0100
Message-ID: <003101c5f9c1$ff146c20$6401a8c0@LAPTOPLEX>

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

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

Received on Mon Dec 05 2005 - 12:59:37 CST