RE: truncate ORA-01552

Yes.
 
Thanks,
Jon Knight
 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Lex de Haan
Sent: Lunes, 05 de Diciembre de 2005 11:33 a.m.
To: jknight@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Knight, Jon
Sent: Monday, December 05, 2005 16:46
To: oracle-l@xxxxxxxxxxxxx
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.

Other related posts: