-
I have one 7.3.4.5 database (Master) and four 8.0.5 databases( Chlidren). I am planning to Migrate Master(7.3.4.5) to 8.1.7.3. All chlid databases have snaphots pointing to Master database. So when I migrate Master to 8.1.7.3, do I need to rebuild the snapshots in chlidren (7.3.4.5). Also please suggest, do I need to upgrade all chlid databases to 8.1.7.3 ( not necessary though). I just want to know Forum opinion. Please advise.
Thanks
-
"As soon as questions of will or decision or reason or choice of action arise, human science is at a loss."
-- Noam Chomsky (b. 1928), American linguist, writer, author
yodaDBA@hotmail.com
-
Hi,
I dont think so that yo have to migrate your children databases to 8.1.7.3 since Snapshots will work as they are working in current version.Only in Orcle 7.2 snapshots should be created with rowid as it is not allowed to create snapshots in primary key.In case of any help please be free to contact me.
Regards,
Rohit Nirkhe,Oracle DBA/Apps DBA,OCP 8i
oracle-support@indiatimes.com
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
|