Have you had sporadic problems with sql statements firing at the wrong schema and can’t work out why? Well you may be a victim of an ongoing Oracle bug. This bug has been around since 9i and is documented under Note: 392673.1. Under certain circumstances an insert or select will use an old cursor which fires at the wrong schema and object. This will, however, only happen under certain conditions and only if the object is not full qualified. It is fixed in version 11 and patched for 10.2.0.4. Check out this thread for more details.
SQL operation in wrong schema
By Paul Lewin on December 7, 2007 9:15 AM
Categories:
Tags:
Search
About this Entry
This page contains a single entry by Paul Lewin published on December 7, 2007 9:15 AM.
Oracle SQL Quick Reference was the previous entry in this blog.
Differences between Oracle and Ansi Outer-Joins is the next entry in this blog.
Find recent content on the main index or look in the archives to find all content.
Categories
Monthly Archives
- January 2009 (1)
- December 2008 (1)
- November 2008 (1)
- October 2008 (1)
- September 2008 (1)
- July 2008 (1)
- May 2008 (4)
- April 2008 (2)
- March 2008 (2)
- February 2008 (2)
- January 2008 (3)
- December 2007 (2)
- November 2007 (1)
- October 2007 (1)
- September 2007 (1)
- August 2007 (1)
- July 2007 (3)
- February 2007 (2)
- July 2006 (1)
- February 2006 (1)
- September 2005 (5)
- July 2005 (2)
- May 2005 (1)
- January 2005 (1)
- December 2004 (2)
- November 2004 (1)
- October 2004 (1)
- September 2004 (3)
- July 2004 (4)
- June 2004 (5)
- May 2004 (2)
- April 2004 (7)
- March 2004 (7)
- February 2004 (4)
- January 2004 (11)
- December 2003 (3)
- November 2003 (2)