Difference between revisions of "Creating a tablespace"

CREATE TABLESPACE <tablespacename>
DATAFILE    <filename>     [SIZE <nn> [K|M]| REUSE]     [AUTOEXTEND ON
[  NEXT n [K|M]]     [MAXSIZE    [n [K|M ]   |   UNLIMITED]]  |  OFF
[   MINIMUM  EXTENT  integer  [K|M]  ]
[   BLOCKSIZE  integer  [K] ]
[  TEMPORARY   |   PERMANENT   ]
[   EXTENT MANAGEMENT [  LOCAL |  DICTIONARY ]  ]
[   LOGGING  |  NOLOGGING  ]
[   ONLINE  |  OFFLINE   ]
[  SEGMENT  SPACE  MANAGEMENT [ MANUAL  |  AUTO  ]  ];