Examine the following impdp command to import a database over the network from a pre-12c
Oracle database (source):
Which three are prerequisites for successful execution of the command?
A.
The import operation must be performed by a user on the target database with the
DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the
source database with the DATAPUMP_EXD_FULL_DATABASE role.
B.
All the user-defined tablespaces must be in read-only mode on the source database.
C.
The export dump file must be created before starting the import on the target database.
D.
The source and target database must be running on the same platform with the same
endianness.
E.
The path of data files on the target database must be the same as that on the source database.
F.
The impdp operation must be performed by the same user that performed the expdp operation.
Explanation:
* Be aware of the following general limitations as you plan to transport data:
/ The source and the target databases must use compatible database character sets.
C: You can use the full transportable export/import feature to copy an entire database
from one Oracle Database instance to another. You can use Data Pump to produce an
export dump file, transport the dump file to the target database if necessary, and then
import the export dump file. Alternatively, you can use Data Pump to copy the
database over the network.
B, Not D: Transporting a Database Using an Export Dump File
The following list of tasks summarizes the process of transporting a database using an
export dump file.
1.(B)At the source database, place each of the user-defined tablespaces in read-only
mode and export the database.
(Note:This method for transporting a database requires that you
place the user-defined tablespaces in the database in read-only mode
until you complete the export.)
Ensure that the following parameters are set to the specified values:
/TRANSPORTABLE=ALWAYS
/FULL=Y
(not D) If the source database is an Oracle Database 11g Release 2 (11.2.0.3) or later Oracle
Database 11g database, then you must set the VERSION parameter to 12 or higher.
2.Transport the export dump file.
Copy the export dump file to a place that is accessible to the target database.
3. Transport the data files for all of the user-defined tablespaces in the database.
Copy the data files to a place that is accessible to the target database.
If the source platform’s endian format is different from the target platform’s
endian format, then you need to convert the data files.
4.(Optional) Restore the user-defined tablespaces to read/write mode on the sourcedatabase.
5.At the target database, import the database.
When the import is complete, the user-defined tablespaces are in read/write
mode.
Note:
* The Data Pump Import utility is invoked using the impdp command.
Incorrect:
Not E: The source and target databases can have different hardware, operating systems,
character sets, and time zones.
Not A, Not F :
* If the user is someone other than the schema you’re exporting or importing,
you need one of these two things:
/DBA privileges
/The DATAPUMP_EXP_FULL_DATABASE and DATAPUMP_IMP_FULL_
DATABASE roles
If you’re working as an administrator in a container database (CDB), you also
need the CDB_DBA role.
* The DATAPUMP_EXP_FULL_DATABASE and DATAPUMP_IMP_FULL_DATABASE roles
allow privileged users to take full advantage of the API. The Data Pump API will use these roles to
determine whether privileged application roles should be assigned to the processes comprising
the job.
Correct Ans : ABC ,
Dont think E is correct
The answer might be A,B,F. The following are the steps to do network impdp
Create a database link in the target to the source
database.
2. Make the user-defined tablespaces in the source database
read-only.
3. Transport the datafiles for all of the user-defined
tablespaces from the source to the target location.
4. Perform conversion of the datafiles if necessary.
5. Import in the target database.
Correct answer A,B,C
Not D: can do with different platform. If endian is different need to convert using RMAN Convert
Not E: not mandatory
Not F: Export and import can be performed by diffrent users
A B E is the answer
C is wrong. No dump is created when using a network link.
correct.
answer is A B D
both target and source have to have same endianess
According to the bellow, it does not look like “D” is the valid option.
“C” not valid, because dumpfile is an invalid parameter with network_link parameter, error: “UDI-00011: parameter dumpfile is incompatible with parameter network_link”
“If the source platform and the target platform are of different endianness, then an additional step must be done on either the source or target platform to convert the tablespace being transported to the target format. If they are of the same endianness, then no conversion is necessary and tablespaces can be transported as if they were on the same platform.”
Source: https://support.oracle.com/CSP/main/article?cmd=show&id=371556.1&type=NOT
ABD
The question is: “Which three are prerequisites for successful execution of THE COMMAND”
D is correct!!! To sucess execution both target and source have to have same endianess
I think A, B,E
D is incorrect, as it stress that on the same platform with the same endianness.
Same endianness. is a must, but don;t have to be the same platform.
ABE
A B and E is correct. E is correct assuming there is no change in the path of datafiles.
I would choose A,B,D
D is probably correct-I think that it is only inaccurate.(I understand your objections )
http://docs.oracle.com/database/121/ADMIN/transport.htm#ADMIN13873
If the source platform and target platform are different, then check the endian format of each platform by running the query on the V$TRANSPORTABLE_PLATFORM view in “Transporting Data Across Platforms”.
E..is nonsense
I would agree with you Jaroslav.
ABD should be the answer, you can change the datafiles path in impdp statement. But files has to have the same endian, otherwise what will do the conversion of datafiles.
ABD
ABD – OK
example from doc :
A – OK
Start SQL*Plus and connect to the target database as the administrator who will transport the database with Data Pump import. This user must have DATAPUMP_IMP_FULL_DATABASE role to transport the database.
During the import operation, the database link must connect to a user on the source database with DATAPUMP_EXP_FULL_DATABASE role. The user on the source database cannot be a user with SYSDBA administrative privilege.
B – OK
Make all of the user-defined tablespaces in the database read-only.
D – OK
The source database and target database are running on the same platform with the same endianness.
http://docs.oracle.com/database/121/ADMIN/transport.htm#ADMIN13873
ABE
ABD
ABD is correct,
D is correct otherwise, you must use RMAN to convert the datafiles before using import!
ABD
AB(D)
E and F are obviously wrong, and can be ruled out.
A: Correct.
B: Correct.
C: Since we are using network_link in the imp command, the metadata and the db data are copied via network, not through a dmp file. Therefore, this choice can be ruled out too.
D: Correct. Both the target and the source must be at the same endianness for the command to succeed. If the target database is not, then we have to convert at the destination. So, C is indeed correct.
So the correct answers are:
A, B, D
So, D is indeed correct.
A, B, D
D is correct because the pre-12c on the source database. So there is no convert available under such condition.
DATA PUMP VERSION parameter should be set to 12.
D – incorrect as it is allowed to covert endian.
I believe C- is referring to transporting datafile not the dump files here.
A and B are correct,others are wrong,any option?
ABD
ABD
A,B,C are correct
Correct is ABC
this is the case of migrating/upgrating/plugging a pre-12c database using Full import/export.
in this method, first export is taken at source (pre-12c) that has only meta data.
then over network_link, import is run to copy the datafiles. you can have different dir structure ( db_file_create_dest etc).
Correct is ABC:
Full Transportable Export/Import: Example
Oracle Database 12c: New Features for Administrators 22 – 8, Student Guide Volume II
Well in the question we are doing an “over the network transport”, in this case in the stidy guide it sais nothing about an initial export dumpfile… it sais only transport datafiles and convert them if it’s the case.
“To transport a database over the network, use import with the NETWORK_LINK parameter. The import is performed using a database link, and there is no dump file involved.”
So C – False
E – False – I don’t see this restriction, the new database can have different name for example so if you have in the path, the patch will be different
F – False the expdp is done by the user you connect to with the db_link, any user as long as it has DATAPUMP_EXP_FULL_DATABASE
So I Think A,B,D – only D remains the 3’rd logical choice, especially since the question sais nothing about you converting the tablespaces before the import with impdp.
AB is correct may be D also
A, B , D