Hi,
I need to move the repository from one solaris machine to another solaris machine in which different oracle versions are used. Current repository is in Oracle 9i.I need to move the repository to Oracle 8i.
Please suggest me the procedure.
Thaks,
vishnu
raju (BOB member since 2005-10-20)
Down grading maynot have affect on repository side if proper care taken… but if if user database itself is downgraded some of function such as case statement if used in universe will not work…
BOBurao (BOB member since 2005-09-20)
Thanks for response…
Could you please guide me the procedure…
Thanks,
Vishnu
raju (BOB member since 2005-10-20)
raju,
The steps should look something like this…
Precreate the destination tablespace and repository schema in the 8i db.
Export the repository schema using the exp from the 8i home, don’t use the 9i exp or this won’t work.
Imp the dump file into your 8i database using the 8i imp program.
If you have to ftp the file between machines for any reason make sure your transfer is in binary mode.
Craig
bedell 
(BOB member since 2003-12-23)