Parallel Execution - Expert Oracle Database Architecture - page 674

location
(
'big_table.dat'
)
)REJECT LIMIT UNLIMITED

All we need to do is edit it to name the external table the way we want, perhaps change the directories, and so on:

EODA@ORA12CR1> create or replace directory my_dir as '/tmp/';
Directory created.

And after that, all we need to do is actually create the external table:

1 CREATE TABLE "BIG_TABLE_ET"
2 (
3 "ID" NUMBER,
...
18 "EDITION_NAME" VARCHAR2(128)
19 )
20 ORGANIZATION external
21 (
22 TYPE oracle_loader
23 DEFAULT DIRECTORY my_dir
24 ACCESS PARAMETERS
25 (
26 records delimited by newline
27 fields terminated by ','
28 missing field values are null
29 )
30 location
31 (
32 'big_table.dat'
33 )
34 )REJECT LIMIT UNLIMITED
35 /
Table created.

Then we make this table parallel enabled. This is the magic step—this is what will facilitate an easy parallel direct
path load:

EODA@ORA12CR1> alter table big_table_et PARALLEL;
Table altered.

■ the PARALLEL clause may also be used on the CREATE TABLE statement itself. right after the REJECT LIMIT
UNLIMITED , the keyword PARALLEL could have been added. i used the ALTER statement just to draw attention to the fact
that the external table is, in fact, parallel enabled.

Note