Oracle External Table Error KUP-04021: field formatting error for field and KUP-04035: beginning enc
I have Oracle 11gR2 64bit running on RHEL 2.6.
The format of the file seems correct to me and I don't understand why I am getting the error. Any thoughts pls..
I am trying to create an external table "test" on file, test.xml:
<test><keydef><keyid>1</keyid><status>ACTIVE</status></keydef></test>
Here is my table test definition:
CREATE TABLE test
( KEYID NUMBER(10,0),
STATUS VARCHAR2(20 CHAR)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "SECURITY"
ACCESS PARAMETERS
( RECORDS DELIMITED BY "</keydef>"
badfile security:'test.bad'
logfile security:'test.log'
discardfile security:'test.dsc'
FIELDS
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS