Re: Clone questions

Dale wrote:
> I hope this is the right forum for this. If not, please point me elsewhere.
>
> I'm a newbie with Oracle administration and I'm tasked with cloning our
> production database and starting it up as a development database.
>
> I have a few books on Oracle and have read enouhg (I hope) to tackle the
> problem using the procedure outlined at
> www.dba-oracle.com/oracle_tips_db_copy.htm. The procedure seems straight
> forward enough, but I have two questions that I can't answer from my reading
> (or at least can't find in my books):

I wouldn't trust it.

Assuming 9i or 10g my recommendation wold be to create a new database from scratch. Then use transportable tablespaces to move the data.

To really help you we need to know:

1. Oracle version and edition
2. Number of tablespaces
3. Size of data files
4. Number of schemas
5. Other similar metrics

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)