question

OracleApprender avatar image
OracleApprender asked

What are the tablespaces automatically created when you create a database ?

What are the tablespaces automatically created when you create a new database. What are their uses ? Thanks in advance.

oracledatabasetablespace
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image
HillbillyToad answered

SYSTEM - reserved for the management of the database TEMP - temp space for sorts and other fun math stuff UNDO - stores uncommitted transactions in case you want to roll them back

That's a pretty brief description, you have a specific question about how to create a database?

3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OracleApprender avatar image OracleApprender commented ·
Thank you for the answer. I don't have any queries about the creation of database as of now.
0 Likes 0 ·
Christian13467 avatar image Christian13467 commented ·
If this is the answer. Mark it as answer!
0 Likes 0 ·
HillbillyToad avatar image HillbillyToad commented ·
LOL, thanks Christian for the grin today :)
0 Likes 0 ·
Andrew Mobbs avatar image
Andrew Mobbs answered

SYSTEM and SYSAUX are mandatory tablespaces and created by the CREATE DATABASE command. TEMP and UNDO are optional in the CREATE DATABASE but highly recommended (if you fail to specify them, you'll get temp and rollback segments created in the SYSTEM tablespace).

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image HillbillyToad commented ·
Thanks, forgot all about our friend 'SYSAUX'
0 Likes 0 ·
OracleApprender avatar image
OracleApprender answered

Refer the answer posted by Hillbilly Toad.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sandy 1 avatar image
Sandy 1 answered

In Oracle 9i there are 3 tablespaces: sys,undo & temp. In Oracle 10g there are 4 tablespaces: sys,sysaux,undo & temp.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.