1Z0-184-25 Question 179
Select 2You have an Oracle Database 23c instance in your development environment that stores product embeddings in a table using the new vector data type. Your team wants to copy this schema to a production environment (also running Oracle Database 23c) in Oracle Cloud Infrastructure using Data Pump. Which two steps must be ensured so that the vector data remains intact and fully usable in the target environment?
- A
Make sure the production environment is on Oracle Database 23c or higher to support the vector data type.
- B
Use the INCLUDE=VECTOR_DATA parameter in the Data Pump export command to include vectors explicitly.
- C
Specify VERSION=LATEST in the export or import parameters so that the new data type definitions are preserved.
- D
Select the DATA_ONLY option in Data Pump export to avoid issues with exporting vector indexes.
Show answer and explanation
Correct answers: A, C
Explanation
In Oracle Database 23c, vector data types require that both the source and destination databases support the new data type. Ensuring that the target is on a compatible or newer database version (23c or above) and using VERSION=LATEST in the Data Pump parameters preserves any new type definitions. Refer to the official Oracle Data Pump documentation for details on how the VERSION parameter affects the handling of newly introduced data types.
- A. Correct.
Correct. Oracle Database 23c or higher is required to support the vector data type. If the target database does not support the new data type, the import of vector data will fail.
- B. Incorrect.
Incorrect. There is no INCLUDE=VECTOR_DATA parameter in Oracle Data Pump. By default, Data Pump exports all database objects (including vector columns) unless explicitly excluded.
- C. Correct.
Correct. Using VERSION=LATEST ensures that all new data type definitions, including vector data types, are properly included and recognized in the export/import process.
- D. Incorrect.
Incorrect. Using DATA_ONLY does not address vector data type compatibility. It simply excludes metadata (such as indexes) from the export, which is not a requirement for successfully transferring vector data.