Home » RDBMS Server » Server Administration » upgrade database from 11G to 19C (11G (11.2.0.4.0))
upgrade database from 11G to 19C [message #685599] Wed, 16 February 2022 08:11 Go to next message
vaibhav8080
Messages: 6
Registered: February 2022
Junior Member
I Want to upgrade database from 11G (11.2.0.4.0) to 19C. It contains some java sources and classes in old 11G database which are used to fetch data from csv or excel files stored on FTP server and load the data into oracle tables. Now I have doubt this will work when database upgrade. Hey guys, please help me with your expertise.
Re: upgrade database from 11G to 19C [message #685600 is a reply to message #685599] Wed, 16 February 2022 10:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is difficult to know if some code we don't see will still work after upgrading but if you use Oracle packages in a simple way there is no reason it won't work as Oracle guarantees more or less the compatibility with previous releases (unless specified it does not in the documentation).

Note that upgrading from 11gR2 to 19c, you also upgrade from jvm 1.6.0 to 1.8.0.

[out of topic] To load CSV files, I'd use UTL_FTP to copy the files in database server then external tables to load them ather than custom code.

Re: upgrade database from 11G to 19C [message #685614 is a reply to message #685600] Thu, 17 February 2022 08:37 Go to previous messageGo to next message
vaibhav8080
Messages: 6
Registered: February 2022
Junior Member
Thanks Michel for Prompt reply,

Can you share links for loading CSV files through UTL_FTP and external tables?

Thanks
Re: upgrade database from 11G to 19C [message #685615 is a reply to message #685614] Thu, 17 February 2022 10:40 Go to previous message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Sorry, UTL_FTP was a customer program but you can find a PL/SQL FTP package based on Oracle UTL_TCP there.

Here are 2 examples to use external tables on csv files:
https://schneide.blog/2020/06/16/using-csv-data-as-external-table-in-oracle-db/
http://nimishgarg.blogspot.com/2012/06/create-external-table-from-csv-file.html

Previous Topic: ORA-00308 ,ORA-27041 -ARCHIVELOG Missing
Next Topic: Deviations in the databases
Goto Forum:
  


Current Time: Sun Aug 07 23:28:01 CDT 2022