Re: Newbie needs rescue please!

On 26 Jun 2001 09:33:41 -0700, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>In article <nuahjtcjqtmu1juqh2g25rv20d48m1rnu6_at_4ax.com>, Vince says...
>>
>>I learned after the fact NOT to use the default Oracle install. But
>>that is history...Now I have a SYSTEM tablespace with MANY tables that
>>need to be pulled out and put into thier own datafile. The tables
>>are all named TLINKDBA.<something>. What I would like to do is:
>>
>>Does anyone have any idea what the exact steps might be? Or can you
>>point me in the direction of the repair?
>
>see
>http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:47812348053
>
>use ALTER TABLE t MOVE and ALTER INDEX i REBUILD instead.
>
>Don't know what using the "default oracle install" has to do with this though --
>this is a side effect of creating a user and not changing their default
>tablespace. This happens on "custom" databases as well...

Seems the oracle default install only sets up the SYSTEM tablespace for userdata - a thing I learned after I did it (and after my first Oracle class).

Thanks for the reply though! Received on Tue Jun 26 2001 - 12:54:05 CDT