Oracle - Explain how to change the definition of a replicated table. posted by
Babu Kunwar
Explain how to change the definition of a replicated table.
-
Connect to the master definition site as the replication administrator.
-
If necessary, then inactivate the master group
-
In a separate SQL*Plus session, check the status of the master group you are
inactivating.
-
Alter the replicated object.
-
Regenerate replication support for the altered object.
-
In a separate SQL*Plus session, check if DBA_REPCATLOG is empty.
-
Resume replication activity.
More links
Overview of PL/SQL Error Handling
Advantages of PL/SQL Exceptions
Explain some of the commonly used Predefined PL/SQL Exceptions.
What is user-defined exception? Explain it with an example.
Explain how PL/SQL exceptions are raised..........
|
