切换ORACLE用户 su - oracle

----------------------------

重启数据库

sqlplus sys / as sysdba

shutdown immediate

startup;

----------------------------

导出单个表

exp pls/yjt_pls2013@yjt file=/home/oracle/boz.dmp tables=EDU_VERSION_SET_AREA;

导入单个表

imp pls/yjt_pls2013@yjt file=RMS_RESOURCEBODY.dmp tables=EDU_VERSION_SET_AREA;

exp tms/zzvcomTMS@youjt file=/home/oracle/boz.dmp tables=EDU_VERSION_SET_AREA;

导出整个库

su -oracle

sqlplus / as sysdba

create or replace directory DumpDir as '/home/oracle/pls';

exit

cd /home/oracle/pls

expdp pls/yjt_pls DUMPFILE=zzpls2013.dmp DIRECTORY=DumpDir LOGFILE=zzpls2013.log SCHEMAS=pls

导入整个库

导入前先删除这个用户

su - oracle

sqlplus system/sys_98921

drop user PLS cascade;

commit;

exit

如果提示无法删除当前连接的用户

select username,sid,serial# from v$session where username like 'pls';

alter system kill session 'sid,serial#';

ITPub博客

ORACLE基本用法及常用命令