On Dec 8, 5:46 pm, NewOracleMember <anjana.manand...@gmail.com> wrote: > 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
Show us exactly what you're doing along with the contents of this file; I have not experienced the issue you're reporting with the 11g product. David Fitzjarrell -- 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
