Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
DBMS_CLOUD.CREATE_EXTERNAL_TABLE ignoring NULL columns tab delimited file — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DBMS_CLOUD.CREATE_EXTERNAL_TABLE ignoring NULL columns tab delimited file

Accepted answer
17
Views
4
Comments
edited Aug 5, 2020 1:31PM in Autonomous Database 4 comments

Summary

External table is ignoring NULL columns on tab delimited file so contents are appearing in wrong columns

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!