Re: Moving a table from one Tablespace to another

Hello,

• you can change the default tablespace from an user with the alter user .. command.
• you can make an import with parameter indexfile= ... In this case you create the create script from a table including indexes. Customize it (delete REM ..)

Regards

Axel
Carl-G. Johansson <c_joh_at_hotmail.com_NOSPAM> schrieb in im Newsbeitrag: jtLd4.81$mr.186819072_at_newsa.telia.net...
> 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 - 14:00:18 CST