Home » RDBMS Server » Server Administration » Application File system for dba1 (New Test instance)
Application File system for dba1 (New Test instance) [message #241874] Wed, 30 May 2007 15:17 Go to next message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
Hi have a question and I hope this is in the right forum. After discussing this with the DBAs it was determined the best practice for moving Oracle reports to the final destination on DBA1 (the new test instance) would be:

To create an OS user which will copy the source report on /tmp a directory in Unix.

The DEV team should create and concurrent program in APPS_DBA1 which will move the report file from /tmp to the final destination and reset the permission.

The concurrent program might have 2 parameters: filename, destination path, and should be created under $TAM_TOP/bin
which is the .rdf file directories for Oracle reports.

Shell code:

# ----------------------------

# main module get parameters

# ----------------------------

set - `echo $1`

shift 8

TEMPDIR=`echo $1 | tr -d '["]'` -- destination path

TEMPFILE=`echo $2 | tr -d '["]'` -- filename

# -------------------------------------------


# return error code 2 to the application

# -------------------------------------------

[ ! "$TEMPDIR" -o ! "$TEMPFILE"] && exit 2

# -------------------------------------------

# get inbound directory

# -------------------------------------------

# echo $TEMPDIR

# echo $TEMPFILE

# -------------------------------------------

# copy source file to final destination and rename the previous version

# -------------------------------------------






Can anyone tell me what problems you see with this approach?

Re: Application File system for dba1 (New Test instance) [message #241895 is a reply to message #241874] Wed, 30 May 2007 19:40 Go to previous messageGo to next message
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
Generic & rhetorical question(s) -
How do you ensure the right report gets to the correct user?
How do you prevent two reportfiles from having the same name & the 2nd report overwriting the 1st file?
Re: Application File system for dba1 (New Test instance) [message #241920 is a reply to message #241874] Thu, 31 May 2007 01:05 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and apply How to format your posts and remove all those blank lines.

Previous Topic: pl/sql package using UTL_FILE
Next Topic: Datadictionary views
Goto Forum:

Current Time: Sat Aug 19 13:50:18 CDT 2017

Total time taken to generate the page: 0.04406 seconds