at the time creation of database system tablespace is created if by using dbca it automatically created by the time of creation of database. if you create manually if give system tablespace or not it will create automatically. after creation of database there no command to create the system tablespace. if you losss then you can restore and recover the system tablesapce.
answered Feb 26 '10 at 05:14 AM
The system tablespace is used to store the database's own objects, such as the data dictionary.
It's created by the CREATE DATABASE command.
answered Dec 22 '09 at 12:52 PM