#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    10
    Rep Power
    0

    ORA-04063 error..


    Hello there,

    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,
    Mamta Kansal.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    The error is because you are referencing a non existent table. Verify that all the tables referenced in the view exists.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    10
    Rep Power
    0

    ORA-04063 error..


    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 09:44 AM.
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    10
    Rep Power
    0
    The problem has been fixed. The error was due to an invalid column name in the select statement.
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    2
    Rep Power
    0
    Hello mamtakansal,

    Could you share the name of the column that was invalid? I'm having the same issue but couldn't find this column yet.

    Thanks!
  10. #6
  11. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,262
    Rep Power
    4279
    Originally Posted by mtsrio
    Could you share the name of the column that was invalid?
    do you honestly think he remembers after ten years???

    here, let me help you...

    the name of the column was foo

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    2
    Rep Power
    0
    I saw 2013 instead of 2003!

IMN logo majestic logo threadwatch logo seochat tools logo