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_FILES
as '/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)