You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)
A.
Perform a rolling upgrade.
B.
Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).
C.
Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.
D.
Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.
E.
Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.
A direct upgrade is one where either the Database Upgrade Assistant (DBUA) or command-line
upgrade script is used to upgrade your database to Oracle Database 12c. Direct upgrade is supported when the source database is running version 10.2.0.5+.
For lower versions:
1. Original export/import (min version 5)
2.Transportable Tablespaces (min version 8.1.5)
3.upgrade to 10.5 and then direct upgrade.
https://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf
Datapump did exist in Oracle 9i though the usable tools were exp and imp. Technically, we would need to export using 9i exp and import using 12c imp to migrate from 9i to 12c.
Expd and impdp became available starting Oracle 10g, which are more widely used now due to enhanced performance.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
rdnkrkmz
Highly Voted 5 years, 10 months agoEL79
Highly Voted 5 years, 3 months agoRay520
Most Recent 2 years, 7 months agoOracle2020
3 years, 4 months agotaiyang
4 years, 8 months agoRay_gk
2 years, 8 months agosherifelia
5 years agoMuhammadnagah
5 years, 1 month ago