Re: Creating new database.

From: Dale Edgar <dale_at_databee.com>
Date: Fri, 22 Feb 2002 18:22:10 GMT
Message-ID: <3c768bfe.12457440@news.btclick.com>

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?

If you have to create the scripts to create the new database you might want to check out the freeware DBATool which can easily generate them for you. http://www.databee.com/dt_home.htm

Regards
Dale Received on Fri Feb 22 2002 - 12:22:10 CST