ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam
Go to Exam

Exam 1z0-083 topic 1 question 108 discussion

Actual exam question from Oracle's 1z0-083
Question #: 108
Topic #: 1
[All 1z0-083 Questions]

You want to transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have the same endian format.
Examine this list of steps:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause.
4. Copy the cross-platform backup sets to the destination system.
5. Copy the Data Pump dump set from the source to the destination system.
6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

  • A. 1, 3, 4, 6, 8
  • B. 3, 4, 6
  • C. 1, 2, 3, 4, 5, 6, 7, 8
  • D. 2, 3, 4, 5, 6, 7
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by RinD at May 7, 2021, 7:37 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
RinD
Highly Voted 3 years, 5 months ago
A is correct https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/mig-rman-cross-plat-transp-tablespace.htm
upvoted 11 times
...
greenday5494
Most Recent 1 year, 1 month ago
Selected Answer: B
the answer is B. disagree with A. RinD's post is for transporting to the cloud, which is not what we're doing here. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-transporting-data-across-platforms.html#GUID-4644069A-7849-49F2-A1BF-2193EBAFFDBD according to this link, only 3 steps are necessary.
upvoted 1 times
guretto
10 months, 3 weeks ago
The endian is the same.... no cross-platform migration
upvoted 1 times
...
greenday5494
11 months, 1 week ago
nevermind, its A
upvoted 1 times
...
antonica
7 months ago
your document say: Note:When you use the DATAPUMP clause, the tablespaces that are being transported must be made read-only. then b is not correct
upvoted 3 times
...
...
_gio_
1 year, 3 months ago
Selected Answer: A
I agree with A
upvoted 1 times
...
ScottL
1 year, 6 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
vkra
1 year, 8 months ago
Selected Answer: A
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/mig-rman-cross-plat-transp-tablespace.htm
upvoted 1 times
...
hilaire
1 year, 10 months ago
A is correct https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/mig-rman-cross-plat-transp-tablespace.htm
upvoted 1 times
...
Dhanushbh
3 years, 3 months ago
A is correct , agreed
upvoted 1 times
...
ObserverPL
3 years, 5 months ago
Agree with RinD - A is CORRECT. It is not required to perform manually export of metadata, it is done during RMAN backup of tablespace for transport.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago