Home » RDBMS Server » Security » migrate oracle 8i to 10g (SUN SOLARIS/HPUX)
migrate oracle 8i to 10g [message #343857] Thu, 28 August 2008 06:24 Go to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hello,

I just did a migration of oracle8i (Sun Solaris) to oracle10g (HP-UX).

The problem is that the roles given in 8i are not reflected in 10g.

e.g: in 8i user x has roles 1, 2, 3
The same user x in 10g has roles 1, 2, 3, 4, 5


The roles are not DB roles (e.g dba, connect, resource, etc) but user defined roles.



Thank you,
Dirish
Re: migrate oracle 8i to 10g [message #343884 is a reply to message #343857] Thu, 28 August 2008 07:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no role 1, 2, 3 in 8i and no role 1, 2, 3, 4 and 5 in 10g.

Regards
Michel

[Updated on: Thu, 28 August 2008 07:06]

Report message to a moderator

Re: migrate oracle 8i to 10g [message #343971 is a reply to message #343857] Thu, 28 August 2008 09:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
How did you migrate?
Re: migrate oracle 8i to 10g [message #344159 is a reply to message #343971] Thu, 28 August 2008 23:45 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Michel,

There is no role 1, 2, 3 in 8i and no role 1, 2, 3, 4 and 5 in 10g.


This is just an example.





Hi Mahesh,

i created the tablespaces as in 8i and then did a full import.



Thanks Guys







Re: migrate oracle 8i to 10g [message #344169 is a reply to message #344159] Fri, 29 August 2008 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What I meant is you have to show us what you did, what are the logfiles and so on.

Regards
Michel
Re: migrate oracle 8i to 10g [message #344300 is a reply to message #344159] Fri, 29 August 2008 05:57 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As already said by Michel,
Unless you post the log, there is nothing much we get to start.
Previous Topic: Ora-01031: insufficient privileges on 10.2.0.4 version for single Instance DB
Next Topic: expanding audit trail information
Goto Forum:
  


Current Time: Thu Mar 28 11:06:34 CDT 2024