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 wellpatitioned
database.
Thanks for any answers.
scheidjs_at_mickey.informatik.uni-stuttgart.de