Home » RDBMS Server » Security » Renaming of Schema (Oracle 11G, Linux)
Renaming of Schema [message #421822] Thu, 10 September 2009 18:57 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear All,

Is there a way to rename the schema?

Thanks.
Re: Renaming of Schema [message #421823 is a reply to message #421822] Thu, 10 September 2009 19:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No direct methods.
Use the traditional methods (export/import etc).
Re: Renaming of Schema [message #421829 is a reply to message #421822] Thu, 10 September 2009 23:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Renaming of Schema [message #424450 is a reply to message #421822] Fri, 02 October 2009 07:56 Go to previous message
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:
  


Current Time: Thu Mar 28 08:15:49 CDT 2024