How to create Partitioned External Table in Oracle Autonomous database cloud?
I am trying to create a Partitioned External Table in my Oracle Autonomous database in OCI.
I created a storage Bucket and the files (for different quarters) are stored in the folders shown below:
../ostf2/REAC/2021/Q4/REAC2021Q1.txt
../ostf2/REAC/2021/Q4/REAC2021Q2.txt
../ostf2/REAC/2021/Q4/REAC2021Q3.txt
../ostf2/REAC/2021/Q4/REAC2021Q4.txt
Now when I do the CREATE_EXTERNAL_PART_TABLE call (as shown below), where years and quarter are in the column_list but not in field_list, as the files do not have years and quarter columns.
I get error:
ORA-20011: Invalid partitioning column in -