Tuesday, March 12, 2013

DBA_DIRECTORIES v/s UTL_FILE_DIR

Prior to 10g (I think this did not work in 9i!!) if a file had to be created using a pl/sql code the DBA had to enter create the directory, register the path in the init.ora file against the utl_file_dir parameter and bounce the database....DOWNTIME!!!.
10g Onwards this is not required with the use of the dba_directories table. A directory is created on the operating system and by using the "CREATE DIRECTORY" command register the path in the dba_directories table.


Exmaple:
CREATE DIRECTORY xyz AS '/u01/oracle/xyz';
Hope this helps! 

No comments: