Re: Copy databse

ningli2000_at_hotmail.com (Nick Li) wrote in message news:<bfc81ac6.0405061324.623cbc2_at_posting.google.com>...
> 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

Apologies if this is duped, google posting seems weird today.

Aside what the other's said, check out the RMAN docs.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=228257.1

jg

--
@home.com is bogus
http://centennialchallenges.nasa.gov/