SQL Loader Question
From: Dheeraj Reddy <ingala_at_prairie.nodak.edu>
Date: 1997/01/07
Message-ID: <5atqlt$8io_at_daily-planet.nodak.edu>#1/1
Date: 1997/01/07
Message-ID: <5atqlt$8io_at_daily-planet.nodak.edu>#1/1
Hello Everybody:
I am new to Oracle et. tools and i have general question about SQL*LDR to implement locks on the tables. We are using SQLLDR to load data into tables from formatted files and my question is:
-
[Quoted]
- Does SQLLDR implement implicit locks on the tables that are being loaded (both for read and write)?
- Or is there any way of explicit locking for the tables so as to avoid any dirty reads while loading?
Thanks in Advance
Dheeraj Reddy
-- ##################################### ## ## ## DHEERAJ REDDY INGALA ## ## ## ##################################### Research Assitant-- Bill Tracking System 1117, 16th Street North IACC BUILDING Apartment #1 DEPARTMENT OF COMPUTER SCIENCE Fargo, ND 58105 NORTH DAKOTA STATE UNIVERISTY CALL # 701-239-8411 FARGO, ND 58105 |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| EMAIL-ID: ingala_at_prairie.nodak.edu World Wide Web: http://www.cs.ndsu.nodak.edu/~ingala ******************************************************************************** BottomLine: Whatever the Human mind can concieve and believe, it can ACHIEVE. ---------- NAPOLEAN HILL ********************************************************************************Received on Tue Jan 07 1997 - 00:00:00 CET