OCI-11558
IF NOT EXISTS clause cannot be used with the current DDL
Cause
IF NOT EXISTS clause cannot be used with DDL statements that create private temporary tables. Examples: CREATE TEMPORARY TABLE ... Please check the documentation for a list of DDL statements that are not supported.
Action
Do not use IF NOT EXISTS clause for this DDL statement.