Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Truncate and Synonyms !!

Truncate and Synonyms !!

From: <mhalpeth_at_my-dejanews.com>
Date: Thu, 12 Nov 1998 12:14:25 GMT
Message-ID: <72ejf1$mfq$1@nnrp1.dejanews.com>


Hi all !

Just wondering why cant one use the 'Truncate Table' clause on a Synonym when all other operations like the delete / update et al are possible on the table via the synonym ?? Is it just because the 'Truncate' is a DDL and not a DML ... but then doesnt the commands pointed to the synonyms get translated ultimately to the table (thats what the precomp has to do isnt it ?) !!

Can anybody shine some light on this topic pls,...

Thanks a lot !

Mahesh .

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 12 1998 - 06:14:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US