Sql代碼
create user username identified by password; 創建用戶
grant dba to username; 權限
drop user username cascade; 刪除用戶
CREATE TABLESPACE 表空間名 DATAFILE C:\Oracle\product\\oradata\orcl\備份文件dbf SIZE G ON NEXT M MAXSIZE UNLIMITED 數據導入創建表空間
drop tablespace 表空間名 including contents and datafiles; 刪除表空間
From:http://tw.wingwit.com/Article/program/Oracle/201311/18171.html