How do I create a Temporary Table in Oracle 8.1.7

[JONBOY74]

Hi all

I'm trying to create a Global Temporary Table like so:

CREATE GLOBAL TEMPORARY TABLE
TEST (NAME, CHAR (10))
ON COMMIT PRESERVE ROWS;

But I get the error below, why & how to I get round it?

ORA-00406:COMPATIBLE parameter needs to be 8.1.0.0.0 or greater


Many Thanks

Jon

 

[binjovi]

Check the compatibilty parameter..

May be oracle system is not allowing this operation since the compatibility specified is of ower version...

Try to change the compatibilty parameter It may work

bins

 

[lfoata]

The compatible paramter is set in the initSID.ora file, which you may find in $ORACLE_HOME/dbs.