Re: net 8 / 8i ?

2001-08-20 Thread Paul Drake
"Browett, Darren" wrote: > > We are running 8.0.5 and due to upgrade fatigue on our applications, we are > at least one year away before we upgrade > to 8i and/or possibly 9i. > > But we are upgrading our desktops to windows 2000. > > The question I have, > > 1. Should I install the net 8.0 cl

Re: changing long to lob

2001-08-20 Thread chao_ping

Oracle for Solaris (on Intel)

2001-08-20 Thread Clinton Naude
Hi all.   I sent out a mail recently about Oracle for Solaris on Intel, but never saw any replies.   Has anyone got any facts/info on this. What are the pro's and cons?   Thanks.   Clint

Re: Substitute for Materialized Views/Snapshots?

2001-08-20 Thread Chris Rezek
I don't know what to say. When I ran the exact SQL just now it worked - no errors at all. So it seems that MATERIALIZED VIEWs *are* available in SE. Very good news. Thank you especially to Anita who kept insisting that the statement should work. Chris Chris Rezek wrote: > > The error is: >

Freelist Contention

2001-08-20 Thread Viraj Luthra
Hello folks, How do I come to know that there is a contention going on in the freelists? Is there any v$ table or this type of contention you derive from some other info. like a ripple effect from some parameter? TIA. raja Get 250 color business cards for FREE! http://businesscards.lycos.co

RE: changing long to lob

2001-08-20 Thread Jon Walthour
Title: Message Joe:   Can you tell me if you were able to do this? I just tried it and it errored out on me:   SQL> create table test_lob (col1 varchar2(30), col_lob long);   Table created.   SQL> desc test_lob Name  Null?    Type 

RE: net 8 / 8i ?

2001-08-20 Thread Jon Walthour
> 1. Should I install the net 8.0 client on the base image and upgrade it to 8i later ? Yes. Go ahead and get it over with. > 2. Should I go ahead and install the 8i client on the base image and be done with it. > The larger question being will the 8i client work with the 8.0 databases ?? Yes

RE: net 8 / 8i ?

2001-08-20 Thread George Hofilena
I'd go for option 1 George -Original Message- Sent: Monday, August 20, 2001 4:41 PM To: Multiple recipients of list ORACLE-L We are running 8.0.5 and due to upgrade fatigue on our applications, we are at least one year away before we upgrade to 8i and/or possibly 9i. But we are upgrad

net 8 / 8i ?

2001-08-20 Thread Browett, Darren
We are running 8.0.5 and due to upgrade fatigue on our applications, we are at least one year away before we upgrade to 8i and/or possibly 9i. But we are upgrading our desktops to windows 2000. The question I have, 1. Should I install the net 8.0 client on the base image and upgrade it to 8i

RE: OT: DBA tasks

2001-08-20 Thread Stephen Andert
Zig Ziglar (a great motivational speaker in case you aren't familiar with the name) refers to his wife of many years as a decided red-head "That is one day she woke up and decided to be a red-head." Stephen If you have any questions, please feel free to call me or drop me a note. Stephen And

Re: Substitute for Materialized Views/Snapshots?

2001-08-20 Thread Chris Rezek
The error is: SQL> create materialized view test_age as select * from age; ORA-12028: snapshot type is not supported by master site Chris Rezek wrote: > > Anita, > > I would be a very happy man today if snapshots existed in SE. However, > I have verified the non-existence of snapshots in SE

Re: Recovery Question

2001-08-20 Thread Peter Gram
Title: RE: Recovery Question Hi Kamel No,  when using backup control file you are telling oracle that it should not trust the control file to know when to end the recovery. The recovery will keep on asking for archive log files until there are now more archivelogs and since it dos not know wher

Re: How to sign-off this group?

2001-08-20 Thread Jared . Still
Better wear that bite-guard Scott. Jared Scott Shafer

Re: Differences in sql server2000 and oracle8i

2001-08-20 Thread Jared . Still
Your best bet is to look at the new features for 9i at otn.oracle.com. If damagers are trying to decide between MS Sql and Oracle, use the latest product offering. How about: Java in the database. You won't find *that* in SQL Server. iFS: Internet File System iAS9i - it's a rather powerf

RE: High DML Table - Suggestions??

2001-08-20 Thread Hillman, Alex
Also I would have high PCTFREE to lessen number of records per block - if you will have a lot of buffer busy waits. If you have enough memory - simply increase size of KEEP pool to get enough space for needed number of CR blocks. You will have to experiment with size of KEEP pool and v$buffer_pool

RE: Can PL/SQL sp read UNIX env variable?

2001-08-20 Thread Gogala, Mladen
You can write a C program and map it to a PL/SQL procedure, but "getenv" will only get variables defined at the moment when the TNS listener was started. > -Original Message- > From: Greg Moore [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 20, 2001 5:42 PM > To: Multiple recipients of

Re: High DML Table - Suggestions??

2001-08-20 Thread Walter K
Good point about the FKs. Fortunately, the table is stand-alone is is not a parent or a child of any other table. I thought about initrans and freelists but the table will only be touched by a single user process which is running in the background performing all of the DML transactions, much like

RE: Recovery Question

2001-08-20 Thread Koivu, Lisa
Title: RE: Recovery Question But don't you end up with an incomplete recovery then? AJ -Original Message- From:   Peter Gram [SMTP:[EMAIL PROTECTED]] Sent:   Monday, August 20, 2001 5:56 PM To: Multiple recipients of list ORACLE-L Subject:    Re: Recovery Question Hi Kame

RE: UTLB/E stat

2001-08-20 Thread Koivu, Lisa
Title: RE: UTLB/E stat Joe, these are values to always be ignored, along with rdbms ipc message, sql*net message from client.  Check out note 62161.1 on Metalink.  could you ask for a better answer ?!  Lisa Koivu aka Lara Croft, DBA Ft. Lauderdale, FL, USA Also, From the Fine Manual p

Re: High DML Table - Suggestions??

2001-08-20 Thread Christian Trassens
Don't put it in a buffer keep because of the amount of consistent gets the table could have. It seems to be a high volatile table. Maybe it is too late but you should look on the initrans, freelist of the table. Also if the table has foreign keys, talk with Development to leave the table without

Re: Recovery Question

2001-08-20 Thread Peter Gram
Hi Kamel You have to tell oracle that the controlfile is not originale one by using "recover database using backup controlefile" GL2Z/ INF DBA BENLATRECHE wrote: >Hi List, > > I am testing one situation where : > >- The database is in archive log mode, >- I have a cold backup of all t

UTLB/E stat

2001-08-20 Thread Joe Frohne
Hi, I have been looking over report.txt output for some of my instances. I am wondering if anybody can tell me about the system wide wait events for the events named pmon timer smon timer I don't know much about what this information portrays. The reason I even ask is on one instnace the valu

Can PL/SQL sp read UNIX env variable?

2001-08-20 Thread Greg Moore
I want to add code to a PL/SQL stored procedure so it can read a UNIX environment variable. Is this possible? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 Sa

High DML Table - Suggestions??

2001-08-20 Thread Walter K
Hi, I have a table that is going to have a large amount of inserts, updates and deletes performed against it daily. Approximately 1,000,000 transactions per day (some single-record, some multi-record). The table is ~100Mb in size. I'm looking for some suggestions on what I can do to have the mos

RE: Performance analysis (enqueue and buffer busy waits)

2001-08-20 Thread Gogala, Mladen
Increase the "snapshot too old" query mortality rate? > -Original Message- > From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 20, 2001 9:22 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Performance analysis (enqueue and buffer busy waits) >

RE: environmental variables

2001-08-20 Thread Mercadante, Thomas F
Lyuda, I have exactly these type of environmental files on my NT server. The PATH on the NT server is altered to include the directory where these files exist. I have one file for each database instance on each server. For example, the listing below is the WTWD.BAT file (representing the WTWD

Oracle Acquires 'Seminal' E-Commerce Patent

2001-08-20 Thread Glenn Travis
http://www.internetnews.com/intra-news/article/0,,7_868161,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

RE: environmental variables

2001-08-20 Thread lhoska
John, may be it is a dump question.. but... there are certain directories my variables would go under. Note: I am declaring custom environmental variables. How do I address this issue? -Original Message- Sent: Monday, August 20, 2001 3:12 PM To: Multiple recipients of list ORACLE-L Sim

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Grabowy, Chris
Title: RE: OT: DBA tasks..turning into Tivo. Lisa,   There are options within Tivo so that you can tell it which channels you dont get.  Also, it needs to know if your using Basic, or Extended Basic, what pay channels, etc.   Yes, it tries to record stuff that you like.  Like I selected Tenn

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Grabowy, Chris
Title: RE: OT: DBA tasks Nothing for DISH.  Probably never will be.  Direct TV and Tivo probably have an exclusive greement. -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001 3:22 PMTo: Multiple recipients of list ORACLE-LSubject: RE:

Re: How to sign-off this group?

2001-08-20 Thread Jon Walthour
Read the bottom of your email. > > From: Ben Le <[EMAIL PROTECTED]> > Date: 2001/08/20 Mon PM 04:04:08 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: How to sign-off this group? > > Would some one please tell me how to sign-off this group. It was a > pleasure to b

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Grabowy, Chris
Title: RE: OT: DBA tasks As for the recording time, its 30 hours.  There's another model that does 60 hours.    The 30 hour model gives you about 18 hours worth of decent recording quality.  So it truly not 30 hours, unless you only record cartoons or something like that.  Regardless, I ca

Re: How to sign-off this group?

2001-08-20 Thread Scott Shafer
Must... resist... temptation... Ben Le wrote: > > Would some one please tell me how to sign-off this group. It was a > pleasure to be in this excellent group in the past years. Thank you. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ben Le > INET: [E

RE: How to sign-off this group?

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

Re: linux

2001-08-20 Thread Oliver Artelt
Hi, I've heard on a OpenBSD mailinglist about such thing. Seems that they've made it after some adjustments. Go to the FreeBSD mailinglists for these questions. oli [EMAIL PROTECTED] wrote: > Hi Friends, > I have small clarification to be made. > Can oracle for linux soft

changing long to lob

2001-08-20 Thread JOE TESTA
while looking thru the migration guide(for downgrade info in case it happens),   alter table modify clob;   and supposedly POOF its now a clob.   interesting.   joe  

RE: How to sign-off this group?

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

OT -- Does PlumTree use Oracle Portal

2001-08-20 Thread Boivin, Patrice J
Does PlumTree rely on Oracle Portal? Just wondering, they are listing IBM as one of their partners, but not Oracle... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques

RE: OT: DBA tasks

2001-08-20 Thread Rachel Carmichael
Grandpa was a redhead... I was born brunette but when I get in the sun it goes red... so I sometimes "help it along" >From: "Koivu, Lisa" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT: DBA tasks >Date: Mon, 20

RE: OT: DBA tasks

2001-08-20 Thread Rachel Carmichael
rats! you figured out my secret :) >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT: DBA tasks >Date: Mon, 20 Aug 2001 11:22:05 -0800 > >didn't Barbies "slutty" friend have that bright re

Re: Substitute for Materialized Views/Snapshots?

2001-08-20 Thread Chris Rezek
Anita, I would be a very happy man today if snapshots existed in SE. However, I have verified the non-existence of snapshots in SE by: (1) running basic create statements and having them fail and (2) filing an iTAR about the existence of snapshots/MVs in SE and receiving an answer of 'no' an

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Koivu, Lisa
Title: RE: OT: DBA tasks..turning into Tivo. What do you mean?  AFAIK it will record ~30+ hours of programming.  Is that what you're asking?  I'm not sure about Dish. -Original Message- From:   Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent:   Monday, August 20, 2001 3:22 PM To: Multi

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Koivu, Lisa
Title: RE: OT: DBA tasks..turning into Tivo. Zapped card that allows you to get EVERY channel, and the adapter that stops DirecTV from zapping your card to nothing (in other words, they caught you).  Then you have to get another card from DirecTV or buy it from someone.  I'm kinda glad we do

RE: OT: DBA tasks

2001-08-20 Thread Koivu, Lisa
Title: RE: OT: DBA tasks  I'm only blonde on football game days, when I put on my blonde stripper wig and braid it :)  A nice Nicole Kidman red would be a wise choice. I'm brunette and proud of it!  Just anything but blonde.  HA -Original Message- From:   Rachel Carmichael [SMTP:[EM

RE: Performance analysis (enqueue and buffer busy waits)

2001-08-20 Thread Post, Ethan
In regards to my last post, here is an example of the type of statement that is killing my CPU. #! ITEM/CUSTOMER KEY ID MASTER FILE SELECT * FROM CRPDTA.F4094 WHERE ( KIPRGR = :KEY1 AND KIIGP1 = :KEY2 AND KIIGP2 = :KEY3 AND KIIGP3 = :KEY4 AND KIIGP4 = :KEY5 AND KICPGP = :KEY6 AND KICGP1

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Kevin Lange
Title: RE: OT: DBA tasks What has the recording time on Tivo gotten up to and does it work on all satelite systems ??   I have Dish and I know there is a package for Direct TV and Tivo ... but not sure if Dish is supported. -Original Message-From: Grabowy, Chris [mailto:[EM

RE: OT: DBA tasks

2001-08-20 Thread Mercadante, Thomas F
didn't Barbies "slutty" friend have that bright red hair? I think her name was "Easy". :) (ducking and heading out the door) -Original Message- Sent: Monday, August 20, 2001 2:51 PM To: Multiple recipients of list ORACLE-L you go girl! :) do I have to have Barbie-blond hair thoug

Re: RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

2001-08-20 Thread Jon Walthour
Rich: Please let me know if the problem goes away for you with any of the patches or if the only real fix is to go to 9i. Jon Walthour > > From: "Jesse, Rich" <[EMAIL PROTECTED]> > Date: 2001/08/20 Mon PM 01:32:30 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE

RE: environmental variables

2001-08-20 Thread Mercadante, Thomas F
Lyuda, I do it all the time. Not exactly what type of environmental you want to create, but you can always do something like: echo set oracle_sid=Prod > setsid.bat call setsid.bat Is this what you mean? I do this as well as echo sql commands to an output file, and run the sql thru sqlplus.

Re: environmental variables

2001-08-20 Thread Jon Walthour
Simple. Put them in a batch file: @echo off set env1 = One set env2 = Two set oracle_sid = mydb ... Then reference like normal C:\> echo %oracle_sid% mydb Jon Walthour > > From: [EMAIL PROTECTED] > Date: 2001/08/20 Mon PM 02:36:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT

RE: PS lock

2001-08-20 Thread Li, Xiangli
No, I didn't get enqueue waits. rgds, Li > -Original Message- > From: Diego Cutrone [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 15, 2001 4:48 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: PS lock > > Hi, > PS lock is related to Parallel Slave Synchroniza

Re: OT: DBA tasks

2001-08-20 Thread Rachel Carmichael
you go girl! :) do I have to have Barbie-blond hair though? I'm thinking a nice, brilliant red myself >From: "Koivu, Lisa" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: OT: DBA tasks >Date: Mon, 20 Aug 2001 09:38:58 -0

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Grabowy, Chris
Title: RE: OT: DBA tasks While that's a great feature.  I like the ability of Tivo to pick up shows that you like, based on your own tastes that it "learns".  Almost on a weekly basis it captures some movie that I have never seen or saw many years ago.  And then I will watch it that night, o

Re:Get Network Not OK : "ORACLE OCI "

2001-08-20 Thread dgoulet
Stephane, Sounds like they maybe getting an ORA-20102 navigation error which would be indicatative of a bad TNSnames.ora file or if it's on teh extranet, are you using DNS or Oracle Names? Most of those will not work through a firewall. Dick Goulet Reply Separator__

RE: OT: DBA tasks

2001-08-20 Thread Kevin Kostyszyn
Yeah, but she'd still be pretty hot? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Monday, August 20, 2001 2:22 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT: DBA tasks Barbie proportioned body, thats just nasty

RE: OT: DBA tasks

2001-08-20 Thread Grabowy, Chris
Ken, I do not believe that is an option. Perhaps version 2.5 will have that. They have message boards at www.tivo.com, so you may want to post the question there. Thanks. Chris -Original Message- Sent: Monday, August 20, 2001 2:03 PM To: Multiple recipients of list ORACLE-L Angelin

environmental variables

2001-08-20 Thread lhoska
Is there any way to create NT environmental variables through script? Lyuda Hoska -- 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 Inte

RE: Interview Queries

2001-08-20 Thread Christopher Spence
Exactly. Focus on ACID theory and steps of normalization. Also how to resolve common design issues. A good data architect may NOT even need to know sql. "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 sho

Re: OT: DBA tasks

2001-08-20 Thread JOE TESTA
Barbie proportioned body, thats just nasty, waist is way to skinny :)   joe >>> [EMAIL PROTECTED] 08/20/01 01:38PM >>> Ahem...  the female DBA's save the database, save the world, flatten the evil people with her well-tuned martial arts skills, swims in icy cold water without showing one goos

RE: OT: DBA tasks

2001-08-20 Thread Koivu, Lisa
Title: RE: OT: DBA tasks Nope, not yet.  When (and if) that happens, the advertising companies and networks are going to scream bloody murder. However, you can turn on a program, wait 10 minutes, and then watch the entire thing fast-forwarding thru all commercials.  Super slick.  by far the

Re: linux

2001-08-20 Thread Joe Raube
There has been some success with 8.0.5 on FreeBSD, but little to none with 8i. -Joe --- Saravana Kumar <[EMAIL PROTECTED]> wrote: > Hi Friends, > I have small clarification to be made. > Can oracle for linux software be intalled on FREE BSD. > > Thanks in advance > > Sarav

RE: Performance analysis (enqueue and buffer busy waits)

2001-08-20 Thread Post, Ethan
FYI, in a previous message I detailed some of the tuning efforts we have been working on in regards to getting a EDI sales order processing job to process 150,000 lines per hour. Well the major point of contention was freelists. We went from 250 lines per minute to over 1500 lines per minute sim

Summary advisor question

2001-08-20 Thread JOE TESTA
Is anyone using this (or dbms_olap.recommend_mv) successfully.   I"m getting a ORA-30479: Summary Advisor errorQSM-00511: invalid fact-tables specified in fact-filter   after RTFM and battling with it for a week, i've come to the experts.  I've got a simple time table and create a time dimens

RE: DBA tasks

2001-08-20 Thread Page, Bruce
Hey, Oracle IS a company based in San Francisco. > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 20, 2001 1:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: DBA tasks > > > ahem... "get the girl" > > lol -- Pl

Re: OT: DBA tasks

2001-08-20 Thread kjanusz
Angelina: Do you know if your can setup your TIVO box so that it can automatically ignore commercials when recording? If, so how do you do that? Thanks, Ken Janusz, CPIM > Ahem... the female DBA's save the database, save the world, flatten the > evil people with her well-tuned martial arts s

RE: DBA tasks

2001-08-20 Thread Thater, William
At 01:38 PM 8/20/2001, Rachel Carmichael wrote: >ahem... "get the girl" > >lol well, now, they didn't define "get" now did they?;-) -- Bill "Shrek" Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] -

OT: DBA tasks

2001-08-20 Thread Koivu, Lisa
Title: OT: DBA tasks Ahem...  the female DBA's save the database, save the world, flatten the evil people with her well-tuned martial arts skills, swims in icy cold water without showing one goose pimple on her Barbie-proportioned body, impresses the Diet Coke guy, and then tells him "thanks b

Re: Interview Queries

2001-08-20 Thread DBarbour
You want this person to design the database or develop against it? I'd skip the "finer" points of SQL and concentrate on stuff like normalization/de-normalization. David A. Barbour Oracle DBA, OCP AISD 512-414-1002

Re: Followup: Database upgrade w/ standby

2001-08-20 Thread Rachel Carmichael
nice when things actually work :) one for our side! >From: "Hand, Michael T" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Followup: Database upgrade w/ standby >Date: Mon, 20 Aug 2001 08:31:27 -0800 > > >The patch leve

Re: slick looking website - VOUG - Portal

2001-08-20 Thread Rachel Carmichael
MUCH better :) >From: Paul Drake <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: slick looking website - VOUG - Portal >Date: Mon, 20 Aug 2001 06:40:59 -0800 > >sorry - that was http://www.voug.org > > >"Boivin, Patrice

Re: DBA tasks

2001-08-20 Thread Scott Shafer
A la, Conan: "Crush your enemies, See them driven before you, Hear the lamentations of their Women! This is best in life." webmaster wrote: > > kill them all and take all the girls I would say > !! > > perhaps on a very teorethical system administration book... cheers > On Mon, 20 Aug

RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

2001-08-20 Thread Jesse, Rich
Hey Jon, We're on 8.1.7.1.0. And as luck would have it, 8.1.7.2.0 came out THE DAY AFTER our upgrade, so I dunno if it appears there. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message--

Re: Unique contraint violation

2001-08-20 Thread Rachel Carmichael
well if she inserts/deletes more than one row per second. >From: "Smith, Ron L." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Unique contraint violation >Date: Mon, 20 Aug 2001 07:25:56 -0800 > >I have a trigger that

RE: DBA tasks

2001-08-20 Thread Rachel Carmichael
ahem... "get the girl" lol >From: "Guy Hammond" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: DBA tasks >Date: Mon, 20 Aug 2001 07:21:31 -0800 > >We find the treasure, kill the bad guys, save the world and ge

Re: WARNING: CURSOR_SHARING=FORCE on 8.1.7

2001-08-20 Thread Rachel Carmichael
I think I need to have a chat with Kevin when I see him at the NYOUG meeting... I'm on 8.1.6 and have been using CURSOR_SHARING=FORCE for about a year. No problems. Admittedly, we don't do too many complicated queries and we analyze all tables and don't use hints... >From: "Jesse, Rich" <[EM

RE: Using Table Partitions in 8.0.5

2001-08-20 Thread Kevin Lange
Thats everyone.    I just found that out from Joe. This really sucks .. Save the money .. Loose the features.    I hate limping along like this -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001 11:51 AMTo: Multiple rec

RE: raw devices

2001-08-20 Thread Valuthur, Srikanth
Don & Oracle Gurus, Going by your answers, I have a question for you? What you have explained is excatly the same environment we had back in our previous work place. But here we have everything what you have MINUS the raw devices. The question I have for Don and the forum folks is, What is the

Differences in sql server2000 and oracle8i

2001-08-20 Thread ARUN K C
Hi, Does anybody has any documents or links which shows the difference major between sql server 2000 and oracle 8i Here the management is asking for some docs which says that 8i is better than sql server 2000. Looks like the replication is very good on sql server 2000 than 8i. Please let me know

RE: Using Table Partitions in 8.0.5

2001-08-20 Thread Yuval Arnon
Kevin,   You need Oracle Enterprise to use the partition feature.   For a comparison of features between EE and SE please see http://otn.oracle.com/products/oracle8i/pdf/8i_fam.pdf Yuval. -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 200

RE: w2k scripting

2001-08-20 Thread Jyoti N
  Sometime back I was struggling to convert my Unix backup scripts to NT world, I came across this book which was quite useful . Check it out. Windows NT shell scripting.. by Tim hill. HTH, Jyoti >From: "Guy Hammond" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipient

Using Table Partitions in 8.0.5

2001-08-20 Thread Kevin Lange
Hi folks;   I have tried to setup a partitioned table in 8.0.5 and I get the message   create table calc_sched_geo_factor_p*ERROR at line 1:ORA-00439: feature not enabled: Partitioning     Is there something someplace I need to turn on in order to use partitions ??   Thanks   Kevin

Re: w2k scripting

2001-08-20 Thread Chaim . Katz
Lisa, I use Tcl and OraTcl that comes with Oracle Enterprise Manager. Chaim "Koivu, Lisa" <[EMAIL PROTECTED]> on 08/19/2001 05:15:21 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Chaim Katz/Completions/Bombardier) Bo

Interview Queries

2001-08-20 Thread Harvinder Singh
Hi, My manager is going to take interview of a person who has about 10 years of experience as Data Architect. Since i am out of office he wants me to send some sample tricky queries which he can ask in interview. I will appreicate if someone can point me to site having some sample tricky queires

RE: Using Table Partitions in 8.0.5

2001-08-20 Thread Kevin Lange
I may have answered my own question       I found a parm called     partition_view_enabled   This is currently set to false.   Even though it says Partioned View , does this govern the use of partitions , period ?? -Original Message-From: Kevin Lange [mailto:[EMAIL P

Shared_pool in relation to the kernel (Solaris)

2001-08-20 Thread Jaouich . Cyril
Title: Shared_pool in relation to the kernel (Solaris) Hi all,     I've got a question related to the SHARED_POOL_SIZE parameter in my init file. Currently our kernel is defined with a 256MB of shared_memory (set shmsys:shminfo_shmmax=268435456) and we have 2 databases running on this se

RE: Please Help - ora error

2001-08-20 Thread Hillman, Alex
I knew that this was incorrect answer - and instead of pointing that I asked if he was sure. Alex Hillman -Original Message- Sent: Saturday, August 18, 2001 1:06 PM To: Multiple recipients of list ORACLE-L Alex: This is a fallacy that's been around since Oracle 6. In actuality, one w

Followup: Database upgrade w/ standby

2001-08-20 Thread Hand, Michael T
The patch level upgrade from 8062 to 8063 went smoothly. The standby database was shutdown, then upgraded after production. When restarted (mounted as standby), it picked up the automated recovery process without a hitch. Thanks Rachel and Jeremiah Mike -Original Message- Sent: Frida

RE: raw devices

2001-08-20 Thread Andrey Bronfin
Thanks a lot for your incedible answer , Don ! -Original Message- Sent: Monday, August 20, 2001 4:46 PM To: Multiple recipients of list ORACLE-L I don't know about NT, but on Solaris you should have some sort of cluster volume manager - Veritos is the most common. Rather than repeat a

RE: Database using 100% of CPU

2001-08-20 Thread JOE TESTA
the OEM with 9i, works beautifully(at least on linux) :)   joe >>> [EMAIL PROTECTED] 08/20/01 10:51AM >>>Are you using the OEM that came with 8.1.6?  I have a dim memory that theJAVA executable that powers that version of OEM had a flaw that couldconsume 100% of the CPU.  Personally, I don't

Re: ORA-21560 when trying to use the dbms_lob.loadfromfile function

2001-08-20 Thread Beatriz Martínez Jiménez
Hello again, We have had some problems with the net during the holidays and I haven´t received some emails. If somebody wrote any message related with this this doubt, I would be very grateful if she/he send it again to me, a lot of thanks, Beatriz Martínez Jiménez wrote: Hello list, I get this e

RE: DBA tasks

2001-08-20 Thread webmaster
kill them all and take all the girls I would say !! perhaps on a very teorethical system administration book... cheers On Mon, 20 Aug 2001, Guy Hammond wrote: > Date: Mon, 20 Aug 2001 07:21:31 -0800 > From: Guy Hammond <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PR

Re: WARNING: CURSOR_SHARING=FORCE on 8.1.7

2001-08-20 Thread Jon Walthour
Rich: This is Bug #1561329: ORA-12704 character set mismatch on select with cursor_sharing = force. This bug apparently appears only in 8.1.7 on HP-UX. In this case, CURSOR_SHARING must be set to EXACT. I'm not sure, but I seem to remember that it didn't give me problems in 8.1.7.1.x, only in

Re: Help: truncate lasting 2+ hours

2001-08-20 Thread Christian Trassens
As someone said, probably that a lot of extents. However the main deal here is that you could lock the users with an ST lock. Therefore, you mustn't try it where all the users are in. And also you could try with a truncate tablereuse storage, and then issuing several alter table deallocate of

Re: ora-24334

2001-08-20 Thread Christian Trassens
It is an OCI error. You should debug the app. Regards. --- Gene Gurevich <[EMAIL PROTECTED]> wrote: > Hi all: > > My application is getting ora-24334 errors: no > descriptor for this position. The information I > found > on Metalink is hot very helpful, something like use > correct position. D

RE: Unique contraint violation

2001-08-20 Thread Smith, Ron L.
Sorry, I found that there were two triggers tied to the table. Probably a vendor error made on a recent updrade. Thanks for the help. Ron -Original Message- Sent: Monday, August 20, 2001 9:58 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] you can't get more than 1 record loaded per sec

RE: linux

2001-08-20 Thread Jon Baker
FreeBSD and OpenBSD are not supported by Oracle.     -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001 10:46 AMTo: Multiple recipients of list ORACLE-LSubject: linux Hi Friends,     I have small clarification to

Re: Unique contraint violation

2001-08-20 Thread JOE TESTA
you can't get more than 1 record loaded per second?   joe >>> [EMAIL PROTECTED] 08/20/01 11:25AM >>>I have a trigger that does an insert on a table containing 5 columns.  Thefirst three columns are variable information.  The fourth column in SYSDATE.The last column is either the constant INSE

Re: w2k scripting

2001-08-20 Thread Jared Still
On Monday 20 August 2001 04:05, Guy Hammond wrote: > Perl on Windows is great, when you consider things like manipulating the > user database or system log, it's probably more useful on Windows than > it is even on Unix. And DBI works the same on both platforms. > Interesting comment Guy. I had

Re: FW: Data Warehouse book

2001-08-20 Thread Jared Still
I'm gonna split my vote, is that allowed, even though I'm not in Florida? If you're completly new to DW, go with 'The Data Warehouse Tool Kit' first, by Ralph Kimball. It will clearly explain DW. If you have some DW experience, or won't be overwhelmed by a much more comprehensize tome, go wit

RE: FW: Data Warehouse book

2001-08-20 Thread Terrian, Tom
You definitely have some Florida blood in you! :-) Thanks, Tom Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -Original Message- Sent: Monday, August 20, 2001 10:44 AM To: [EMAIL PROTECTED]; Terrian, Tom I'm gonna split my vote, is that allowed, even t

  1   2   >