Re: Is there a way to clone additonal database ?

just copy all data file including control file, prameter file into different location.
modify your ini file to point to new location of your control file, chage oracle_sid name. and start it up using svrmgrl. Of course you will get error message like can't find data file, Don't worry, startup with no mount option.
issue the following command to modify path of you new datafile:

alter system rename datafile 'filename' to 'new file name';

Make sure owner of oracle datafile is same ( very important); Kenny Lim wrote in message <83cdu6$3ol$1_at_birch.prod.itd.earthlink.net>...
>
>Hi All,
>
>We are currently trying to build 2 additonal test database from the
default.
>(It took us approx 14 hours to build and import the dump file into the
>default database)
>
>So instead of building it from scratch again, we were just wondering is
>there a easier way to duplicate it
>by merely copying the physical files and customize it manually on the
>target.
>
>Any advise would be greatly. Thanks in advance.
>
>Kenny -
>
>
>
Received on Fri Dec 17 1999 - 11:05:36 CST