Oracle Replication Tips by Burleson

Oracle OEM Replication

current time will pass the Next Date.  We will cover monitoring UMVs in the next chapter.

To change the refresh interval or other job properties, select the job and press the Edit button at the bottom of the page.  This will bring up the Edit Job window (Figure 4.22). 

Figure 4.22 The Edit Job Window

Make any necessary changes and select OK.  If OEM will not let you modify a job, it is because you are not logged on as the job’s creator.  Even SYS cannot change a job created by another user.

Now that we have our updatable materialized view replication running, we need to keep it running.  Since background job processes perform this type of replication, there are a number of problems that can stop the replication.  We will cover monitoring UMVs in Chapter 5.

This is an excerpt from Oracle Replication By Rampant TechPress (only $19.95).  You can click here to order a copy and get instant access to the code depot:

http://www.rampant-books.com/book_2003_2_replication.htm

Get a Personal Oracle Replication Mentor

The author is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle replication question. 

You can get me personally, or any Oracle Certified replication DBA with more than 20 years of full-time IT experience.