LogMiner: utl_file_dir
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: LogMiner: utl_file_dir

  1. #1
    Join Date
    Mar 2000
    Location
    Toronto, Ontario, Canada
    Posts
    213
    Hi all,
    I need some suggestions on how to set the utl_dir_file parameter in O9i. I tried to set by 'alter system set...'
    but it returns error
    "ORA-02095: specified initialization parameter cannot be modified"
    Somebody please help me here as i need to practice on LogMiner.

    TIA,
    Regards,
    Vimal Patel
    OCP DBA 7.3, 8, 8i, 9i
    Sun Solaris 8 Sys. Admin.
    A+

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    In 9.2, you can use logical directories if you want to read an OS file. Meaning you don't have to bounce the instance and change UTL_FILE_DIR.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width