"FlameDance" <flamedance_at_gmx.de> wrote in message
news:c6tg6f$op$01$1_at_news.t-online.com...
> Jim Kennedy wrote:
>
> > If you don't want LMT's and I understand the owner's concern. But why
are
> > you reorganizing? Most of us have plenty of useful things to do.
>
> The existing huge initial values of up to 1.7GB give us problems when
> exporting/importing into the backup database. These days we import the
> big tables first, one by one, making sure each fits into a datafile,
> then import the rest ... it's a hassle that we want to get rid of.
>
> I wrote a little 40-line PL/SQL procedure that generates a script that
> does it for all tables, so the main task is already done. Now I'm
> looking to optimize the storage parameters on a per table basis before
> actually executing the script on the production databasse.
>
> Stephan
One doesn't use export and import to backup a database. If you want to
optimize the storage then make them all the same size, the extents that is.
Jim
Received on Fri Apr 30 2004 - 23:07:22 CDT
