-
Hi,
I have a problem while writing to a file using utl_file.
utl_file_dir=/var/tmp,/abc/test,/DB/tests
Documentation recommends to specify each directory in single line. I have changed it to
utl_file_dir=/var/tmp,
utl_file_dir=/abc/test
utl_file_dir=/DB/tests
And have bounced the DB. Still I get INVALID_PATH exception.
Will the comma in the first line err out?
Any help will be appreciated.
Cheers,
Nandu
Never give up !
Nanda Kumar - Vellore
-
Note that all users can read or write all files specified in the UTL_FILE_DIR parameter(s).
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
Note that all users can read or write all files specified in the UTL_FILE_DIR
Thanks Suresh. That is the expected behaviour.
But my worry is, it is throwing an exception INVALID_PATH.
I have a question !
If the first path mentioned in the UTL_FILE_DIR is invalid and the consequtive paths are valid, what will happen?
Pls. note that, for this database I don't have access to V$ views to check the values.
Cheers,
Nandu
Never give up !
Nanda Kumar - Vellore
-
find a dba/user that can access v$parameter
issue the command
show parameters utl;
This will tell you values for parameters starting with utl.
figure it out from there.
Good Luck
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
Thanks Sureshy!
It's a shame ... I can't access the V$ views..
Its not the DB I maintain... and it is just to help my team, as the DBA is not around.
Anybody else, have ever been stuck up with INVALID_PATH?
Help Please !
Cheers,
Nandu
Never give up !
Nanda Kumar - Vellore
-
Don't take this wrong, but are you sure the paths exist? Correct spelling? (You said it wasn't your database - maybe you were given some wrong info about directory locations.)
-
Don't take this wrong, but are you sure the paths exist?
Thats a very valid point u have made.
I have checked with the path. Case sensitivity... etc.,
Everything is fine.
I still wonder if something is wrong with the Parameter setting itself... pls. see msg., above for how it looks like.
Cheers,
Nandu
Never give up !
Nanda Kumar - Vellore
-
Okay, who owns the directories? Should be oracle.
-
NANDU:
According to Oracle "The directories that UTL_FILE can read from and write to need to have permissions of the Oracle instance owner and the user running the package."
Run chmod 777 directory_name at the unix prompt and this might help.
Something else:
utl_file_dir=/var/tmp, utl_file_dir=/abc/test, utl_file_dir=/DB/tests
should be enough for the init.ora
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|