You can change a users default tablespace, but any objects they have already
created will have to be moved also. Use the OEM tool to restructure the DB,
I would suggest you get a Oracle DBA to do this for you, either hire a
contract worker or hire direct. If this DB is mission critical, you want
someone who knows what they are doing to set this up otherwise it will cost
the company alot more money in the long run.
Another cardinal rule is don't accept Oracle defaults if you use the DB
Assistant tool to set up your DB.
"Fred A G" <nospam_at_allowed.localhost> wrote in message
news:40hk6.3157$hi2.8990_at_nntpserver.swip.net...
>
> <vlaurent_at_networkusa.net> wrote in message
> news:3a918f19.22905516_at_news.ssmhc.com...
> > I have been tasked to install Oracle 8.1.7 and set a few things up. I
> > did the generic install since I haven't done and install before. Now
> > a few issues are cropping up:
> >
> > I used the default tablespace of system for the install. Now I read
> > on-line: " I scarcely need repeat the cardinal rule that other than
> > the data dictionary nothing should be allowed in the SYSTEM tablespace
> > that can possibly go elsewhere. In particular, no user, other than
> > SYS, should have SYSTEM as their DEFAULT TABLESPACE. And no user, not
> > even SYS, should have SYSTEM as their TEMPORARY TABLESPACE." This
> > is the default, which I did. I see problems here.
> >
>
> On a side note, Oracle themselves seems to break that rule. The database
> batch creation of 8.1.7 creates SCOTT and some other example users with
> SYSTEM as temp tablespace. Has this been so with previous 8.1 releases?
> (And shouldn't TEMP be the 'System temp tablespace'?)
>
> Regards
> /Fad
>
>
Received on Mon Feb 19 2001 - 17:40:29 CST
