I have a create temporary table command in Oracle that has worked in the past but now I'm getting the following error:
SQL Error: ORA-14459: missing GLOBAL keyword
14459. 00000 - "missing GLOBAL keyword"
*Cause: keyword GLOBAL is missing while creating temporary table.
*Action: supply keyword.
I am not an admin on the database, just a user with read only priviledges
Sql looks like this:
DROP TABLE IF EXISTS t1
CREATE TEMPORARY TABLE t1(
SELECT DATE(a.thedate) AS thedate, etc. etc.)
Thanks for any assistance!