Re: rename table

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: oracledbam@xxxxxxxxxxx
  • Date: Mon, 11 Oct 2004 10:16:26 -0400

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

Other related posts: