Create Table space statement in Oracle!

1 create tablespace db_name

2 datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ db_name _. dbf'size 200 m

3 autoextend on next 10 m maxsize unlimited Logging

4 extent management local autoallocate

5 segment space management auto;

Explanation:

1. create a tablespace named db_name; 2. the tablespace has a data file *. DBF, 200 MB in size; 3. allows automatic expansion of tablespaces (autoextends), increasing by 10 MB (next 10 m) each time without limiting the maximum size; 4. it indicates that the tablespace is managed locally and the range is automatically allocated (autoallocate). You cannot specify the range size. segment space (segment) uses bitmaps (auto) to manage data blocks. Using Auto has better space utilization and efficiency than using manual.