For this article we are going to use the Manual upgrade method. Using SQL statement CREATE TABLE AS: In this method, you will copy data from the current database into the new Oracle database release.Īfter you have quickly reviewed the above-mentioned methods, you can choose which one that is best for you.
Use 'sha1sumOracle Data Pump: In this method, you can use export and import tools provided by Oracle to make a full export from your current database, then perform an import into the new Oracle database release. Database 12c Release 2 available for download Yes, it’s the moment the world has been waiting for: the latest generation of the world’s most popular database, Oracle Database 12c Release 2 (12.2) is now available everywhere - in the Cloud and on-premises. The download contains README-JDBC, README-UCP, jdbc-demo.tar, ucpdemos.jar, Javadoc-JDBC.zip, ucpjavadoc.zip, and README.txt that has more information about the contents of the tar file. It is commonly used by database administrators who need more control over the upgrade process. Manual Upgrade: It is a command line upgrade method using SQL scripts. To analyze the current database and take needed actions that can minimize the upgrading downtime.
Its recommended by Oracle to run the Pre-Upgrade Information tool before running the DBUA. This tool can work for both CDB and non-CDB database systems. Oracle Database Upgrade Assistance (DBUA): Database Upgrade Assistance is a graphical user interface tool provided by Oracle that can help you through the upgrade process.
0 kommentar(er)
