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).
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.
How to recover the file from the Tablespace?
Can flashback of database be implemented more than once after resetlogs?
What view would we use to look at the size of a data file?
What is the maximum no.of columns a table can have ?
Insert a row to a table and create another table then say Rollback. Will the row be inserted ?