Re: Moving tables between tablespaces???

Ok this seems to be ok:

Create a new user (user2) with default tablespace = target tablespace.

export the user user1's objects exp user1/user1 ......

imp system/xxxx fromuser=user1 touser=user2

I got it to work on the test enviroment. Do you se any hidden problems with this approach? The user is not a person, it's an application and at this point I can't see that changing the tables,procs to another user would affect the app.

tadada! (-;

/Jerra

Jerra wrote:

> 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