Forum Stats

  • 3,768,999 Users
  • 2,252,895 Discussions
  • 7,874,835 Comments

Discussions

Migrating from 12c to 19

Are there any issues to migrating a database from version 12c to 19? We do not use stored procedures. We do use sequences. A web article,

https://www.itconvergence.com/blog/oracle-database-19c-whats-new/, suggests that 12c can be "directly" converted to 19. Not sure if this is correct. Thank you.

Comments

  • Dave_VZ
    Dave_VZ Member Posts: 37 Red Ribbon

    In our experience, it was just a minor upgrade with no hick-ups. Think of it as 12c (12.2.0.2) and 19c (12.2.0.3) to adopt the trending use of two-digit year numbers as release levels.

  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 3,664 Silver Crown

    As Dave has mentioned, Oracle 18c and 19c are actually "commercial" names for Oracle 12.2 version released on 2018 and 2019, as part of a new release plan with yearly versions.

    There are no big architecture changes between Oracle 12.2 and Oracle 19c and the upgrade should be pretty simple, compared with upgrading from older (11.x, 12.1). You did not mention if your 12c is 12.1 or 12.2, there are probably more differences between 12.1 and 12.2 than 12.2 and 19c.