Home » Server Options » Replication » urgent!!! please advice !!! materialized view & user defined data types
urgent!!! please advice !!! materialized view & user defined data types [message #75390] Tue, 12 August 2003 10:39 Go to next message
kshathrya
Messages: 29
Registered: October 2001
Junior Member
i have an issue accessing objects from othe rdatabases through dblink, in cases where the tables have user defined data types;

table1 in db1 has user defined datatype on c1.

if i query from db2, i am able to see the data, but, if i use a materialized view, i get table or view does not exist.

please advice. urgent.
Re: urgent!!! please advice !!! materialized view & user defined data types [message #136736 is a reply to message #75390] Fri, 09 September 2005 14:26 Go to previous message
ja20000
Messages: 3
Registered: August 2005
Location: VA, USA
Junior Member



please check your privileges on the remote database.
Previous Topic: Errors encountered refreshing a single materialized view
Next Topic: Replication between Oracle and DB2 running on different Servers
Goto Forum:
  


Current Time: Thu Mar 28 05:32:13 CDT 2024