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

SQL-02122: Invalid OPEN or PREPARE for this database connection

1 Answers  


ORA-33022: (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.

1 Answers  


ORA-38718: Invalid thread number specified in the DUMP FLASHBACK command.

1 Answers  


DRG-50947: ABOUT clause not allowed without a theme index

1 Answers  


ORA-01654: unable to extend index string.string by string in tablespace string

1 Answers  






ORA-27158: process control failure

1 Answers  


ORA-12509: TNS:listener failed to redirect client to service handler

1 Answers  


PCC-02035: CMD-LINE: CONFIG= option is invalid in a config file

1 Answers  


RMAN-06493: only UNTIL TIME clause is allowed when performing a restore from autobackup, found: string

1 Answers  


SQL-02136: Invalid NCHAR character set id

1 Answers  


RMAN-06707: could not initialize for output file: "string"

1 Answers  


ORA-30695: JDWP message format problem

1 Answers  


Categories