>>1. For SQLs using RBO, the plan for the existing SQL won''t change, >>right? As oracle says no change for RBO since oracle 7.3. > >Wrong. You could see some differences. Let me precise this point...=20 There are two reasons that lead to different execution plans with the = RBO: 1) Differences in the optimizer itself. 2) The indexes of the new database are not created in the same order as = the indexes of the old one. -- //www.freelists.org/webpage/oracle-l