Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Truncate and Synonyms !!
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