Table spaces and Types of table spaces A tablespace is a box for messages (tables, spiders, etc). A collection involves one or more tablespaces, each created up of one or more information. Furniture and spiders are designed within a particular tablespace. Oracle has a control of 64,000 information per collection. Default tablespaces When a new collection is designed, it will have the following tablespaces (as designed by the Database Settings Assistant): SYSTEM (the information dictionary) SYSAUX (optional collection components) TEMP (temporary tablespace, see tablespace kinds below) UNDOTBS1 (undo tablespace, see tablespace kinds below) USERS (default people tablespace created) Tablespace creation To create tablespace in CREATE TABLESPACE statement uses this syntax:- CREATE TABLESPACE <tblspc_name>; Tablespace types Permanent tablespaces Lasting tablespaces are used to store person data and person designed physical objects like furniture, spiders and materializ...
Learn Smartly to Grow and Excellence with ScholarsPurpose