数据库批量建表:
1.登录服务器,切换oracle用户 su - oracle
2.将DDL文件放至目录,按照组件生成批量建表脚本
#!/bin/bash
cd DDL
for file in $(ls *)
do
ap=../@${file:0:4}.sh
if[! -f $ap];then
echo "cd /home/db/oracle/DDL">$ap
echo "sqlplus -s 数据库连接串 <<!">$ap
echo "SPOOL ../createdb.log APPEND">$ap
fi
echo @${file}>> $ap
done
cd ..
for fjob in $(ls @*)
do
echo "SPOOL OFF;">>$fjob
echo "exit;">>$fjob
echo "!">>$fjob
done
3.执行生成的批量建表脚本:
3.1建表脚本
#!/bin/bash
sh @TBAF.sh
SPOOL OFF
exit;
!
3.2建主键脚本
#!/bin/bash
sh @TRAF.sh
SPOOL OFF
exit;
!
3.3建索引脚本
#!/bin/bash
sh @TXAF.sh
SPOOL OFF
exit;
!