Database DataWarehousing (MOSC)

MOSC Banner

Where does the domain name come from when creating mv in remote db?

edited Mar 8, 2012 7:00PM in Database DataWarehousing (MOSC) 3 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center