Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Moving tables between tablespaces???
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
![]() |
![]() |