Hello All, I am trying to Spool a file in Oracle 11g. I am using the following commands.
spool file path/FileName.txt --Set echo on to see the input as well in the spool file set echo on; -- Source scripts at C:/FileName.sql start C:/FileName.sql OR select count(*) from users_table; -- Close the spool file spool off; exit When I run the query <select count (*) from users_table>, Oracle shows there are over 200 users_tables but the spool file records only about 7-10 tables. I am not sure what I am doing wrong here. However, I tried the same steps in Oracle10g, that seems to work. Can anyone tell me what I am doing wrong here? or Is there a problem with Oracle 11g. Thanks -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
