How to change the owner of a tablespace from UserA to UserB?
444476Nov 12 2007 — edited Nov 13 2007Hi, 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