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')
);
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.