Query Hybrid Partitioned Data
If you want to query internal data and multiple data files in the Object
Store as single logical table you can use a hybrid partitioned table to represent the data as
single object. Use the procedure DBMS_CLOUD.CREATE_HYBRID_PART_TABLE
to create a hybrid partitioned
table.
If your data, internal or external, can be represented in finer granularity as multiple logical partitions then it is highly recommended to create a hybrid partitioned table with multiple internal and external partitions, preserving the logical partitioning of your data for query access.
When you a create a hybrid partitioned table, you include a partitioning clause
in the DBMS_CLOUD.CREATE_HYBRID_PART_TABLE
statement. The partitioning clause that you include depends upon your data files and the
type of partitioning you use. See Creating Hybrid Partitioned Tables for more information.