Re: file text

Sorry for my not so clear previous answer. Here's a complement (embedded).

Sandy <daleelaNOdaSPAM_at_usa.net.invalid> a écrit dans le message : 0a7653bd.34870473_at_usw-ex0110-076.remarq.com...
> Hello Michel,
>
>
>
> Thanks for your answer.
> But I still have questions because I am kinda new in
> oracle.
> 1)Does the utl_file package belongs to the user sys ???

Yes.
Sys have to grant the execute privilege to the owner of your procedure.

> 2)After I add add a parameter to your init.ora file:
> utl_file_dir='c:\test' I have to restart the database ?

Yes.

> that's what you meant by bounce ? and to restart a database
> on NT I suppose I have to stop and restart a service which
> one is it ?

I presume you're accessing your database thru a service. Look at your tnsnames.ora on your client workstation (usually in c:\orant\network\admin in Oracle7, or c:\orant\net80\admin in Oracle8, or
c:\orant815\network\admin in Oracle8i...), you'll see a line beginning with something like <your service name>.world=... In this part, you'll see a clause CONNECT_DATA=(SID=<instance name>)...). You'll get the instance name.

On your server, you have a service OracleService<instance name>, this is the one to stop.
If you are in Oracle8i and the key registry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMEx/ORA_<instance name>_SHUTDOWNTYPE is "i", you can stop and restart this service with the service manager. Otherwise, use oradim in a DOS box
(oradim73.exe, oradim80.exe or oradim.exe in your %ORACLE_HOME%\bin directory) and type: oradim -shutdown -sid <instance name> -shutmode i -shuttype inst -usrpwd <internal password> and then
oradim -startup -sid <instance name> -startype inst -usrpwd <internal password> pfile=<path/init.ora>
or use server manager:
svrmgr23.exe (or svrmgr80.exe or svrmgrl.exe) and then type connect internal
shutdown immediate
startup pfile=<path/init.ora>
exit

> 3)WHat I don't know what to do is to give to oracle the
> read/write privilege on the directory. I meant on NT I will
> create a user named oracle ? and which password I would
> give to him ? In the oracle database does the user oracle
> exist ?

In fact, this is the user that starts the oracle services which must have the write privilege on the directory. Usually it is the system account and there is no problem. Actually, you can see which user it is with the NT service manager. Click on the OracleService<instance name> and then on the Startup button In the part "Log On As" of the popup dialog box, you can see the user that started the Oracle service.

>
> Sorry for asking so many questions, but the less we know
> and the more we ask :-)
>
> Thanks
>
> Sandy
>
> -- Have a nice day
> Michel
>
>
>
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images,
Audios, Videos, News, and Shopping. Smart is Beautiful

--
Cheers
Michel