Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQLPlus - execute a remote script
50 views
Skip to first unread message
Noixe
Sep 16, 2011, 9:11:39 AM9/16/11
to
Hello,
I have on ftp server a script for sqlplus. I have tried this syntax to
execute it:
sqlplus userdb/passdb@namedb @ftp://
user_server:pass_server@ftp_address/directory_of_file/file.sql
but after the connection sqlplus don't work. He seems to be waiting
for input but there is not a prompt (SQL>).
Maybe the syntax used is wrong?
Thanks
I have on ftp server a script for sqlplus. I have tried this syntax to
execute it:
sqlplus userdb/passdb@namedb @ftp://
user_server:pass_server@ftp_address/directory_of_file/file.sql
but after the connection sqlplus don't work. He seems to be waiting
for input but there is not a prompt (SQL>).
Maybe the syntax used is wrong?
Thanks
Paulie
Sep 28, 2011, 8:15:09 AM9/28/11
to
On Sep 16, 2:11 pm, Noixe <midnightm...@live.it> wrote:
> I have on ftp server a script for sqlplus. I have tried this syntax to
> execute it:
active,
spam-free and have very knowledgeable people. Usenet is dead <sheds
tear...>,
but recognising this reality is important and it's time for people to
move on.
Usenet was good in its day - mid-90's to approx. early 2000's. It's
dead now.
Paul...
Chris Hansen
Sep 18, 2012, 6:39:20 PM9/18/12
to
You could always write a bash script which SCP's the file over to the
machine, runs the script and then deletes it.
Or you can run a local script against a remote instance.
This is what little I know unfortunately :c
Robert Klemme
Sep 19, 2012, 1:36:23 AM9/19/12
to
On 09/19/2012 12:39 AM, Chris Hansen wrote:
> On 28/09/11 13:15, Paulie wrote:
>>
>>
>> On Sep 16, 2:11 pm, Noixe<midnightm...@live.it> wrote:
>>
>>> I have on ftp server a script for sqlplus. I have tried this syntax to
>>> execute it:
> On 28/09/11 13:15, Paulie wrote:
>>
>>
>> On Sep 16, 2:11 pm, Noixe<midnightm...@live.it> wrote:
>>
>>> I have on ftp server a script for sqlplus. I have tried this syntax to
>>> execute it:
> As a very recent pseudo-DBA, I don't think this is possible.
>
> You could always write a bash script which SCP's the file over to the
> machine, runs the script and then deletes it.
I don't see the start of this thread so my advice might actually have
>
> You could always write a bash script which SCP's the file over to the
> machine, runs the script and then deletes it.
been given already. One can as well try to use process substitution of
bash and the likes. e.g.
$ sqlplus ... <(wget -o /dev/null -O - 'ftp://....')
> Or you can run a local script against a remote instance.
Kind regards
robert
Eric
Sep 19, 2012, 2:51:13 PM9/19/12
to
On 28/09/11 13:15, Paulie wrote:
>
>
>
>
because of people like you who decided for some inexplicable reason to
prefer web forums.
Eric
--
ms fnd in a lbry
Roy Hann
Sep 20, 2012, 4:50:29 AM9/20/12
to
Eric wrote:
> Usenet is not dead, and if some parts of it appear to be dying that's
> because of people like you who decided for some inexplicable reason to
> prefer web forums.
Amen to that brother.
> Usenet is not dead, and if some parts of it appear to be dying that's
> because of people like you who decided for some inexplicable reason to
> prefer web forums.
I can understand children being too stupid or lazy to realize that a
web-based forum owned, hosted, and managed by a corporation is going to
be moderated, censored and exploited.
I participate in one such forum--unwillingly--and although I am on
first name terms with the CEO and the rest of the senior management of
the company that operates it, I have had some of my posts deleted for
being "off message" or critical.
God help us if Twitter is the only remaining channel for uncensored,
unmoderated comment.
As you say Eric, inexplicable. But then so much is. *sigh*
--
Roy
0 new messages