Scripting Spool Files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Scripting Spool Files

  1. #1
    Join Date
    May 2001
    Posts
    70

    Question

    Hello All-

    I have a situation where I have a production database that we have to spool each customers transactions by hour to there own spool file(that is about 500 customers with an average of 5000 transactions per hour). This is due to legal issues.

    I really don't want to get into managing tons of scripts and was hoping to build something that can work on the fly.

    Any ideas would great!

    Thanks.

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    I have a question

    1) Are they seperate users on the oracle database like I mean are there sepearte schema for each and every customer or the customer details are stored in a single tables and linked by a Key to other tables

    Option 1 If they are seperate users

    If they are seperate users as far as I can think is write a script on unix or a batch file on Windows NT/200 to accept parameters like

    Username,password and path of the spool file which are going to be stored in a text file

    Execute the the script file thru a loop and make it accept parameters from the above text file line by line and execute the output to the specified spool file.

    Using cronjob in Unix or Windows Scheduler in NT/2000 and schedule it every one hour.

    Option 2 If customer Info is available in a single schema

    For this you need to write a procedure to do the above following steps and you can execute the above procedure every 1 hour using dbms_job or using Oracle Enterprise Manager

    This is what I could think about

    Hope this helped

    Regards

    Santosh

  3. #3
    Join Date
    Jul 2000
    Posts
    243
    Hi

    why not use utl_file? why spool?

  4. #4
    Join Date
    May 2001
    Posts
    70
    I found the information about utl_file and have created the package to process the data that way.

    Thanks for the help.

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