Whats wrong? (ORA-01466)
Hi all,
I'm new in this community, so please excuse if something is wrong...
We have some problems with our application, which produces sometimes an "ORA-01466: unable to read data - table definition has changed".
I reduced the statements a lot and found out, that the following statements reproduces the error 100%:
---
drop table dummy;
create table dummy (a number);
insert into dummy values (0);
commit;
set transaction read only;
select * from dummy;
---
The 1466 is the result of the select statement. So what is wrong with this? When I put a delay between the set transaction and the select, it works sometimes.
I'm new in this community, so please excuse if something is wrong...
We have some problems with our application, which produces sometimes an "ORA-01466: unable to read data - table definition has changed".
I reduced the statements a lot and found out, that the following statements reproduces the error 100%:
---
drop table dummy;
create table dummy (a number);
insert into dummy values (0);
commit;
set transaction read only;
select * from dummy;
---
The 1466 is the result of the select statement. So what is wrong with this? When I put a delay between the set transaction and the select, it works sometimes.
0