Global Temporary Table support

• 
  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

  Alex B April 04, 2019 19:24

  - 0 +
• 
  Hi Alex, 
  
  Sorry for the delay - waiting for the engineers to take a moment and elaborate the issue.

  jaspernygaard April 09, 2019 17:29

  - 0 +
• 
  Hi @jaspernygaard,
  
  No worries, I'll look forward to your update!
  
  Kind regards,
  Alex

  Alex B April 09, 2019 17:48

  - 0 +

Add comment

Please sign in to leave a comment.