Which two steps are required in addition to the regular steps needed for transporting tablespaces?

You need to transport tablespaces between platforms with different endians. Which two steps are required in addition to the regular steps needed for transporting tablespaces? (Choose two.)

You need to transport tablespaces between platforms with different endians. Which two steps are required in addition to the regular steps needed for transporting tablespaces? (Choose two.)

A.
The DB_FILE_NAME_CONVERT parameter must be set in the init.ora file.

B.
The CONVERT command of SQL*Plus must be used to change byte ordering.

C.
No other explicit action is required.

D.
The CONVERT command of the Recovery Manager utility must be used to change byte ordering.

E.
The COMPATIBLE parameter must be set to 10.0.0 or higher in both the source and the target databases.

Explanation:
Before a tablespace can be transported to a different platform, the datafile header must identify the platform to which it belongs. In an Oracle Database with compatibility set to 10.0.0 or later. You also, must convert the tablespace set to the endianness of the target platform. You can perform a source-side conversion or you can perform a target-side conversion. if you want to convert before transporting the tablespace set, then convert the datafiles composing de tablespace set. The RMAN CONVERT command is used to do the conversion. Start RMAN and connect to the target database:
$ RMAN TARGET /

Recovery Manager: Release 10.1.0.0.0
Copyright (c) 1995, 2003, Oracle Corporation. All rights reserved. Convert the datafiles into a temporary location on the source platform. In this example, assume that the temporary location, directory /temp, has already been created. The converted datafiles are assigned names by the system.
RMAN> CONVERT TABLESPACE <name>
2> TO PLATFORM ‘Microsoft Windows NT’
3>FROMMAT’/temp/%U’;

REF: Oracle(r) 10g Administrator Guide, 8-29,8-33 and 8-34



Leave a Reply 1

Your email address will not be published. Required fields are marked *


networkmanagers

networkmanagers

Correct answer is