请åèä¸é¢è¿ä¸ªæ¹æ³ï¼
å¤æ³¨ï¼getDbUserByTableName $TableNameæ¯è·å表å¨åªä¸ªæ°æ®åºçãä½ å¯ä»¥ç´æ¥æ$DbUSERæ¢ætns串æè
å«åå³å¯ã
#sqlplusè¿æ¥æ°æ®åºçæ¹æ³
#éè¦ä¼ å
¥ä¸¤ä¸ªåæ°ï¼ç¬¬ä¸ä¸ªæ¯è¡¨åï¼ä¸ä¸ªæ¯éè¦æ§è¡çsqlè¯å¥ï¼ä¸æ¡è¯å¥ä½ä¸ºä¸è¡
sqlBossDb(){
TableName=$1
SqlStr=$2
getDbUserByTableName $TableName
DbUSER=`cat dbuser.temp`
Note_Log "$DbUSERè¿æ¥æ°æ®åºï¼æ§è¡è¯å¥$SqlStr"
eval echo \${$DbUSER} >aaa.temp #æ¥è¯¢åºæ¥æ¯sqlDbUser.cfgä¸DBUSERNAME项ï¼éè¦æ¢æDBUSERSTR项
DbUSER=`cat aaa.temp`
#Note_Log "å¼å§ $DbUSER"
sqlplus $DbUSER <<!
set linesize 1000
$SqlStr
commit;
quit
!
e