CREATE OR REPLACE DIRECTORY "DIR_GMS" AS 'D:\Gopal_works\test_env_files'

GRANT READ ON DIRECTORY dir_gms TO gopal;
GRANT WRITE ON DIRECTORY dir_gms TO gopal;

CREATE TABLE emp_ext
  ORGANIZATION EXTERNAL
   (
     TYPE ORACLE_DATAPUMP
     DEFAULT DIRECTORY dir_gms
     LOCATION ('emp_ext_dmp.dmp')
   )
   AS SELECT * FROM hr.employees;


CREATE TABLE emp_xt (
  EMPLOYEE_ID     NUMBER(5),
  FIRST_NAME     VARCHAR2(50),
  LAST_NAME       VARCHAR2(50))
  ORGANIZATION EXTERNAL (
     TYPE ORACLE_DATAPUMP
     DEFAULT DIRECTORY dir_gms
     LOCATION ('emp_ext_dmp.dmp')
  );

expdp hr/hr tables=EMPLOYEES directory=DIR_GMS dumpfile=HR_EMP.dmp logfile=expdpEMP.log

CREATE TABLE emp_xt (
  EMPLOYEE_ID     NUMBER(5),
  FIRST_NAME     VARCHAR2(50),
  LAST_NAME       VARCHAR2(50))
  ORGANIZATION EXTERNAL (
     TYPE ORACLE_DATAPUMP
     DEFAULT DIRECTORY dir_gms
     LOCATION ('HR_EMP.DMP')
  );

SELECT * FROM EMP_XT
  
ORA-29913: error IN executing ODCIEXTTABLEOPEN callout
ORA-31619: invalid DUMP FILE "D:\Gopal_works\test_env_files\HR_EMP.DMP"
ORA-06512: AT "SYS.ORACLE_DATAPUMP", line 19