Copying user and all data

From: Tommy Nordvik <tommy_at_fossekall.ii.uib.no>
Date: 26 Aug 1998 09:24:23 GMT
Message-ID: <6s0k87$ddv$1@toralf.uib.no>

I have schema with 4 tables. I would like to copy this schema to x number of different Oracle servers, set up identical to the main machine where I want to copy the data from.

So far I'm using export/import. My problem is that I have to delete the old data before I can import the tables with the new data. In case the import failes I should have a backup of the old data. How should I go about doing this?

Is it possible to copy the datafiles instead of using export/import?

TIA
-Tommy

(if it's not too much trouble please cc a reply to: tommy_at_ii.uib.no) Received on Wed Aug 26 1998 - 04:24:23 CDT