Metalink on the blink

[Adams, Matthew (GECP, MABG, 088130)]

Title: Metalink on the blink





Is anyone else having problems with Metalink this morning
or is it just us?  We can't log in at all.


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
"The swim only hurt once - from the beginning
to the end" - Doc Counsilman on swimming the
English Channel at age 58

RE: rebuilding indexes - sure to cause a ruckus

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: rebuilding indexes - sure to cause a ruckus





My brother (the NASA rocket scientist) usually 
says something like 


' "Hey, this is all quite easy, it sure ain't raising kids"


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Their fundamental design flaws are completely
hidden by their superficial design flaws.
  - Douglas Adams


-Original Message-
From: Richard Foote [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 10, 2003 5:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: rebuilding indexes - sure to cause a ruckus



Hi Yong,


One thing I should have mentioned when I posted my "epic" is that it not
only attempts to correct the numerous technical errors in the article but
also attempts to answer the various questions the article raises but totally
fails to address. What I find most astonishing about the article is that the
author confesses at the conclusion he has no idea when and why an index
rebuild is beneficial. And as the author doesn't know, then surely it must
all be so difficult, a "scientific-less phenomenon".


If I can convince anyone who makes it through my email that this isn't
rocket science, then it's been worth the bandwidth.


BTW, does anyone know what a rocket scientist refers to when they say "Hey,
this is all quite easy, it sure ain't ?" ?


Cheers ;)


Richard


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 10, 2003 5:44 AM



> Thanks, Richard. I'll read your long message more carefully later. I like
your
> statement that rebuilding an index or not is not rocket science. One needs
to
> measure the performance before and after the rebuild and make a conclusion
> himself. Many times we discuss performance issues and get very technical
and
> sophisticated, without showing experimental results! Having been a science
> researcher before, I'd like to emphasize that facts speak louder than
theories.
> There may be 10,000 24x7 databases in the world that don't easily allow
even
> testing an index rebuild. But there may be 100 times more production
databases
> in the world that are not 24x7. The individual DBA needs to do his control
> study and conclude, using experts' opinions as reference.
>
> Yong Huang
>
>
>
> __
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
> --
> 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: Richard Foote
  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: background process "LGWR" did not start

[Adams, Matthew (GECP, MABG, 088130)]

also 
'sysresv'  will show which shared memory segments 
and 
semaphore sets belong to an instance.
 
Matt Adams - GE Appliances - 
[EMAIL PROTECTED]Their fundamental design flaws are 
completelyhidden by their superficial design 
flaws.  - Douglas 
Adams 
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Friday, December 05, 2003 11:49 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
background process "LGWR" did not startIn regards to Bambi's comments about having a single 
instance on the server, this situation 
gets more complex if you have several instances on a server. 
There's also the possibility that the 
instance(s) shared memory is in more than one segment. You can use 
ipcs and oradebug to decipher which memory segments belong to which instance.  Google for ipcs and oradebug, 
several helpful references showed up 
when I tried it. HTH 
Jared 

  
  

"Bellow, Bambi" 
  <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
   12/05/2003 08:34 AM  Please 
  respond to ORACLE-L 
                To:     
     Multiple recipients of list ORACLE-L 
  <[EMAIL PROTECTED]>         cc:         
          Subject: 
         RE: background process "LGWR" did not 
  startHi 
John!When I've run into this problem it was because there was a memory 
segmentbeing forced open.  If you have the same issue, I can hep. 
 First, assumingthat you're on Unix (if you're not, please ignore the 
rest of this email andjust have a lovely day), and that your database is 
down (otherwise, if youwanted to do a shutdown abort, that wouldn't be such 
a bad thing), you cando an ipcs -mAIf that was the only 
instance on your box, the rest is pretty easy, cuz theoffending segment is 
the only one owned by oracle in the list.  If itwasn't, and there are 
other oracle segments on the box, you have to find outwhich one is your guy. 
 The memory segments associated with a particularinstance should have 
very similar (but not exactly the same) CTIMEs.  Ifthere is one way out 
of whack, that's your guy.  Now, this is where mymemory gets a little 
fuzzy (age, doncha know?)... if the instances startedup at nearly exactly 
the same time for some reason, you are looking for a"0" in the  segsz(?) column (anybody remember fersher onthis one?). 
 By now, you should know which memory segment to kill.  To 
kill the offending memory segment, do an ipcrm -m 
on it.  You, of course, want to be exceedingly 
careful here, and just assumethat all the usual disclaimers apply.  If 
you kill the wrong segment, yourother database is not going to be very happy 
about it.But assuming you killed the right segment, your database with 
the LGWRproblem should be well and truly down.  Bring 'er on up and the 
LGWR processshould come up just fine.Bambi.-Original 
Message-Sent: Thursday, December 04, 2003 8:34 AMTo: Multiple 
recipients of list ORACLE-LAnyone know what might be causing this 
error? Oracle 8.1.7 on Solaris.background process "LGWR" did not 
start-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.net-- Author: John Dunn INET: 
[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).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.net-- Author: Bellow, Bambi INET: 
[EMAIL PROTECTED]Fat City Network Services    -- 
858-538-5051 http://www.fatcity.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: decrease initial extent

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: decrease initial extent





Mladen,


Keep reading, it's further down.



From the 8.1.7 SQL Reference Manual, under the ALTER TABLE entry
(top of page 8-36):


"If you specify KEEP, then the specified amount of space is kept
and the remaining space is freed. When the remaining
number of extents is less than MINEXTENTS, then
MINEXTENTS is adjusted to the new number of extents. If the
initial extent becomes smaller than INITIAL, then INITIAL
is adjusted to the new size."





Matt Adams - GE Appliances - [EMAIL PROTECTED]
Their fundamental design flaws are completely
hidden by their superficial design flaws.
  - Douglas Adams


-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 03, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: decrease initial extent



I don't understand. Here is what manual says:


deallocate_unused_clause


Use the deallocate_unused_clause to explicitly deallocate unused space at the end of the table,
partition or subpartition, overflow data segment, LOB data segment, or LOB index and make the 
space available for other segments in the tablespace.


It's not supposed to change the characteristics of the initial extent. Funny. I'll test it
at home.



On 12/03/2003 04:44:27 PM, [EMAIL PROTECTED] wrote:
> Since I agreed with Mladen that it wouldn't work, I just had to test this.
>  
> On 8.1.7.3 on OpenVMS the "deallocate unused keep # " shrinks the initial
> extent.
> It shrank a test table from  1m to 8k.  I'm not sure why it chose 8k.
> (db_block_size=4k, default initial_extent for the tablespace=64k)
>  
> I assume it would work on SYS tables as well.
> (No sacrificial database that I'm willing to try it on.)
>  
> Nelson
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 03, 2003 4:09 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> If you use "keep " it will. 
> 
> Alex. 
> 
> 
> -Original Message- 
>  ] 
> Sent: Wednesday, December 03, 2003 12:59 PM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> That will not do anything for the initial extent. 
> You may try with 
> 
> alter table  pray intensely for the desired change; 
> 
> 
> On 12/03/2003 03:34:25 PM, [EMAIL PROTECTED] wrote: 
> > alter table  deallocate unused keep 1; 
> > 
> > Alex. 
> > 
> > 
> > -Original Message- 
> > Sent: Wednesday, December 03, 2003 10:09 AM 
> > To: Multiple recipients of list ORACLE-L 
> > 
> > 
> > Is there any way to decrease the initial extent allocated to a table. 
> > It is one of the system tables, so I do not want to drop and recreate 
> > it. I can not export/import as it appear in noexp$. It has long field 
> > so I can not do alter table move. 
> > 
> > Yechiel Adar 
> > Mehish 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>   
> > -- 
> > Author: Yechiel Adar 
> >   INET: [EMAIL PROTECTED] 
> > 
> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
>   
> > San Diego, California    -- Mailing list and web hosting services 
> > - 
> > To REMOVE yourself from this mailing list, send an E-Mail message 
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the 
> > name of mailing list you want to be removed from).  You may also send 
> > the HELP command for other information (like subscribing). 
> > 
> 
> Mladen Gogala 
> Oracle DBA 
> 
> 
> 
> Note: 
> This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistransmission.  If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify the
> sender.  You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> right to monitor all e-mail communications through its networks. Any views
> expressed in this message are those of the individual sender, except where
> the message states otherwise and the sender is authorized to state them to
> be the views of any such entity.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>   
> -- 
> Author: Mladen Gogala 
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
>   
> San Diego, California    -- Mailing list and web hosting services 
> - 
> To REMOVE yourself from this mailing list, send an E-Mail message 
> to: [EMAIL 

RE: db version control - schemas, code

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: db version control - schemas, code



I 
forgot to add to this message, I have requested permission 
to
forward this presentation to 
others.
 
Matt
 
Matt Adams - GE Appliances - 
[EMAIL PROTECTED]We have enough youth.How about a fountain of 
intelligence? 
 
-Original Message-From: Adams, Matthew (GECP, MABG, 
088130) Sent: Thursday, October 16, 2003 3:04 PMTo: 
Multiple recipients of list ORACLE-LSubject: RE: db version control - 
schemas, code
there was an excellent presentation by Mark Stock at 
SEOUC 2002 called 
Tag! Whose Code is it? 
about embedding versioning inside of Oracle objects. 
I'm reluctant to send it without getting approval from 
the copyright holder, but the authors e-mail 
address is  [EMAIL PROTECTED] 
 Matt Adams - GE Appliances - 
[EMAIL PROTECTED] We have enough youth. 
How about a fountain of intelligence? 
-Original Message- From: Yosi 
Greenfield [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 16, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: 
db version control - schemas, code 
Hi All, 
Client would like me to propose a solution for managing 
schemas and code in their databases. There are several 
developers, each making changes to their own schema, and 
then there's test, qa, and production. 
There are both schema changes and code changes. Mostly 
schema changes though. 
Client would like software (scripts and/or packaged sw) 
AND a methodology. I've looked at the specs for Oracle 
Change Manager. Any experiences with that? 
Can anyone recommend a methodology and/or sw for this? 
Or articles/books? 
Thanks, 
Yosi 
-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.net 
-- Author: Yosi Greenfield 
  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: db version control - schemas, code

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: db version control - schemas, code





there was an excellent presentation by Mark Stock at
SEOUC 2002 called


Tag! Whose Code is it?


about embedding versioning inside of Oracle objects.


I'm reluctant to send it without getting approval from 
the copyright holder, but the authors e-mail
address is  [EMAIL PROTECTED]



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: Yosi Greenfield [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 16, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L
Subject: db version control - schemas, code



Hi All,


Client would like me to propose a solution for managing
schemas and code in their databases. There are several
developers, each making changes to their own schema, and
then there's test, qa, and production.


There are both schema changes and code changes. Mostly
schema changes though.


Client would like software (scripts and/or packaged sw)
AND a methodology. I've looked at the specs for Oracle
Change Manager. Any experiences with that?


Can anyone recommend a methodology and/or sw for this?
Or articles/books? 


Thanks,


Yosi


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yosi Greenfield
  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: Opinions sought on possible TOAD replacement

[Adams, Matthew (GECP, MABG, 088130)]

Have 
you looked at Toolkit for Oracle (TOra)?
 
http://sourceforge.net/projects/tora/
 
I've 
heard rather good things about it.
 
Matt
 
Matt Adams - GE Appliances - 
[EMAIL PROTECTED]We have enough youth.How about a fountain of 
intelligence? 
 
-Original Message-From: Paul Vincent 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 
11:59 AMTo: Multiple recipients of list ORACLE-LSubject: 
Opinions sought on possible TOAD replacement
Management have been grumbling about the cost of TOAD Professional 
licenses, and have been "recommended" a cheaper product called PL/SQL Developer 
by Allround Automations (available from Inthink Corporation at $150 a pop). Now, 
I've been to the product website, and read up on all its features, and it 
basically looks like a nice enough product, but aimed squarely at PL/SQL 
developers, rather than including all the DBA-oriented goodies we find in TOAD. 
My first reaction is to respond by saying "fine, give it to the developers to 
replace their copies of TOAD, if they find it adequate for development, but it's 
not a DBA tool, so I'll keep my TOAD Xpert with DBA module, thanks very 
much!".
 
But if 
anyone on the list has tried both products, I'd be interested to know what you 
think. Is it as usable as TOAD Professional for developers? Does it have hidden 
charms which would make it a suitable replacement for DBA use? How responsive 
are the product developers to requests for enhancements? Any input is very 
welcome!
 
Paul 
Vincent
DBA
University of Central England

RE: I know its early since OOW is just over BUT

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: I know its early since OOW is just over BUT





As of now, I'm planning on going, but as always,
that is subject to the whims of Damagement.


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All Targets Met. All Systems Working.
All Customers Satisfied. All Staff Enthusiastic. 
All Pigs Fed And Ready To Fly.


-Original Message-
From: Joe Testa [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 15, 2003 4:49 PM
To: Multiple recipients of list ORACLE-L
Subject: I know its early since OOW is just over BUT



Is anyone planning on going to IOUG conference in Toronto, CA, next 
spring(2004)???


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

8.1.7 + redhat AS 2.1 = trouble

[Adams, Matthew (GECP, MABG, 088130)]

Title: 8.1.7 + redhat AS 2.1 =  trouble





Are there know binutils or other issues when installing
8.1.7 on redhat AS 2.1?  


Attempts to run genclntsh keep
getting undefined references in  libc.so.6?


I can't find anything on Metalink or google about
running AS 2.1 and 8.1.7 together.


Matt





Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All Targets Met. All Systems Working.
All Customers Satisfied. All Staff Enthusiastic. 
All Pigs Fed And Ready To Fly.

RE: Oracle World anyone?

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Oracle World anyone?





I'll be there.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We are pentium of Intel. Division is futile.
You will be approximated.


-Original Message-
From: Steve McClure [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 14, 2003 9:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle World anyone?



Just completed the registration, and was wondering how much company I was
going to have there.
Who else has plans to attend?



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve McClure
  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: 100 instances on same server !!!

[Adams, Matthew (GECP, MABG, 088130)]

Right now I have 37 instances on an hp-ux 
server,
a mix of 8.1.7.4 and 9.2.0.3
 
Matt Adams - GE Appliances - [EMAIL PROTECTED]We are pentium 
of Intel. Division is futile.You will be approximated. 
 
-Original 
Message-From: Dilip Patel 
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 6:54 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 100 
instances on same server !!!

Thanks for the replies so far. Considering the fact that my database is 
tiny ( just around 3 GB ), How many of them can work on same server? I can just 
test with 5 instances, with limited hardware. Will the CPUs be able to take load 
of 100 instances? Is it worth experimenting this? 
 
I am on 8.1.7.4 and the application is already built. I stand no chance of 
changing the code. That is why using individual schemas for individual users is 
not an option. Right now I am just asked if 100 instances can run on same server 
and I don’t have solid answer. 
 
Just on side note, can I ask, What is the maximum number of instances 
anyone has ever worked/heard being installed with in same server? 
 
Thanks again.
 
Dilip.

  - Original Message - 
  From: AK 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, August 07, 2003 11:54 
  AM
  Subject: Re: What books recommended for 
  Data Modeling ?
  100 instances woh .  If you are in 9i look at 
  possibilities like contextor label security . or creating another schema 
  .-ak- Original Message - To: "Multiple 
  recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: 
  Wednesday, August 06, 2003 9:24 PM> I have not heard installing 
  hundred database instances on same server.> Maybe you should think 
  creating one instance, and then hundred schemas in> it.>> 
  Guang>> On Wed, 6 Aug 2003, Dilip Patel wrote:>> 
  > Hi All,> > Need some suggestions/Input.> >> 
  > My application database is 8.1.7, NOARCHIVELOG, WIN200,> > 
  total size 4 GB, more of single user OLTP client-server application.> 
  >> > Now the customer wants to give training on this application 
  to hundredtrainees> > at a time. For this he wants to install 
  hundred database instances onsame> > server machine,  which 
  *each* will be accessed simultaneously from 100different> > 
  client workstations.> >> > The reasons for installing all 
  instances on same machine are> > - to avoid re-installing databases 
  on 100 workstations after each roundof> > training.> > 
  - No user should see any other user's data.> >> > Please 
  suggest if this approach is feasible or is it at all possible.Tested this 
  with upto 5 instances, and> > it seems to work. The customer is 
  willing to upgrade to any hardwareneeded for> > this 
  setup.> >> > Thanks in advance for your time.> 
  >> > Dilip.> >>> -- > Please see 
  the official ORACLE-L FAQ: http://www.orafaq.net> -- > 
  Author: Guang Mei>   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: AK  INET: [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: backwards export

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: backwards export







> I'm not sure of the export compatibility, but you should know that 9i 
> clients won't talk to a 7.3.4 database, 


  True


> and 7.3.4 clients won't talk to a 
> 9.2 database, 
  
 False


  A Oracle7 client can, will, and does talk to a 9.2.0 database 
with no problem.


> which could be a problem.  At least, they're not certified 
> to talk to each other, which isn't quite the same thing.


  See note 172179.1 on Metalink.  To quote:


"In short, any version of SQL*Net's version 2 Client (2.3.x) and 
up to Net 9.0.x, will be able to connect to any version of 
Oracle Database version 7.3.x and up to 9.2.x, with certain 
compatibility issues that are explained below"



Matt Adams

Matt Adams - GE Appliances - [EMAIL PROTECTED]
It will make sense when you stop thinking logically,
and start thinking Oracle-ly  -  Jim Droppa


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 23, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: backwards export



I'm not sure of the export compatibility, but you should know that 9i 
clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a 
9.2 database, which could be a problem.  At least, they're not certified 
to talk to each other, which isn't quite the same thing.


Cheers
Simon Anderson







Jeroen van Sluisdam <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
23/07/2003 12:49
Please respond to ORACLE-L


 
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
    Subject:    backwards export



Hi,
 
We are investigating possibilities for migration of an oracle 7.3.4 to 
oracle 9i. We want to separate our
production DB from the app-logic such that we can migrate from oracle 
7.3.4 on hp-ux 10.20 to oracle 9i
on hp-ux 11. Problem is our development and test-environment because we 
cannot separate the logic at the
same time here also from the db (costs). Does anyone have any experience 
with exporting from oracle 9i 
to oracle 7.3.4 ? 
 
I found the underlying note on metalink about the same problem but with 
oracle 8. I have limited experience on oracle8
and none on oracle 9. So I hope you can give some tips.
..
You need to run the 7.3 version of export against your 8.0 database via 
sqlnet/net8. Beforehand, you need to run rdbms/admin/catexp7.sql against 
your 8.0 database. This creates the 7.3 export views required. Note that 
if you have used any 8.0 specific features (e.g. objects) these will not 
be exported for obvious reasons. 

 
Tia,
 
Jeroen



-- 
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: dba age

[Adams, Matthew (GECP, MABG, 088130)]

For an apricot, I am old. For a head of lettuce, even more 
so.
But for a mountain I am not even 
begun in years. 
However, for a man I am just right. 

Matt Adams - GE Appliances - 
[EMAIL PROTECTED]It will make sense when you stop thinking 
logically,and start thinking Oracle-ly  -  Jim Droppa 
 
-Original Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 12:09 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: dba 
age
Now 
that's a LOADED question which I'm sure many a individual on this list will 
resist answering.
 
Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 11:55 
  AMTo: Multiple recipients of list ORACLE-LSubject: dba 
  age
  Now this one is difficult folks .
   
  what is average age of an experienced oracle dba 
  ?
   
  -ak

oracle10g

[Adams, Matthew (GECP, MABG, 088130)]

Gotta love 
oracle.
 
It won't be 10i, it'll 
be Oracle10g
 
what on earth are they 
thinking?
 
http://www.oracle.com/oracleworld/paris/conference/

RE: failed to archive

[Adams, Matthew (GECP, MABG, 088130)]

It's 
due to Oracle using multiple archivers.
For 
every one that fails,  you will find an 
another ARCX process that was already 
working
on 
it.
 
Using 
sequence number 87568 from below as an
example, grep for that number in the alert log and see 

for 
yourself.
 
Matt
 
Matt Adams - GE Appliances - 
[EMAIL PROTECTED]"Doing linear scans over an associative array is 
liketrying to club someone to death with a loaded 
Uzi."    - Larry Wall (creator of Perl) 
 
-Original Message-From: AK 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 15, 2003 11:45 
AMTo: Multiple recipients of list ORACLE-LSubject: failed 
to archive
 
I see a lot of "failed to archive " messages in 
alert.log . But finally the log gets archived . Is it due overloaded archiver ? 

 
this is from alert log.
 
ARC0: Beginning to archive log# 3 seq# 
87568ARC0: Failed to archive log# 3 seq# 87568ARC0: Beginning to archive 
log# 2 seq# 87569Mon Jul 14 11:36:23 2003ARC4: Completed archiving log# 
3 seq# 87568
 
-ak 
 
ocp dba 8i
 

RE: Do Not Call

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Do Not Call





Turbo Pascal Database Toolbox


http://www.emsps.com/oldtools/borpasv.htm#tpdb



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All Targets Met. All Systems Working.
All Customers Satisfied. All Staff Enthusiastic. 
All Pigs Fed And Ready To Fly.


-Original Message-
From: Orr, Steve [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 01, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Do Not Call



There have been over 10,000,000 entries made in the National Do Not Call
Registry since Friday June 27. Does anyone know the database engine in
which this is stored? 



Curious in Bozeman, MT
-- 
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: copy a datafile to a raw device

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: copy a datafile to a raw device





It's been a number of years since I did anything with
raw devices, so this is all ancient and possibly 
out of date/incorrect.


I believe Stephen to be wrong.  The bits and bytes
written on the data file are identical, regardless of
whether the device is raw or cooked.  However, 
back in the day I worked with these, the file could not use
the first block of the raw device, as that was reserved for
operating system usage (and back then on those devices, this was
8K).  So, we had to do something like 


dd if=system of=/dev/raw obs=8192 seek=1


to force the dd to skip the first 8K.  


Since you have already overwritten the first block of the raw
device, you might have to drop it and re-create it.


Also, since the first 8K was reserved for the OS, the size of 
the raw device must be at LEAST the size of the datafile + 8K.


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.
All Targets Met. All Systems Working.
All Customers Satisfied. All Staff Enthusiastic. 
All Pigs Fed And Ready To Fly.


-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 19, 2003 4:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: copy a datafile to a raw device




Well heck.  Nobody else has replied, so I might take a stab at it here.  I
suspect that the format of the data (bits and bytes) required on a raw
device is different than the format of the data in a file in a file system.
I'm stretching a bit here, but I think an analogy would be what would happen
if you dd a file from UFS to NTFS.  The data on the NTFS might be a digital
copy of what was on UFS, but it's format is totally useless in the context
of NTFS.


> -Original Message-
> From: Gurelei [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 19, 2003 1:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: copy a datafile to a raw device
> 
> 
> hi all:
> 
> I need to move a SYSTEM datafile from a filesystem
> to a raw device. I have shutdown the database,
> copied the file via
> 
> dd if=system of=/dev/raw
> 
> renamed the file in the database, but couldn't open
> the database because of the error: Unknown File Header
> Version read for file number 1.
> 
> I tried another dd:
> 
> dd if=system of=/dev/raw obs=32768 (32K is the db
> block size), but I got the same error. Can anyone
> see what else could be wrong with my dd command
> 
> thanks
> 
> Gene
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Gurelei
>   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: Stephen Lee
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

median function

[Adams, Matthew (GECP, MABG, 088130)]

Title: median function





I'm attempting to write a query to calculate the median
of a column of numbers.


The first solution I came across was


Select avg(col1) MEDIAN from
( select rownum row1, col1 from a where col1 in (select col1 from a )) a
where a.row1 in ( select floor(count(*)/2 +.5) from a )
  or a.row1 in ( select ceil(count(*)/2+.5) from a )


This does too many FT scans (4) of table a, so I tried to write
a simpler version using the analytical functions.


I have gotten as far as


 SELECT col1
 FROM
 (
 SELECT col1
 , row_number() OVER (ORDER BY col1) AS r
 , CEIL(COUNT(col1) OVER () /2) m
 FROM a
 )
 WHERE r = m


However, this only works for an odd number of values.
IIRC, if an even number of values is present, the median
is defined as the average of the two middle-most numbers.


Before I spend much more time on this, has anybody already written
one ?



Matt Adams - GE Appliances - [EMAIL PROTECTED]
If carpenters built buildings the way programmers write 
programs, the first woodpecker to come along would destroy 
civilization. - author unknown

RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database





We did this in order to get a test db up in a new
environment that would eventually become production.
We knew that for the production cut over, it 
would be a cold backup/restore to a new server, so 
there was no risk in trying it.  


By causing a log switch immediately after taking the 
tablespaces out of backup mode, I am making sure 
that all transactions that have all transactions that
have hit the DB up until that point.


I have also used this technique to move/clone and 
upgrade 8.0.5 databases to 8.1.6 and 8.1.7 for 
testing environments and have never enountered any
problems.  I would NEVER NEVER NEVER (is that 
enough nevers?)  use this to generate a 
new production system.


I did not recover the database in 8.1.7 and
then upgrade because the 
destination machine did not have the 8.1.7 code installed
on it at that time.



Matt Adams - GE Consumer Products - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly.  
It's just particular about who it makes friends with.


-Original Message-
From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 25, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database




Courageous and it looks like it worked.  But this wouldn't be supported by 
Oracle.
Why did you have to go by time ? Why not recover until cancel and apply
all available archive logs ?  Ensure that your online redo logs with the last
few transactions are also archived out of the 8.1.7 environment and then
recover till the last archive.


I would apply all the archive logs in 8.1.7, recover the database in 8.1.7
and then upgrade it to 9.2.


Hemant
At 01:29 PM 24-03-03 -0800, you wrote:
>I did this a couple of weeks ago.  The answer is yes, but you recover
>first, then upgrade.
>
>You've got to
>
>0) Note the sequence number of the log file being written
>to in the source database before you start.
>1) put source in hot backup mode
>2) copy files to new destination
>3) take source out of backup mode
>4) NOTE the date/time
>5) 'alter system switch logfile' on the source
>6) copy all archived log files from the one
>    noted in the step 0 to the most recent (inclusive) to destination
>7) (optional) on source, do a 'alter database backup controlfile to trace'
>8) (optional) copy the trace file to destination
>9)  (optional) using the 9.2.0 executables, use trace file to re-create 
>control file, renaming database
>10) on destination do 'alter database recover automatic until time 'TIME 
>NOTED IN STEP 4'  using backup controlfile'
>  The 9.2.0 executables can read and understand log files from 8.1.7
>11) on destination do 'alter database open resetlogs'
>12)  On destination, perform steps for manual upgrade from 8.1.7 to 9.2.0
>13) Celebrate with a couple of truely great beers (i recommend Sierra 
>Nevada Celebration Ale)
>
>Good luck
>
>
>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>Contrary to popular opinion, Unix is user friendly.
>It's just particular about who it makes friends with.
>
>
>
>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>Contrary to popular opinion, Unix is user friendly.
>It's just particular about who it makes friends with.
>
>-Original Message-
>From: Nick Wagner [mailto:[EMAIL PROTECTED]]
>Sent: Monday, March 24, 2003 3:24 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Quick Question -- 8.1.7 logs applied to 9.2.0 database instance?
>
>Can I take a hot backup of an 8.1.7 instance...  and then upgrade the 
>backup to 9.2.0 (upgrading data dictionary tables and everything) and then 
>apply logs created by the 8.1.7 instance to this 9.2.0 backup?
>
>Please answer as soon as possible...
>
>Thanks!
>Nick Wagner
>
>

RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database instan

[Adams, Matthew (GECP, MABG, 088130)]

I did 
this a couple of weeks ago.  The 
answer is yes, but you recover
first, then 
upgrade.
 
You've got to 

 
0) 
Note the sequence number of the log file being written
to in 
the source database before you start.
1) put 
source in hot backup mode
2) 
copy files to new destination
3) 
take source out of backup mode
4) 
NOTE the date/time
5) 
'alter system switch logfile' on the source
6) 
copy all archived log files from the one
   noted in the step 0 to the most recent 
(inclusive) to destination
7) 
(optional) on source, do a 'alter database backup controlfile to 
trace'
8) 
(optional) copy the trace file to destination
9)  (optional) using the 9.2.0 executables, use 
trace file to re-create control file, renaming database 
10) on 
destination do 'alter database recover automatic until time 'TIME NOTED IN STEP 
4'  using backup controlfile'
 The 9.2.0 executables can read 
and understand log files from 8.1.7
11) on 
destination do 'alter database open resetlogs'
12)  On destination, perform steps for manual 
upgrade from 8.1.7 to 9.2.0
13) 
Celebrate with a couple of truely great beers (i recommend Sierra Nevada 
Celebration Ale)
 
Good 
luck
Matt Adams - GE 
Appliances - [EMAIL PROTECTED]Contrary to popular opinion, Unix is user 
friendly. It's just particular about who it makes friends with. 

 
Matt Adams - GE Appliances - 
[EMAIL PROTECTED]Contrary to popular opinion, Unix is user 
friendly. It's just particular about who it makes friends with. 

 
-Original Message-From: Nick Wagner 
[mailto:[EMAIL PROTECTED]Sent: Monday, March 24, 2003 3:24 
PMTo: Multiple recipients of list ORACLE-LSubject: Quick 
Question -- 8.1.7 logs applied to 9.2.0 database instance?
Can I take a hot 
backup of an 8.1.7 instance...  and then upgrade the backup to 9.2.0 
(upgrading data dictionary tables and everything) and then apply logs created by 
the 8.1.7 instance to this 9.2.0 backup?  
 
Please answer as 
soon as possible...
 
Thanks!  

Nick Wagner
 


 

RE: Veritas Quick I/O for Oracle

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Veritas Quick I/O for Oracle





got a copy, benchmarked it.  No discernable
difference for our application.  Others I 
know swear that it's great. So I guess it varies by
the application.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Another month has ended.  
All goals met
All customers satisfied
All staff ready and enthusiastic
All pigs fed and ready to fly


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 14, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: Veritas Quick I/O for Oracle



Is anyone using Veritas Quick I/O for Oracle? We are purchasing some new
Solaris systems with fiber channel and Veritas File System, and the Veritas
salesperson is claiming "up to 400 times faster". I would like to know if
anyone else has discovered this miracle and what benefits you are seeing.
Thanks.
-- 
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: POLL: Database to DBA ratio

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: POLL: Database to DBA ratio





350 Oracle Databases spread across US and Europe.
14 full time, 4 part time.
75% of applications are designed and built in-house.




-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 12, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: POLL: Database to DBA ratio



We have over 400 databases,  90%+ are Oracle under various versions, platforms. 


Today have 19 DBAs. Two weeks from now there will be 17. 


Rightsizing to continue in the 2nd Quarter 


- Kirti 


-Original Message-
Sent: Wednesday, March 12, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L




We have 7 DBAs.  105 production databases (97 24x7), ranging from 2 GB OLTP
to 800 GB data warehouses.  395 devl/alpha/beta databases ranging in size
from very small (1 GB) to production-sized.  About 1/3 of the production
databases have at least 1 (usually more) development effort going on at any
given time.


Most of our time (lives?) is spent just keeping things up and running.  The
on-call guy averages between 50 to 100 pages per week (record is in the
230-range).  Tuning and testing new stuff is fairly uncommon - as we have
time.



  
  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: show errors doesn't show anything ???

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: show errors doesn't show anything ???





try "show errors package"  or
"show errors package prv_admin"


from the 9.2.0 SQL PLUS Reference Manual


"When you specify SHOW ERRORS with no arguments, SQL*Plus
shows compilation errors for the most recently created or altered stored
procedure. When you specify the type (function, procedure, package,
package body, trigger, view, type, type body, dimension, or java class)
and the name of the PL/SQL stored procedure, SQL*Plus shows errors
for that stored procedure."



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: Janet Linsy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 06, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L
Subject: show errors doesn't show anything ???



Hi,


I have 9i on Linux Red Hat 2.4.9.  A package is
invalid after compiling.  I did a show errors but
nothing shows.  How do I see where the error is ??


SQL> alter package prv_admin compile;


Warning: Package altered with compilation errors.


SQL> show errors;
No errors.


Thank you in advance!


Janet


__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Janet Linsy
  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).

access to oracle $ tables in 9.2.0

[Adams, Matthew (GECP, MABG, 088130)]

Title: access to oracle $ tables in 9.2.0





Previously, an account with the DBA role could
directly query oracle's internal tables
(user$, seg$, ts$, etc).  Now in 9.2.0.2,
it appears we can't.  Does anybody know 
what version this changed in or where (or if)
it was documented.  A quick search on 
MetaLink came up empty.


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?

RE: How long to hold onto old Oracle CDs?

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: How long to hold onto old Oracle CDs?





It figures.  We're one the largest accounts Oracle
has got.  Heck, Oracle has two people at HQ that
deal with nothing but GE business units, and I
STILL can't get 7.3.4, 8.0.5 or 8.0.6 for NT.


Even my dedicated account rep struck out getting 
these disks.  


Oh, well.  I'll go back and try it again.


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: david davis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How long to hold onto old Oracle CDs?



I cut an iTAR on Metalink back last Oct. It would have been simpler. If 
someone had maintained our support agreement. But while that was being 
resolved. The sent me the CD. I got the CD in a couple of days.


I was informed by someone at IBM that Oracle could burn new CD's. If you 
truly have a need for the CD. Such as lost/broken. Put pressure on them via 
your account rep.


I hardly think it is likely for a vendor to say they don't have the code. If 
we have people on the list with software dating back to Oracle 4, I doubt 
Oracle is purging its archives of the software. It would be irrational. It 
is more likely they are just being difficult. Doing nothing is always the 
easiest route for the vendor.


>From: "Adams, Matthew (GECP, MABG, 088130)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: How long to hold onto old Oracle CDs?
>Date: Mon, 24 Feb 2003 09:24:11 -0800
>
>Two months ago, I tried to order older non-supported
>CDs (7.3, 8.0.5, 8.0.6) and they told me
>they could not ship them.
>
>How did you order them?
>
>
>Matt Adams - GE Appliances - [EMAIL PROTECTED]
>We have enough youth.
>How about a fountain of intelligence?
>
>-Original Message-
>Sent: Monday, February 24, 2003 10:39 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Actually the CD's are available. You just have to request them from Oracle.
>Of course, this does depend upon having a support contract.
>
>Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to
>cracked media.
>
>
> >From: "Jesse, Rich" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: How long to hold onto old Oracle CDs?
> >Date: Mon, 24 Feb 2003 06:58:58 -0800
> >
> >Hey all,
> >
> >Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?  We've
> >been at 8.1.7 for 18 months now.  I can't think of a good reason, other
> >than
> >the software isn't available anymore.
> >
> >Anybody want some old CDs?  :)
> >
> >Rich
> >
> >Rich Jesse    System/Database Administrator
> >[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA
> >--
> >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).
>
>
>_
>Help STOP SPAM with the new MSN 8 and get 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: david davis
>   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).



_
Add photos to your messa

RE: Third Party Application Madness

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Third Party Application Madness





That's the situation I'm in now, but the
language is Hungarian.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: Odland, Brad [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Third Party Application Madness



And the table and column names hopefully are in a language you know...


I ran into a app that the table names and columns were in German. Not a
problem if you know German...


Brad



-Original Message-
Sent: Monday, February 24, 2003 2:13 PM
To: Multiple recipients of list ORACLE-L



Congratulations!  We, the Annointed Members present you, Jared Still, with
the Sadistic Vendor Setup Purple Heart award.  Wear it with pride.


At least you *have* PKs and FKs...



Rich


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


-Original Message-
Sent: Monday, February 24, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L




In need of cathartic release, I find myself sharing my
pain with the folks that will understand it best.   :)


The past two weeks have really been 'fun'.


[snip]


Now, on to the next crisis.


Jared
-- 
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: Odland, Brad
  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: How long to hold onto old Oracle CDs?

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: How long to hold onto old Oracle CDs?





Two months ago, I tried to order older non-supported 
CDs (7.3, 8.0.5, 8.0.6) and they told me
they could not ship them.


How did you order them?



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: david davis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: How long to hold onto old Oracle CDs?



Actually the CD's are available. You just have to request them from Oracle. 
Of course, this does depend upon having a support contract.


Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to 
cracked media.



>From: "Jesse, Rich" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: How long to hold onto old Oracle CDs?
>Date: Mon, 24 Feb 2003 06:58:58 -0800
>
>Hey all,
>
>Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs?  We've
>been at 8.1.7 for 18 months now.  I can't think of a good reason, other 
>than
>the software isn't available anymore.
>
>Anybody want some old CDs?  :)
>
>Rich
>
>Rich Jesse    System/Database Administrator
>[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA
>--
>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).



_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: david davis
  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: Programming languages that make DBA's lives easier

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Programming languages that make DBA's lives easier





I much pefer Oberon or Scheme.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: Weiss, Rick [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 21, 2003 9:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Programming languages that make DBA's lives easier



FORTRAN - Only one or two of us left that have even heard of it, much less
actually made $$$ using it


Rick Weiss


-Original Message-
Sent: Thursday, February 20, 2003 10:59 PM
To: Multiple recipients of list ORACLE-L




Assembler.



On Wednesday 19 February 2003 03:33, Robson, Peter wrote:
> I wonder if I can throw in a further caveat to the choices people 
> would make?
>
> If you had to choose a programming language in which to write a 
> program or application in which you wished to conceal your 
> intellectual property, which would you use?
>
> peter
> edinburgh
>
> -Original Message-
> Sent: Tuesday, February 18, 2003 10:56 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> On top of learning Oracle, which programming languages would also 
> benefit some1 learning Oracle?  Perl? Java?  How would these languages 
> be used?
>
>
>
> *
> This  e-mail   message,  and  any  files  transmitted   with  it, are
> confidential  and intended  solely for the  use of the  addressee. If 
> this message was not addressed to  you, you have received it in error 
> and any  copying,  distribution  or  other use  of any part  of it is 
> strictly prohibited. Any views or opinions presented are solely those 
> of the sender and do not  necessarily represent  those of the British 
> Geological  Survey. The  security of e-mail  communication  cannot be 
> guaranteed and the BGS  accepts no liability  for claims arising as a 
> result of the use of this medium to  transmit messages from or to the 
> BGS. The BGS cannot accept any responsibility  for viruses, so please
> scan all attachments.    http://www.bgs.ac.uk
> *



Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weiss, Rick
  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: Teradata baned from IOUG???

[Adams, Matthew (GECP, MABG, 088130)]

If 
there is a demand, I will be happy to expound at some length
on the 
processes by which the papers for our track were chosen, 

but I 
do believe that a different forum might 
be 
appropriate, as we are getting a bit far off the main
topic 
of how to manage Oracle technology.
 
We 
spent last weekend in Gatlinburg/Pigeon Forge 
The 
drive on I-75 from Knoxville, TN up to Lexington, KY and then 

I-64 
over to Louisville was quite a drive as well.
 
Send 
me an e-mail offline next time your going to
be in 
the area and I'll introduce to the very fine products
of the 
Bluegrass Brewing Company.
 
Matt Adams - GE 
Appliances - [EMAIL PROTECTED]We have enough youth.How about a 
fountain of intelligence? 
 
-Original Message-From: Loughmiller, Greg 
[mailto:[EMAIL PROTECTED]]Sent: Friday, February 21, 2003 
10:00 AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: Teradata baned from IOUG???
go 
get'm big dawg  In all honesty, this was educational to me as I'm not 
sure that a lot of people understand the process for the selection.. I have 
learned something today. And once that's accomplished, I need to celebrate.. So 
now I can go home and drink beer for the rest of the day:-)
 
Matt-I65 was really ugly last weekend with the Sunday 
Ice:-) 

  -Original Message-From: Adams, Matthew (GECP, MABG, 
  088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20, 
  2003 2:51 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Teradata baned from 
  IOUG???
  Alright, Mogens.  I'll stand up 
  here.
   
  I'm 
  one of the two DBA focus area managers (FAMs) for IOUG 2003.  My fellow 
  
  FAM 
  and abstract reviewers (3 of them) and I are the ones who
  choose this presentation (along with all the others 
  in the DBA track).
   
  None 
  of us are employed by TUSC or by Oracle.
   
  You 
  statement: "how certain presentations with the word "ratio" and 
  
  something negative in their heading don't make it 
  through the 
  selection process, while presentations with the word 
  "ratio" 
  and 
  something positive make it through."  is technically 
  accurate.
  The 
  only other presentation with the word "ratio" in the title was 
  
  rejected. However, there are a number 
  of others presentations
  that 
  fall within this specific area of tuning by a number of 
  people,
  including Roger Schrag, Cary 
  Millsap,  Jonathan Lewis,
   
  I 
  cannot and will not go into the particulars of why a 
  specific presentation was chosen, but I can tell you 
  
  that 
  no weight was given to the employer of the speaker.
  Matt Adams - GE 
  Appliances - [EMAIL PROTECTED]We have enough youth.How about a 
  fountain of intelligence? 
   
  -Original 
  Message-From: Mogens Nørgaard 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 3:34 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Teradata baned from IOUG???Then why this feeling (in 
  other countries, too) that IOUG should be called TOUG instead? Funny how 
  certain presentations with the word "ratio" and something negative in their 
  heading don't make it through the selection process, while presentations with 
  the word "ratio" and something positive make it through. Funny how an abstract 
  like the following nonsense makes it through the process. Just downright 
  funny, strange and not very convincing... who in their right mind said this 
  was a professional presentation that would be of interest to any serious 
  optimiser guy or girl? Somebody must have said Aye to this. Are you ready? 
  Here we go:"Lately, there has been a big push to ignore your hit ratio 
  with claims that it is meaningless. This shallow minded view (usually by 
  people who sell a tuning tool) ignores why people look at hit ratios and 
  what they are looking for. This quick tip talk will show you what to look 
  for and why. You will definitely know when, where & why to look at 
  your hit ratio in the future. Show you why your hit ratio matters. How 
  to analyze the hit ratio. Fallacies by those who want to sell you products 
  and tools instead. " Henry Poras wrote:
  

Neither is David Teplow (former president of 
NOUG)

  -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 
  Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Teradata baned from IOUG???I know Stan Yellott is 
  not a TUSC employee. He is the President of RMOUG and a great guy who has 
  worked behind the scenes at many IOUG conferences. He is a tremendous 
  calming influence (as many of us recall from San Diego).I don't 
  think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless they 
  have changed jobs recently.Henry Poras wrote:
  Anyone know if a

RE: Teradata baned from IOUG???

[Adams, Matthew (GECP, MABG, 088130)]

Alright, Mogens.  I'll stand up 
here.
 
I'm 
one of the two DBA focus area managers (FAMs) for IOUG 2003.  My fellow 

FAM 
and abstract reviewers (3 of them) and I are the ones who
choose 
this presentation (along with all the others in the DBA 
track).
 
None 
of us are employed by TUSC or by Oracle.
 
You 
statement: "how certain presentations with the word "ratio" and 

something negative in their heading don't make it 
through the 
selection process, while presentations with the word 
"ratio" 
and 
something positive make it through."  is technically 
accurate.
The 
only other presentation with the word "ratio" in the title was 

rejected. However, there are a number 
of others presentations
that 
fall within this specific area of tuning by a number of 
people,
including Roger Schrag, Cary 
Millsap,  Jonathan Lewis,
 
I 
cannot and will not go into the particulars of why a 
specific presentation was chosen, but I can tell you 

that 
no weight was given to the employer of the speaker.
Matt Adams - GE 
Appliances - [EMAIL PROTECTED]We have enough youth.How about a 
fountain of intelligence? 
 
-Original 
Message-From: Mogens Nørgaard 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 3:34 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Teradata baned from IOUG???Then why this feeling (in other 
countries, too) that IOUG should be called TOUG instead? Funny how certain 
presentations with the word "ratio" and something negative in their heading 
don't make it through the selection process, while presentations with the word 
"ratio" and something positive make it through. Funny how an abstract like the 
following nonsense makes it through the process. Just downright funny, strange 
and not very convincing... who in their right mind said this was a professional 
presentation that would be of interest to any serious optimiser guy or girl? 
Somebody must have said Aye to this. Are you ready? Here we go:"Lately, 
there has been a big push to ignore your hit ratio with claims that it is 
meaningless. This shallow minded view (usually by people who sell a tuning 
tool) ignores why people look at hit ratios and what they are looking for. 
This quick tip talk will show you what to look for and why. You will 
definitely know when, where & why to look at your hit ratio in the 
future. Show you why your hit ratio matters. How to analyze the hit ratio. 
Fallacies by those who want to sell you products and tools instead. " 
Henry Poras wrote:

  
  Neither is David Teplow (former president of NOUG)
  
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 
Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Teradata baned from IOUG???I know Stan Yellott is not a 
TUSC employee. He is the President of RMOUG and a great guy who has worked 
behind the scenes at many IOUG conferences. He is a tremendous calming 
influence (as many of us recall from San Diego).I don't think Ian, 
Mark, Bill, Stephen or Steve are TUSC Employees, unless they have changed 
jobs recently.Henry Poras wrote:
Anyone know if any of the 10 people running for the Board of Directors for
IOUG is a TUSC employee? Noone claims it in their statements.

Henry


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


me too...

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 18, 2003 11:11 AM


  
  evidently i'm not the only one who thinks that, interesting.

joe



It seems to me that IOUG has become a wholly owned
subsidiary of TUSC.  TUSC in turn has an incestuous
relationship with Oracle.  All very cozy.

No real complaint about the arrangements.  Someone has
to step up to the plate if IOUG is going to continue
to be a viable organization and in this economic
climate few can afford to do it.

Should IOUG be able to survive without Oracle?
Probably.  Will it be able to survive without Oracle?
I doubt it.


--- Jonathan Lewis <[EMAIL PROTECTED]>
wrote:
  
  It should be possible for the IOUG to live without
Oracle's support.  Obviously it would be better
for all concerned if there is some measure of
co-operation, and there's clearly no need for
bloody-minded conflict.  But if the IOUG just
keeps doing things that the users want, then
the users should be able to support it in the
complete absence of any input from Oracle.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


The Co-operative Oracle Users'

RE: Teradata baned from IOUG???

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Teradata baned from IOUG???





The Exhibitor List at at the IOUG web site
does not list Teradata.





Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 1:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Teradata baned from IOUG???



Exactly. Let's see if they're men or mice :).


My guess is that they'll give in because some of them get a lot of free 
publicity from Oracle.


Mogens


Tony Johnson wrote:


>I'm sorry but I thought that IOUG was independant from Oracle? If Larry
>is afraid of a little competition then perhaps he should get out of the
>market. If not then he should battle it out in every venue possible and
>show why Oracle is better. 
>
>If Rich and the guys do this they will be setting a dangerous precedant.
>
>-Original Message-
>Sent: Wednesday, February 12, 2003 2:59 PM
>To: Multiple recipients of list ORACLE-L
>
>
>DBA's
>
>Check the article's comment on Oracle trying to ban Teradata from IOUG
>
>Teradata Steals Oracle's Data Mart Users ...
>
>Teradata pushes consolidation and woos away Oracle customers. But
>Oracle strikes back. Sort of. Will bean counters surf the Web with
>Excel? Will Steve Ballmer and Larry Ellison become immortal?
>
>http://computerworld.com/newsletter/0%2C4902%2C78375%2C0.html?nlid=DM 
>
>
>
>  
>




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  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: Version Controlling in Oracle database - Ideas ?

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Version Controlling in Oracle database - Ideas ?





Have you checked out Mark Stock's Presentation 
at the 2002 SEOUC conference entitled:


TAG! Whose Code is it? Code Management & Data Encryption


Should be available at www.seouc.org.






Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?


-Original Message-
From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Version Controlling in Oracle database - Ideas ?




Looking for a solution to version controlling of database objects in Oracle.


The scenario is like this:


Multiple people simultaneously work on the same database object in TOAD.


How can we implement a version controlling feature. 


Putting this in simple words, 


If X checks out a file from TOAD and Y needs to work on the same file
(assuming they have the same privilege),
Y should not be allowed to work on the object till X finishes working on it. 


We want to put a restriction on the database objects such that simultaneously no two 
users should be able to work it.


Integrating VSS with TOAD was not acceptable since it would be file based(saving the .sqls).


Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: VIVEK_SHARMA
  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: HyperRoll Experience (http://www.hyperroll.com)

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: HyperRoll Experience (http://www.hyperroll.com)





The people who work on Oracle Express 
(multi-dimensional DB) are using it with
great success. Note that this does not 
include me.  I have not used it personally.


Mark Cawi of ThinkFast consulting did a presentation
on HyperRoll at the January meeting of 
the Greater Cincinnati Oracle Users Group.
I don't how useful the presentation alone would
be to you (I've never felt that slides without
associated commentary are all that helpful), but 
if you want to download it, it can be found at:


http://www.gcoug.org/presentations/



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: HyperRoll Experience (http://www.hyperroll.com)



I'll go along with Dennis, their online brochure offers
no compelling reason to investigate this.


The lack of any mention of MV's ( as in, "Why our product
is better than Materialized Views") and the implication that
it won't require tuning by the DBA make it seem rather 
suspicious.


my $0.02 worth


Jared







DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/03/2003 06:39 AM
 Please respond to ORACLE-L


 
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
    Subject:    RE: HyperRoll Experience (http://www.hyperroll.com)



Babu - Hadn't heard of it, looked at the link you provided. Tell your
management that it isn't needed because Oracle has Materialized Views. ;-)
Seriously, if I were you, I would compare how this tool works against
Oracle's Materialized View feature.


Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 



-Original Message-
Sent: Monday, February 03, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L



All


Have any of you worked with this product that is supposed to improve the
performance of a RDBMS or a OLAP database...  Damagement heard about this
product form somewhere and wants us to investigate...


Any feedback is appreciated..


TIA


Babu


_
This e-mail transmission and any attachments to it are intended solely for
the use of the individual or entity to whom it is addressed and may 
contain
confidential and privileged information.  If you are not the intended
recipient, your use, forwarding, printing, storing, disseminating,
distribution, or copying of this communication is prohibited.  If you
received this communication in error, please notify the sender immediately
by replying to this message and delete it from your computer.



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





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

hotel notice for folks considering attending IOUG

[Adams, Matthew (GECP, MABG, 088130)]

Title: hotel notice for folks considering attending IOUG





I got this in the e-mail today.
If you are considering attending the IOUG-A live 
in April, please read the below.


(I hope Jared doesn't consider too far OT)


---


Dear IOUG Member:
 
Please be aware that an organization which has no affiliation with 
the IOUG is contacting our members and representing themselves 
as part of our organization - for the purpose of selling hotel 
rooms for this year's Live! event in Orlando.
 
This company has no affiliation with the IOUG and we do not 
endorse their activity.  We strongly recommend that you do not 
do business with them, should they contact you directly.
 
Our attorney is contacting this organization to notify them to 
cease this activity. If you have any questions, comments or
 concerns, please contact our headquarters staff at +1.312.245.1579.


Many thanks.

RE: unix time conversion function

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: unix time conversion function





Nevermind,


Once I thought about it for more than 30 seconds, 
I got it.



TO_DATE('01/01/1970','MM/DD/') +  / 86400


easy as 3.141592654 



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Adams, Matthew (GECP, MABG, 088130) 
Sent: Friday, January 24, 2003 2:12 PM
To: '[EMAIL PROTECTED]'
Subject: unix time conversion function



Anybody got a handy little function to 
convert a standard unix seconds-since-Jan-1970 epoch
time (stored as a number) to a readable date?


It would save me a lot of time not having to re-invent the 
wheel.


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.

unix time conversion function

[Adams, Matthew (GECP, MABG, 088130)]

Title: unix time conversion function





Anybody got a handy little function to 
convert a standard unix seconds-since-Jan-1970 epoch
time (stored as a number) to a readable date?


It would save me a lot of time not having to re-invent the 
wheel.


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.

RE: from Non-Archive-Mode to Archive-Mode

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: from Non-Archive-Mode to Archive-Mode





I personally use the following SQL to 
get a very rough estimate of how much 
archive space I'm going to need per day.


select (num_logs*bytes )/(1024*1024) "Megs per Day"
  from (select ceil(avg(count(*))) num_logs from v$log_history lh
 group by trunc(lh.first_time)),
   (select avg(bytes) bytes from v$log)
/



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: from Non-Archive-Mode to Archive-Mode




It depends on how much data is changed in the database.  If there is no data
manipulation, then you need very little archive space (just enough for the
online logs when you run a backup).  Look in the alert log to see how many
log switches occur.  I think this will give you a reasonable estimate of how
much archiving will occur.


-Original Message-
Sent: Friday, January 17, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L


Hi,


  how can I calculate/estimate the extra disk space I'll need if I
change the log mode from non-archive-mode to archive-mode. I want to change
the log mode of all my objects. Do I need to do this one-by-one or is it
enough if I change the log mode of my tablesapces?


Thanks in advance


Murat




--
Bu  e-posta  sadece  yukarida  isimleri  belirtilen  kisiler  arasinda ozel
haberlesme  amacini  tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji
geri  gonderiniz  ve  sisteminizden  siliniz.  Rt.Net  Internet  Hizmetleri
Pazarlama  ve  Ticaret  A.S.  bu  mesajin icerigi ile ilgili olarak hic bir
hukuksal sorumlulugu kabul etmez.


This  e-mail  communication  is intended for the private use of the persons
named  above.  If  you  received  this message in error, please immediately
notify  the  sender  and  delete  it  from  your  system.  Rt.Net  Internet
Hizmetleri  Pazarlama  ve Ticaret A.S. does not accept legal responsibility
for the contents of this message.
--




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MURAT BALKAS
  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: Stephen Lee
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Was 8.1.6 certified on Solaris 8?

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Was 8.1.6 certified on Solaris 8?





We run a couple of apps on 8.1.6/solaris 8
with no problems.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 6:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Was 8.1.6 certified on Solaris 8?



We're upgrading from Solaris 2.6 to Solaris 8 and 8.1.6 to 8.1.7 on one of
our boxes.


I want to know if it's possible to do the OS upgrade first and then the
database upgrade (e.g., I'd be running 8.1.6 on Solaris 8 for a day or so).


The Oracle certification matrix only says that 8.1.6 is desupported and
therefore doesn't list any certified OS versions for it.


Did anyone run 8.1.6 on Solaris 8 or remember if it was ever certified?



TIA,
Jay Miller


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

ioug.org web site

[Adams, Matthew (GECP, MABG, 088130)]

Title: ioug.org web site





Is anybody else having trouble with the www.ioug.org
web site.  I can get to the home page, but cannot
log in, or register for IOUG-A Live.


Is it just me?



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.

RE: Is nothing sacred? (Oracle vs The Experts)

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Is nothing sacred? (Oracle vs The Experts)





> that the Cubs will never win another
> World Series (okay...bad example).


Ok, now that hurt.


Matt "long suffering cubs fan" Adams


 "Do they still play the blues in Chicago when baseball 
  season rolls around?"
    - A Dying Cubs Fan Last Request



-Original Message-
From: Fink, Dan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 12, 2002 5:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is nothing sacred? (Oracle vs The Experts)



Of course, sacred cows make the best steaks (sorry, Gaja).


An excellent example is the age old ideas that the earth was the center of
the universe, that the world was flat, that the Cubs will never win another
World Series (okay...bad example). Knowledge is limited by what we can
currently test. We are always restricted by our physical world (I don't have
a clue as to how I can personally test if the world is indeed round) but
also by what we choose to accept as fact. What happens to indexing
strategies when disk reads are faster than memory access operations? Before
you say, "It will never happen" think about it...Can you predict the future
with absolute certainty?


Even the 'experts' choose to accept certain facts. Look at the scientific
world. Many of the most 'brilliant' ideas now can be proven false. According
to the experts, we only need 5 computers worldwide with 64k of memory. 


I checked by Data Server Internals texts from 1999 and they preach 15% of
rows returned for indexing, and this series is certainly looked upon as the
'expert'. Anyone out there with a more recent version? I wonder what it
says...


IMHO, the bottom line is that many of us are so concerned with just keeping
systems running that we have no time for our own personal research and
development. Until I decided to write an article about rollback segments, I
never applied the scientific method to my understanding of Oracle. Will
application of the method explain everything? Nope, but it will come close.
It requires a lot of time and hard work, something that is a precious
commodity these days, especially in the corporate world. I am very grateful
for people like Cary, Tim, Anjo, Craig, Gaja, Kirti, et.al. who take the
time to say "prove it!" and then perform the experiments and, most
importantly, are willing to share the results with us on this list and at
meetings like IOUG-A.


Dan Fink


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



I think the question "Is nothing sacred?" is an interesting one. Lots of
these things we're talking about have been false for a very long time.
It's only that people are finally starting to notice them. Product
changes are often *not* what's driving "new knowledge." In many cases,
the "change" that's taking place is the improvement in the quality of
our conclusions.


"Is nothing sacred?" I think it's perfectly legitimate to confront
people's (and companies') conjectures with scientific data.



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com


Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas



-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, November 12, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L


Jesse,


    No, nothing in sacred any more.  Change is the theme of the day.
BTW: did
you experiment with caching these tables in the keep_pool??  I've had
some real
good luck with unindexed tables that are small (in the 1 to 10 block
size) that
get assigned to the keep pool and retained in memory forever.


    Also, BTW: I'll disagree with Cary and Hotsos on the costs of a PIO
vs a
LIO.  In my experience it's not such a clear cut distinction.  Whenever
Oracle
needs a block of data that data must be in memory which means that a PIO
requires 2 LIO's to fulfill the request and on top of that there may be
other
memory management routines that get called if an empty data block in
memory must
be created.  All in all it's a very mixed bag that needs to be
considered case
by case.  I believe that was one of the reasons Oracle allows us to
configure
the cache three ways.  Static, seldomly changed tables in the keep pool.
Large
constantly changing tables in the discard pool.  Also to index or not to
index
are no longer such clear cut item, especially with CBO which loves to
ignore
indexes.


Dick Goulet


Reply Separator
Author: "Jesse; Rich" <[EMAIL PROTECTED]>
Date:   11/11/2002 8:58 AM


So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that
runs
20 minutes out of every hour of the day (despite my protests to it's
design).  After it starts having problems (go figure), it becomes a
priority
to speed it up.


Thanks to a 10046 trace, we see that the query taking the most elapsed
time
does FTSs on each of 

RE: IOUG Papers

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: IOUG Papers





The Focus Area Managers submitted their selections
up to the Technical Session Chair and the 
Director of Educational Programming last week. 
They have to review the selections for each area and
make any adjustments they feel necessary. 
I would think that notices would be going out to 
paper authors fairly soon, within the next
two weeks possibly.


Matt Adams



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Stephen Andert [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 11, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L
Subject: IOUG Papers



Does anyone know what the expected time-frame is for the IOUG paper
seletion committee to select papers?


I submitted a couple and am on pins and needles.


Thanks
Stephen Andert


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Andert
  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: When will Oracle 10i be out?

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: RE: When will Oracle 10i be out?





8i?  You luck dog.  I'm still trying to get about 
15 systems up to 7.3 (from 7.2)



Matt Adams - GE Appliances - [EMAIL PROTECTED]



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: When will Oracle 10i be out?



Heck, Would you people kindly give some of us time to get fully up on 8i first!!


Dick Goulet


Reply Separator
Author: [EMAIL PROTECTED]
Date:   11/7/2002 11:08 AM


The day we all finish upgrading our databases to 9i.


Sunil Nookala
DBA
Dell Corp.




-Original Message-
Sent: Thursday, November 07, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L



Has anyone heard when Oracle will be releasing version 10i?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pall, Tom [Contractor]
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle DBA with SAP Needed

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Oracle DBA with SAP Needed





It's Toledo.  That ought to automatically 
double the salary.


"Saturday night in Toledo Ohio is like being nowhere at all
All through the day, how the hours rush by
you visit the park and you watch the grass die."


 -  John Denver

Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle DBA with SAP Needed



The fact that the job's in or near Toledo might have something to do with
the salary. I doubt the cost of living is that high around there.


--Walt Weaver
  Bozeman, Montana


-Original Message-
Sent: Wednesday, November 06, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L



I doubt they can fill this position at that salary.


Oracle DBA's that work with SAP can easily earn much more than that.


Jared







"Markham, Richard" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L


 
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
    Subject:    RE: Oracle DBA with SAP Needed



What does "Base Salary is 55K-to maybe high 60s Firm." mean?  You can 
throw the possibility of a raise out the window? =) 
-Original Message- 
Sent: Wednesday, November 06, 2002 9:49 AM 
To: Multiple recipients of list ORACLE-L 


If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in 
Toledo, 
Ohio 
is the place for you. This Fortune 500 employer has experienced steady 
growth over 
the hundred years it has been in business and is looking for a top notch 
candidate. 
This company is located in a very reasonable cost of living area and 
offers 
a varied choice 
of neighborhood communities. 
If you are looking for a place to grow within your career in a smaller 
city 
atmosphere 
this is the opportunity to check out. 
Relocation Assistance is provided. 
PLEASE DO NOT send your resume for this position UNLESS you have the 
skills 
outlined below for this position. 
DO NOT send your resume unless you have a stable work history. 
Candidates whose work history includes frequent job changes connot be 
considered. 
If you are employed by a consulting company you must have a long term 
project history. 
This is a full time staff position so no sub-contractors or third parties 
please. 
NO H-1B candidates please. 
*Requirements: 
-MUST be a team player. 
-3+ years Oracle DBA experience. 
-SAP experience 
-Must have experience with:Installation, Backup and recovery, 
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design, 
Monitoring, and Support. 
-MUST have excellent communications skills 
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
scripting 
and experience with 
 Sybase and/or SQL Server. 
Base Salary is 55K-to maybe high 60s Firm. 
The employer itself offers a comprehensive medical plan, dental insurance, 
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K 
Plan, and much more. 
For immediate consideration, please email your resume as an attachment to: 
OraStaff, Inc. 
Email: [EMAIL PROTECTED] 
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni 
I pay referral fees. 
So please contact me if you know of anyone who would be 
qualified/interested 
in the position described above- if it is not a match for your skills. 
Thanks. 





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: OraStaff 
  INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California    -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Pleas

RE: creating a 9.2 database

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: creating a 9.2 database



Did 
you run 9.0 or 9.2?  The last page for my installer
has 
two check boxes 
 
 - create template
 - create database
 
 
 
Matt Adams - GE Appliances - 
[EMAIL PROTECTED]My computer beat me at chess, but I wonwhen it 
came to kick boxing. 
 
-Original Message-From: David Wagoner 
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 01, 2002 
2:39 PMTo: Multiple recipients of list ORACLE-LSubject: 
RE: creating a 9.2 database

There 
are two check boxes at the end of the DBCA steps.  One is to create a template, the other 
is to create scripts.  The tricky 
thing about the 9i DBCA is that the options are different if you choose New 
Database rather than the other choices.  
I’ve checked and edited the scripts after using the Create New Database 
option.
 
HTH,
 
David 
Wagoner
 
 
-Original 
Message-From: Adams, 
Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Friday, November 01, 2002 12:59 
PMTo: Multiple recipients of 
list ORACLE-LSubject: RE: 
creating a 9.2 database
 
I did this (create a 
template, exit and re-run, select template, go to step 7 (last 
screen)).  Nowhere did I see an option to have the script to a file.  
Do you know which step this is found in? 
 Matt Adams - GE Appliances - 
[EMAIL PROTECTED] My computer beat me at chess, but I 
won 
when it came to kick 
boxing. 

-Original 
Message- 
From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 31, 
2002 4:54 PM 
To: Multiple recipients of list 
ORACLE-L 
Subject: Re: creating a 9.2 
database 

 
I must disagree. There is no 
$ORACLE_HOME/admin//scripts. There is no admin directory under 
$ORACLE_HOME. In 9.2.0 you must create a template first by using the default 
configuration, save it, then exit the OUI. Then start it up again and use the 
existing template.  Go through the normal prompts and then select the 
option to have it generate a shell script file near the end of the 
process.  Have it save the script file in a directory of your choosing or it will 
put it in 
$ORACLE_HOME/assistants/dbca/templates by 
default. 

RWB 

"Adriano Freire" 
<[EMAIL PROTECTED]>@fatcity.com on 10/31/2002 
02:59:10 
PM 
Please respond to 
[EMAIL PROTECTED] 

 
Sent by:  
[EMAIL PROTECTED] 

 
To:   Multiple 
recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: 
 
normally in  
$ORACLE_HOME/admin//scripts - Original Message 
- 
To: Multiple recipients of list 
ORACLE-L 
Sent: Thursday, October 31, 2002 
5:40  PM 

I always like to create my 
databases by hand via 
the create database statement.  
However, whenever a  new version comes out I use the dbca assistant 
to  generate the 
create database script so I can see 
what  Oracle does by default (although I usually don't 
run  this generated script.) 
I'm trying to do this with my 
new 9.2 installation, but at the end (step 7), it doesn't seem to 
allow the 
generation of the script without creating 
the  database. 

Is dbca creating a script to 
run and if so, where is it storing it? 
9.2.0 on HP-UX 
11i 

Matt 
 Matt Adams - GE Appliances 
-  [EMAIL PROTECTED] My computer beat me at chess,  but I 
won 
when it came to kick 
boxing. 


-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com -- Author:   INET: 
[EMAIL PROTECTED] 
Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.com San Diego, 
California    -- Mailing list and web 
hosting services 
- To REMOVE yourself from this 
mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list you want to 
be removed from).  You may also send the HELP command for other 
information (like subscribing). 

RE: Get together at OOW

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Get together at OOW





Not all the time.  At the IOUG-A Live in Ananheim a few years
ago, we all met
at a resturant for dinner.  We had just one bill, I collected the
cash from everyone and paid the bill.  Everybody insisted that they
only gave me enough money to cover their portion of the bill and
the tip (which was an automatic 18%).  After paying the bill and
tip, I still had about $15 left over and everybody insisted that
it wasn't theirs, so we went back to hotel and I bought a round.


This is just that kind of group.  Generous to a fault with
time, knowledge, and on occasion, money.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 01, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Get together at OOW




Its the classic three part story...


Part 1:  20 great friends meet for the dinner


Part 2:  The bill arrrive


  "I only had one piece of garlic bread!"
  "You drank some of my wine!"
  "I shared my burger with Joe over there!"


Part 3:  20 arch enemies storm out...


:-)


 --- "Karniotis, Stephen"
<[EMAIL PROTECTED]> wrote: > Personal
experience with the "one check" concept and
> large numbers of people
> is not good.  I would pressure them into say 5
> checks.  Easier to
> coordinate.
> 
> Thank You
> 
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:    [EMAIL PROTECTED]
> Web:  www.compuware.com
> 
>  -Original Message-
> Sent: Thursday, October 31, 2002 3:59 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Get together at OOW
> 
> Absolutely OK!  I just made the reservation at
> Chevy's (3rd and Howard) for
> Tuesday Nov. 12th, 7pm for 20-25 people.  The only
> restriction is that we
> put it on one check.  Hopefully that will not be a
> problem for anyone.
> 
> Gerardo
> 
> -Original Message-
> Sent: Thursday, October 31, 2002 10:40 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I might be able to scrounge a 7pm appearance by Anjo
> Kolk, Mogens Nørgaard,
> James Morle, Connor McDonald, Gaja Vaidyanatha, John
> Beresniewicz, Pete
> Sharman, Lex de Haan, and maybe a few others if
> there's room. Would that be
> okay?
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - 2003 Hotsos Symposium on Oracle(r) System
> Performance, Feb 9-12 Dallas
> - Jonathan Lewis' Optimising Oracle, Nov 19-21
> Dallas
> 
> 
> -Original Message-
> Gerardo
> Sent: Thursday, October 31, 2002 11:39 AM
> To: Multiple recipients of list ORACLE-L
> 
> John,
> 
> I'm planning to make a reservation (for dinner) at
> 7pm for 15 people on
> Tuesday 11/12/2002.  We can congregate in the
> cantina for drinks anytime
> before then.  We should have no problem changing the
> number of people at the
> last minute, if necessary.
> 
> Gerardo
> 
> -Original Message-
> Sent: Wednesday, October 30, 2002 3:44 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Steve,
> 
> I will send out an invite closer to that time - say
> around 6th or 7th.
> 
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
> 
> What would you see if you were allowed to look back
> at your life at the end
> of your journey in this earth?
> 
> ** The opinions and statements above are entirely my
> own and not those of my
> employer or clients **
> 
> > -Original Message-
> > From: Steve McClure [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 28, 2002 9:39 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Get together at OOW
> > 
> > 
> > It looks like I will be attending this year
> pending upper management 
> > balking at the registration fee.  As for getting
> together, I think
> > that would be
> > great, Chevy's is great as well,  In fact Tuesday
> evening 
> > looks great too.
> > 
> > So how big a party does that make?  Count me in.
> > 
> > 
> > Steve McClure
> > 
> > -Original Message-
> > Sent: Saturday, October 26, 2002 8:48 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > 
> > John,
> > 
> > Yes, it would be nice to meet.
> > 
> > I'm not planning anything, I'll let someone else
> do it.
> > 
> > I won't be available during the day at the
> conference, so
> > it would be best if someone else put's something
> together.
> > 
> > My previous post didn't make it to the list:  I'm
> attending a couple
> > of Veritas classes at the same time as the
> conference, so I'll just  
> > be a couple miles down the road at the
> Embarcadero.
> > 
> > Jared
> > 
> > PS. Rachel, too bad you won't be there.  I'm
> bringing Blazing Saddles.  
> > ;)
> > 
> > On Monday 21 October 2002 16:43, John Kanagaraj
> wrote:
> > > Jared,
> > >
> > > Count me in as I live

RE: creating a 9.2 database

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: creating a 9.2 database





I did this (create a template, exit and re-run, select 
template, go to step 7 (last screen)).  Nowhere did I see an
option to have the script to a file.  Do you know which 
step this is found in?



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 31, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: creating a 9.2 database




I must disagree. There is no $ORACLE_HOME/admin//scripts. There is no
admin directory under $ORACLE_HOME. In 9.2.0 you must create a template
first by using the default configuration, save it, then exit the OUI. Then
start it up again and use the existing template.  Go through the normal
prompts and then select the option to have it generate a shell script file
near the end of the process.  Have it save the script file in a directory
of your choosing or it will put it in
$ORACLE_HOME/assistants/dbca/templates by default.


RWB






"Adriano Freire" <[EMAIL PROTECTED]>@fatcity.com on 10/31/2002 02:59:10
PM


Please respond to [EMAIL PROTECTED]




Sent by:  [EMAIL PROTECTED]



To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:




normally in  $ORACLE_HOME/admin//scripts
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 31, 2002 5:40  PM


I always like to create my databases by hand via
the create database statement.  However, whenever a  new
version comes out I use the dbca assistant to  generate the
create database script so I can see what  Oracle does by
default (although I usually don't run  this generated script.)


I'm trying to do this with my new 9.2 installation, but
at the end (step 7), it doesn't seem to allow the
generation of the script without creating the  database.


Is dbca creating a script to run and if so, where is
it storing it?


9.2.0 on HP-UX 11i


Matt



Matt Adams - GE Appliances -  [EMAIL PROTECTED]
My computer beat me at chess,  but I won
when it came to kick boxing.





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

creating a 9.2 database

[Adams, Matthew (GECP, MABG, 088130)]

Title: creating a 9.2 database





I always like to create my databases by hand via
the create database statement.  However, whenever a new
version comes out I use the dbca assistant to generate the
create database script so I can see what Oracle does by 
default (although I usually don't run this generated script.)


I'm trying to do this with my new 9.2 installation, but 
at the end (step 7), it doesn't seem to allow the 
generation of the script without creating the database.


Is dbca creating a script to run and if so, where is
it storing it?


9.2.0 on HP-UX 11i


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.

RE: CA's AutoSys

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: CA's AutoSys





I think we may be talking about the same
place Terry, aren't we?


Matt Adams


-Original Message-
From: Ball, Terry [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 18, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: CA's AutoSys



Oh, I don't know about that.  At one of the places you used to work, they
_finally_ got it to work, but it did need at least one full-time, dedicated
employee to monitor, maintain and massage it.
 


Terry Ball, DBA 
Birch Telecom 
Work: 816-300-1335 
FAX:  816-300-1800 


 


-Original Message-
Sent: Friday, October 18, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L




Run Screaming in the opposite direction. 


Product was a semi-disaster at two previous 
job sites.  Failed to run jobs when scheduled, 
failed to detected when dependent jobs failed.  
Just plain didn't work well.  


Of course this was when Platinum owned the product, 
who knows, maybe CA improved it. (although I would 
doubt it). 



 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
Write a poem about a haircut! But lofty, noble, tragic, full of love, 
treachery, retribution, quiet heroism in the face of certain doom! 
Six lines, cleverly rhymed, and every word beginning with the letter s! 


-Original Message- 


Sent: Friday, October 18, 2002 11:50 AM 
To: Multiple recipients of list ORACLE-L 



To All, 


    I'll admit this is somewhat off-topic, but since the project is going to


handle all scheduled batch jobs that bang on our PeopleSoft Oracle database,
I 
figured I'd ask if anyone has an opinion preferably from experience using
the 
product.  The Complete A^^holes are here today to do a demo install so any
input 
you all have would be appreciated. 


Thanks in advance 


Dick Goulet 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: 
  INET: [EMAIL PROTECTED] 


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
  
San Diego, California    -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ball, Terry
  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: CA's AutoSys

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: CA's AutoSys





Run Screaming in the opposite direction.


Product was a semi-disaster at two previous
job sites.  Failed to run jobs when scheduled,
failed to detected when dependent jobs failed.  
Just plain didn't work well.  


Of course this was when Platinum owned the product,
who knows, maybe CA improved it. (although I would
doubt it).




Matt Adams - GE Appliances - [EMAIL PROTECTED]
Write a poem about a haircut! But lofty, noble, tragic, full of love, 
treachery, retribution, quiet heroism in the face of certain doom! 
Six lines, cleverly rhymed, and every word beginning with the letter s!


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 18, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: CA's AutoSys



To All,


    I'll admit this is somewhat off-topic, but since the project is going to
handle all scheduled batch jobs that bang on our PeopleSoft Oracle database, I
figured I'd ask if anyone has an opinion preferably from experience using the
product.  The Complete A^^holes are here today to do a demo install so any input
you all have would be appreciated.


Thanks in advance


Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: No Nulls? (was: Warehouse design: snowflake vs star schem

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem





"No application that I can reasonably think of should 
use NULLS, except those pre-81
where there are obsolete columns."


Everytime somebody says this to me, I ask them:


How do you handle still employed employees in an EMPLOYEE table 
that contains a END_EMPLOYEMENT date column?


What's your take?

Matt Adams - GE Appliances - [EMAIL PROTECTED]
Write a poem about a haircut! But lofty, noble, tragic, full of love, 
treachery, retribution, quiet heroism in the face of certain doom! 
Six lines, cleverly rhymed, and every word beginning with the letter s!


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:No Nulls? (was: Warehouse design: snowflake vs star schem



Jesse,


    I'll refrain from personal comments, but on CJ's quote, he's correct.  Nulls
are an oddity.  They cannot be true or false ( = NULL or
 != NULL), nor can they equal anything.  They are in effect a third
logical state of nothingness.  You also have to code most applications with
indicator variables to check for their existence.  All in all a real pain in the
backside.  BUT, if you give me the possibility that nulls exist in the data I
much prefer using them vs. many a third party solution of a single space.  No
application that I can reasonably think of should use NULLS, except those pre-81
where there are obsolete columns.


Dick Goulet


Reply Separator
Author: "Jesse; Rich" <[EMAIL PROTECTED]>
Date:   10/14/2002 9:33 AM


On the link below is this quote from C.J.Date:


"I don't want you to think that my SQL solution to your problem means I
advocate the use of nulls.  Nulls are a disaster."


Of course, he doesn't expound upon it (probably not a need except for
dummies like me).  Anyone care to comment?  (On the quote, not on my
dumminess...)



Rich



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


> -Original Message-
> From: Robson, Peter [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 14, 2002 4:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Warehouse design: snowflake vs star schemas
> 
> 
> Just for the record (and perhaps to confirm that there are 
> always two sides
> to a story). Readers may like to see the article Chris Date 
> wrote to Ralph
> Kemball on the subject of business rules and integrity constraints:
> 
> http://www.dbdebunk.com/kimball1.htm
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

hot backup mode

[Adams, Matthew (GECP, MABG, 088130)]

Title: hot backup mode





Does the unmodified image of the datafile block
get recorded in the redo log as well as the modified
image when a tablespace is in hot backup mode?


I'm being told that it does, but that is not
my understanding.  Is this documented somewhere?


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Their fundamental design flaws are completely
hidden by their superficial design flaws.
  - Douglas Adams