Home » SQL & PL/SQL » SQL & PL/SQL » Reg: Materialized view logs (Oracle 9i)
Reg: Materialized view logs [message #323683] Thu, 29 May 2008 04:08 Go to next message
vasantha17
Messages: 10
Registered: April 2008
Location: Hyderabad
Junior Member
Hi,

I am having an issue on the creation of mview logs.

I have created base tables in remote database(i.e server1) and created fast refresh mviews in another database ( i.e server2) based on the tables which were existed on remote server(server1).

Now I have to create mview logs for fast refresh and I am not sure where I have to create mview logs at the base table database (server1) or on server2.

Please help me in this.

Thanks,
Vasantha
Re: Reg: Materialized view logs [message #323685 is a reply to message #323683] Thu, 29 May 2008 04:14 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CREATE MATERIALIZED VIEW LOG
Quote:
A materialized view log is located in the master database in the same schema as the master table.

Regards
Michel

[Updated on: Thu, 29 May 2008 04:16]

Report message to a moderator

Previous Topic: BULK COLLECT problem
Next Topic: External Table
Goto Forum:
  


Current Time: Sat Dec 03 14:13:15 CST 2016

Total time taken to generate the page: 0.09736 seconds