Created On: 12 October 2011
Problem:
User wishes to capture output of SQL queries run in SQL Plus into a text file. These queries would be performed on a database table in Modernization Workbench during a troubleshooting process with SupportLine.
Resolution:
User can use the "spool" feature to capture output results of a SQL query in SQLPlus into a text file. Prior to running any SQL query, user must enable the spool feature and specify a target text file. From here, run the SQL query. After that, spool must be disabled.
spool C:\\log.txt
select * from WorkspaceSettings;
spool off
spool C:\\log.txt
select * from WorkspaceSettings;
spool off
Incident #2537476
Old KB# 34918
#EnterpriseAnalyzer
#SupportTip