Extending Global Temporary Tables

You might not need to extend the Global Temporary tables as the out-of-the-box table itself contains multiple flexible columns. Each GTT and RM table contains:

  • 15 columns of type VARCHAR2 (4000)
  • 4 columns to support DATE fields. The data type is VARCHAR2(8)
  • 2 clob columns

You can fill these columns by using user exits.