Some questions about oracle, partitioning, etc

Hello !

I have a few questions :

1. The partition exchange load ( PEL ;) ) may work fine, but what if you have more than 1 table ? for example tables T1 and T2. a- load into a staging table for T1 AND for T2, b- exchange the staging tables with subpartitions from T1 AND T2. If a fails, there is no problem, T1 and T2 have not been altered. BUT if b fails between the 2 exchanges ? T1 for example would be altered, while T2 no, thus leaving the database in a bad state. What can we do to avoid this ?
2. Is there a way of testing a partition exchange before actually making it ? If the indexes do not match exactly, then the exchange is rejected, I would like to test it before being rejected !
3. I don't understand this one : I have a program that : a- loads data to a staging table 'ST' using SQL*Loader Direct Path/Parallel b- loads data from 'ST' to target table 'TT' using the sql statement : "INSERT INTO TT SELECT * FROM ST" c- drops the table 'ST' d- crashes before ending the transaction (NO commit) Since there is NO commit, an automatic rollback is done, the target table shouldn't be altered, but actually it is ! And the most spectacular thing is that if I do not perform step c, everything behaves normally : the target table is not altered. I really do not understand what's happening here... Why the fact of not droping a table can influence a rollback ?

Thanks in advance for your thoughts and suggestions !!

SergGioGio Received on Thu Jul 18 2002 - 04:55:39 CDT