Database Administration (MOSC)

MOSC Banner

Writing to file system via job fails, but succeeds when done by hand

edited May 7, 2009 1:14AM in Database Administration (MOSC) 1 commentAnswered
 Hello all,
I'm facing a very strange situation here which I cannot find a solution for. Maybe anyone of you can?
We're running two DB servers (10.2.0.4) on SLES10, one being the productive environment, the other one being used for tests.
PROD was set up first and is running without any problems ever since. TEST was created afterwards using the exact same configuration as PROD.

One of the functionalities of our application is adding data files (e.g. pdf files) to objects by moving them in them in the file system to the appropiate
directory and adding its meta data in the DB. Moving the files is done using JAVA code that runs directly in the DB (we used to use the UTL_FILE package, which we had

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center