| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data load options
My experience with getting data into Oracle on an NT platform.
If a small number of rows are being inserted or updated, use an application or SQL script.
If the data already exists in some form outside of Oracle, transform the data into some form of a flat file and use SQL*Loader.
If the data already exists in another Oracle database, export it and import it into your database (gotta be careful about tablespaces, schemas and not messing up existing data but that goes with the territory).
Other methods include loading it into Access or some other MS product and using an ODBC connection to update Oracle. I've seen that used for everything from single row updates to medium sized (10M) bulk loads.
"O'Neill,
Sean" To: Multiple recipients of list ORACLE-L
<Sean.ONeill_at_o <ORACLE-L_at_fatcity.com>
rganon.ie> cc:
Sent by: Subject: Data load options
root_at_fatcity.c
om
07/25/2001
06:16 AM
Please respond
to ORACLE-L
I'm trying to compile a list of options for loading data into an Oracle
database on NT platform. What I've come up with so far is:
[1] SQL script that performs inserts, updates.
[2] SQL Loader utility
[3] Import utility
Are there others?
Anyone care to share experience based opinions on pros and cons of the
methods?
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
-------------------------------- ------------Organon (Ireland) Ltd.
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: Sean.ONeill_at_organon.ie 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: ListGuru_at_fatcity.com (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tday6_at_csc.com 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: ListGuru_at_fatcity.com (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).Received on Wed Jul 25 2001 - 09:21:13 CDT
 |
 |