# su - oracle
$ sqlplus /nolog
SQL> conn / as sysdba
Connected.
SQL> create tablespace tbs_name datafile '/opt/oracle10/oradba/dbname.dbf' size 10m; //建表空间`
Tablespace created.
SQL> create user myname identified by mypass default tablespace tbs_name; //建用户
User created.
SQL> grant connect to myname; //连接权限
Grant succeeded.
SQL> grant resource to myname; //其他所有权限
Grant succeeded.
SQL> drop user myname cascade;//删除用户
User dropped.
SQL> DROP TABLESPACE tbs_name INCLUDING CONTENTS AND DATAFILES; //删除表空间