Home » SQL & PL/SQL » SQL & PL/SQL » Ora error ORA-00932
Ora error ORA-00932 [message #265646] Thu, 06 September 2007 15:42 Go to next message
SamuelJk
Messages: 15
Registered: August 2007
Junior Member
Hi ,
while executing the following snapshot script i am getting error.

ORA-00932: inconsistent datatypes: expected got
ORA-02063: preceding line from DBLINK

Snapshot script
---------------

CREATE SNAPSHOT test_v
BUILD IMMEDIATE
REFRESH ON DEMAND
WITH ROWID
AS
SELECT * from test_owner.code_v@test_DBLINK.WORLD
/

if I run sql query i am not getting any error.
SELECT * from test_owner.code_v@test_DBLINK.WORLD

Please provide your suggession

Thanks
Samuel.
Re: Ora error ORA-00932 [message #265684 is a reply to message #265646] Fri, 07 September 2007 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
desc test_owner.code_v@test_DBLINK.WORLD

Check if you don't have any datatype that is not supported by mview.

Regards
Michel
Re: Ora error ORA-00932 [message #265823 is a reply to message #265646] Fri, 07 September 2007 09:04 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
What are the Oracle version to FOUR decimal places of both the local & remote databases?
Previous Topic: Dense Rank - help needed
Next Topic: Can I create user defined TYPE from another schema?
Goto Forum:
  


Current Time: Sun Dec 04 13:07:46 CST 2016

Total time taken to generate the page: 0.08487 seconds