RE: Oracle 8i to 19c migration

If ALL you’re concerned about is the DATA, i.e., NO “code” like SQL, stored procedures, Java, Python, Oracle Call Interface, ODBC, JDBC or ANY other data ACCESS methods, which would also imply you don’t care how long it takes to copy the data AND that the data is “static”, i.e, not being changed, then export/import is the “safe” bet. As others have noted, you may have to take two steps, to a later version, before 19c.

If ANY the above assumptions are incorrect; then there is NO “good” or “smooth” way to accomplish what you desire.

As I’m sure you know, there are VAST differences in “behavior” of the optimized, operating system and underlying database. If there is ANY “application” involved that is not a complete re-write, you’ll need to test, test and test again; and expect significant rewrites.

Clay Jackson

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Shravan Kumar Kota Sent: Thursday, November 23, 2023 9:39 AM To: Oracle-L Freelists <oracle-l_at_freelists.org> Subject: Oracle 8i to 19c migration

CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.

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