Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy databse

Re: Copy databse

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Thu, 06 May 2004 17:29:16 -0700
Message-ID: <xLAmc.75288$Jy3.32268@fed1read03>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US