Re: Restore with new name

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 14 Feb 2005 17:57:42 GMT
Message-ID: <qE5Qd.4877$aW6.2785@newssvr22.news.prodigy.net>

David Gray wrote:

> Hi all,
>
> Oracle 9i
> Windows advanced server 2000
>
> I would like to test if a cold backup of a 9i database is usable once
> restored. Once restored I would like the database to have a new name
> so that it does not interfere with the live instance.
>
> Very new to Oracle so don't really have a clue where to begin. The
> only parameter that's obvious is the db_name...
>
> Any or pointers on how begin greatly received.
>
> Cheers
> Dave.

Check the documentation for the DBNEWID utility.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch14.htm

-- 
Mark Bole
http://www.bincomputing.com

Received on Mon Feb 14 2005 - 11:57:42 CST