For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
The USER_TABLESPACE clause in the CREATE PLUGGABLE DATABASE command can be used to specify the list of user tablespaces when moving a non-CDB to a PDB. This is useful for migrating specific data without bringing unnecessary tablespaces, which optimizes space and minimizes migration time. Additionally, it can specify the list of tablespaces to include when creating a PDB from the CDB seed. This allows for defining which user tablespaces should exist in the newly created PDB, ensuring that the necessary schema and data structures are available right from the start. These use cases leverage the flexibility of the USER_TABLESPACE clause to manage database resources effectively.
B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
It's correct BD?
To confirm D tried plugging in a PDB in my test system with USER_TABLESPACES clause and an excluded tablespace is indeed offline. CREATE PLUGGABLE DATABASE XEPDB2 USING '/opt/oracle/oradata/XE/XEPDB2/XEPDB2.xml' USER_TABLESPACES=NONE NOCOPY TEMPFILE REUSE; SQL> select TABLESPACE_NAME,status from dba_tablespaces; TABLESPACE_NAME STATUS ------------------------------ --------- SYSTEM ONLINE SYSAUX ONLINE UNDOTBS1 ONLINE TEMP ONLINE CUSTOM OFFLINE
i double checked B again. B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB ? ____________________________________________________________________________________ Its definitely FALSE Because to exclude some tablespaces we can use for example USER_TABLESPACES=ALL EXCEPT('tbs1','tbs4','tbs5'); in this case all tablespaces will be included except tbs1, tbs4 and tbs5 Howver This clause does not apply to the SYSTEM, SYSAUX, or TEMP tablespaces. so you should not include these tablespaces in a tablespace list for this clause. If i want to translate Answer B into an example, it should look like that: USER_TABLESPACES=ALL EXCEPT('system','sysaux','emp'); Apparently something like that is not allowed, therefor Answer B is wrong Correct answers are D, F
did you take the exam?
if the NONE option is specified, all tablespaces except SYSTEM, SYSAUX, or TEMP are excluded since this clause does not apply to these tablespaces
I'd say B is correct. The documentation says: "Specify NONE to exclude all tablespaces." and later "This clause does not apply to the SYSTEM, SYSAUX, or TEMP tablespaces." That is, when specifying NONE, only SYSTEM, SYSAUX and TEMP will be included. And that's what answer B says. https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/overview-of-pdb-creation.html#GUID-1C47D543-8376-48AE-A1AE-632316731D59
This one is tricky, and I found 3 correct answers. The USER_TABLESPACE clause is available for use in 3 scenarios. A. When creating a PDB from SEED. B. When cloning an existing PDB. C. When creating a PDB from XML File USER_TABLESPACE has 4 choices: (This clause lets you specify the tablespaces to be made available in the new PDB. The SYSTEM, SYSAUX, and TEMP tablespaces are available in all PDBs and cannot be specified in this clause.) 1. Specify tablespace to make the tablespace available in the new PDB. You can specify more than one tablespace in a comma-separated list. 2. Specify ALL to make all tablespaces available in the new PDB. This is the default. 3. Specify ALL EXCEPT to make all tablespaces available in the new PDB, except the specified tablespaces. 4. Specify NONE to make only the SYSTEM, SYSAUX, and TEMP tablespaces available in the new PDB. A. is wrong. Default tablespaces are defined with the DEFAULT_TABLESPACE clause. B is correct. See point 4 for USER_TABLESPACE. C is wrong. See description before point 1. D is correct. See point 1. E is wrong. See description before point 1. F is correct. See point 1.
Will B be incorrect? Cause it's 'when plugging in a PDB', Not cloning or creating.
assuming it should be "PDB seed" in F : SQL> create pluggable database pdb4 admin user pdbadmin identified by pdbadmin USER_TABLESPACES=('USERS'); Pluggable database created. Not much sense, but it works.
Correct: B,D A. False. Default tablespaces are defined with the DEFAULT_TABLESPACE clause not with USER_TABLESPACE clause. B. True. Specify NONE in USER_TABLESPACE clause to make only the SYSTEM, SYSAUX, and TEMP tablespaces available in the new PDB. C. False. The USER_TABLESPACE clause is available for use in 3 scenarios: When creating a PDB from SEED, When cloning an existing PDB or When creating a PDB from XML File D. True. When you move a non-CDB to a PDB, and the non-CDB had several schemas that each supported a different application, you can use this clause to separate the data belonging to each schema into a separate PDB. This technique assumes that each schema used a separate tablespace in the non-CDB. E. False. The SYSTEM, SYSAUX, and TEMP tablespaces always are available in all PDBs and cannot be specified in this clause F. False. When create PDB from seed no users tablespaces are defined in seed container
Hello. Answer F is false. Database cdb@seed have only dictionary structures. This database have only system tablespaces (SYSTEM, SYSAUX ...). In this time we omit user_tablespace clause. https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13850 This is tricky question. :). Corect are B and D.
DF i think
DF ithink
F is wrong. You don't have user tablespaces in PDB$SEED.
from https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC, there is no user_tablespaces in syntax. F is wrong
B and D correct. F incorrect based on my reading of the doc - "This clause lets you specify the tablespaces to be made available in the new PDB. The SYSTEM, SYSAUX, and TEMP tablespaces are available in all PDBs and cannot be specified in this clause. " https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC
as explained here: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC
I think BD as well. I looked in the syntax diagrams and the user_tablespace clause is also valid for answer F. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC
https://oracle-base.com/articles/12c/multitenant-user_tablespaces-clause-12c Remember, the SYSTEM, SYSAUX and TEMP tablespaces are always included.
B= with NONE D=Specify tablespace to make the tablespace available in the new PDB
I found https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC04DB1FFC very helpfull. See user_tablespaces_clause
Not C : USER_TABLESPACE is a clause for CREATE PLUGGABLE DATABASE options: (create_pdb_from_seed, create_pdb_clone, create_pdb_from_xml) and not an option for RELOCATION clause.