Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PUBLIC:Re: fragmentation
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-8643Received on Fri Jan 23 1998 - 00:00:00 CST