date:20031104

Ive read the stuff on OTN. I read rene nyffenegger's stuff on his page. any other docs 
on this out there you can recommend? Id prefer not having to hunt through google.com 
for them.

i dont create databases at work. Look for stuff on Windows and Linux so I can play 
around at home. 

-- 
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: redhat/oracle

2003-11-04 Thread Rodd Holman

I suspect that Oracle will continue to support RH AS.  That is the only
version they ever supported officially.  So the pay status of RH and
Oracle is a moot point.  However, those of us who play with it knew that
with a couple of adjustments it would run on the free version.  What
will happen there?? I'll probably try and swing my support towards
SuSE.  It's a well put together distro.  I've worked with 8.1 and 8.2. 
Both installed Oracle flawlessly without needing the RH tweaks.

Rodd

On Tue, 2003-11-04 at 08:19, Ron Rogers wrote:
 For the time being there are Linux ISO'S at http://www.linuxiso.org/
 including the RED HAT consumer linux.
 Ron
 
  [EMAIL PROTECTED] 11/03/2003 10:44:27 PM 
 Well, if RedHat starts exhibitting tendencies of becoming another
 Microsoft,
 there are Mandrake, Debian , SuSE and (don't shoot, I'm just kidding)
 SCO.
 (duck, and quickly)
 On 2003.11.03 20:54, Joe Testa wrote:
  Well with RH latest ordeal of jumping out of simple ISOs and
 basically no  
  more free software, what is oracle's stand on running on RH?,  the
 paid  
  version only from now on and those linux users out there, what are WE
 going  
  to do?
  
  Looking to see if i need to spend money before end of year for tax
 write-off :)
  
  joe
  
  
 -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
  Author: Joe Testa
   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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodd Holman
  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: char(1) VS varchar2(1)

2003-11-04 Thread Walt Weaver

Well, I'm planning on being there too Bill, so there will be at least
one non-deity in the audience.:)

--Walt Weaver
  Bozeman, Montana

On Tue, 2003-11-04 at 06:49, Thater, William wrote:
 Tim Gorman  scribbled on the wall in glitter crayon:
 
  Yes!  RMOUG Training Days is going to be an incredible event this
  year!  A 2-day conference in Colorado during ski season with a lineup
  of speakers that rivals the major international conferences,
  including keynotes by Bill Inmon and Sue Cook!  We're going to have a
  blast;  I'm looking forward to meeting you!
 
 oh good lord, i'll be in the company of gods and the goddess!  this here
 going to be right good.;-)  now lets hope the schedule me so i can go to
 your presentations... or maybe i should be scheduled against one of you so
 nobody comes to mine.;-)
 
 --
 Bill Shrek Thater ORACLE DBA  
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]
 
 I bet the human brain is a kludge. - Marvin Minsky
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Walt Weaver
  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: redhat/oracle

2003-11-04 Thread Rodd Holman

No.  But the free download of RH9 looks to end in March 04.  Then there
will only be the three pay versions starting at USD $179.00.  All
support for previous versions is GONE.  Sounds like another Micro$oft in
the birthing stage.

Rodd

On Tue, 2003-11-04 at 03:24, Mark Leith wrote:
 OK, this is even more confusing to me. According to the following page:
 
 http://www.redhat.com/download/products.html
 
 You can download Red Hat Linux for free from http://ftp.redhat.com or
 ftp://ftp.redhat.com. To access the Red Hat FTP site, use anonymous as you
 user name and your email address as the password.
 
 I actually downloaded Red Hat 9 on Friday. That download (in iso format) is
 available from the above FTP (which is pretty overloaded lately), and also
 available from:
 
 ftp://ftp.mirror.ac.uk/sites/ftp.redhat.com/pub/redhat/linux/9/en/iso/i386/
 
 So, do I have to pay a license to use it?
 
 BTW, ftp://ftp.mirror.ac.uk/sites/ has to be one of the best FTP sites in
 the world - bookmark it! ;)
 
 Cheers
 
 Mark
 
 
 -Original Message-
 Mladen Gogala
 Sent: 04 November 2003 04:59
 To: Multiple recipients of list ORACLE-L
 
 
 I'll try my luck with SuSE. It apparently has IBM support.  Red Hat is
 starting to act badly and brings memories of one former Xenix reseller
 which made fortune by selling operating system written by IBM.
 
 On 2003.11.03 23:24, Jared Still wrote:
  This is news to me. RH will no longer let you download Linux for free?
 
  hmmm
 
  Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/
 
  The cheapest version is $179.00 US.  Looks like the next version
  for me will be Gentoo.
 
  Jared
 
  On Mon, 2003-11-03 at 17:54, Joe Testa wrote:
   Well with RH latest ordeal of jumping out of simple ISOs and basically
   no more free software, what is oracle's stand on running on RH?,  the
   paid version only from now on and those linux users out there, what are
   WE going to do?
  
   Looking to see if i need to spend money before end of year for tax
   write-off :)
  
   joe
  
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: Joe Testa
 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).
 
 
 --
 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).
 ---
 Incoming mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodd Holman
  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

Re: redhat/oracle

2003-11-04 Thread Joe Testa

And now novell is eating up Suse, http://www.slashdot.org  8:45A today.

joe

Rodd Holman wrote:

I suspect that Oracle will continue to support RH AS.  That is the only
version they ever supported officially.  So the pay status of RH and
Oracle is a moot point.  However, those of us who play with it knew that
with a couple of adjustments it would run on the free version.  What
will happen there?? I'll probably try and swing my support towards
SuSE.  It's a well put together distro.  I've worked with 8.1 and 8.2. 
Both installed Oracle flawlessly without needing the RH tweaks.

Rodd

On Tue, 2003-11-04 at 08:19, Ron Rogers wrote:
 

For the time being there are Linux ISO'S at http://www.linuxiso.org/
including the RED HAT consumer linux.
Ron
   

[EMAIL PROTECTED] 11/03/2003 10:44:27 PM 
 

Well, if RedHat starts exhibitting tendencies of becoming another
Microsoft,
there are Mandrake, Debian , SuSE and (don't shoot, I'm just kidding)
SCO.
(duck, and quickly)
On 2003.11.03 20:54, Joe Testa wrote:
   

Well with RH latest ordeal of jumping out of simple ISOs and
 

basically no  
   

more free software, what is oracle's stand on running on RH?,  the
 

paid  
   

version only from now on and those linux users out there, what are WE
 

going  
   

to do?

Looking to see if i need to spend money before end of year for tax
 

write-off :)
   

joe

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
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
   



 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 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: char(1) VS varchar2(1)

2003-11-04 Thread Thater, William

Walt Weaver  scribbled on the wall in glitter crayon:

 Well, I'm planning on being there too Bill, so there will be at least
 one non-deity in the audience.:)

seriously cool!  we'll have to go find a corner out of the god light and
have a few beers.;-)

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

The personal computer market is about the same size as the total potato chip
market. Next year it will be about half the size of the pet food market and
is fast approaching the total worldwide sales of panty hose. - James Finke,
President, Commodore International Ltd. 1982 
-- 
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: redhat/oracle

2003-11-04 Thread Joe Testa

What I dont like about Suse is no ISOs unless you're willing to pay for 
the software.  maybe i'll just buy the WS version and write it off on my 
taxes to run oracle on., hmm

blah.

joe



Rodd Holman wrote:

I suspect that Oracle will continue to support RH AS.  That is the only
version they ever supported officially.  So the pay status of RH and
Oracle is a moot point.  However, those of us who play with it knew that
with a couple of adjustments it would run on the free version.  What
will happen there?? I'll probably try and swing my support towards
SuSE.  It's a well put together distro.  I've worked with 8.1 and 
8.2. Both installed Oracle flawlessly without needing the RH tweaks.

Rodd

On Tue, 2003-11-04 at 08:19, Ron Rogers wrote:
 

For the time being there are Linux ISO'S at http://www.linuxiso.org/
including the RED HAT consumer linux.
Ron
  

[EMAIL PROTECTED] 11/03/2003 10:44:27 PM 


Well, if RedHat starts exhibitting tendencies of becoming another
Microsoft,
there are Mandrake, Debian , SuSE and (don't shoot, I'm just kidding)
SCO.
(duck, and quickly)
On 2003.11.03 20:54, Joe Testa wrote:
  

Well with RH latest ordeal of jumping out of simple ISOs and

basically no

more free software, what is oracle's stand on running on RH?,  the

paid

version only from now on and those linux users out there, what are WE

going

to do?

Looking to see if i need to spend money before end of year for tax

write-off :)
  

joe

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
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
  


 


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 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).

RMAN: connecting target DB with SYS account using connect string

2003-11-04 Thread Saminathan

Hi list,

I have problem connecting to target DB using account SYS with connect string. But 
SQL*Plus works fine.

For example,

SQLconnect sys/[EMAIL PROTECTED]
connected.

but in RMAN (using same OS account and server)
==

RMAN connect target sys/[EMAIL PROTECTED]  failed
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-04005: error from target database: ORA-01017: invalid username/password; logon 
denied

Any help will be really appreciated.

-Sami


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saminathan
  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: redhat/oracle

2003-11-04 Thread Stahlke, Mark

This just came in on the suse-oracle-announce mail list:

Dear SUSE Oracle customers,

SUSE LINUX is to be aquired by Novell:
http://www.novell.com/news/press/archive/2003/11/pr03069.html

We will of course continue our Enterprise Server product line and our 
close relationship with Oracle!


Regards,
Michael Hasenstein

Cheers,
Mark Stahlke
Denver Newspaper Agency

-Original Message-
Sent: Monday, November 03, 2003 9:59 PM
To: Multiple recipients of list ORACLE-L


I'll try my luck with SuSE. It apparently has IBM support.  Red Hat is
starting to act badly and brings memories of one former Xenix reseller
which made fortune by selling operating system written by IBM.

On 2003.11.03 23:24, Jared Still wrote:
 This is news to me. RH will no longer let you download Linux for free?
 
 hmmm
 
 Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/
 
 The cheapest version is $179.00 US.  Looks like the next version
 for me will be Gentoo.
 
 Jared
 
 On Mon, 2003-11-03 at 17:54, Joe Testa wrote:
  Well with RH latest ordeal of jumping out of simple ISOs and basically
  no more free software, what is oracle's stand on running on RH?,  the
  paid version only from now on and those linux users out there, what are
  WE going to do?
 
  Looking to see if i need to spend money before end of year for tax
  write-off :)
 
  joe
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Joe Testa
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).


-- 
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: Stahlke, Mark
  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: redhat/oracle

2003-11-04 Thread Ramón Estevez

Agree with you

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994



-Original Message-
Sent: Tuesday, November 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


I suspect that Oracle will continue to support RH AS.  That is the only version they 
ever supported officially.  So the pay status of RH and Oracle is a moot point.  
However, those of us who play with it knew that with a couple of adjustments it would 
run on the free version.  What will happen there?? I'll probably try and swing my 
support towards SuSE.  It's a well put together distro.  I've worked with 8.1 and 8.2. 
Both installed Oracle flawlessly without needing the RH tweaks.

Rodd

On Tue, 2003-11-04 at 08:19, Ron Rogers wrote:
 For the time being there are Linux ISO'S at http://www.linuxiso.org/ 
 including the RED HAT consumer linux. Ron
 
  [EMAIL PROTECTED] 11/03/2003 10:44:27 PM 
 Well, if RedHat starts exhibitting tendencies of becoming another 
 Microsoft, there are Mandrake, Debian , SuSE and (don't shoot, I'm 
 just kidding) SCO.
 (duck, and quickly)
 On 2003.11.03 20:54, Joe Testa wrote:
  Well with RH latest ordeal of jumping out of simple ISOs and
 basically no
  more free software, what is oracle's stand on running on RH?,  the
 paid
  version only from now on and those linux users out there, what are 
  WE
 going
  to do?
  
  Looking to see if i need to spend money before end of year for tax
 write-off :)
  
  joe
  
  
 --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
  Author: Joe Testa
   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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodd Holman
  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: =?iso-8859-1?Q?Ram=F3n_Estevez?=
  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: char(1) VS varchar2(1)

2003-11-04 Thread Walt Weaver

On Tue, 2003-11-04 at 08:04, Thater, William wrote:
 Walt Weaver  scribbled on the wall in glitter crayon:
 
  Well, I'm planning on being there too Bill, so there will be at least
  one non-deity in the audience.:)
 
 seriously cool!  we'll have to go find a corner out of the god light and
 have a few beers.;-)
 
 --
 Bill Shrek Thater ORACLE DBA  
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]

Sounds good to me. We might even be able to think of something besides
Oracle to talk about.:)

--Walt
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Walt Weaver
  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: redhat/oracle

2003-11-04 Thread Mark Leith

Hope this is not getting too off topic, but I thought this may also be of
interest to those reading this thread:

http://www.theregister.co.uk/content/4/33770.html

Novell bags SuSE for $210m

Linux company SuSE was today acquired by Novell in a $210 million all-cash
deal.

The transaction is subject to regulatory approval and the winding up of
shareholder agreements. Novell expects the transaction to close by the end
of its first fiscal quarter (January 2004).



-Original Message-
Rodd Holman
Sent: 04 November 2003 14:59
To: Multiple recipients of list ORACLE-L


No.  But the free download of RH9 looks to end in March 04.  Then there
will only be the three pay versions starting at USD $179.00.  All
support for previous versions is GONE.  Sounds like another Micro$oft in
the birthing stage.

Rodd

On Tue, 2003-11-04 at 03:24, Mark Leith wrote:
 OK, this is even more confusing to me. According to the following page:

 http://www.redhat.com/download/products.html

 You can download Red Hat Linux for free from http://ftp.redhat.com or
 ftp://ftp.redhat.com. To access the Red Hat FTP site, use anonymous as you
 user name and your email address as the password.

 I actually downloaded Red Hat 9 on Friday. That download (in iso format)
is
 available from the above FTP (which is pretty overloaded lately), and also
 available from:


ftp://ftp.mirror.ac.uk/sites/ftp.redhat.com/pub/redhat/linux/9/en/iso/i386/

 So, do I have to pay a license to use it?

 BTW, ftp://ftp.mirror.ac.uk/sites/ has to be one of the best FTP sites in
 the world - bookmark it! ;)

 Cheers

 Mark


 -Original Message-
 Mladen Gogala
 Sent: 04 November 2003 04:59
 To: Multiple recipients of list ORACLE-L


 I'll try my luck with SuSE. It apparently has IBM support.  Red Hat is
 starting to act badly and brings memories of one former Xenix reseller
 which made fortune by selling operating system written by IBM.

 On 2003.11.03 23:24, Jared Still wrote:
  This is news to me. RH will no longer let you download Linux for free?
 
  hmmm
 
  Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/
 
  The cheapest version is $179.00 US.  Looks like the next version
  for me will be Gentoo.
 
  Jared
 
  On Mon, 2003-11-03 at 17:54, Joe Testa wrote:
   Well with RH latest ordeal of jumping out of simple ISOs and basically
   no more free software, what is oracle's stand on running on RH?,  the
   paid version only from now on and those linux users out there, what
are
   WE going to do?
  
   Looking to see if i need to spend money before end of year for tax
   write-off :)
  
   joe
  
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: Joe Testa
 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).
 

 --
 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).
 ---
 Incoming mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003

 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.530 /

RE: redhat/oracle

2003-11-04 Thread Henry Poras

Novell? Now there's a company that doesn't have a clue. Let's see, they
bought Cambridge Technology Parters to ummm let Jack Messman run
Novell??? If I'm wrong maybe it's because I Don't Know Jack
(http://www.novell.com/info/forms/wwsmc2001/jak.html)

Henry


-Original Message-
Joe Testa
Sent: Tuesday, November 04, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L


And now novell is eating up Suse, http://www.slashdot.org  8:45A today.

joe


Rodd Holman wrote:

I suspect that Oracle will continue to support RH AS.  That is the only
version they ever supported officially.  So the pay status of RH and
Oracle is a moot point.  However, those of us who play with it knew that
with a couple of adjustments it would run on the free version.  What
will happen there?? I'll probably try and swing my support towards
SuSE.  It's a well put together distro.  I've worked with 8.1 and 8.2.
Both installed Oracle flawlessly without needing the RH tweaks.

Rodd

On Tue, 2003-11-04 at 08:19, Ron Rogers wrote:


For the time being there are Linux ISO'S at http://www.linuxiso.org/
including the RED HAT consumer linux.
Ron



[EMAIL PROTECTED] 11/03/2003 10:44:27 PM 


Well, if RedHat starts exhibitting tendencies of becoming another
Microsoft,
there are Mandrake, Debian , SuSE and (don't shoot, I'm just kidding)
SCO.
(duck, and quickly)
On 2003.11.03 20:54, Joe Testa wrote:


Well with RH latest ordeal of jumping out of simple ISOs and


basically no


more free software, what is oracle's stand on running on RH?,  the


paid


version only from now on and those linux users out there, what are WE


going


to do?

Looking to see if i need to spend money before end of year for tax


write-off :)


joe


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 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







--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
  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: Henry Poras
  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[2]: redhat/oracle

2003-11-04 Thread Jonathan Gennick

Tuesday, November 4, 2003, 10:14:25 AM, you wrote:
JT What I dont like about Suse is no ISOs unless you're willing to pay for 
JT the software.  maybe i'll just buy the WS version and write it off on my 
JT taxes to run oracle on., hmm

This is something I'm struggling with. I want to run Oracle
on my lab systems, but I can't really afford to part with
the $1500 or so that RH Enterprise costs. Oracle nicely
makes their software free for learning, etc. Red Hat,
unfortunately, does not.

I think Red Hat's strategy makes a certain amount of sense
though. They've identified a niche that will pay handsomely,
compared to what your average consumer will pay, for Linux.
Why not focus on that market?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: char(1) VS varchar2(1)

2003-11-04 Thread April Wells

Title: RE: char(1) VS varchar2(1)





got my alternate status. There will be 2 non-deity entities in the crowd.


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
 /\
/ \
/ \
\ /
 \/
 \
 \
 \
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Walt Weaver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 04, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: char(1) VS varchar2(1)



Well, I'm planning on being there too Bill, so there will be at least
one non-deity in the audience. :)


--Walt Weaver
 Bozeman, Montana


On Tue, 2003-11-04 at 06:49, Thater, William wrote:
 Tim Gorman scribbled on the wall in glitter crayon:
 
  Yes! RMOUG Training Days is going to be an incredible event this
  year! A 2-day conference in Colorado during ski season with a lineup
  of speakers that rivals the major international conferences,
  including keynotes by Bill Inmon and Sue Cook! We're going to have a
  blast; I'm looking forward to meeting you!
 
 oh good lord, i'll be in the company of gods and the goddess! this here
 going to be right good.;-) now lets hope the schedule me so i can go to
 your presentations... or maybe i should be scheduled against one of you so
 nobody comes to mine.;-)
 
 --
 Bill Shrek Thater ORACLE DBA 
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]
 
 I bet the human brain is a kludge. - Marvin Minsky
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Walt Weaver
 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).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: RMAN: connecting target DB with SYS account using connect str

2003-11-04 Thread Gorbounov,Vadim

Sami,

RMAN connects as SYSDBA. The password may actually be different. 

The good one is that works

SQLconnect sys/[EMAIL PROTECTED] as SYSDBA

HTH
Vadim

-Original Message-
Sent: Tuesday, November 04, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
string


Hi list,

I have problem connecting to target DB using account SYS with connect
string. But SQL*Plus works fine.

For example,

SQLconnect sys/[EMAIL PROTECTED]
connected.

but in RMAN (using same OS account and server)
==

RMAN connect target sys/[EMAIL PROTECTED]  failed
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-04005: error from target database: ORA-01017: invalid
username/password; logon denied

Any help will be really appreciated.

-Sami


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saminathan
  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: Gorbounov,Vadim
  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: char(1) VS varchar2(1)

2003-11-04 Thread Pete Sharman

Well, there'll be other non-gods there as well.  I had two papers accepted -
guess I better start writing something for them now!  :)

Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not.  It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Thater, William
Sent: Wednesday, November 05, 2003 12:49 AM
To: Multiple recipients of list ORACLE-L


Tim Gorman  scribbled on the wall in glitter crayon:

 Yes!  RMOUG Training Days is going to be an incredible event this 
 year!  A 2-day conference in Colorado during ski season with a lineup 
 of speakers that rivals the major international conferences, including 
 keynotes by Bill Inmon and Sue Cook!  We're going to have a blast;  
 I'm looking forward to meeting you!

oh good lord, i'll be in the company of gods and the goddess!  this here
going to be right good.;-)  now lets hope the schedule me so i can go to
your presentations... or maybe i should be scheduled against one of you so
nobody comes to mine.;-)

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

I bet the human brain is a kludge. - Marvin Minsky
-- 
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  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: RMAN: connecting target DB with SYS account using connect str

2003-11-04 Thread DENNIS WILLIAMS

Sami - You may also need to create an orapw file in order to connect as
SYSDBA remotely.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 04, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
str


Sami,

RMAN connects as SYSDBA. The password may actually be different. 

The good one is that works

SQLconnect sys/[EMAIL PROTECTED] as SYSDBA

HTH
Vadim

-Original Message-
Sent: Tuesday, November 04, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
string


Hi list,

I have problem connecting to target DB using account SYS with connect
string. But SQL*Plus works fine.

For example,

SQLconnect sys/[EMAIL PROTECTED]
connected.

but in RMAN (using same OS account and server)
==

RMAN connect target sys/[EMAIL PROTECTED]  failed
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-04005: error from target database: ORA-01017: invalid
username/password; logon denied

Any help will be really appreciated.

-Sami


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saminathan
  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: Gorbounov,Vadim
  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: 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).

SQL*PLUS buffer width and buffer length stored where ??

2003-11-04 Thread Bob Metelsky

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 

Optionsenvironment
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).

RE: Re[2]: redhat/oracle

2003-11-04 Thread Hately, Mike (LogicaCMG)

RHAS Developer Edition, £40 a pop for download. Best money I've spent this
year.

Mike Hately

-Original Message-
Sent: 04 November 2003 15:45
To: Multiple recipients of list ORACLE-L


Tuesday, November 4, 2003, 10:14:25 AM, you wrote:
JT What I dont like about Suse is no ISOs unless you're willing to pay for JT the 
software.  maybe i'll just buy the WS version and write it off on my

JT taxes to run oracle on., hmm

This is something I'm struggling with. I want to run Oracle
on my lab systems, but I can't really afford to part with
the $1500 or so that RH Enterprise costs. Oracle nicely
makes their software free for learning, etc. Red Hat,
unfortunately, does not.

I think Red Hat's strategy makes a certain amount of sense
though. They've identified a niche that will pay handsomely,
compared to what your average consumer will pay, for Linux.
Why not focus on that market?

Best regards,




E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

No warranty of any kind is given in respect of any information contained in this   
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  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).

ORA-24314

2003-11-04 Thread Nuala Cullen


Hello All,

I've been connecting to a customers server via VPN.

I've been able to connect to the database on the server  via SQLPLUS  Toad
but when I try to do an import or connect via SQLPLUS /NOLOG I get an
ORA-24314 error (no service handler).

I've tried looking for an answer on the web but no joy.

I rang the dba at the site and got him to connect to the machine (not via
VPN) and he had no problems doing the import and connecting via SQLPLUS
/NOLOG.
I also connected to another box via pcanywhere and had no problems with the
SQLPLUS /NOLOG option.

What I would like to know is how come some oracle operations are not
possible via VPN? 

Thanks in advance,

N.

ps oracle version 8.1.7.4 running on Windows 2000 server


winmail.dat

RE: redhat/oracle

2003-11-04 Thread Thater, William

Joe Testa  scribbled on the wall in glitter crayon:

 And now novell is eating up Suse, http://www.slashdot.org  8:45A
 today. 
 
 joe

so now that Linux has made it are we going to have a Linux provider melt
down?  with no open source/free versions left?

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

Software is best understood as a branch of movie making. - Ted Nelson
-- 
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: redhat/oracle

2003-11-04 Thread Jesse, Rich

Mladen,

Save yourself from RPM hell and try Gentoo.  I ended up converting a box at
home from RH8 to Gentoo after much prodding by a co-worker or two.  I admit
it's mch easier to install/build packages under Gentoo because of
portage's dependency list that RPMs somehow seem to lack.  I gave up trying
to install Kino (non-linear editor/video capture) on RH8.  On Gentoo, it's
emerge -pv kino to see what it's going to do, then emerge -v kino to
actually do it.

And I've mentioned here before that Oracle 9iR2 was an a trouble-free
install on it, too! (to help keep this on-topic)

I suppose there is a potential argument for SuSE because of the
pseudo-supported by Oracle thing


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: Mladen Gogala [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 03, 2003 10:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: redhat/oracle
 
 
 I'll try my luck with SuSE. It apparently has IBM support.  Red Hat is
 starting to act badly and brings memories of one former Xenix reseller
 which made fortune by selling operating system written by IBM.
 
 On 2003.11.03 23:24, Jared Still wrote:
  This is news to me. RH will no longer let you download 
 Linux for free?
  
  hmmm
  
  Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/
  
  The cheapest version is $179.00 US.  Looks like the next version
  for me will be Gentoo.
  
  Jared
  
  On Mon, 2003-11-03 at 17:54, Joe Testa wrote:
   Well with RH latest ordeal of jumping out of simple ISOs 
 and basically
   no more free software, what is oracle's stand on running 
 on RH?,  the
   paid version only from now on and those linux users out 
 there, what are
   WE going to do?
  
   Looking to see if i need to spend money before end of year for tax
   write-off :)
  
   joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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: redhat/oracle

2003-11-04 Thread Boivin, Patrice J

I am still curious to see when linux will make it on the desktop, despite
the hype now we know that Red Hat is dropping that initiative.

Patrice.

-Original Message-
Sent: Tuesday, November 04, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L


Joe Testa  scribbled on the wall in glitter crayon:

 And now novell is eating up Suse, http://www.slashdot.org  8:45A
 today. 
 
 joe

so now that Linux has made it are we going to have a Linux provider melt
down?  with no open source/free versions left?

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

Software is best understood as a branch of movie making. - Ted Nelson
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  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: 10g new features


OK KG, the cat is out of the bag.

Now you have to tell all of us. Especially Raj. :)

Jared







K Gopalakrishnan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 01:29 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: 10g new features


Yong:

I was not joking. Actually there is a command to rename tablespaces in 9i
and that is undocumented. IIRC it is with some FROM and TO options or
something similar to that.

Let me check that come back to you offline..

KG

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 9:39 AM


 Gopal was joking about the fact that Jared only said 'alter tablespace
rename'
 instead of ALTER TABLESPACE RENAME DATAFILE.

 In fact, 9.2 SQL Reference has this

 Moving and Renaming Tablespaces: Example
 This example moves and renames a datafile associated with the tbs_01
tablespace
 from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat':

 If you only read the subtitle here (first line), you *will* be surprised.

 Yong

 --- Mladen Gogala [EMAIL PROTECTED] wrote:
  Actually, I don't understand what you mean. Here is 9.2:
 
  SQL create tablespace test datafile '/data/oradata/data/test01.dbf'
   2 size 10M extent management local autoallocate
   3 segment space management auto;
 
  Tablespace created.
 
  SQL alter tablespace test rename to test01;
  alter tablespace test rename to test01
*
  ERROR at line 1:
  ORA-01904: DATAFILE keyword expected
 
 
  SQL
 
 
  So, what did you mean?
 
  On 2003.11.03 21:59, K Gopalakrishnan wrote:
   Jared:
  
   'alter tablespace rename' is not the REAL 10g feature. It is available
   from 9.2 onwards... :) Hope you know what I mean,,
  
   KG
  
- Original Message -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, November 04, 2003 12:54 AM
Subject: 10g new features
  
  
  
Found a site with some 10g new features.
  
http://www.adp-gmbh.ch/ora/misc/10g.html
  
I'm sure some will like the new 'alter tablespace rename'
  
http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux
  
  
Jared
 
  -- 
  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).


 __
 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
 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: redhat/oracle

2003-11-04 Thread Stahlke, Mark

I'll second that recommendation for Gentoo. I'm running Oracle 9.2.0.3 on my
Gentoo based laptop and I just installed OWB on it too.

Installing Gentoo can take a long time but once it's done you'll have a
sweet system.

Cheers,
Mark Stahlke
Denver Newspaper Agency


-Original Message-
Sent: Tuesday, November 04, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L


Mladen,

Save yourself from RPM hell and try Gentoo.  I ended up converting a box at
home from RH8 to Gentoo after much prodding by a co-worker or two.  I admit
it's mch easier to install/build packages under Gentoo because of
portage's dependency list that RPMs somehow seem to lack.  I gave up trying
to install Kino (non-linear editor/video capture) on RH8.  On Gentoo, it's
emerge -pv kino to see what it's going to do, then emerge -v kino to
actually do it.

And I've mentioned here before that Oracle 9iR2 was an a trouble-free
install on it, too! (to help keep this on-topic)

I suppose there is a potential argument for SuSE because of the
pseudo-supported by Oracle thing


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: Mladen Gogala [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 03, 2003 10:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: redhat/oracle
 
 
 I'll try my luck with SuSE. It apparently has IBM support.  Red Hat is
 starting to act badly and brings memories of one former Xenix reseller
 which made fortune by selling operating system written by IBM.
 
 On 2003.11.03 23:24, Jared Still wrote:
  This is news to me. RH will no longer let you download 
 Linux for free?
  
  hmmm
  
  Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/
  
  The cheapest version is $179.00 US.  Looks like the next version
  for me will be Gentoo.
  
  Jared
  
  On Mon, 2003-11-03 at 17:54, Joe Testa wrote:
   Well with RH latest ordeal of jumping out of simple ISOs 
 and basically
   no more free software, what is oracle's stand on running 
 on RH?,  the
   paid version only from now on and those linux users out 
 there, what are
   WE going to do?
  
   Looking to see if i need to spend money before end of year for tax
   write-off :)
  
   joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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: Stahlke, Mark
  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 ??

2003-11-04 Thread Bob Metelsky

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 

Optionsenvironment
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: memory usage by dbw very high




 what is meant by OP,tanel..

Original Poster.

Tanel.

RE: 10g new features

2003-11-04 Thread Jamadagni, Rajendra




Oh My ...

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-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 04, 2003 
  12:25 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: 10g new featuresOK 
  KG, the cat is out of the bag. Now you 
  have to tell all of us. Especially Raj. :) Jared **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

Re: re Rebuilding Indexes in Oracle Apps -- an update




Jared,

I don't see how index skip scans could benefit more 
from a rebuild than from coalesce (providing the index height remains the same). 
Skip scan doesn't scan the whole index like FFS does, it just does several scans 
for each value set in beginning of concatenated index (+some more 
mechanisms).

Maybe I'm missing something here, what did you have 
in mind?

Tanel.


  If the index is 
  based simply on the unique key, and for some reason you are 
  using index_ffs on it, then rebuilding will 
  cut down the number of scanned blocks. It would be interesting to see how skip scans are affected by this as 
  well. Jared 
  
  


  
  Hemant K Chitale 
[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
11/01/2003 12:34 AM 
Please respond to ORACLE-L 
  To:   
 Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] cc:

 Subject:RE: re Rebuilding Indexes in 
Oracle Apps -- an updateRichard et al,{for those who've been 
  following the thread on Rebuilding Indexes ...}I've just been reading 
  the AskTom thread on rebuilding indexesat 
  http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:6601312252730and 
  picked on the important line"Coalesce... reclaim the free space from 
  mostly empty index leaf blocks that will not be reused otherwise due to 
  your increasing sequence. "Richard has also pointed COALESCE as a 
  better option.COALESCE would be a better option than REBUILD for Indexes 
  onmonotonically increasing sequences where older values are purged 
  periodically.Hemant K ChitaleOracle 9i Database Administrator 
  Certified ProfessionalMy personal web site is : 
  http://hkchital.tripod.com-- Please see the official 
  ORACLE-L FAQ: http://www.orafaq.net-- Author: Hemant K 
  ChitaleINET: [EMAIL PROTECTED]Fat City Network 
  Services  -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California-- Mailing list and web hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from). You mayalso send the HELP command 
  for other information (like 
subscribing).

Re: connecting target DB with SYS account using connect string

Hi!

Which version? RMAN automatically logs on as sysdba, IIRC.
Try to log on to your database using sqlplus with
sys/[EMAIL PROTECTED] as sysdba

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 5:14 PM


 Hi list,

 I have problem connecting to target DB using account SYS with connect
string. But SQL*Plus works fine.

 For example,

 SQLconnect sys/[EMAIL PROTECTED]
 connected.

 but in RMAN (using same OS account and server)
 ==

 RMAN connect target sys/[EMAIL PROTECTED]  failed
 RMAN-00571: ===
 RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
 RMAN-00571: ===
 RMAN-04005: error from target database: ORA-01017: invalid
username/password; logon denied

 Any help will be really appreciated.

 -Sami


 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Saminathan
   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: redhat/oracle

2003-11-04 Thread Mladen Gogala

No problem. I do have some very bad experiences with SuSE. Software
was nowhere to be found, they were pushing their own alternatives and the  
icing on the cake was when a member of SuSE support stuff has told me that  
building kernel is for experts only. I was trying to install OSS sound on my
box because it was working, in contrast to ALSA. I downloaded the official  
kernel (2.4.10 at the time), built it and ditched SuSE at the earliest  
convenience. Now that they were acquired by Novell, they may learn what is the  
meaning of the phrase customer support.
I am inclined to  try Gentoo, now that RH is no longer an option. In my  
opinion, Red Hat has just made a disastrous move which will cause them to  
perish within a year.
I believe that they need general public to remain on top because. at least to  
my knowledge, not much of the corporate world is committed to Linux. My  
prediction is that RH will be bought and Szulik will be out within two years  
from now.

On 2003.11.04 12:19, Jesse, Rich wrote:
Mladen,

Save yourself from RPM hell and try Gentoo.  I ended up converting a box at
home from RH8 to Gentoo after much prodding by a co-worker or two.  I admit
it's mch easier to install/build packages under Gentoo because of
portage's dependency list that RPMs somehow seem to lack.  I gave up trying
to install Kino (non-linear editor/video capture) on RH8.  On Gentoo, it's
emerge -pv kino to see what it's going to do, then emerge -v kino to
actually do it.
And I've mentioned here before that Oracle 9iR2 was an a trouble-free
install on it, too! (to help keep this on-topic)
I suppose there is a potential argument for SuSE because of the
pseudo-supported by Oracle thing
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 -Original Message-
 From: Mladen Gogala [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 03, 2003 10:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: redhat/oracle


 I'll try my luck with SuSE. It apparently has IBM support.  Red Hat is
 starting to act badly and brings memories of one former Xenix reseller
 which made fortune by selling operating system written by IBM.

 On 2003.11.03 23:24, Jared Still wrote:
  This is news to me. RH will no longer let you download
 Linux for free?
 
  hmmm
 
  Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/
 
  The cheapest version is $179.00 US.  Looks like the next version
  for me will be Gentoo.
 
  Jared
 
  On Mon, 2003-11-03 at 17:54, Joe Testa wrote:
   Well with RH latest ordeal of jumping out of simple ISOs
 and basically
   no more free software, what is oracle's stand on running
 on RH?,  the
   paid version only from now on and those linux users out
 there, what are
   WE going to do?
  
   Looking to see if i need to spend money before end of year for tax
   write-off :)
  
   joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  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[4]: redhat/oracle

2003-11-04 Thread Jonathan Gennick

Tuesday, November 4, 2003, 11:49:33 AM, Hately, Mike (LogicaCMG) ([EMAIL PROTECTED]) 
wrote:
HML RHAS Developer Edition, £40 a pop for download. Best money I've spent this
HML year.

What's the URL? You're not the first person to tell me this,
but so far I've not been able to find anything about it on
Red Hat's web site.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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).

explain plan conundrum

I cant sql trace it now. I hae run statspack. this query is running now and I dont 
want to run another copy with a trace on until this finishes, since I dont want to 
suck up resources. Im at a loss as to where the 20 billion rows comes from in this 
explain plan? Everything including the indexes are analyzed. 

when the two tables involved have 36k and 5k rows involved.
looks like some form of cartesian join, but its not showing up in the plan. The two 
tables are joined by a column. 

any place to look on this? I know I need the 10046 trace, but I cant get that yet and 
it make take 12 hours to get it after this runs. 

select col1,
   col2,
   col3 
from tab1
 tab2
where tab1.col1 = tab2.col2;


Operation   Object Name RowsBytes   CostObject Node In/Out  PStart 
 PStop

SELECT STATEMENT Optimizer Mode=CHOOSE  1 G 237
  
  HASH JOIN 1 G 20G 237  
INDEX FAST FULL SCANPK1 5 K 11 K3  
  
TABLE ACCESS FULL   TABLE2  366 K   4 M 231
  


-- 
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: redhat/oracle

2003-11-04 Thread Paul Drake

Debian.
http://www.debian.org/social_contract

"Thater, William" [EMAIL PROTECTED] wrote:
Joe Testa scribbled on the wall in glitter crayon: And now novell is eating up Suse, http://www.slashdot.org 8:45A today.   joeso now that Linux has "made it" are we going to have a Linux provider meltdown? with no open source/free versions left?--Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song[EMAIL PROTECTED]Software is best understood as a branch of movie making. - Ted Nelson-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Thater, WilliamINET: [EMAIL PROTECTED]
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

Re: 10g new features




Yup, out of bag, definitely. I already scanned 
through v$reserved_words to find anything usable with alter tablespace (or 
perhaps database), but no luck. However, words such "undrop" and "disk group" 
are already reserved in 9.2.0.4 ;-9

Tanel.


  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, November 04, 2003 7:24 
  PM
  Subject: Re: 10g new features
  OK KG, the cat is out of the 
  bag. Now you have to tell all of 
  us. Especially Raj. :) Jared 
  


  
  "K Gopalakrishnan" [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 
11/04/2003 01:29 AM 
Please respond to ORACLE-L 
  To:   
 Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
cc:  

   Subject:Re: 10g new 
featuresYong:I was not joking. Actually there is a command to rename 
  tablespaces in 9iand that is undocumented. IIRC it is with some FROM and 
  TO options orsomething similar to that.Let me check that come back 
  to you offline..KG- Original Message - To: 
  "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: 
  Tuesday, November 04, 2003 9:39 AM Gopal was joking about the 
  fact that Jared only said 'alter tablespacerename' instead of 
  ALTER TABLESPACE RENAME DATAFILE. In fact, 9.2 SQL Reference 
  has this Moving and Renaming Tablespaces: Example This 
  example moves and renames a datafile associated with the 
  tbs_01tablespace from 'diskb:tbs_f5.dat' to 
  'diska:tbs_f5.dat': If you only read the subtitle here (first 
  line), you *will* be surprised. Yong --- 
  Mladen Gogala [EMAIL PROTECTED] wrote:  Actually, I 
  don't understand what you mean. Here is 9.2:   SQL 
  create tablespace test datafile '/data/oradata/data/test01.dbf'  
   2 size 10M extent management local autoallocate  
   3 segment space management auto;   
  Tablespace created.   SQL alter tablespace test 
  rename to test01;  alter tablespace test rename to test01 
 
  *  ERROR at line 1:  
  ORA-01904: DATAFILE keyword expected
  SQLSo, what did you mean? 
On 2003.11.03 21:59, K Gopalakrishnan wrote:  
   Jared: 'alter tablespace rename' is 
  not the REAL 10g feature. It is available   from 9.2 
  onwards... :) Hope you know what I mean,, 
  KG  - Original Message 
  -From: [EMAIL PROTECTED]   
   To: Multiple recipients of list ORACLE-LSent: 
  Tuesday, November 04, 2003 12:54 AMSubject: 10g new 
  features
Found a site with some 10g new features.   
 http://www.adp-gmbh.ch/ora/misc/10g.html  
  I'm sure some will like the new 'alter 
  tablespace rename'  
  http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux  
Jared  
   --   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). 
  __ 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).-- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net-- 
  Author: K GopalakrishnanINET: [EMAIL PROTECTED]Fat City 
  Network Services  -- 858-538-5051 http://www.fatcity.comSan 
  Diego, California-- Mailing list and web hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from). You mayalso send the HELP command

Re: explain plan conundrum

some more info. 

I checked distinct values in those two tables. and there are 366,000 records in one 
table and 5,000 records in another however, the column that is joining to only has 4 
distinct values. I added a bitmap index to the columns and its using it on the smaller 
table. 

Im willing to be that is the problem. any possible way to tune a join against such few 
distinct values
 
 From: [EMAIL PROTECTED]
 Date: 2003/11/04 Tue PM 01:34:26 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: explain plan conundrum
 
 I cant sql trace it now. I hae run statspack. this query is running now and I dont 
 want to run another copy with a trace on until this finishes, since I dont want to 
 suck up resources. Im at a loss as to where the 20 billion rows comes from in this 
 explain plan? Everything including the indexes are analyzed. 
 
 when the two tables involved have 36k and 5k rows involved.
 looks like some form of cartesian join, but its not showing up in the plan. The two 
 tables are joined by a column. 
 
 any place to look on this? I know I need the 10046 trace, but I cant get that yet 
 and it make take 12 hours to get it after this runs. 
 
 select col1,
col2,
col3 
 from tab1
  tab2
 where tab1.col1 = tab2.col2;
 
 
 Operation Object Name RowsBytes   CostObject Node In/Out  PStart 
  PStop
 
 SELECT STATEMENT Optimizer Mode=CHOOSE1 G 237
   
   HASH JOIN   1 G 20G 237  
 INDEX FAST FULL SCAN  PK1 5 K 11 K3  
   
 TABLE ACCESS FULL TABLE2  366 K   4 M 231
   
 
 
 -- 
 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).
 

-- 
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: redhat/oracle

2003-11-04 Thread Mary Ruiz











Red
Hat To Drop Free Linux Products In Favor Of Enterprise



The
company is offering users two upgrade paths, either to the stable Enterprise
Linux product or to its developer-oriented Fedora Project, which is a free
download.



http://www.computerworld.com/newsletter/0,4902,86827,00.html?nlid=AM







-Original Message-
From: Paul Drake
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 04, 2003 1:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: redhat/oracle





Debian.





http://www.debian.org/social_contract












Thater,
William [EMAIL PROTECTED] wrote:





Joe Testa scribbled on the wall in glitter crayon:

 And now novell is eating up Suse, http://www.slashdot.org 8:45A
 today. 
 
 joe

so now that Linux has made it are we going to have a Linux provider
melt
down? with no open source/free versions left?

--
Bill Shrek Thater ORACLE DBA 
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

Software is best understood as a branch of movie making. - Ted Nelson
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
INET: [EMAIL PROTECTED]









Do you Yahoo!?
Protect your identity with
Yahoo! Mail AddressGuard

Re: explain plan conundrum

2003-11-04 Thread Wolfgang Breitling

It's not 20 billion rows but 20 billion bytes. It's only 1 billion rows. 
The cartesion product of 5K rows and 366K rows is 1830M rows or 1.8G. If 
the join predicate is not very selective, .5 or .33 for example, that would 
yield an estimated join cardinality of 1G (after rounding).

At 11:34 AM 11/4/2003, you wrote:
I cant sql trace it now. I hae run statspack. this query is running now 
and I dont want to run another copy with a trace on until this finishes, 
since I dont want to suck up resources. Im at a loss as to where the 20 
billion rows comes from in this explain plan? Everything including the 
indexes are analyzed.

when the two tables involved have 36k and 5k rows involved.
looks like some form of cartesian join, but its not showing up in the 
plan. The two tables are joined by a column.

any place to look on this? I know I need the 10046 trace, but I cant get 
that yet and it make take 12 hours to get it after this runs.

select col1,
   col2,
   col3
from tab1
 tab2
where tab1.col1 = tab2.col2;
Operation   Object Name RowsBytes   CostObject 
Node In/Out  PStart  PStop

SELECT STATEMENT Optimizer Mode=CHOOSE  1 
G 237
  HASH JOIN 1 
G 20G 237
INDEX FAST FULL SCANPK1 5 K 11 
K3
TABLE ACCESS FULL   TABLE2  366 K   4 
M 231
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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).

database terminated

2003-11-04 Thread David Boyd

Hi List,

One of our databases was terminated due to error 600.  Below is the error 
message from alert log file:

Tue Nov  4 12:00:25 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov  4 12:00:32 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov  4 12:00:32 2003
PMON: terminating instance due to error 600
Instance terminated by PMON, pid = 24501
Could any one please let me know what was the reason caused this happened?  
Where can I start to look at the potential cause?  Thanks in advance.

We are on Oracle 8.1.7 and OS Sun 5.8.

David

_
Concerned that messages may bounce because your Hotmail account is over 
limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: David Boyd
 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: explain plan conundrum

i figured it out. I use the ordered hint. Its actually a 3 table join and I took that 
out for simplicity in my question. I drove off a more selective join. Got it to run in 
1 minute. 

i almost never have to use ordered hint 

 From: [EMAIL PROTECTED]
 Date: 2003/11/04 Tue PM 01:34:26 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: explain plan conundrum

 I cant sql trace it now. I hae run statspack. this query is running now and I dont 
 want to run another copy with a trace on until this finishes, since I dont want to 
 suck up resources. Im at a loss as to where the 20 billion rows comes from in this 
 explain plan? Everything including the indexes are analyzed. 

 when the two tables involved have 36k and 5k rows involved.
 looks like some form of cartesian join, but its not showing up in the plan. The two 
 tables are joined by a column. 

 any place to look on this? I know I need the 10046 trace, but I cant get that yet 
 and it make take 12 hours to get it after this runs. 

 select col1,
col2,
col3 
 from tab1
  tab2
 where tab1.col1 = tab2.col2;

 Operation Object Name RowsBytes   CostObject Node In/Out  PStart 
  PStop

 SELECT STATEMENT Optimizer Mode=CHOOSE1 G 237

   HASH JOIN   1 G 20G 237  
 INDEX FAST FULL SCAN  PK1 5 K 11 K3  

 TABLE ACCESS FULL TABLE2  366 K   4 M 231

 -- 
 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).

-- 
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: redhat/oracle

2003-11-04 Thread Joe Testa

Jonathan, i got the developer version of RHAS 2.1 on CD, if you dont 
find it downloadable(which unless you paid for it, i dont think you 
can), let me know, i'll burn copies and send out to ya.

joe

Jonathan Gennick wrote:

Tuesday, November 4, 2003, 11:49:33 AM, Hately, Mike (LogicaCMG) ([EMAIL PROTECTED]) 
wrote:
HML RHAS Developer Edition, £40 a pop for download. Best money I've spent this
HML year.
What's the URL? You're not the first person to tell me this,
but so far I've not been able to find anything about it on
Red Hat's web site.
Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 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: explain plan conundrum

2003-11-04 Thread Yong Huang

Hi, Ryan,

Where's the 20 billion rows? There's 1 G rows and 20 G bytes.

What are the values of NUM_ROWS in xxx_INDEXES for PK1 and xxx_TABLES for
TABLE2? Did you analyze using ANALYZE command or DBMS_STATS?

Yong Huang

--- [EMAIL PROTECTED] wrote:
 I cant sql trace it now. I hae run statspack. this query is running now and I
 dont want to run another copy with a trace on until this finishes, since I
 dont want to suck up resources. Im at a loss as to where the 20 billion rows
 comes from in this explain plan? Everything including the indexes are
 analyzed. 
 
 when the two tables involved have 36k and 5k rows involved.
 looks like some form of cartesian join, but its not showing up in the plan.
 The two tables are joined by a column. 
 
 any place to look on this? I know I need the 10046 trace, but I cant get that
 yet and it make take 12 hours to get it after this runs. 
 
 select col1,
col2,
col3 
 from tab1
  tab2
 where tab1.col1 = tab2.col2;
 
 
 Operation Object Name RowsBytes   CostObject Node In/Out  PStart 
  PStop
 
 SELECT STATEMENT Optimizer Mode=CHOOSE1 G 237
   
   HASH JOIN   1 G 20G 237  
 INDEX FAST FULL SCAN  PK1 5 K 11 K3  
   
 TABLE ACCESS FULL TABLE2  366 K   4 M 231

__
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).

Function calls, queries, and trace files

2003-11-04 Thread Paul Baumgartel

I gather that the SQL within functions that are called in top-level SQL
statement are not considered recursive, and therefore do not conform to
Cary's rule

A database call with dep=n+1 is the recursive child of the first
subsequent dep=n database call listed in the SQL trace data stream.

But the dep value for such SQL is indeed 1 more than the dep value
of the caller, as in this excerpt:

PARSING IN CURSOR #1 len=124 dep=0 uid=149 oct=3 lid=149 tim=2988575045
   
 hv=440952914 ad='3775ee70'
select
outstanding_vested_for_100K(hextoraw('0001E8A6F8A94B40B95BBE32AF120D95'),
to_date('28-AUG-03','DD-MON-YY'))
from dual
END OF STMT
PARSE #1:c=0,e=203,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2988540123
EXEC #1:c=0,e=396,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=4,tim=2988596994
WAIT #1: nam='SQL*Net message to client' ela= 10 p1=1413697536 p2=1
p3=0
=
PARSING IN CURSOR #12 len=365 dep=1 uid=149 oct=3 lid=149
tim=2988604429 
  hv=3990937121 ad='344ddb98'
SELECT GrantType.Behavior from
GrantType,PlanStockClassGrantType,IssueGrant,GrantParticipant
where GrantParticipant.GrantParticipant_pk=:b1 and
IssueGrant.IssueGrant_pk=GrantParticipant.IssueGrant_fk
and IssueGrant.PlanStockClassGrantType_fk =
PlanStockClassGrantType.PlanStockClassGrantType_pk
and PlanStockClassGrantType.GrantType_fk=GrantType.GrantType_pk


The first SQL is what I entered in SQL*Plus (immediately after turning
on 10046 tracing).  The second is contained in the
outstanding_vested_for_100k function.  

Why is the motivating SQL shown in the trace first?

Is the rule for determining recursive relationships in a case like
this simply to follow the increasing dep values (with detours for
true recursive SQL, such as data dictionary access, that follows
Cary's rule)?

TIA



=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com

__
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: 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: database terminated

2003-11-04 Thread Paul Baumgartel

David,

First of all, fortunately, your database was not terminated--your
_instance_ was.   Your database lives on disk and can't be terminated
so easily, lucky for you.

ORA-00600 denotes an Oracle internal error (aka bug).  Open a TAR
with Oracle Support; optionally search MetaLink for the text in the
error message.  Good luck.


--- David Boyd [EMAIL PROTECTED] wrote:
 Hi List,
 
 One of our databases was terminated due to error 600.  Below is the
 error 
 message from alert log file:
 
 Tue Nov  4 12:00:25 2003
 Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
 ORA-00600: internal error code, arguments: [106], [], [], [], [], [],
 [], []
 Tue Nov  4 12:00:32 2003
 Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
 ORA-00600: internal error code, arguments: [106], [], [], [], [], [],
 [], []
 Tue Nov  4 12:00:32 2003
 PMON: terminating instance due to error 600
 Instance terminated by PMON, pid = 24501
 
 Could any one please let me know what was the reason caused this
 happened?  
 Where can I start to look at the potential cause?  Thanks in advance.
 
 We are on Oracle 8.1.7 and OS Sun 5.8.
 
 David
 
 _
 Concerned that messages may bounce because your Hotmail account is
 over 
 limit? Get Hotmail Extra Storage!
 http://join.msn.com/?PAGE=features/es
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: David Boyd
   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).


=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com

__
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: 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: database terminated

2003-11-04 Thread DENNIS WILLIAMS

David
http://metalink.oracle.com

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 04, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


Hi List,

One of our databases was terminated due to error 600.  Below is the error 
message from alert log file:

Tue Nov  4 12:00:25 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov  4 12:00:32 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov  4 12:00:32 2003
PMON: terminating instance due to error 600
Instance terminated by PMON, pid = 24501

Could any one please let me know what was the reason caused this happened?  
Where can I start to look at the potential cause?  Thanks in advance.

We are on Oracle 8.1.7 and OS Sun 5.8.

David

_
Concerned that messages may bounce because your Hotmail account is over 
limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Boyd
  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: 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: ORA-24314

2003-11-04 Thread DENNIS WILLIAMS

Nuala
   This was discussed recently on this list, but not to a definite
conclusion. The speculation is that is probably a firewall issue. Your VPN
probably has to go through a firewall, which is probably open for normal
telnet type activities like a terminal connection. But connecting to
Oracle remotely requires, at a minimum port 1521 to be open (or whatever
your listener is listening for). Maybe more if you are running MTS. Some
firewalls are reputed to be more Oracle aware than others. I would talk to
your network engineer. And if you get it working, let us know what you had
to do.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 04, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L



Hello All,

I've been connecting to a customers server via VPN.

I've been able to connect to the database on the server  via SQLPLUS  Toad
but when I try to do an import or connect via SQLPLUS /NOLOG I get an
ORA-24314 error (no service handler).

I've tried looking for an answer on the web but no joy.

I rang the dba at the site and got him to connect to the machine (not via
VPN) and he had no problems doing the import and connecting via SQLPLUS
/NOLOG.
I also connected to another box via pcanywhere and had no problems with the
SQLPLUS /NOLOG option.

What I would like to know is how come some oracle operations are not
possible via VPN? 

Thanks in advance,

N.

ps oracle version 8.1.7.4 running on Windows 2000 server


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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: database terminated

there is an ora-600 query screen on metalink. it has limited amounts of information. 
ora-600 is not documented anywhere else.

you need toopen a TAR immediately. ora-600 is not well documented. if you dont have a 
support plan, you may have a problem. 

 From: David Boyd [EMAIL PROTECTED]
 Date: 2003/11/04 Tue PM 02:04:26 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: database terminated

 Hi List,

 One of our databases was terminated due to error 600.  Below is the error 
 message from alert log file:

 Tue Nov  4 12:00:25 2003
 Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
 ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
 Tue Nov  4 12:00:32 2003
 Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
 ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
 Tue Nov  4 12:00:32 2003
 PMON: terminating instance due to error 600
 Instance terminated by PMON, pid = 24501

 Could any one please let me know what was the reason caused this happened?  
 Where can I start to look at the potential cause?  Thanks in advance.

 We are on Oracle 8.1.7 and OS Sun 5.8.

 David

 _
 Concerned that messages may bounce because your Hotmail account is over 
 limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: David Boyd
   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: redhat/oracle

2003-11-04 Thread Brian Haas

Thater, William wrote:
so now that Linux has made it are we going to have a Linux provider melt
down?  with no open source/free versions left?


I doubt it. Redhat or any other company can't lock up GPL'd software. The only 
thing they can keep you from copying/distributing is any proprietary 
applications they have added to the distribution.

AFAIK, you can download RH AS, just not is ISO form. The RPM's are available on 
their FTP site.

-Brian



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Brian Haas
 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: redhat/oracle

2003-11-04 Thread Brian Haas

Boivin, Patrice J wrote:
I am still curious to see when linux will make it on the desktop, despite
the hype now we know that Red Hat is dropping that initiative.
Patrice.


As far as I'm concerned, it has already made it. It's my primary desktop at 
work,with windows for those pesky apps that only run there. I guess I just like 
a more robust, unix-like os when I have to work on other unix systems all day. ;).

The free version of redhat is now called the fedora project. This will continue 
to be the experimental/desktop version that is along the same line as redhat 8  9

-Brian

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Brian Haas
 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: database terminated

2003-11-04 Thread Jamadagni, Rajendra

did someone by chance set any event for pmon process? There seems to be a bug 2329767 
reported. Metalink has lot of information ...

type in ora-600 106 in the search box.

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: Tuesday, November 04, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L


Hi List,

One of our databases was terminated due to error 600.  Below is the error 
message from alert log file:

Tue Nov  4 12:00:25 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov  4 12:00:32 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov  4 12:00:32 2003
PMON: terminating instance due to error 600
Instance terminated by PMON, pid = 24501

Could any one please let me know what was the reason caused this happened?  
Where can I start to look at the potential cause?  Thanks in advance.

We are on Oracle 8.1.7 and OS Sun 5.8.

David

**
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: 10g new features




Btw, bold guys fromPolishOracle 
UserGrouphave put out Oracle's 10g New Features beta documentation 
at their website...

http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf

I already sent a notification to PLOUG to remove 
this doc immediately, because I'm affiliated with European Oracle User Group 
myself and would not like if PLOUG would get into trouble.

But anyway, take the most out of this URL, it 
mightnot last for long;)

Tanel.


  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, November 04, 2003 8:04 
  PM
  Subject: RE: 10g new features
  
  Oh My ...
  
  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-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, November 04, 2003 
12:25 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: 10g new 
featuresOK KG, the cat 
is out of the bag. Now you have to 
tell all of us. Especially Raj. :) Jared 
  **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

RE: redhat/oracle

2003-11-04 Thread Jesse, Rich

Beware that the RPMs are SRPMs -- source.  You still have to roll it
yourself.  Given that, I'm sticking with Gentoo for home/development,
although it would make an interesting project.  A consultant here with some
mid-hurricane RH training-cut-short tells me that AS can be built from the
SRPMS and a working standard RH box.

singNo time for RedHat A.S.  There's no time left for you.  No time left
for you./sing


Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: Brian Haas [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, November 04, 2003 1:34 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: redhat/oracle
 
 
 Thater, William wrote:
  so now that Linux has made it are we going to have a 
 Linux provider melt
  down?  with no open source/free versions left?
 
 
 I doubt it. Redhat or any other company can't lock up GPL'd 
 software. The only 
 thing they can keep you from copying/distributing is any proprietary 
 applications they have added to the distribution.
 
 AFAIK, you can download RH AS, just not is ISO form. The 
 RPM's are available on 
 their FTP site.
 
 
 -Brian
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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: redhat/oracle

2003-11-04 Thread Boivin, Patrice J

Will Oracle 9iR2 run on fedora do you think?

Tonight I will check from home where I can download Fedora from, I am a
little fed up with XP's memory management (that half kernel, half user
process nonsense).

Patrice

-Original Message-
Sent: Tuesday, November 04, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L


Boivin, Patrice J wrote:
 I am still curious to see when linux will make it on the desktop, despite
 the hype now we know that Red Hat is dropping that initiative.
 
 Patrice.


As far as I'm concerned, it has already made it. It's my primary desktop at 
work,with windows for those pesky apps that only run there. I guess I just
like 
a more robust, unix-like os when I have to work on other unix systems all
day. ;).

The free version of redhat is now called the fedora project. This will
continue 
to be the experimental/desktop version that is along the same line as redhat
8  9


-Brian

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Brian Haas
  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: Boivin, Patrice J
  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: redhat/oracle

2003-11-04 Thread Rodd Holman

Actually the Novell initiative probably has the best shot.  With Novell
now owning NDS, Ximian Gnome, and SuSE they have a good combination for
success.  That's assuming boneheadded management decisions don't screw
it up.  The technology is there.

On Tue, 2003-11-04 at 11:24, Boivin, Patrice J wrote:
 I am still curious to see when linux will make it on the desktop, despite
 the hype now we know that Red Hat is dropping that initiative.
 
 Patrice.
 
 -Original Message-
 Sent: Tuesday, November 04, 2003 1:14 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Joe Testa  scribbled on the wall in glitter crayon:
 
  And now novell is eating up Suse, http://www.slashdot.org  8:45A
  today. 
  
  joe
 
 so now that Linux has made it are we going to have a Linux provider melt
 down?  with no open source/free versions left?
 
 --
 Bill Shrek Thater ORACLE DBA  
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]
 
 Software is best understood as a branch of movie making. - Ted Nelson
 -- 
 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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rodd Holman
  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: redhat/oracle

 AFAIK, you can download RH AS, just not is ISO form. The RPM's are
available on
 their FTP site.

To be precise, SRPMs are available on ftp site...

Tanel.


-- 
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: database terminated

2003-11-04 Thread Mercadante, Thomas F

bad news.  106 is an unreported error in the metalink/ora-600 site.
you need to submit a tar with Oracle.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, November 04, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L


did someone by chance set any event for pmon process? There seems to be a
bug 2329767 reported. Metalink has lot of information ...

type in ora-600 106 in the search box.

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: Tuesday, November 04, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L


Hi List,

One of our databases was terminated due to error 600.  Below is the error 
message from alert log file:

Tue Nov  4 12:00:25 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov  4 12:00:32 2003
Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
ORA-00600: internal error code, arguments: [106], [], [], [], [], [], [], []
Tue Nov  4 12:00:32 2003
PMON: terminating instance due to error 600
Instance terminated by PMON, pid = 24501

Could any one please let me know what was the reason caused this happened?  
Where can I start to look at the potential cause?  Thanks in advance.

We are on Oracle 8.1.7 and OS Sun 5.8.

David


**
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: Mercadante, Thomas F
  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: re Rebuilding Indexes in Oracle Apps -- an update

Now that I think about it, you're probably right.

I'll test it anyway, I like to see numbers. :)

Jared

Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 10:04 AM
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: re Rebuilding Indexes in Oracle Apps -- an update

Jared,

I don't see how index skip scans could benefit more from a rebuild than from coalesce (providing the index height remains the same). Skip scan doesn't scan the whole index like FFS does, it just does several scans for each value set in beginning of concatenated index (+some more mechanisms).

Maybe I'm missing something here, what did you have in mind?

Tanel.

If the index is based simply on the unique key, and for some reason you are
using index_ffs on it, then rebuilding will cut down the number of scanned blocks.

It would be interesting to see how skip scans are affected by this as well.

Jared

Hemant K Chitale [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/01/2003 12:34 AM
Please respond to ORACLE-L

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: re Rebuilding Indexes in Oracle Apps -- an update

Richard et al,

{for those who've been following the thread on Rebuilding Indexes ...}

I've just been reading the AskTom thread on rebuilding indexes
at
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:6601312252730

and picked on the important line
Coalesce... reclaim the free space from mostly empty index leaf blocks
that will not be reused otherwise due to your increasing sequence.

Richard has also pointed COALESCE as a better option.
COALESCE would be a better option than REBUILD for Indexes on
monotonically increasing sequences where older values are purged periodically.

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
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: Re: explain plan conundrum

everything is analyzed. For all indexes, for all indexed columns.

I used analyze. its the same as dbms_stats, just not as robust. I use it when I dont 
feel like typing out dbms_stats.

Are there optimizer parameters that help the optimizer determine join order? Ive never 
had to use the 'ordered' hint on the CBO before when everything is analyzed. The 
difference was huge. Ran for 2 hours and still going, with the hint ran in 45 seconds. 

im assuming there are some init.ora parameters that I should check out? Does oracle 
take into account 'distinctness' of the columns being joined? 
I have 1 table with 366,000 rows and another with 5,000 rows. the columns being joined 
have 4 distinct values each. However, the table with 366,000 rows joins on its primary 
key to another table and that filters out enough rows that that join should go first. 
The optimizer made a bad decision. 

how do i analyze why it made a bad join order decision? hints like this are a stop gap 
fix. 
 
 From: Yong Huang [EMAIL PROTECTED]
 Date: 2003/11/04 Tue PM 02:09:30 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: explain plan conundrum
 
 Hi, Ryan,
 
 Where's the 20 billion rows? There's 1 G rows and 20 G bytes.
 
 What are the values of NUM_ROWS in xxx_INDEXES for PK1 and xxx_TABLES for
 TABLE2? Did you analyze using ANALYZE command or DBMS_STATS?
 
 Yong Huang
 
 --- [EMAIL PROTECTED] wrote:
  I cant sql trace it now. I hae run statspack. this query is running now and I
  dont want to run another copy with a trace on until this finishes, since I
  dont want to suck up resources. Im at a loss as to where the 20 billion rows
  comes from in this explain plan? Everything including the indexes are
  analyzed. 
  
  when the two tables involved have 36k and 5k rows involved.
  looks like some form of cartesian join, but its not showing up in the plan.
  The two tables are joined by a column. 
  
  any place to look on this? I know I need the 10046 trace, but I cant get that
  yet and it make take 12 hours to get it after this runs. 
  
  select col1,
 col2,
 col3 
  from tab1
   tab2
  where tab1.col1 = tab2.col2;
  
  
  Operation   Object Name RowsBytes   CostObject Node In/Out  PStart 
   PStop
  
  SELECT STATEMENT Optimizer Mode=CHOOSE  1 G 237

HASH JOIN 1 G 20G 237  
  INDEX FAST FULL SCANPK1 5 K 11 K3  

  TABLE ACCESS FULL   TABLE2  366 K   4 M 231
 
 __
 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).
 

-- 
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: RMAN: connecting target DB with SYS account using connect string

2003-11-04 Thread Ruth Gramolini

IF you set your ORACLE_SID to the target database as the Oracle user, all
you have to do is say RMAN connect target and it will automatically
connect.  If you are working from the command line you connect
user_with_sysdba_privs/[EMAIL PROTECTED] and you will be connected.  If
does not recognize the as sysdba.

HTH,
Ruth

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
  Saminathan
  Sent: Tuesday, November 04, 2003 10:15 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN: connecting target DB with SYS account using connect
  string


  Hi list,

  I have problem connecting to target DB using account SYS with
  connect string. But SQL*Plus works fine.

  For example,

  SQLconnect sys/[EMAIL PROTECTED]
  connected.

  but in RMAN (using same OS account and server)
  ==

  RMAN connect target sys/[EMAIL PROTECTED]  failed
  RMAN-00571: ===
  RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
  RMAN-00571: ===
  RMAN-04005: error from target database: ORA-01017: invalid
  username/password; logon denied

  Any help will be really appreciated.

  -Sami


  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Saminathan
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: Ruth Gramolini
  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: Re: explain plan conundrum

2003-11-04 Thread Wolfgang Breitling

Could you please post the entire sql and plan and statistics of the tables 
and indexes so that we can comment on it rather than letting us guess on 
selective bits of the entire problem.

At 01:29 PM 11/4/2003, you wrote:
everything is analyzed. For all indexes, for all indexed columns.

I used analyze. its the same as dbms_stats, just not as robust. I use it 
when I dont feel like typing out dbms_stats.

Are there optimizer parameters that help the optimizer determine join 
order? Ive never had to use the 'ordered' hint on the CBO before when 
everything is analyzed. The difference was huge. Ran for 2 hours and still 
going, with the hint ran in 45 seconds.

im assuming there are some init.ora parameters that I should check out? 
Does oracle take into account 'distinctness' of the columns being joined?
I have 1 table with 366,000 rows and another with 5,000 rows. the columns 
being joined have 4 distinct values each. However, the table with 366,000 
rows joins on its primary key to another table and that filters out enough 
rows that that join should go first. The optimizer made a bad decision.

how do i analyze why it made a bad join order decision? hints like this 
are a stop gap fix.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: 10g new features


The link is dead. :(

But thanks to the googlecache effect, you can still see the doc:

http://216.239.57.104/search?q=cache:UVsNMDV-OBIJ:www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf+Oracle10g_New_Features.pdfhl=enie=UTF-8

Jared








Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 12:04 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: 10g new features


Btw, bold guys from Polish Oracle User Group have put out Oracle's 10g New Features beta documentation at their website...

http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf

I already sent a notification to PLOUG to remove this doc immediately, because I'm affiliated with European Oracle User Group myself and would not like if PLOUG would get into trouble.

But anyway, take the most out of this URL, it might not last for long ;)

Tanel.

- Original Message - 
From: Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 
Sent: Tuesday, November 04, 2003 8:04 PM
Subject: RE: 10g new features

Oh My ...

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-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: 10g new features


OK KG, the cat is out of the bag. 
Now you have to tell all of us. Especially Raj. :) 
Jared 


**
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

Re: database terminated

2003-11-04 Thread David Boyd

Thanks all of you who replied.  Your help is highly appreciated.  I'll open 
a TAR with Oracle.

David

From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: database terminated
Date: Tue, 04 Nov 2003 11:19:33 -0800
there is an ora-600 query screen on metalink. it has limited amounts of 
information. ora-600 is not documented anywhere else.

you need toopen a TAR immediately. ora-600 is not well documented. if you 
dont have a support plan, you may have a problem.

 From: David Boyd [EMAIL PROTECTED]
 Date: 2003/11/04 Tue PM 02:04:26 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: database terminated

 Hi List,

 One of our databases was terminated due to error 600.  Below is the 
error
 message from alert log file:

 Tue Nov  4 12:00:25 2003
 Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
 ORA-00600: internal error code, arguments: [106], [], [], [], [], [], 
[], []
 Tue Nov  4 12:00:32 2003
 Errors in file /oracle/admin/adminp0/bdump/adminp0_pmon_24501.trc:
 ORA-00600: internal error code, arguments: [106], [], [], [], [], [], 
[], []
 Tue Nov  4 12:00:32 2003
 PMON: terminating instance due to error 600
 Instance terminated by PMON, pid = 24501

 Could any one please let me know what was the reason caused this 
happened?
 Where can I start to look at the potential cause?  Thanks in advance.

 We are on Oracle 8.1.7 and OS Sun 5.8.

 David

 _
 Concerned that messages may bounce because your Hotmail account is over
 limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: David Boyd
   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).
_
MSN Shopping upgraded for the holidays!  Snappier product search... 
http://shopping.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: David Boyd
 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: redhat/oracle

2003-11-04 Thread Paul Drake

Mary,

This topic is better handled over at /. than here. (http://slashdot.org).
RedHat should have communicated more effectively that they are indeed still supporting both Libre and Gratis software (read: free as in speech, free as in beer).
For now, I'll sit on RH8.0 for Oracle 9i R2 development and with RH AS 2.1 for production. But SuSE gets another look - deservingly so.

Paul
Mary Ruiz [EMAIL PROTECTED] wrote:

Red Hat To Drop Free Linux Products In Favor Of Enterprise

The company is offering users two upgrade paths, either to the stable Enterprise Linux product or to its developer-oriented Fedora Project, which is a free download.

http://www.computerworld.com/newsletter/0,4902,86827,00.html?nlid=AM

-Original Message-From: Paul Drake [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: redhat/oracle

Debian.

http://www.debian.org/social_contract

"Thater, William" [EMAIL PROTECTED] wrote:

Joe Testa scribbled on the wall in glitter crayon: And now novell is eating up Suse, http://www.slashdot.org 8:45A today. joeso now that Linux has "made it" are we going to have a Linux provider meltdown? with no open source/free versions left?--Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song[EMAIL PROTECTED]Software is best understood as a branch of movie making. - Ted Nelson-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Thater, WilliamINET: [EMAIL PROTECTED]

Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

** SQL WHERE clause order

2003-11-04 Thread A Joshi

Hi,
   In a SQL statement I want a certain where clause to be done first. Is it enough to 
list it first as follows or do I (and can I) do something else to make it get checked 
first before other WHERE/AND clause are looked at. Thanks :
 
SELECT emp_id FROM emp
WHERE select_sen_emp_chk_first = 'Y'
AND  dept = :dept
AND  salary  :min_sal

Re: redhat/oracle

2003-11-04 Thread Mladen Gogala

Hmmm, equally tragic: www.fakednews.com was shut down. I wanted to create a  
little spoof for this group about Red Hat being bought by Microsoft and  
starting to work on the new enterprise version of Linux called Longnose, which  
would  blend Linux with the unique Windows ability to propagate viruses, worms  
and trojans as well as create the world's first Linux port of BSOD (dubbed  
PSOD = Penguin Screen Of Death), but FakedNEws.com was shut down by CNN
lawyers. What a darned shame!

On 2003.11.04 14:04, Joe Testa wrote:
Jonathan, i got the developer version of RHAS 2.1 on CD, if you dont find it  
downloadable(which unless you paid for it, i dont think you can), let me  
know, i'll burn copies and send out to ya.

joe

Jonathan Gennick wrote:

Tuesday, November 4, 2003, 11:49:33 AM, Hately, Mike (LogicaCMG) (mike. 
[EMAIL PROTECTED]) wrote:
HML RHAS Developer Edition, £40 a pop for download. Best money I've spent  
this
HML year.

What's the URL? You're not the first person to tell me this,
but so far I've not been able to find anything about it on
Red Hat's web site.
Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by email. To join, visit  
http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to  
[EMAIL PROTECTED] and include the word subscribe in  
either the subject or body.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 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: redhat/oracle


 This topic is better handled over at /. than here

True enough in the general sense, though I don't necessarily
think it off topic here, as many of us use it to run Oracle.

And there is usually far too much garbage as /. to get
involved in the discussions, at least IMO.

Jared









Paul Drake [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 01:19 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: redhat/oracle


Mary,

This topic is better handled over at /. than here. (http://slashdot.org).
RedHat should have communicated more effectively that they are indeed still supporting both Libre and Gratis software (read: free as in speech, free as in beer).
For now, I'll sit on RH8.0 for Oracle 9i R2 development and with RH AS 2.1 for production. But SuSE gets another look - deservingly so.

Paul


Mary Ruiz [EMAIL PROTECTED] wrote:
?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / 

Red Hat To Drop Free Linux Products In Favor Of Enterprise

The company is offering users two upgrade paths, either to the stable Enterprise Linux product or to its developer-oriented Fedora Project, which is a free download.

http://www.computerworld.com/newsletter/0,4902,86827,00.html?nlid=AM



-Original Message-
From: Paul Drake [mailto:[EMAIL PROTECTED] 
Sent: ?xml:namespace prefix = st1 ns = urn:schemas-microsoft-com:office:smarttags /Tuesday, November 04, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: redhat/oracle

Debian.
http://www.debian.org/social_contract


Thater, William [EMAIL PROTECTED] wrote:
Joe Testa scribbled on the wall in glitter crayon:

 And now novell is eating up Suse, http://www.slashdot.org 8:45A
 today. 
 
 joe

so now that Linux has made it are we going to have a Linux provider melt
down? with no open source/free versions left?

--
Bill Shrek Thater ORACLE DBA 
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

Software is best understood as a branch of movie making. - Ted Nelson
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
INET: [EMAIL PROTECTED]



Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

PL/SQL - can't accept user input - then how?

2003-11-04 Thread Saira Somani-Mendelin

List,

Please forgive the repetitious nature of this query, but I haven't yet
found an answer that satisfied me.

Environment: AIX 5.1 Oracle 8.1.7

Trying to create an SQL script which calls a procedure to update a
record based on information provided by the user via a screen prompt. I
know PL/SQL is not interactive by nature. 

I have tried the ACCEPT command in the .sql script before the procedure
call, which is wrapped in a shell script but it doesn't wait for my
input, just carries on executing the rest of the .sql script.

I am now thoroughly confused about how to do this. And I doubt I am the
only one. I do need the user to provide me with a parameter so I can
locate the record for update.

Don't hesitate to tell me to RTFM or book or website, just tell me WHICH
ONE(S) to read :)

Thanks much,
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 WHERE clause order

2003-11-04 Thread Wolfgang Breitling

Why do you want a certain predicate evaluated first?

At 02:34 PM 11/4/2003, you wrote:
Hi,
   In a SQL statement I want a certain where clause to be done first. Is 
it enough to list it first as follows or do I (and can I) do something 
else to make it get checked first before other WHERE/AND clause are 
looked at. Thanks :

SELECT emp_id FROM emp
WHERE select_sen_emp_chk_first = 'Y'
AND  dept = :dept
AND  salary  :min_sal
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: Re: explain plan conundrum

2003-11-04 Thread Henry Poras

First I would take a look at the papers posted at Wolfgang Breitling's site
http://www.centrexcc.com/ Next, try and compare the number of rows the
optimizer expects to bring back at each step (cardinality as seen in explain
plan), to the actual number returned (rows as seen in sql_trace=true --
tkprof; or manually do each part of the query, but be careful because of the
filtering). Focus in on a discrepency between these two methods. That is
where the optimizer is being fooled. It might be because of bad statistics,
skewed data, init.ora settings, ...

Henry


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L


everything is analyzed. For all indexes, for all indexed columns.

I used analyze. its the same as dbms_stats, just not as robust. I use it
when I dont feel like typing out dbms_stats.

Are there optimizer parameters that help the optimizer determine join order?
Ive never had to use the 'ordered' hint on the CBO before when everything is
analyzed. The difference was huge. Ran for 2 hours and still going, with the
hint ran in 45 seconds.

im assuming there are some init.ora parameters that I should check out? Does
oracle take into account 'distinctness' of the columns being joined?
I have 1 table with 366,000 rows and another with 5,000 rows. the columns
being joined have 4 distinct values each. However, the table with 366,000
rows joins on its primary key to another table and that filters out enough
rows that that join should go first. The optimizer made a bad decision.

how do i analyze why it made a bad join order decision? hints like this are
a stop gap fix.

 From: Yong Huang [EMAIL PROTECTED]
 Date: 2003/11/04 Tue PM 02:09:30 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: explain plan conundrum

 Hi, Ryan,

 Where's the 20 billion rows? There's 1 G rows and 20 G bytes.

 What are the values of NUM_ROWS in xxx_INDEXES for PK1 and xxx_TABLES for
 TABLE2? Did you analyze using ANALYZE command or DBMS_STATS?

 Yong Huang

 --- [EMAIL PROTECTED] wrote:
  I cant sql trace it now. I hae run statspack. this query is running now
and I
  dont want to run another copy with a trace on until this finishes, since
I
  dont want to suck up resources. Im at a loss as to where the 20 billion
rows
  comes from in this explain plan? Everything including the indexes are
  analyzed.
 
  when the two tables involved have 36k and 5k rows involved.
  looks like some form of cartesian join, but its not showing up in the
plan.
  The two tables are joined by a column.
 
  any place to look on this? I know I need the 10046 trace, but I cant get
that
  yet and it make take 12 hours to get it after this runs.
 
  select col1,
 col2,
 col3
  from tab1
   tab2
  where tab1.col1 = tab2.col2;
 
 
  Operation   Object Name RowsBytes   CostObject Node In/Out  PStart 
   PStop
 
  SELECT STATEMENT Optimizer Mode=CHOOSE  1 G 237
HASH JOIN 1 G 20G 237
  INDEX FAST FULL SCANPK1 5 K 11 K3
  TABLE ACCESS FULL   TABLE2  366 K   4 M 231

 __
 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).


--
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  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

RE: redhat/oracle

2003-11-04 Thread Paul Drake

Jared,

Try browsing at +3, or set it to sort highest first.
You'll lose the ascii art that slips by the lameness filters, but see the stuff that matters.

Paul[EMAIL PROTECTED] wrote:
This topic is better handled over at /. than here True enough in the general sense, though I don't necessarily think it off topic here, as many of us use it to run Oracle. And there is usually far too much garbage as /. to get involved in the discussions, at least IMO. Jared

Paul Drake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]
11/04/2003 01:19 PM Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: redhat/oracleMary, This topic is better handled over at /. than here. (http://slashdot.org). RedHat should have communicated more effectively that they are indeed still supporting both Libre and Gr!
atis
software (read: free as in speech, free as in beer). For now, I'll sit on RH8.0 for Oracle 9i R2 development and with RH AS 2.1 for production. But SuSE gets another look - deservingly so. Paul Mary Ruiz [EMAIL PROTECTED] wrote: ?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /

Red Hat To Drop Free Linux Products In Favor Of Enterprise

The company is offering users two upgrade paths, either to the stable Enterprise Linux product or to its developer-oriented Fedora Project, which is a free download.

http://www.computerworld.com/newsletter/0,4902,86827,00.html?nlid=AM

-Original Message-From: Paul Drake [mailto:[EMAIL PROTECTED] Sent: ?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /Tuesday, November 04, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: redhat/oracle

Debian.
http://www.debian.org/social_contract

"Thater, William" [EMAIL PROTECTED] wrote: Joe Testa scribbled on the wall in glitter crayon: And now novell is eating up Suse, http://www.slashdot.org 8:45A today. joeso now that Linux has "made it" are we going to have a Linux provider meltdown? with no open source/free versions left?--Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song[EMAIL PROTECTED]Software is best understood as a branch of movie making. - Ted Nelson-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Thater, WilliamINET: [EMAIL PROTECTED]

Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard

Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

Re: ** SQL WHERE clause order

2003-11-04 Thread Stephane Faroult

A Joshi wrote:
 
 Hi,
In a SQL statement I want a certain where clause to be done first. Is it enough 
 to list it first as follows or do I (and can I) do something else to make it get 
 checked first before other WHERE/AND clause are looked at. Thanks :
 
 SELECT emp_id FROM emp
 WHERE select_sen_emp_chk_first = 'Y'
 AND  dept = :dept
 AND  salary  :min_sal

JUMPING AROUND
  What are you doing ? Firstly the answer to your question is a
resounding NO, and secondly your approach is totally illogical. I fear
something like 'one of the other conditions forces a to_number() which
fails if I haven't checked beforehand that I am dealing with a number'
or something as ghastly. If this is really what you have in mind, you
can very easily with decode() have a condition which depends on the
contents of another column. Never, ever depend on order.
  Now if your only concern is to force the optimizer to use one specific
index, you can put an hint or the old dept+0 = :dept trick.

 But I fear you are on a slippery slope.
/JUMPING AROUND 
-- 
Regards,

Stephane Faroult
Oriole Software
-- 
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 WHERE clause order

2003-11-04 Thread A Joshi

Wolfgang,
 I want it (select_sen_emp_chk_first) evaluated first because it is a prog (PL/SQL) variable. I assume it would be faster than others. Since : It does not have to go to table data to evaluate that like it would have to for dept or salary. Thank YouWolfgang Breitling [EMAIL PROTECTED] wrote:
Why do you want a certain predicate evaluated first?At 02:34 PM 11/4/2003, you wrote:Hi, In a SQL statement I want a certain where clause to be done first. Is  it enough to list it first as follows or do I (and can I) do something  else to make it get checked first before other WHERE/AND clause are  looked at. Thanks :SELECT emp_id FROM empWHERE select_sen_emp_chk_first = 'Y'AND dept = :deptAND salary  :min_salWolfgang BreitlingOracle7, 8, 8i, 9i OCP DBACentrex Consulting Corporationhttp://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wolfgang BreitlingINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list an!
d web
 hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

RE: PL/SQL - can't accept user input - then how?

2003-11-04 Thread Stephen . Lee


If you already have shell script front end, would it be acceptable to prompt
for the input in the shell script rather than in the procedure?

#!/bin/ksh

echo ENTER LOGIN
read USER

echo ENTER PASSWORD
stty -echo
read PASS
stty echo

echo ENTER WHAT IT IS
read INPUT

sqlplus -s -XXX
   ${USER}/${PASS}
   exec THE_PROCEDURE('$INPUT')
XXX

 -Original Message-
 
 List,
 
 Please forgive the repetitious nature of this query, but I haven't yet
 found an answer that satisfied me.
 
 Environment: AIX 5.1 Oracle 8.1.7
 
 Trying to create an SQL script which calls a procedure to update a
 record based on information provided by the user via a screen 
 prompt. I
 know PL/SQL is not interactive by nature. 
 
 I have tried the ACCEPT command in the .sql script before the 
 procedure
 call, which is wrapped in a shell script but it doesn't wait for my
 input, just carries on executing the rest of the .sql script.
 
 I am now thoroughly confused about how to do this. And I 
 doubt I am the
 only one. I do need the user to provide me with a parameter so I can
 locate the record for update.
 
 Don't hesitate to tell me to RTFM or book or website, just 
 tell me WHICH
 ONE(S) to read :)
 
 Thanks much,
 Saira
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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 WHERE clause order

2003-11-04 Thread A Joshi

Stephane,
   Here is my SQL :
 
SELECT emp_id FROM emp
WHERE :select_sen_emp_chk_first = 'Y'
AND  dept = :dept
AND  salary  :min_sal

Re: ** SQL WHERE clause order

2003-11-04 Thread Yong Huang

Hi, Joshi,

The only hint that may affect the evaluation order in the WHERE clause is
ORDERED_PREDICATES. But I don't know who actually got it to work. The chapter
Optimizer Hints in Performance Tuning Guide talks about it. It also says if
you don't have this hint, there's a certain order in which Oracle evaluates
predicates in the WHERE clause. Not sure if that's true. You can try switching
the predicates around and look at the execution plan for each.

Documentation is wrong in saying that you should be put that hint in the WHERE
clause.

Yong Huang

--- A Joshi [EMAIL PROTECTED] wrote:
 Hi,
In a SQL statement I want a certain where clause to be done first. Is it
 enough to list it first as follows or do I (and can I) do something else to
 make it get checked first before other WHERE/AND clause are looked at. Thanks
 :
  
 SELECT emp_id FROM emp
 WHERE select_sen_emp_chk_first = 'Y'
 AND  dept = :dept
 AND  salary  :min_sal


__
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: 10g new features

Exactly, until the doc is in google's cache, you
still can get the HTML version.
I thought that anyone keen enough to have this doc
would figure it out :)

Tanel.

- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L

Sent: Tuesday, November 04, 2003 10:49
PM
Subject: Re: 10g new features
The link is dead.
:( But thanks to the
googlecache effect, you can still see the doc: http://216.239.57.104/search?q=cache:UVsNMDV-OBIJ:www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf+Oracle10g_New_Features.pdfhl=enie=UTF-8
Jared

"Tanel Poder" [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 12:04 PM
Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] cc:

Subject:Re: 10g new
featuresBtw,
bold guys from Polish Oracle User Group have put out Oracle's 10g New Features
beta documentation at their website... http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf
I already sent a notification to PLOUG to remove this doc immediately,
because I'm affiliated with European Oracle User Group myself and would not
like if PLOUG would get into trouble. But anyway, take the most out
of this URL, it might not last for long ;) Tanel.
- Original Message -
From: Jamadagni, Rajendra To: Multiple recipients of list
ORACLE-L Sent: Tuesday, November 04, 2003 8:04
PM Subject: RE: 10g new
features Oh My
... 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-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, November 04, 2003
12:25 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: 10g new featuresOK KG, the
cat is out of the bag. Now you have to tell all of us. Especially
Raj. :) Jared
**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

PCTFREE and PCTUSED

2003-11-04 Thread Maryann Atkinson

Suppose I have the following settings which happen to be
the defaults as well:
PCTFREE 10
PCTUSED 40
I am trying to figure out what PCTUSED is really used for.
My book is telling me that is used so that Oracle knows
whether to keep a block in the free-list.
My point is this: If PCTFREE is 10%, that means the block can be
up to 90% full, right?
Well, if the block happens to be 60% full at the moment, then Oracle
knows that this block is not full enough because 60 is less than 90,
so it can keep it in the free list. I dont see what PCTUSED is needed,
it kind of seems I can accomplish the same with just one parm,
that being PCTFREE.
But Oracle wouldnt have just put a parm there without any usage,
so I guess there's something I dont see...
Any ideas/examples? Any good reasoning anywhere?

Thanks,
maa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maryann Atkinson
 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: PL/SQL - can't accept user input - then how?


This should get you started

HTH

Jared



SQLPATH=''
USER_INPUT=''

while [ -z $USER_INPUT ]
do

echo Please enter a table owner:
read USER_INPUT

done


echo $USER_INPUT


sqlplus /nolog EOF
set echo on
connect scott/tiger
select table_name
from all_tables
where owner = upper('$USER_INPUT');
EOF







Saira Somani-Mendelin [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 01:49 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:PL/SQL - can't accept user input - then how?


List,

Please forgive the repetitious nature of this query, but I haven't yet
found an answer that satisfied me.

Environment: AIX 5.1 Oracle 8.1.7

Trying to create an SQL script which calls a procedure to update a
record based on information provided by the user via a screen prompt. I
know PL/SQL is not interactive by nature. 

I have tried the ACCEPT command in the .sql script before the procedure
call, which is wrapped in a shell script but it doesn't wait for my
input, just carries on executing the rest of the .sql script.

I am now thoroughly confused about how to do this. And I doubt I am the
only one. I do need the user to provide me with a parameter so I can
locate the record for update.

Don't hesitate to tell me to RTFM or book or website, just tell me WHICH
ONE(S) to read :)

Thanks much,
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: 10g new features


... and now printed and nicely bound. :)







Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/04/2003 02:59 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: 10g new features


Exactly, until the doc is in google's cache, you still can get the HTML version. 
I thought that anyone keen enough to have this doc would figure it out :)

Tanel.

- Original Message - 
From: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L 
Sent: Tuesday, November 04, 2003 10:49 PM
Subject: Re: 10g new features


The link is dead. :( 

But thanks to the googlecache effect, you can still see the doc: 

http://216.239.57.104/search?q=cache:UVsNMDV-OBIJ:www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf+Oracle10g_New_Features.pdfhl=enie=UTF-8 

Jared 







Tanel Poder [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 
11/04/2003 12:04 PM 
 Please respond to ORACLE-L 

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
cc: 
Subject:Re: 10g new features



Btw, bold guys from Polish Oracle User Group have put out Oracle's 10g New Features beta documentation at their website... 
 
http://www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf 
 
I already sent a notification to PLOUG to remove this doc immediately, because I'm affiliated with European Oracle User Group myself and would not like if PLOUG would get into trouble. 
 
But anyway, take the most out of this URL, it might not last for long ;) 
 
Tanel. 
 
- Original Message - 
From: Jamadagni, Rajendra 
To: Multiple recipients of list ORACLE-L 
Sent: Tuesday, November 04, 2003 8:04 PM 
Subject: RE: 10g new features 

Oh My ... 
 
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-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: 10g new features


OK KG, the cat is out of the bag. 
Now you have to tell all of us. Especially Raj. :) 
Jared 


**
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

RE: redhat/oracle

2003-11-04 Thread Orr, Steve

Ditto. (But what about OS X? :)

Got Oracle9.2 server and client running on my RH9 desktop. Found the
following link somewhat informative even though there are some
weirdities:
http://www.oreillynet.com/lpt/a/4141

Got the RH9 desktop machine a couple of weeks ago but am still
struggling to get free of windoze. My desktop only boots redhat but my
other computer is a windoze laptop with windoze and redhat 7.2 running
under VMWare and I've found it to be too much of a hassle. VMWare is
great but the memory requirements for a dual O/S machine, the associated
complexities and general slowness were sometimes painful. With the
Linux-only machine I haven't missed the MSOffice stuff much. 

I use the Ximian Evolution interface to MS Exchange. The problems are:
MS Outlook rules are only processed when the Outlook client is running;
getting calendars; and company distribution lists in Evolution. Because
of this I'm still using the laptop just for MS Outlook. I think there's
a way to get it to work but haven't gotten to it yet since the
futz-factor quotient is up with all this stuff and I have real work that
keeps interrupting me. :-)

So right now my recommendation to damagement is that all IT employees
should have at least 2 or 3 desktop/laptop computers to do their daily
work on. 


Steve


-Original Message-
Sent: Tuesday, November 04, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


As far as I'm concerned, it has already made it. It's my primary desktop
at 
work,with windows for those pesky apps that only run there. I guess I
just like 
a more robust, unix-like os when I have to work on other unix systems
all day. ;).

The free version of redhat is now called the fedora project. This will
continue 
to be the experimental/desktop version that is along the same line as
redhat 8  9

-Brian

Boivin, Patrice J wrote:
 I am still curious to see when linux will make it on the desktop, 
 despite the hype now we know that Red Hat is dropping that initiative.
 
 Patrice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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: PCTFREE and PCTUSED

2003-11-04 Thread Tim Fleury

PCTUSED comes into play when rows are deleted from the block.  If enough
data is deleted from a block to cause the block to fall below 60% used
(PCTUSED), the block goes back on the freelist for subsequent
inserts/updates.

-Original Message-
Sent: Tuesday, November 04, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L


Suppose I have the following settings which happen to be
the defaults as well:

PCTFREE 10
PCTUSED 40


I am trying to figure out what PCTUSED is really used for.
My book is telling me that is used so that Oracle knows
whether to keep a block in the free-list.

My point is this: If PCTFREE is 10%, that means the block can be up to
90% full, right?

Well, if the block happens to be 60% full at the moment, then Oracle
knows that this block is not full enough because 60 is less than 90, so
it can keep it in the free list. I dont see what PCTUSED is needed, it
kind of seems I can accomplish the same with just one parm, that being
PCTFREE.

But Oracle wouldnt have just put a parm there without any usage, so I
guess there's something I dont see...

Any ideas/examples? Any good reasoning anywhere?

Thanks,
maa

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maryann Atkinson
  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: Tim Fleury
  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: PCTFREE and PCTUSED