I have similar task sometime ago.
I'm check several ways, fastest is create table as select using dblink
and apply generated script for indexes and packages.
Regards,
Kostya Alexandrov
Zarick, Mathias wrote:
> Hello All,
>
> we have to migrate an 9i DB from a Linux IA64 Itanium to Linux x86_64 AMD Opteron.
> We have to stay on 9i, so we cannot use the new 10g data pump features or rman
> transportable tablespaces.
> The transportable tablespaces feature with export / import in 9i is only supported,
> when we stay on exactly the same platform.
> Anyway has anybody tried between IA64 and x86_64?
> Both should have little endian format.
> Any other tricks to minimize downtime?
> full export / full import will take so so long.
>
> Looking forward to your contributions
> Mathias
>
>
> Mathias Zarick
> Specialist
> Data Center Server & Storage
> IT
>
> OMV Solutions
> Lassallestra?e 3
> A-1020 Wien
> Tel. +43 (1) 40440-22113
> Fax +43 (1) 40440-622113
> mailto: mathias.zarick@(protected)
> http://www.omv.com
>
> OMV Solutions GmbH, registriert beim Handelsgericht Wien unter FN 80445b;Gesellschaftssitz: Wien; DVR: 0667293; UID ATU36821105; Lassallestra?e 3; A-1020 Wien, ?sterreich
>
> Diese Nachricht ist vertraulich und nur f?r den Adressaten bestimmt. Falls Sie diese Nachricht irrt?mlich erhalten haben, verst?ndigen Sie bitte den Absender und l?schen Sie diese Nachricht und alle Anh?nge. Danke.
> Soweit gesetzlich zul?ssig, schlie?t OMV jede Haftung f?r Sch?den aus ?bertragungsfehlern, Viren, fremden Einfluss, Verz?gerungen und dergleichen aus.
>
> This message is confidential and intended solely for the addressee. If you receive this message in error, please immediately inform the sender and delete the message and any attachments. Thank you.
> To the extent permitted by law OMV shall in no way be liable for any damages, whatever their nature, arising out of transmission failures, viruses, external influence, delays and the like.
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
