Huawei
H13-831_V2.0 · Question #180
An internet company plans to switch its core underlying database platform from Oracle to PostgreSQL. The Oracle database has over 20 users and involves numerous upper-layer applications. Therefore…
The correct answer is B. Migrate schemas with the same user name in the Oracle database to separate databases in. See the full explanation below for the reasoning.
Advanced Storage and Database Architecture Design
Question
An internet company plans to switch its core underlying database platform from Oracle to PostgreSQL. The Oracle database has over 20 users and involves numerous upper-layer applications. Therefore, the customer hopes to minimize code modifications to these upper-layer applications. Which of the following solutions is unreasonable?
Options
- ACustomize the Oracle system function with the same name in PostgreSQL and keep the function of
- BMigrate schemas with the same user name in the Oracle database to separate databases in
- CSince PostgreSQL does not support PACKAGE objects, you can split the PACKAGE objects in Oracle
- DMigrate the schema with the same user name in Oracle database to the schema under the specified
How the community answered
(53 responses)- A6% (3)
- B81% (43)
- C11% (6)
- D2% (1)
Topics
#Oracle to PostgreSQL#database migration#schema migration#PACKAGE objects
Community Discussion
No community discussion yet for this question.