Re: Truncate problem

From: Jonathan G Gennick <jgennick_at_kpmg.com>
Date: 1997/04/02
Message-ID: <3343c624.870561@news.kweb.us.kpmg.com>#1/1

"Steve Main" <smain_at_cnw.com> wrote:

>
>truncate table synstores; Fails with table or view does not exist
>
>truncate table owner1.stores OK
>

I took a look in the Oracle7 Server SQL Language Reference Manual for version 7.1, and it gives this specific list of DDL commands that recognize synonyms:

	audit
	noaudit
	grant
	revoke
	comment

Truncate is not in the list and I believe it is considered to be DDL not DML. In fact yes it is. I just checked. See page 4-397 under usage notes.

regards,

Jonathan Received on Wed Apr 02 1997 - 00:00:00 CST