Re: Making a copy of a database

<trubyn@aol.com> wrote: :Can anyone suggest a technique for copying an OnLine database to the :same server? :An archive attempts to restore to the dbspace - I don't know if this :can be overridden. I don't think so. You could however set up another instance and restore the database into that. But ... :A tbunload/tbload is OK, but the copy database will have been re-blocked :and defragmented, and therefore not an exact physical copy of the :original. ... how exact do you want it to be. It seems like you want the same data to be in the same place with fragmented extents and everything. Again by setting up another instance of your server with exactly the same physical disk layout you *might* be able to use dd to copy the data from one to the other. I wouldn't rely on it for anything but testing out something, and wouldn't want to run anything production oriented on the instance that has been using such copied data. Nils.Myklebust@idg.no <- New E-mail adress NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company