Oracle10g – Bug 5458753

I read a post on the Oracle-L yesterday regarding Bug 5458753 where “SQL can execute in wrong Schema”. According to Metalink Note 392673.1, there is a patch currently available for it and the problem should be fixed in 10.2.0.3.

Might not be an issue in most Production environments, but in a shared development environment like ours where developers are using the same object names in different schemas, it could be quite a problem. Imagine issuing a query and getting unexpected results. I mean sometimes you expect the unexpected when developing, but not to this extreme.

Update (23-Oct-2006)
I applied patch 5458753 on Friday (20-Oct-2006) and it appears to have resolved the problem in my 10.2.0.2 installation on Solaris 9 (64-bit).

Update (17-Oct-2006)
I actually reviewed Metalink Note 391116.1. The way I understand it, the problem is expected to be fixed when 10.2.0.3 is released. Guess we’ll have to wait and see for sure.

Update (13-Oct-2006)
An entry on the Pythian Group Blog mentions Bug 5458753 is not in the list of bugs fixed in 10.2.0.3 according to Metalink Note 391116.1.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: