Database Administration (MOSC)

MOSC Banner

Grants to be able to create a external table?

edited Jan 20, 2012 2:26AM in Database Administration (MOSC) 3 commentsAnswered ✓
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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center