Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy databse
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
Backup controlfile to trace,
Shut down MYDB1,
copy all the files to new locations,
edit the tracefile from step 1
open MYDB2
Received on Thu May 06 2004 - 19:29:16 CDT
![]() |
![]() |