Re: Oracle 8i to 19c migration

You should decide on a character set in 19c before you import. Running csscan utility against the 8i database should tell you if there will be data or column issues. If there are no issues the. You should be good. Otherwise you may need to correct the issue. But always, always test multiple times before you switch to 19c for production. Doing this saved me hours of after migration work. This was important because I had over 100+ databases to migrate.

Mark

On Thu, Nov 23, 2023, 1:18 PM Shravan Kumar Kota <shravankota_at_gmail.com> wrote:

> Thanks for the update Mark , as my db is in 8i and do I need to update
> character set after import of the data?
>
> Thanks
> Skumar
>
> On Thu, Nov 23, 2023, 23:43 Mark Davidson <wdavidsmc_at_gmail.com> wrote:
>
>> 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-l