We help IT Professionals succeed at work.
Get Started

External Table

dba1234
dba1234 asked
on
227 Views
Last Modified: 2012-05-12
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 2020
Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE