ORA-16000 On CREATE GLOBAL TEMPORARY TABLE on ADG (Doc ID 2788007.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Create Global Temporary table on ADG reports below error


SQL> CREATE GLOBAL TEMPORARY TABLE <table name>(c1 number, c2 varchar(10)) ON COMMIT PRESERVE ROWS;
CREATE GLOBAL TEMPORARY TABLE tab2(c1 number, c2 varchar(10)) ON COMMIT PRESERVE ROWS
*
ERROR at line 1:
ORA-16000: database or pluggable database open for read-only access


Following parameters are Already set on Primary and Standby


temp_undo_enabled boolean TRUE
Compatible >= 12

MRP is running real time with Apply in Open Mode

Also  adg_redirect_dml =true 

Changes

 Please refer



https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/managing-oracle-data-guard-physical-standby-databases.html#GUID-DAF341CA-69C9-497D-A50C-FDC89ED9C1D8


DDL Operations  =============>

Global temporary tables can be created on, and dropped from, Active Data Guard standby databases. The DDL for these operations is transparently redirected to the primary database .

The Active Data Guard session then waits until the corresponding changes are shipped and applied to the Active Data Guard standby. The following is an example of creating a global temporary table:

Cause

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