ora11g oracle批量操作
一、ora11g oracle批量锁表
脚本如下(示例):
#!/bin/ksh
export PATH=.:/opt/ora11g/app/product/11.2.0/bin:$PATH
export ORACLE_HOME=/opt/ora11g/app/product/11.2.0
echo "
begin
for rec in (
select 'lock table '||t.OWNER||'.'||t.TABLE_NAME||' in share mode ' txt from dba_tables t where t.OWNER='PRODUCT' AND T
.TABLE_NAME LIKE 'UP%'
)
loop
execute immediate rec.txt;
end loop;
dbms_lock.sleep(1080);
commit;
end;
/
"|sqlplus -s_lock_product_162 oracle账户/密码@数据链 >rec.log 2>&1 &
echo "lock 完成"
锁定oracle,PRODUCT用户,表名为UP开头的表
2.ora11g oracle批量解锁表
脚本如下(示例):
#!/bin/ksh
ps -ef | grep lock_product | grep -v grep | awk '{printf "kill -9 %s \n",$2}'|sh
echo "Release lock product!"
总结
以上就是今天要讲的内容,很简单,勤练习即可。