Howto Create global temporary table in Oracle 8.0.5

Hi Guys,

I did create a temporary table in Oracle 8i without any problem.
However, How can I create a temporary table in Oracle 8.0

CREATE GLOBAL TEMPORARY TABLE table
(a RAW(8),b RAW(8))
ON COMMIT DELETE ROWS; I executed this statement
and I got this error

ERROR at line 1:
ORA-00901: invalid CREATE command

It looks like a new feature in Oracle 8i

How can I create a temporary table in Oracle 8.0?

Thank you very much
Claude
ciao Received on Wed Dec 14 2005 - 16:02:45 CST