Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 401 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
ORA-00406 Altering table adding colunm
567959
Member Posts: 9
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
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
Answers
-
This is what is mentioned for the error,
ORA-00406: COMPATIBLE parameter needs to be string or greater
Cause: The COMPATIBLE initialization parameter is not high enough to allow the operation. Allowing the command would make the database incompatible with the release specified by the current COMPATIBLE parameter.
Action: Shutdown and startup with a higher compatibility setting.
The databases of 10g , if started with compatible value of 10 tan they can'tbe downgraded to previous value.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref417
You need to change this parmater's value to 10.0.0 or higher.
HTH
Aman.... -
I can´t change the compatibility is necessary run in 9i
My question is why in one database run normally and in the other one send this error
the databases suppose to be equal?
Regards
Ze -
Ze,
In DBA_REGISTRY, are the version of components equal in both databases?
select comp_name, version from dba_registry;
MR -
MR,
yes, the versions are equal:
Oracle Database Catalog Views 10.2.0.1.0
Oracle Database Packages and Types 10.2.0.1.0
Oracle Enterprise Manager 10.2.0.1.0
Ze -
I would venture that you need to uncompress the table then add the column and then compress the table again.
-
Hi,
I tried
alter table maip.tmaitip0 nocompress
but the error continue.
another sugestions?
thanks
Ze -
Hi,
Can you check the output of the below query in both the databases if not partitioned else use user_tab_partitions.
SELECT table_name,
compression,
num_rows,
blocks,
empty_blocks
FROM user_tables where table_name = <your_table_name>
Regards
Anurag Tibrewal -
Hi,
the result was:
database A:
TMAITIP0,DISABLED,14,5,0
database B:
TMAITIP0,DISABLED,,,
the database with the problem is B.
Ze -
Hi,
We are sure that this is not a partitioned table because you used user_tables instead of user_tab_partitions.
Regards
Anurag Tibrewal -
Hi,
Moreover you may have to look at the bug 2421054 in metalink.
Regards
This discussion has been closed.