Home » Server Options » Replication » Materialized Views
Materialized Views [message #10755] Sun, 15 February 2004 21:43 Go to next message
Mark
Messages: 284
Registered: July 1998
Senior Member
Does anyone know how to get the source code that was used to create a Materialized View from the data dictionary.
Re: Materialized Views [message #10756 is a reply to message #10755] Mon, 16 February 2004 01:10 Go to previous messageGo to next message
Sudhakar
Messages: 34
Registered: May 2002
Member
Hi,

select query from user_snapshots where table_name='xyz'

By using USER_SNAPSHOTS dictionay view we can get the source code that was used to create a Materialized View.

Regadrs,
Sudhakar
Re: Materialized Views [message #10761 is a reply to message #10756] Mon, 16 February 2004 05:08 Go to previous message
Materialized Views
Messages: 1
Registered: February 2004
Junior Member
Cheers...

That was great

Mark
Previous Topic: Materialized View
Next Topic: near real time replication, staging tables
Goto Forum:
  


Current Time: Thu Mar 28 15:28:11 CDT 2024