Global temporary Table

Database
SAP
Enthusiast

Global temporary Table

Hi ,

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 !!!

2 REPLIES
Enthusiast

Re: Global temporary Table

Eve using the keyword  ALL at the end?

use ON COMMIT PRESERVE ROWS at the end .

SAP
Enthusiast

Re: Global temporary Table

DROP using ALL worked out . Thanks Raja !!!