How to create the equivalent of a "database" in SQL Server (a tablespace -- at least I think that's what I'm doing) in Oracle:

CREATE TABLESPACE "SMACK"
     LOGGING
     DATAFILE 'C:\ORACLE\ORADATA\INSTANCE\SMACK.ora' SIZE 5M
     EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO