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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Errors encountered refreshing a single materialized view
Next Topic: Replication between Oracle and DB2 running on different Servers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 12 16:44:39 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.