Re: How to copy a complete tablespace ?

Jerry Gitomer wrote in message
>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

The create table as ... won't work if your table has any LONG fields. Export
and Import is probably a less typing alternative if you have a lot of tables.

...Ru Received on Wed Mar 31 1999 - 14:42:41 CST