alter system set utl_file_dir='{directory 1}
Example :
alter system set utl_file_dir='/home/oracle/a', '/home/oracle/b' scope=spfile;
Take note that this parameter needs a restart to be effective.
Thursday, October 23, 2008
Oracle : Example to set the utl_file_dir parameter
Syntax :
alter system set utl_file_dir='{directory 1}', '{directory 2}' ... '{directory n}' scope=spfile;
Example :
alter system set utl_file_dir='/home/oracle/a', '/home/oracle/b' scope=spfile;
Take note that this parameter needs a restart to be effective.
alter system set utl_file_dir='{directory 1}
Example :
alter system set utl_file_dir='/home/oracle/a', '/home/oracle/b' scope=spfile;
Take note that this parameter needs a restart to be effective.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment