OraFAQ Forum: Server Administration » Wildcard for multiple directories with UTL_FILE

Home » RDBMS Server » Server Administration » Wildcard for multiple directories with UTL_FILE_DIR

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Wildcard for multiple directories with UTL_FILE_DIR [message #52587]

Tue, 30 July 2002 18:01

Vaughan Castine
Messages: 1
Registered: July 2002

Junior Member

We have a need to have multiple directories writable by Oracle. These directories all have a common parent directory.

To reduce management overhead we don't want to have to keep changing the UTL_FILE_DIR statements in init.ora.

We could use
UTL_FILE_DIR=*
but this opens up a security can of worms and we wont be going down that path.

Does anyone know if its possible to use wildcards so that we put one entry rather than having to specify
UTL_FILE_DIR=/usr/dir1
UTL_FILE_DIR=/usr/dir2
UTL_FILE_DIR=/usr/dir3
UTL_FILE_DIR=/usr/dir4
etc...

We have already unsuccessful tried
UTL_FILE_DIR=/usr/*

Report message to a moderator

Re: Wildcard for multiple directories with UTL_FILE_DIR [message #52588 is a reply to message #52587]

Tue, 30 July 2002 18:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

If you are specifying multiple directories, you must
repeat the UTL_FILE_DIR parameter for each directory
on separate lines of the initialization parameter
file. I dont think use of wildcard is supported.

workaround is:

1. Create all required files in a single UTL_FILE_DIR

2. Have proper naming convention for the files 
3. Have a OS level Batch file which physically moves the output in the various sub directories

Report message to a moderator

Previous Topic:	ORA-04045 error during recompilation/revalidation of LBACSYS.LBAC_EVENTS while creating Table
Next Topic:	Tablespaces and Users

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 13 10:55:37 CST 2025