My Oracle Support Banner

How to perform a movement of non-SYS owned Advanced Queueing Tables across tablespaces using DBMS_AQADM.MOVE_QUEUE_TABLE On 19c and Above (Doc ID 2867445.1)

Last updated on DECEMBER 15, 2024

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service
Gen 2 Exadata Cloud at Customer
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

The purpose of this article is to discuss and provide a procedure which enables you to perform a movement of non-SYS owned Advanced Queuing (AQ) tables using interface DBMS_AQADM.MOVE_QUEUE_TABLE.

Scope

This article is intended for anyone who needs to move the AQ tables from one tablespace to another or within the same tablespace.
The DBMS_AQADM.MOVE_QUEUE_TABLE is a standard interface offered to customers by Oracle. This interface is designed to replace the old ad-hoc external script (Doc ID 1410195.1) used to move the AQ tables. The MOVE_QUEUE_TABLE interface is integrated with Oracle Database server and made available to customers via the standard AQ package DBMS_AQADM.  The interface can be used either to move the AQ queue table within the same tablespace (local redefinition) or to move to a different tablespace (non-local redefinition).

Patch and Version Details:

The DBMS_AQADM.MOVE_QUEUE_TABLE interface is included from Oracle 23ai. In order to use the interface  in older versions you need to have the Patch 37223181 applied.

The one-off backport patches on different 19.x DBRU versions are readily available. If a Patch is not available for your version please consult Oracle Support.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.