Oracle数据库的导入/导出

step 1:
-------------------------------------
# sqlplus /nolog
SQL>connect / as sysdba //os authorization
or
SQL>connect sys/password as sysdba; //password authorization

step 2:
-------------------------------------
sql>shutdown immediate; //立即关闭数据库
sql>startup open read only; //只读的方式启动数据库
or
SQL>startup restrict; //受限的方式（只能dba访问）启动数据库
SQL>quit;

step 3:
-------------------------------------
#exp userid=system/password owner=test file=/exp/user.dmp log=/exp/exp.log //导出dmp文件，用户是test
#imp userid=system/password fromuser=test touser=admin file=/exp/user.dmp log=/exp/imp.log //导入dmp文件，导入用户是admin

step 4:
-------------------------------------
重复step 1的操作，登陆oracle
SQL>shutdown immediate; //立即关闭oracle
SQL>startup; //正常启动数据库