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
BEGIN:VCARD VERSION:2.1 N:de Haan;Lex FN:Lex de Haan ORG:Natural Join B.V. TEL;WORK;VOICE:+31.30.2515022 TEL;HOME;VOICE:+31.30.2518795 TEL;CELL;VOICE:+31.62.2955714 TEL;WORK;FAX:+31.30.2523366 ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 SK=0D=0ANetherlands URL;WORK:http://www.naturaljoin.nl EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx REV:20040224T160439Z END:VCARD