Re: PUBLIC:Re: fragmentation

From: Jerry Gitomer <jgitomer_at_p3.net>
Date: 1998/01/23
Message-ID: <34C9630B.6FD9@p3.net>#1/1

Uh, Eugen

You are right. I am so used to editing the scripts so that I can move things around and put them in different tablespaces that I forgot that just doing a straight export and import will result in coalesced space. When I am not reorganizing I prefer to turn spooling on with a file as the destination, do a select *, and then use SQL*Loader to restore the data.

Jerry

-- 
Jerry Gitomer        Computers and cameras
jgitomer_at_p3.net      One for the money, one for the fun
610/277-8643

Received on Fri Jan 23 1998 - 00:00:00 CST