Re: How to copy a complete tablespace ?

From: Reinhard Wahl <wahl_at_zv.fhg.de>
Date: Wed, 31 Mar 1999 13:13:15 +0200
Message-ID: <3702034B.63BA845A@zv.fhg.de>

Hi Carsten,

Be carefull,

Jerry Gitomer wrote:
>
> CREATE TABLE test.<table_name> AS SELECT * FROM production.<table_name>;
>

this statement generates only DEFAULT-Storage-Clause and big tables may exceed extents.
Further this statement copies between two schemas and not tablespaces so you have to ensure DEFAULT-parameters for the destination-user. The method of Barth is quiet right, but you have to be sure about BACKUP and RECOVERY.
I would prefer export/import.

Grüße aus München

Reinhard Received on Wed Mar 31 1999 - 05:13:15 CST