Thanx to all who responded on my query about Data Load options. I've tried to summarise below. To try and put a lid on it I'd appreciate feedback on gaps, any corrections and obs on data volume metrics. Low volume = <10Mb Medium volume = >10Mb <100Mb High Volume = >100Mb Option Volume Data Data Source Ease of use (includes learning curve) ------------------- ---------- ---------- ---------------- ------------------------------------- SQL Script Low Simple External Simple SQL Loader Medium, High Simple External ??? Import Medium Complex Oracle Moderate UTL_FILE ??? Complex ??? ??? DB Link ??? ??? Oracle ??? ODBC from MS Access Medium ??? External ??? Pro*C ??? ??? ??? Difficult Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA -------------------------------- ------------ Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
