用oralce 自帶工具sql developer 創建

/*第1步：創建臨時表空間? */

create temporary tablespace hudongtemptablespace

tempfile 'E:\worksubject\WY-Honda_Ess\Oracle11g\hudongtemptablespace.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

/*第2步：創建數據表空間? */

create tablespace hudongtablespace

logging

datafile 'E:\worksubject\WY-Honda_Ess\Oracle11g\hudongtablespace.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

/*第3步：創建用戶并指定表空間? */

create user hudong identified by hudong

default tablespace hudongtablespace

temporary tablespace hudongtemptablespace;

/*第4步：給用戶授予權限? */

grant connect,resource,dba to hudong;

當刪除表空間時，要做以下操作：解決oracle 錯誤：ORA-01219

1、?? ?alter database datafile 'E:\worksubject\WY-Honda_Ess\Oracle11g\HONDAESS_TEMP.DBF' offline drop;

2、 alter database open;

備份數據庫：exp userid=hudong/hudong@sales file=D:\appprd20140310.dmp

還原數據庫 ：imp hudong/hudong@testsales full = y file=e:\appprd20140311.dmp ignore=y