| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Move "LOBINDEX" etc from "DATA" tablespace to "SYSTEM" tablespace?
System: Sun Solaris 2.7
Oracle : 8.1.6 Enterprise Edition
I just installed the oracle server software and created an instance manually.
Everything seems to be fine except there is one problem. The problem is that there are some objects owned by user "SYSTEM" end up in tablespace "DATA" (see the query result below). I think this is due to the fact that I changed SYSTEM's default tablespace to "DATA" before I run "pupbld.sql". After I found out this problem after finishing all the instance creation, I even re-run all the scripts:
catalog.sql, catproc.sql, catrep.sql and dbmspool.sql by user "internal" pupbld.sql by user "SYSTEM"
but it did not help. So my question is :
How could I "move" these objects out of "DATA" tablespace and into "SYSTEM" tablespace without re-creating the instance?
Thanks.
Guang
SQL> select distinct owner, tablespace_name, segment_type, segment_name from dba_segments where tablespace_name='DATA';
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBINDEXSYS_IL0000002394C00012$$
SYSTEM DATA LOBINDEXSYS_IL0000002552C00025$$
SYSTEM DATA LOBINDEXSYS_IL0000002562C00025$$
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBINDEXSYS_IL0000002580C00003$$
SYSTEM DATA LOBINDEXSYS_IL0000002580C00004$$
SYSTEM DATA LOBINDEXSYS_IL0000002580C00005$$
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBINDEXSYS_IL0000002589C00001$$
SYSTEM DATA LOBINDEXSYS_IL0000002589C00002$$
SYSTEM DATA LOBINDEXSYS_IL0000002589C00003$$
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBINDEXSYS_IL0000003136C00005$$
SYSTEM DATA LOBINDEXSYS_IL0000003149C00004$$
SYSTEM DATA LOBINDEXSYS_IL0000003163C00004$$
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBINDEXSYS_IL0000003186C00003$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000002394C00012$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000002552C00025$$
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBSEGMENTSYS_LOB0000002562C00025$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000002580C00003$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000002580C00004$$
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBSEGMENTSYS_LOB0000002580C00005$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000002589C00001$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000002589C00002$$
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBSEGMENTSYS_LOB0000002589C00003$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000003136C00005$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000003149C00004$$
OWNER TABLESPACE_NAME SEGMENT_TYPE
------------------------------ ------------------------------
------------------
SYSTEM DATA LOBSEGMENTSYS_LOB0000003163C00004$$
SYSTEM DATA LOBSEGMENTSYS_LOB0000003186C00003$$ 26 rows selected.
SQL> spool off
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei INET: zlmei_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Thu Mar 22 2001 - 19:11:33 CST
--------------------------------------------------------------------
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).
 |
 |