1 2 Previous Next 20 Replies Latest reply: Feb 1, 2013 3:40 AM by 936666 RSS

    Error with Spool

    936666
      Hi,

      Tried to drop all the tables in the database
      SQL> conn test/Test
      SQL> Spool test.sql
      SQL> select 'drop table username.'|| table_name ||';' from dba_tables where OWNER='TEST';
      SQL> spool off;
      SQL> @test.sql
      SP2-0042: unknown command "SQL>" - rest of line ignored.
      SP2-0734: unknown command beginning "SQL> selec..." - rest of line ignored.
      SP2-0042: unknown command "SQL>" - rest of line ignored.
      SP2-0734: unknown command beginning "SQL> spool..." - rest of line ignored.
      SP2-0044: For a list of known commands enter HELP
      and to leave enter EXIT.
        1 2 Previous Next