Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change the owner of a tablespace from UserA to UserB?

444476Nov 12 2007 — edited Nov 13 2007
Hi, friends,

I have one question: how to change the data owner from UserA to UserB?

My sceneria is like this:

I created a user, say UserA, and UserA is the ower of tablespace tsA.
UserA has loaded some data into the tablespace. When I view the tables of tablespace tsA, it is like this: UserA.table1, etc.

Now, I created a user, say UserB, and I want UserB to be the owner of the
tablespace tsA. But I still say the table under tablespace as: UserA.table1.
How can change the owner of tablspace tsA to UserB and I can safely delete UserA?

Thanks,

Xiannian
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2007
Added on Nov 12 2007
6 comments
665 views