Re: Questions about Import/Export

In that case, do your import as is and include "ignore=y" in the command call. This will not report any 'create table' errors and will then proceed to insert the rows into the tables.

Alan
Dino Hsu <dino1_at_ms1.hinet.net> wrote in message news:8lev7t$4ad4a$1_at_ID-41926.news.cis.dfn.de...
> 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 Tue Jul 25 2000 - 00:00:00 CDT