Re: Move user to different tablespace

From: godmann <allanwtham_at_yahoo.com>
Date: 14 May 2002 22:29:17 -0700
Message-ID: <95cd51c.0205142129.1f779ef8@posting.google.com>

goforticket_at_yahoo.com (Linda Lee) wrote in message news:<f901fb80.0205141257.3b72a895_at_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.

Using svrmgrl, no other way.

Allan W. Tham
Oracle DBA Received on Wed May 15 2002 - 00:29:17 CDT