DBMS_CLOUD.CREATE_EXTERNAL_TABLE ignoring NULL columns tab delimited file
Summary
External table is ignoring NULL columns on tab delimited file so contents are appearing in wrong columnsContent
I have created an external table over a tab-delimited file with DBMS_CLOUD.CREATE_EXTERNAL_TABLE but I cannot work out how to correctly handle NULL column values. An example will hopefully help. The customer file has the following tab-delimited columns
CUSTOMERID
PERSONID
STOREID
TERRITORYID
ACCOUNTNUMBER
ROWGUID
MODIFIEDDATE
A sample of records from the customer file are;
1 934 1 AW00000001 {3F5AE95E-B87D-4AED-95B4-C3797AFCB74F} 2014-09-12 11:15:07.263000000
2 1028 1 AW00000002 {E552F657-A9AF-4A7D-A645-C429D6E02491} 2014-09-12 11:15:07.263000000
3 642 4 AW00000003 {130774B1-DB21-4EF3-98C8-C104BCD6ED6D} 2014-09-12 11:15:07.263000000
29484 291 292 5 AW00029484 {A24C1240-1A8D-427B-91E9-6197F8CF3CAD} 2014-09-12 11:15:07.263000000
29485 293 294 4 AW00029485 {392AE773-D7EC-48AC-B8D0-6E65B770285C} 2014-09-12 11:15:07.263000000
29486 295 296 3 AW00029486 {2A5ABA2E-8DB0-4856-A773-21D185F1679E} 2014-09-12 11:15:07.263000000
Tagged:
0