OraFAQ Forum: Server Administration » How do you rename User name and switch user to a new tablespace?

Home » RDBMS Server » Server Administration » How do you rename User name and switch user to a new tablespace? (11g 11.2.0.1 , windows server 2008r2 standard)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do you rename User name and switch user to a new tablespace? [message #617830]

Thu, 03 July 2014 16:22

JP10
Messages: 29
Registered: May 2014
Location:

Junior Member

I have a user name DBO_FWK_UNITTEST and it's default tablespace is assigned to USERS tablespace with USERS.DBF file name. This was created when I did a migration from SQL DB to Oracle DB. I want to now change the username to FWK_UNITTEST and have it's own tablespace and datafile? Can this be done if so how? Appreciate the help.

Report message to a moderator

[Message index]

		How do you rename User name and switch user to a new tablespace? By: JP10 on Thu, 03 July 2014 16:22
		Re: How do you rename User name and switch user to a new tablespace? By: BlackSwan on Thu, 03 July 2014 16:55
		Re: How do you rename User name and switch user to a new tablespace? By: JP10 on Thu, 03 July 2014 17:27

Previous Topic:	rebuild index
Next Topic:	View to check user connections

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 23:50:02 CDT 2024