Re: Copy databse

On 6 May 2004 14:24:51 -0700, ningli2000_at_hotmail.com (Nick Li) wrote:

>Hi,
>
> I have a database with the SID of "MYDB1". I would like to "copy"
>everything in the database, including schemas, tables, procedures,
>roles, etc and create a new database with a different name, such as
>"MYDB2". Could anyone tell me if there is an easy way to do this?
>
> Thanks in advance.
>
> Nick

Yes, there is. And of course it is documented and of course it's a FAQ, so a little Googling would have provided the answer.

So here goes for the umpteenth time

create a new instance
run alter database backup controlfile to trace in the source instance edit the trace file from the previous step, reflecting the new instance
- shutdown the source database and copy the datafiles or
alternatively
make a hot backup of the source database and restore it at the target - now run the tracefile as a sql script

This is bascally it.

--
Sybrand Bakker, Senior Oracle DBA