469,293 Members | 1,364 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,293 developers. It's quick & easy.

init.ora file location.

10
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.
Oct 18 '07 #1
3 28163
amitpatel66
2,367 Expert 2GB
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:

Expand|Select|Wrap|Line Numbers
  1. select value from v$parameter where name = 'utl_file_dir'
  2.  
Oct 18 '07 #2
Surek
10
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:

Expand|Select|Wrap|Line Numbers
  1. select value from v$parameter where name = 'utl_file_dir'
  2.  

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.
Oct 18 '07 #3
amitpatel66
2,367 Expert 2GB
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
Oct 18 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Ping | last post: by
2 posts views Thread by FC | last post: by
9 posts views Thread by J.Marsch | last post: by
10 posts views Thread by Wylbur via DotNetMonster.com | last post: by
6 posts views Thread by Troels Arvin | last post: by
2 posts views Thread by Christof Warlich | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.