Re: Questions about Import/Export

Alan,

On the second point, I don't mean to get rid of any objects. But if I don't drop the objects before importing, the import program will complain about something like SQL xxx failed because the object already exists.

Dino

Alan Barker <Ajb1_at_nextcentury.com.au> wrote in message news:Z75e5.328$l3.665_at_news.syd.ip.net.au...
> 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 Sun Jul 23 2000 - 00:00:00 CDT