Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00406 Altering table adding colunm

567959Oct 20 2008 — edited Oct 20 2008
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 17 2008
Added on Oct 20 2008
#database, #error, #general-database-discussions, #table
11 comments
1,827 views