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 ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBINDEX SYS_IL0000002394C00012$$ SYSTEM DATA LOBINDEX SYS_IL0000002552C00025$$ SYSTEM DATA LOBINDEX SYS_IL0000002562C00025$$ OWNER TABLESPACE_NAME SEGMENT_TYPE ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBINDEX SYS_IL0000002580C00003$$ SYSTEM DATA LOBINDEX SYS_IL0000002580C00004$$ SYSTEM DATA LOBINDEX SYS_IL0000002580C00005$$ OWNER TABLESPACE_NAME SEGMENT_TYPE ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBINDEX SYS_IL0000002589C00001$$ SYSTEM DATA LOBINDEX SYS_IL0000002589C00002$$ SYSTEM DATA LOBINDEX SYS_IL0000002589C00003$$ OWNER TABLESPACE_NAME SEGMENT_TYPE ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBINDEX SYS_IL0000003136C00005$$ SYSTEM DATA LOBINDEX SYS_IL0000003149C00004$$ SYSTEM DATA LOBINDEX SYS_IL0000003163C00004$$ OWNER TABLESPACE_NAME SEGMENT_TYPE ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBINDEX SYS_IL0000003186C00003$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000002394C00012$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000002552C00025$$ OWNER TABLESPACE_NAME SEGMENT_TYPE ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBSEGMENT SYS_LOB0000002562C00025$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000002580C00003$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000002580C00004$$ OWNER TABLESPACE_NAME SEGMENT_TYPE ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBSEGMENT SYS_LOB0000002580C00005$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000002589C00001$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000002589C00002$$ OWNER TABLESPACE_NAME SEGMENT_TYPE ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBSEGMENT SYS_LOB0000002589C00003$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000003136C00005$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000003149C00004$$ OWNER TABLESPACE_NAME SEGMENT_TYPE ------------------------------ ------------------------------ ------------------ SEGMENT_NAME -------------------------------------------------------------------------------- SYSTEM DATA LOBSEGMENT SYS_LOB0000003163C00004$$ SYSTEM DATA LOBSEGMENT SYS_LOB0000003186C00003$$ 26 rows selected. SQL> spool off _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
