Re: Moving user objects out of SYSTEM

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 20 Apr 1999 09:06:41 -0700
Message-ID: <371CA611.D4A88CB7@us.oracle.com>

Doug

If you already have the full export, fine, you can use it. But if you only want to do this for one user, maybe a user level export would be better. Some things to check:

Ensure the user doesn't have the UNLIMITED TABLESPACE privilege, or the RESOURCE role (which has this privilege). If they do, they can bypass the quota anyway.
Ensure the default tablespace for the user is something other than SYSTEM.

Then you should be able to import the user (FROMUSER/TOUSER with a full export, or just imp user_being_imported_username/password).

HTH. Pete

Doug Cowles wrote:

> Can someone outline a procedure to move a user's objects
> out of SYSTEM? If I have a full export for example, and then
> re-import just one user with a 0 quota on system, will that do it?
> Is there an easier way?
>
> - Dc.

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Apr 20 1999 - 11:06:41 CDT