1.用户对应表空间,指定数据库默认表空间

create user test1 identified by test1 default tablespace ringidx;

alter database default tablespace ring;
2.创建、增加表空间

create tablespace test_data

logging

datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

ALTER TABLESPACE game

ADD DATAFILE '/oracle/oradata/db/GAME02.dbf' SIZE 1000M;

3.修改数据文件大小

ALTER DATABASE DATAFILE '/oracle/oradata/db/GAME.dbf' RESIZE 4000M;

ITPub博客

表空间与数据文件的管理