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 laterOracle 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).
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 |