Autonomous Transaction Processing

Get Involved. Join the Conversation.

Topic

    Pramoda Vyasarao
    Error while fetching data from an external table ( for a...
    Topic posted June 24, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Transaction Processing 
    20 Views, 1 Comment
    Title:
    Error while fetching data from an external table ( for a file from OCI object storage)
    Content:

    Hello,

     

    I followed the instructions from the below link 

    https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data.html#GUID-07900054-CB65-490A-AF3C-39EF45505802

    Scripts used 
     
    SET DEFINE OFF
    BEGIN
     
    dbms_cloud.create_credential (
        'pramod_obj_store_cred',
        ‘user_email@gmail.com',
        'r4u.tH{BT_t(JePKkI6X’); — token from the OCI object store user 
    END;
    /
     
     
    BEGIN  
       DBMS_CLOUD.CREATE_EXTERNAL_TABLE(   
          table_name =>'happiness_report_2019_ext',   
          credential_name =>'pramod_obj_store_cred',   
          format => json_object('type' value 'csv', 'skipheaders' value '1'),   
          column_list => 'country varchar2(100),                   
                         ladder number,
                         sd_ladder number,                 
                         positive_effect number,                 
                         negative_effect number,                 
                         social_support number,                    
                         freedom number,     
                         corruption number,   
                         generosity number,
                         gdp number,
                         life_expectancy number');
       END;
    /
     
     
    Error message 
     
     
    Creating a token for the object storage cloud account 
     
     
     
    CSV file is available in the object storage bucket  (URL path) 
     
     

     

     
    Version:
    18C

    Comment