Better to use a direct path export (direct=Y). This is faster, though not
terribly so.
"Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote in message
news:8omlii$sbq$1_at_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 Tue Sep 05 2000 - 04:54:00 CDT
