Re: How to copy a complete tablespace ?

From: <dean.reynolds_at_home.net>
Date: Wed, 31 Mar 1999 15:33:22 GMT
Message-ID: <37023ef0.2546361@news>

I am running Oracle 7.3 on NT and I have to keep dev/prod instances pretty current. We don't use any kind of replication features because our developers need performance speed. We also run these databases in NOARCHIVELOG mode.

One of the databases I have set up runs like this:

I have the production instance up and running. I set up a second machine and configure the drives in the same fashion as the first.

I bring down the production instance and use WinZIP to zip up all the datafiles(and the init,log, and ctl files).

I bring the production instance back up, copy the zipped files to the new machine, unzip them, make sure my LISTENER and TNSNAMES are set up right, bring up the dev instance.

Not a great choice for a production database, but for a development database it's wonderful. I (or the developers) can completely screw up the database and I can have it restored in no time. An import of the same database takes over 16 hours!

-Dean

---

I don't live in Germany anymore, but check out PRIMAVERAS if you make it to Augsburg.

On Tue, 30 Mar 1999 11:21:42 +0200, "Carsten Schmitz" <c.schmitz_at_kps.de> wrote:

>Hello !
>
>
>Just a beginner question!
>
>How do I copy a complete tablespace to another.
>We are running here a Oracle DB on Windows NT wich is always in use. I
>created a new tablespace for development and now I want to
>create an exact copy of the tables in the running tablespace so I'm able to
>mess around with these tables without damaging nothing original!
>
>
>Any help would be very appreciated,
>
> Sincerely
> Carsten Schmitz
>
>
Received on Wed Mar 31 1999 - 09:33:22 CST