External Tables in Oracle

1. Place the ALL_OBJECTS.csv file in D:\CDD
2.  GRANT CREATE ANY DIRECTORY TO SCOTT;
3. Create directory

CREATE OR REPLACE DIRECTORY EXT_TAB_DATA AS 'D:\CDD';
SELECT * FROM ALL_DIRECTORIES WHERE DIRECTORY_NAME='EXT_TAB_DATA';

DROP TABLE ALL_OBJECTS_DUMP;

CREATE TABLE ALL_OBJECTS_DUMP (
    owner         VARCHAR2(30),
    object_name   VARCHAR2(30),
    object_type   VARCHAR2(19),
    status        VARCHAR2(7),
    created       DATE
)
organization EXTERNAL ( TYPE oracle_loader
    DEFAULT DIRECTORY ext_tab_data
ACCESS PARAMETERS (
    RECORDS DELIMITED BY NEWLINE
    FIELDS TERMINATED BY ',' MISSING FIELD VALUES ARE NULL
(
   owner       CHAR(30),
    object_name   CHAR(30),
    object_type   CHAR(19),
    status        CHAR(7),
    created       CHAR(10)
    )
  ) location('ALL_OBJECTS.csv') )
    PARALLEL 5
REJECT LIMIT UNLIMITED;

SELECT * FROM ALL_OBJECTS_DUMP;