1Z0-184-25 Question 176
Select 2You have a development database running on Oracle Database 23c that stores product embeddings in a table called PRODUCT_EMBEDDINGS using the built-in VECTOR data type. You must migrate the entire schema to a new production environment, also running Oracle Database 23c, using Oracle Data Pump (expdp/impdp). Which two actions should you take to ensure the VECTOR data is successfully exported and imported?
- A
Set the COMPATIBLE initialization parameter in both source and target databases to 23.0.0 or higher.
- B
Use the Data Pump parameter VERSION=12.2 to remain backward compatible for the vector data.
- C
Include a pre-migration script to drop and re-create a user-defined VECTOR type before the import.
- D
Ensure that the schema user performing the import has CREATE TYPE and CREATE TABLE privileges.
- E
Restrict the export to only the product embeddings table using an INCLUDE=TABLE parameter.
Show answer and explanation
Correct answers: A, D
Explanation
To successfully export and import VECTOR data in Oracle Database 23c, you must ensure that the database compatibility setting supports VECTOR columns (COMPATIBLE must be at least 23.0.0) and that the importing user has the necessary privileges to create objects involving VECTOR data. Relying on backward compatibility modes (e.g., VERSION=12.2) or scripts for user-defined types is not applicable, since VECTOR is a native data type in 23c. For more details, refer to the Oracle Database Data Pump documentation for Oracle Database 23c regarding schema and data movement best practices.
- A. Correct.
Because the VECTOR data type is introduced in Oracle Database 23c, setting the COMPATIBLE parameter to at least 23.0.0 ensures the target system can properly handle and store VECTOR data columns.
- B. Incorrect.
Using VERSION=12.2 forces Data Pump to create export dumps compatible with older database versions, losing features specific to 23c (such as the VECTOR data type). This would not preserve your embeddings properly.
- C. Incorrect.
VECTOR is a built-in data type in Oracle Database 23c, not a user-defined type, so there is no need to drop and re-create a user-defined type. This script would be unnecessary and potentially harmful.
- D. Correct.
The user importing the schema needs appropriate privileges (e.g., CREATE TABLE, CREATE TYPE) to replicate objects that include the VECTOR data type. Without these privileges, Data Pump might fail while creating tables or types.
- E. Incorrect.
While INCLUDE=TABLE can limit the export to specific tables, it is not required to get a successful Data Pump migration of VECTOR data if the goal is to transfer the entire schema. You only need it if you must selectively migrate certain objects.