Re: Copy Prdoduction database to Test database on different machine

h.pool_at_nibble.nl (Herman Pool) wrote in message news:<7ba6eb1a.0402050648.6c2a10f3_at_posting.google.com>...
> Hi all,
>
> I want to make a copy of the production database to a different
> machine and then reload the database for testing purpose.
> This must be done during the night when nobody is on the production
> system.
>
> On both machines:
> OS: Linux RH 8.0
> Oracle: 9.2.0.1
> Same directory structure.
>
> Which steps do I have to take or which scripts do I have to run?
>
> With kind regards,
>
> Herman Pool

Look up transportable tablespace and see if it meets your needs.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=100693.1

jg

--
@home.com is bogus.
http://members.iinet.net.au/~bofh/index.html