sqlplus cncusg1o/cncusg1o@TSTDB1<<!
create table log_pps_1005 as select * from log_pps;
create table log_bps_fcc8_1005 as select * from log_bps_fcc8;
create table err_bps_fcc8_1005 as select * from err_bps_fcc8;
create table LOG_BPS_FLOV_1005 as select * from LOG_BPS_FLOV;
exit;
!
echo "backup success";
这是在UNIX底下的一个脚本,现在不明白的地方是第一行的"<<!" 和倒数第2行的"!"
我当然也有自己的理解。
但请高手分别帮我解释下吧。
create table log_pps_1005 as select * from log_pps;
create table log_bps_fcc8_1005 as select * from log_bps_fcc8;
create table err_bps_fcc8_1005 as select * from err_bps_fcc8;
create table LOG_BPS_FLOV_1005 as select * from LOG_BPS_FLOV;
exit;
!
echo "backup success";
这是在UNIX底下的一个脚本,现在不明白的地方是第一行的"<<!" 和倒数第2行的"!"
我当然也有自己的理解。
但请高手分别帮我解释下吧。
sqlplus '/ as sysdba' <<eof
{
shutdown immediate;
startup force dba pfile=$ORACLE_HOME/dbs/init.ora;
shutdown immediate;
}
exit;
eof------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977