Re: Transferring Oracle database

Uzytkownik "Volker Hetzer" <firstname.lastname_at_ieee.org> napisal w wiadomosci news:ekpgok$uka$1_at_nntp.fujitsu-siemens.com...
> Michal AKA Miki schrieb:
> > Meanwhile a bunch of details:
> > - Oracle on HP UX has version 8.1.6
> > - Oracle on Windows should be version 10.x (10.0.9 AFAIR), but if I will
not
> > manage, I will do also version 8.1.6. But this is situation not very
> > comfortable, because version 8.x is not supported anymore by Oracle...
> > - Oracle on Windows is not yet installed, I don't know if it's important
> > info :)
> > - I practiced IMP80.EXE and EXP80.EXE - data transfers are easy... but I
> > need also to transfer procedures, tablespaces settings, and whole rest.
> Do you really /want/ to transfer tablespace setitngs? I mean, you are
really
> sure you don't want locally managed tablespaces?

They will be locally managed. It's little misunderstanding here...

> A migration from 8 to 10g is a bit more than just copying stuff.
> Have you tested this? I've heard bad things about forms performance
> for instance, when the RBO goes away.

I did not tested it myself, but I know, that the same application is working on Oracle 10, but don't know exactly which version.. About performance - application is used by 5 people (maybe one more during next year), I hope our good P4 will be fully enough..

> And what's 10.0.9? I can't find any 10.0 release. As far as I know the
first
> 10g release was 10.1.

my mistake :) on CD there is written 109 so it looks, that it's 10g or 10.9 (if such exists)

I've read comments from you and other guys and it looks, that most safe method will be manual creation and just imp/exp functionality... I really appreciate all advices - many thanks once again..

Regards
Michal Received on Fri Dec 01 2006 - 12:40:20 CST