We followed these steps to load the TPCH data into the Oracle database:

1. We copied orders and part table CSV files to this location on the Oracle database host:

 [Oracle@oraclebds data]$ cp orders.tbl*, part.tbl* /tpc/data

2. We created a directory on the Oracle database:

SQL>Create OR replace directory tpch_dir AS ‘/tpch/data’;

SQL>grant read on directory tpch_dir to tpch;

3. We created the TPCH tables “orders” and “part” that point to the csv file location using these commands:

SQL>create table tpch. orders

(

o_orderkey          NUMBER(10,0),

o_custkey            NUMBER(10,0),

o_orderstatus       CHAR(1),

o_totalprice          NUMBER

o_orderdate          CHAR(10),

o_orderpriority      CHAR(15)

o_clerk                  CHAR(15),

o_shipppriority      INTEGER,

o_comment          VARCHAR2(7 

              )

 ORGANIZATION EXTERNAL

 (TYPE oracle_loader

  DEFAULT DIRECTORY tpch_dir

  ACCESS PARAMETERS (

  FIELDS

  TERMINATED BY ‘|’

   MISSING FIELD VALUES ARE NULL

)

LOCATION(‘/tpch/data/orders*.tbl’));

4. Similarly, we created a TPCH table “part” that points to the location:

SQL> create table tpch.ext_part

(

P_partkey               NUMBER(10,0),

P_name                  VARCHAR2(55),

P_mfgr                    CHAR(25),

P_brand                  CHAR(10),

P_type                    VARCHAR2(25),

P_size                      INTEGER,

P_container           CHAR(10),

P_retailprice          NUMBER,

P_comment          VARCHAR2(23)

)

ORGANIZATION EXTERNAL

(TYPE  oracle_loader

DEFAULT DIRECTORY tpch_dir

ACCESS PARAMETERS (

FIELDS

TERMINATED BY ‘|’

MISSING FIELD VALUES ARE NULL

)

LOCATION(‘/tpch/data/part.tbl*));