Skip to Main Content
  • Questions
  • In-memory tables and Data Guard Logical Standby


Question and Answer

Connor McDonald

Thanks for the question, Jim.

Asked: April 28, 2022 - 1:33 pm UTC

Last updated: May 11, 2022 - 5:38 am UTC

Version: Oracle Enterprise DB 19.13.1

Viewed 100+ times

You Asked

I would like to use InMemory tables in my Data Guard Logical Standby database.
Are there any caveats or limitations? I haven't found any documentation about Logical Standby and InMemory tables.
Thanks very much.
ps. Sometimes I miss the prickly responses of a few years ago.

and Connor said...

"Stop wasting our time with such questions...."

prickly enough? hee hee hee just kidding. terms of functionality, no issue, but you've hit upon an interesting intersection of licensing terms and conditions :-(

Currently the term "DataGuard" (DG) from a license perspective covers both physical and logical, but when in-memory and DG are used in the same sentence, then physical DG and in-memory only makes sense for *active* DG.

So my guess is that the license folk were assuming solely physical DG because (as per license guide) to use DG and in-memory, you *must* have an Active DG license.

Thus you've stumbled into a weird collision of terminology and license usage....because it would seem silly to need a license for a read-only facility (active DG) in order to use in-memory for a read/write (Logical DG) facility :-)

Bottom line - time for a discussion with your local Oracle Account rep and explain the usage plans etc. It may well end up being the case you need to custom license agreement to handle all of this.


  (1 rating)


Jim, May 05, 2022 - 5:34 pm UTC

Thanks, Connor. I'll check with our sales rep, but I'm very happy to hear that there should be no technical problems. And thanks for the prickly response!
Connor McDonald
May 11, 2022 - 5:38 am UTC


More to Explore


Need more information on Administration? Check out the Administrators guide for the Oracle Database