Re: Creating new database.

On Wed, 20 Feb 2002 10:29:10 -0000, "Richard Nield" <richard.nield_at_ntlworld.com> wrote:

>Hi...
>
>we have an oracle database in which we hold stock, transaction and contract
>data for several large stock holding warehouses, for accounting purposes.
>Each year we freeze the old db and start a new one. This is the first year
>I have been involved in the creation of the new db....the dba has said he
>will create the database, but I will have to provide the scripts to create
>the tables, indexes and constraints. my question is, should he not have a
>way of cloning the old database to make the new - especially as most of the
>data is copied from the old to the new?
>
>We are using oracle 8i.....I original database was created using designer in
>1999.
>
>
>Hope that make sense! many thanks for any advise.
>
>
>
>

The procedure to clone a database is floating all around over the internet, in usenet groups, in oramag articles, and if you have rman you can do it using rman, and it is document in the RMAN manual. Other than that you can of course run an export with rows=n

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 20 2002 - 09:51:06 CST