Moving a user out of the SYSTEM tablespace
From: Peter Campbell <peter_at_ml.csiro.au>
Date: Tue, 23 Jun 1992 05:33:20 GMT
Message-ID: <1992Jun23.053320.27007_at_ml.csiro.au>
Date: Tue, 23 Jun 1992 05:33:20 GMT
Message-ID: <1992Jun23.053320.27007_at_ml.csiro.au>
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 Received on Tue Jun 23 1992 - 07:33:20 CEST