Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle 18c: Global Temporary Table support from Standby

mariam.kupaSep 28 2018 — edited Jan 18 2019

From 18c documentation:https://docs.oracle.com/en/database/oracle/oracle-database/18/sbydb/managing-oracle-data-guard-physical-standby-database…

"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"

1. Set temp_undo_enabled=true on primary database:

SQL> alter system set temp_undo_enabled=true;

2. Tried to create global temporary table on standby database:

SQL> CREATE GLOBAL TEMPORARY TABLE tab2(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

Something is not working, I am not able to create Global Temporary Table on the standby database.

This post has been answered by Markus.Michalewicz-Oracle on Jan 16 2019
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 15 2019
Added on Sep 28 2018
#data-guard, #performance-availability
16 comments
2,426 views