1、--刪除已有的舊數(shù)據(jù)（表空間和臨時表空間下）

--DROP TABLESPACE USER_DATA INCLUDING CONTENTS AND DATAFILES;

--DROP TABLESPACE USER_TEMP INCLUDING CONTENTS AND DATAFILES;

2、--創(chuàng)建表空間

CREATE? TABLESPACE user_data ?LOGGING ?DATAFILE? 'D:\app\cphmvp\oradata\orcl\user_data201304013.DBF '? ?SIZE 100M ?AUTOEXTEND? ON? ?NEXT? 100M MAXSIZE 10240M ?EXTENT MANAGEMENT LOCAL;

--創(chuàng)建臨時表空間

CREATE?? TEMPORARY? TABLESPACE? user_temp ?TEMPFILE? 'D:\app\cphmvp\oradata\orcl\user_temp20130413.DBF' SIZE 100M ?AUTOEXTEND? ON NEXT? 100M MAXSIZE 10240M ?EXTENT MANAGEMENT LOCAL ?

3、 --創(chuàng)建用戶，指定表空間

CREATE?? USER??cph IDENTIFIED? BY??cph??DEFAULT? TABLESPACE user_data ?TEMPORARY? TABLESPACE user_temp;

4、?--授權(quán) ?

grant connect,resource,dba to cph; ?grant unlimited tablespace to cph; ?

5、?--導(dǎo)入數(shù)據(jù)

-- cmd下??

imp cph/cph file=d:\database_bak\cph201304012.dmp log=d:\cph20130412_imp.log buffer=10000000 rows=y ignore=y full=y

6、備份數(shù)據(jù) 補充

exp userid=cph/cph@orcl owner=cph file=d:\cph201304012.dmp log=d:\cph20130412_imp.logbuffer=67108864 statistics=none grants=n consistent=y??

?

exp userid=pyc2/pyc2 owner=pyc2 file=d:\pyc2_20130801.dmp log=d:\pyc2_20130801.log buffer=67108864 statistics=none grants=n consistent=y

?

?

創(chuàng)建表空間_臨時表空間_用戶_指定表空間_授權(quán)