did you recompile all invaldiated objects? maybe that is causing problem in addition to all new privilege checks, re-parsing etc. Raj On Mon, 11 Oct 2004 10:10:20 -0400, Seema Singh <oracledbam@xxxxxxxxxxx> wrote: > Hi, > I have some issue with rename. > > There are 2 tables which I want to rename.Let us name as table1 and table2. > The moment I renamed these tables the site became slower.AFter rename I > rebuilded indexes and validate structure too.But still I noticed site > slower.The only diffrent I noticed the diffrent name of indexes.aNy thought > ???? > thanks > -Seema -- //www.freelists.org/webpage/oracle-l