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.
OCP DBA 7.3, 8, 8i, 9i
Sun Solaris 8 Sys. Admin.
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
Click Here to Expand Forum to Full Width