我想把下面的几个语句做成一个.bat文件,怎么做呀?
搞了半天没搞出来。sqlplus sys/oracle@hdhdwms as sysdba;
shutdown immediate;
startup;
alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;
alter database open;
exit;
搞了半天没搞出来。sqlplus sys/oracle@hdhdwms as sysdba;
shutdown immediate;
startup;
alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;
alter database open;
exit;
shutdown immediate;
startup;
alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;
alter database open;
exit;
将以上内容保存成startup.sql文件在写个startup.bat,内容如下:
sqlplus /nolog @startup.sql
startup.sql中第一行内容应该是:conn sys/oracle@hdhdwms as sysdba;
是的,刚才直接从楼主那复制了..sql开始是:conn sys/oracle@hdhdwms as sysdba;