Grants to be able to create a external table?
Hi!
I have a user which tries to create a external table:
CREATE TABLE rtkprod.ldx_qa_aps_elc_in_ext (
season_id NUMBER,
subclass NUMBER,
period_desc VARCHAR2 (20),
season_desc VARCHAR2 (10),
assortment_id NUMBER,
dc_no NUMBER,
country_no NUMBER,
ass_dc_country_desc VARCHAR2 (20),
aps NUMBER,
elc_factor NUMBER)
ORGANIZATION EXTERNAL (
TYPE oracle_loader
DEFAULT DIRECTORY qa_aps_elc_in
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
CHARACTERSET 'UTF8'
BADFILE qa_aps_elc_in:'aps_elc.bad'
LOGFILE qa_aps_elc_in:'aps_elc.log'
FIELDS TERMINATED BY ';'
MISSING FIELD VALUES ARE NULL (
season_id,
subclass,
I have a user which tries to create a external table:
CREATE TABLE rtkprod.ldx_qa_aps_elc_in_ext (
season_id NUMBER,
subclass NUMBER,
period_desc VARCHAR2 (20),
season_desc VARCHAR2 (10),
assortment_id NUMBER,
dc_no NUMBER,
country_no NUMBER,
ass_dc_country_desc VARCHAR2 (20),
aps NUMBER,
elc_factor NUMBER)
ORGANIZATION EXTERNAL (
TYPE oracle_loader
DEFAULT DIRECTORY qa_aps_elc_in
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
CHARACTERSET 'UTF8'
BADFILE qa_aps_elc_in:'aps_elc.bad'
LOGFILE qa_aps_elc_in:'aps_elc.log'
FIELDS TERMINATED BY ';'
MISSING FIELD VALUES ARE NULL (
season_id,
subclass,
0