Re: Questions about Import/Export

Andrew,

Are you really sure that dropping the database is the easiest way? To drop a database, remove its datafiles, redo log files, and all other associated files (control files, parameter files, archived log files). (Administractor's Guide) Even if dropping the database is easy, creating a database is never as easy, it may take a long to allocate tablespaces.

Maybe your idea is that the import program will create all the tablespaces back, for this point I have to confirm.

Regards,
Dino

Andrew Williamson <andrewweb_at_my-deja.com> wrote in message news:964439943.2657.0.nnrp-02.c30bdde2_at_news.demon.co.uk...
> Is dropping the entire database and recreating not an option for some
> reason? This would be the easiest way, full database export/import. All
 you
> need to do is create the basic database, and import the whole lot.
>
>
> > > 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
> <snip>
>
>
Received on Tue Jul 25 2000 - 00:00:00 CDT