olocal wrote:
> Hi all,
>
> What is the best method to refresh a development database on different
> box from production database ?
>
> There is hot backup running daily and the databases are in archivelog
> mode. The production database now reaching 140G although it's actually
> size only 60%, we don't use autoextend here.
>
> I am wondering here, whether can we able to clone the production
> environment by partially ? What I mean here is we copy some of
> necessary tablespaces like system while other make them offline and
> bring the database. Then step by step copying the rest of the
> tablespaces and resize them accordingly. The main purpose is due to
> space limitation as we don't have identical disk space.
>
> Let me know if I haven't describe the situation clearly !
>
> thank you.
>
Transportable tablespaces.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Oct 21 2003 - 10:23:59 CDT
