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

What else can I help you with?

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 do you fix an invalid XML error on Yahoo Mail?

Change to classic yahoo view. This worked for me.


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.


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

Could that be sarcasm? fasicious


How to decompile and recompile C plus plus for free?

Decompile?! There is no such thing.


How can you update your java application?

Do any corrections to the source code; recompile.


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.