EXCHANGE PARTITION in Oracle8i

Hi

We've to move data from a preload area (invisible for end users) to a productive area (visible to end users). We developed under Oracle8.0 and used the ALTER TABLE EXCHANGE PARTITION command (because we've partitioned tables). This worked very well. Now we've upgraded to Oracle8i and the same command lasts hours (instead a few seconds in Oracle8.0). Has somebody any advice why this effect happens ? We use the EXCHANGE PARTITION EXCLUDING INDEXES and WITHOUT VALIDATION (that's normally the fastest way).

We can't use INSERT INTO command because our tables have more than 20'000'000 rows and size between 3 and 5 GB a partition.

Thanks for any reply.

René Received on Sun Oct 21 2001 - 15:41:25 CDT