Xref: alice comp.databases.oracle.server:19887
Message-ID: <354571C2.2D50BF36@csu.edu.au>
Date: Tue, 28 Apr 1998 16:05:54 +1000
From: Steve Vella <svella@csu.edu.au>
Organization: Charles Sturt University
X-Mailer: Mozilla 4.05 [en] (WinNT; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Help with TRUNCATE command
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 21
Path: alice!news-feed.fnsi.net!news.idt.net!nntprelay.mathworks.com!sunqbc.risq.qc.ca!news.uow.edu.au!metro!tanias.syd.csu.edu.au!svella.riv.csu.edu.au

Can someone help.

When using the TRUNCATE command on a 7.2.3.0.0 database I get the
following error.

SQL> truncate table concept.pegltran_work;
truncate table schema.table_name
                       *
ERROR at line 1:
ORA-01031: insufficient privileges

The DBA's have granted "DELETE ANY TABLE" access to the user account but
it is not working.  The database is not in the Trusted Oracle 7 in DBMS
MAC mode.  Can anyone who has come across this before please let me know
how to fix this ?

Thanks in advance

Steve Vella
svella@csu.edu.au