Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any clue anyone?