Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

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
    Cause: utl_file_dir is not set in the initialization file.

    Action: Set utl_file_dir to the appropriate directory.

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.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US