Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reorganizing tables (next extents)
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 Received on Fri Apr 30 2004 - 07:18:15 CDT