Forum Stats

  • 3,782,538 Users
  • 2,254,661 Discussions
  • 7,880,110 Comments

Discussions

ORA-00406 Altering table adding colunm

567959
567959 Member Posts: 9
edited Oct 20, 2008 2:03PM in General Database Discussions
Hi,
I have two databases in diferent servers:

database A oracle 10g compability 9i
database B oracle 10g compability 9i
I execute the following comand in both databases but the result was diferent:

Database A:
alter table maip.tmaitip0 add(ct_afl number(1));

table altered...

Database B:
alter table maip.tmaitip0 add(ct_afl number(1));

ORA-00406: COMPATIBLE parameter needs to be 10.0.0.0.0 or greater
ORA-00722: Resource "Add/drop column for compressed tables"

The databases are the same an the table structures too.
Can any body give me a help?

Thanks
Jose Luis Suarez
DBA
Tagged:
«1

Answers

This discussion has been closed.