Re: Problem for partition exchange

I think this is a bug I came across about a year ago. In my case I found that repeating the command immediately would make the exchange take place. Not the nicest workaround for a production system - so you may want to upgrade to 8.0.5

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Project Account(Dr. D. Cheung and pshek) wrote in message <78prcr$3rd$1_at_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:30:01 CST