在同一个实例下面存在多个用户,当这些用户中存在相同名称的表或对象时可能会存在串对象的问题,如用户user_a和user_b都存在一个emp表,当在user_a中执行对emp表操作时有可能会访问到user_b下面的emp表,这一系统的bug在oracle多个版本中出现,下面为已发现的相关bug
Bug号 | 影响版本 | 相关描述 |
11.1.0.7 | PLSQL cursors with user binds may execute in the wrong schema (rare) | |
10.2.0.4 | PL/SQL CURSOR EXECUTES IN WRONG SCHEMA | |
10.2.0.2, 10.2.0.3 | Wrong cursor may be executed if schemas have objects with same names [ID 5686711.8] | |
11.2.0.3 11.2.0.2 | Bug 13080778 - ORA-942 / ORA-1031 / corruption for SQL using same object name in multiple schemas - superseded [ID 13080778.8] | |
Bug:5458753 | 10.2.0.2 | SQL can execute in wrong Schema [ID 392673.1] |
11.2.0.2 11.2.0.1 , 11.1.0.7 , 10.2.0.5 | Wrong child cursor may be executed - SQL executes in a wrong schema | |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21605631/viewspace-757259/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21605631/viewspace-757259/