This discussion is archived
1 Reply Latest reply: Mar 9, 2012 4:04 AM by 921715 RSS

from where comes the domain name when creating mv?

921715 Newbie
Currently Being Moderated
Hi all,

When I create an MV on a table in another database, the source database shows a domain name in all_registered_mviews that is not the same as on the destination database. Does anyone know where that domain name comes from (and what I need to change to make sure it is registered correcly when creating an mv?). Here is the info I'm looking at:

:source(table) db:
select mview_site from user_registered_mviews;
DB1.REGRESS.RDBMS.DEV.US.ORACLE.COM

:destination(mv) db:
show parameter domain
db_domain string EU.DUMMY.NET

show parameter service
service_names string DB1.EU.DUMMY.NET

SQLNET.ora files on both databases are identical and do not set a default domain.

Thanx in advance,
Lennert

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points