external-tables

How can I use Oracle Preprocessor for External Tables to consume this type of format?

Suppose I have a custom file format, which can be analogous to N tables. Let's pick 3. I could transform the file, writing a custom load wrapper to fill 3 database tables. But suppose for space and resource constraints, I can't store all of this in the tablespace. Can I use Oracle Preprocessor for External Tables to transform the custo...

Oracle external tables. Optimising select queries.

I have to perform many selects from an Oracle external table. I have 10 cursors that look a lot like this (ext_temp is the external table) CURSOR F_CURSOR (day IN varchar,code Number,orig Number) IS select NVL(sum(table_4.f),0) from ext_temp table_4 where --couple of conditions here, irrelevant for the question ...

In Oracle, how do I make an external table that has the exact same structure as an existing table?

I know that you can create a table for export like this: create table bulk_mbr organization external( type ORACLE_DATAPUMP default directory jason_home location ('mbr.dat')) as SELECT * FROM mbr; But I'd like to do something like this for imports so I can create an external import table with the same structure as an existing table,...

External Tables vs SQLLoader

So, I often have to load data into holding tables to run some data validation checks and then return the results. Normally, I create the holding table, then a sqlldr control file and load the data into the table, then I run my queries. Is there any reason I should be using external tables for thing instead? In what way will they make my ...