CODEWITHSUNDEEP
oracle-database
SamOl
SamOl

Reputation: 90

Compile view with compilation error, noot show errors command says no errors

I have added to my view one field.

When I compile it with sqlplus I get warnings:

Warning: View created with compilation errors.

Warning: View created with compilation errors.

When I then run show errors it displays:

No errors.

Any idea if I have errors or not?

Upvotes: 0

Views: 18395

Answers (2)

harry2517
harry2517

Reputation: 51

this will help you:

SHOW ERRORS VIEW view_name

or 

SHOW ERRORS VIEW owner.view_name

(if you're not the owner of the view).

Upvotes: 5

SamOl
SamOl

Reputation: 90

Need to be more careful, when add fields to view. Development server has many databases, and if they are not refreshed regularly, then we miss some recent changes, like in my case one database didn't have one field in the table, for underlying view, and I couldn't compile it

Upvotes: 0

Related Questions