Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    7

    Unanswered: Log all commands - how?

    I have to hand in a code dump of all commands I entered into oracle sql plus (I'm using version 8). Is there a way to tell sql plus to record every (successfull) command into a log file?

    Cheers.

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    Re: Log all commands - how?

    In SQL*Plus you should use the SPOOL command, which tells Oracle to log all your commands and their results to a file.

    SPOOL filename.txt;
    command 1;
    command 2;
    ...
    SPOOL OFF;


    I know you said SQL*Plus, but just FYI in SQL*Worksheet there is a command history button you can click on.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •