.dmp file is not getting generated after giving syntax suggested in oracle docs.

Summary:

I want to use data pump access driver to store the .dmp file in atp directory so that i can use it to send it to object cloud storage by using PUT.

Content (required):

To send file from atp directory to oci object storage

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

CREATE TABLE inv_history_x

  ORGANIZATION EXTERNAL

  (

   TYPE ORACLE_DATAPUMP

   DEFAULT DIRECTORY DATA_PUMP_DIR

   LOCATION ('inv_12.dmp')

  )

  AS SELECT * FROM inv_history;