AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Answer Library  · Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Suchitra Joshi
Expertise
I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience
15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

 
   

You are here:  Experts > Computing/Technology > Oracle > Oracle > About Advanced Replication (Updatable MView) and recovery of System datafile

Oracle - About Advanced Replication (Updatable MView) and recovery of System datafile


Expert: Suchitra Joshi - 10/7/2009

Question
Hi Suchitra,
This is Mahesh, DBA - Reflexis Systems India Pvt. Ltd. from Pune(M.H), India

1. I want to Set an Advanced replication, using Updatable materialized view. Can you please guide me regarding the same using your Instructions and steps (Example as well for the Syntax) if possible.

2. Is there any way to recover and start up tha database if out System datafile is corrupted or deleted when we don't have any bachup of that even our DB is in NoArchive mode.
If there is any, please come up with the steps and syntaxes

Answer
Hi Mahesh,

Both of these are DBA questions and I think these can be answered properly by some expert DBAs. I have no experience in Advance replication.

Here are some links which may help you -

1) http://www.orafaq.com/wiki/Advanced_Replication_FAQ
2) http://youngcow.net/doc/oracle10g/server.102/b14227/rarrepsite.htm

Hope this helps.

Regards

Suchitra

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.