Re: moving tables between tablespaces

In article <1993May11.111337.28925_at_ifi.informatik.uni-stuttgart.de> scheidjs_at_mickey.informatik.uni-stuttgart.de writes:

>I want to move some tables from the system tablespace to an user-tablespace. I
>can do this manually, but there are too many tables, is it possible to dothis
>automatically ?
>
>The same problem occurs when I make an Export of the user an try to import it
>in a database which has another design, I mean first all my tables are in the
>system-tablespace and I want to import them into an user-tablespace.
>The export-file contains the tablespace of the tables and always creates them
>in the system-tablespace though I don't have any resource-rights on it.
>How can I change this "hard-coded" tablespace ?
>
>I don't like the solution with only one big system-tablespace, I need a well-
>patitioned database.
>
>Thanks for any answers.
>
>-------------------------------------------------------------------------------
>scheidjs_at_mickey.informatik.uni-stuttgart.de
>-------------------------------------------------------------------------------
>

1. alter user default tablespace xxxx

  then try the import.

-- 
tina C London