Re: utl_file_dir question

Not an easy question.

Set up a folder (directory) on the NT server called STUDENTS. Set your utl_file_dir parameter to that folder. From the server's SERVICES panel, stop and start the instance (so the parameter will take effect). Under STUDENTS, create folders for each of your students and make them sharable. You will need to have file sharing enabled on the server. To do that, right click on the NETWORK NEIGHBORHOOD icon on the server. Pick PROPERTIES and under that pick FILE AND PRINT SHARING. Tell it that you want to be able to give others access to your files. From the student's client machines, attach each student's folder as a network drive. You'll probably want to make it so that they will automatically reconnect on logon.

                                                                                           
                    Joan Hsieh                                                             
                    <joan.hsieh          To:     Multiple recipients of list ORACLE-L      
                    @tufts.edu>          <ORACLE-L_at_fatcity.com>                            
                    Sent by: root        cc:                                               
                                         Subject:     utl_file_dir question                
                                                                                           
                    04/08/2002                                                             
                    11:13 AM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L                                                               
                                                                                           
                                                                                           

I have couple question. We need to set up 15 trainer in the training room by tomorrow for a pl/sql class. I need to set up utl_file_dir for them. This is NT environment. question 1: If I create 15 users in oracle, do I need to ask Nt admin to create system users for them as well? 2: It should be 15 different directories for each of them. How to set it in int.ora?
3: Since the training room are remote access to server. The utl_file_dir will write to local or server?

Those are sound pretty easy question. I never set this up before and they want it now. I will check the manual as well.

Thanks in advance,

Joan

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: tday6_at_csc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).