-
Logical Standby Database query
Hi
Can the logical standby database created using Oracle9i Data Guard be opened in a read write mode? i.e Can I create new objects in it other than the replicated ones?
regards
nik
-
Indeed Yes
The existing objects (from the primary) remain read-only. The new objects are read-write. ie. u can create a new index on a table that is replicated from the primary. This is one strategy for DSS.
-
Originally posted by gopi
Indeed Yes
The existing objects (from the primary) remain read-only. The new objects are read-write. ie. u can create a new index on a table that is replicated from the primary. This is one strategy for DSS.
Thanx a lot gopi this was exactly my requirement.
regards
nik
-
Originally posted by nik_flash
Thanx a lot gopi this was exactly my requirement.
Is this method of replication being used in Production system anyone?....or its a kinda Prototype. Please let me know if anyone of you has used this Logical Standby method of replication successfully.
regards
nik
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|