Re: running a script from dos

From: Venkat <vreddy_at_ix.netcom.com>
Date: Tue, 19 May 1998 11:55:38 -0400
Message-ID: <6jsa20$jmg@dfw-ixnews8.ix.netcom.com>

You can do it 2 ways. The first is useful for repeated use or scheduling

create a file called C:\createuser.sql and put all the create tablespace, user commands in there. Then put the following in a .bat file and call from DOS with 4 parameters separated by spaces (xyz.bat scott tiger ORCL C:\orant)

1. oracle userid
2. passowrd
3. connect string
4. oracle Home (usually C:\rant on NT and C:\orawin95 on Win95)

%4\bin\sqlplus.exe "connect %1/%2@%3" <C:\createuser.sql >C:\crusr%3.log

or something like
SQLPLUS scott/tiger_at_ORCL @C:\createuser.sql

HTH
Venkat

>How can i run a script from DOS that will create an oracle user,
>tablespace etc in Oracle?
>
>Tim Palmer
>
Received on Tue May 19 1998 - 10:55:38 CDT