Re: Upgrade from 10g1 to latest 19c

I believe the upgrade method requires upgrading to another version first, such as 11.2.0.4.

From there, a direct upgrade to 19c is possible.

But, there is no single-hop route to 19c bliss from 10g via database upgrade methods

Depending on the size of the database, you may want to go the datapump route, as it results in a 'cleaner' database.

There will be no extra baggage from whatever has been done to that database the past few years.

That said, the datapump method requires more effort and planning, as there may be related schemas, public synonyms and other objects that are not in the schema.

This is the route we have taken in just this same situation with a client recently.

Only by using DP did we discover the app has created required objects in SYS (oh my!)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://www.pythian.com/blog/technical-track/author/jared-still <https://github.com/jkstill>
Personality: http://www.personalitypage.com/INTJ.html

On Thu, Aug 1, 2024 at 7:40 PM steve jamro <sjamro1990_at_gmail.com> wrote:

> Hello
>
> 1-is it possible to directly upgrade from 10g1 to 19c
> Using data pump?
> 2-if possible, is data pump the best method to upgrade to a new host/OS
> 10g->19c?--
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l