OraFAQ Forum: Server Administration » upgrade database from 11G to 19C

Home » RDBMS Server » Server Administration » upgrade database from 11G to 19C (11G (11.2.0.4.0))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

upgrade database from 11G to 19C [message #685599]

Wed, 16 February 2022 08:11

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.

Report message to a moderator

Re: upgrade database from 11G to 19C [message #685600 is a reply to message #685599]

Wed, 16 February 2022 10:18

Michel Cadot
Messages: 68501
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.

Report message to a moderator

Re: upgrade database from 11G to 19C [message #685614 is a reply to message #685600]

Thu, 17 February 2022 08:37

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

Report message to a moderator

Re: upgrade database from 11G to 19C [message #685615 is a reply to message #685614]

Thu, 17 February 2022 10:40

Michel Cadot
Messages: 68501
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 06:09:59 CDT 2023