Re: Newbie needs rescue please!

It has nothing to do with a default install. Oracle has user default and temporary tablespaces that will be used unless you tell Oracle differently. When you created user TLINKDBA you neglected to set a default and temporary tablespace for that user. So Oracle fell back on its default settings. This same thing would have happened and will happen again no matter what kind of install you do. Always set default and temporary tablespaces for any users who will own objects.

"Vince Laurent" <vlaurent_at_networkusa.net> wrote in message news:opihjt09uckm7cp7fr0imjbkj6lrl55b6l_at_4ax.com...
> 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:47812348
 053
> >
> >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 - 17:24:25 CDT