我想把下面两个文件合并起来,全都写在1.bat里面,可以吗?1.bat
内容如下:
echo 开始...
echo exit|sqlplus username/password@orcl as sysdba @script.sql
echo 略。。
echo 结束script.sql
内容如下:
----删除用户
drop user test cascade;
/
----创建用户zjif
CREATE USER testIDENTIFIED BY "test"
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
---略
内容如下:
echo 开始...
echo exit|sqlplus username/password@orcl as sysdba @script.sql
echo 略。。
echo 结束script.sql
内容如下:
----删除用户
drop user test cascade;
/
----创建用户zjif
CREATE USER testIDENTIFIED BY "test"
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
---略
试试 用一个bat 去调用 另一个bat
echo run {
echo allocate channel Channel1 type disk format '%BACKUP_DIR%\%NAME%';
echo sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
echo release channel Channel1;
echo }
) | rman target /这样的方式
@后面必须是文件名,你在@后写的任何东西它都当文件去取的。比如@(run 之类的会说(run.sql打不开之类的。
sqlplus username/password@orcl as sysdba <<EOF
drop user test cascade;
CREATE USER testIDENTIFIED BY "test" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";
exit;
EOF
# Program:#
#This program is a test program.
# History:
# 2010/07/01 HanLiangYuan First releasea
echo -e 'test start \a \n'
su oracle <<EOF
sqlplus / as sysdba
select table_name from dba_tables;
exit;
EOF
echo -e 'test end \a \n'
exit 0
测试成功,谢谢ls.