Tablespaces,”Tablespaces are the first level of logical organization of your physical storage. Each tablespace is responsible for organizing one or more data files. Typically, each tablespace might start attached to one data file, but as the database grows and your files become large
you may decide to add storage in the form of multiple data files.Every 11g database should have the following tablespaces:SYSTEM: Stores the core database objects that are used for running the database itself.SYSAUX: For objects that are auxiliary and not specifically tied to the core features of the database.UNDO: Stores the rollback or undo segments used for transaction recovery.TEMP: For temporary storage.”