Re: Oracle 8i to 19c migration
From: Mark Davidson <wdavidsmc_at_gmail.com>
Date: Thu, 23 Nov 2023 13:13:17 -0500
Message-ID: <CAD8HnKGX3QF=gORRj9mtfFUSwSRAG-HwsHOq8cx8qB-MER_o+g_at_mail.gmail.com>
Date: Thu, 23 Nov 2023 13:13:17 -0500
Message-ID: <CAD8HnKGX3QF=gORRj9mtfFUSwSRAG-HwsHOq8cx8qB-MER_o+g_at_mail.gmail.com>
When I had to migrate from 9i to 12c, my only option was export from 9i
then import to 12c. It required downtime but it was safe. I also did a
character set scan on the source which was usacii7 because we also moved to
an updated character set and some data columns needed to be increased. Then
I needed to update the tnsnames.ora file to a newer format.
Mark
On Thu, Nov 23, 2023, 12:40 PM Shravan Kumar Kota <shravankota_at_gmail.com>
wrote:
> Hi all
>
> We have 8i db in hpux server , now we are moving to 19c in Linux server.
>
> Which method will be good and smooth o migrate the data.
>
> Thanks,
> Skumar.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 23 2023 - 19:13:17 CET