Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving tables between tablespaces???
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 Fri Mar 17 2000 - 00:00:00 CST