Re: User Objects in SYSTEM

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Fri, 12 Mar 1999 09:17:10 -0800
Message-ID: <36E94C15.BEBED2C2@us.oracle.com>

Doug

Good idea. You may want to pre-create the objects in the right tablespace, though.

HTH. Pete

Doug Cowles wrote:

> I inherited an instance that was set up rather
> half-hazardly and have discovered several users
> with a default tablespace of SYSTEM.
> I have also verified that they do have objects in
> the SYSTEM tablespace. I am going to change
> their default tablespace to a new one to sort of
> "plug the hole". But I was looking for commentary
> on moving those objects. I think I will export
> from SYSTEM all objects owned by user x
> and then import them to the new tablespace.
> Is this ok? Any warnings or comments?
>
> - 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 Fri Mar 12 1999 - 11:17:10 CST