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

Personality: http://www.personalitypage.com/INTJ.html

Did Oracle 10g support SECUREFILES LOBs? I forgot. If it didn't, you may end up with BASICFILES LOB columns, which may not be what the users want. There are very significant changes from Oracle 10g --> Oracle 19c. Another method would be to use Golden Gate or Quest SharePlex and replicate the data into the pre-created 19c schema. That would also minimize the downtime, because the source database can remain active during the replication.

Speaking of the choice between GG and SharePlex, I would go with the latter because it's significantly cheaper. Also, Quest is very flexible with the licenses and can "rent" you a license for 6 months or so, until your task is done.

Regards