Sample Code for creating a tablespace using the Oracle command line

Create smallfile tablespace "newts" datafile 'd: \ app \ oracle \ oradata \ orcl11g \ newts01.dbf 'size 100 m autoextend on next 10 m maxsize 200 mlogging/* all operations on segments in the tablespace will generate redo content, which is the default practice, you can disable the "generate redo" option for very few operations (such as generating indexes) */extent management local/* tablespace to use bitmap to allocate intervals, this is the default */segment space management Auto/* method. bitmap is used to track block usage. This is the default method */default nocompress;