RE: external tables
- From: "Anthony Molinaro" <amolinaro@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jul 2004 19:24:03 -0400
Susan,
Use the external table, it's awesome. True, you can't index them,
but you can easily:
create table x nologging as select * from external_table;
Then put an index on x.=20
You can even create x as a partitioned table.
The idea is, you can now perform sql on this 20gb flat file. You
probably wouldn't want to use it
directly in joins if it's that big but you can now easily distribute it.
You can use it to merge into=20
other tables or insert /*+ append */ for direct path access.
=20
Give it a shot.
- ant
-----Original Message-----
From: susan lam [mailto:susanzlam@xxxxxxxxx]=20
Sent: Thursday, July 29, 2004 7:13 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: external tables
Hi,
I've a huge flat file (about 20GB) to load into a 9i
database. I would like to make use of the external
table feature but I do not know the usefulness of it
if I cannot create any indexes on external tables.
Querying on the table will be slow without the
indexes. Are there other alternatives where I could
make use of the external table feature and yet be able
to query the table without any performance impact?
TIA
susan
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
