ORACLE基本用法及常用命令

切换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#‘;
 
导入整个库
cd /home/oracle/pls
impdp system/sys_8968888 DUMPFILE=zzpls20130911.dmp DIRECTORY=DumpDir LOGFILE= zzpls20130911.log  SCHEMAS=pls
 
 
约束表dba_constraints
C (check constraint on a table) 
P (primary key) 
U (unique key) 
R (referential integrity) 
V (with check option, on a view) 
O (with read only, on a view)
 
oracle 查看某个表的约束
select * from dba_constraints where owner=‘PLS‘ and table_name=‘SHARE_KNOWLEDG_STRUCTURE‘;

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。