Operating Systems :: DOS :: Create a .bat file on NT to run svrmrg23, connect internal and run an alter command |
|||
By: Squibi  |
Date: 04/10/2002 00:00:00  |
Points: 100 | Status: Answered Quality : Excellent |
|
I am running Oracle 7.3.4.5 on NT4.0 and need to create a batch file that will run svrmgr23, then connect as internal and then run a few "alter" statements and then exit. Whenever I attempt it the batch file stops as soon as SVRMGR23 is started. Can anyone help? |
|||
| By: VGR | Date: 04/10/2002 08:24:00 | |
Type : Comment |
| could you show me your BAT file ? I suspect that you used CALL which indeed transfers execution control to the called BAT/EXE There are solutions but I would like to see exactly what you're trying to perform. Thanks |
|||
| By: Squibi | Date: 04/10/2002 08:53:00 | |
Type : Comment |
| Here is my batch file @echo off svrmgr23 connect internal/password alter tablespace . . . . exit exit |
|||
| By: VGR | Date: 04/10/2002 09:09:00 | |
Type : Comment |
| just use CALL batch2 and in batch2.BAT place the line svmgr23 This is the first and simpliest solution I think of. |
|||
| By: Squibi | Date: 07/10/2002 03:32:00 | |
Type : Comment |
| Sorry, I am not sure what you are trying to say. |
|||
| By: VGR | Date: 09/10/2002 20:28:00 | |
Type : Answer |
| main BATch : @echo off [...your stuff before the sub-call...] CALL BATCH2 [...your stuff after the sub-call...] [ REM you may use the ERRORLEVEL variable to get the passed result from previous call] ^Z second BATch "BATCH2.BAT" @echo off svmgr23 ^Z is that better explained ? |
|||
| By: Squibi | Date: 09/10/2002 21:25:00 | |
Type : Comment |
| This didnt work but I need to close this and am not sure how else to do it. . . . I was able to get the process to work by having the batch file start svrmgr23 and run an .sql file in the same command line: svrmgr23 command="C:\test.sql" And I set up the SQL to log on and run the alter commands. I wish I could have done this in one file but this works. |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
