OraFAQ Forum: Server Administration » Recreating UTL

Home » RDBMS Server » Server Administration » Recreating UTL_FILE Package Body

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

Recreating UTL_FILE Package Body [message #177490]

Thu, 15 June 2006 00:15

ptgeorge
Messages: 19
Registered: April 2005

Junior Member

I'm having problems using UTL_FILE. The error message that comes up says that the package body is not found.

ORACLE_HOME/rdbms/admin/ultfile.sql only contains package definition and creation of a synonym. How does one recreate the UTL_FILE package body. From what I understand, it is a pre-built package that gets set up during oracle installation.

Oracle version I'm using is 9.2.0.6.0 on AIX, if required. Though I know that it works on similar setups

Is there a way to recreate this package body ?

Report message to a moderator

Re: Recreating UTL_FILE Package Body [message #177495 is a reply to message #177490]

Thu, 15 June 2006 00:49

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

It's in ?/rdbms/admin/prvtfile.plb:

$ grep -i 'package body utl_file' *
prvtfile.plb:CREATE OR REPLACE PACKAGE BODY utl_file wrapped

Report message to a moderator

Re: Recreating UTL_FILE Package Body [message #177504 is a reply to message #177495]

Thu, 15 June 2006 02:43

ptgeorge
Messages: 19
Registered: April 2005

Junior Member

Thanks a lot. prvtfile.plb is a zero-byte file on this machine. Will try to copy from elsewhere and rerun catpatch.sql

Report message to a moderator

Previous Topic:	Recovery prvtutil.plb
Next Topic:	Cloning of database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:36:09 CDT 2024