Home » SQL & PL/SQL » SQL & PL/SQL » ORA-12003 - Error Code
ORA-12003 - Error Code [message #493604] Wed, 09 February 2011 00:36 Go to next message
ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai
Senior Member

I am trying to drop and create some tables in one schema from another schema through procedure.

While running the procedure i got error as

ORA-12003 - Talbe does'nt exist

Guide me to finish this task.
Re: ORA-12003 - Error Code [message #493613 is a reply to message #493604] Wed, 09 February 2011 01:16 Go to previous message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-12003: materialized view "string"."string" does not exist

Cause: The materialized view with the given owner and name does not exist.

Action: Verify inputs and create a materialized view.
Previous Topic: How to find who created the table in oracle
Next Topic: urgent - MV
Goto Forum:
  


Current Time: Fri Apr 19 00:13:36 CDT 2024