Re: rename table

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 11 Oct 2004 10:16:26 -0400
Message-ID: <9177895d04101107165f1216fc@mail.gmail.com>

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_at_hotmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 11 2004 - 09:11:57 CDT