Partition Swap problem
Hello All,
I'm tryin partition swap a temp table with another FACT table. All the columns, and their datatypes is a 100% match (used WinMerge to check)
But when I try to run the partition swap, I get the below error
SQL Error: ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
14097. 00000 - "column type or size mismatch in ALTER TABLE EXCHANGE PARTITION"
*Cause: The corresponding columns in the tables specified in the
ALTER TABLE EXCHANGE PARTITION are of different type or size
*Action: Ensure that the two tables have the same number of columns
with the same type and size.
The syntax is
alter table FACT EXCHANGE PARTITION MAY_2009
WITH TABLE FIX_200907 INCLUDING INDEXES UPDATE GLOBAL INDEXES
Any help would be greatly appreciated !!!