Re: Moving a table from one Tablespace to another

You could just extract the DDL from the dump file (imp using show =y), amend the DDL inserting the tablespace you want, create the table using the amended DDL then import using ignore =y. The create on the import will fail because the table already exists, but you know that so ... the import will then just carry on creating indicies or constraints and load the data.

or is that going round the houses .. as they say ? NeilC.

Carl-G. Johansson wrote in message ...
>Hello!
>
>I wonder if someone can give me a hint on how to move a table from one
>tablespace to another.
>
>I have exported the table to a dump file and thought I could just change
the
>table owners default tablespace, taking the original tablespace for the
>table off line, but that didn't help.
>
>As I understand it an import allways want's to put the table in the
>tablespace from where it was exported.
>
>Any ideas about this?
>
>--
>Regards
>Carl Johansson
>
>
Received on Sat Jan 08 2000 - 17:00:06 CST