Title: RE: help in SqlLoader; NULLIF function
see answer below
> -Original Message-
> From: Venkatesh, Sankar (CAP, GEFA)
> [mailto:[EMAIL PROTECTED]]
>
> Using Solaris and Oracle 8.1.7
>
> What is the syntax of NULLIF condition in "sqlldr ", when we
> have multiple
> null conditi
Export to NLA0: would do 100% compression. Nope, I'm afraid that you can not
use pipes in VMS. You may be able to create a permanent mailbox and write a
program that would compress it and forward it through the network, but it
would
be an extremely complicated thing. My advice is to export it to
Title: RE: Anybody Using Veritas Database Edition
Agree. After using Quick IO the performance is better.
But I still have one problem : autoextend datafile and also
extending a datafile manually is not working for datafile
using quick IO.
Rivaldi
-Original Message-
From: Vijay R
No. The main disadvantage is you need to shut the database to convert the
database files to quick I/O files and you can not grow quick I/O files
online. In other words, you can have database file with autoextend on.
We haven't enabled cached quick I/O.
- Original Message -
To: "Multiple
Hi listers...
Could you recomend me some good free (not shareware) terminal emulation
software for Windows?
Something little better than windows telnet.exe?
Thanks in advance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DKTS
INET: [EMAIL PROTECTED]
Fat City N
Hi Nuno (and list),
Changing 'optimizer_index_caching' and 'optimizer_index_cost_adj' does seem to
inhibit cursor sharing under 8i. You may want to try the following test under
8.0 and see if it is any different.
SQL> create table t as select * from dual;
Table created.
Title: RE: shutdown immediate
I am
at Oracle 8.0.5 AIX 4.3.2
should
I upgrade my Oracle db to get
a good
shutdown immediate?
-Original Message-From: Behar, Rivaldi
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 09,
2001 2:46 PMTo: Multiple recipients of list
ORACLE-LSubjec
Can anyone tell me what the syntax is to start, stop, or reload the listener
when there is a password on it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Not as pissed off as the time he trusted me with the root password, and I absent
mindedly ran this command from the root partition:
chown *
>>> [EMAIL PROTECTED] 05/09/01 03:16PM >>>
On Wed, 9 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:
->make exponentially growing files and
look at http://www.uk.research.att.com/vnc/
HTH
Ed Maurer
> -Original Message-
> From: DKTS [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 3:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Terminal Emulation Sw.
>
>
> Hi listers...
>
> Could you recomend me s
--- Leslie Lu <[EMAIL PROTECTED]> wrote:
> Thank you for all those who answered my question.
>
> I just installed uwin. I'm running a script
> upgrade_db.ksh. In the script, there is someting
> like:
>
> function check_login {
>
>
>
Title: RE: never mind -- Re: ??? Again: run unix script on NT
Look in ORACLE_HOME\bin for the correct name of the SQL*Plus executable. Be sure to use the line command version (the one WITHOUT a W at the end of the file name.) Depending on the version of Oracle, it could be SQLPLUS, or PLUS80,
If password protection is being used, you must set the password before you
can issue the STOP command. When using passwords for the listener, you
cannot issue the STOP command at the operating system level because the
password can only be set within the lsnctrl utility.
There are two types of p
Cool!
(Originally Al Martino, "Moon Over Naples")
Here is Elvis Presley's (suitably cheesy) rendition:
http://tinpan.fortunecity.com/metal/114/spanishlive.ra
:)
(linked from: http://tinpan.fortunecity.com/metal/114/index.html )
Date sent: Wed, 09 May 2001 13:30:45 -0800
To:
Title: RE: Hey, looks like MS got .NET to work!!
> -Original Message-
> From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
>
> Here is Elvis Presley's (suitably cheesy) rendition:
>
> http://tinpan.fortunecity.com/metal/114/spanishlive.ra
>
> From: Jacques Kilchoer <
woo hoo! Bambi's back and we've got her! :)
welcome home, you've been missed
>From: "Bambi Bellows" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: consistency in cost?
>Date: Wed, 09 May 2001 14:31:01 -0800
>
>Tim -
Hi Steve,
I tested it on Oracle 8.1.6.3 (Solaris 2.6).
Parse_calls gets incremented every time the sql gets executed but the
version_count continues to be 1.
Regards,
Waleed
-Original Message-
Sent: Wednesday, May 09, 2001 6:15 PM
To: Multiple recipients of list ORACLE-L
Hi Nuno (an
I can think of no practical(?) use except for parallel server.
In parallel server an instance will aquire private rollback
segments specified in init.ora. If none (or too few) are
specified, it will aquire public rollback segments. Public
rollback segments are, in my opinion, only useful in
I suppose you could but I'd rather not touch the default views when a simple
join in my query can give me the same results
Linda
-Original Message-
Sent: Wednesday, May 09, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
why dont you go to that view and edit that sql then it
Haven't used my copy much either. Agree that it's hard to read, maybe because
it's organized such that it's difficult to find things in haste, or there
isn't enough white space, or the font bugs me, I dunno :-)
Rachel Carmichael wrote:
>
> hm, I'm surprised you don't like the DBA Handbook... I
Thanks Jacques
Your suggestion worked perfectly for me.
The following is the exact translation in my case (ditto of your
suggestion).
TerminationDate POSITION(58:63) "decode (:TerminationDate,
'00', NULL, '99', NULL, '731014', NULL, to_date (:TerminationDate,
'YYMMDD') )"
Thank you for all those who answered my question.
I just installed uwin. I'm running a script
upgrade_db.ksh. In the script, there is someting
like:
function check_login {
# Login to the database using the variables
provided
##
Jacques,
Thanks for the great tip, you are right, Humperdinck is
*vastly* superior!
http://www.interhit.com/engelbertlp.html
"THE DANCE ALBUM"
http://www.interhit.com/engelbertlpcredits.html
-
l'canta:
http://www.interhit.com/spanisheyes.ram
-
("spanglish" version):
http://www.i
Tim --
Oh, sure, bring LOGIC into it. Truth of the matter is that Oracle is trying to phase
out the last vestiges of v5, and that's never EVER going to happen. Logic be dammed!
Mwahahahaha!
Bambi.
--Original Message-
Date: Wed, 09 May 2001 05:01:06 -0800
To: Multiple recipients of
yeah? Well how do you like this?
while :
do
mkdir ./t
cd ./t
done
;)
Jared
On Wednesday 09 May 2001 09:00, Norrell, Brian wrote:
> You want to crash the server? On any Unix box, execute the following four
> commands:
>
> echo './t.sh &' > t.sh
> echo './t.sh &' >> t.sh
> chmo
I see someone has already given you instructions on how
to use a password with listener.ora.
Just thought I might add that they are fairly useless, as you
*cannot* prevent someone with dba group privileges on another
node of the network from shutting down your listener.
They won't be able to st
I'll have to disagree with not using commit within a loop.
If you identify what a transaction is within your code, and
write it accordingly, using commit where appropriate, you
will not get ORA-1002 or ORA-1555, at least not due
to your own code.
I've written a number of routines to do just t
Dick explained the locks, I'll talk a little about how I've
used it and seen it used.
In an user application, doing a SELECT FOR UPDATE and
letting the user update the data in the form at his or her leisure
and then COMMIT the data is very bad practice. Sounds kind
of like Designer 2000 in that
If what you need is terminal emulation, such as VT100, etc,
goto www.download.com and do a search for terminal
software.
I have used Tere Term Pro a number of times and am
quite happy with it. There is another piece of software
on the net that that will let it use SSH.
Here are some links, ho
Hi all,
I tried without word bear is not working too
I tried password that contain
numbers, special characters, not common english word
the ORA-00988 still there :(
Sinardy
-Original Message-
Sent: Wednesday, 9 May 2001 9:41 PM
To: Multiple recipients of list ORACLE-L
sinardy,
hello...
I wonder, why I have to startup my ORACLE database manually..(using SVRMGRL
then STARTUP).
I checked the NT services and oracle TNS listener plus services for ORCL are
already automatic.
need answers.
thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Auth
can you imagine how BIG that book would be if the font was larger???
>From: SuzyV <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Oracle books
>Date: Wed, 09 May 2001 16:21:01 -0800
>
>
>Haven't used my copy much either
you blow your nose at? Man, the quality of friendly insults on this list
has risen dramatically :)
>From: Jacques Kilchoer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Hey, looks like MS got .NET to work!!
>Date: W
I'm using TeraTerm Pro with the SSH add-on... works beautifully for us
www.download.com
>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Terminal Emulation Sw.
>Date: Wed, 09 May 2001 18:27:21 -0800
>
why do I get an image of you sticking your tongue out at Brian? :)
>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Cool way to crash an Oracle database, any time, any place
>Date: Wed, 09 May 2001 17:
Hi Waleed,
I ran the test below under 8.1.6.0 on NT using SQL*Plus and I would have
expected the same results under 8.1.6.3 on Solaris.
Do you possibly have a small shared pool with very quick reuse?
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
Just another viewpoint:
The Oracle server newsgroup does have some very knowledgeable contributors -
eg Jonathan Lewis and members of Oracle's own ODBC group amongst probably
others.
Also, the lazydba list which (if I remember correctly) started this
comparison is distinct to the newsgroup.
Reg
Give full path of sqlplus executable. eg.
BAD_LOGIN=`d:/orant/sqlplus -s ${SQLUSER}/${PW}@${DB}
HTH,
Rajesh
-Original Message-
Sent: Thursday, May 10, 2001 2:36 AM
To: Multiple recipients of list ORACLE-L
Thank you for all those who answered my question.
I just installed uwin.
Hi Steve, Waleed
on 8.1.6.0 Solaris I've got the same results as Waleed has.
Shared pool is huge, about 250M and user activity is low at the moment
(users haven't woken up yet :)
Is it NT-specific?
Regards,
Ed
>
>
> Hi Waleed,
>
> I ran the test below under 8.1.6.0 on NT using SQL*Plus
I have to say that the newsgroup comp.oracle.databases.server is much
more NT Friendly.
(IOUG: Did anything happen from IOUG concerning the ORACLE-NT-L mailing
list?)
Not just Jonathan Lewis, but Sybrand Baker, Howard Rodgers, Ricky
Sanchez put out some pretty good stuff.
I'd post to the ORACLE-L
101 - 140 of 140 matches
Mail list logo