Replication of Packages or procedures [message #75007] |
Tue, 06 February 2001 12:45 |
Giuseppe Lottini
Messages: 2 Registered: February 2001
|
Junior Member |
|
|
I tried to replicate several procedures and packages in a master to updateable snapshot environment.
I got no errors but when I try to update and recompile a package, on the replicated site the package remains unchanged. I was not able to find any clear documentation about the package/procedure replication.
Someone can help me????
Many thanks in advance.
lott
----------------------------------------------------------------------
|
|
|
|
Re: Replication of Packages or procedures [message #75023 is a reply to message #75007] |
Wed, 28 February 2001 09:15 |
anjan
Messages: 9 Registered: February 2001
|
Junior Member |
|
|
1.tune the private pl/sql area in the library
cache.
2.see that there are minimum number of reloads in the library cache by >select sum(pins), sum(reloads) from v$librarycache;
3.check your rollback segment size. increase it.
4. try increasing open_cursor in init.ora
5.check the user_objects in the data dictionary.
6. set the following parameter
in init.ora > 07_dictionary_accessibility=true
let me know it works this way or not. also let me know which version of oracle you are working with.
anjan saikia
----------------------------------------------------------------------
|
|
|
Re: Replication of Packages or procedures [message #75094 is a reply to message #75007] |
Thu, 09 August 2001 09:53 |
Tania Chiquiar
Messages: 1 Registered: August 2001
|
Junior Member |
|
|
Hi. In order to packages and procedures replication, you could create a job that executes the following procedure:
DBMS_REPCAT.REFRESH_SNAPSHOT_REPGROUP (
gname => 'YourSnapshotGroup',
refresh_snapshots => TRUE,
refresh_other_objects => TRUE);
In this way, your snapshot group will be refreshed with the data and the most recent version of your packages and procedures. If you just want to refresh just your packages, set refresh_snapshots => FALSE. I hop this suggestion helps.
----------------------------------------------------------------------
|
|
|
|