What are the tablespaces automatically created when you create a new database. What are their uses ? Thanks in advance.
asked
What are the tablespaces automatically created when you create a database ?
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?
Thank you for the answer. I don't have any queries about the creation of database as of now.
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).
Refer the answer posted by Hillbilly Toad.
In Oracle 9i there are 3 tablespaces: sys,undo & temp. In Oracle 10g there are 4 tablespaces: sys,sysaux,undo & temp.
