Home » Infrastructure » Unix » Coping Schemas
Coping Schemas [message #123670] Tue, 14 June 2005 06:34 Go to next message
snagra
Messages: 23
Registered: March 2005
Junior Member
I''ve loaded oracle 10.1.0.4 and created a database on my new Sun box. I need to copy a schema from the old sun box which uses 8.1.7. I need to get all the roles and priviledges from the old machine at the same time. How can this be achieved?

Report message to a moderator

Re: Coping Schemas [message #123686 is a reply to message #123670] Tue, 14 June 2005 08:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export/import should help.

Report message to a moderator

Re: Coping Schemas [message #123687 is a reply to message #123686] Tue, 14 June 2005 08:15 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
or if you are worried only about the roles and privileges and you can create a user like-an-existing user.
Please see the discussion here.
http://www.orafaq.com/forum/t/46236/0/

Report message to a moderator

Previous Topic: Changeing a global database name
Next Topic: Import error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 30 00:16:51 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.