Re: SQL*Plus with readline
On Wed, 17 Dec 2003, Carel-Jan Engel wrote: > > > On Tue, 16 Dec 2003, Carel-Jan Engel wrote: > >> Does this tool have the same 'functionality'? So, be carefull, or take > >> advantage of it ;-). > > > > Nope, the only history it stores are the commands you type once the > > program it execs is fired up. Now, if you connect scott/tiger from within > > sqlplus, you're on thin ice, but I usually specify which user/db I'm > > connecting to on the command-line and let SQL*Plus ask me for my password. > > So, what happens when SQL*Plus asks for your password? Doesn't that entry > get recorded as well? Nope. It appears the program is smart enough to ignore that line. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus with readline
> On Tue, 16 Dec 2003, Carel-Jan Engel wrote: >> Does this tool have the same 'functionality'? So, be carefull, or take >> advantage of it ;-). > > Nope, the only history it stores are the commands you type once the > program it execs is fired up. Now, if you connect scott/tiger from within > sqlplus, you're on thin ice, but I usually specify which user/db I'm > connecting to on the command-line and let SQL*Plus ask me for my password. So, what happens when SQL*Plus asks for your password? Doesn't that entry get recorded as well? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus with readline
And it has the added benefit of working properly on my system, while uniread does not. Jared On Tue, 2003-12-16 at 16:49, Mladen Gogala wrote: > Daniel, there is gqlplus which does have readline. Look at the > http://gqlplus.sourceforge.net/ > On 2003.12.16 17:09, Daniel Hanks wrote: > > I know there's a lot of folks who grumble about the spartan-ness of SQL*Plus, but > > the only real feature I wish it had was GNU readline capability for command > > history and editing. I've looked at some wrappers (yasql, gasql), as well as > > replacements (henplus, which is quite nice, actually), but today I found something > > that seems to do exactly what I really want--SQL*Plus behavior, augmented with > > readline support (So I can still do stuff like output formatting, spooling, etc., > > etc.,). Yes, I actually dig SQL*Plus, just wish it had readline. > > > > So today I found a little utility called uniread: > > > > http://sourceforge.net/projects/uniread/ > > > > It's a Perl program that > > > > "adds full readline support (command editing, history, etc.) to any existing > > interactive command-line program. Common examples are Oracle's sqlplus or jython. > > uniread will work on any POSIX platform with Perl." > > > > I tried it out with SQL*plus, and so far seems to work beautifully. Just thought > > I'd share. > > > > -- Dan > > > >Daniel Hanks - Systems/Database Administrator > >About Inc., Web Services Division > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Daniel Hanks > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus with readline
Daniel, there is gqlplus which does have readline. Look at the http://gqlplus.sourceforge.net/ On 2003.12.16 17:09, Daniel Hanks wrote: > I know there's a lot of folks who grumble about the spartan-ness of SQL*Plus, but > the only real feature I wish it had was GNU readline capability for command history > and editing. I've looked at some wrappers (yasql, gasql), as well as replacements > (henplus, which is quite nice, actually), but today I found something that seems to > do exactly what I really want--SQL*Plus behavior, augmented with readline support > (So I can still do stuff like output formatting, spooling, etc., etc.,). Yes, I > actually dig SQL*Plus, just wish it had readline. > > So today I found a little utility called uniread: > > http://sourceforge.net/projects/uniread/ > > It's a Perl program that > > "adds full readline support (command editing, history, etc.) to any existing > interactive command-line program. Common examples are Oracle's sqlplus or jython. > uniread will work on any POSIX platform with Perl." > > I tried it out with SQL*plus, and so far seems to work beautifully. Just thought I'd > share. > > -- Dan > >Daniel Hanks - Systems/Database Administrator >About Inc., Web Services Division > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Daniel Hanks > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus with readline
On Tue, 16 Dec 2003, Carel-Jan Engel wrote: > Don't know this particular one, but ran into a shell on HP-UX with similar > capabilities. I was a developer those days, and the feature I liked most > was its capability to unveil sys/system passwords. Just get this shell > running and ask the DBA to do something from your terminal. After that, the > non-echoed password will be perfectly visible in command-line history > (after the DBA left the scene, of course). They never found out how we were > able to discover their passwords. I think it's now safe to spread the > knowledge around. > Heh. Yeah, there's something on Linux called 'script' that would do that. Basically spawns a shell and sends all the output from that session to a file. > Does this tool have the same 'functionality'? So, be carefull, or take > advantage of it ;-). Nope, the only history it stores are the commands you type once the program it execs is fired up. Now, if you connect scott/tiger from within sqlplus, you're on thin ice, but I usually specify which user/db I'm connecting to on the command-line and let SQL*Plus ask me for my password. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus with readline
On HPUX the ied utility enables command history. Everything you type will be logged to the HISTORY file unless you specify one. -- Denny Koovakattu Quoting Carel-Jan Engel <[EMAIL PROTECTED]>: > At 14:09 16-12-03 -0800, you wrote: > >I know there's a lot of folks who grumble about the spartan-ness of > >SQL*Plus, but the only real feature I wish it had was GNU readline > >capability for command history and editing. I've looked at some wrappers > >(yasql, gasql), as well as replacements (henplus, which is quite nice, > >actually), but today I found something that seems to do exactly what I > >really want--SQL*Plus behavior, augmented with readline support (So I can > >still do stuff like output formatting, spooling, etc., etc.,). Yes, I > >actually dig SQL*Plus, just wish it had readline. > > > >So today I found a little utility called uniread: > > > >http://sourceforge.net/projects/uniread/ > > > >It's a Perl program that > > > >"adds full readline support (command editing, history, etc.) to any > >existing interactive command-line program. Common examples are Oracle's > >sqlplus or jython. uniread will work on any POSIX platform with Perl." > > > >I tried it out with SQL*plus, and so far seems to work beautifully. Just > >thought I'd share. > > > >-- Dan > > > >Daniel Hanks - Systems/Database Administrator > >About Inc., Web Services Division > > > > Don't know this particular one, but ran into a shell on HP-UX with similar > capabilities. I was a developer those days, and the feature I liked most > was its capability to unveil sys/system passwords. Just get this shell > running and ask the DBA to do something from your terminal. After that, the > > non-echoed password will be perfectly visible in command-line history > (after the DBA left the scene, of course). They never found out how we were > > able to discover their passwords. I think it's now safe to spread the > knowledge around. > > Does this tool have the same 'functionality'? So, be carefull, or take > advantage of it ;-). > > > Regards, Carel-Jan > > === > If you think education is expensive, try ignorance. (Derek Bok) > === > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Carel-Jan Engel > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > This message was sent using IMP, the Internet Messaging Program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus with readline
At 14:09 16-12-03 -0800, you wrote: I know there's a lot of folks who grumble about the spartan-ness of SQL*Plus, but the only real feature I wish it had was GNU readline capability for command history and editing. I've looked at some wrappers (yasql, gasql), as well as replacements (henplus, which is quite nice, actually), but today I found something that seems to do exactly what I really want--SQL*Plus behavior, augmented with readline support (So I can still do stuff like output formatting, spooling, etc., etc.,). Yes, I actually dig SQL*Plus, just wish it had readline. So today I found a little utility called uniread: http://sourceforge.net/projects/uniread/ It's a Perl program that "adds full readline support (command editing, history, etc.) to any existing interactive command-line program. Common examples are Oracle's sqlplus or jython. uniread will work on any POSIX platform with Perl." I tried it out with SQL*plus, and so far seems to work beautifully. Just thought I'd share. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division Don't know this particular one, but ran into a shell on HP-UX with similar capabilities. I was a developer those days, and the feature I liked most was its capability to unveil sys/system passwords. Just get this shell running and ask the DBA to do something from your terminal. After that, the non-echoed password will be perfectly visible in command-line history (after the DBA left the scene, of course). They never found out how we were able to discover their passwords. I think it's now safe to spread the knowledge around. Does this tool have the same 'functionality'? So, be carefull, or take advantage of it ;-). Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
I'm sure there are many ways to perform complex validations a shell script. And I needed a simple solution so I opted for the easy way. Unfortunately, I'm not an expert shell programmer yet. Fortunately, I did receive many good suggestions from the list to help me progress in my quest to learn Korn Shell. Thanks, Saira -Original Message- Thater, William Sent: November 7, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: > The "sleeping beauty" suggestion works extremely well, if you are > patient. Patience, you know, is a virtue and my goal is to promote > fair and balanced view to the database. me, i want my patience RIGHT NOW!;-) BTW, is there any chance of validating the input before it gets passed to the procedure? -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Before God we are all equally wise - and equally foolish. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
Hee hee... I am indeed a novice, but I make fairly sound judgments based on the name of a function :) -Original Message- Jamadagni, Rajendra Sent: November 7, 2003 9:30 AM To: Multiple recipients of list ORACLE-L Don't tell me you tried it MG, another feather for your Cap ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Friday, November 07, 2003 9:17 AM To: Multiple recipients of list ORACLE-L I like this solution. It works way better than the dbms_lock.sleep() suggestion ;) Thank you. Saira ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
Mladen Gogala scribbled on the wall in glitter crayon: > The "sleeping beauty" suggestion works extremely well, if you are > patient. Patience, you know, is a virtue and my goal is to promote > fair and balanced view to the database. me, i want my patience RIGHT NOW!;-) BTW, is there any chance of validating the input before it gets passed to the procedure? -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Before God we are all equally wise - and equally foolish. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus errors... how to hide?
The "sleeping beauty" suggestion works extremely well, if you are patient. Patience, you know, is a virtue and my goal is to promote fair and balanced view to the database. On 11/07/2003 09:17:12 AM, Saira Somani-Mendelin wrote: > I like this solution. It works way better than the > dbms_lock.sleep() suggestion ;) > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
Don't tell me you tried it MG, another feather for your Cap ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Friday, November 07, 2003 9:17 AM To: Multiple recipients of list ORACLE-L I like this solution. It works way better than the dbms_lock.sleep() suggestion ;) Thank you. Saira ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
I like this solution. It works way better than the
dbms_lock.sleep() suggestion ;)
Thank you.
Saira
-Original Message-
Sent: November 6, 2003 3:54 PM
To: [EMAIL PROTECTED]
Cc: Saira Somani-Mendelin
Catch the error in an exception clause and ignore it.
SQL> set serveroutput on
SQL> run
1 declare
2 x number ;
3 begin
4 x := to_number ('123^') ;
5 exception
6 when value_error
7 then
8dbms_output.put_line ('Bad Number') ;
9 when others
10 then
11raise ;
12* end ;
Bad Number
Procedura PL/SQL completata correttamente.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Saira Somani-Mendelin
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
If the data is supposed to be strictly numeric, you can intercept the bad
data prior to running the sql.
X=''
while [ -z "$X" ]; do
echo ""
echo "Enter a number or Q to quit"
read X
if [ "$X" = "Q" ]; then
echo "Exiting ..."
exit 0
fi
if [ -z "$X" ]; then
echo ""
echo "That was a blank entry. Try again."
echo ""
continue
fi
if [ -n "`echo $X | sed -n '/[^0-9]/p'`" ]; then
echo ""
echo "You entered at least one non-numeric character."
echo "You entered ->${X}<-"
echo "Try again."
echo ""
X=""
continue
fi
done
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
=)
Why not do
whenever sqlerror exit 1
Bambi.
-Original Message-
Sent: Thursday, November 06, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
You might be inclined to try something like:
DECLARE
...
BEGIN
.
EXCEPTION
WHEN INVALID_NUMBER THEN
DBMS_LOCK.SLEEP(365*24*3600);
END;
/
On 11/06/2003 03:44:26 PM, Saira Somani-Mendelin wrote:
> List,
>
> I have a shell script that executes a sql*plus script (which executes a
> procedure) based on user input.
>
> But what if the user inputs an invalid datatype? The exception section
> handles the error and displays a user-friendly message but I still get
> an error stack. I want to hide this from the user. How can I do this? I
> have set feedback and echo options off. See output below:
>
> PO Reconciliation Batch Release
>
>
> Enter batch number to be released:
> yrugis
> You have entered an invalid number! Exiting program...
> **[I want to suppress the errors below]**
> BEGIN RELEASE_PO_B_H('yrugis'); END;
>
> *
> ERROR at line 1:
> ORA-01722: invalid number
> ORA-06512: at "TRAIN65D.RELEASE_PO_B_H", line 16
> ORA-06512: at line 1
>
> Thanks,
> Saira
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Saira Somani-Mendelin
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bellow, Bambi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
most appropriate way is to use a
begin
..
exception
when invalid_number then
dbms_output.put_line('Sorry, a batch number must be numeric, please try again.');
when ...
..
end
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Thursday, November 06, 2003 4:54 PM
To: Multiple recipients of list ORACLE-L
Saira,
How about use the same method as suggested in another thread, i.e. pipe and
remove unwanted text? In your case
whatever comes in | sed -n '/^BEGIN/,/^ORA-06512: at line/!p'
Yong Huang
--- Saira Somani-Mendelin <[EMAIL PROTECTED]> wrote:
> List,
>
> I have a shell script that executes a sql*plus script (which executes a
> procedure) based on user input.
>
> But what if the user inputs an invalid datatype? The exception section
> handles the error and displays a user-friendly message but I still get
> an error stack. I want to hide this from the user. How can I do this? I
> have set feedback and echo options off. See output below:
>
> PO Reconciliation Batch Release
>
>
> Enter batch number to be released:
> yrugis
> You have entered an invalid number! Exiting program...
> **[I want to suppress the errors below]**
> BEGIN RELEASE_PO_B_H('yrugis'); END;
>
> *
> ERROR at line 1:
> ORA-01722: invalid number
> ORA-06512: at "TRAIN65D.RELEASE_PO_B_H", line 16
> ORA-06512: at line 1
>
> Thanks,
> Saira
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
**
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
**5
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jamadagni, Rajendra
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL*Plus errors... how to hide?
See the Code below. It worked fine for me.
Probably you have a raise_exception_error somewhere in the procedure.
SQL> create procedure RELEASE_PO_B_H ( in_number varchar2 ) is
2v_number number;
3 begin
4v_number := in_number;
5 exception
6when value_error then
7 dbms_output.put_line('You have entered an invalid number! Exiting
program...');
8 end;
9 /
Procedure created.
$ cat RELEASE_PO_B_H.csh
#!/bin/csh
sqlplus -s <
> List,
>
> I have a shell script that executes a sql*plus script (which executes a
> procedure) based on user input.
>
> But what if the user inputs an invalid datatype? The exception section
> handles the error and displays a user-friendly message but I still get
> an error stack. I want to hide this from the user. How can I do this? I
> have set feedback and echo options off. See output below:
>
> PO Reconciliation Batch Release
>
>
> Enter batch number to be released:
> yrugis
> You have entered an invalid number! Exiting program...
> **[I want to suppress the errors below]**
> BEGIN RELEASE_PO_B_H('yrugis'); END;
>
> *
> ERROR at line 1:
> ORA-01722: invalid number
> ORA-06512: at "TRAIN65D.RELEASE_PO_B_H", line 16
> ORA-06512: at line 1
>
> Thanks,
> Saira
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Saira Somani-Mendelin
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Krishna Kakatur
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL*Plus errors... how to hide?
You might be inclined to try something like:
DECLARE
...
BEGIN
.
EXCEPTION
WHEN INVALID_NUMBER THEN
DBMS_LOCK.SLEEP(365*24*3600);
END;
/
On 11/06/2003 03:44:26 PM, Saira Somani-Mendelin wrote:
> List,
>
> I have a shell script that executes a sql*plus script (which executes a
> procedure) based on user input.
>
> But what if the user inputs an invalid datatype? The exception section
> handles the error and displays a user-friendly message but I still get
> an error stack. I want to hide this from the user. How can I do this? I
> have set feedback and echo options off. See output below:
>
> PO Reconciliation Batch Release
>
>
> Enter batch number to be released:
> yrugis
> You have entered an invalid number! Exiting program...
> **[I want to suppress the errors below]**
> BEGIN RELEASE_PO_B_H('yrugis'); END;
>
> *
> ERROR at line 1:
> ORA-01722: invalid number
> ORA-06512: at "TRAIN65D.RELEASE_PO_B_H", line 16
> ORA-06512: at line 1
>
> Thanks,
> Saira
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Saira Somani-Mendelin
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege is
waived or lost by any mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any hard copies
of it and notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL*Plus errors... how to hide?
Saira,
How about use the same method as suggested in another thread, i.e. pipe and
remove unwanted text? In your case
whatever comes in | sed -n '/^BEGIN/,/^ORA-06512: at line/!p'
Yong Huang
--- Saira Somani-Mendelin <[EMAIL PROTECTED]> wrote:
> List,
>
> I have a shell script that executes a sql*plus script (which executes a
> procedure) based on user input.
>
> But what if the user inputs an invalid datatype? The exception section
> handles the error and displays a user-friendly message but I still get
> an error stack. I want to hide this from the user. How can I do this? I
> have set feedback and echo options off. See output below:
>
> PO Reconciliation Batch Release
>
>
> Enter batch number to be released:
> yrugis
> You have entered an invalid number! Exiting program...
> **[I want to suppress the errors below]**
> BEGIN RELEASE_PO_B_H('yrugis'); END;
>
> *
> ERROR at line 1:
> ORA-01722: invalid number
> ORA-06512: at "TRAIN65D.RELEASE_PO_B_H", line 16
> ORA-06512: at line 1
>
> Thanks,
> Saira
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL*Plus errors... how to hide?
If you're familiar with Perl and DBI, that would be a good solution.
You can quite easily hide errors that way.
Jared
"Saira Somani-Mendelin" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/06/2003 12:44 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: SQL*Plus errors... how to hide?
List,
I have a shell script that executes a sql*plus script (which executes a
procedure) based on user input.
But what if the user inputs an invalid datatype? The exception section
handles the error and displays a user-friendly message but I still get
an error stack. I want to hide this from the user. How can I do this? I
have set feedback and echo options off. See output below:
PO Reconciliation Batch Release
Enter batch number to be released:
yrugis
You have entered an invalid number! Exiting program...
**[I want to suppress the errors below]**
BEGIN RELEASE_PO_B_H('yrugis'); END;
*
ERROR at line 1:
ORA-01722: invalid number
ORA-06512: at "TRAIN65D.RELEASE_PO_B_H", line 16
ORA-06512: at line 1
Thanks,
Saira
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Saira Somani-Mendelin
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
Catch the error in an exception clause and ignore it.
SQL> set serveroutput on
SQL> run
1 declare
2 x number ;
3 begin
4 x := to_number ('123^') ;
5 exception
6 when value_error
7 then
8dbms_output.put_line ('Bad Number') ;
9 when others
10 then
11raise ;
12* end ;
Bad Number
Procedura PL/SQL completata correttamente.
> -Original Message-
> Saira Somani-Mendelin
>
> I have a shell script that executes a sql*plus script (which
> executes a
> procedure) based on user input.
>
> But what if the user inputs an invalid datatype? The exception section
> handles the error and displays a user-friendly message but I still get
> an error stack. I want to hide this from the user. How can I
> do this? I
> have set feedback and echo options off. See output below:
>
> PO Reconciliation Batch Release
>
>
> Enter batch number to be released:
> yrugis
> You have entered an invalid number! Exiting program...
> **[I want to suppress the errors below]**
> BEGIN RELEASE_PO_B_H('yrugis'); END;
>
> *
> ERROR at line 1:
> ORA-01722: invalid number
> ORA-06512: at "TRAIN65D.RELEASE_PO_B_H", line 16
> ORA-06512: at line 1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected
My reply was probably a bit too brief. The most robust way for doing this would be to use pattern matching utilities such as sed and awk (Perl? What's Perl?) to parse that output for stuff like ORA- (N is a digit of a number) TNS- SP- etc. But for a quick and dirty approach, select an additional dummy word in the select statement then parse for that word as the first word in the line; that's what the "read" statement does for you. You could add another condition outside the "while read" loop to see if the value you got is reasonable. For example set MY_VARIABLE='BROKE' before running sqlplus, then see if MY_VARIABLE is still BROKE or empty when the loop is done. > -Original Message- > > I take back that statement of mine. Gotta take Unix lessons. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected
-- I don't know if a return value can be gathered in a
-- shell variable except by using ` chars.
Sorry, Stephen had already mentioned one other way:
} | while read DOINK LINE; do
if [ "$DOINK" = "DOINK" ]; then
DBNAME="$LINE" # << Will do.
I take back that statement of mine. Gotta take Unix lessons.
Thanks & regards,
Charu.
-Original Message-
Sent: 06 November 2003 10:09
To: [EMAIL PROTECTED]
'Connected
Thanks Stephen,
The reason for using ` characters was because I wanted the output
(a filename) in a variable. After that, the variable would be
passed to other scripts for file creation, FTP etc. I don't know
if a return value can be gathered in a shell variable except by
using ` chars.
I was trying to suppress 'Connected.' line using SQL*Plus itself.
Once Stephane suggested grep (i.e. suppress from Unix),
possibilities broadened considerably. I will keep the 'while read'
option in mind for future.
Thanks & regards,
Charu.
-Original Message-
Behalf Of
[EMAIL PROTECTED]
Sent: 05 November 2003 21:15
To: Multiple recipients of list ORACLE-L
'Connected
Rather than try to get output using the ` characters, see what you
can do
with this method:
{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages
set whatever else
do this;
do that;
do the other thing;
XXX
} | while read LINE; do
parse $LINE with sed, awk, whatever
if [ this is true ]; then
do something
fi
done
If all you want is to do a simple select that is supposed to
return one
line, one cheap, but not especially robust, way of doing it is
like
{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages
set whatever else
select 'DOINK',name from v$database;
-- or select 'DOINK '||name from v$database;
XXX
} | while read DOINK LINE; do
if [ "$DOINK" = "DOINK" ]; then
DBNAME="$LINE"
fi
done
Now, if one is proficient in sed and awk, more elegant and robust
means can
be devised.
> -Original Message-
> From: Charu Joshi [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 6:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL*Plus question - a bit urgent - Can we suppress
> 'Connected.'
> message?
>
>
> Hello all,
>
> I am calling SQL*Plus from a unix shell script and storing the
> results of the query executed in a shell variable. It goes like
> this:
>
> FL_SUFFIX=`sqlplus -s /nolog SET FEEDBACK OFF
>SET VERIFY OFF
>SET PAGESIZE 0
>
>CONN $ORA_ID/$ORA_PASS
>
>SELECT dummy FROM dual; -- Dummy query.. unrelated to
> the question.
>
>EXIT SQL.SQLCODE
>
> EndOfSQL`
>
> But the contents of the FL_SUFFIX are 'Connected.' instead of
the
> value returned by the query.
>
> This is obviously because of the 'CONN $ORA_ID/$ORA_PASS'
> statement. Is there a way to suppress the 'Connected.' message
> that comes on connecting to database?
>
> I have thought about 2 solutions:
>
> 1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would be the last
> alternative in case everything else fails .. obviously from
> security point of view.
>
> 2. Create a .sql script as:
>
> SET ECHO OFF
> SET FEEDBACK OFF
> SET VERIFY OFF
> SET PAGESIZE 0
>
> SET TERMOUT OFF -- The important bits.
> SPOOL /dev/null --
> CONN $ORA_ID/$ORA_PASS
> SPOOL OFF --
> SET TERMOUT ON -- The important bits.
>
> SELECT dummy FROM dual; -- Dummy query.
>
> EXIT SQL.SQLCODE
>
> and then call this script as
>
> FL_SUFFIX=`sqlplus -s /nolog @a.sql`
>
> I think solution 2 will work, but I am loathe to writing a
script
> for a single SQL statement unless there is no other way.
>
> Any new ideas would be greatly appreciated, the quicker the
> better.
>
> Thanks & regards,
> Charu.
>
> *
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
> *
>
> Visit us at http://www.mahindrabt.com
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Charu Joshi
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051
http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
services
>
-
> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: [EMAIL PROTECTED] (note EXACT spel
RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected
Thanks Stephen,
The reason for using ` characters was because I wanted the output
(a filename) in a variable. After that, the variable would be
passed to other scripts for file creation, FTP etc. I don't know
if a return value can be gathered in a shell variable except by
using ` chars.
I was trying to suppress 'Connected.' line using SQL*Plus itself.
Once Stephane suggested grep (i.e. suppress from Unix),
possibilities broadened considerably. I will keep the 'while read'
option in mind for future.
Thanks & regards,
Charu.
-Original Message-
Behalf Of
[EMAIL PROTECTED]
Sent: 05 November 2003 21:15
To: Multiple recipients of list ORACLE-L
'Connected
Rather than try to get output using the ` characters, see what you
can do
with this method:
{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages
set whatever else
do this;
do that;
do the other thing;
XXX
} | while read LINE; do
parse $LINE with sed, awk, whatever
if [ this is true ]; then
do something
fi
done
If all you want is to do a simple select that is supposed to
return one
line, one cheap, but not especially robust, way of doing it is
like
{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages
set whatever else
select 'DOINK',name from v$database;
-- or select 'DOINK '||name from v$database;
XXX
} | while read DOINK LINE; do
if [ "$DOINK" = "DOINK" ]; then
DBNAME="$LINE"
fi
done
Now, if one is proficient in sed and awk, more elegant and robust
means can
be devised.
> -Original Message-
> From: Charu Joshi [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 6:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL*Plus question - a bit urgent - Can we suppress
> 'Connected.'
> message?
>
>
> Hello all,
>
> I am calling SQL*Plus from a unix shell script and storing the
> results of the query executed in a shell variable. It goes like
> this:
>
> FL_SUFFIX=`sqlplus -s /nolog SET FEEDBACK OFF
>SET VERIFY OFF
>SET PAGESIZE 0
>
>CONN $ORA_ID/$ORA_PASS
>
>SELECT dummy FROM dual; -- Dummy query.. unrelated to
> the question.
>
>EXIT SQL.SQLCODE
>
> EndOfSQL`
>
> But the contents of the FL_SUFFIX are 'Connected.' instead of
the
> value returned by the query.
>
> This is obviously because of the 'CONN $ORA_ID/$ORA_PASS'
> statement. Is there a way to suppress the 'Connected.' message
> that comes on connecting to database?
>
> I have thought about 2 solutions:
>
> 1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would be the last
> alternative in case everything else fails .. obviously from
> security point of view.
>
> 2. Create a .sql script as:
>
> SET ECHO OFF
> SET FEEDBACK OFF
> SET VERIFY OFF
> SET PAGESIZE 0
>
> SET TERMOUT OFF -- The important bits.
> SPOOL /dev/null --
> CONN $ORA_ID/$ORA_PASS
> SPOOL OFF --
> SET TERMOUT ON -- The important bits.
>
> SELECT dummy FROM dual; -- Dummy query.
>
> EXIT SQL.SQLCODE
>
> and then call this script as
>
> FL_SUFFIX=`sqlplus -s /nolog @a.sql`
>
> I think solution 2 will work, but I am loathe to writing a
script
> for a single SQL statement unless there is no other way.
>
> Any new ideas would be greatly appreciated, the quicker the
> better.
>
> Thanks & regards,
> Charu.
>
> *
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
> *
>
> Visit us at http://www.mahindrabt.com
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Charu Joshi
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051
http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
services
>
-
> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You
may
> also send the HELP command for other information (like
subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- M
RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected
Rather than try to get output using the ` characters, see what you can do
with this method:
{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages
set whatever else
do this;
do that;
do the other thing;
XXX
} | while read LINE; do
parse $LINE with sed, awk, whatever
if [ this is true ]; then
do something
fi
done
If all you want is to do a simple select that is supposed to return one
line, one cheap, but not especially robust, way of doing it is like
{
sqlplus -s <<-XXX
$USER/[EMAIL PROTECTED]
set heading off feedback off trims on lines 300 pages
set whatever else
select 'DOINK',name from v$database;
-- or select 'DOINK '||name from v$database;
XXX
} | while read DOINK LINE; do
if [ "$DOINK" = "DOINK" ]; then
DBNAME="$LINE"
fi
done
Now, if one is proficient in sed and awk, more elegant and robust means can
be devised.
> -Original Message-
> From: Charu Joshi [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 6:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL*Plus question - a bit urgent - Can we suppress
> 'Connected.'
> message?
>
>
> Hello all,
>
> I am calling SQL*Plus from a unix shell script and storing the
> results of the query executed in a shell variable. It goes like
> this:
>
> FL_SUFFIX=`sqlplus -s /nolog SET FEEDBACK OFF
>SET VERIFY OFF
>SET PAGESIZE 0
>
>CONN $ORA_ID/$ORA_PASS
>
>SELECT dummy FROM dual; -- Dummy query.. unrelated to
> the question.
>
>EXIT SQL.SQLCODE
>
> EndOfSQL`
>
> But the contents of the FL_SUFFIX are 'Connected.' instead of the
> value returned by the query.
>
> This is obviously because of the 'CONN $ORA_ID/$ORA_PASS'
> statement. Is there a way to suppress the 'Connected.' message
> that comes on connecting to database?
>
> I have thought about 2 solutions:
>
> 1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would be the last
> alternative in case everything else fails .. obviously from
> security point of view.
>
> 2. Create a .sql script as:
>
> SET ECHO OFF
> SET FEEDBACK OFF
> SET VERIFY OFF
> SET PAGESIZE 0
>
> SET TERMOUT OFF -- The important bits.
> SPOOL /dev/null --
> CONN $ORA_ID/$ORA_PASS
> SPOOL OFF --
> SET TERMOUT ON -- The important bits.
>
> SELECT dummy FROM dual; -- Dummy query.
>
> EXIT SQL.SQLCODE
>
> and then call this script as
>
> FL_SUFFIX=`sqlplus -s /nolog @a.sql`
>
> I think solution 2 will work, but I am loathe to writing a script
> for a single SQL statement unless there is no other way.
>
> Any new ideas would be greatly appreciated, the quicker the
> better.
>
> Thanks & regards,
> Charu.
>
> *
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
> *
>
> Visit us at http://www.mahindrabt.com
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Charu Joshi
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected.' message?
Thanks Stephane, Your solution 3 has done the job for me. Regards, Charu. -Original Message- Stephane Faroult Sent: 05 November 2003 18:10 To: Multiple recipients of list ORACLE-L 'Connected.' message? You have multiple solutions; one would be to use an externally identified Oracle account; another one to use the hide.c program (should find it with google) to prevent people from seeing command arguments through 'ps'; another one to write something such as myvar=`echo "your stuff here blabla exit" | sqlplus -s /nolog | grep -iv connected` . just a few ideas. HTH SF >- --- Original Message --- - >From: "Charu Joshi" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 05 Nov 2003 04:04:38 > >Hello all, > >I am calling SQL*Plus from a unix shell script and >storing the >results of the query executed in a shell variable. >It goes like >this: > >FL_SUFFIX=`sqlplus -s /nolog < SET ECHO OFF > SET FEEDBACK OFF > SET VERIFY OFF > SET PAGESIZE 0 > > CONN $ORA_ID/$ORA_PASS > > SELECT dummy FROM dual; -- Dummy query.. >unrelated to >the question. > > EXIT SQL.SQLCODE > >EndOfSQL` > >But the contents of the FL_SUFFIX are 'Connected.' >instead of the >value returned by the query. > >This is obviously because of the 'CONN >$ORA_ID/$ORA_PASS' >statement. Is there a way to suppress the >'Connected.' message >that comes on connecting to database? > >I have thought about 2 solutions: > >1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would >be the last >alternative in case everything else fails .. >obviously from >security point of view. > >2. Create a .sql script as: > >SET ECHO OFF >SET FEEDBACK OFF >SET VERIFY OFF >SET PAGESIZE 0 > >SET TERMOUT OFF -- The important bits. >SPOOL /dev/null -- >CONN $ORA_ID/$ORA_PASS >SPOOL OFF -- >SET TERMOUT ON -- The important bits. > >SELECT dummy FROM dual; -- Dummy query. > >EXIT SQL.SQLCODE > >and then call this script as > >FL_SUFFIX=`sqlplus -s /nolog @a.sql` > >I think solution 2 will work, but I am loathe to >writing a script >for a single SQL statement unless there is no other >way. > >Any new ideas would be greatly appreciated, the >quicker the >better. > >Thanks & regards, >Charu. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected.' message?
You have multiple solutions; one would be to use an externally identified Oracle account; another one to use the hide.c program (should find it with google) to prevent people from seeing command arguments through 'ps'; another one to write something such as myvar=`echo "your stuff here blabla exit" | sqlplus -s /nolog | grep -iv connected` .. just a few ideas. HTH SF >- --- Original Message --- - >From: "Charu Joshi" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 05 Nov 2003 04:04:38 > >Hello all, > >I am calling SQL*Plus from a unix shell script and >storing the >results of the query executed in a shell variable. >It goes like >this: > >FL_SUFFIX=`sqlplus -s /nolog < SET ECHO OFF > SET FEEDBACK OFF > SET VERIFY OFF > SET PAGESIZE 0 > > CONN $ORA_ID/$ORA_PASS > > SELECT dummy FROM dual; -- Dummy query.. >unrelated to >the question. > > EXIT SQL.SQLCODE > >EndOfSQL` > >But the contents of the FL_SUFFIX are 'Connected.' >instead of the >value returned by the query. > >This is obviously because of the 'CONN >$ORA_ID/$ORA_PASS' >statement. Is there a way to suppress the >'Connected.' message >that comes on connecting to database? > >I have thought about 2 solutions: > >1. Use sqlplus -s $ORA_ID/$ORA_PASS :- This would >be the last >alternative in case everything else fails .. >obviously from >security point of view. > >2. Create a .sql script as: > >SET ECHO OFF >SET FEEDBACK OFF >SET VERIFY OFF >SET PAGESIZE 0 > >SET TERMOUT OFF -- The important bits. >SPOOL /dev/null -- >CONN $ORA_ID/$ORA_PASS >SPOOL OFF -- >SET TERMOUT ON -- The important bits. > >SELECT dummy FROM dual; -- Dummy query. > >EXIT SQL.SQLCODE > >and then call this script as > >FL_SUFFIX=`sqlplus -s /nolog @a.sql` > >I think solution 2 will work, but I am loathe to >writing a script >for a single SQL statement unless there is no other >way. > >Any new ideas would be greatly appreciated, the >quicker the >better. > >Thanks & regards, >Charu. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*PLUS buffer width and buffer length stored where ??
Interesting finding here ORCL9 SQL> Store set C:\oracle\ora92\dbs\login.sql Or if the file exists ORCL9 SQL> Store set C:\oracle\ora92\dbs\login.sql append That generates a substantial config file, much more than a standard login I have to test if it actually keeps the buffer width and length. I don't see it in there, though. Bob -Original Message- Sent: Tuesday, November 04, 2003 11:34 AM To: Multiple recipients of list ORACLE-L All, I have the issue with setting a basic format in sql plus In my login.sql I have set line size 1000 Say I have a have a table with 20 columns and I select * from table where rownum <=2 What happens is I can't scroll the data... (The horizontal scroll is locked)) Unless I go into Options>environment> Screen buffer width 900 Screen buffer length 899 This works in my environment however Id like to roll out a default login.sql to users or have the ability to set the sessions for them. I've search online and there doesn't seem a way to set the buffer width from a config file, only through the gui. I'm sure someone here knows that, or has a "complete" login.sql file to have the ability to enable the horizontal scroll by default Thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Plus
It's still in oracle\bin in the 10.1.0.0.0 software for MSWin. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Tanel Poder Sent: Monday, September 22, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Hi! Sqlplusw is gone, the windows gui version. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 7:19 PM > Hello: > > Was watching Larry Ellison's key note and he mentioned that they still have > SQL Plus in 10g. > I heard rumor that it was removed. Since it seems as though some from this > list have seen it does it still have SQL Plus or has it been removed? > > Thanks In Advance, > Jay > > _ > High-speed Internet access as low as $29.95/month (depending on the local > service providers in your area). Click here. https://broadband.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jay Wade > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Plus
Hi No this is not true sqlplusw.exe on w2*k is stil there in the beta kit and I can not find anything about desupport in the manuals :-) Tanel Poder wrote: Hi! Sqlplusw is gone, the windows gui version. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 7:19 PM Hello: Was watching Larry Ellison's key note and he mentioned that they still have SQL Plus in 10g. I heard rumor that it was removed. Since it seems as though some from this list have seen it does it still have SQL Plus or has it been removed? Thanks In Advance, Jay _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Plus
SQL*Plus windoz version is removed, not the ubiquitous command line tool. How can they remove SQL*Plus, the proverbial cockroach tool of the Oracle world? Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 12:19 PM > Hello: > > Was watching Larry Ellison's key note and he mentioned that they still have > SQL Plus in 10g. > I heard rumor that it was removed. Since it seems as though some from this > list have seen it does it still have SQL Plus or has it been removed? > > Thanks In Advance, > Jay > > _ > High-speed Internet access as low as $29.95/month (depending on the local > service providers in your area). Click here. https://broadband.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jay Wade > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Plus
Hi! Sqlplusw is gone, the windows gui version. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 7:19 PM > Hello: > > Was watching Larry Ellison's key note and he mentioned that they still have > SQL Plus in 10g. > I heard rumor that it was removed. Since it seems as though some from this > list have seen it does it still have SQL Plus or has it been removed? > > Thanks In Advance, > Jay > > _ > High-speed Internet access as low as $29.95/month (depending on the local > service providers in your area). Click here. https://broadband.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jay Wade > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NEVER MIND - WAS - RE: SQL Plus Environment
Set SQLPATH, then login.sql and all of your other .sql scripts can be in whatever directory location(s) you prefer. "Farnsworth, Dave" wrote: > > I fixed it. I decided if the DBS directory was not created by the Oracle install >than I will go and create the directory for Oracle. I then dropped my login.sql into >the directory, fired up SQLPlus and my login.sql worked. Maybe I should of just sent >a HELP instead. ;o) > > Dave > > -Original Message- > Sent: Tuesday, February 11, 2003 12:22 PM > To: Multiple recipients of list ORACLE-L > > I want to set up a glogin.sql and a login.sql. I am reading the manual and I find >this. Oh yea. I'm on 8.1.7 on NT. > > When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and >GLOGIN.SQL is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory. > If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape >sequences. > See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide >and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and >GLOGIN.SQL files. > > I can find the glogin.sql on my client PC and have edited it to my liking. But I >cannot find the login.sql and I do not have the DBS directory. I see a DBS directory >on the server but not on the client. Am I missing something or does login.sql not >exist on 8.1.7. > > Thanks, > > Dave > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Plus Environment
Hi Dave, Here's how mine is set up (SqlPlus client 8.1.7) $oracle_home\bin\login.sql, fires when I log in Calls a mylogin.sql file complete with path. login.sql Looks like this @c:\oracle\ora81\sqlplus\admin\mylogin.sql set linesize 2000 column name format a40 column column format a20 mylogin.sql looks like this set pause off set termout off SET ARRAYSIZE 3 column dbsid new_value dbsid noprint select global_name dbsid from global_name; column dbusr new_value dbusr noprint select user dbusr from dual; set sqlprompt '(&dbsid-&dbusr)>' set termout on UNDEF DBSID UNDEF DBUSR set linesize 100 set pagesize 100 HTH, and have a great day. Tell everyone on OT hello. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -Original Message- Sent: Tuesday, February 11, 2003 1:22 PM To: Multiple recipients of list ORACLE-L I want to set up a glogin.sql and a login.sql. I am reading the manual and I find this. Oh yea. I'm on 8.1.7 on NT. When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and GLOGIN.SQL is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory. If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape sequences. See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and GLOGIN.SQL files. I can find the glogin.sql on my client PC and have edited it to my liking. But I cannot find the login.sql and I do not have the DBS directory. I see a DBS directory on the server but not on the client. Am I missing something or does login.sql not exist on 8.1.7. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NEVER MIND - WAS - RE: SQL Plus Environment
I fixed it. I decided if the DBS directory was not created by the Oracle install than I will go and create the directory for Oracle. I then dropped my login.sql into the directory, fired up SQLPlus and my login.sql worked. Maybe I should of just sent a HELP instead. ;o) Dave -Original Message- Sent: Tuesday, February 11, 2003 12:22 PM To: Multiple recipients of list ORACLE-L I want to set up a glogin.sql and a login.sql. I am reading the manual and I find this. Oh yea. I'm on 8.1.7 on NT. When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and GLOGIN.SQL is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory. If you modify LOGIN.SQL or GLOGIN.SQL, make sure you do not add any ANSI escape sequences. See "Setting Up Your SQL*Plus Environment" in Chapter 3 of the SQL*Plus User's Guide and Reference <../../server.817/a82950/toc.htm>, which describes the LOGIN.SQL and GLOGIN.SQL files. I can find the glogin.sql on my client PC and have edited it to my liking. But I cannot find the login.sql and I do not have the DBS directory. I see a DBS directory on the server but not on the client. Am I missing something or does login.sql not exist on 8.1.7. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus Worksheet Question
Jay, We're talking about the SQL*Plus Worksheet for Windows here, not good old plain SQL*Plus. Your solution only works for SQL*Plus, but not the Worksheet. Cheers, Leng. - From: [EMAIL PROTECTED] Date: Mon, 3 Feb 2003 14:38:35 +0530 Subject: RE: SQL*Plus Worksheet Question This is a multipart message in MIME format. --=_alternative 0032130465256CC2_= Content-Type: text/plain; charset="us-ascii" Hi leng, The following works fine with SQL*Plus if you include it in Glogin(Login).sql column user new_value A noprint column global_name new_value B noprint select user from dual; select global_name from global_name; set sqlprompt &A@&B. HTH ... Regards JAI "Kaing, Leng" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/03/03 11:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: SQL*Plus Worksheet Question > Eric, > > Not sure what you're talking about but here's a stab in the dark... > > set sqlprompt "mydb.myusername> " > > This changes the output prompt, but not the prompt in the header of the window bar. If you can figure this one out, please let me know too. > > Rgs, > > Leng. > -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus Worksheet Question
Hi leng, The following works fine with SQL*Plus if you include it in Glogin(Login).sql column user new_value A noprint column global_name new_value B noprint select user from dual; select global_name from global_name; set sqlprompt &A@&B. HTH ... Regards JAI "Kaing, Leng" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/03/03 11:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: SQL*Plus Worksheet Question > Eric, > > Not sure what you're talking about but here's a stab in the dark... > > set sqlprompt "mydb.myusername> " > > This changes the output prompt, but not the prompt in the header of the window bar. If you can figure this one out, please let me know too. > > Rgs, > > Leng. > > - > From: "Harrington, Eric" <[EMAIL PROTECTED]> > Date: Fri, 31 Jan 2003 10:29:25 -0500 > Subject: SQL*Plus Worksheet Question > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > --_=_NextPart_001_01C2C93D.891CA8A0 > Content-Type: text/plain > > Version 9.2 > > I am monitoring several databases and have several SQL*Plus Worksheet > sessions open. I would like to display the connected user name and instance > as the prompt associated w/ the appropriate session. Per Metalink > Note:120664.1 I added the following lines to the login.sql: > > set termout off > spool set_prompt.sql > select 'set sqlprompt '||instance||'>' > from sys.v_$thread; > spool off > start set_prompt.sql > set termout on > > This does successfully change the prompt to the instance name for SQL*Plus > but not SQL*Plus Worksheet. What am I missing? Is there another way to > accomplish this? > > Eric Harrington > State of Maine > Bureau of Motor Vehicles > > -- > Leng Kaing > Email: [EMAIL PROTECTED] > Phone: +61-417-371-348 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus Worksheet Question
> Eric, > > Not sure what you're talking about but here's a stab in the dark... > > set sqlprompt "mydb.myusername> " > > This changes the output prompt, but not the prompt in the header of the window bar. >If you can figure this one out, please let me know too. > > Rgs, > > Leng. > > - > From: "Harrington, Eric" <[EMAIL PROTECTED]> > Date: Fri, 31 Jan 2003 10:29:25 -0500 > Subject: SQL*Plus Worksheet Question > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > --_=_NextPart_001_01C2C93D.891CA8A0 > Content-Type: text/plain > > Version 9.2 > > I am monitoring several databases and have several SQL*Plus Worksheet > sessions open. I would like to display the connected user name and instance > as the prompt associated w/ the appropriate session. Per Metalink > Note:120664.1 I added the following lines to the login.sql: > > set termout off > spool set_prompt.sql > select 'set sqlprompt '||instance||'>' > from sys.v_$thread; > spool off > start set_prompt.sql > set termout on > > This does successfully change the prompt to the instance name for SQL*Plus > but not SQL*Plus Worksheet. What am I missing? Is there another way to > accomplish this? > > Eric Harrington > State of Maine > Bureau of Motor Vehicles > > -- > Leng Kaing > Email: [EMAIL PROTECTED] > Phone: +61-417-371-348 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*PLUS and CygWin
Before you run sqlplus, set the ComSpec env variable, like so: set ComSpec=c:\usr\local\wbin\sh.exe Next time you host out it will run this instead of the default ComSpec='C:\WINNT\system32\cmd.exe' HTH, Warren Lindsey Stefan Jahnke wrote: Hi everybody I'm using cywin on my Win2k box to get a reasonable shell. Now there's one problem left: Everytime I issue a "host" command within SQL*PLUS, I get a Windows console. I would like to get the bash prompt instead. Is there any Any ideas ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Warren Lindsey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus truncating lines
Okay, I have independent verification, so I am NOT delusional... I reconnected to the 9.0.1 database, reran the query and the lines were not truncated! I'm STUMPED! -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 12, 2002 3:09 PMTo: Multiple recipients of list ORACLE-LSubject: SQL*Plus truncating lines I'm calling each statement from SQL*Plus for Windows 9.2.0.1.0. When I connect to a 9.0.1 database and execute a query, the output to the screen is truncated at 100 characters. If the output is spooled to a file, all lines appear as expected. When the same session is connected to an 8.1.7 database, the output is not truncated. When the same statement is run on the box using the unix command line version, it is not truncated. linesize - 150 command_string (column of output) a145 echo off pages 0 Any clues as to why the database connection matters? Is it actually something with SQL*Net? Any other things to check? Dan Fink
RE: SQL*Plus COPY error solved (sort of)
Hadn't thought of trying that; makes sense. Thanks. --- "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]> wrote: > When you tried under NT, did you use sqlplus.exe or sqlplusw.exe? > > If you used sqlplusw.exe, this sounds like Bug No. 1504702 > > The workaround is to use the copy command from the character version > of sqlplus (sqlplus.exe) rather than the GUI version. > > HTH, > Bruce Reardon > __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus COPY error solved (sort of)
When you tried under NT, did you use sqlplus.exe or sqlplusw.exe? If you used sqlplusw.exe, this sounds like Bug No. 1504702 The workaround is to use the copy command from the character version of sqlplus (sqlplus.exe) rather than the GUI version. HTH, Bruce Reardon -Original Message- Sent: Saturday, 26 October 2002 10:49 AM it's oraus.msg located in rdbms/mesg but that file does NOT exist on Windows systems anymore --- Stephen Lee <[EMAIL PROTECTED]> wrote: > > Some severe rustiness here on this topic; but the mists of time have > me > thinking that Oracle is looking for the file that contains the text > for > messages it wants to display, and in your case, it can't find the > file. I > used to know what file this was and where it was located; but would > have to > look it up now. > > -Original Message- > Sent: Friday, October 25, 2002 3:24 PM > > This COPY script failure occurred when running in SQL*Plus on Windows > NT. In SQL*Plus on (Unix) database server, runs just fine, so > immediate problem solved. > > Shouldn't it work from PC, though? > > --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > > I'm trying to use (for the first time in 15 years of Oracle > > experience!) SQL*Plus COPY, and am receiving the following > > incomprehensible error: > > > > SQL> @odss/cmsr > > > > Array fetch/bind size is 100. (arraysize is 100) > > Will commit after every 10 array binds. (copycommit is 10) > > Maximum long size is 2. (long is 2) > > > > ERROR: > > ORA--3393898: Message -3393898 not found; product=RDBMS; > > facility=ORA > > > > Anyone seen this or anything like it? My environment is set up > > properly; i.e., errors returned by operations other than COPY > display > > the way they're supposed to. > > > > TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus COPY error
I've not seen this particular error. Over the years I've found SQL*Plus COPY to be buggy. I just did a search on Metalink for "sqlplus copy error". Your problem is not addressed directly, but other problems point to bugs in the GUI version of SQL*PLUS. Oracle's advice is to use the command line, non-GUI version of SQL*Plus for COPY. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 12:54 PM > I'm trying to use (for the first time in 15 years of Oracle > experience!) SQL*Plus COPY, and am receiving the following > incomprehensible error: > > SQL> @odss/cmsr > > Array fetch/bind size is 100. (arraysize is 100) > Will commit after every 10 array binds. (copycommit is 10) > Maximum long size is 2. (long is 2) > > ERROR: > ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA > > Anyone seen this or anything like it? My environment is set up > properly; i.e., errors returned by operations other than COPY display > the way they're supposed to. > > TIA! > > > __ > Do you Yahoo!? > Y! Web Hosting - Let the expert host your web site > http://webhosting.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus COPY error solved (sort of)
it's oraus.msg located in rdbms/mesg but that file does NOT exist on Windows systems anymore --- Stephen Lee <[EMAIL PROTECTED]> wrote: > > Some severe rustiness here on this topic; but the mists of time have > me > thinking that Oracle is looking for the file that contains the text > for > messages it wants to display, and in your case, it can't find the > file. I > used to know what file this was and where it was located; but would > have to > look it up now. > > -Original Message- > Sent: Friday, October 25, 2002 3:24 PM > To: Multiple recipients of list ORACLE-L > > > This COPY script failure occurred when running in SQL*Plus on Windows > NT. In SQL*Plus on (Unix) database server, runs just fine, so > immediate problem solved. > > Shouldn't it work from PC, though? > > > --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > > I'm trying to use (for the first time in 15 years of Oracle > > experience!) SQL*Plus COPY, and am receiving the following > > incomprehensible error: > > > > SQL> @odss/cmsr > > > > Array fetch/bind size is 100. (arraysize is 100) > > Will commit after every 10 array binds. (copycommit is 10) > > Maximum long size is 2. (long is 2) > > > > ERROR: > > ORA--3393898: Message -3393898 not found; product=RDBMS; > > facility=ORA > > > > Anyone seen this or anything like it? My environment is set up > > properly; i.e., errors returned by operations other than COPY > display > > the way they're supposed to. > > > > TIA! > > > > > > __ > > Do you Yahoo!? > > Y! Web Hosting - Let the expert host your web site > > http://webhosting.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Paul Baumgartel > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting > services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > __ > Do you Yahoo!? > Y! Web Hosting - Let the expert host your web site > http://webhosting.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephen Lee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus COPY error solved (sort of)
Some severe rustiness here on this topic; but the mists of time have me thinking that Oracle is looking for the file that contains the text for messages it wants to display, and in your case, it can't find the file. I used to know what file this was and where it was located; but would have to look it up now. -Original Message- Sent: Friday, October 25, 2002 3:24 PM To: Multiple recipients of list ORACLE-L This COPY script failure occurred when running in SQL*Plus on Windows NT. In SQL*Plus on (Unix) database server, runs just fine, so immediate problem solved. Shouldn't it work from PC, though? --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > I'm trying to use (for the first time in 15 years of Oracle > experience!) SQL*Plus COPY, and am receiving the following > incomprehensible error: > > SQL> @odss/cmsr > > Array fetch/bind size is 100. (arraysize is 100) > Will commit after every 10 array binds. (copycommit is 10) > Maximum long size is 2. (long is 2) > > ERROR: > ORA--3393898: Message -3393898 not found; product=RDBMS; > facility=ORA > > Anyone seen this or anything like it? My environment is set up > properly; i.e., errors returned by operations other than COPY display > the way they're supposed to. > > TIA! > > > __ > Do you Yahoo!? > Y! Web Hosting - Let the expert host your web site > http://webhosting.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus COPY error
Paul - Hopefully you will receive more helpful advice, but I have received strange errors using the COPY command and the reply I received from Oracle support was that it was being phased out and if I didn't like errors I should write a small PL/SQL program to perform this task (give you a copy if you want it). That was 5 years ago, so obviously it hasn't disappeared. I would recommend modifying your COPY statement until you get away from the error. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL> @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2. (long is 2) ERROR: ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA Anyone seen this or anything like it? My environment is set up properly; i.e., errors returned by operations other than COPY display the way they're supposed to. TIA! __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Plus Default Value for &1 Help
The problem comes down to this:
If there is a '&' in the script, and there is no value already
assigned to it, sqlplus is going to stop processing, and
wait for user input.
I've never found a way around this.
It would be nice if there were some facility such as all
unix shells have to test for the existence and number
of command line variables.
If this is something you must have, you might want to consider
using Perl to do this, as it's fairly easy there.
Or use something like expect as a frontend to sqlplus, but I think
that's more work than just doing the job in Perl.
Jared
"Post, Ethan" <[EMAIL PROTECTED]>
10/18/2002 02:04 PM
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
cc: "Robert Fendley (E-mail)" <[EMAIL PROTECTED]>
Subject:RE: SQL Plus Default Value for &1 Help
Thanks Jared, I have been looking at Steve Adams accept.sql script and
seeing if I can tweak that in someway. But I think you are right, this is
a
difficult task indeed.
---
--
-- Script: accept.sql
-- Purpose: to prompt for a script parameter, but allow a default
value
--
-- Copyright: (c) Ixora Pty Ltd
-- Author: Steve Adams
--
-- Synopsis:@accept name prompt default
--
---
accept _value_entered prompt "&2 [&3] "
column _value_returned new_value &1 noprint
set termout off
select nvl('&_value_entered', '&3') "_value_returned" from dual;
set termout on
undefine 1 2 3 _value_entered
column _value_returned clear
-Original Message-
Sent: Friday, October 18, 2002 3:58 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Importance: High
Ethan,
I think you're stuck here.
There isn't any memory structure in sqlplus that I'm aware of
that will allow you to check for the existence of variables
passed on the command line, without actually checking the
variable itself.
Below is the method I use for passing command line
variables to sqlplus, and prompting the user if they
don't exist.
column ctest noprint new_value utest
prompt Enter the value:
set feed off echo off term off
select '&1' ctest from dual;
set feed on term on
select '&utest' from dual;
I don't see any way to directly supply a default value in sqlplus, though
it
would really be cool if someone else has a way to do so in sqlplus.
This would likely require something like expect, or Perls Telnet
module to catch user input, and timeout if not supplied in a timely
manner.
Jared
"Post, Ethan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/18/2002 02:23 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:SQL Plus Default Value for &1 Help
Anyone got an example for the following...
I have a SQL Script that expects &1 passed into it, however, if &1 is not
supplied I would like to use a default value and not stop to prompt the
user. I am playing around with new_value and select nvl('&1','foo') from
dual...etc...and nothing seems to be working.
Thanks,
Ethan Post
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
Concerning gqlplus I spoke to the author about this issue and he is supposed to be addressing it. I still find it useful and hope he fixes this problem soon. -D- On Fri, 30 Aug 2002 12:58:26 -0800 [EMAIL PROTECTED] wrote: > Just tried it. > > Took 5 minutes to break it with this: > > set sqlprompt '&&umachine - &who_var@&instance_var SQL> ' > > Jared > > > > > > > > "Orr, Steve" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 08/30/2002 01:28 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: SQL*Plus in 10i > > > > BTW: Anybody's using gqlplus? > Whoa, I've been looking for something like this. Is it any good? > > -- Dwayne Cox Oracle Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
Have not heard from Oracle as of yet regarding removing the SQL*Plus interface. To my knowledge, there are extensive enhancements being made to SQL*Plus. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, August 30, 2002 4:43 PM To: Multiple recipients of list ORACLE-L Subject:RE: SQL*Plus in 10i They are going to have iSQL*Plus (or however it's spelled) and you can use that (and OEM) for startup and shutdown. The SQL*Plus text and windows clinet I hear will be gone. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, August 30, 2002 2:34 PM To: Multiple recipients of list ORACLE-L oradim -startup -sid -pfile ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: > How do they expect you to start and stop the database if it goes away? > and please don't say OEM... > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > RF > > > > Robert G. Freeman - Oracle OCP > > Oracle Database Architect > > CSX Midtier Database Administration > > Author > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > Oracle9i New Features (Oracle Press) > > Mastering Oracle8i (Sybex) > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Freeman, Robert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
On Fri, 30 Aug 2002 08:23:27 -0800, you wrote: >Anyone else hear that SQL*Plus is going away in 10i?? The story I heard is that only the Windows version, the one that wraps a GUI around the command-line, goes away. The DOS version stays (or so I've been told, but I forget by who). Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
I wonder why there is no Oradim under Unix/Linux? ltiu On Friday 30 August 2002 19:23, Rachel Carmichael wrote: > does oradim work in Unix boxes? I've never used it > > And it took a LOT of releases and warnings before they got rid of > svrmgr.. they started saying it was going away in version 7 I believe. > > --- ltiu <[EMAIL PROTECTED]> wrote: > > oradim -startup -sid -pfile ??? > > > > They got rid of SVRMGR. > > > > ltiu > > > > On Friday 30 August 2002 11:08, you wrote: > > > How do they expect you to start and stop the database if it goes > > > > away? > > > > > and please don't say OEM... > > > > > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > > > > > > > RF > > > > > > > > Robert G. Freeman - Oracle OCP > > > > Oracle Database Architect > > > > CSX Midtier Database Administration > > > > Author > > > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > > > Oracle9i New Features (Oracle Press) > > > > Mastering Oracle8i (Sybex) > > > > > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: Freeman, Robert > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > > > > 538-5051 > > > > > > San Diego, California-- Public Internet access / Mailing > > > > Lists > > > > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > > > > in > > > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You > > > > may > > > > > > also send the HELP command for other information (like > > > > subscribing). > > > > > __ > > > Do You Yahoo!? > > > Yahoo! Finance - Get real-time stock quotes > > > http://finance.yahoo.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: ltiu > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
No it doesn't. oradim is used to create/start/stop oracle services. There is no such thing as NT services on Unix. -Original Message- Sent: Friday, August 30, 2002 10:23 PM To: Multiple recipients of list ORACLE-L does oradim work in Unix boxes? I've never used it And it took a LOT of releases and warnings before they got rid of svrmgr.. they started saying it was going away in version 7 I believe. --- ltiu <[EMAIL PROTECTED]> wrote: > oradim -startup -sid -pfile ??? > > They got rid of SVRMGR. > > ltiu > > On Friday 30 August 2002 11:08, you wrote: > > How do they expect you to start and stop the database if it goes > away? > > and please don't say OEM... > > > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > > > > RF > > > > > > Robert G. Freeman - Oracle OCP > > > Oracle Database Architect > > > CSX Midtier Database Administration > > > Author > > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > > Oracle9i New Features (Oracle Press) > > > Mastering Oracle8i (Sybex) > > > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Freeman, Robert > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > > > San Diego, California-- Public Internet access / Mailing > > > Lists > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You > may > > > also send the HELP command for other information (like > subscribing). > > > > __ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
I LOVE that idea
I miss the monitor function :)
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> We only need to start it. It usually stops itself without human
> control.
> That is why we have ora-600 and ora-7445 features implemented in PMON
>
> and SMON. As for starting and stopping, let me be innovative:
> What do you say to call the start/stop program "IOR" and have
> database startup performed by "ior w" and database creation by "ior
> i"
> ("i" liki "init"). That would be a new and improved thing, wouldn't
> it?
> May be, calling the program "sqldba" would be even better.
> Integrating
> an ncurses version of top sessions monitor and rollback segment
> monitor
> would also be an outrageous improvement, don't you think so?
>
> > -Original Message-
> > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, August 30, 2002 2:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: SQL*Plus in 10i
> >
> >
> > How do they expect you to start and stop the database if it goes
> away?
> > and please don't say OEM...
> >
> >
> > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > > Anyone else hear that SQL*Plus is going away in 10i??
> > >
> > >
> > > RF
> > >
> > > Robert G. Freeman - Oracle OCP
> > > Oracle Database Architect
> > > CSX Midtier Database Administration
> > > Author
> > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > > Oracle9i New Features (Oracle Press)
> > > Mastering Oracle8i (Sybex)
> > >
> > > The avalanche has begun, It is too late for the pebbles to vote.
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Freeman, Robert
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 FAX: (858)
> 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > >
>
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You
> may
> > > also send the HELP command for other information (like
> subscribing).
> >
> >
> > __
> > Do You Yahoo!?
> > Yahoo! Finance - Get real-time stock quotes
> > http://finance.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
>
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like
> subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
I can't code scripts to be run by the operations staff via OEM. I don't want to give that much access to non-DBA staff. I told Ken Jacobs this years ago when he said at an NYOUG meeting that "soon your database will be controlled from the web" --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > And as for OEM, I've heard from several sources that Oracle is going > to > position that product more and more to be "THE" database management > interface. It's going to start feeling like we are working on a > SQL Server database before you know it. > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. > > > > -Original Message- > Sent: Friday, August 30, 2002 2:09 PM > To: Multiple recipients of list ORACLE-L > > > How do they expect you to start and stop the database if it goes > away? > and please don't say OEM... > > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > RF > > > > Robert G. Freeman - Oracle OCP > > Oracle Database Architect > > CSX Midtier Database Administration > > Author > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > Oracle9i New Features (Oracle Press) > > Mastering Oracle8i (Sybex) > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Freeman, Robert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
does oradim work in Unix boxes? I've never used it And it took a LOT of releases and warnings before they got rid of svrmgr.. they started saying it was going away in version 7 I believe. --- ltiu <[EMAIL PROTECTED]> wrote: > oradim -startup -sid -pfile ??? > > They got rid of SVRMGR. > > ltiu > > On Friday 30 August 2002 11:08, you wrote: > > How do they expect you to start and stop the database if it goes > away? > > and please don't say OEM... > > > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > > > > RF > > > > > > Robert G. Freeman - Oracle OCP > > > Oracle Database Architect > > > CSX Midtier Database Administration > > > Author > > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > > Oracle9i New Features (Oracle Press) > > > Mastering Oracle8i (Sybex) > > > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Freeman, Robert > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > > > San Diego, California-- Public Internet access / Mailing > > > Lists > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You > may > > > also send the HELP command for other information (like > subscribing). > > > > __ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
That's not really a show stopper as far as I'm concerned. -Original Message- Sent: Friday, August 30, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Importance: High Just tried it. Took 5 minutes to break it with this: set sqlprompt '&&umachine - &who_var@&instance_var SQL> ' Jared "Orr, Steve" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/30/2002 01:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: SQL*Plus in 10i > BTW: Anybody's using gqlplus? Whoa, I've been looking for something like this. Is it any good? -Original Message- Sent: Friday, August 30, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Yes, Oracle will sell it as standalone product because it is most useful and most used client software on Oracle. The licence model is 'per session'. :-))) BTW: Anybody's using gqlplus? http://gqlplus.sourceforge.net/ JP On Friday 30 August 2002 18:23, you wrote: > Anyone else hear that SQL*Plus is going away in 10i?? > > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
And how will they support automated jobs (i.e., cron) that use sqlplus?? I've already had to rewrite scripts from svrmgrl to sqlplus. I don't want to go through that again. I'm hoping, Robert, that you're just pulling everyone's leg :) -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- Robert Sent: Friday, August 30, 2002 3:43 PM To: Multiple recipients of list ORACLE-L They are going to have iSQL*Plus (or however it's spelled) and you can use that (and OEM) for startup and shutdown. The SQL*Plus text and windows clinet I hear will be gone. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, August 30, 2002 2:34 PM To: Multiple recipients of list ORACLE-L oradim -startup -sid -pfile ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: > How do they expect you to start and stop the database if it goes away? > and please don't say OEM... > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > RF > > > > Robert G. Freeman - Oracle OCP > > Oracle Database Architect > > CSX Midtier Database Administration > > Author > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > Oracle9i New Features (Oracle Press) > > Mastering Oracle8i (Sybex) > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Freeman, Robert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
>> McNealy, Ellison and Gates Sounds like one of those injury law firms that advertises on late night TV... Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
Just tried it. Took 5 minutes to break it with this: set sqlprompt '&&umachine - &who_var@&instance_var SQL> ' Jared "Orr, Steve" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/30/2002 01:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: SQL*Plus in 10i > BTW: Anybody's using gqlplus? Whoa, I've been looking for something like this. Is it any good? -Original Message- Sent: Friday, August 30, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Yes, Oracle will sell it as standalone product because it is most useful and most used client software on Oracle. The licence model is 'per session'. :-))) BTW: Anybody's using gqlplus? http://gqlplus.sourceforge.net/ JP On Friday 30 August 2002 18:23, you wrote: > Anyone else hear that SQL*Plus is going away in 10i?? > > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
Yeah, let's break the backbone of many dba's toolbox.
This must be one of the stupider things they've done lately.
Reminds of a time when I repaired computers, and the mfgr
wanted to remove test points from boards to save $0.25.
I would guess we could make use of IOUG to take up this issue.
Jared
"Freeman, Robert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/30/2002 01:43 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: SQL*Plus in 10i
They are going to have iSQL*Plus (or however it's spelled) and you can use
that (and OEM)
for startup and shutdown. The SQL*Plus text and windows clinet I hear will
be gone.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
The avalanche has begun, It is too late for the pebbles to vote.
-Original Message-
Sent: Friday, August 30, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
oradim -startup -sid -pfile ???
They got rid of SVRMGR.
ltiu
On Friday 30 August 2002 11:08, you wrote:
> How do they expect you to start and stop the database if it goes away?
> and please don't say OEM...
>
> --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > Anyone else hear that SQL*Plus is going away in 10i??
> >
> >
> > RF
> >
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i (Sybex)
> >
> > The avalanche has begun, It is too late for the pebbles to vote.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Freeman, Robert
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> __
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
I've been looking for something like this too -- unfortunately it doesn't work on my platform (UnixWare 7) out of the box, and I haven't had time to figure out why not. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 30, 2002 4:28 PM > BTW: Anybody's using gqlplus? Whoa, I've been looking for something like this. Is it any good? -Original Message- Sent: Friday, August 30, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Yes, Oracle will sell it as standalone product because it is most useful and most used client software on Oracle. The licence model is 'per session'. :-))) BTW: Anybody's using gqlplus? http://gqlplus.sourceforge.net/ JP On Friday 30 August 2002 18:23, you wrote: > Anyone else hear that SQL*Plus is going away in 10i?? > > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Philip Douglass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
They are going to have iSQL*Plus (or however it's spelled) and you can use that (and OEM) for startup and shutdown. The SQL*Plus text and windows clinet I hear will be gone. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, August 30, 2002 2:34 PM To: Multiple recipients of list ORACLE-L oradim -startup -sid -pfile ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: > How do they expect you to start and stop the database if it goes away? > and please don't say OEM... > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > RF > > > > Robert G. Freeman - Oracle OCP > > Oracle Database Architect > > CSX Midtier Database Administration > > Author > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > Oracle9i New Features (Oracle Press) > > Mastering Oracle8i (Sybex) > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Freeman, Robert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
And as for OEM, I've heard from several sources that Oracle is going to position that product more and more to be "THE" database management interface. It's going to start feeling like we are working on a SQL Server database before you know it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, August 30, 2002 2:09 PM To: Multiple recipients of list ORACLE-L How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > Anyone else hear that SQL*Plus is going away in 10i?? > > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
Having McNealy, Ellison and Gates working for the same company? It would be somewhat like Heller's "Milo Enterprises" > -Original Message- > From: ltiu [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 30, 2002 3:59 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: SQL*Plus in 10i > > > Rumor ... > > They might as well buy SUN along the way (and get rid of Java > for good). > SUN's market cap is only $13B. MS got $300B. > > On Friday 30 August 2002 12:44, Gogala, Mladen wrote: > > Connected to that, there is a rumor tha M$ will buy Oracle > Corp., with > > Larry Ellison taking the place of Steve Ballmer. > > > > -Original Message- > > Sent: Friday, August 30, 2002 3:24 PM > > To: Multiple recipients of list ORACLE-L > > > > > > oradim is only a windows thingy. Those of us on real OS's > use svrmgrl or > > sqlplus depending on version. Are you saying that they are > going to port > > oradim to *NIX?? > > > > Rodd > > > > On Fri, 2002-08-30 at 13:33, ltiu wrote: > > > > oradim -startup -sid -pfile ??? > > > > > > > > They got rid of SVRMGR. > > > > > > > > ltiu > > > > On Friday 30 August 2002 11:08, you wrote: > > > How do they expect you to start and stop the database if > it goes away? > > > > > > and please don't say OEM... > > > > > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > > > > > > > > > > > > > > > > > > > RF > > > > > > > > > > > > > > > > Robert G. Freeman - Oracle OCP > > > > > > > > Oracle Database Architect > > > > > > > > CSX Midtier Database Administration > > > > > > > > Author > > > > > > > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > > > > > > > Oracle9i New Features (Oracle Press) > > > > > > > > Mastering Oracle8i (Sybex) > > > > > > > > > > > > > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > > > > > > > > > > > > > -- > > > > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > > > > -- > > > > > > > > Author: Freeman, Robert > > > > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > > > > > > > > San Diego, California-- Public Internet access / Mailing > > > > > > > > Lists > > > > > > > > > > > > > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > > > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > > > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > > > > > (or the name of mailing list you want to be removed > from). You may > > > > > > > > also send the HELP command for other information (like > subscribing). > > > > > > __ > > > > > > Do You Yahoo!? > > > > > > Yahoo! Finance - Get real-time stock quotes > > > > > > http://finance.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
> BTW: Anybody's using gqlplus? Whoa, I've been looking for something like this. Is it any good? -Original Message- Sent: Friday, August 30, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Yes, Oracle will sell it as standalone product because it is most useful and most used client software on Oracle. The licence model is 'per session'. :-))) BTW: Anybody's using gqlplus? http://gqlplus.sourceforge.net/ JP On Friday 30 August 2002 18:23, you wrote: > Anyone else hear that SQL*Plus is going away in 10i?? > > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
Rumor ... They might as well buy SUN along the way (and get rid of Java for good). SUN's market cap is only $13B. MS got $300B. On Friday 30 August 2002 12:44, Gogala, Mladen wrote: > Connected to that, there is a rumor tha M$ will buy Oracle Corp., with > Larry Ellison taking the place of Steve Ballmer. > > -Original Message- > Sent: Friday, August 30, 2002 3:24 PM > To: Multiple recipients of list ORACLE-L > > > oradim is only a windows thingy. Those of us on real OS's use svrmgrl or > sqlplus depending on version. Are you saying that they are going to port > oradim to *NIX?? > > Rodd > > On Fri, 2002-08-30 at 13:33, ltiu wrote: > > oradim -startup -sid -pfile ??? > > > > They got rid of SVRMGR. > > > > ltiu > > On Friday 30 August 2002 11:08, you wrote: > > How do they expect you to start and stop the database if it goes away? > > > > and please don't say OEM... > > > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > > > > > > > > > > > > > RF > > > > > > > > > > > > Robert G. Freeman - Oracle OCP > > > > > > Oracle Database Architect > > > > > > CSX Midtier Database Administration > > > > > > Author > > > > > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > > > > > Oracle9i New Features (Oracle Press) > > > > > > Mastering Oracle8i (Sybex) > > > > > > > > > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > > > > > > > > > -- > > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > > -- > > > > > > Author: Freeman, Robert > > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > > > > San Diego, California-- Public Internet access / Mailing > > > > > > Lists > > > > > > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > > > (or the name of mailing list you want to be removed from). You may > > > > > > also send the HELP command for other information (like subscribing). > > > > __ > > > > Do You Yahoo!? > > > > Yahoo! Finance - Get real-time stock quotes > > > > http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
Why not? It's easy to use. It will increase Oracle's market share to the dumb and dumber. ltiu On Friday 30 August 2002 12:24, you wrote: > oradim is only a windows thingy. Those of us on real OS's use svrmgrl > or sqlplus depending on version. Are you saying that they are going to > port oradim to *NIX?? > > Rodd > > On Fri, 2002-08-30 at 13:33, ltiu wrote: > > oradim -startup -sid -pfile ??? > > They got rid of SVRMGR. > > ltiu > > On Friday 30 August 2002 11:08, you wrote: > > How do they expect you to start and stop the database if it goes > > away? and please don't say OEM... > > > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > > > > RF > > > > > > Robert G. Freeman - Oracle OCP > > > Oracle Database Architect > > > CSX Midtier Database Administration > > > Author > > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > > Oracle9i New Features (Oracle Press) > > > Mastering Oracle8i (Sybex) > > > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Freeman, Robert > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing > > > Lists > > > --- > > >- To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > > name of mailing list you want to be removed from). You may also > > > send the HELP command for other information (like subscribing). > > > > __ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
thats the Stupid WINDOZE way. joe ltiu wrote: >oradim -startup -sid -pfile ??? > >They got rid of SVRMGR. > >ltiu > >On Friday 30 August 2002 11:08, you wrote: > >>How do they expect you to start and stop the database if it goes away? >>and please don't say OEM... >> >>--- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: >> >>>Anyone else hear that SQL*Plus is going away in 10i?? >>> >>> >>>RF >>> >>>Robert G. Freeman - Oracle OCP >>>Oracle Database Architect >>>CSX Midtier Database Administration >>>Author >>>Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) >>>Oracle9i New Features (Oracle Press) >>>Mastering Oracle8i (Sybex) >>> >>>The avalanche has begun, It is too late for the pebbles to vote. >>> >>>-- >>>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>>-- >>>Author: Freeman, Robert >>> INET: [EMAIL PROTECTED] >>> >>>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>>San Diego, California-- Public Internet access / Mailing >>>Lists >>> >>>To REMOVE yourself from this mailing list, send an E-Mail message >>>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>>the message BODY, include a line containing: UNSUB ORACLE-L >>>(or the name of mailing list you want to be removed from). You may >>>also send the HELP command for other information (like subscribing). >>> >>__ >>Do You Yahoo!? >>Yahoo! Finance - Get real-time stock quotes >>http://finance.yahoo.com >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
Connected to that, there is a rumor tha M$ will buy Oracle Corp., with Larry Ellison taking the place of Steve Ballmer. -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Friday, August 30, 2002 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SQL*Plus in 10ioradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX?? Rodd On Fri, 2002-08-30 at 13:33, ltiu wrote: oradim -startup -sid -pfile ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: > How do they expect you to start and stop the database if it goes away? > and please don't say OEM... > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > RF > > > > Robert G. Freeman - Oracle OCP > > Oracle Database Architect > > CSX Midtier Database Administration > > Author > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > Oracle9i New Features (Oracle Press) > > Mastering Oracle8i (Sybex) > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Freeman, Robert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
oradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX?? Rodd On Fri, 2002-08-30 at 13:33, ltiu wrote: oradim -startup -sid -pfile ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: > How do they expect you to start and stop the database if it goes away? > and please don't say OEM... > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > RF > > > > Robert G. Freeman - Oracle OCP > > Oracle Database Architect > > CSX Midtier Database Administration > > Author > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > Oracle9i New Features (Oracle Press) > > Mastering Oracle8i (Sybex) > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Freeman, Robert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
What would be the replacement?? -Original Message- Sent: Friday, August 30, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
We only need to start it. It usually stops itself without human control.
That is why we have ora-600 and ora-7445 features implemented in PMON
and SMON. As for starting and stopping, let me be innovative:
What do you say to call the start/stop program "IOR" and have
database startup performed by "ior w" and database creation by "ior i"
("i" liki "init"). That would be a new and improved thing, wouldn't it?
May be, calling the program "sqldba" would be even better. Integrating
an ncurses version of top sessions monitor and rollback segment monitor
would also be an outrageous improvement, don't you think so?
> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 2:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SQL*Plus in 10i
>
>
> How do they expect you to start and stop the database if it goes away?
> and please don't say OEM...
>
>
> --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> > Anyone else hear that SQL*Plus is going away in 10i??
> >
> >
> > RF
> >
> > Robert G. Freeman - Oracle OCP
> > Oracle Database Architect
> > CSX Midtier Database Administration
> > Author
> > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
> > Oracle9i New Features (Oracle Press)
> > Mastering Oracle8i (Sybex)
> >
> > The avalanche has begun, It is too late for the pebbles to vote.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Freeman, Robert
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> > Lists
> >
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
> http://finance.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
oradim -startup -sid -pfile ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: > How do they expect you to start and stop the database if it goes away? > and please don't say OEM... > > --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > > Anyone else hear that SQL*Plus is going away in 10i?? > > > > > > RF > > > > Robert G. Freeman - Oracle OCP > > Oracle Database Architect > > CSX Midtier Database Administration > > Author > > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > > Oracle9i New Features (Oracle Press) > > Mastering Oracle8i (Sybex) > > > > The avalanche has begun, It is too late for the pebbles to vote. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Freeman, Robert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
Yes, Oracle will sell it as standalone product because it is most useful and most used client software on Oracle. The licence model is 'per session'. :-))) BTW: Anybody's using gqlplus? http://gqlplus.sourceforge.net/ JP On Friday 30 August 2002 18:23, you wrote: > Anyone else hear that SQL*Plus is going away in 10i?? > > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
Nooo!!! On Friday 30 August 2002 09:23, Freeman, Robert wrote: > Anyone else hear that SQL*Plus is going away in 10i?? > > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > Anyone else hear that SQL*Plus is going away in 10i?? > > > RF > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) > Oracle9i New Features (Oracle Press) > Mastering Oracle8i (Sybex) > > The avalanche has begun, It is too late for the pebbles to vote. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus in 10i
Are you kidding? So what do we use to startup and shutdown db? OEM? I don't think there is any truth to this one. Richard -Original Message- Sent: Friday, August 30, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus blowing up on query on V$AQ...
I had never heard of that bug, but I checked it out on MetaLink and took it for a spin myself: SQL*Plus: Release 8.1.7.0.0 - Production on Thu Aug 1 21:26:16 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to:Oracle8i Enterprise Edition Release 8.1.7.0.0 - ProductionWith the Partitioning optionJServer Release 8.1.7.0.0 - Production SQL> select * from v$aq;ERROR:ORA-00604: error occurred at recursive SQL level 1ORA-01001: invalid cursorORA-00604: error occurred at recursive SQL level 1ORA-01001: invalid cursor no rows selected Confirms what you're saying, along with what is documented in bugs #2092731 and #2131687. But, then what about this here? Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - ProductionWith the Partitioning optionJServer Release 8.1.7.0.0 - Production SVRMGR> connect internalConnected.SVRMGR> select * from v$aq;QID WAITING READY EXPIRED TOTAL_WAIT AVERAGE_WA-- -- -- -- -- -- 2569 0 0 0 0 0 2571 0 0 0 0 0 2579 0 0 0 0 0 2581 0 0 0 0 0 (about 100 rows removed to shorten display) 25388 0 0 0 0 0 25389 0 0 0 0 0 25390 0 0 0 0 0ORA-00604: error occurred at recursive SQL level 1ORA-01001: invalid cursorORA-00604: error occurred at recursive SQL level 1ORA-01001: invalid cursor SVRMGR> So, it is happening in Server Mangler as well. Let's just say that Server Manager gets a little further along than SQL*Plus, for what that's worth. Still, it would seem that it's not a problem particular to SQL*Plus, but rather a problem either in OCI or the RDBMS. Sure, it could be a problem in both SQL*Plus and SVRMGR only, but since these products were developed separately, I'm guessing not. If I had a "C" compiler, I'd compile up the OCI demo program "cdemo2" and see if it blows up also. My money is that it is AQ itself, which uses OO features within the RDBMS. I did a SQL Trace level 12 on the statement and there is an awful lot of recursive object-oriented stuff going on behind the scenes when you do a simple query of V$AQ... ...in summary, I'm not surprised that it blows up -- I'm more surprised that it ever works at all... :-) Thanks April! That was cool... - Original Message - From: "April Wells" <[EMAIL PROTECTED]> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 11:58 AM Subject: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA > > The functionality for Server Manager command-line was migrated in it's> entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle> eliminated svrmgrl not so much as a way of deprecating command-line> utilities in general, but rather to consolidate redundant products...> > > Except you still can't select from V$AQ in sqlplus even in 9i... just a> teeny little thing... but (per a dozen hits on metalink) it only works in> server manager... > > ajw> > > -Original Message-> Sent: Tuesday, July 30, 2002 12:45 PM> To: Multiple recipients of list ORACLE-L> > > Tim:> > I take exception to the age thing here. Yes, I remember rewriting the MVS> procs for Oracle's MVS implementation because they never checked to see if> MPM was running in the background task manager of SDSF. Add to it that I> wrote (helped Oracle) a complete TSO Dialog Manager interface to all of the> Oracle tools that ran on the mainframe.> > GUI tools hide the "work" involved in solving the problem Go Command> Line!!!> > Thank You> > Stephen P. Karniotis> Product Architect> Compuware Corporation> Direct: (248) 865-4350> Mobile: (248) 408-2918> Email: [EMAIL PROTECTED]> Web: www.compuware.com> > -Original Message-> Sent: Tuesday, July 30, 2002 12:38 PM> To: Multiple recipients of list ORACLE-L> Subject: Re: Guys: Is this worth $1,749 for 8 year Oracle veteran> DBA> > GUI tools are simply a front-end presentation layer for SQL commands. GUI> tools do not "bypass" the SQL command-line layer; they only abstract it.> Command-line tools (such as SQL*Plus) use the same API as the GUI tools, but> simply do a lot less abstraction on the presentation. Command-line tools> will never "go the way of the dodo", because they are part of the diagnostic> process for GUI tools, if nothing e
Re: SQL*Plus/UTL_FILE vs. 3'rd Party Data Extraction
Perl is very fast, very flexible, and quite inexpensive. :) See my post earlier today that includes the TOC from "Perl for Oracle DBA's" Jared "Post, Ethan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/02/2002 09:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:SQL*Plus/UTL_FILE vs. 3'rd Party Data Extraction I have some people who are asking about 3'rd party data extraction tools to pull data from Oracle into text files for loading a data warehouse. I am not sure what the size of the project is but I think it is pretty big. The DW is Terradata. Anyway, they are stating Oracle tools are too slow. They do not define slow so it is hard to argue with them. My opinion is that it is very dependent on hardware (CPU/Disk) in most cases. What are your opinions on the matter, do you need 3'rd party? What tools are you using (I am aware of Informatica and such but I think they are looking for something a little cheaper)? Thanks, Ethan Post -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sql plus help - display more text on a line
Title: RE: sql plus help - display more text on a line Bill, You're on the right track, both should work, if you want to see the text on screen, change the SQL*Plus environment, i.e. Options->Environment and under Screen Buffer increase the Buffer_Width, to some large number (larger than the text you're trying to see). If you don't care about seeing the text on screen, set linesize to an appropriately large number then spool a file. When you view the spool file, it should look fine. HTH, Rich -Original Message- From: Magaliff, Bill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 2:26 PM To: Multiple recipients of list ORACLE-L Subject: sql plus help - display more text on a line how can I display more text on a line? I've adjusted linesize, but the last several columns are chopped off . . . there's a screen buffer setting in the SQLPlus environment, but it doesn't seem to do anything that I can see. thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus Connection
Hello , In windows you can choose where to connect without connect string by setting registry value HKLM\Software\ORACLE\local = 'default_connect_string' Friday, May 24, 2002, 1:13:20 PM, you wrote: SB> How a connection gets established when we don't SB> specify the connect string SB> (i.e. sqlplus usr/pass ...typically when working in a SB> Server) ? SB> This type of connection is established as LOCAL=YES SB> and uses BEQ protocol SB> as opposed to TCP in case of client-server mode by SB> SQL*net V2/net8. SB> Question:1 SB> When a request is made for this type of connction ( SB> without connect string ) SB> how it gets resolved and ultimately connects to the SB> database ? SB> Question:2 SB> Is there any kind of *.ora file ( like sqlnet.ora SB> ,protocol.ora etc ) SB> which is used/accessed to establish this direct SB> connection ? SB> __ SB> Do You Yahoo!? SB> LAUNCH - Your Yahoo! Music Experience SB> http://launch.yahoo.com -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus and DBMS_OUTPUT won't display extended charset?
Yup, as I mentioned in the "export..." statement, it is. Looks like an iTAR... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 16, 2002 6:08 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: SQL*Plus and DBMS_OUTPUT won't display extended charset? > > > I'm not 100% sure, but don't you also have to set those NLS > parms on your > client??? > > Chris > > -Original Message- > Sent: Thursday, May 16, 2002 6:28 PM > To: Multiple recipients of list ORACLE-L > > > Oracle 8.1.7.2.0 > HP/UX 11.0 > DB was converted from USASCII7 to UTF8 > NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are both "UTF8" in DB. > "export NLS_LANG=AMERICAN_AMERICA.UTF8" in client environment > (Korn shell). > > In SVRMGRL on the DB server, when I SELECT CHR(200) FROM > DUAL, I get the > character displayed properly (Latin capital "E" with grave > accent). In > SQL*Plus, however, the character does not appear. Also, when I use > DBMS_OUTPUT.PUT_LINE to dump CHR(200) to the screen in either > Server Manager > or SQL*Plus, nothing shows up. > > Anyone know what's going on here? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus and DBMS_OUTPUT won't display extended charset?
I'm not 100% sure, but don't you also have to set those NLS parms on your client??? Chris -Original Message- Sent: Thursday, May 16, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Oracle 8.1.7.2.0 HP/UX 11.0 DB was converted from USASCII7 to UTF8 NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are both "UTF8" in DB. "export NLS_LANG=AMERICAN_AMERICA.UTF8" in client environment (Korn shell). In SVRMGRL on the DB server, when I SELECT CHR(200) FROM DUAL, I get the character displayed properly (Latin capital "E" with grave accent). In SQL*Plus, however, the character does not appear. Also, when I use DBMS_OUTPUT.PUT_LINE to dump CHR(200) to the screen in either Server Manager or SQL*Plus, nothing shows up. Anyone know what's going on here? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql/PLUS Question
You can do SELECT * FROM nls_database_parameters; Rick -Original Message- Sent: Thursday, July 26, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Hi All, Just a short How to... Is there some way to find out what your session parameters are. I am aware of the > show parameters; But an example is NLS_DATE_FORMAT, if you change it from the system default using alter session. And run > show parameter It still remains with no value in the VALUE column of the output. Hope I made myself clear. Thanks In Advance Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql/PLUS Question
In sqlplus you can select * from v$parameter; -Original Message- Sent: Thursday, July 26, 2001 9:06 AM To: Multiple recipients of list ORACLE-L Hi All, Just a short How to... Is there some way to find out what your session parameters are. I am aware of the > show parameters; But an example is NLS_DATE_FORMAT, if you change it from the system default using alter session. And run > show parameter It still remains with no value in the VALUE column of the output. Hope I made myself clear. Thanks In Advance Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
