Re: How to copy a complete tablespace ?

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Tue, 30 Mar 1999 21:35:23 -0500
Message-ID: <7ds1gt$3li$1@autumn.news.rcn.net>

Hi Carsten,

    Since you have already created the tablespace you can do:

1. for tables you haven't created yet in TEST

    CREATE TABLE test.<table_name> AS SELECT * FROM production.<table_name>;

I am not sure about the "AS", but the syntax is close enough so that you can experiment.

       2. for tables you have created in TEST:

       INSERT INTO test.<table_name> SELECT * FROM production.<table_name>;

I prefer to use the CREATE and then build the indexes after I have created the tables since I find it is faster.

regards

Jerry Gitomer

---

Carsten Schmitz wrote in message <7dq50s$qgn$1_at_news.hamburg.pop.de>...
>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 Tue Mar 30 1999 - 20:35:23 CST