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
Skip to content
  • Register

    • DBMS_CLOUD.CREATE_EXTERNAL_TABLE ignoring NULL columns tab delimited file

    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
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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