DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: spool file at server for each client login to SQL

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    spool file at server for each client login to SQL

    i can create spool file for each login to SQL this way:
    column whichdate new_value whichday noprint
    select trunc(sysdate) whichdate from dual;
    spool c:\...\File_&&whichday..txt
    but once i terminate the session and again connect to SQL the new spool file is created which overwrites the data of previous spool file.
    is there any way to save previous data, may using append clause.

    can i create a spool file ,in same way, at server end for each client login to SQL.
    with following details in it :
    computer name or IP of that client,
    session time, &
    user name.

    thanxcan i create a spool file ,in same way, at server end for each client login to SQL.
    with following details in it :
    computer name or IP of that client,
    session time, &
    user name.

    thanx

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you can append in 10g

Posting Permissions

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


Click Here to Expand Forum to Full Width