Oracle A423961 Manual Do Utilizador

☞

5 – 10

Oracle7 Server Getting Started for Windows NT 

To confirm that CATREP ran correctly, run a query on ALL_OBJECTS
where STATUS = ’INVALID’. (ie: SELECT * FROM ALL_OBJECTS
WHERE STATUS = ’INVALID’;)

If you find that any of the package bodies ran incorrectly, rerun them
manually. Here is the syntax for running them manually:

ALTER PACKAGE <package name> COMPILE BODY;

If CATREP.SQL has run successfully, a number of replication tables are
made in the SYSTEM subdirectory. The database is now set up for
Advanced Replication.  Refer to the Oracle7 Server Distributed Systems,
Volume II:  Replicated Data documentation for details on setting up a
Master Definition Site, Master Sites, Updatable Snapshot Sites, and
Conflict Resolution.

   Execute the following statement on the master site

when setting up updatable snapshot sites:

GRANT EXECUTE ON DBMSOBJGWRAPPER TO PUBLIC

The practical limit as to the number of Master Sites an environment may
have is 10. The SNP0 to SNP9 process each handle one destination
master at a time.

If you use the advanced replication option and intend to set up a large
number of replicated objects, monitor the following data dictionary
tables:

•

SOURCE$

•

IDL_UB1$

•

IDL_UB2$

•

I_SOURCE1

•

ARGUMENT$

•

I_ARGUMENT1

•

IDL_SB4$

•

IDL_CHAR$

•

TRIGGER$

If necessary, increase the storage parameters to accommodate the
storage requirements of large numbers of replicated objects.