Create a tablespace in Oracle and create a user

Create a tablespace in Oracle and create a user

//Create temporary tablespace

Create TemporaryTablespace test_temp
Tempfile'E: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf'
Size 32 m
AutoextendOn
Next32 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 a tablespace
Create UserTestserver_user identifiedByTestserver_user
DefaultTablespace test_data
TemporaryTablespace test_temp;

//Grant permissions to users

GrantConnect, ResourceToTestserver_user;

//Log on with this user. 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.

 

From: http://www.cnblogs.com/wangdetian168/archive/2008/06/16/1223370.html