Do you have problem spooling file in oracle 10G?
- This problem occurs because of permission restriction of writing file in C drive.
- By spooling we create a file in oraclexe which is in C drive, if you do not have permission to create a file in C(OS drive) then spooling will be failed.
- This is the only reason why users other than admin cant spool.
- Allow users as well as admin to write files to C drive and then try spooling, it should work!
