Re: How do I copy a database?

Andrew Williamson <andrewweb_at_my-deja.com> schreef in berichtnieuws 956674195.26804.0.nnrp-13.c30bdde2_at_news.demon.co.uk...
> 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
> >
>
>
Any cross platform action requires export/import.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Apr 25 2000 - 00:00:00 CEST