CREATE TABLESPACE sqljunkie
logging
datafile ‘C:\app\oradata\orcl\sqljunkie.dbf’
size 32m
autoextend ON NEXT 32m
maxsize 2048m extent management local;
CREATE undo TABLESPACE
sqljunkie_undodatafile ‘C:\app\oradata\orcl\undo.dbf’
size 100M;
CREATE TEMPORARY TABLESPACE sqljunkie_temptempfile
‘C:\app\oradata\orcl\sqljunkie_temp.dbf’
size 32m
autoextend ON NEXT 32m
maxsize 2048m extent management local;
CREATE USER sqljunkie
IDENTIFIED BY sqljunkieDEFAULT
TABLESPACE sqljunkie
TEMPORARY TABLESPACE sqljunkie_temp;