This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex
This is an Interview Question By BMC Software.. " while installing the Oracle 9i ( 9.2) version, automatically system takes the space of approximately 4 GB.. thats fine.... Now, if my database is
Latest Answer : better make the autoextend off and add more datafiles to the tablespace. Making a single datafile to a bigger size is risky...By making autoextend off you can monitor the growth of the tablespace....schedule a growth monitoring script with a threshhold ...
What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?
Explain how will you setup Replication Server & sync it?
Latest Answer : Replication server can be setup using many ways1)Using Oracle Streams2)Using Advanced replication 3)Using Mviews.Each has their own mechanism to sync data. Regards,Vijay Kaushik ...