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?
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
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.
it saids between non-CDB and PDB.... so D is perfectly correct.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
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.
ald85
Highly Voted 4 years, 7 months agoveginha
Highly Voted 4 years, 7 months agoAntonio71
2 years agoantonica
Most Recent 10 months, 1 week agogabskh
1 year, 3 months ago_gio_
1 year, 7 months agoScottL
1 year, 9 months agomomi0205
2 years, 6 months agoflaviogcmelo
2 years, 9 months agoBio12345
2 years, 11 months agoBio12345
2 years, 11 months agoNeil107
3 years, 6 months agoObserverPL
3 years, 8 months agoVinayakChandra
7 months, 2 weeks agodieymir
4 years, 2 months agoSchmeili
4 years, 2 months agojanw
4 years, 5 months agojanw
4 years, 5 months agojanw
4 years, 5 months agocerebro2000x
4 years, 6 months agoyou1234
4 years, 7 months agoald85
4 years, 7 months agoproact
4 years, 3 months ago