Global Temporary Table support

jaspernygaard

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

Alex B

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

Hi Alex, 

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

Alex B

Hi @jaspernygaard,

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

Kind regards,
Alex