Oracle Database Discussions

Hi ALL,,,

I refreshed one db from PROD dump.

After that I compiled all Invalid objects .But am unable to compile UTL_FILE PACKAGE BODY

Showing all are invalid.

OBJECT_NAME OBJECT_TYPE OWNER
-------------------- ------------------- ------------------------------
UTL_FILE PACKAGE BODY UTLFILE
UTL_FILE_EX PACKAGE BODY UTLFILE
UTL_FILE_ADMIN PACKAGE BODY UTLFILE

SQL> show parameter utl

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
create_stored_outlines string
utl_file_dir string


Please help me how to compile this.

If I tried to copile manualyy..I am gettimg Error like..PACAGE ALTERED WITH COMPILATION Errors.


Thanks
Manohar.