Oracle Database Discussions

Hi,

I have installed Oracle 9i enterprise edition in my local system. (For learning purpose)

Now when I queried V$parameters for value (name= utl_file_dir) it is showing as null.

SELECT value
FROM v$parameter
WHERE name = 'utl_file_dir';

O/p : zero rows selected.

I have updted the init.ora file as below

UTL_FILE_DIR="I:\temp"

After updating the init.ora file I have sutdown the database and started the instance again. But still when I queried v$paramater it is showing as null only.

Any idea, what else I need to change.

Thanks,
Suri