Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
To migrate heap table data after a database upgrade, three suitable methods include: using SQL Developer, using Oracle Data Pump, and using the CREATE TABLE AS SELECT SQL statement. SQL Developer provides a user-friendly interface for database management and migration tasks. Oracle Data Pump is a highly efficient tool for data export and import, suitable for large datasets. The CREATE TABLE AS SELECT SQL statement allows data to be migrated by creating new tables and copying data directly from the old tables. These methods are consistent with standard practices for data migration.
looks like table migration methods are asked here, not upgrade methods, should be BCF
why B ? The same role is for sqlplus For me correct is CEF as tell us veginha
That sqlplus isn't among the answers doesn't mean that b is incorrect ....
C,E and F are correct Oracle provides features and products to automate the upgrade process and ensure the most efficient use of time. Oracle Database supports the following methods for upgrading a database to the new release: Database Upgrade Assistant (DBUA) Manual upgrade using SQL scripts and utilities Oracle Data Pump CREATE TABLE AS SQL statement https://docs.oracle.com/database/121/UPGRD/intro.htm#UPGRD60026
Upgrade is not Migrate!!!
C and F are correct no doubt. E would be fine but question is about AFTER UPGRADING database, hence once DBUA finishes his work. So E is not correct. The only remaining sensible third answer is B.
it's BCF.
argument of veginha handles the upgrade itself, this question handles about a heap move. for me BCF
bcf ithink
CEF https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/upgrade-and-data-migration-methods-and-processes.html#GUID-93250F01-DB85-4CA2-9A10-5B5FA5E4B924
BCF for me i have not yet tried dbua to upgrade tables
Oracle Database supports the following methods for upgrading or migrating a database to the new release: * Database Upgrade Assistant (DBUA) * Migrating data using Oracle Data Pump * CREATE TABLE AS SQL statement
reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/upgrade-and-data-migration-methods-and-processes.html#GUID-93250F01-DB85-4CA2-9A10-5B5FA5E4B924
Oracle Database supports the following methods for upgrading or migrating a database to the new release: * Database Upgrade Assistant (DBUA) * Migrating data using Oracle Data Pump * CREATE TABLE AS SQL statement
I believe so.
C, E and F.
I think BCF it's not an upgrade, it is a migration
BCF correct
https://www.oracle.com/us/products/database/migrating-to-oracle-database-wp-3610526.pdf