Re: Moving tables between tablespaces???

No the user did not have that role.
This situation is quite funny, the documentation clearly points out the different steps to perform an operation like this and still it does not work. I'll just have to read more on this matter.

Thanks anyway for the reply!

/Jerra

Sybrand Bakker wrote:

> Question:
> Does user2 have the resource role?
> If that's true, user2 has the unlimited tablespace privilege, and quota do
> not apply.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Jerra <jerra_at_aland.net> wrote in message
> news:8atc8v$1uq$1_at_gandalf.alcom.aland.fi...
> > I wanted to move user2 from tablespace1 to tablespace2. Used the following
> > steps:
> >
> > -exported the user2 objects exp user2/user2 owner=user2
> > -alter user2 qouta 0 on tablespace1 (as system manager)
> > -alter user2 default tablespace tablespace2(as system manager)
> > -alter user2 quota unlimited on tablespace2(as system manager)
> > -imp user2/user2 fromuser=user2
> >
> >
> > What happened?? -> The bloody tables came back to tablespace1?!?
> >
> >
> > What's the correct procedure for this??
> >
> >
> > Running Oracle8 Enterprise Edition Release 8.0.5.1.0 UNIX
> >
> >
> > Thank you very plenty!!
> >
> >
> > Jerra
> >
> >
Received on Sat Mar 18 2000 - 00:00:00 CST