Re: Best way to transfer a database?

From: Mark <ars_at_lambic.co.uk>
Date: Thu, 31 Aug 2000 17:06:45 GMT
Message-ID: <39AE9095.DAE3591D@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 - 12:06:45 CDT