Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    19

    Unanswered: options in connect

    Hello I have a problem . It is:

    In sqlplus, i put:

    connect user/pwd@cadena
    Then sqlplus put "conectado"
    I have a script where I connect 100 databases and I execute the the same select :

    spool log.log
    connect user/pwd@cadena
    select * from tabla;
    connect user1/pwd@cadena
    select * from tabla;
    ----
    spool off;

    After, In the result, log.log I have to delete the word "conectado"

    Can I generate the spool log.log without the word "conectado"
    Thanks a lot¡¡¡¡

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    If you use Oracle 10, the it would be possible to do something like this:
    Code:
    connect user/pwd@cadena 
    spool log.log
    select * from tabla;
    spool off;
    
    connect user1/pwd@cadena 
    spool log.log APPEND
    select * from tabla;
    spool off;
    In Oracle versions prior to 10g, I don't know how to do it ... only, perhaps, when spooling is over, to open a text editor and perform "Replace" operation and replace all "Connected" messages with nothing.

Posting Permissions

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