Global Temporary Table support

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

Answers

  • Alex BAlex B Posts: 804 Diamond 2
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • jaspernygaardjaspernygaard Posts: 38 Bronze 1
    Hi Alex, 

    Sorry for the delay - waiting for the engineers to take a moment and elaborate the issue. 
  • Alex BAlex B Posts: 804 Diamond 2
    Hi @jaspernygaard,

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

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.