Need urgent help...

I am trying to make a change in one column (primary key). I dropped
the primary key which dropped other 2-3 foreign keys referencing this
column.

I made the changes.

Re-built Primary key as well as Foreign keys which were dropped.

Now, many packages were invalid. So, I did rebound all those packages.

After all these, I tried to run RUNSTATS (with distribution and all
indexes) on all tables and it is taking LOOOOOONG time than it used to
take usually (all tables are taking loooong time including those
tables which are NOT at all involved in this change).

Can anyone help me in understanding this and to overcome this looong
time runstats PLEASE?

"Kumar" <kumar@tumkurcity.com> wrote in message
news:2fa6f746.0405101225.abd8d2f@posting.google.co m...[color=blue]
> Need urgent help...
>
> I am trying to make a change in one column (primary key). I dropped
> the primary key which dropped other 2-3 foreign keys referencing this
> column.
>
> I made the changes.
>
> Re-built Primary key as well as Foreign keys which were dropped.
>
> Now, many packages were invalid. So, I did rebound all those packages.
>
> After all these, I tried to run RUNSTATS (with distribution and all
> indexes) on all tables and it is taking LOOOOOONG time than it used to
> take usually (all tables are taking loooong time including those
> tables which are NOT at all involved in this change).
>
> Can anyone help me in understanding this and to overcome this looong
> time runstats PLEASE?[/color]

Probably running short of space on system temporary tablespace. Other things
to look at include the sortheaps.

"Kumar" <kumar@tumkurcity.com> wrote in message
news:2fa6f746.0405101225.abd8d2f@posting.google.co m...[color=blue]
> Need urgent help...
>
> I am trying to make a change in one column (primary key). I dropped
> the primary key which dropped other 2-3 foreign keys referencing this
> column.
>
> I made the changes.
>
> Re-built Primary key as well as Foreign keys which were dropped.
>
> Now, many packages were invalid. So, I did rebound all those packages.
>
> After all these, I tried to run RUNSTATS (with distribution and all
> indexes) on all tables and it is taking LOOOOOONG time than it used to
> take usually (all tables are taking loooong time including those
> tables which are NOT at all involved in this change).
>
> Can anyone help me in understanding this and to overcome this looong
> time runstats PLEASE?[/color]

Probably running short of space on system temporary tablespace. Other things
to look at include the sortheaps.