RE: Oracle 9.2.0.1/2 on Mandrake 9 - solved

[Jim . Conboy]

I've been told the same thing, but the reasoning was that they couldn't guarantee what 
was put out for download was actually the correct build.  Not sure that's very 
reassuring, either.

Jim

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



Oracle Corp. finds the checksum concept to be alien.  They actually
posted these words to me in a tar at metalink, "We don't support
servers that are installed via download from otn."  I guess "network
computing" really is dead. ;)
 



On Thu, Nov 14, 2002 at 07:54:27AM -0800, Boris Dali wrote:
> Ray, right on target!
> 
> After looking for disk errors in dmesg output,
> /var/log/messages to no avail, I finally uninstalled
> the whole 9.2 OH last night,
> re-downloaded/re-burned/re-... and this time
> installation of both 9.2.0.1 and a patch went with no
> glitches. 
> 
> Apparently Disk2 was corrupted/missing files/??? on
> downloading/burning/unpacking, but what surprised me
> the most is that I didn't get any errors at
> gunzip/cpio stage, which I always thought of as a good
> indication that software on CDs is valid. This
> assumption cost me week and a half of hopeless tries
> to make it work...
> 
> On the bright side, some .o, .so etc. files I see in
> OUI during installation look painfully familiar...
> 
> Thanks a lot for you help.
> 
>  --- Ray Stell <[EMAIL PROTECTED]> wrote: > On Tue,
> Nov 12, 2002 at 01:50:52PM -0800
> 
> __ 
> Post your free ad now! http://personals.yahoo.ca
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Boris Dali
>   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).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  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 8i DB, 9i DB and 9iAS on same Unix box, refused

[Jim . Conboy]

Don-
 
Look 
for port conflicts between the Apache installed with 9iAS and the one with 
9.2.  If you're using web cache on iAS check the port that is using 
also.
Are 
you using iAS Release 2 (9.0.2)?  If so, and both the infrastructure and 
mid-tier are on the same server, they will each have their own orahome with 
apache.  iAS Release 2 is smart enough to keep its various apaches, etc on 
diffferent ports but the 9.2 DB install might not be.
 
Jim

  -Original Message-From: Don Malzahn 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, November 11, 2002 
  5:44 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle 8i DB, 9i DB and 9iAS on same Unix box, 
  refusedAll,Environment:HP-UX 11iWe had 
  Oracle 8i (8.1.7) running successfully on our one host. This host also has 
  Oracle 9i AS already 
  too. Then we installed 
  Oracle 9i R2 (9.2.0.1) on the same host (to run RMAN backup and recovery on 
  another host).Since then our one application (FAMIS from PRISM) is having 
  problems taking connections through the web (9i AS).One person here 
  did some research and says perhaps when 9i DB was installed (to support doing 
  RMAN backups for a 9i DB system on another box), it overlaid the prior version 
  of Apache. Sounds good to me. We don't have  that much experience in the 
  9iAS, so we can't really say where the problem is. The database is up and open 
  and I can hit it from command line sqlplus.Any ideas what went wrong 
  and how to fix it? Should we have done a reboot of the host after the Oracle 
  9i install? We did 
  not.message:===ERRORThe requested URL could not be 
  retrievedWhile trying to retrieve the URL: http://cmms.harper.cc.il.us/pls/ftrn/loc.login 
  The following error was encountered: · Connection 
  Failed The system returned: (61) Connection refusedThe remote host 
  or network may be down. Please try the request again. Generated Mon, 
  11 Nov 2002 19:15:16 GMT by fw3.harper.cc.il.us (Squid/2.2.STABLE5) 
  ===Thanks.
  -
  Don Malzahn, IT/AS, Harper Community College   Voice:(847) 
  925-6829
  E-mail: [EMAIL PROTECTED]    Web page: http://www.harpercollege.edu
  "The only limit to our realization of tomorrow will be our doubts of 
  today". - FDR
    
  

Re: Grumble, grumble

[Jim Conboy]

You darn skippy, Bambi.  We never got specific error messages, 
either.  Just got something like 'patch failed' with no reference to where 
or why.  The world's gone soft since the days when 'computer people' all 
wore white smocks and carried boxes of punch cards around.
 
Jim>>> [EMAIL PROTECTED] 11/02/01 12:00PM 
>>>
Anyone ever see *this* ?  They sure don't apply patches the 
way they used to.  Why, when *I* was a child, we 
applied patches with spit and mud and hay, and they 
didn't complain about no '=' character neither, by gum... 
Bambi.  
oradev> /u05/dfinappl/ad/11.5.0/bin/adpatch 
c1880630.drv 
 
Copyright (c) 1998 Oracle Corporation     
Redwood Shores, California, USA 
 
Oracle Applications AutoPatch 
 
Version 11.5.0 
NOTE: You may not use this utility for custom development 
  unless you have written 
permission from Oracle Corporation. 
Invalid argument (no '=' character): c1880630.drv 
-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.com -- Author: Bellows, Bambi   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet access / 
Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send 
the HELP command for other information (like subscribing). 

RE: SAP and Oracle

[Jim Conboy]

Kimberly-
 
When we went to SAP about 5 years ago our SAP license came with limited use 
Oracle licenses.  This covered all the users of SAP, although in truth only 
the SAP superuser actually connected directly to Oracle.  The license did 
not allow creation of additional schemas in the Oracle instance.  You can 
create additional objects in the SAP schema, but I think technically you must do 
so using SAP-supplied tools.  And of course you can't transfer them to a 
different application.
 
Sometime over the last two years I've heard that this arrangement had 
changed, and that we had to get our usage licenses directly from Oracle.  
But since we had a corporate agreement with Oracle which covered these users 
anyway I never pursued that issue and can't vouch for it.
 
Jim>>> [EMAIL PROTECTED] 10/26/01 05:55PM 
>>>
When you say for SAP only do you mean all the people who 
connect to SAP will be covered? 
-Original Message- Sent: Friday, 
October 26, 2001 2:11 PM To: Multiple recipients of list 
ORACLE-L 
Your SAP license comes with a 'limited-use' Oracle license, 
which means you can use it for SAP only. 
Todd Carlson Oracle Database 
Administrator Tripos, Inc. (314) 
647-8837 ext. 3246 
-Original Message- Smith 
Sent: Friday, October 26, 2001 3:35 PM To: Multiple recipients of list ORACLE-L 
Does anyone know if we need to buy our licenses separate for 
Oracle when using SAP?  Sometimes, when a vendor 
product runs on top of a database they supply that but I do not think SAP is one.  
Thanks a head of time. 
 Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 
-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.com -- Author: Kimberly Smith   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet access / 
Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send 
the HELP command for other information (like subscribing). 
-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.com -- Author: Todd Carlson   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet access / 
Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send 
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet access / 
Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send 
the HELP command for other information (like subscribing). 

RE: Java in the database

[Jim Conboy]

Christopher-
 
Do you have first-hand experience with the performance of Orion, either 
within iAS or as a stand-alone servlet engine?  The '5x faster' seems to 
come from an Oracle source, which I suspect is referring to Java stored and 
executed within Oracle.  I'm not sure whether Orion as a stand-alone 
product can make the same claim.  Then again I'm a DBA, not an experienced 
Java developer, and am finding it a bit confusing to wade thru the 
alphabet soup.
 
I have a 3rd-party app to install that needs 'any J2EE-compliant' java 
servlet engine.  I'm looking for something that will provide good 
scalability at a good price.  The price is right, if Orion scales well then 
maybe I won't need iAS for this server since I don't need all the other goodies 
that comes along with it.  If you have any real-world indications of 
scalability I'd appreciate hearing from you.  Thanks.
 
Jim
>>> [EMAIL PROTECTED] 10/26/01 02:51PM 
>>>

Take a look at 
OrionServer (www.orionserver.com) 
 at $1,500 / server and 5x faster 
than Web Logic, I would wonder why people would use others.  And OAS9i uses Orion as the core 
now.
 
 

"Do not criticize 
someone until you walked a mile in their shoes, that way when you criticize 
them, you are a mile a way and have their shoes."
Christopher 
R. Spence Oracle 
DBA 
Phone: 
(978) 322-5744 Fax:    
(707) 885-2275 
Fuelspot 73 
Princeton Street North, 
Chelmsford 01863   

-Original 
Message-From: Jim Conboy 
[mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 9:50 
AMTo: Multiple recipients of 
list ORACLE-LSubject: Re: Java 
in the database
 

Jan-

 

I've heard some concerns about the 
scalability of Tomcat as an app server.  Of course, some of those concerns 
are voiced by guys like Oracle and BEA who have a nice little Java engine to 
sell you for $10-20K per CPU.  I know a lot of people use Tomcat for 
prototypes and such, then go with one of the big boys for the production 
system.  Have you - or anyone else - had Tomcat working in a 
production environment with, say, 100-200 concurrent users?  
Thanks.

 

Jim>>> 
[EMAIL PROTECTED] 10/26/01 08:35AM >>>
PL/SQL. 
Java code only on Tomcat-Jakarta (Apache). 
JP 
On Thu 25. October 2001 19:16, you 
wrote: > Out of curiosity, is anyone using the java engine for procedural 
code, or > are most people still using PL/SQL? > > Regards, 
> Patrice Boivin > Systems Analyst (Oracle Certified DBA) > 
> Systems Admin & Operations | Admin. et Exploit. des syst?mes 
> Technology Services    | 
Services technologiques > Informatics 
Branch | Direction de 
l'informatique > Maritimes Region, DFO  | 
Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] 
<mailto:[EMAIL PROTECTED]> 
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan 
Pruner   INET: [EMAIL PROTECTED] 
Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051 San 
Diego, California    -- Public Internet 
access / Mailing Lists 
 To 
REMOVE yourself from this mailing list, send an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send the HELP command for 
other information (like subscribing). 

Re: Java in the database

[Jim Conboy]

Jan-
Please do let us know how you do with 500 users.
"Oracle App Server = Apache + Tomcat"
Is this true?  I know that "Oracle HTTP Server" (ha ha) is 
basically Apache.  And I know that the Oracle Jserver was basically the 
Jserv precursor to Tomcat.  But I thought 8.1.7 and 9i came with a new 
servlet.  I looked on Metalink and couldn't tell, is that 'new' java 
servlet really Tomcat?
 
Jim
>>> [EMAIL PROTECTED] 10/26/01 10:50AM >>>
:-) Wait 2 weeks and I will tell you how 
is it running up to 500 people. 
"Oracle and BEA who have a nice little Java engine to sell you 
" It has only other product name, but inside is it the 
same 
Oracle App Server = Apache + Tomcat 
JP 

Re: Java in the database

[Jim Conboy]

Jan-
 
I've heard some concerns about the scalability of Tomcat as an app 
server.  Of course, some of those concerns are voiced by guys like Oracle 
and BEA who have a nice little Java engine to sell you for $10-20K per 
CPU.  I know a lot of people use Tomcat for prototypes and such, then go 
with one of the big boys for the production system.  Have you - or anyone 
else - had Tomcat working in a production environment with, say, 100-200 
concurrent users?  Thanks.
 
Jim>>> [EMAIL PROTECTED] 10/26/01 08:35AM 
>>>
PL/SQL. Java code only on Tomcat-Jakarta 
(Apache). 
JP 
On Thu 25. October 2001 19:16, you wrote: > Out of curiosity, is anyone using the java engine for procedural 
code, or > are most people still using PL/SQL? 
> > Regards, > Patrice Boivin > Systems Analyst (Oracle 
Certified DBA) > > Systems 
Admin & Operations | Admin. et Exploit. des syst?mes > Technology Services    | 
Services technologiques > Informatics 
Branch | Direction de 
l'informatique > Maritimes Region, 
DFO  | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] 
 
-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com -- Author: Jan Pruner   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet access / 
Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send 
the HELP command for other information (like subscribing). 

RE: providing 24*7 database ---

[Jim Conboy]

Seemed fine when I tried it (and thanks for the idea!).  The trick 
with the indexes is that the ones on the partitioned table have to be local, 
which was in the scripts provided, and the 'exchange partition' had to say 
'including indexes', which was not.  Adding 'including indexes' made this 
work like a charm for me.
 
Jim>>> [EMAIL PROTECTED] 10/24/01 11:25AM 
>>>
I 
couldn't verify that the non-partitioned indexes become unusable after 
exchanging the partition for the normal table.  In the sample I posted 
I snipped the output of the queries on USER_INDEXES and USER_PART_INDEXES, 
but my tests showed that they remain valid.  I'm curious to see why 
your results are different.  Can you post the spooled output of your 
test?
 
Thanks.
Tony 
Aponte

  -Original Message-From: Narender Akula 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 23, 
  2001 10:30 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: providing 24*7 database 
  ---
  Thanks all for the input.
  hi 
  tony ,
  Quick question ... when you exchange partititons with 
  non partitioned table data , all indexes on non partitioned tables become 
  unusable status right.
  do 
  have to rebuild them after every exchnage...
   
  naren
  
-Original Message-From: Aponte, Tony 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, 23 October 2001 
05:06To: Multiple recipients of list ORACLE-LSubject: 
RE: providing 24*7 database ---
We use a modified version of your duplicate schema 
idea.  But we don't have the objects in different schemas.  We use 
partitioned objects so that we can exchange the partitions with the 
production tables at a scheduled time.  The voodoo is that we use a 
single range partition of MAXVALUE and all indexes are LOCAL 
PARTITIONED.  The partitioning key doesn't really matter in this setup 
since we aren't using the features for its advantages, just to be able to 
swap data and index segments on the fly.  I've attached a transcript 
showing the actual sequence but I'll give you a short explanation 
first:
There are production tables/indexes that are used by the 
application, whether directly or via synonyms.  There is a second set 
of tables with a _TEMP suffix that have duplicate structural definitions 
(constraints, column names and data types, etc.)    The 
indexes also end with a _TEMP but are identical to the production 
ones.  The only difference is that they are partitioned 
tables/indexes.  All partitioned objects have a single range partition 
by a bogus column.  The single partition is bounded by the MAXVALUE 
keyword, so all of the data is contained in one partition.
Now you can manipulate the _TEMP tables at your convenience 
without interrupting the access tot he "published" objects.  Once you 
have refreshed your _TEMP objects and are ready to publish the new data your 
would execute a series of ALTER TABLE _TEMP EXCHANGE 
PARTITION TABLE .  That's it.  No re-pointing of 
synonyms, revalidating of views/stored procs./etc.  The application 
keeps chugging along.  The next execution of SQL will use the published 
tables.
HTH Tony Aponte 
** pseudo-attachment 
** 
SQL> create table x(x1 number,x2 varchar2(50)); 

Table created. 
SQL> create index xi1 on x(x1); 
Index created. 
SQL> create table y(x1 number,x2 varchar2(50)) 
  2   partition by range (x1)  
(partition y values less than (maxvalue)); 
Table created. 
SQL> create index yi1 on y(x1)   2  local (partition yi1 ); 
Index created. 
SQL> insert into x values (1,'original data from regular 
table'); 
1 row created. 
SQL> insert into y values (2,'original data from 
partitioned table'); 
1 row created. 
SQL> commit; 
Commit complete. 
SQL> select * from x; 
    X1 
X2   
-- 
--   
 1 
original data from regular 
table 

SQL> select * from y; 
    X1 
X2   
-- 
--   
 2 
original data from partitioned 
table 

SQL> alter table y exchange partition y with table x; 

Table altered. 
SQL> select * from x; 
    X1 
X2   
-- 
--   
 2 
original data from partitioned 
table 

SQL> select * from y; 
    X1 
X2   

RE: Little Brother Larry not really ON topic

[Jim Conboy]

Y'know, Bambi is such a gentle name, but you're scaring me with this 
in-depth knowledge. :-)
 
JIm>>> [EMAIL PROTECTED] 10/19/01 03:59PM 
>>>
Yes, well, I think that they thought that was a pretty snazzy 
way not to pay on life insurance.  In practice, 
though, if you've had your policy more than two years, 
most companies will pay anyway.  It's hard to get a definitive 
yes or no out of them at the time you buy your policy, so it's 
rather the luck of the draw, um, as it were... 

-Original Message- Sent: Friday, 
October 19, 2001 2:42 PM To: Multiple recipients of list 
ORACLE-L 
And you they won't pay your life insuranc to your beneficiaries 
because you died in the commission of a crime..Catch 22 
eh? Ruth - Original Message 
- To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]> Sent: Friday, October 19, 
2001 3:07 PM 
> Suicide is illegal, but, oddly commission of that crime 
lands you in a > mental institution because you are 
mentally unfit to stand trial, and, > except in the 
case of extraordinary extenuating circumstances, is proof of > at least temporary insanity.  This is the mechanism that is 
used to > institutionalize people who attempt, but 
fail, to commit suicide.  This is > also used by 
some insurance companies who will not pay claims for sufferings > incurred in the commission of a 
crime. > > Extraordinary 
extenuating circumstances include (but are not limited to): > Extreme political protest (e.g., the autoimolation of those 
monks); > extraordinary pain and suffering (it's 
still illegal, but won't land you in > a mental institution); suicide attempts immediately prior to 
capital > punishment (they really don't like that 
because they can't execute you until > you're mentally competent to appreciate the punishment you are about 
to > endure and prisoners, instead, are placed on 
suicide watch) > > 
HTH, > Bambi. > 
> -Original Message- > 
Sent: Friday, October 19, 2001 1:15 PM > To: Multiple 
recipients of list ORACLE-L > > Are you sure its not illegal to 'attempt' suicide?  
Granted > that still does not make a whole lot of 
sense but it gives > them a way to get back at you 
for the medical bills and what > not of a failed 
attempt I believe.  So if you do want to do > it 
take the extra time and plan well (not that I think anyone > should do it). > > -Original Message- > Sent: 
Friday, October 19, 2001 10:55 AM > To: Multiple 
recipients of list ORACLE-L > > > No, man, they through your corpse into 
a cell until you learn better. Duh! > > -Original Message- 
> Sent: Friday, October 19, 2001 4:25 AM > To: Multiple recipients of list ORACLE-L > > - Original Message - 
> To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]> > Sent: Friday, October 
19, 2001 00:50 > > 
> > My favorite law is that it is illegal to commit 
suicide. > > > > 
Love that! > > 
> and what happens if u successfully commit one? 
> > will they sue u? 
> > > Marin > 
> >  > "...what you brought from your past, is of no use in your present. 
When > you must choose a new path, do not bring old 
experiences with you. > Those who strike out afresh, 
but who attempt to retain a little of the > old life, 
end up torn apart by their own memories. " > 
> > > 
-- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Marin Dimitrov 
>   INET: [EMAIL PROTECTED] > > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, 
California    -- Public Internet access / 
Mailing Lists > 
 
> To REMOVE yourself from this mailing list, send an E-Mail 
message > to: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in > the message BODY, 
include a line containing: UNSUB ORACLE-L > (or the 
name of mailing list you want to be removed from).  You may 
> also send the HELP command for other information (like 
subscribing). > -- > 
Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bellows, Bambi 
>   INET: [EMAIL PROTECTED] > > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, 
California    -- Public Internet access / 
Mailing Lists > 
 
> To REMOVE yourself from this mailing list, send an E-Mail 
message > to: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in > the message BODY, 
include a line containing: UNSUB ORACLE-L > (or the 
name of mailing list you want to be removed from).  You may 
> also send the HELP command for other information (like 
subscribing). > -- > 
Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith 
>   INET: [EMAIL PROTECTED] 
> > Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, 
California    -- Public Internet access / 
Mailing Lists > 
---

RE: * Oracle DBA Needed in Phoenix..

[Jim Conboy]

Preferably with no close friends or relatives, nobody to notice if you 
just...disappear.
 
Jim>>> [EMAIL PROTECTED] 07/06/01 09:10AM 
orastaff wrote:>We would like to submit someone 
who is a renter and who is interested>in Phoenix but has not applied to 
Phoenix companies and is not working>with>other recruiters for 
Phoenix companies. Is this some super secret job or 
what???-Original Message-Sent: Thursday, July 05, 
2001 3:15 PMTo: Multiple recipients of list ORACLE-LIf you're 
interested in a great opportunity, then consider this position inPhoenix, AZ 
with a leading company that needs an Oracle DBA to join its' I.T. 
staff.We would like to submit someone who is a renter and who is 
interestedin Phoenix but has not applied to Phoenix companies and is not 
working withother recruiters for Phoenix companies. This is a full 
time staff position so no sub-contractors or third 
partiesplease.Please do not call or send a resume if you are not in 
the U.S. and/or need sponsorship.* Requirements:- A degree in 
C.S. or equivalent- 3+ yrs Oracle DBA experience is needed- Strong 
Unix- Application development experience; Unix scripting; C or Perl 
languages   are desirable- Must have good communication skills 
-U.S. citizenship or permanent residency requiredThis position 
is with a  company that offers 
:    
* Quality Work 
Environment    
* Base salary up to 75K-firm +excellent 
benefits    
* Financial 
Stability    
* Some Relocation 
Assistance    
NO sub contracting positions available.PLEASE do not send your resume if 
you are not in the United States.For  immediate consideration, 
please send your resume to:Email: [EMAIL PROTECTED]Phone: 
1-800-549-8502. * Please use job code: One/Phoenix/DBA/CarlosWe pay 
referral fees.So please contact me if you know of anyone who would be 
qualified/interestedin the posiition described above- if it is not a 
match for your skills.Thanks,Bill LawOraStaff, Inc-"The Proven 
Connection To Oracle Opportunity"-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: OraStaff  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
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.com--Author: 
Farnsworth, Dave  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
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: Select only one of three tables

[Jim Conboy]

This could get ugly.  I'm thinking the decode/outer join method won't 
work because there's no table you can reliably use as a base for the outer 
join.  How about:
 
select emp_id, dept from dept_one
union
(select emp_id, dept from dept_two minus select emp_id, dept from 
dept_one)
union
(select emp_id, dept from dept_three minus
    (select emp_id, dept from 
dept_two union select emp_id, dept from dept_one))
/
 
and then go for some coffee if these tables are large at all.
 
Jim
 
 
Hello listI have a scenario in which I have to check three 
tables. If there is recordintable A, take it otherwise check table B, if 
there is record in table B,takeit otherwise check table C. Let say I am 
looking for DEPT column and thetablesare DEPT_ONE, DEPT_TWO, and 
DEPT_THREE. At the end I need only one DEPTcolumn.While I can check 
each of the tables in order I would like to do it in onestatement. I have 
tried DECODE but it did not like combination of count andcolumn names - 
error ORA-00937. To make it simpler here is my query from twotables 
only:select  decode (count(d2.emp_id), 0, d3.dept, d2.dept) 
dept  from dept_two d2, dept_three d3where d3.emp_id =  
TESTER_1'   and d2.emp_id(+) = d3.emp_idCan someone 
recommend a solution?ThanksWitold-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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.com-- Author: 
Nicoll, Iain (Calanais)  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
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: "ALTER SYNONYM"?

[Jim Conboy]

Can you use a view 
instead?
 
SVRMGR> create table temp1 (temp1 varchar2(1));Statement 
processed.
SVRMGR> create table temp2 (temp1 varchar2(1));Statement 
processed.
SVRMGR> insert into temp1 values ('a');1 row 
processed.SVRMGR> insert into temp1 values ('a');1 row 
processed.SVRMGR> insert into temp1 values ('a');1 row 
processed.SVRMGR> insert into temp1 values ('a');1 row 
processed.SVRMGR> insert into temp2 values ('b');1 row 
processed.SVRMGR> insert into temp2 values ('b');1 row 
processed.SVRMGR> insert into temp2 values ('b');1 row 
processed.
SVRMGR> create or replace view temp as select * from temp1;Statement 
processed.SVRMGR> select * from temp;T-4 
rows selected.SVRMGR> create or replace view temp as select * from 
temp2;Statement processed.SVRMGR> select * from 
temp;T-bbb3 rows selected.SVRMGR>
Maybe some unwanted overhead with the 
view, but it might help out.
 
Jim
 
>>> [EMAIL PROTECTED] 06/30/01 04:56PM 
>>>Is there a way to do what would be an ALTER SYNONYM?I've 
got a synonym created that rotates between pointing to two 
differenttables.  Sometimes it points to TABLE_A, sometimes to 
TABLE_B.  (This isso that behind the scenes, I can truncate and reload 
TABLE_A, and thenswap, etc. so the table "never 
disappears".)However, when I want to switch the SYNONYM from pointing to 
TABLE_A topointing to TABLE_B, the only way is to:drop synonym 
table_syn;create synonym table_syn for table_b;Is there a way to 
make that instantaneous for the database?  If someonedoes a select at 
the exact instant between those two commands, it'll errorout, because the 
table "won't 
exist".-Rick+--+| 
Rick Osterberg   
[EMAIL PROTECTED]    
|| Database Applications 
Specialist FAS Computer 
Services   
|+--+-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rick 
Osterberg  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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: Speed up massive delete

[Jim Conboy]

Not sure how this message looked to 
everybody on the list.  When I rec'd it, all I could see was the ALTER 
statements.  But I know that the create statements and direct loads work 
also.  When I went to reply as such, lo and behold the missing 
create/direct load statements appeared as they should.  Just wanted to 
point that out, because Joe as provided the definitive answer, but only if you 
can read his entire response!  Weird.
 
Jim
>>> [EMAIL PROTECTED] 06/28/01 11:06AM 
>>>
ok lets cover this again on unrecoverable/nologging(yes i've 
done the research and demo it in my logminer presentation):
 
 
  

•If I have my table as set to nologging, will my 
DML still show up in the redo logs? 

•Yes it will, which options the nologging option has an effect on 
 


•Only the following operations can make use of the 
NOLOGGING option: 
• alter 
table...move partition 
• alter 
table...split partition 
• alter 
index...split partition 
• alter 
index...rebuild 
• alter 
index...rebuild partition 
 •create table...as select 

• create 
index 
• direct load 
with SQL*Loader 
• direct load 
INSERT 
 
  
Other SQL 
statements (such as UPDATE, DELETE, conventional path INSERT, and various DDL 
statements not listed above) are unaffected 
by the NOLOGGING attribute of the schema object, so yes you DML will 
appear in the redo/archive logs. 

 
joe
 
 
 
>>> [EMAIL PROTECTED] 06/28/01 10:24AM 
>>>Ron,How does creating indexes as UNRECOVERABLE save 
time when you insert data?As far as I'm aware the only operation it will 
save time on is the 
initialcreation.Regards,Mike|+--->|    
|  "Ron Rogers" 
||    
|  
|    
|  
ttery.org>   ||    
|   
||    
|  
06/28/01 
||    
|  02:51 
PM ||    
|  
Please   
||    
|  respond to   
||    
|  
ORACLE-L 
||    
|   
||+--->  
>---|  
|   
|  |   To: 
Multiple recipients of list 
ORACLE-L    
|  |   
<[EMAIL PROTECTED]>  
|  |   cc: 
(bcc: Mike 
Hately/ETECH)    
|  |   
Subject: Re: Speed up massive 
delete    
|  
>---|JackDrop 
the indexes first before you do the deletes will save you time by 
notcreating logs for the indexes being deleted. On my large activity files I 
havecreated the indexes as "Unrecoverable" saving time when I add data or 
deletedata.ROR mªÖªm>>> [EMAIL PROTECTED] 06/28/01 05:45AM 
>>>Hi All,I have to do some pretty big deletes on a 
test environment and they areestimated to take for ever.Are there any 
options to speed it 
up?Jack=De 
informatie verzonden in dit e-mailbericht is vertrouwelijk en isuitsluitend 
bestemd voor de geadresseerde. Openbaarmaking,vermenigvuldiging, 
verspreiding en/of verstrekking van deze informatie aanderden is, behoudens 
voorafgaande schriftelijke toestemming van Ernst &Young, niet 
toegestaan. Ernst & Young staat niet in voor de juiste envolledige 
overbrenging van de inhoud van een verzonden e-mailbericht, nochvoor tijdige 
ontvangst daarvan. Ernst & Young kan niet garanderen dat eenverzonden 
e-mailbericht vrij is van virussen, noch dat e-mailberichtenworden 
overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.Indien 
bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij uvriendelijk 
doch dringend het e-mailbericht te retourneren aan de verzenderen het 
origineel en eventuele kopieën te verwijderen en te vernietigen.Ernst 
& Young hanteert bij de uitoefening van haar werkzaamheden 
algemenevoorwaarden, waarin een beperking van aansprakelijkheid is 
opgenomen. Dealgemene voorwaarden worden u op verzoek kosteloos 
toegezonden.=The 
information contained in this communication is confidential and isintended 
solely for the use of the individual or entity to whom it isaddressed. You 
should not copy, disclose or distribute this communicationwithout the 
authority of Ernst & Young. Ernst & Young is neither liable forthe 
proper and complete transmission of the information contained in 
thiscommunication nor for any delay in its receipt. Ernst & Young does 
notguarantee that the integrity of this communication has been maintained 
northat the communication is free of viruses, interceptions or 
interference.If you are not the intended recipient of this communication 
please returnthe communication to the sender and delete and destroy all 
copies.In carrying out its engagements, Ernst & Young applies 
general terms andconditions, which contain a clause

RE: Speed up massive delete

[Jim Conboy]

Well, that IS true (actually I think 
its NOLOGGING for index creation).  But if you have massive amounts of 
INSERTS or DELETES, dropping the index first and then re-creating can 
help.
 
If the number of deletes is truly 
large, and you've got spare disk space, and the table can be off-line for a 
while, you might try CTAS (create table as select) using UNRECOVERABLE, to make 
a second copy of the table with just the rows you want to keep.  Then drop 
or rename the old table, rename the new table, and re-create the indexes with 
NOLOGGING.  In removing 3 million rows from a 9 million row table this 
method was very fast compared to DELETE.
 
Jim
>>> [EMAIL PROTECTED] 06/28/01 10:58AM 
>>>
Yes that is right. rgds amar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, June 28, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Subject: 
Re: Speed up massive delete 
Ron, How does creating indexes as 
UNRECOVERABLE save time when you insert data? As far as 
I'm aware the only operation it will save time on is the initial 
creation. 
Regards, Mike 
|+---> |    
|  "Ron Rogers" | 
|    
|   
|    
|  
ttery.org>   | |    
|   
| |    
|  
06/28/01 | |    
|  02:51 
PM | |    
|  
Please   | |    
|  respond to   
| |    
|  
ORACLE-L | |    
|   
| |+--->   
>---| 
  
|   
|   |   
To: Multiple recipients of list 
ORACLE-L    
|   |   
<[EMAIL PROTECTED]>  
|   |   
cc: (bcc: Mike 
Hately/ETECH)    
|   |   
Subject: Re: Speed up massive 
delete    
|   
>---| 

Jack Drop the indexes first before you 
do the deletes will save you time by not creating logs 
for the indexes being deleted. On my large activity files I have 
created the indexes as "Unrecoverable" saving time when I add 
data or delete data. ROR 
mªÖªm 
>>> [EMAIL PROTECTED] 06/28/01 05:45AM >>> 
Hi All, 
I have to do some pretty big deletes on a test environment and 
they are estimated to take for ever. Are there any options to speed it up? 
Jack 
= 
De informatie verzonden in dit e-mailbericht is vertrouwelijk 
en is uitsluitend bestemd voor de geadresseerde. 
Openbaarmaking, vermenigvuldiging, verspreiding en/of 
verstrekking van deze informatie aan derden is, 
behoudens voorafgaande schriftelijke toestemming van Ernst & 
Young, niet toegestaan. Ernst & Young staat niet in voor de 
juiste en volledige overbrenging van de inhoud van een 
verzonden e-mailbericht, noch voor tijdige ontvangst 
daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat 
e-mailberichten worden overgebracht zonder inbreuk of 
tussenkomst van onbevoegde derden. 
Indien bovenstaand e-mailbericht niet aan u is gericht, 
verzoeken wij u vriendelijk doch dringend het 
e-mailbericht te retourneren aan de verzender en het 
origineel en eventuele kopieën te verwijderen en te vernietigen. 
Ernst & Young hanteert bij de uitoefening van haar 
werkzaamheden algemene voorwaarden, waarin een beperking 
van aansprakelijkheid is opgenomen. De algemene 
voorwaarden worden u op verzoek kosteloos toegezonden. = 
The information contained in this communication is confidential 
and is intended solely for the use of the individual or 
entity to whom it is addressed. You should not copy, 
disclose or distribute this communication without the 
authority of Ernst & Young. Ernst & Young is neither liable for 
the proper and complete transmission of the information 
contained in this communication nor for any delay in its 
receipt. Ernst & Young does not guarantee that the 
integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or 
interference. 
If you are not the intended recipient of this communication 
please return the communication to the sender and delete 
and destroy all copies. 
In carrying out its engagements, Ernst & Young applies 
general terms and conditions, which contain a clause 
that limits its liability. A copy of these terms and 
conditions is available on request free of charge. = 

-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.com 
-- Author:   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet access / 

RE: exp performance question ( direct=y)

[Jim Conboy]

No, buffer is ignored for 
DIRECT=Y.  But RECORDLENGTH should be set to DB_BLOCK_SIZE, or a multiple 
of it.  I've had dramatic gains in performance doing this.
 
Also, pre-8i you couldn't do 
direct-mode export of LONG fields.  As of sometime in 8i you can (I know it 
works in 8.1.7).
 
Jim
>>> [EMAIL PROTECTED] 06/22/01 04:00PM 
>>>
I dunno. Does the BUFFER still 
matter when DIRECT=Y?
 
If so, I either remove it 
entirely, or multiply it by about a factor of five or so. 
 
my $0.02

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  exp performance question ( direct=y)
  Ron, 
   
  ok i'm now confused, 
   
  exp direct=n|y
  imp no such option
  sql_loader has direct also.
   
  or am i missing something here?
   
  joe
   
  >>> [EMAIL PROTECTED] 06/22/01 03:00PM 
  >>>I thought that DIRECT=Y was for imports only. It makes since 
  because in the import you are placing the data directly into the blocks with 
  out a redo log.I have no idea why there was a difference in the times 
  unless it was the extra overhead for a command that was not used.ROR 
  mª¿ªm>>> [EMAIL PROTECTED] 06/22/01 12:55PM 
  >>>Oracle : 8.0.5Platform : SunCurrently we have 
  cron job every night (starting from 11pm) to do export. I changed the 
  setting "direct" to "y" two days ago while leaving all other parameters 
  unchanged, hoping to gain some performance. I am a bit surprused to find 
  that it did not. It actually took longer to create dump file with less 
  data to export. The whole exp process takes about 2 hours to finish. Yes, 
  there could be lots of other unix processes running during that time. But 
  I would still expect to see some improvement because we are doing this way 
  for quite a while. So my questions are:1. From your "real" export 
  experience, how much performance boost did you see when you set 
  "direct=y"?2. If "direct=y" improves the performance, why would anyone 
  want to use  "direct=n"?Thanks.Guang-- here 
  is my orcle dump file's time stamp:(dmp.1 and dmp.2 are from 
  direct=y,dmp.3, dmp.4 and dmp.5 are from 
  direct=n).-rw-rw-r--   1 
  mt   prog 1042197132 
  Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r--   1 
  mt   prog 1042375633 
  Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r--   1 
  mt   prog 1042556662 
  Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r--   1 
  mt   prog 1034773279 
  Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r--   1 
  mt   prog 1035237986 
  Jun 22 01:22 oracle.dmp.1.gz--here is the parameter 
  file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = 
  YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = 
  YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS = 
  YUSERID = xxx/yyyOWNER = 
  (aaa,bbb)_Get 
  your FREE download of MSN Explorer at http://explorer.msn.com -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
  Guang Mei  INET: [EMAIL PROTECTED] Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  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.com--Author: Ron 
  Rogers  INET: [EMAIL PROTECTED]Fat City Network 
  Services    -- (858) 538-5051  FAX: (858) 538-5051San 
  Diego, California    -- Public Internet 
  access / Mailing 
  ListsTo 
  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: OT - interviewing your superior(fun question)

[Jim Conboy]

He also included something like "in the 
Congress" in his statement, so it was pretty clear he was speaking about 
providing political support as opposed to technological innovation.  If you 
read the transcript there's not much confusion.  But it does make for some 
good jokes.
 
Jim
>>> [EMAIL PROTECTED] 06/21/01 05:46PM 
>>>nope, he said"I played a role in inventing the 
Internet"-Original Message-Sent: Thursday, June 21, 2001 
5:27 PMTo: Multiple recipients of list ORACLE-LI thought he 
invented the internet.  Just ask him.  The best line was "Iknew 
Jack Kennedy and You are no Jack Kennedy" said by Loyd Benson to DanQuayle. 
>>> [EMAIL PROTECTED] 06/21/01 05:13PM 
>>>:), actually if you parrot Gore, it would be"I played a 
role in inventing certifications".The devil is in forgetting the 
details!-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Gene 
Sais  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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.com-- Author: 
Mohan, Ross  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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).

In Praise of Metalink

[Jim Conboy]

Since I've complained loudly when Metalink stinks I feel obligated to give them a pat 
on the back when it works.  And today on three separate occasions it was downright 
snappy.  Anybody else have a similar experience or have I just been inhaling 
controlled substances again?

Jim 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle license costs

[Jim Conboy]

Chaim-

I managed to save hardcopy but not soft, so I can't send it but I can comment.  
Actually, I was surprised at how little difference there was between Oracle and 
SQLServer at moderate usage levels assuming these numbers are accurate and you're 
using a similar server configuration.  At 100 users Oracle was ~64K, SS was 50K, but 
Oracle upgrades are included in support costs while you have to pay 50-75% of new 
price for SS upgrades.  SS support is priced per call, such that after 4 calls per 
month Oracle support is cheaper.  At 200 users you see more of a difference (127K 
Oracle vs 50K for SS) and support breakeven is after 9 calls a month, but if you 
upgrade SS at the 50-75% additional cost the difference starts to go away again.  The 
big difference is as you scale the ladder of licensed users because SS gives an 
unlimited user license, but of course if you have problems getting SS to climb that 
scale then no amount of $$$ will be enough.  I don't have direct experience in that, 
but if you have to buy 5 'low-cost' NT servers (and presumably 5 SS licenses?) to 
replace one  Unix server the economics could get ugly.

Long live free-range fresh-air chocolate-covered Canadian ants!

Jim


>>> [EMAIL PROTECTED] 03/23/01 10:50AM >>>


List,
Recently there was a discussion concerning the cost of Oracle licenses vs MS Sql
Server licenses wasn't there? That discussion was not an issue at my job - until
today which is why I'm wondering if there were any postings that in any shape or
form justified some of the price differential between Oracle and MSSQL? If so,
could someone forward the arguments to me? I would appreciate it very much.

I admit that in the last little while, I was deleting (a little too quickly)
everything that had nothing to do with ants, canada, chocolate factories and
fresh air.

I think what's really  needed is a dba certificate program based on the postings
of this list which would of course include off and on topic material.

Thanks
Chaim
[EMAIL PROTECTED] 


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT: Re: DBA Job at a Chocolate Factory

[Jim Conboy]

Yeah, scofflaw seems to be a common ailment among presidential types.  Our current 
prez is no stranger to the handcuffs either and he and the veep total 5 arrests 
between them.  

Jim

>>> [EMAIL PROTECTED] 03/21/01 12:56PM >>>
I had a short gig setting up a database in Tallahassee State prison. They
had the prisoners entering data for underground utility lines. I had to
train the DBA who was in for 10 years for 3 counts of assault and battery.
That was like being on another, very bad, planet.
If anyone has any intrest in commiting crimes (unless you're a certain
recent former President then you can do whatever you want without fear of
justice) I urge you to tour such a facility. You'll never have an intrest
in commiting crime again.

-Rocky

--- Steve Orr <[EMAIL PROTECTED]> wrote:
> Seven years ago I was offered an Oracle DBA job at a chocolate factory
> and
> turned it down. (Please don't tell Rachel, she already thinks I'm
> crazy.) I
> had two simultaneous offers for the same salary and took the one closer
> to
> home. While on the interview they gave me the full tour of the factory
> starting with the bags of cocoa beans on the docks. The smell was
> intoxicating and even wafted into the office area where I would have
> worked.
> They had unlimited stashes of chocolate in every cubicle. I asked the
> employees if they ever got sick of chocolate and the answer was a
> resounding
> NO. Now my kids will never forgive me for not having taken the job at
> the
> chocolate factory.
> 
> This begs the question... Where and what are some of the most
> interesting
> Oracle DBA jobs out there? I heard of one deep underground at a mining
> operation in the middle of the Nevada desert. Database is a basic
> technology
> that can be applied to just about any business anywhere. Any interesting
> stories? Personal experiences?
> 
> 
> Steve Orr
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Steve Orr
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Long Problem??

[Jim Conboy]

Might find the URL below useful.  Its a perl script for selecting or inserting LONG 
RAW but you should be able to adapt it without too much trouble.

http://www.orafaq.com/scripts/perl/blob.txt 

Jim

>>> [EMAIL PROTECTED] 03/16/01 10:15AM >>>
Maybe you can do it from within PL/SQL -- the maximum for a string literal
in PL/SQL is 32K.

The only alternative that I know of is to use ProC or another external
program.  Anyone else know?

Diana

-Original Message-
Sent: Thursday, March 15, 2001 11:01 PM
To: Multiple recipients of list ORACLE-L


Hello Gurus
This is my Oracle prblem.

there's a column with Long Datatype in a table in Oracle 8 i and I am
inserting data into this table.

insert into Tname (longcol) values('aklajkhsajdsaj')
The Long column is only allowing me to enter a max of 4000 characters as teh
value. The minute the no of characters becomes > 4000, I get an error saying

ORA - 01704: String Literal too Long

 I have to insert data into this freaking column, and its definetely gonna
be > 4000 characters. help me


This is an SOS !!


Vishak



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Diana Duncan
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Listener consolidation

[Jim Conboy]

Stephen-

What kind of errors did you get?  Off the top of my head I believe 8i's tnsnames.ora 
syntax requires you to call your connection data a service_name instead of a sid.  
Probably some other minor but critical changes to how the config files work.  Not sure 
why tnsping would work and other stuff wouldn't but I don't know what error you got.

Jim

>>> [EMAIL PROTECTED] 03/12/01 06:46PM >>>
Hi all:

Our listeners have evolved over time, whereby when we moved from 8.0 to 8.1, a new 
listener was created to support this instead of having one listener listening to all 
databases of different versions.  We are trying to consolidate so that we only are 
running one listener (8.1) and it is listening for 8.1 and 8.0 databases.  I also just 
found out we may need to also include a 7.3 database.  

Our initial test today gave us all kinds of problems where when we moved an 8.0.4 
database out of the 8.0 listener into the 8.1 listener, it wouldn't allow sqlnet 
connections.  However TNSPING worked just fine.  

Does anyone have any hints for doing this?

FWIW, consolidating to a single listener is only the first step.  Once we are 
comfortable that this process is working well, we are going to begin moving all db's 
that will support it to LDAP.

Help?  Thoughts?  Guidance?  All would be appreciated greatly.




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  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Deployment of Oracle Client

[Jim Conboy]

How do most organizations deploy sqlnet client to a large user base?  We've currently 
got hundreds, maybe thousands of users with various versions of the client installed 
on their desktop.  We're also about to roll out Windows 2000 to a large percentage of 
these users.  In testing we've determined that earlier desupported client versions 
(7.3.4 and such) seem to work on W2K with the apps currently deployed.  I'm not happy 
with a "cross your fingers and hope" approach and have been pushing to get most users 
up to 8i as a client.  Ideally I'd like to have something the users can download and 
install from the intranet.  In searching technet downloads all I find is the entire 
bloated 200MB Oracle Client as a download - much too big for our remote users to 
download and install.  All I want is the Net8 pieces I'd need for sqlworksheet, or 
TOAD, or an ODBC connection, so that the download and install time would be within 
reason.  Anybody have suggestions?  How are people on this list deploying Oracle apps 
to many users?  Thanks.

Jim

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: (Fwd) Oracle's Savings Don't Add Up

[Jim Conboy]

Well well well.

I'm quite distressed to hear that Oracle's been shutting down and selling off servers 
like mad, but Metalink doesn't have the hardware it needs to run smoothly.  And some 
of their 'savings' are not spending less but keeping costs growing slower than 
revenues.  Reminds me of when my wife 'saves' a bundle on furniture, hard to retire on 
that kind of 'savings'.  But on the whole Oracle's cost-cutting seems pretty 
impressive and I don't think they deserved the negative headline.  If it keeps my 
bills from climbing even higher I'm all for it.

Jim

>>> [EMAIL PROTECTED] 03/09/01 02:05PM >>>

--- Forwarded message follows ---
To: [EMAIL PROTECTED] 
Date sent:  Fri,  9 Mar 2001 02:04:02 -0500 (EST)

TODAY'S NEWS

*  Oracle's Savings Don't Add Up
*  Web-Powered HR
*  TRANSFORMATION TODAY: Collective Wisdom
*  OPINION: Want E-Biz Influence? Be Ready For The Fallout
*  How Wall Street Reacted
=

...

***
Oracle's Savings Don't Add Up

Don't buy into Oracle's claims that it's saving billions of dollars by implementing 
its own e-business software. Much of the savings actually have come from cost-cutting 
measures that could have been achieved without the Internet, according to experts and 
an analysis of Oracle's financial 
statements.

Oracle has achieved impressive savings--hundreds of millions of dollars, in fact--by 
re-engineering business processes around the Internet. But it looks like Oracle isn't 
going to slide in safely this year or next on the many more billions it has promised 
to save.--Mitch Wagner

So where's the money? Read on:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30LbsD 

Do you believe Oracle's claim that it's saving billions of dollars through the use of 
its own software and the Internet? Answer our Reader Poll:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30LbtE 
 **

...


=
This issue is sponsored by NetReality,
Provider of the WiseWan application Priority Switch
Are your mission-critical applications running slow? Are you tired of
wasting precious dollars on unecessary bandwidth? SPEED SAP --
BOOST BAAN -- SUPERCHARGE CITRIX NetReality brings network
delivery assurance and allows you to control business priorities--in 
real time. For a FREE QoS analysis, log on to:
http://update.internetweek.com/cgi-bin4/flo?y=eCsd0BdpN70V30DURJ 

=

...

This message powered by FloNetwork
http://www.flonetwork.com 
--- End of forwarded message ---


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Licensing

[Jim Conboy]

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Diana Duncan
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Steve Cawley
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim Conboy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: MetaSlop

[Jim Conboy]

I would not leave the impression that I was trying to blame recent problems solely on 
increasing usage.  I doubt this week is THAT much worse than 3 weeks ago when Metalink 
was slow but usable.   And I might acknowledge a little more culbability in bringing 
about the current situation - force-feeding virtually all support to the Web, 
collecting money up front, which ought to give a decent indication of potential 
demand, then failing to make provisions to supply the necessary services.  I'm certain 
that its not easy, but it ain't cheap either and we don't get rebates, so I'm not 
disposed to be real understanding.

Jim

>>> [EMAIL PROTECTED] 02/27/01 03:20PM >>>
And if you were running a comparable system, what would *you* say?


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED] 
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Tuesday, February 27, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L


Man, these guys just invite the wise-ass comment, don't they?  Such as:

Well maybe if the product worked better/was less confusing/had better
documentation we wouldn't all be in Metalink!
Oh no!  If 4 new servers brought the system to its knees just think how bad
it'll be when the rest of the hardware arrives!
4 new top-of-the-line servers, just think what that'll do to their power
unit charges!

Plus I can't rid myself of the image of us all 'staggering' to Metalink for
help.

Jim

>>> [EMAIL PROTECTED] 02/27/01 01:21PM >>>
For those interested, right from the horses mouth, or other orifice as you
desire:

News & Notes
  MetaLink Performance - An Update



  We apologize for the slow response times recently on MetaLink. All over
the
world our customers are coming to and using this valuable
  knowledge base in staggering numbers. Our Global IT team are working these
performance issues as their number one priority.

  What is Being Done
  This week four new front-end web servers were brought on line to help
manage
the load. Additional hardware has been purchased and will
  arrive soon which will make a significant improvement in performance.

  We appreciate your patience during this time of significant growth in
MetaLink
usage.

  Thanks,
  The MetaLink Team

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim Conboy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: MetaSlop

[Jim Conboy]

Man, these guys just invite the wise-ass comment, don't they?  Such as:

Well maybe if the product worked better/was less confusing/had better documentation we 
wouldn't all be in Metalink!
Oh no!  If 4 new servers brought the system to its knees just think how bad it'll be 
when the rest of the hardware arrives!
4 new top-of-the-line servers, just think what that'll do to their power unit charges!

Plus I can't rid myself of the image of us all 'staggering' to Metalink for help.

Jim

>>> [EMAIL PROTECTED] 02/27/01 01:21PM >>>
For those interested, right from the horses mouth, or other orifice as you
desire:

News & Notes
  MetaLink Performance - An Update



  We apologize for the slow response times recently on MetaLink. All over the
world our customers are coming to and using this valuable
  knowledge base in staggering numbers. Our Global IT team are working these
performance issues as their number one priority.

  What is Being Done
  This week four new front-end web servers were brought on line to help manage
the load. Additional hardware has been purchased and will
  arrive soon which will make a significant improvement in performance.

  We appreciate your patience during this time of significant growth in MetaLink
usage.

  Thanks,
  The MetaLink Team

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Am I too hard on the developper ?

[Jim Conboy]

Consider yourself lucky.  Last week I had a doh!veloper tell me (I swear I'm not 
making this up) that he had to test his code in production because "the test 
environment got messed up and its too hard to figure out how to make it right again".  
He's a really junior guy and actually quite brilliant so I was gentle with him, but 
now I'm REALLY worried about who's example he was following.

Jim

>>> [EMAIL PROTECTED] 02/16/01 12:26PM >>>
Yeah but it is so much work to add 10 new fields .

The latest one is 'Do we have a tool that can compare
the dev and the test environment so we know what we
have to put in test ?' .

Not only it is too hard to do 10 alter tables but also
it is too hard to make a list of what is changed (I'm
not even talking about planning stuff).

Here, the 2/3 of IT is from one of the biggest
consultant firm (Cap Gemini Ernst and Young, oups it
slips out ...) so 99.9% of the 2/3 are developpers
asking questions like " Can you tell me again the
difference between a primary key and a foreign key".

It's 18:20 , I'm going home and I'll send a less nasty
email on monday morning.



--- [EMAIL PROTECTED] a écrit : > 
> Stay on it.  Dropping tables to add columns in
> development is just plain stupid.
> 
> Jared
> 
> On Fri, 16 Feb 2001, [iso-8859-1] paquette stephane
> wrote:
> 
> > Hi,
> >
> > I do not know if it's friday afternoon or what ?
> > The developpers want me to regenerate the grants
> in
> > the development environment because they're
> running a
> > script that drops and recreates a new version of
> the
> > tables.
> > I asked them : Could you do an alter table instead
> ?
> >
> > The developpers : What ! they'are at least 10 new
> > fields !
> >
> > I used to be a developper, I do not remember
> myself
> > dropping and recreating everything each time I add
> a
> > new field . Anyway in production, only the new
> stuff
> > goes in.
> >
> > Any comments ?
> >
> > =
> > Stephane Paquette
> > DBA Oracle
> > [EMAIL PROTECTED] 
> >
> > __
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail
> - only $35
> > a year!  http://personal.mail.yahoo.com/ 
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com 
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> >   INET: [EMAIL PROTECTED] 
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> >
> 


=
Stephane Paquette
DBA Oracle
[EMAIL PROTECTED] 

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED] 

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

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle on Unix

[Jim Conboy]

FYI, the box of 817 CDs I got included a sheet of paper warning you to cd out of the 
cdrom directory before trying to switch CDs.

Jim

>>> [EMAIL PROTECTED] 02/07/01 03:45PM >>>
Yes,
The java installer is the same look and feel across all platforms.  With
8.1.7 you have 2 CD's on some systems.  Therefore in order to switch CD's
mid install you need to issue the runInstaller command from a directory
other than the CD-ROM.  Such as:
$ cd /home/oracle
$ /cdrom/runInstaller
Doing this allows you to unmount the cdrom and switch cd's when you need to.
This info is not in the readme's.  It was not on metalink the last time I
checked.  And, as you would expect, you need to talk to 3 different support
techs to get someone aware of this little trick.

Rodd Holman

-Original Message-
Sent: Wednesday, February 07, 2001 2:09 PM
To: Multiple recipients of list ORACLE-L


Dear All,

I've been working with Oracle on NT for years, never had the one on unix.
Now, I am trying to use the one on Linux. I see that the installation screen
is just the same as on NT. Is this also the same with other unix platform
such as AIX, Solaris, HP-UX, etc?

TIA

Nosie



Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED] 
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl 



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Holman, Rodney
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to use Export Transportable Tablespaces

[Jim Conboy]

There are straightforward examples in the 8.1.7 documentation.  I don't know if that 
feature is available in 8.1.6.  But regardless, you should investigate WHY the 
fromuser/touser didn't achieve the desired results or I fear you'll be disappointed 
again.

Jim

>>> [EMAIL PROTECTED] 02/06/01 12:22PM >>>

Does anyone have an example of how to use transportable tablespaces with
export/import.

I want export a user (8.1.6 database) source and import fromuser
touser(8.1.6 database) target.

I tried to import fromuser/ touser, but many contraints were not created and
lost some data
so I was told to try transportable tables. Can't find any good examples on
how to use this new
feature.

Can someone please help me.

Thanks
Larry





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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).