这个批处理命令要怎么写?

[mofei13975101162]

我想在一个批处理里面作如下的事情,
连接oracle,drop用户,imp 文件.
我是这样写的:
sqlplus system/bjdb@bjdboracle
drop user testbase cascade;
CREATE USER "TESTBASE" PROFILE "DEFAULT" IDENTIFIED BY "testbase" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "TESTBASE" WITH ADMIN OPTION;
GRANT "DBA" TO "TESTBASE" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "TESTBASE" WITH ADMIN OPTION;
exit
imp system/bjdb@bjdboracle file=c:\base200301061404.dmp fromuser=base touser=testbase ignore=y constraints=y
cmd

但是很可惜,事情不像我想像中那么好,它第一步就停止了,大家说我该怎么办?我该怎么解决,我希望一个详细点的办法.我就只有最后的12分了,都交给大侠你了:((

[jiezhi]

in your bat file:
sqlplus @your.sql
in your.sql:
connect ....
............


please just try this,I did not test.

[mofei13975101162]

呵呵,谢谢jiezhi(西域浪子) 大哥,完全正确.