RE: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-26 Thread Eric D. Pierce
will you also need two stamens? On 25 Jun 2002 at 10:29, April Wells wrote: two pistals at dawn What is dual? ... -- 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:

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Rachel Carmichael
and I use the ora-600 lookup tool on Metalink, search metalink for the 1st parameter in the ora-600 message. Yes we pay a lot for support, but if we bombard the support techs with questions we can answer ourselves, then when we NEED them for real, they are too busy to help us. Rachel --- Joe

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Joe Testa
that of which is happening today, tech support is busy answering RTFM questions like: What is a database, whats the R in RDBMS stand for, how do i create a user, etc. joe Rachel Carmichael wrote: and I use the ora-600 lookup tool on Metalink, search metalink for the 1st parameter in the

RE: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Farnsworth, Dave
-that of which is happening today, tech support is busy answering RTFM -questions like: What is dual? -Original Message- Sent: Tuesday, June 25, 2002 10:24 AM To: Multiple recipients of list ORACLE-L that of which is happening today, tech support is busy answering RTFM questions

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Yechiel Adar
I think that after finding the problem you should check metalink, read the manuals, ask the list, try to define it more etc. These should take 1-2 days at most. If problem not solved - call support. This way you have a two prong attack on it: you and support. I just thought that 2 weeks it

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Jan Pruner
And who is dummy? What is dual? -Original Message- Sent: Tuesday, June 25, 2002 10:24 AM To: Multiple recipients of list ORACLE-L that of which is happening today, tech support is busy answering RTFM questions like: What is a database, whats the R in RDBMS stand for, how do i

RE: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread April Wells
two pistals at dawn What is dual? -Original Message- Sent: Tuesday, June 25, 2002 10:24 AM To: Multiple recipients of list ORACLE-L that of which is happening today, tech support is busy answering RTFM questions like: What is a database, whats the R in RDBMS stand for, how do

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Joe Testa
help? Farnsworth, Dave wrote: -that of which is happening today, tech support is busy answering RTFM -questions like: What is dual? -Original Message- Sent: Tuesday, June 25, 2002 10:24 AM To: Multiple recipients of list ORACLE-L that of which is happening today, tech support is

RE: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Fink, Dan
test, please ignore Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- Sent: Tuesday, June 25, 2002 2:50 PM To: Multiple recipients of list ORACLE-L help? Farnsworth, Dave wrote: -that of which is happening today, tech support is busy answering RTFM

RE: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Fink, Dan
I have not received a response, so I will repost. Please Ignore. Cheers Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- Sent: Tuesday, June 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L test, please ignore Daniel W. Fink Sr. Oracle DBA MICROMEDEX

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Suzy Vordos
You failed, take another OCP exam ;) Fink, Dan wrote: test, please ignore Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- Sent: Tuesday, June 25, 2002 2:50 PM To: Multiple recipients of list ORACLE-L help? Farnsworth, Dave wrote: -that of

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-24 Thread Joe Testa
well ora600 errors you cant fix but before i lay claim that its a bug, i have everything support will ask for including multiple test cases before i get them on the horn. joe Yechiel Adar wrote: - Original Message - i call support usually AFTER 2 weeks of working on an issue my

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-20 Thread Yechiel Adar
- Original Message - i call support usually AFTER 2 weeks of working on an issue my self, they are my last resort, when i've exhausted all of my friends, cohorts and this list for my issue. joe Hello Joe I think that your policy is wrong. If after one or two days you do not

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-10 Thread Jared Still
There ain't no substitute for doing your own research, then asking for help when you need. Personally, I sometimes find SQL*Net baffling. There must be a hundred different ways to setup the listeners, names, tnsnames.ora, sqlnet.ora, tracing, MTS, yadda, yadda, yadda. I still ask questions,

RE: Index Constraint

2002-06-10 Thread Sherman, Paul R.
-Original Message- From: Hamid Alavi [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 5:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Index Constraint Igore, rtfm is a very complex answer, please reply clearly!! -Original Message- Sent: Friday, June 07

RE: Index Constraint

2002-06-09 Thread Igor Neyman
Hamid, First, I don't think it's high class to misspell my name intentionally (you did it more than once). Second, rtfm is best advice, you can get, when asking such generic questions, which show your unwillingness to do your home work and which could (and should) be investigated first using

RE: Index Constraint

2002-06-09 Thread JoJo Al-Zawawi
Come on, you guys. If you don't want to answer somebody's question, all you have to do is Delete the e-mail. You really don't have to respond rudely. You don't even have to say rtfm. You could NICELY point out, your best bet is the manual. You know what? Sometimes for us newbies, the

RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-09 Thread Joe Testa
JoJo, take a hint from someone who'd been doing oracle for 11 years now. The docs are ALOT better than they were in 5.x/6.x days. Heck you dont even have to buy oracle anymore to read the docs. They used to come only in paper, than using Oracle Book(anyone rememeber that one), and now on

Re: Index Constraint

2002-06-08 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: An example on my understanding of Reverse Key Indices: Say you have a table EMP with a column EMPNO, and an index on this field.This number is incremented sequentially for every new employee that joins in. And as employees retire, say, the records are deleted.

Index Constraint

2002-06-07 Thread Hamid Alavi
Hi List, What's the diffrent between unique constrint unique index, when we have to use which, I think both are the same. Any Idea? And what about normal index reverse index? when we have to use normal and when reverse index, I think Reverse index normaly using for FK index, Is it right or not?

RE: Index Constraint

2002-06-07 Thread Jamadagni, Rajendra
No, don't use reverse index for FKs, on certain versions they caused havoc by allowing parent key to be deleted (Metastink has an alert on this one). Reverse indexes are preferred in OPS environment AFAIK. Raj __ Rajendra Jamadagni

Re: Index Constraint

2002-06-07 Thread Igor Neyman
rtfm Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 07, 2002 3:46 PM Hi List, What's the diffrent between unique constrint unique index, when we have to use which, I think both are the

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
What about PK, which one should be, normal or Reverse, I can see in one of my database, Erwin generate all PK as normal/reverse ? -Original Message- Sent: Friday, June 07, 2002 1:33 PM To: Multiple recipients of list ORACLE-L No, don't use reverse index for FKs, on certain versions

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
Igore, rtfm is a very complex answer, please reply clearly!! -Original Message- Sent: Friday, June 07, 2002 1:18 PM To: Multiple recipients of list ORACLE-L rtfm Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

RE: Index Constraint

2002-06-07 Thread Rajesh . Rao
: @espn.com Subject: RE: Index Constraint Sent by: [EMAIL PROTECTED

Re: Index Constraint

2002-06-07 Thread Igor Neyman
Hamid, Which part of RTFM you didn't understand? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 07, 2002 5:28 PM Igore, rtfm is a very complex answer, please reply clearly!! -Original

RE: Index Constraint

2002-06-07 Thread Rachel Carmichael
read the fine manual you might, by doing a bit of research, get the answers on your own. It's definitely a way to learn more --- Hamid Alavi [EMAIL PROTECTED] wrote: Igore, rtfm is a very complex answer, please reply clearly!! -Original Message- Sent: Friday, June 07, 2002 1:18

RE: Index Constraint

2002-06-07 Thread Gogala, Mladen
Read The Frigging Manual -Original Message- From: Hamid Alavi [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 5:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Index Constraint Igore, rtfm is a very complex answer, please reply clearly!! -Original

RE: Index Constraint

2002-06-07 Thread JoJo Al-Zawawi
Running To Find Mama. Just kidding around, JoJo -Original Message- Sent: Friday, June 07, 2002 2:28 PM To: Multiple recipients of list ORACLE-L Igore, rtfm is a very complex answer, please reply clearly!! -Original Message- Sent: Friday, June 07, 2002 1:18 PM To: Multiple

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
Igore, The RTFM part ! -Original Message- Sent: Friday, June 07, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Hamid, Which part of RTFM you didn't understand? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
recipients of list ORACLE-L Subject: RE: Index Constraint Igore, rtfm is a very complex answer, please reply clearly!! -Original Message- Sent: Friday, June 07, 2002 1:18 PM To: Multiple recipients of list ORACLE-L rtfm Igor Neyman, OCP DBA [EMAIL PROTECTED

RE: Index Constraint

2002-06-07 Thread Hamid Alavi
Igore, I didn't expect even in this group you can find such low class people If you want to use these sort of words please keep it for yourself. -Original Message- Sent: Friday, June 07, 2002 1:18 PM To: Multiple recipients of list ORACLE-L rtfm Igor Neyman, OCP DBA [EMAIL

RE: Index Constraint

2002-06-07 Thread Rachel Carmichael
rtfm can be read as read the fine manual exactly what sort of language are you accusing Igor (and it would be nice if you managed to spell his name correctly) of using? you have spent a good deal of time asking people on this list for help for things that you could easily find in the manuals, if