| 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: sqlldr questions
Charlie,
refer oracle utilities documentation part 8.
To save time and space in the redo log file, use the UNRECOVERABLE keyword
when you load data.
hope this helps.
Sunil Nookala
Dell computer corporation.
-----Original Message-----
From: Charlie Mengler [mailto:charliem_at_mwh.com]
Sent: Monday, October 30, 2000 8:42 AM
To: Multiple recipients of list ORACLE-L
Subject: sqlldr questions
I need to use sqlldr to load about 32GB worth of data as a one-shot deal. I ran an initial test over this last weekend. The test revealed some "dirty" data.
Can sqlldr be configured such that it simply does a sanity test on the data to verify that all the records are in acceptable format WITHOUT actually going thru the overhead of loading the data? If so, how?
I'm running the instance in archive mode. The test load job consumed all the disk space where the redo logfiles get deposited. Is there any way to configure sqlldr so that logging is DISBALED? If so, how?
--
Charlie Mengler Maintenance Warehouse charliem_at_mwh.com 10641 Scripps Summit Ct 858-831-2229 San Diego, CA 92131Your call is important to us. Please continue to hold!
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 Mon Oct 30 2000 - 11:19:28 CST
 |
 |