-- Oracle-managed permanent with auto-extendable tablespace:
 
-- syntax: 
CREATE TABLESPACE <tablespace_name>;
 
 
-- example: 
ALTER SYSTEM SET DB_CREATE_FILE_DEST = $ORACLE_BASE/testbed';
CREATE TABLESPACE sales_data;
 
 
 
--Oracle-managed fixed size tablespace (permanent):
 
-- syntax: 
CREATE TABLESPACE <tablespace_name>
DATAFILE AUTOEXTEND OFF;
 
-- example: 
ALTER SYSTEM
SET DB_CREATE_FILE_DEST = $ORACLE_BASE/oradata';
 
CREATE TABLESPACE user_data DATAFILE AUTOEXTEND OFF;
 
 
-- To allow a table to extend itself indefinitely:
 
ALTER TABLE sales_us storage (maxextents unlimited);
 
-- To allow a tablespace to extend itself indefinitely, the 
-- following syntax is used:
 
CREATE tablespace
Sales_US
Datafile
'/test/sandbox/sales/client.dbf'
size
400M
AUTOEXTEND ON
next 20M 
MAXSIZE UNLIMITED;