Home » RDBMS Server » Server Administration » Wildcard for multiple directories with UTL_FILE_DIR
Wildcard for multiple directories with UTL_FILE_DIR [message #52587] Tue, 30 July 2002 18:01 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 11:50:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.