I was trying to load a csv file into an AWS RDS Oracle, but realized that it is not that simple or may not possible at all. Here are my findings -

I could have done an external table and then loaded into a table by doing a create table as select * from ext_table; But, unless you are using oracle custom you cannot install dbms_cloud which is needed to create external tables. S3_Integration is easy to configure but I don't think can use it any further do anything meaningful to load the data into an oracle RDS database.

Just wanted to be sure before I give up -

Can anyone confirm that it is not possible to load a csv in Oracle RDS using external tables/Sql loader.

What other method would be anyone's recommendation since the above solution is not possible ? Loading using spark/python ?