OraFAQ Forum: Server Utilities » How to create dbms

Home » RDBMS Server » Server Utilities » How to create dbms_reputil package in the database? (Oracle 9.2.0.6.0 on Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create dbms_reputil package in the database? [message #436445]

Wed, 23 December 2009 11:24

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

Report message to a moderator

Re: How to create dbms_reputil package in the database? [message #436447 is a reply to message #436445]

Wed, 23 December 2009 11:28

Mahesh Rajendran
Messages: 10708
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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to create dbms_reputil package in the database? [message #436550 is a reply to message #436445]

Thu, 24 December 2009 02:36

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

Report message to a moderator

Previous Topic:	oracle 10g Data pump
Next Topic:	Logical error in Exporting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 04:03:31 CST 2025