"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.
Use the alter user command to grant each of these users quota on the
users tablspace and to change their default tablespace to users then
use the alter table move command to move the tables in question
followed by moving their indexes.
Received on Sun Mar 09 2003 - 12:44:54 CST
