Oracle | DBMS_PDB_APP

Oracle DBMS_PDB_APP_CON Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Moves data between partitions in a partitioned table.

In version 18.3 this was an orphaned package header with PDB Application Container related constants. In 19c it was modified to include the MOVE_DATAMOVE_DATA procedure.

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
SYNC_ERROR_NOT_OK	NUMBER	1
SYNC_ERROR_OK_ON_RETRY	NUMBER	2
SYNC_ERROR_OK_ALWAYS	NUMBER	3

Dependencies

DBMS_PDB_LIB

Dependencies Only STANDARD

Documented No

First Available 19c ... see Purpose statement above

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, AUTO_WITH_COMMIT);

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role

Source {ORACLE_HOME}/rdbms/admin/dbmsappcon.sql

Subprograms

MOVE_DATA

MOVE_DATAMOVE_DATA

Use to move data between partitions after split partition on container map partitions. Data movement is for PDBs in the same CDB and intra CDB dblinks should be enabled before calling this proc. Movement will be according to the map constraints and data will be moved from old to new only. This proc affects all container_map enabled tables. dbms_pdb_app_con.move_data( old_partition_name IN VARCHAR2, new_partition_name IN VARCHAR2);

exec dbms_pdb_app_con.move_data('MAPPED_PART_OLD', 'MAPPED_PART_NEW');

      

      PL/SQL procedure successfully completed.