1Z0-184-25 Question 177
Single answerYou are migrating a table containing vector data (stored in an SDO_GEOMETRY column) from one Oracle Database in Oracle Cloud Infrastructure to another using Oracle Data Pump. You want to ensure that the geometry data, associated spatial indexes, and metadata are fully preserved in the target environment. Which approach correctly achieves this goal?
- A
A. Use Data Pump with INCLUDE=TABLE to export only the table data, then recreate spatial indexes manually after import.
- B
B. Specify the TRANSPORT_TABLESPACE parameter in Data Pump to include all metadata automatically in the dump file.
- C
C. Include the geometry metadata by exporting from USER_SDO_GEOM_METADATA and include the spatial index definitions in the same Data Pump operation.
- D
D. Set the SPATIAL=Y parameter in the Data Pump export command to automatically export geometry objects without additional configuration.
Show answer and explanation
Correct answer: C
Explanation
When using Oracle Data Pump to migrate vector data stored in an SDO_GEOMETRY column, it is essential to include both the table data and the supporting spatial metadata and index definitions. By exporting the contents of USER_SDO_GEOM_METADATA and the spatial indexes in the same Data Pump job, the target environment will have the complete geometry structure available. For more information, refer to the Oracle Spatial and Graph documentation on Data Pump export/import best practices.
- A. Incorrect.
A: Incorrect. Exporting only the table data (INCLUDE=TABLE) will not automatically include spatial indexes or metadata. You would need to export the index and metadata objects as well, or else they must be recreated manually.
- B. Incorrect.
B: Incorrect. TRANSPORT_TABLESPACE is used for moving entire tablespaces between databases. It is not a direct substitute for ensuring that vector/geometry metadata and indexes are included in a Data Pump export/import for a single table.
- C. Correct.
C: Correct. You must export not only the table but also the geometry metadata from USER_SDO_GEOM_METADATA and the spatial indexes. By ensuring these objects are included in the same dump file, you preserve all the necessary spatial information during the migration.
- D. Incorrect.
D: Incorrect. There is no Data Pump parameter SPATIAL=Y that automatically includes geometry data, indexes, and metadata. You must explicitly include the relevant objects (metadata views and indexes) in the export/import operation.