Re: Oracle Dirty Read Question

Vish magapu wrote:
>
> According to Oracle manuals (for Ver 7.1) Oracle Never does a "dirty
> read". That means (as I understand) if somebody wites the data but has
> not committed, others users will not be able to see it. But suppose I
> executed the following sequence of statements:
> login as scott/tiger
> create table test (col1 varchar2(1));
> -- Grant select to someuser on test
> insert into test vlaues('X');
> -- But I do not commit;
> login as someuser;
> select * from test;
> -- I get one row which is 'X'
> If Oracle does not do dirty reads how this is possible. Am I
> mis-understanding the concept.
> Please help.

You understanding is perfect. Four possible reason :

1. You are doing the two things in same sql*plus session. If you login one user insert one row. Without issue commit, you logout normally (when you do another login) The updates are commited automatically.
2. You login into another user also have the table test with a record X.
3. Improper setup of database (not likely), setup again.
4. Oracle Bug. (not likely) Make sure you applied all patches needed.