July 27th, 2003, 06:01 AM
I am trying to create a view, but I am getting the error:
ORA-04063: "user.view_name" has errors. I believe that this error is caused if the underlying table has been deleted. I have tried to delete/drop view, have even tried to change the name of the view. However, I am still getting the same error.
Could anyone please shed light on this matter? Any help will be greatly appreciated!
Thanks a lot,
July 27th, 2003, 03:57 PM
The error is because you are referencing a non existent table. Verify that all the tables referenced in the view exists.
July 28th, 2003, 08:38 AM
Thanks for your response! The referenced table in the view exists. I have made sure that it's there and have performed a commit.
I think, my previous post is little misleading. Actually, I deleted the table and then recreated it with data in it and performed the commit. I still keep getting the ORA-04063 error..
Last edited by mamtakansal; July 28th, 2003 at 08:44 AM.
July 28th, 2003, 09:29 AM
The problem has been fixed. The error was due to an invalid column name in the select statement.
August 2nd, 2013, 06:51 AM
Could you share the name of the column that was invalid? I'm having the same issue but couldn't find this column yet.
August 2nd, 2013, 02:34 PM
do you honestly think he remembers after ten years???
Originally Posted by mtsrio
here, let me help you...
the name of the column was foo
August 2nd, 2013, 03:22 PM
I saw 2013 instead of 2003!