Exam 1z0-083 All QuestionsBrowse all questions from this exam
Go to Exam
Question 13

You must transport the UNIVERSITY tablespace from one database to another.

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have different endian formats.

Examine this list of actions:

1. Make the UNIVERSITY tablespace read-only on the source system.

2. Export the UNIVERSITY tablespace metadata using EXPDP.

3. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.

4. Copy the UNIVERSITY tablespace data files to the destination system.

5. Copy the Data Pump dump set to the destination system.

6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7. Import the UNIVERSITY tablespace metadata using IMPDP.

8. Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

    Correct Answer: C

    To transport the UNIVERSITY tablespace from one database to another with different endian formats, the correct steps to follow are: make the tablespace read-only, export the tablespace metadata using EXPDP, convert the data files to the destination platform format using RMAN on the source system, copy the data files and the Data Pump dump set to the destination system, and finally import the tablespace metadata using IMPDP before making the tablespace read/write on the destination system. This ensures proper handling of endian format conversion and metadata transfer.

Discussion
asefaOption: C

easy way we must convert either on destination or source so A is incorrect (no option 3 and 6) we must copy data pump set from source to destination so B is incorrect (no step 5) no need to convert on destination if we aleady did conversion on source so D is incorrect (both step 3 and 6) are included we must make tablespace read only son E is incorrect so answer must be C

egore0496

Why not B According https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-E4C56852-73A5-44A2-BB10-938831DA6E4C C but what about network mode of data pump or nfs/cifs export?

egore0496

15.2.4 Transporting a Database Over the Network https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-032C9715-B2F8-4ACD-8A1C-C1A899DEA3C1

asduta

thats not in the choices isnt it?

janwOption: C

agree with c must contain 1, 5, 8 must contain 3 and 6 (not both)

Alejandrrro

Agree with C too MOS Doc ID 371556.1 describes the action plan almost the same as in C. Files are converted on the source system

Patrick9230Option: C

Must C

fukakaOption: B

B is correct E is wrong: 1 is a must D is wrong: 3 & 6 need either one A & C are wrong: 5 is not a must if using network mode of data pump

egore0496Option: B

B 5 is not must https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-72973E3D-FC0A-47E8-A62A-6DF8AD83138D Network Considerations for Oracle Data Pump Export

egore0496

15.2.4 Transporting a Database Over the Network https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-032C9715-B2F8-4ACD-8A1C-C1A899DEA3C1

asduta

5 is a must since above choices doesn't list other type of moving the dump file, including one you mentioned.

jaimegarciaOption: B

yes , transportable tablespace

mamadu

Answer is C at first i also thought it was B but step 5 is important otherwise you have not moved the exported dump in step 2. then you can choose an option with either of 6 or 3.

LEOC71Option: C

Step 2 is part of all alternatives, then the data pump set created must be transferred to the destination system (step 5). => C: TRUE B:FALSE => to be true step 2 shouldn't be mentioned as part of the procedure, only step 7 (using impdp network mode).

flaviogcmeloOption: C

In my opinion, choosing alternative C instead of B is the detail of making the dump file available to the destination database. https://docs.oracle.com/en/database/oracle/oracle-database/19/spmds/migrating-oracle-database.html#GUID-F224185E-6AEC-45FC-B4F3-7F8B6469606D

_gio_Option: C

I think C

GuhborgesOption: C

For me, the right answer should B, but here, we have a lot of person saying the correct one is C, so go with the others.

Marcello86CTOption: E

I would say that correct Answer is : E With Data Pump Conventional Export and Import we no need to make any convesrion because it support different endian format. In conventional mode is not requeired neither to set db in read only.

abdelouahab

Hi, the conversion is a must between different endianess see https://docs.oracle.com/en/database/oracle/oracle-database/19/spmdu/task-4-transport-the-tablespace-set.html#GUID-41D10DCA-7733-4E4C-A41A-B94F63A82F7C

Neil107Option: C

It's C. It is always preferred/recommended to convert at the source, as far as possible, rather than convert it at the destination. Saves a lot of headache!

DhanushbhOption: C

C is correct [Doc ID 2013271.1]

JatindraOption: E

Correct Answer is E

BdaOption: B

I also think that it should be B.

Abdou1968Option: B

B is a correct answer

Roberto2Option: C

You only need to convert the data once. On the source side, you convert the Tablespaces, but on the target side, you convert the datafiles. So answer C is correct. Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/spmdu/converting-data-using-rman.html#GUID-DDFA71A3-396A-440A-B9AB-E0970F843904