| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Move "LOBINDEX" etc from "DATA" tablespace to "SYSTEM" tables
see answer below
> -----Original Message-----
> From: Guang Mei [mailto:zlmei_at_hotmail.com]
>
> 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?
The thing is that some of the scripts in $ORACLE_HOME/rdbms/admin don't do a 'drop/create' for objects, only a 'create' so if the object is already there it won't be recreated.
I suppose you could look in DBA_LOBS to find the corresponding tables for the LOBs you see in the DATA tablespace. Then look in $ORACLE_HOME/rdbms/admin for the script that creates those tables. Try to drop the tables manually and rerun the scripts to recreate them under SYS in tablespace SYSTEM.
But first, you may want to ask yourself - is it really a concern that the objects are not in the SYSTEM tablespace?
 |
 |