create tablespace testspace
nologging
datafile 'g:\testspace.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create temporary tablespace testspace_temp
tempfile 'c:\testspace_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create user test identified by test
default tablespace testspace
temporary tablespace testspace_temp;
grant connect,resource,dba to test;
nologging
datafile 'g:\testspace.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create temporary tablespace testspace_temp
tempfile 'c:\testspace_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create user test identified by test
default tablespace testspace
temporary tablespace testspace_temp;
grant connect,resource,dba to test;