Query External Partitioned Data
If you want to query multiple data files in the Object Store as a single
external table and the files can be represented as multiple logical partitions, then it is
highly recommended to use an external partitioned table. Using an external partitioned table
preserves the logical partitioning of your data files for query access. Use the procedure DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE
to create an
external partitioned table.
When you a create a partitioned external table, you include a partitioning
clause in the DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE
statement. The partitioning
clause that you include depends upon the data files in the Cloud and the type of
partitioning you use. See Creating a Partitioned External Table
for more information.