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

Re: How do you rename User name and switch user to a new tablespace? [message #617833 is a reply to message #617830]

Thu, 03 July 2014 16:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

JP10 wrote on Thu, 03 July 2014 14:22

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.

Yes, it can be done.
You can also poke yourself in the eye with a sharp pencil.
Not everything that can be done, should be done

there is NO direct relationship between USER & TABLESPACE & "ownership" is not a concept that applies to tablespaces.

You can NOT rename schema/user inside Oracle DB.
So you need to CREATE USER FWK_UNITTEST

You could then export schema DBO_FWK_UNITTEST & import into FWK_UNITTEST; but I see NO benefit to do so.

Never confuse movement with progress.
Going around in circles is movement; but most folks would not consider it to be progress.
I fail to understand what would be gained my doing what you want to do.
What difference does it make with regard the schema name?

Report message to a moderator

Re: How do you rename User name and switch user to a new tablespace? [message #617835 is a reply to message #617833]

Thu, 03 July 2014 17:27

JP10
Messages: 29
Registered: May 2014
Location:

Junior Member

Thanks BlackSwan I just realized the data pump utility will meet my needs.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 23 03:25:45 CDT 2023