1.start/cmd:exp system/manager@ea21sg2t full=y file=e:/oracle/ea21sg2t.dmp log=ea21sg2t.log
2.create database.
3.start/cmd:svrmgrl
connect internal/oracle@ea21sg2t
@f:/setupOracle/tablespace.sql
tablespace.sql:
spool E:/oracle/admin/ea21sg2t/create/createdb1_ea21sg2tidx.log
drop tablespace RHOMBUS_CM_TS_DATA including contents;
CREATE TABLESPACE RHOMBUS_CM_TS_DATA
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/cm/CMMODULE01_RHOMBUSSG6T.DBF' SIZE 100M REUSE;
drop tablespace EA21_MF_TS_DATA including contents;
CREATE TABLESPACE EA21_MF_TS_DATA
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/mf/mfmodule01_ea21sg2t.dbf' SIZE 1400M REUSE;
drop tablespace EA21_QT_TS_DATA including contents;
CREATE TABLESPACE EA21_QT_TS_DATA
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/qt/qtmodule01_ea21sg2t.dbf' SIZE 500M REUSE;
drop tablespace EA21_CO_TS_DATA including contents;
CREATE TABLESPACE EA21_CO_TS_DATA
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/co/comodule01_ea21sg2t.dbf' SIZE 1200M REUSE;
drop tablespace EA21_SI_TS_DATA including contents;
CREATE TABLESPACE EA21_SI_TS_DATA
DATAFILE 'E:/ORACLE/ORADATA/ea21sg2t/si/simodule01_ea21sg2t.dbf' SIZE 200M REUSE;
..................................
If there is not the directory such as cm,mf,qt,co,si,you must create the directory fistly .
4.imp system/manager@ea21sg2t file=e:/oracle/ea21sg2t.dmp log=d:/oracle/ea21sg2t.log full=y grants=y
if there is error,after opening another start/cmd:alter user system identified by manager,try above command again.
caution:if the imp failed, you can try again after removing all table using truncate table t1; truncate table t2;.If there is a error such as "warning objects were exported by EXP_USER ,not by you :",you can try it again after changing the system/manager to developer/developer.
5.oracle dba studio/storage/tablespaces,change the size according to the percent such as system,temp.