Re: easiest way to copy one DB to another?

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 21 Sep 2005 01:48:48 GMT
Message-ID: <Xns96D7BF62D2703SunnySD@68.6.19.6>

"barneytoe" <barneytoe_at_gmail.com> wrote in news:1127254994.480038.216470_at_o13g2000cwo.googlegroups.com:

> I have two ora 9.2 DBs, and simply want to copy one to another. The 2nd
> DB doesn't necessarily have all the same views and such, but I'd like
> to just force it to be an exact copy, if possible.
>
> I do have SYS login capabiltieis on target DB.
>
> Is there an easy way to do this?
>
> I read about sqlplus copy capabilities, but not sure that'll create
> views and users and such.
>
> thanks.
>
> chris
>
>

SHUTDOWN IMMEDIATE and the use OS command (COPY, cp, etc.) to copy all the files to their new directory. Lastly start both DBs.

FWIW - I did a variation of this just yesterday & did not even shutdown the source DB & had a working clone in under 60 minutes. Received on Tue Sep 20 2005 - 20:48:48 CDT