CreateDBFiles.sql

connect SYS/&&sysPassword as SYSDBA
set echo on

spool /xfer/oracle/OraHome10g/assistants/dbca/logs/CreateDBFiles.log

CREATE TABLESPACE "USERS" LOGGING 
DATAFILE '/u01/oracle/10g/ILMG1/data/users01.dbf' SIZE 5M 
REUSE AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED 
EXTENT MANAGEMENT LOCAL 
SEGMENT SPACE MANAGEMENT  AUTO ;

ALTER DATABASE DEFAULT TABLESPACE "USERS";

spool off