HELP: Change user in .SQL script

From: Morgan Skinner <morgan.skinner_at_fisons-ls.com>
Date: 1995/06/19
Message-ID: <3s3qsu$bvu_at_alterdial.UU.NET>#1/1

Hopefully this is a no brainer for someone out there. I have a .SQL script in which I want to do the following. Anyone got any suggestions...

CONNECT usera/passworda

... Do some SQL stuff

CONNECT userb/passwordb

... Do some more stuff

The problem is that the machine halts after the first command ( I assume it is looking for a termination character or something like that). I have scripts that will do this from the command line, but I want to put all of this in one .SQL file.

I was the Englishman in PM122 & PM123 with the Questions

email : morgan.skinner_at_fisons-ls.com Received on Mon Jun 19 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Akira Hashimoto: "Re: Cant drop tablespace"
Previous message: Andrew McAllister: "Full Export Hangs Oracle and Entire Machine"
Next in thread: Steve Butler: "Re: HELP: Change user in .SQL script"
Reply: Mike Ressler: "Re: HELP: Change user in .SQL script"
Reply: Steve Butler: "Re: HELP: Change user in .SQL script"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message