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?
From: email@example.com [mailto:firstname.lastname@example.org]On Behalf Of Niall Litchfield
Sent: Lunes, 05 de Diciembre de 2005 08:11 a.m.
Subject: Re: This shouldn't be this tough...
Won't you get it from the alert.log starting with 10gr1?
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.