| 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: External tables
sqlldr is a tool that performs a function. This function has been enhanced
and copied to Oracle Kernel as the new feature "External Tables".
I would say run your tests again and see if there is any relation between sqlldr and external tables.
I would be surprised!
Also reading the external tables is just a reading/scanning process that requires no temporary resources from the database (and this is the beauty of it) except you are going to join that source to another table or doing any other operation that require the Temp resources.
Regards,
Waleed
-----Original Message-----
Sent: Thursday, April 24, 2003 12:52 PM
To: Multiple recipients of list ORACLE-L
Waleed,
I went to the 9i new features class & a discussion of external tables at the NOUG last year presented by an Oracle programmer out of the Nashua development office. Both stated that sql loader is invoked by proxy for you by the Oracle kernel and that it loads temporary tables of the global temporary type. Experimenting with a 9ir2 database here and a very large external table reveals a usage of temp tablespace during the table read and sure enough sql loader was in the HP-UX process table. Not sure where your info comes from.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Thursday, April 24, 2003 10:57 AM
To: Multiple recipients of list ORACLE-L
It does not use sqlldr and there is no temporary tables.
Regards,
Waleed
-----Original Message-----
Sent: Thursday, April 24, 2003 10:12 AM
To: Multiple recipients of list ORACLE-L
Dave,
I would say that it depends since an external table uses SQL*Loader anyway, it just ends up in a temporary table vs. a permanent one. Saves on redo generation as well.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Wednesday, April 23, 2003 6:32 PM
To: Multiple recipients of list ORACLE-L
Has anyone benchmarked external tables versus sqlldr for loading data?
Before
I start using external tables I thought I'd see if it was worth my time.
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: David Turner
INET: turner_at_tellme.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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.net
--
Author: Goulet, Dick
INET: DGoulet_at_vicr.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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.net
--
Author: Goulet, Dick
INET: DGoulet_at_vicr.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Thu Apr 24 2003 - 12:38:04 CDT
 |
 |