Droping a Global Temporary Table

Database
SAP
Enthusiast

Droping a Global Temporary Table

Hi ,

while dropping a global temporay table , i face the below error .

Executed as Single statement.  Failed [5337 : HY000] Drop Table is not allowed due to materialized temporary tables.

Elapsed time = 00:00:00.031

STATEMENT 1: DROP  failed.

How can i drop the table now ? Please help

Tags (1)
1 REPLY
Teradata Employee

Re: Droping a Global Temporary Table

5337   Drop Table is not allowed due to materialized temporary tables.

Explanation:

Drop table is only allowed when the target table is not materialized in any other sessions unless the keyword ALL is specified.

Generated By:

OPT modules.

For Whom:

End User.

Remedy:

Resubmit statement with the keyword ALL.