Home » RDBMS Server » Server Utilities » How to create dbms_reputil package in the database? (Oracle 9.2.0.6.0 on Windows)
How to create dbms_reputil package in the database? [message #436445] Wed, 23 December 2009 11:24 Go to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Hi,

I want create metadata repository for App server(repca) for which I need to have dbms_reputil package installed in the database

I searched in <ORACLE_HOME>\rdbms\admin but could not found it

Do I need to install any particular option on the database so that the package is created in my database?

Thanks and Regards,
Chetana
Re: How to create dbms_reputil package in the database? [message #436447 is a reply to message #436445] Wed, 23 December 2009 11:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you look for $ORACLE_HOME/rdbms/admin/dbmsgen.sql?

[Updated on: Wed, 23 December 2009 11:29]

Report message to a moderator

Re: How to create dbms_reputil package in the database? [message #436448 is a reply to message #436445] Wed, 23 December 2009 11:31 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
rem
rem $Header: dbmsgen.sql 24-may-2001.14:53:16 gviswana Exp $ 
rem
Rem  Copyright (c) 1993, 1996, 1997, 1998 by Oracle Corporation 
Rem    NAME
Rem     dbmsgen.sql - Replication code generators.
Rem          
Rem    DESCRIPTION
Rem     Routines to generate shadow tables, triggers, and packages for
Rem     table replication.
Rem     Routines to generate wrappers for replication of standalone procedure
Rem     invocations, and packaged procedure invocations.
Rem     Routines which support generated replication code.
...
CREATE OR REPLACE PACKAGE dbms_reputil AS  

Regards
Michel
Re: How to create dbms_reputil package in the database? [message #436550 is a reply to message #436445] Thu, 24 December 2009 02:36 Go to previous message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Hello,

Thank you very much

I got it now in <oracle_home>\rdbms\admin only

Not sure how I could not found it earlier

But this time I searched with the file name you mentioned and got it

Thanks and Regards,
Chetana
Previous Topic: oracle 10g Data pump
Next Topic: Logical error in Exporting
Goto Forum:
  


Current Time: Sat Oct 01 05:57:07 CDT 2016

Total time taken to generate the page: 0.05531 seconds