Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBCA support for bigfile tablespaces

Franck PachotJun 12 2019 — edited Jun 12 2019

Currently, DBCA creates all datafiles as smallfile tablespaces.

This can be manually changed when generating the scripts (-generateScripts) by adding SET DEFAULT BIGFILE in the CREATE DATABASE statement just before LOGFILE GROUP

A command line option would be nice, something like useBigFile <true | false > which defaults to false but can be set to true.

Comments
Post Details
Added on Jun 12 2019
5 comments
1,334 views