What are the tablespaces automatically created when you create a new database. What are their uses ? Thanks in advance.
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?
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.
No one has followed this question yet.