Re: How do I copy a database?

[Quoted] Try doing this on the cold database would be easiest.

Not sure if a direct file-copy is valid where byte-orders are concerned on different platforms, but you could try it. If that works, then that's the easiest. You'd need to make new control files. Basically, treat is as a clone and see how you get on.

If not, export/import can be done.

Andrew

Håkan Wahlberg <hakan.wahlberg_at_boliden.se> wrote in message news:39059B1E.7BC4BA99_at_boliden.se...
> On a regular basis I want to copy a production database with all users,
> all the grants, triggers,
> objects etc, from a Linux server to a (local) NT server.
> How do I do that? Snapshots? Replication or ...?
>
> The idea is to have the local database for testing and debugging
> purposes,
> so it should be identical to the original database and always reflect
> any changes
> made.
>
> TIA
> /Håkan Wahlberg
>
Received on Tue Apr 25 2000 - 00:00:00 CEST