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 -> Move user to different tablespace

Move user to different tablespace

From: Linda Lee <goforticket_at_yahoo.com>
Date: 14 May 2002 13:57:21 -0700
Message-ID: <f901fb80.0205141257.3b72a895@posting.google.com> 





Hi,



I created a user in a wrong (default) tablespace, and then all the
user's object were created in the tablespace.



How can I move the user's schema from one tablespace to another
tablespace? I tried "export/drop user/create user/import". But it
seems to me that the user's priviledges and grants are all lost after
doing that.



Is it a better way to do that?



thanks.
Received on Tue May 14 2002 - 15:57:21 CDT












Original text of this message













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