Gurus,


I receive an ora-30657 error when I attempt to create the external table. I
bet you can guess what Oracle's advice is, "Action: Do not attempt the
operation". Do you guys have any suggestions?





CREATE TABLE MODMAST_EXT
(
MBSEG NUMBER,
CO NUMBER,
PLANT NUMBER,
MODEL VARCHAR2(8 BYTE),
WIDTH NUMBER,
LNGTH NUMBER,
HLNGTH NUMBER,
PRLIN# NUMBER,
MDLEDT VARCHAR2(10 BYTE),
BEGCAT NUMBER,
ENDCAT NUMBER,
BASEPR NUMBER,
BASECS NUMBER,
FLRNUM NUMBER,
MODDES VARCHAR2(20 BYTE),
MODPRE VARCHAR2(4 BYTE),
MODSUF VARCHAR2(5 BYTE),
WOMOD VARCHAR2(1 BYTE),
AUTUPD VARCHAR2(1 BYTE),
LSTUPD VARCHAR2(1 BYTE),
BOMNAM VARCHAR2(8 BYTE),
UPDDT8 NUMBER,
AUDDT8 NUMBER,
SCRAP NUMBER,
FASTNR NUMBER,
MSPRF1 VARCHAR2(10 BYTE),
MSPRF2 VARCHAR2(2 BYTE),
MSPRF3 NUMBER
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY FLATFILES
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ","
optionally enclosed by '~'
missing field values are null
)
LOCATION (FLATFILES:'modmast')
)
LOGGING
NOCACHE
NOPARALLEL
REJECT LIMIT 0;

Oracle LazyDBA home page