Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Bulk Loading Policies

Bulk Loading Policies

From: JAL <jal_at_guess.com>
Date: 1998/02/12
Message-ID: <6c054m$lqe$1@usenet11.supernews.com>#1/1

Hi all,

     We have Oracle 7.3.3.4 on a Unix box, Solaris 2.5.1 and we will be receiving data to upload into the production database, i.e. bank reconciliation tapes. The data will be initially loaded into an intermediate table before going into the database. We have been told that in order for clients to do this they must have DBA rights, which I can't believe, to use SQL Loader. We would prefer to have the clients do the bulk loading but I am interested in hearing from other organizations and what policies you have in place regarding this. Did you find it more advantageous to have the client do the bulk loads or is this something that should be done by the DBA?

     Thanks in advance for your answers.

--
    Juanita R. Alvarez
Database Administration Team Lead
Pima Community College
4905A E. Broadway
Tucson, AZ   85709
Email is jalvarez_at_tpimacc.pima.edu
Received on Thu Feb 12 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US