Re: how to change table's tablespace?

Hi

Um my *good* reason is that I tend to trust Oracle to know what they are doing with SYS,SYSTEM etc. I realize that this may not be especially convincing <VBG>.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:39f41693_at_news.iprimus.com.au...


>

> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message

> news:8t0va5$qvr$1_at_soap.pipex.net...

> > "Howard J. Rogers" <howardjr_at_www.com> wrote in message

> > news:39f18fee_at_news.iprimus.com.au...

> > > This is (a) bad DBA work in the first place (every user with the

 rights
 to


> > > create things should have a setting for DEFAULT TABLESPACE),

> >

> > <snip>

> > > To sort out point (a) first: do a select * from dba_users where

> > > default_tablespace = 'SYSTEM'.  Anyone listed there should have a

 proper


> > > tablespace set as their default: alter user blah default tablespace X

> >

> > Given the 'work' the dba did in the first place I feel I should point

 out


> > that you do NOT alter built in Oracle accounts default tablespaces if

 they


> > appear in the list generated by this SQL command. (I know that its

 obvious


> > but...)

> >

>

> Hi Niall,

>

> It's true I never change OUTLN or some of the more obscure ones, but I

> *always* change SYSTEM.  I'm in two minds about SYS, but tend to change

 that


> too.  If you've any good reasons for not doing so, I'd love to hear them.

>

> > Also check where the temporary tablespaces are set. I'd put money on

 them


> > being in SYSTEM as well. temporary tablespace should be assigned to a

> > tablespace that only accepts temporary objects (of type temporary in

> fact).

>

> Absolutely.  Good reminder.

> Regards

> HJR

>

>

>

>

> >

> > HTH (and isn't too patronising)

> >

> >

> > --

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> >

> >

>

>