Re: Oracle Dirty Read Question

This is not possible .I tested with database which I use and does'nt allow.
I think in your system ,the autocommit must be on.Set it to off and it will
work they way is should.

Regards,
Venkatesh

In article <33497ABF.166452E5_at_ix.netcom.com>, Vish magapu <magapuv_at_ix.netcom.com> writes:
|> 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.
|>
|> Thanks,
|> Vish
|>
|> --------------------------------------------------------------
|> Name: Vish Magapu
|> E-mail: Vish Magapu <magapu_at_monet.fujitsu.com>
|> Date: 04/07/97
|> Time: 15:44:24
|> --------------------------------------------------------------
|>
Received on Tue Apr 08 1997 - 00:00:00 CDT