#登陆oracle
SQL> sqlplus system/system as sysdba;
#更换用户
SQL> conn / as sysdba;
#创建用户
SQL>create user username identified by password ;
#为创建用户赋予dba权限
SQL> grant dba to username;
#新建用户登陆
SQL> conn username/password ;
#建立表空间指定区尺寸为128k,如不指定,区尺寸默认为64k
SQL>create tablespace test_data logging datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local ;
#修改表空间大小
SQL>alter database datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf' resize 10240m