Home » RDBMS Server » Server Administration » migration of oracle 10gR2 to oracle 11gR2
migration of oracle 10gR2 to oracle 11gR2 [message #462204] Wed, 23 June 2010 03:17 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,


I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.

For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?


OS; solaris sparc 10

Oracle 10g: 10.2.0.1.0

oracle 11g: 11.2.0.1.0


Thanks,


Sailesh

Report message to a moderator

Re: migration of oracle 10gR2 to oracle 11gR2 [message #462211 is a reply to message #462204] Wed, 23 June 2010 03:50 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And what confuse you? Just export/import the schema (assuming there are different databases), before grant the quota on both tablespace to your user.

Regards
Michel

Report message to a moderator

Previous Topic: ORA-03113 end-of-file on communication channel error
Next Topic: need help to clear buffer pool (merged)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 10:46:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.