login with sys as sysdba
----First create the directory ----
CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'C:\temp\';

---After creating the directory --------
----Give the grant to hr-------

Grant Read on directory EXT_TABLES to HR;
----after granting the access to hr
then create the table --------



CREATE TABLE countries_ext (
  country_code      VARCHAR2(5),
  country_name      VARCHAR2(50),
  country_language  VARCHAR2(50)
)
ORGANIZATION EXTERNAL (
  TYPE ORACLE_LOADER
  DEFAULT DIRECTORY ext_tables
  ACCESS PARAMETERS (
    RECORDS DELIMITED BY NEWLINE
    FIELDS TERMINATED BY ','
    MISSING FIELD VALUES ARE NULL
    (
      country_code      CHAR(5),
      country_name      CHAR(50),
      country_language  CHAR(50)
    )
  )
  LOCATION ('Countries1.txt','Countries2.txt')
)
PARALLEL 5
REJECT LIMIT UNLIMITED;
------------
SELECT *   FROM   countries_ext
---------
--If the load files have not been saved in the appropriate directory the following result will be displayed:--



SQL> SELECT *
  2  FROM   countries_ext
 
SELECT *
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file Countries1.txt in EXT_TABLES not found
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1