I am facing two issues on using global temporary tables
1. Unable to drop a global temporray table . It says that :-
Drop Table is not allowed due to materialized temporary tables
2. I am unable to see the rows inserted into global temporary table . Is it because i didnt use ON COMMIT PRESERVE ROWS .
Thanks in advance !!!