Re: looking for script

nexus987_at_hotmail.com (Michael Green) wrote in message news:<2e5102f0.0208150608.3cfe0b6d_at_posting.google.com>...
> Yes, these are two different machines (but identical hardware & OS)
> about 100 miles apart... dumps are from a cold backup that is
> performed automatically each night.
>
> Basically I'm trying to duplicate the functionality that we have with
> our Sybase servers (where I can just "dump database foo to
> '/path/to/backup/file'" and on the remote server "load database foo
> from '/path/to/backup/file'").

Oracle's exp and imp are very similar to Sybase's dump and load, except that you need to run them outside of the database instance. But it's easier to copy the database. Do a search for "clone database" on metalink. You may find useful scripts there or, at least, step by step instructions.

>
> Seems like something people would want to do fairly often for disaster
> recover, development, and test servers...
Received on Thu Aug 15 2002 - 14:39:16 CDT