R&D in Blogger
Memo for IT tech. IT技術のメモ帳。
Search This Blog
2016/12/26
Delete data by using synonym in Oracle
Code:
DELETE FROM syn_table_name;
Attention
User have delete authority.
Why don't use truncate?
As Synonyms can't be used in drop table/view or truncate table/cluster statements. It will cause ORA-00942: table or view does not exist.
No comments :
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments ( Atom )
No comments :
Post a Comment