TRUNCATE SYNONYM & ORA-00942
来源:互联网 发布:pc游戏编程 人机博弈 编辑:程序博客网 时间:2024/06/06 14:01
同事可以查询到表中的数据,但truncate这张表的时候抱ORA-00942: 表或视图不存在
开始以为是表名写的有问题,但后来发现他删除的不是表,而是一个同义词(synonym)
对同义词synonym是不能用truncat的。
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as scott
SQL> SELECT COUNT(1) FROM T_EMP;
COUNT(1)
----------
3
SQL> TRUNCATE TABLE T_EMP;S
TRUNCATE TABLE T_EMP
ORA-00942: 表或视图不存在
SQL> SELECT S.OBJECT_NAME,S.OBJECT_TYPE,s.status FROM user_objects s WHERE s.object_name='T_EMP';
OBJECT_NAME OBJECT_TYPE STATUS
-------------------- ------------------- -------
T_EMP SYNONYM VALID
SQL> SELECT dbms_metadata.get_ddl('SYNONYM','T_EMP') TEXT FROM dual;
TEXT
--------------------------------------------------------------------------------
CREATE OR REPLACE SYNONYM "SCOTT"."T_EMP" FOR "SCOTT"."TEST2"
SQL> TRUNCATE TABLE TEST2;
Table truncated
SQL> SELECT COUNT(1) FROM T_EMP;
COUNT(1)
----------
0
SQL>
- TRUNCATE SYNONYM & ORA-00942
- ORA-02069与database link ,synonym,sequence
- synonym
- Synonym
- truncate时报错ORA-02266
- truncate表触发ORA-00600
- ORA-00980: synonym translation is no longer valid", version 9
- truncate table时发生ORA-02266错误
- truncate table时发生ORA-02266错误
- truncate表时报错:ORA-00054
- truncate empty table ora-02266, why? cause
- ORA-00980 同义词转换不再有效(ORA-00980: synonym translation is no longer valid)
- oracle 10g expdp ORA-00980: synonym translation is no longer valid
- truncate
- truncate
- TRUNCATE
- Truncate
- truncate()
- Linux驱动中相关函数查询
- service
- 细数BW开发时的注意点(总结)
- java验证码实例
- struts2标签轻松显示日期
- TRUNCATE SYNONYM & ORA-00942
- 限定缩放范围的窗口
- Android wifi
- spring配置文件
- 备忘--vim常用配置
- 使用微软的 Visual Studio International Pack 1.0 进行网站简体与繁体的互转和得到汉字、拼音、笔画等相关信息
- javascript 命名空间 个人理解心得
- oracle 触发器
- 如何正确看待地方门户网站的品牌推广理念