1.2 Creating Global Database Variable
- Login into database using sys user.
- Create db variable
(CONTENT_FILES)as mentioned below:create or replace directory
CONTENT_FILESas '/scratch/contents'; - Granting access to schema (
OBDXSCHEMA– Example-OBDX_DBAUTH181IT) for variable created in step 2.GRANT READ, WRITE ON DIRECTORY CONTENT_FILES TO &&schema_name;
Parent topic: Content Upload Configuration (Day 1)