dbca does not allow creating default bigfile tablespace in a pdb
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database Configuration Assistant - Version 188.8.131.52 and later
Information in this document applies to any platform.
When run dbca to either create a container database including a pluggable database or to create a pluggable database under an existing container database, there is no way to specify that the default tablespace of the
pluggable database is created using bigfile.
Also When creating database using "custom database" template in dbca in step 11/14 after choose "customize storage locations"
and then when editing chosen tablespace and change the status of check boxes "use automatic segment space management" or "use bigfile tablespace",
after applying the changes by pressing "Appy" button, the status of this check boxes will be changed for all tablespaces not just for the one edited.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms