Oracle数据库的导入/导出

snakeskin

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;//正常启动数据库