1.2 Creating Global Database Variable

  1. Login into database using sys user.
  2. Create db variable (CONTENT_FILES) as mentioned below:

    create or replace directory CONTENT_FILES as '/scratch/contents';

  3. Granting access to schema (OBDXSCHEMA – Example- OBDX_DBAUTH181IT) for variable created in step 2.

    GRANT READ, WRITE ON DIRECTORY CONTENT_FILES TO &&schema_name;