SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Plus Error - "Can't open file" when spooling

GaffAug 26 2010 — edited Aug 27 2010

Hi:

I have a user who is either able or unable to spool when running a script depending on what Oracle user she logs in as. She's always logging in as the same Linux user but connecting to Oracle as different Oracle users via SQL Plus. When spool files are created they are created with that user's account and group settings, so the OS account seems to be fine.

I'm having a problem with the idea that there is an Oracle role or something that controls this. Spool isn't UTL_FILE. Is this a SQL Plus application setting or something?

We're using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2010

Added on Aug 26 2010

7 comments

2,296 views