How to add a new entry in utl_directory or v$parameter

1. Close down database
2. Open /dbs

3. Open the file init.ora file after taking a backup of this file.
4. Add the new parameter directory under "utl_file_dir" tag.
5. save the file.
6. take a backup of spfile.
7. connect with database as sysdba user.
$ sqlplus / as sysdba
8. Run the following commands ->
SQL> startup pfile=/dbs/initDEMOFFF.ora
SQL> create spfile from pfile='/initDEMOFFF.ora';
File created.
SQL> show parameter utl

No comments :