Re: Defrag Database

You can export with the option direct=y, but if You do it on the client, NLS_LANG setting on the client and the server nust be the same ( a path of the speedup is that we avoid conversion between charsets on the server and client )

Regards
Robert

Mitchell Loren wrote:

> I will be defragging about 15% of the 2000+ tables in my prod database
> 7.3.4 (AIX) using exp/imp. I will be putting the DB in restricted mode
> for the shortest possible time. Does anyone have any performance
> suggestions for speeding up the process ( exp/imp parameters, etc.)?
> Order of rebuilding objects.
>
> Also, and more importantly, what steps do I need to take to assure read
> consistency ? Any suggestions are appreciated.

--

Robert Liziniewicz                    C.I. HTS-ComArch
Robert.Liziniewicz_at_ci.comarch.pl      ul. Ujastek 10, Krakow
                                      tel. (+48 12) 644-66-31
                                           (+48 601) 47-86-81