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.

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 13:32:37 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.