OraFAQ Forum: Server Administration » ORA-0406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater.

Home » RDBMS Server » Server Administration » ORA-0406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-0406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater. [message #60688]

Wed, 25 February 2004 23:06

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi,

I'm runing on Oracle 8i Release 8.1.7.2.0.

In my Initialization parameters file I have for the "COMPATIBLE" parameter the value: 8.1.5.0.0.

I received this ORA-00406 error message when trying to:

ALTER TABLE table_name STORAGE (FREELISTS 5);

I have 5 processes performaing heavy insert in 2 of my tables and this can help me maybe to increase the performance on these tables (as space on disk is not an issue here).

Do I have just to update this COMPATIBLE init parameter? Is it just ok to update the value from 8.1.5.0.0 to 8.1.6.0.0? Or it would bring or generate�some drawbacks or other problems?

My tables are on tablespaces of type Locally Managed Tablespace: I thought that with such LMT tablespaces, the storage parameters in the STORAGE clause couldn't be altered or decided at creation time?

Thank you for your help!

Regards,

Patrick Tahiri.

Report message to a moderator

Re: ORA-0406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater. [message #60690 is a reply to message #60688]

Thu, 26 February 2004 02:20

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

It would be best to set COMPATIBLE to 8.1.7.0.0 and get it done with. The Migrations Guide documents what additional features are enabled at each compatibility level.

Steps:

1. Add the "COMPATIBLE=8.1.7.0.0" parameter to your INIT.ORA file.

2. SQL> SHUTDOWN IMMEDIATE

3. SQL> STARTUP

For additional info, read chapter 9 "Compatibility and Interoperability" of the Oracle8i Migration Guide.

Best regards.

Frank

Report message to a moderator

Re: ORA-0406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater. [message #60691 is a reply to message #60690]

Thu, 26 February 2004 02:27

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Thank you for your answer!

Just something else: Can we define the STORAGE clause and especially FREELISTS on objects within a tablespace that is Locally Managed Tablespace?

ALTER TABLE table_name STORAGE (FREELISTS 5);

and this table is on a locally managed tablespace. Is it possible with LMT?

Many thanks again.

Regards,

Patrick Tahiri.

Report message to a moderator

Re: ORA-0406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater. [message #60693 is a reply to message #60691]

Thu, 26 February 2004 02:47

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Yes, you can. Look at this example:

SQL> create tablespace x datafile '/tmp/x.dbf' size 5M extent management local;

Tablespace created.

SQL> create table tab_x (a date) tablespace x;

Table created.

SQL> alter table tab_x storage (freelists 5);

Table altered.

SQL> drop tablespace x including contents and datafiles;

Tablespace dropped.

BTW: You might want to use "SEGMENT SPACE MANAGEMENT AUTO" instead of FREELISTS.

Best regards.

Frank

Report message to a moderator

Re: ORA-0406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater. [message #60696 is a reply to message #60693]

Thu, 26 February 2004 03:02

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Thank you very much!!

Regards,

Patrick Tahiri.

Report message to a moderator

Previous Topic:	DBUA vs Manual upgrade from 8i to 9i.
Next Topic:	difference among DATABASE NAME / GLOBAL DATABASE NAME / SID / SERVICE NAME / INSTANCE NAME

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:54:01 CDT 2024