OraFAQ Forum: Unix » Coping Schemas

Home » Infrastructure » Unix » Coping Schemas

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

Coping Schemas [message #123670]

Tue, 14 June 2005 06:34

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

Mahesh Rajendran
Messages: 10707
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

Mahesh Rajendran
Messages: 10707
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 05:55:32 CDT 2024