OraFAQ Forum: Security » Renaming of Schema

Home » RDBMS Server » Security » Renaming of Schema (Oracle 11G, Linux)

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

Renaming of Schema [message #421822]

Thu, 10 September 2009 18:57

rkl1
Messages: 97
Registered: June 2005

Member

Dear All,

Is there a way to rename the schema?

Thanks.

Report message to a moderator

Re: Renaming of Schema [message #421823 is a reply to message #421822]

Thu, 10 September 2009 19:05

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

No direct methods.
Use the traditional methods (export/import etc).

Report message to a moderator

Re: Renaming of Schema [message #421829 is a reply to message #421822]

Thu, 10 September 2009 23:06

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.dba-village.com/dba/village/dvp_forum.OpenThread?ThreadIdA=37743&SkipA=0

Please feedback to the answerr we give you.

Regards
Michel

Report message to a moderator

Re: Renaming of Schema [message #424450 is a reply to message #421822]

Fri, 02 October 2009 07:56

mohd_dba
Messages: 19
Registered: October 2009

Junior Member

There are some steps which need to be followed:

1.Export the old schema.
2.Create the new schema with default tablespace.
3.Assign all the privileges related to new schema.
4.Import the schema.The command is like.

For ex:

$ imp system/manager file=abc.dmp log=abc.log fromuser=scott touser=scott1 ignore=y feedback=10000 buffers=100000 commit=y;

This is for Same server.If it different server.Use FTP and transfer the .dmp and log files.And import it.

Thanks,
Afroze.

[Updated on: Fri, 02 October 2009 07:57]

Report message to a moderator

Previous Topic:	network encryption for oracle
Next Topic:	Identify users connecting database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 01:19:31 CST 2024