What are the tablespaces automatically created when you create a new database. What are their uses ? Thanks in advance.
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).
No one has followed this question yet.
Between EXISTS and In which one is more performance friendly ?
Relationship among database, tablespace and data file ?
What is the difference between restoring and recovering?
How to add one more field to the below existing table ?
Can we restore a dropped table after a new table with the same name has been created?