ORA-14643: Hakan factor mismatch for tables in ALTER TABLE
EXCHANGE PARTITION



ORA-14643: Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION..

Answer / guest

Cause: Either records_per_block has been minimized for one
of the tables to be exchanged, but not the other, or the
hakan factors for the tables to be exchanged are not equal.

Action: If records_per_block has been minimized for one of
the tables, but not the other, either perform alter table
with the NOMINIMIZE RECORDS_PER_BLOCK option for both
tables, or perform alter table with the MINIMIZE
RECORDS_PER_BLOCK for both tables. If the hakan factors do
not match perform alter table with the NOMINIMIZE
RECORDS_PER_BLOCK option for both tables.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12012: Proxy authentication failed - retry?

1 Answers  


LCD-00112: illegal integer radix specification [string]

1 Answers  


ORA-01581: attempt to use rollback segment (string) new extent (string) which is being allocated

1 Answers  


ORA-07279: spcre: semget error, unable to get first semaphore set.

1 Answers  


ORA-25010: Invalid nested table column name in nested table clause

1 Answers  






DRG-11125: invalid format of existing log file string

1 Answers  


ORA-22619: all collection elements have already been accessed

1 Answers  


ORA-01071: cannot perform operation without starting up ORACLE

1 Answers  


LSX-00022: unknown namespace prefix "~S"

1 Answers  


QSM-00772: the specified SQL statement cannot be stored in the workload due to a statement error

1 Answers  


ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

1 Answers  


PLS-00122: %s as separator is allowed only with specific built-in functions

1 Answers  


Categories