Problem for partition exchange

From: Project Account <hpgs_at_cs.hku.hk>
Date: 28 Jan 1999 14:14:51 GMT
Message-ID: <78prcr$3rd$1@www.csis.hku.hk>

I use Oracle 8.0.3 (Enterprise). When I try to exchange a partition of a partitioned table with an external table(with exactly the same layout and indexes) by issuing the following commands...

ALTER TABLE TBL_A EXCHANGE PARTITION TP_TEST WITH TABLE TBL_EXT INCLUDING INDEXES WITH VALIDATION; There's always an error stating that there's type mismatch. I am 100% sure the layout and everything is correct. but when i issue:

ALTER SYSTEM FLUSH SHARED_POOL; the exchange will be successful. i want to now why coz the above command will make other running SQLs (mostly doing CREATE TABLE AS SELECT ...) die away...

thx for ur help...

shek Received on Thu Jan 28 1999 - 08:14:51 CST