Index >
ORACLE Server Parameters >
utl_file_dir
utl_file_dir
Oracle 11.1.0:
Parameter Name: | utl_file_dir
| Description: | utl_file accessible directories list
| Type: | CHAR
| Obsoleted: | FALSE
| Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 10.2.0:
Parameter Name: | utl_file_dir
| Description: | utl_file accessible directories list
| Type: | CHAR
| Obsoleted: | FALSE
| Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 10.1.0:
Parameter Name: | utl_file_dir
| Description: | utl_file accessible directories list
| Type: | CHAR
| Obsoleted: | FALSE
| Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 9.2.0:
Parameter Name: | utl_file_dir
| Description: | utl_file accessible directories list
| Type: | CHAR
| Obsoleted: | FALSE
| Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.1.7:
Parameter Name: | utl_file_dir
| Description: | utl_file accessible directories list
| Type: | CHAR
| Obsoleted: | FALSE
| Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.0.6:
Parameter Name: | utl_file_dir
| Description: | utl_file accessible directories list
| Type: | CHAR
| Obsoleted: | FALSE
| Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 7.3.4:
Parameter Name: | utl_file_dir
| Description: | utl_file accessible directories list
| Type: | CHAR
| Obsoleted: | FALSE
| Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Related Error Messages:
ORA-01308: initialization parameter utl_file_dir is not set
ORA-23502: valid directory for offline instatiation is not specified Cause: An attempt was made to offline instantiate to a directory which is not specified or null.Action: There are two ways to specify the directory: o As a parm offline_dirpath to the API o As an init.ora parm named utl_file_dir Make sure you have specified an appropriate directory in which the offline file can be created.//
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ utl_file_dir ]
on the Oracle FAQ.
|