125 DBMS_LIVE_FEED

The DBMS_LIVE_FEED package is the Oracle Data Studio PL/SQL package for managing live table feeds.

125.1 About the DBMS_LIVE_FEED Package

The DBMS_LIVE_FEED package is the Oracle Data Studio PL/SQL package for managing live table feeds.

Oracle Data Studio previously was available only with Oracle Autonomous AI Database. Starting with Oracle Database 26ai (23.26.2), you can now install this feature as an option for your database. For installation details see Oracle AI Database Utilities.

Live table feeds are automated loads that keep a target table updated from new or changed objects in object storage (or other sources). They can be run on demand, run on a schedule, or run using notification-driven updates.

The following ins an overview of DBMS_LIVE_FEED package functions:

  • Purpose: Continuously or periodically load new content into an existing target table based on new objects found in the source.
  • Supported file types: CSV, JSON, Parquet (object_type).
  • Format handling: object_format accepts formats compatible with DBMS_CLOUD.COPY_DATA.

Supported sources include the following:

  • create_for_storage_link: Creates a live feed from a cloud storage link (OCI bucket URI and the local credential name).
  • create_for_directory: Creates a live feed from a database directory.
  • create_for_url: Creates a live feed from a URL using credential_name.

Filtering and processing modes include the following:

  • Filtering: Use object_filter with object_filter_type to restrict which files are loaded (glob or regular expression).
  • Scheduled runs: Set scheduled and scheduler_interval (DBMS_SCHEDULER syntax), optionally with job_class, start_date, and end_date.
  • Notification-driven runs: Set notifications to allow object storage to notify the live feed of new files.

Lifecycle management includes the following

  • modify_live_feed: Update scheduling or notification settings and scheduler attributes.
  • drop_live_feed: Remove a live feed.
  • load_new_content: Manually load new content for an existing feed.

The following notification enablement helpers are available:

  • get_notification_key: Returns a key used to construct a notification URL for the cloud service.
  • get_confirmation_url: Returns a URL that you must manually visit to confirm and enable notifications. (The URL cannot be auto-confirmed due to firewall restrictions.)
  • get_notification_state: Returns the current notification state for the feed job processing.

For details about using this package, refer to Database Actions Using Guide for Oracle Cloud

Related Topics