When Part Of A Read Only Transaction, Query Fails With ORA-01466
(Doc ID 605770.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]Information in this document applies to any platform.
Symptoms
++ Database is freshly installed using the default seed db option
++ The output of query :
SQL> select dbtimezone, sessiontimezone from dual;
returns different timezones
++ In the test case pasted below :
SQL> create table xxx(x varchar2(100));
SQL> insert into xxx values('1000');
SQL> commit;
SQL> set transaction read only;
SQL> select x from xxx;
the statement 'select x from xxx;' will fail with error :
ORA-01466 : unable to read data -- object definition has changed
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |