Global Temporary Table support

jaspernygaard · April 3, 2019 11:06AM

Any plans to support global (or private) temporary tables i SCO?

Alex B · April 4, 2019 7:24PM

Hi @jaspernygaard,

In what way are Global temporary tables not supported? I just created one as this:

CREATE GLOBAL TEMPORARY TABLE abGlobalTempTable
(
  id int primary key not null, 
  asdf varchar(20) null
) ON COMMIT PRESERVE ROWS;

and in Schema Compare for Oracle 5.2.2 it shows as:

In this case it's in the SYSTEM schema, but I also checked created one under a schema as well:

CREATE GLOBAL TEMPORARY TABLE AB134701.abGlobalTempTable
(
  id int primary key not null, 
  asdf varchar(20) null
) ON COMMIT PRESERVE ROWS;

and it showed up under that user.

If you can provide an example of how this isn't working please let me know!

Kind regards,
Alex

jaspernygaard · April 9, 2019 5:29PM

Hi Alex,

Sorry for the delay - waiting for the engineers to take a moment and elaborate the issue.

Alex B · April 9, 2019 5:48PM

Hi @jaspernygaard,

No worries, I'll look forward to your update!

Kind regards,
Alex

Answers