Re: Creating new database.

Any DBA can clone an existing instance. But there are some terrible prices to pay:

1. Inability to resize and redistribute objects based on historical experience.
2. Inability to convert tablespaces from dictionary managed to locally managed
3. Inability to learn new skills
4. A stagnant resume that will make it harder for you to get your next job.

You are being handed a plum. Eat it!

Daniel Morgan

Richard Nield 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.
Received on Wed Feb 20 2002 - 17:01:00 CST