oracle 中建立表 資料表空間

drop user oa cascade;刪除oa賬戶 DROP TABLESPACE WEIBOBOX INCLUDING CONTENTS ANDDATAFILES;刪除資料表空間建立暫存資料表空間create temporary tablespace WEIBOBOX tempfile 'C:/app/hechaojie/oradata/orcl/weibobox.dbf'size 50m autoextend on next 50m maxsize 20480m extent management local; 建立資料表空間create tablespace WEIBOBOX  logging datafile 'C:/app/hechaojie/oradata/orcl/weibobox.dbf'size 50m autoextend on next 50m maxsize 20480m extent management local; 建立並指定資料表空間create user username identified bypassword default tablespace user_data temporary tablespace user_temp; 給使用者授權grant connect,resource to username;