Re: moving one user schema out of system tablespace

From: David Sharples <david.sharples3_at_ntlworld.com>
Date: Sun, 9 Mar 2003 17:27:16 -0000
Message-ID: <VPKaa.18287$EN3.148896@newsfep4-glfd.server.ntli.net>

"CS" <wchuacs_at_pc.jaring.my> wrote in message news:b4f6q9$6t9$1_at_news6.jaring.my...
> Hi,
>
> I have installed Oracle8i (8.1.7.0.0) on my home PC running Windows 2000
> Professional, and there was a pre-configured database created too.
>
> I found there are a few users created, eg: Scott, Blake, Jones, etc. Who
> knows their initial passwords ? i knew only Scott/Tiger, the rest I don't.
>
> And they were created in SYSTEM tablespace, both default and temporary,
what
> is the best solution to move them to other tablespace, eg: USERS
tablespace
> (created) ?
>
> Please help me with your excellent experience to outline what are the
steps
> to follow and also any other considerations to care about ?
>
> thankyou.
>
>

you can move the object if you require using alter table <table> move ... and alter index indexname rebuild <tablespace_name> Received on Sun Mar 09 2003 - 11:27:16 CST