Re: Compatible parameter

"DenHang" <reply_toDenHang_at_pi.be> wrote in message news:ah1u66$6d4$1_at_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)?
>
>
>

just change and/or set the compatible parameter in init<sid>.ora and bounce the instance.
Many vendors of commercial software live in the assumption Oracle is Sqlserver sold by a different vendor. You seem to have been exposed to that myth too. Just forget everything you learned about sqlserver and leave your bad sqlserver habits or be prepared to enter hell.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address