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!

Change the owner of a tablespace

680823May 6 2011 — edited May 6 2011

Hi,

I'm using sql*plus, oracle 10g, windows 7.

I have a tablespace FRUIT owned by OWNER_A.

Question 1) How do I change the ownership of the tablespace FRUIT to OWNER_B?

Question2) When I am connected to sql*pls client as OWNER_A and trying to create a new tablespace COLOR, can I set the ownership to OWNER_B?

This post has been answered by sb92075 on May 6 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2011

Added on May 6 2011

#general-database-discussions

6 comments

717 views