Oracle Database Discussions

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!

Bigfile tablespace for system tablespace.

BM_exa-OracleAug 25 2014 — edited Aug 25 2014

I am trying to create a database with bigfile tablespaces for SYSTEM tablespace as well. I can use dbca to create it and set bigfile tablespace to SYSTEM tablespace.

How can I create bigfile system tablespace with CREATE DATABASE statement? Can any one help with the syntax?

Even though normal tablespace is enough for system, I was just checking if there is a syntax available to create.

Thanks,

Bhanu

This post has been answered by Srini Chavali-Oracle on Aug 25 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2014

Added on Aug 25 2014

#general-database-discussions

7 comments

504 views