OraFAQ Forum: Replication » urgent!!! please advice !!! materialized view & user defined data types

Home » Server Options » Replication » urgent!!! please advice !!! materialized view & user defined data types

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

urgent!!! please advice !!! materialized view & user defined data types [message #75390]

Tue, 12 August 2003 10:39

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