My Oracle Support Banner

Shrink And Enable Row Movement Commands On PDB For SYS.STREAMS$_APPLY_PROGRESS Table Results In ORA-65040 errors (Doc ID 2536451.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.
Enable row movement and shrink space commands fails in PDB

Goal

 Attempting current steps with STREAMS$_APPLY_PROGRESS table maintenance results in

 

SQL> alter table SYS.STREAMS$_APPLY_PROGRESS enable row movement;
alter table SYS.STREAMS$_APPLY_PROGRESS enable row movement
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

SQL> alter table SYS.STREAMS$_APPLY_PROGRESS shrink space;
alter table SYS.STREAMS$_APPLY_PROGRESS shrink space
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

 

 

Solution

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
Goal
Solution
References


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