// Create a temporary tablespace
Create temporary tablespace test_temp
Tempfile 'e: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf'
Size 32 m
Autoextend on
Next 32 m maxsize 2048 m
Extent management local;
// Create a data table space
Create tablespace test_data
Logging
Datafile 'e: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_data01.dbf'
Size 32 m
Autoextend on
Next 32 m maxsize 2048 m
Extent management local;
// Create a user and specify the tablespace
Create user testserver_user identified by testserver_user
Default tablespace test_data
Temporary tablespace test_temp;
// Grant permissions to users
Grant connect, resource to testserver_user;
// Log on to the user later. Any database objects created belong to the test_temp and test_data tablespaces. Therefore, you do not need to specify a tablespace for each object created.