Re: Questions about Import/Export

Hi Dino,

Export/Import is a valid method of defragging your database as upon import, all the blocks are 're-packed' with data hence getting rid of wasted space.

On the second point, if you're going to get rid of objects from various schemas, wouldn't you be better off exporting the db but only importing the schemas that you wish to retain? (maybe I've misunderstood the second point)

Regards,
Alan Barker
Dino Hsu <dino1_at_ms1.hinet.net> wrote in message news:8l9peq$3vm78$1_at_ID-41926.news.cis.dfn.de...
> Dear All,
>
> I have questions about import/export:
> 1.I am told that we can improve the performance of a database by exporting
> the database and then importing it back when the database is too
 fragmented
> after many DML operations. Do you think so? Is this an appropriate way? My
> experiment gives a performance increase of about 10%.
> 2.If we want the import (of the whole database) to be quick and I want to
> drop all schema objects (using a stored procedure with dynamic SQL) before
> the import, what types of shema objects should be droped in addition to
> tables?
>
> I am using Oracle 8.0.5 for Windows NT4, thanks in advance.
>
> Regards,
> Dino
>
>
>
>
Received on Sat Jul 22 2000 - 00:00:00 CDT