1 Reply Latest reply on Mar 9, 2012 12:04 PM by Lennert_bruin

    from where comes the domain name when creating mv?

      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;

      :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,