From ssmith@ai.com Wed, 03 Oct 2001 09:21:06 -0700 From: "Steve Smith" Date: Wed, 03 Oct 2001 09:21:06 -0700 Subject: Re: init.ora file and UTL_FILE package In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: text/plain Yep, as long as they have OS level authority. That's why I said 'development server'.. Steve ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Wednesday, October 03, 2001 2:30 AM > Remember this has security implications however as anyone can read/write > files from otherwise "private" directories. > > Kev. > > "hit any user to continue" > __________________ > > Kevin Thomas > Technical Analyst > Deregulation Services > Calanais Ltd. > (2nd Floor East - Weirs Building) > Tel: 0141 568 2377 > Fax: 0141 568 2366 > http://www.calanais.com > > > -----Original Message----- > Sent: 03 October 2001 05:50 > To: Multiple recipients of list ORACLE-L > > > utl_file=* > > On the development server.. > > Steve > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > Sent: Tuesday, October 02, 2001 5:55 PM > > > > I have a question concerning the init.ora file and using the supplied > > package UTL_FILE.... > > > > I am finding it a real inconvenience to bounce the database everytime I > need > > to add a UTL_FILE directory, especially on the development machine. Since > > the coding is very dynamic and many people are developing on the same > > database, when I add a UTL_FILE directory, I need to notify everyone > > involved, have them stop what they are doing and bounce the database... > yuk! > > > > Is there any possible way to add UTL_FILE directories on the fly without > > bouncing the database (alter session, alter system, etc....) and then at a > > more convenient time add all of the changes at once to the init.ora file > and > > bounce the database once. > > > > Any suggestions would be useful. > > > > Thanks in advance > > > > ReedK > > "just another Montana DBA" > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kempf, Reed > > INET: rkempf@rightnow.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@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: Steve Smith > INET: ssmith@ai.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@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: Thomas, Kevin > INET: Kevin.Thomas@calanais.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@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: Steve Smith INET: ssmith@ai.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@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).