IFILE

Property	Description
Parameter type	Parameter file
Syntax	IFILE = parameter_file_name
Default value	There is no default value.
Modifiable	No
Range of values	Valid parameter filenames
Basic	No
Real Application Clusters	Multiple instances can have different values.

Use IFILE to embed another parameter file within the current parameter file. For example:

IFILE = COMMON.ORA

You can have up to three levels of nesting. In this example, the file COMMON.ORA could contain a second IFILE parameter for the file COMMON2.ORA, which could contain a third IFILE parameter for the file GCPARMS.ORA. You can also include multiple parameter files in one parameter file by listing IFILE several times with different values:

IFILE = DBPARMS.ORA

IFILE = GCPARMS.ORA

IFILE = LOGPARMS.ORA

Note:

1. You must list multiple entries on contiguous lines of the parameter file.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘IFILE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
ifile		TRUE	FALSE	FALSE	FALSE	FALSE	include file in init.ora

Oracle initializatoin parameters