view compilation error questions
When I create a view and there is an error, the view code won't be stored in the data dictionary unless you use the force option. I also noticed that when you create a view without the force option and it errors out the error is displayed unlike procedure, functions, etc where it will just tell you that a compilation error has occured but the code will still be stored in the db, but you can do a show error or select from the user_errors view to see the error. It seems that with views oracle will prevent it from