Refresh External Partitioned Tables with Updated or Deleted Source Files
You can use DBMS_CLOUD.SYNC_EXTERNAL_PART_TABLE
to refresh an external
partitioned table. Use this procedure when new partitions are added or when partitions are
removed from the object store source.
Note:
Only useDBMS_CLOUD.SYNC_EXTERNAL_PART_TABLE
when the partitioned external
table is created with DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE
and the
file_url_path
parameter.
To refresh a partitioned external table: