Link to home
Create AccountLog in
Avatar of dba1234
dba1234

asked on

External Table

Hi,
I am trying to create a external table and getting the below error. I have setup the directory and permission.
ORA-30657: operation not supported on external organized table
CREATE TABLE table_name
(
  CLM_KEY         NUMBER                        NOT NULL,
  EDW_DATE        DATE                          NOT NULL,
  CURR_ROW        CHAR(1 BYTE)                  DEFAULT 'Y'                   NOT NULL,
  CLM_NO          VARCHAR2(40 BYTE),
  CLM_SRC_IND     VARCHAR2(10 BYTE),
  CLM_TYPE_IND    VARCHAR2(10 BYTE),
  CLM_FORM_IND    VARCHAR2(10 BYTE),
  CLM_PROD_IND    VARCHAR2(10 BYTE),
  XTRL_CLM_NO     VARCHAR2(40 BYTE),
  INTRL_CNTL_NO   VARCHAR2(40 BYTE),
  CLM_STAT_IND    VARCHAR2(10 BYTE),
  RCVD_DATE       DATE,
  ENTD_DATE       DATE,
  BEG_DATE        DATE,
  END_DATE        DATE
        )
       organization external
       (TYPE ORACLE_LOADER

        default directory xtern_data_dir
         access parameters
         ( records delimited by newline
           fields terminated by ','
         )
        LOCATION ('file.txt')  
   );
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer