Robert Geier wrote:Yes, all the views can be described. Yes, user owns the views
can you describe the view ? Is the select being executed by the same user that owns the view ?
Robert Geier wrote:Thank you, I will check the block corruption as suggested
Can you post the create view statement.
Do you have any special features enabled on your database like VPD, Database Vault etc ?
Jan-Marten Spit wrote:Yes, when log in as SYS, still the same thing happens
"select * from VIEW1 failed
select * from VIEW1 where 1 = 1 works"
so does it also fail when you run this as SYSTEM and SYS?