Home » RDBMS Server » Server Administration » Materialized View Question
Materialized View Question [message #180606] Tue, 04 July 2006 07:21 Go to next message
marrec
Messages: 35
Registered: May 2005
Location: Mühlheim, Germany
Member
hi there,

i'm running an oracle enterprise 9.206 rdbms.

because of company-rules i must use schema1 for all-Tables and Schema2 for Procs/PKGs/Views etc.
The Problem is a Materialized View. I have to use Schema2 for the mat-View and the refresh-Job and schema1 for the real table.

is there any possibility to do this?

thx and greetz from world-cup-champion2006 germany

Report message to a moderator

Re: Materialized View Question [message #180650 is a reply to message #180606] Tue, 04 July 2006 10:00 Go to previous message
imtj
Messages: 12
Registered: July 2006
Location: Chinese
Junior Member
You can use materialized view refresh Schema2's table to Schema1's table.

Report message to a moderator

Previous Topic: How to move the database
Next Topic: user login not responding
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 15:23:34 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.