MuddyMojo
asked on
SQLplus | spool without file extension
Our enterprise system will only import files without a extension... Is there a way to SPOOL from sqlplus without a extension? I know how to change the extension and I know if none is specified it addes .LST but how can I just spool a filename like "myfile"? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I split the points because slightwv answered my question about the extension and robyncoffey offered a efficient work around. Thank you both and I hope you feel the split was resonable.
This meets the extensionless requirement as well as enabling you to avoid doing it by hand over and over.
JT