Re: Moving a user out of the SYSTEM tablespace

In article <1992Jun23.053320.27007_at_ml.csiro.au>, peter_at_ml.csiro.au (Peter Campbell) writes:
> I am trying to move a user out of the SYSTEM tablespace by exporting,
> revoking RESOURCE privilege to SYSTEM, dropping everything, changing
> the default tablespace, and importing. Unfortunately despite having no
> quota the user is still able to create things in SYSTEM so everything is
> being recreated there instead of being forced to the new tablespace.
>
> What am I doing wrong?
>
> Peter Campbell peter_at_ml.csiro.au
> CSIRO Marine Labs, Hobart, Australia
Well, it seems this posting stuff is not as easy as it appears...

To answer your question (I hope), you need to, from a DBA privileged account, run the following statement:

ALTER USER username DEFAULT TABLESPACE newspace;

This will ensure that all objects created by the user that occupy space will be created in the tablespace 'newspace'. Received on Tue Jun 23 1992 - 17:20:07 CEST