utl_file_dir = * is VERY bad news...
for i in (
select file_name
from dba_data_files ) loop
open file i.file_name for write
end loop;
and voila...No more db
- "Dasko, Dan" <Dan.Dasko_at_cdicorp.com> wrote: >
Cool, you learn something new everyday.
>
> Dan
>
> -----Original Message-----
> Sent: Wednesday, March 14, 2001 8:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Dan -
>
> I've previously used the * to define utl_file_dir
> with no problems.
> According to the documentation:
>
> "The parameter specification UTL_FILE_DIR = * has a
> special meaning.
> This entry turns off directory access checking, and
> it makes any
> directory accessible to the UTL_FILE functions."
>
> I'm wondering if the directory location in the
> procedure or package is
> entered correctly OR the filename is invalid for the
> operating system.
> I've had that problem when trying to dynamically
> name a file.
>
> Regards,
>
> David A. Barbour
> Oracle Database Administrator
> Formerly with the now defunct and bankrupt
> ConnectSouth
>
>
> "Dasko, Dan" wrote:
> >
> > I thought that a directory had to be specified by
> name in initora. I
> don't
> > think you can specify a wildcard or a higher level
> directory. I could be
> > wrong.
> >
> > Dan
> >
> > -----Original Message-----
> > Sent: Wednesday, March 14, 2001 5:16 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > List hi!
> > Oracle817 on AIX. (64 bit)
> > We have defined in initora file UTL_FILE_DIR=*
> > When we start function UTL_FILE.FOPEN it raises
> exception INVALID_PATH.
> > Everything is set and available (permissions are
> 777).
> > Do you have any idea what's wrong?
> >
> > TIA,
> > Sonja
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
> > INET: sonja.sehovic_at_pbz.hr
> >
> > 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).
> >
> >
>
> > This e-mail message has been scanned for the
> presence of all known
> computer
> > viruses by the MessageLabs Virus Control Center.
> However, it is still
> > recommended that you use local virus scanning
> software to monitor for the
> > presence of viruses.
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Dasko, Dan
> > INET: Dan.Dasko_at_cdicorp.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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: David A. Barbour
> INET: dbarbour_at_nucentrix.net
>
> 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).
>
>
> This e-mail message has been scanned for the
> presence of all known computer
> viruses by the MessageLabs Virus Control Center.
> However, it is still
> recommended that you use local virus scanning
> software to monitor for the
> presence of viruses.
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Dasko, Dan
> INET: Dan.Dasko_at_cdicorp.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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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).
Received on Thu Mar 15 2001 - 15:53:08 CST