answersLogoWhite

0


Best Answer

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

13y ago
This answer is:
User Avatar

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
Related questions

What is the definition of view oracle database?

I want to know how the view is working in oracle?


How many types of view in oracle?

There are two types of views in Oracle based upon from how many tables data are being fetched. 1. Simple view - In this view, data is coming from only one table. 2. Complex view - In this view, data comes from more than one table. That's it. However, Complex views have some limitations. For these follow Oracle documentation.


How do you update assembly in net without recompile?

I'm not sure what you are asking about... But the point is if you have changed your project you much recompile.


What is basic command of oracle?

SELECT, overall, I would view as most important.


How do you view users permissions in oracle database via sql query?

ask the DBA


What is a snapshot IN DBMS?

A DBMS snapshot in Oracle can also be referred to as a materialized view. Basically a snapshot is a refreshable view that can be refreshed on command or commit.


How to determine the date of record insertion in oracle table?

I know SCN_TO_TIMESTAMP(ora_rowscn). But In my case it gives invalid scn number exception. Let me know the other way.


How do you fix an invalid XML error on Yahoo Mail?

Change to classic yahoo view. This worked for me.


What is complex view in oracle?

Where it's not simply limiting the columns or rows from a single table. A complex view would summarize/roll-up values in a table or join multiple tables together into the view.


How can you update your java application?

Do any corrections to the source code; recompile.


How to decompile and recompile C plus plus for free?

Decompile?! There is no such thing.


What word means 'taking an opposite point of view to the extreme case to prove that it is invalid?

Could that be sarcasm? fasicious