Posts

  • 1-5 of 5
  • Pramoda Vyasarao
    Object storage access via Cloud console to business users2
    Topic posted June 30, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Object storage access via Cloud console to business users
    Content:

    Hello,

    Allow group Data_Team to manage objects in compartment ABC where all {target.bucket.name='BucketA', any {request.permission='OBJECT_CREATE', request.permission='OBJECT_INSPECT’}}
     
    With this policy defined, I plan to create business users and assign them to the group Data_Team. Here is my question, appreciate any insights on this.
     
     Can users of Data_Team (group) use cloud console UI to upload files to the object storage bucket? Or is it just via APIs / CLI ?
    In this  use case , business users procure large lists of external data in XLS/CSV files.  If we can achieve the above, I'm thinking of allowing business users to upload files to Object storage via a browser and then developers can access & load them to tables. In Cloud console UI, Data_Team should just see Object storage link enabled (no other option).
     
     
    Regards,
    Pramoda 
  • Pramoda Vyasarao
    Error while fetching data from an external table ( for a...1
    Topic posted June 24, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    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
  • Pramoda Vyasarao
    Oracle Advanced Analytics & Oracle Data Miner on ATP
    Topic posted June 24, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Oracle Advanced Analytics & Oracle Data Miner on ATP
    Content:

    Hello,

     

    I've tried Machine learning SQL notebook on our trial ATP instance. I was keen to try Oracle data miner option using SQL Developer on ATP.  I get an error message saying 'data mining repository is not installed' (screenshot attached). Does ODM not work on ATP? 

    Thanks

    Pramoda

    Image:
  • Pramoda Vyasarao
    Max size of files on Object storage2
    Topic posted June 20, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Storage, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    Max size of files on Object storage
    Summary:
    Maximum file size
    Content:

    Hello,

    I am downloading large files from https://www.data.gov for my Machine learning use cases. The plan is to load these into Object store and access them as external tables. What's the maximum file size? I remember it as 2GB in a training , please confirm?

    Regards,

     

  • Pramoda Vyasarao
    APEX applications on ATP1
    Topic posted June 20, 2019 by Pramoda VyasaraoGreen Ribbon: 100+ Points, tagged Apex, DBCS, Transaction Processing in Data Management > Autonomous Transaction Processing public
    Title:
    APEX applications on ATP
    Summary:
    Building APEX applications on ATP
    Content:

    Hello,

    If a company is using autonomus database cloud service, what options they have to develop & host APEX applications ?

    1. Does APEX come along with ATP service?

    2. Or the company has to sign up for an APEX cloud service and then connect that to ATP DB?

    Thanks for any insights on this.

    Regards,