Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)
Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB. Additionally, Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB. This is because, during the full import process, tablespaces can be created automatically using parameters like REMAP_DATAFILE and REUSE_DATAFILES. Furthermore, when moving schemas from a PDB to a non-CDB, Oracle attempts to convert common users to conventional users, although this attempt might sometimes fail if specific conditions are not met.
BD E,F ->Incorrect -> tablespace export/import can be conventional or transportable A,C -> Nothing is created automatically you must create what you need.
actually tablespaces can be created automatically with full exports, that's why parameters like REMAP_DATAFILE and REUSE_DATAFILES exist in impdp. (A) https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_import.htm#i1010424 I think that B is incorrect since a database user and a local user is like the same, so no conversion is necessary. And D seems to be correct since a common user must be converted, but it seems like always fails because of the "##" characters in the "create user c##common" command, so the REMAP_SCHEMA is needed. https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/using-database-utilities-in-a-cdb.html#GUID-C1578FB6-216F-473E-A6D5-18453D4F9021 What do you think?
I think you are right, for me A D
A seems to be correct, BUT it's about importing full exports - while you can import only PART (one schema, one table, ...) from full export and then tablespace is NOT created. Tablespace is created only if you perform FULL import of FULL export. So A is rather not ok. B is definitely correct. D is definitely correct too.
By Defualt, if you just run import (without specifying mode=tables/schemas/full etc) of a full export it will run a full import as full is the default mode for import
I agree, B and D.
BD as most agrees
I believe it's BD.
i also go with BD
During the following import situations, Data Pump automatically creates the tablespaces into which the data will be imported: The import is being done in FULL or TRANSPORT_TABLESPACES mode The import is being done in table mode with TRANSPORTABLE=ALWAYS In all other cases, the tablespaces for the selected objects must already exist on the import database. You could also use the Import REMAP_TABLESPACE parameter to map the tablespace name to an existing tablespace on the import database.
A only correct in case of full import, answer only talks about full export
B seems correct D is correct as it says 'attempts'. It can generate an error, so it's an attempt...
AB for me
D. Wrong ORA-65094:invalid local user or role name AB, is a better options, i think
question is about data movement therefore correct answer is A and E
ABD are all correct, I agree with veginha: answer B is tricky because no convertion is needed
B and D
I believe it's AB.
BD for the win!
A -> true, it's a full export D -> true, *attempts* to convert common users to conventional users (it'll fail)
ald85, looks like question is from non-CDB to pdb? i doubt on D answer ?
The question says "a non-CDB and a PDB" not sense is specified. it can be non-CBD to PDB or PDB to non-CBD. Which are the cases B and D.
it saids between non-CDB and PDB.... so D is perfectly correct.