Re: Best way to transfer a database?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 31 Aug 2000 15:19:54 -0700
Message-ID: <8omlii$sbq$1@spiney.sierra.com>

IMHO, I believe it might be faster to export just structures and grants, etc (no data)
then import the structures, grants, etc, (no data) then create a database link between the two instances and copy (using insert as select from)

I've not tried this but IMP is just so intolerably slow...

"Mark" <ars_at_lambic.co.uk> wrote in message news:39AE9095.DAE3591D_at_lambic.co.uk...
> Sean wrote:
> >
> > I have two Oracle 8i machines : one development, the other production.
> > On the development machine, I have a user called FOO that I need to
> > transfer ALL data, table structures, rights, etc to the production
> > machines.
> >
> > What is the best way to transfer all the database stuff (belonging to a
> > user) from one machine to another?
>
> From dev database:
>
> exp userid=foo/foospassword owner=foo file=foo.dmp
>
> To prod database:
>
> imp userid=foo/foospassword file=foo.dmp full=y
>
> Read your Oracle Utilities manual for more info.
Received on Thu Aug 31 2000 - 17:19:54 CDT