| materialized view help [message #138315] |
Wed, 21 September 2005 05:23  |
gautamvv
Messages: 254
Registered: June 2005
|
Senior Member |
|
|
I have 2 database servers in the same network say Server A and Server B. I want to Move all the data from one database (server A) to another database (server B) for every specified amount of time. Oracle version is 9i.
i am new to materialized view concept, and i am trying to use it
from whatever i gathered, i did the following:
database in server A...(database name is inmacs)
database in server B...(database name is new)
i granted create materialized view,query rewrite to inmacs
and new.
then i said
create materialized view mv_emp
refresh fast start with sysdate
next sysdate + 1/48
with primary key
as select * from emp;
(as an example) in inmacs..
it is getting created....but i am confused, and i want
to know how to proceed
any help is appreciated.
|
|
|
|
|
|
| Re: materialized view help [message #138400 is a reply to message #138315] |
Wed, 21 September 2005 13:26  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Can consider logical standby database through dataguard, but that may be overkill for your situation. The above question to you is a good one that needs to be answered.
And of course presumably there is a good reason (or a reason out of your control) to have multiple databases instead of one consolidated database in the first place.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
