answersLogoWhite

0

To get the answer to this run the following:

You have invoked the following:

alter <view_name> compile;

or

create or replace view <view_name> as .......<view definition>

When you did one of the above you got the "failed to compile" error, this is when you run this:

show errors

Each case is different, running 'show errors' will tell you what the problem is specific to each one.

User Avatar

Wiki User

14y ago

Still curious? Ask our experts.

Chat with our AI personalities

BeauBeau
You're doing better than you think!
Chat with Beau
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga

Add your answer:

Earn +20 pts
Q: Why an invalid view does not recompile in oracle?
Write your answer...
Submit
Still have questions?
magnify glass
imp