init.ora file location.

[Surek]

Hi,
Can anyone tell me the location of init.ora file?

I wanted to take the output of the query into a CSV file.
If i use the spool command, it takes long time since there are large number of records.

So am trying to use the UTL_FILE utility.

Can anyone help me on this?

Thanks.

[amitpatel66]

Hi,
Can anyone tell me the location of init.ora file?

I wanted to take the output of the query into a CSV file.
If i use the spool command, it takes long time since there are large number of records.

So am trying to use the UTL_FILE utility.

Can anyone help me on this?

Thanks.

In order to check the directories that you can use for UTL_FILE operations, you need not go and check for init.ora file. Use the below query that will give the the directories that you can use for UTL_FILE operations:

select value from v$parameter where name = 'utl_file_dir'
 

[Surek]

In order to check the directories that you can use for UTL_FILE operations, you need not go and check for init.ora file. Use the below query that will give the the directories that you can use for UTL_FILE operations:

select value from v$parameter where name = 'utl_file_dir'
 

when i executed the query it tells me that 'Table or view doesnot exist'.
Can you tell me the location where the init.ora file will be placed generally.

[amitpatel66]

when i executed the query it tells me that 'Table or view doesnot exist'.
Can you tell me the location where the init.ora file will be placed generally.

You can find init.ora file under the path:

$ORACLE_HOME/dbs folder.

Well you need to find the path for ORACLE_HOME as it varies based on the installation.

You can probably find it from regedit in case of windows or run the command echo $ORACLE_HOME in case of unix AIX machine