To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to remove Streams setup. For detailed steps, refer to the section “Removing an Oracle Streams Configuration” in the Oracle Streams Concepts and Administration Guide specific for the Oracle release from which you are removing.
It is observed that even though there are no Streams Processes or Rules.
connect / as sysdba
delete from sys.apply$_source_obj ;
delete from sys.apply$_source_schema;
Then run again the preupgrade script.
Stay tuned for more articles on Oracle 19c
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp