The user is "schema2" . I believe it only has select on the views. thank you Gene Gurevich "Andrew Kerber" <andrew.kerber@gm ail.com> To genegurevich@xxxxxxxxxxxx 10/01/2008 09:04 cc AM oracle-l@xxxxxxxxxxxxx Subject Re: ora-4063 What user is executing the batch job, and does it have alter privileges on the views (as in alter view compile?) On Wed, Oct 1, 2008 at 8:56 AM, <genegurevich@xxxxxxxxxxxx> wrote: Hello everybody: I am running oracle 10.2.0.1 In the database schema1 owns several tables and select on these tables is granted to public. Schema2 owns several views using the tables in schema1. Select on these views is also granted to public. And I have a schema3 which runs selects against schema2's views from a Pro*C code. Once every 2 weeks, all objects in schema1 are being dropped and reimported (without structure changes, just with different data). After that all the views in the schema2 become invalid. This does not seem to be an issue because a desc or select command runs successfully and changes the status to valid. This however does not seem to be the case with the Pro*C code which fails consistently with ORA-4063. The command that fails is select col into variable from view . When I run this command manually from SQL> prompt, I have no issues, when it is executed in batch mode from Pro*C script it fails Has anyone seen this issue before and what could be the fix for it? thank you Gene Gurevich -- //www.freelists.org/webpage/oracle-l -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- //www.freelists.org/webpage/oracle-l