We help IT Professionals succeed at work.

External Table

dba1234
dba1234 asked
on
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')  
   );
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Remove the 'not null' and 'default' on the columns.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.