RelationalDBDesign
SiteMap
Network Config
Network Admin
Network Topology
Distributed Databases
«Prev
Oracle Network Administration
Oracle Net Features
Net Listener Features
Net Scalability Features
Oracle Partitioned Tables
Net Connectivity Features
Oracle Manageability Features
Oracle Security Features
Net Services Conclusion
Net Services Installation
Net Pre Installation
View Net Assistant
Add Oracle Net Features
Net Listener OEM
NetServices Line Commands
Net Configuration Assistant
Oracle NetManager Conclusion
Net Applications
Using Connection Manager
Net Multiplexing Configuration
Understanding Connection Pooling
Configure Loadbalancing Network
Radius Adapter Purpose
Configure Radius Adapter
Distributed Databases
Distributed Database Server
Oracle Queue Propagation
Using Primary Key Snapshots
Updateable Snapshots
Deferred Constraints
LOG Support Replication
Monitoring Replication Events
Implement Snapshot Security
Instantiating Snapshot Sites Offline
Snapshot Deployment
Distributed Databases
Partitioned Tables
Partitioning Index Organized Tables
Arrange SQL in Order
Partitioning Object Tables
Enabling Row Movement
Enable Row Movement
Manipulating Partitions
Steps to Manipulate Partitions
Exchange Partition with Table
Exchange Table Partition
Partitionwise Queries Joins
Parallel Server
Enable Parallel DML
Offline snapshot instantiation
1) To begin the offline instantiation process, you must first call BEGIN_INSTANTIATION, pending the name and the destination.
2) You use the Oracle export utility to export the desired table.
3) After the export is complete, you call the RESUME_SUBSET_OF_MASTERS procedure to resume replication activities for the master sites
4) Now you transfer the export file from the master definition site to the new master site via FTP
5) Next, you are ready to prepare the new site to import data from your export file. To do this, you log into the remote site and call the BEGIN_LOAD procedure.
6) You now Import the data into the new site, using your export file as input.
7) After you have imported the export file, you call the END_LOAD procedure.
This will prepare the site to resume normal replication
8) The final step is to formally complete the offline instantiation process by calling the END_INSTANTIATION procedure. This will end the offline instantiation and resume normal replication activity at all master sites.