moving non system segments

From: Markham, Richard <RMarkham_at_hafeleamericas.com>
Date: Mon, 23 Sep 2002 11:11:56 -0800
Message-ID: <F001.004D6F09.20020923111156@fatcity.com>

I was playing around with Tim Gorman's hc.sql (health check) and
would like to move these objects into the USER tablespace. I would
like assistance in additional things to consider.

I haven't actualy used the command but believe I would use:
ALTER <object_type> <owner>.<segment_name> MOVE <new_tablespace>;

am curious if there is an issue with access against "in transit" objects.

.The following non-SYS accounts have objects in SYSTEM ts
.   AURORA$JIS$UTILITY$ (67 segments using        1.09Mb)
.   CSMIG (7 segments using        0.19Mb)
.   MDSYS (31 segments using        1.27Mb)
.   ORDSYS (10 segments using        0.21Mb)
.   OSE$HTTP$ADMIN (3 segments using        0.05Mb)
.   SYSTEM (160 segments using        2.80Mb)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Markham, Richard
  INET: RMarkham_at_hafeleamericas.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Sep 23 2002 - 14:11:56 CDT