Database Administration (MOSC)

MOSC Banner

view compilation error questions

edited Mar 4, 2015 10:11AM in Database Administration (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center