Unable to read from Global Temporary table

[swati_rastogi27]

Hi ,

I have a data view with complex joins, so instead of reading from view , I want to dump data into a global temporary table and read from it.

I used below statement to create the same:

CREATE GLOBAL TEMPORARY TABLE SCHEMA.V_COMPLEX_VIEW_GTT

ON COMMIT PRESERVE ROWS AS (

SELECT * FROM SCHEMA.V_COMPLEX_VIEW where 1=2

);

When I try to read from this table , I get an error stating , 'Driver not capable'

Please help

[swati_rastogi27]

Any clue anyone?