Re: How to copy a complete tablespace ?

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

>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!

I'm going to assume that you actually want to get a mirror image of the entire instance. What I'll explain to you is explained in the Backup & Recovery Manuals.

You can write a script to "ALTER TABLESPACE data [ BEGIN | END ] BACKUP" -- where data is each of your tablespaces. Then backup a copy of the controlfile to a trace file, edit it to point to alternative file locations, and recover the database.

Alternatively, you can just export/import the data. --
Barth Siemens
Change the email address from nospam to barth. Received on Tue Mar 30 1999 - 08:40:23 CST