Invalid Table Name with a View

[David Singleton]

Ladies and gentlemen, I need your assistance please.

I have a rather complex SQL statement (multiple inline views) that I'm encapsulating inside a view. All tables are owned by the same schema.

When connected as the schema owner, the SQL executes flawlessly. After successfully creating the view (owned by the same schema), and query the view, I receive an ORA-00903: INVALID TABLE NAME error.

Any ideas why I might be receiving that error? Could it be the inline views in my SQL? By inline view, I mean like this:

select 1
from ( -- Inline view
select 1
from dual
)

I appreciate any help.

Thanks,
David

[tamilselvan]

Checkup alias given to in-line views.
They may be misspelled.

Tamil