Re: Database reorg question

You can export all other objects except the tables which you want to get reorganized. After the tables are reorganized. You can import back all other objects. I think this should work.

regards
vittal gh

Tony de Lange wrote:

> I have sent you a script to try. Contact me if it is not received.
> tony.delange_at_alusaf.com
>
> hpdba wrote in message <352A07CE.CF2513A8_at_yahoo.com>...
> >I would like to automate our database reorgs, mainly for tables that
> >have many extents or chained rows. I think I can come up with a process
> >that identifies the tables that need reorganized and what action to take
> >on them. The problem is that the process usually requires an export,
> >drop table, and import. When the table is dropped you loose triggers on
> >the table, views become invalid and need recreated, and referential
> >constraints from other tables need rebuilt. I want to write scripts that
> >query the data dictionary and dynamically create the scripts for
> >recreating views, triggers, and constraints.
> >
> >Based on your experience, do you think this is do-able? Is it dangerous
> >because of the possibility of missing something? How do you normally
> >handle these kinds of reorgs? Do you normally have a set of scripts that
> >you use to rebuild the constraints, views, and triggers for each table?
> >Is it unrealistic to expect to automate this process in the manner I
> >have described?
> >
> >Thanks!
Received on Thu Apr 08 1999 - 01:48:39 CDT