Re: Copying tables from one tablespace to another.

From: Ian Evans <eon_at_mira.net>
Date: 27 Nov 1998 01:29:34 GMT
Message-ID: <01be19a5$0872ebc0$032811cb@eon.nmh-au>

One can export the tables, extract the ddl of the tables from export using the show option. Editing the output file, you can change the create table commands to use another tablespace. Run the import again with ignore=y so that the tables are populated.

Depending on the type of tables you can also choose to use the 'create table as select' command but there are problems with complex datatypes. Then you can use the SQLCopy command instead. Haven't used this second option myself yet.

regards, Ian Evans

Michael McKenna <michael.mckenna_at_worldnet.att.net> wrote in article <73hhgk$lop_at_bgtnsc01.worldnet.att.net>...
> Is there an easy way to copy (or move) a number of tables in one table
space
> to another tablespace?
>
> Thanks,
>
> Michael.
>
>
>
Received on Thu Nov 26 1998 - 19:29:34 CST