Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Moving tables between tablespaces???

Moving tables between tablespaces???

From: Jerra <jerra_at_aland.net>
Date: 2000/03/17
Message-ID: <8atc8v$1uq$1@gandalf.alcom.aland.fi>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US