Compatible parameter

From: DenHang <reply_toDenHang_at_pi.be>
Date: Tue, 16 Jul 2002 22:04:39 +0200
Message-ID: <ah1u66$6d4$1@reader11.wxs.nl>

When I try to create a temporary table (using CREATE GLOBAL TEMPORARY TABLE...) I get the following error:
ORA-00406: COMPATIBLE parameter needs to be 8.1.0.0.0 or greater

I'm getting this error using SQL plus and Pl Sql developer and I installed Oracle 8i release 3.

Is it wise to change that parameter and how can I change it? Is there may-be another way to create temporary tables (eg. like in Ms Sql where you can create temp tables local to a session using # in front of the tablename)? Received on Tue Jul 16 2002 - 15:04:39 CDT