date:20020625


Charlie,

You are hardly able to fit two instances of your configuration into 256M
along with OS memory requirements. For example, JServer option has
additional requirements for java_pool_size. RTFM about OLAP and Data Mining
option if they have some additional memory requirements. Partitionning AFAIK
doesn't.
32M for 9i SGA - probably impossible or you database will not function
properly.

The full formula for the total memory requirement of the Oracle9i on
unixbackground processes may be found in Oracle9i Administrator's
Reference for 9.0.1 Part No. A90347-02 and page 1-14 Oracle9i Memory
Requirements.
It looks like
text + SGA + (n * (data + uninitialized_data + 8192 + 2048) )
see the manual for details. Of course, the SGA is the biggest part when
there are few users.

--
hth
Alexandre

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 12:05 AM


 Yes, I know I need to RTFM, but if some kine soul has a quick
 answer for me, I'd appreciate it.

  startup
 ORACLE instance started.

 Total System Global Area  168788768 bytes
 Fixed Size   729888 bytes
 Variable Size 100663296 bytes
 Database Buffers   33554432 bytes
 Redo Buffers   33841152 bytes
 Database mounted.
 Database opened.
  exit
 Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit
Production
 With the Partitioning, OLAP and Oracle Data Mining options
 JServer Release 9.2.0.1.0 - Production
 oracle@actaeon:CAN#


 I just got done upgrading two V7.3.4.5 instances to V9.2 on a sandbox
 which has only 256MB RAM. Both SGAs are currently sized the same way.
 The OS is paging/swapping like carzy because SGA1+SGA2256MB. :-(

 Which initSGA.ora parameters control the Variable Size piece of
 the 9i SGA? I'd like to shrink this total to around 32MB.

 TIA  HAND!

 --
 Charlie Mengler  Maintenance Warehouse
 [EMAIL PROTECTED] 10641 Scripps Summit Ct.
 858-831-2229 The Micro$oft Haiku Creed   San Diego, CA 92131
 Chaos reigns within. Reflect, repent, and reboot. Order shall return.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Charlie Mengler
   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: Alexandre Gorbatchev
  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: RMAN Guru Needed - RMAN/Netbackup

2002-06-25 Thread rabbit


Thanks for reply:
I tried to restore the archivelogs on their own and it still asks for a
backup piece thats on a tape that has been scratched.
I looked at rc_backup_redolog and see lots of entries for the particular
archive log.The last entry (in date order) points to a backup_set that is
on the scratched tape. The second last entry points to a backup set that is
on the tape that we have in the library. Im guessing that RMAN looks at the
last entry and figures that this job backed it up and deleted it and
therefore it is this tape. What I want to know is how I can get the
archivelogs to be restored from the previous tape. Im probably going to
raise a tar now.
I can see in the logs that our bi weekly backup and delete all archivelogs
ran on the 11/jan/2001 - yet these particular archive logs were backed up
again the day after. Very strange behaviour yet could explain why RMAN is
pointing to wrong tape.
I always suspected RMAN was to easy to not be problematic
Sam



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

RE: rows values in tkprof

2002-06-25 Thread Remacle Jean


Ravi,

The rows value comes from the execution plan stored in the trace file at
runtime. 
The execution plan is only dumped to trace file when the cursor is closed.
So, if you take another try with sql*plus for instance and quit sql*plus
before closing the trace,
then you will see the rows values printed in your trace. Or if you commit
the transaction even if it is a select then you will see the rows count.

That's a matter of fact there is a tkprof option to add the explain plan
into the output. All the option does is connect to the database when you
issue the tkprof command line and compute a explain plan. 
I see two quirks here first you do not have a real image of what happened at
runtime and second you don't have the rows count.

By the way if your cursor is closed ( you have stats info in your trace
file)  and you issue a tkprof command with the explain option you will see
two execution plan in the output, the stored one and the newly computed one.

Jean Remacle

-Original Message-
From:   Nalla Ravi [mailto:[EMAIL PROTECTED]]
Sent:   lundi 24 juin 2002 21:08
To: Multiple recipients of list ORACLE-L
Subject:rows values in tkprof

Dear All,

In my tkprof output rows values under explain plan
section are not getting printed, is there any
parameter to be set?

Thanks,
Ravi

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  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: Remacle Jean
  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).

Backup and restore


Hi i am an oracle newbie.
I can't find an exaustive explanation about backup and restore in Oracle.
I mean policy, commands and syntax without using wizards.
I did a fast run cross orafaq, but i can't find it ...
Any help 
thank you, Marcello
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marcello  Savino
  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: Backup and restore


Marcello,
Didn't you find the answer for the most common kind of questions in Oracle
FAQs? The answer is RTFM.
Fasten your seatbelts and get into, for examlpe, Oracle Backup and Recovery
Concepts or better  Oracle Backup and Recovery Documentation Online
Roadmap.
Good Luck!
--
Alexandre

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 10:33 AM


 Hi i am an oracle newbie.
 I can't find an exaustive explanation about backup and restore in Oracle.
 I mean policy, commands and syntax without using wizards.
 I did a fast run cross orafaq, but i can't find it ...
 Any help 
 thank you, Marcello
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Marcello  Savino
   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: Alexandre Gorbatchev
  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).

Difference Between DBMS/RDBMS

2002-06-25 Thread Santosh Varma




could any body point 
me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, 
we can related two or more tables..if a column exists in another table for 
relation ??
Thanks and regards,
Santosh

Flush Shared Pool Area

2002-06-25 Thread GL2Z/ INF DBA BENLATRECHE


Hi All


   In which cases the  alter system flush shared_pool is necessary ?

Regards
Kamel  Benlatreche


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  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: NEED YOUR OPINION

2002-06-25 Thread SIM/HAOUHACH


Hi Hamid,
Can you to give me what you want to obtain as result to this requette.
I believe that in your request you have a problem of conversion of a
varchar2 in number.

LYNDA HAOUHACH
Ingénieur Systèmes
SONATRACH LTH 
Émail: [EMAIL PROTECTED]




 -Message d'origine-
 De:   Hamid Alavi [SMTP:[EMAIL PROTECTED]]
 Date: lundi 24 juin 2002 11:23
 À:Multiple recipients of list ORACLE-L
 Objet:NEED YOUR OPINION
 
 List,
 
 I have a table with the following structure:
 
 CREATE TABLE SERVICE_CODE_MSC ( 
   MSC_SERVICE_ID  NUMBER (4)NOT NULL, 
   MSC_SERVICE_CODEVARCHAR2 (30)  NOT NULL, 
   CONSTRAINT MSC_PK
   PRIMARY KEY ( MSC_SERVICE_ID, MSC_SERVICE_CODE ) 
 USING INDEX 
  TABLESPACE USERS
 
 Here is some sample of this table:
 service_id service_code
 -  --
 7 a1000
 7 a2000
 30e1230
 30e1234
 1012098
 20130987
 
 
 When I run the followinh query on this table I get invalid
 number(ORA-01722), then when I drop tha table and reload the data the
 query
 running OK, Here is the query I am running:
 
 select count(*)
   from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID
 from MTF_SERVICE_CODE_MSC 
   where 
 substr(MSC_SERVICE_CODE, 1, 1) in
 ('9','8','7','6','5','4','3','2','1','0')) a
   where
to_number(a.MSC_SERVICE_CODE) between 7 and 30
 Any Idea ? why this hapenning?
 
 Thanks Allot.
 
 
 
 
 
 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987
 
 
 
 
 
 
 === Confidentiality Statement === 
 The information contained in this message and any attachments is 
 intended only for the use of the individual or entity to which it is 
 addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
 and exempt from disclosure under applicable law.  If you have received 
 this message in error, you are prohibited from copying, distributing, or 
 using the information.  Please contact the sender immediately by return 
 e-mail and delete the original message from your system. 
 = End Confidentiality Statement =
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Hamid Alavi
   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: SIM/HAOUHACH
  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).

AW: NEED YOUR OPINION

2002-06-25 Thread Stefan Jahnke


Hi Hamid

by making sure that the first charakter of msc_service_code is in the range
[0-9], 
you have no guarantee for the rest of the VARCHAR being numeric, too. It
could 
contain anything else, so your to_number might go down the drain ...

Regards,
Stefan


-Ursprüngliche Nachricht-
Von: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 25. Juni 2002 01:23
An: Multiple recipients of list ORACLE-L
Betreff: NEED YOUR OPINION


List,

I have a table with the following structure:

CREATE TABLE SERVICE_CODE_MSC ( 
  MSC_SERVICE_ID  NUMBER (4)NOT NULL, 
  MSC_SERVICE_CODEVARCHAR2 (30)  NOT NULL, 
  CONSTRAINT MSC_PK
  PRIMARY KEY ( MSC_SERVICE_ID, MSC_SERVICE_CODE ) 
USING INDEX 
 TABLESPACE USERS

Here is some sample of this table:
service_id service_code
-  --
7   a1000
7   a2000
30  e1230
30  e1234
10  12098
20  130987


When I run the followinh query on this table I get invalid
number(ORA-01722), then when I drop tha table and reload the data the query
running OK, Here is the query I am running:

select count(*)
from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID
  from MTF_SERVICE_CODE_MSC 
  where 
  substr(MSC_SERVICE_CODE, 1, 1) in
('9','8','7','6','5','4','3','2','1','0')) a
where
 to_number(a.MSC_SERVICE_CODE) between 7 and 30
Any Idea ? why this hapenning?

Thanks Allot.





Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  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: Stefan Jahnke
  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).

SQL*LOAD question

2002-06-25 Thread Bernard, Gilbert


I have 150 000 lines to insert with sqlload and it takes 8 minutes, my
feeling is this is too long.
I tried in DIRECT mode, but I got some error, Direct mone does not work with
pl/sql instriction like procedure or 
Sysdate value.  I retrived any pl/sql instruction and any value like
sysdate.  I amiliorate the perf with 20 sec off.

How can boost sqlloader?




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: Bernard, Gilbert
  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: Flush Shared Pool Area

2002-06-25 Thread John . Hallas


Normally this is done when you are getting ORA-4030 (maybe ORA-4031 as well)
errors.
Basically the shared pool is fragmented and a object is trying to load but
cannot find sufficient contiguous free space.
Flushing the shared pool clears everything out and the package should load.
Bear in mind that when flushing the shared pool any objects that are marked
as kept will not be flushed out.
It is normal to load often used packages into the shared pool just after
startup so that these are kept and space is used efficiently.

HTH

John

-Original Message-
Sent: 25 June 2002 11:03
To: Multiple recipients of list ORACLE-L


Hi All


   In which cases the  alter system flush shared_pool is necessary ?

Regards
Kamel  Benlatreche


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  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: 
  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).

R: Backup and restore


What is RFTM (Rapid Fast Training Machine ? ;-)
How can i get into a RFTM ?
Sorry but, you know, i am a newbie .
Marcello


Marcello,
Didn't you find the answer for the most common kind of questions in Oracle
FAQs? The answer is RTFM.
Fasten your seatbelts and get into, for examlpe, Oracle Backup and
Recovery
Concepts or better  Oracle Backup and Recovery Documentation Online
Roadmap.
Good Luck!
--
Alexandre

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marcello  Savino
  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: SQL*LOAD question

2002-06-25 Thread John . Hallas


See post below from Stephen Andert (21/6/02)
David, 
 
start shameless self-plug
I wrote an article last year about tuning SQL*Loader.  It is at
http://oracle.oreilly.com/news/oraclesqlload_0401.html I experienced a huge
improvement in performance and others have told me that they were able to
achieve similar improvements.
end shameless self-plug

Stephen

Also see the ORAFAQ mentioned at the bottom of each post on this list. That
holds some very good info on sqlloader 

HTH

John

 [EMAIL PROTECTED] 06/20/02 04:20PM 
I try to insert 14,000 rows into oracle database using SQLLDR and it takes
too long to finish (around an hour).  Is there a way to improve SQLLDR to
make it run faster?  For example, if modify parameter file will help?

-Original Message-
Sent: 25 June 2002 10:53
To: Multiple recipients of list ORACLE-L


I have 150 000 lines to insert with sqlload and it takes 8 minutes, my
feeling is this is too long.
I tried in DIRECT mode, but I got some error, Direct mone does not work with
pl/sql instriction like procedure or 
Sysdate value.  I retrived any pl/sql instruction and any value like
sysdate.  I amiliorate the perf with 20 sec off.

How can boost sqlloader?




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: Bernard, Gilbert
  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: 
  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).

R: Difference Between DBMS/RDBMS




DBMS 
=Data Base Management System
RDBMS=Relational Data Base Management System
But 
actually i do not know any dbms that's not an rdbms. 
Bye , 
Marcello
-Messaggio originale-Da: Santosh Varma 
[mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 
11.48A: Multiple recipients of list ORACLE-LOggetto: 
Difference Between DBMS/RDBMS

  could any body 
  point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as 
  in RDBMS, we can related two or more tables..if a column exists in another 
  table for relation ??
  Thanks and regards,
  Santosh

Re: Backup and restore


Meaning of RTFM depends on how you like it. :)
Read the Fabulous Manual
Read the F...ng Manual  (most popular ;)
... Friendly 
... Fine .
... Freaking ...
and ... whatever.

 - Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 1:23 PM


 What is RFTM (Rapid Fast Training Machine ? ;-)
 How can i get into a RFTM ?
 Sorry but, you know, i am a newbie .
 Marcello


 Marcello,
 Didn't you find the answer for the most common kind of questions in
Oracle
 FAQs? The answer is RTFM.
 Fasten your seatbelts and get into, for examlpe, Oracle Backup and
 Recovery
 Concepts or better  Oracle Backup and Recovery Documentation Online
 Roadmap.
 Good Luck!
 --
 Alexandre

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Marcello  Savino
   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: Alexandre Gorbatchev
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Santosh Varma




full 
form i also knew.
and 
also that all dbms have the features of rdbms also
then, 
what is the difference ??

santosh

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Marcello SavinoSent: 
  Tuesday, June 25, 2002 4:58 PMTo: Multiple recipients of list 
  ORACLE-LSubject: R: Difference Between 
  DBMS/RDBMS
  DBMS 
  =Data Base Management System
  RDBMS=Relational Data Base Management System
  But 
  actually i do not know any dbms that's not an rdbms. 
  Bye 
  , Marcello
  -Messaggio originale-Da: Santosh Varma 
  [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 
  11.48A: Multiple recipients of list ORACLE-LOggetto: 
  Difference Between DBMS/RDBMS
  
could any body 
point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as 
in RDBMS, we can related two or more tables..if a column exists in another 
table for relation ??
Thanks and regards,
Santosh

Re: Backup and restore


its called documen tation, there are user(manually) backup doics and 
rman docs.

happy reading.

joe

PS:  you should have been around in oracle 5/6 days when no such 
documentation existed.

Marcello Savino wrote:

Hi i am an oracle newbie.
I can't find an exaustive explanation about backup and restore in Oracle.
I mean policy, commands and syntax without using wizards.
I did a fast run cross orafaq, but i can't find it ...
Any help 
thank you, Marcello



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

2002-06-25 Thread Mercadante, Thomas F


Hamid,

You WHERE clause is causing the problem.
When you say :
 to_number(a.MSC_SERVICE_CODE) between 7 and 30

you are forcing Oracle to convert the values of the column MSC_SERVICE_CODE
to a number.  Your data shows that the current values contain letters, thus
the invalid number error.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, June 24, 2002 7:23 PM
To: Multiple recipients of list ORACLE-L


List,

I have a table with the following structure:

CREATE TABLE SERVICE_CODE_MSC ( 
  MSC_SERVICE_ID  NUMBER (4)NOT NULL, 
  MSC_SERVICE_CODEVARCHAR2 (30)  NOT NULL, 
  CONSTRAINT MSC_PK
  PRIMARY KEY ( MSC_SERVICE_ID, MSC_SERVICE_CODE ) 
USING INDEX 
 TABLESPACE USERS

Here is some sample of this table:
service_id service_code
-  --
7   a1000
7   a2000
30  e1230
30  e1234
10  12098
20  130987


When I run the followinh query on this table I get invalid
number(ORA-01722), then when I drop tha table and reload the data the query
running OK, Here is the query I am running:

select count(*)
from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID
  from MTF_SERVICE_CODE_MSC 
  where 
  substr(MSC_SERVICE_CODE, 1, 1) in
('9','8','7','6','5','4','3','2','1','0')) a
where
 to_number(a.MSC_SERVICE_CODE) between 7 and 30
Any Idea ? why this hapenning?

Thanks Allot.





Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  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: Mercadante, Thomas F
  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: Difference Between DBMS/RDBMS


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? 
 because in DBMS also as in RDBMS, we can related two or more 
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



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

2002-06-25 Thread Tripat Singh




DBMS is broad term, It covers Relational, 
heirarchical and network database management systems.

Regards

Tripat Singh

  - Original Message - 
  From: 
  Marcello Savino 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, June 25, 2002 4:58 
PM
  Subject: R: Difference Between 
  DBMS/RDBMS
  
  DBMS 
  =Data Base Management System
  RDBMS=Relational Data Base Management System
  But 
  actually i do not know any dbms that's not an rdbms. 
  Bye 
  , Marcello
  -Messaggio originale-Da: Santosh Varma 
  [mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 
  11.48A: Multiple recipients of list ORACLE-LOggetto: 
  Difference Between DBMS/RDBMS
  
could any body 
point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as 
in RDBMS, we can related two or more tables..if a column exists in another 
table for relation ??
Thanks and regards,
Santosh

RE: Virtual drive on Solaris

2002-06-25 Thread Ferenc Mantfeld


Used it for large application upgrades, works a charm, cut down the time by
about a third. But it does not work on every platform, because when I set it
and then perform a transaction, upon dumping the redo log, I find my
transaction in there. But thanks Tim.

BTW, I was in that class, you ran it in Dallas in 1998 at Oracle Education.
Cheers :

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Only Robinson Crusoe had all his work done by Friday


-Original Message-
Sent: Monday, 24 June 2002 4:23 PM
To: Multiple recipients of list ORACLE-L


I hesitated mentioning that parameter in this forum, but I figured what the
heck?  Could be fun, in a sick way...  :-)

Once I was teaching a DBA class and mentioned _DISABLE_LOGGING.
Immediately, I saw every head in the class look down, scribbling furiously!
I had to backtrack very quickly and warn of the consequences of disabling
redo logging (i.e. database corruption if not shutdown normally for any
reason)...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 2:48 PM


 Hi Tim

 Yes, I have tried the _disable_logging, does not work on all platforms. DB
 starts up fine, but redo log is generated, evidenced by log switching
going
 on.

 Also if I do a normal DML (large-ish one to verify), then dump the redo
log,
 I see my transaction there, so for a 420R, running Solaris8 and Oracle
 9.0.1, it would seem that _disable_logging does not work.

 I don't want to complicate the picture even further with transportable
 tablespaces, which would mean that I would need to store all dependent
 objects (in this case indexes only) in the same tablespace, which I could
 easily achieve by rebuilding all indexes using a dynamic SQL.

 Informatica BTW does not only do single level inserts, version 5.0 onwards
 has a 'bulk load' feature, but I am not sure what this actually does.
 Previously Sagent also had a 'direct load' switch, which meant that it
wrote
 all of its data to large (very large) flat files and then used Sql*Loader
 direct path to load. Fast, but Sagent at the time was very unreliable,
 because on identical runs, it would sometimes load all the data, sometimes
 only a portion, and every time, would report no errors and everything
hunky
 dory, until you went looking for your data. I remember that took me about
a
 week of arguing to prove that Sagent was at fault.

 Thanks for the suggestion of the Non volatile RAM (NVRAM) unit, it makes
the
 most sense. I will suggest this to my damagers.

 Regards:
 Ferenc Mantfeld
 Senior Performance Engineer
 Siebel Performance Engineering
 Melbourne, 3000, VIC, Australia
 Only Robinson Crusoe had all his work done by Friday


 -Original Message-
 Sent: Sunday, 23 June 2002 9:03 PM
 To: Multiple recipients of list ORACLE-L


 Have you considered setting _DISABLE_LOGGING = TRUE
 instead?  It could be just as disastrous...  ;-)

 Buying an NVRAM unit would probably be more sensible, since
 at least then you have some probability of the file-system
 on such a unit surviving node failure or restart.

 I don't use Informatica, but I believe it mainly does
 single-row inserts, so not using the APPEND hint is a
 blessing anyway.  After all, who likes one row in each
 database block?  However, I could be wrong about that and it
 may actually be performing multi-row/array insertions...

 I don't know what your loads are like, but how about
 something like this instead?

   - create a small database with _DISABLE_LOGGING set to
 TRUE
   - use Informatica to load into a tablespace on that small,
 sacrificial db
   - use transportable tablespace to copy the tablespace to
 your real DW

 Just an idea (better you than me to try it!)...

 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Sunday, June 23, 2002 8:53 PM


  Hi All
 
  does anyone have any white paper or info on how to
 configure a dedicated
  portion of real memory as a virtual drive on Solaris ? I
 want to move my
  online redo logs (4 X 128 M single threaded) for a 300 GB
 DW onto it, to
  speed up Informatica ETL, since Informatica does not allow
 me to specify /*+
  APPEND */ mode of insert. I know I will not bypass the SQL
 layer this way,
  but at least, the LGWR will be writing to memory instead
 of disk. Thanks in
  advance.
 
  Regards:
  Ferenc Mantfeld
  Senior Performance Engineer
  Siebel Performance Engineering
  Melbourne, 3000, VIC, Australia
  Only Robinson Crusoe had all his work done by Friday
 
 
  -Original Message-
  Sent: Saturday, 22 June 2002 9:03 PM
  To: Multiple recipients of list ORACLE-L
 
 
  On Solaris
 
  ps -ef -opid,ppid,vsz=VIRTMEM -orss=PHYSMEM
 -opmem,pcpu,user,args
 
  use:
 
  psrinfo -v
  prtconf | grep Mem
  format
  uname -a
 
  HTH
 
  Richard
 
  -Original Message-
  Sent: Saturday, June 22, 2002 1:38 PM
  To: Multiple recipients

Re: Difference Between DBMS/RDBMS

2002-06-25 Thread Nicolai Tufar




Not all DBMS have features of RDBMS.
dBase or IBM's IMS are that come to 
mind.
There were hierachical databases, network 
databases,
ISAM (Indexed Sequential Acess Method) but these 
days, yes,
noDBMS can besuccessfull whitout 
`R'.

  - Original Message - 
  From: 
  Santosh 
  Varma 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, June 25, 2002 3:18 
PM
  Subject: RE: Difference Between 
  DBMS/RDBMS
  
  full 
  form i also knew.
  and 
  also that all dbms have the features of rdbms also
  then, what is the difference ??
  
  santosh
  
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 
Marcello SavinoSent: Tuesday, June 25, 2002 4:58 
PMTo: Multiple recipients of list ORACLE-LSubject: R: 
Difference Between DBMS/RDBMS
DBMS =Data Base Management System
RDBMS=Relational Data Base Management System
But actually i do not know any dbms that's not an rdbms. 

Bye , Marcello
-Messaggio originale-Da: Santosh Varma 
[mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 
11.48A: Multiple recipients of list ORACLE-LOggetto: 
Difference Between DBMS/RDBMS

  could any body 
  point me the difference(s) between DBMS and RDBMS ?? because in DBMS also 
  as in RDBMS, we can related two or more tables..if a column exists in 
  another table for relation ??
  Thanks and regards,
  Santosh

RE: HP-UX 11.0/8.1.6.2.0/Optimizer

2002-06-25 Thread Ferenc Mantfeld


Mike

Siebel does not support CBO either, and I have seen your exact problem.

If you have the segment level degree of parallelism on any of the tables or
indexes in the query with a non serial degree of parallelism, the optimizer
immediately invokes CBO for the query, regardless of what optimizer_mode is
set to, and of course in the absence of statistics, a query written for CBO
will stink like nothing stinketh, especially on large data set. I tore my
hair out for a day with such a query at a customer's site, and like you, all
I could say is 'ba-a-a-a-a-a-a'. But I will never forget it.

I'd love to chat more, but the game is about to start, and I want to see
Germany hand justice to Korea, though it will be difficult because the
Germans only have 11 players, and the Koreans up to now have had 14 on the
field (team plus ref plus two lines men ). At least I have my priorities
straight.

Hope that helps you.

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Only Robinson Crusoe had all his work done by Friday


-Original Message-
Sent: Monday, 24 June 2002 4:34 PM
To: Multiple recipients of list ORACLE-L


Hi All:

Here's a strange thing.  I did a reorg of a very nasty tablespace
over the weekend.  I broke it out into 4 new tablespaces for the
large tables and the rest into a single tablespace.  This database
has 'optimizer_mode = rule' set in the initSID.ora file because
the Cognos application can't seem to handle the CBO, so I did
not compute any statistics as part of the process.

Sounds like routine maintenance, right?

Nope.  It went weird.  One query, which included an outer join
and a sub-query went from about 2 minutes to not finishing in
over two hours.  All indexes and objects were back in the DB.  I
verified that about a dozen times, all with manglement breathing
down my neck.  I EXPLAINED the query till I was blue in the face.
I rebuilt (again!) all the indexes.  No joy.

Finally, I thought oh heck...might as well analyze them.

Shazzam.  Back to 2 minutes.  Huh?  But Optimizer-mode is RULE!!

How?  Why?  I look stupid and so does my whole DBA group.
Does anybody have any insights about this behavior?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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: Ferenc Mantfeld
  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).

NOT IN performance problem

2002-06-25 Thread Nils Höglund




Hello,

I have encountered a performance problem. I use Oracle8 Enterprise Edition
Release 8.0.5.0.0 - Production.

I have two tables. phonenumber and person, each person has none, one or
many phonenumbers referenced to him.

The phonenumber-table is structured like:
phonenumber.personid
phonenumber.phonenumber

The person-table is structured like:
person.personid
person.name
person.address


I wan't to know which persons that does NOT have any phonenumber(s).

I can write the query as:
SELECT personid FROM phonenumber WHERE personid NOT IN (
   SELECT personid FROM person);
   
However, since my tables are quite large, it takes forever to run my query.
In the real database both (or
atleast one) of person or phonenumber are views.

To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster.
(SELECT DISTINCT person.personid FROM person, phonenumber WHERE
person.personid=phonenumber.personid)

I'm wondering how I could restructure or rewrite my query (who doesn't have
any phoinenumbers?) to run faster, 
or if there is anything else I can do to optimize the query?

Any suggestions?


-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)736 51 74 58
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  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: recording SQLPlus activity

2002-06-25 Thread Richard Huntley

Title: RE: recording SQLPlus activity





Ray,


You must have an abundance of time on your hands, to be able to sift through every every
command entered by several hundred developers?? If they have their own login ids, let them
do whatever in their own schemas, but in protected schemas it's only right to put limits on
them so they can't hurt themselves or others. If tracking them is real important, though, check
out auditing--if you're going to capture the information, auditing requires you to keep an eye on it,
so at least you'll be paying attention to it in some way (people often like to collect data that they
never look at)


HTH,
Rich



-Original Message-
From: Ray Gordon [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 8:53 PM
To: Multiple recipients of list ORACLE-L
Subject: recording SQLPlus activity



I have just been moved to a group with several hundred developers, and to 
say the least the environment is chaotic.


Without putting limits on my developers (such as via READONLY user, etc.), 
is there some way that every command that a developer executes using SQLPlus 
gets recorded (by userid and time)?


Ray






_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Gordon
 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: Difference Between DBMS/RDBMS




OK.
First were pre-relational DBMS. Like fms, network, hierarchical; 
programmatic  pragmatic. Different types. Some are still 
useful.
Than Codd came with his 12 rules (12?) I believe 
INGRES was the fist onebased onhis research.
Than (80's) came Oracle, Sybase, DB2, Informix. 
btw, I believe Oracle was not relational until version... mmm 6 or 7? was 6 
relational?
Than came post-relational dbms with extended 
semantic, rule-based, etc.
90's - object oriented DB, spatial, distributed db, 
multi-dimensional, data warehouses and data mining, AI.
about 2000 came XML

They all seem to be DMBS, but not all are 
RDBMS.
In fact, can anybody name pure relational 
dbms?

What did I forget, missed or make 
wrong?

  - Original Message - 
  From: 
  Santosh 
  Varma 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, June 25, 2002 2:18 
PM
  Subject: RE: Difference Between 
  DBMS/RDBMS
  
  full 
  form i also knew.
  and 
  also that all dbms have the features of rdbms also
  then, what is the difference ??
  
  santosh
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Marcello SavinoSent: 
Tuesday, June 25, 2002 4:58 PMTo: Multiple recipients of list 
ORACLE-LSubject: R: Difference Between 
DBMS/RDBMS
DBMS =Data Base Management System
RDBMS=Relational Data Base Management System
But actually i do not know any dbms that's not an rdbms. 

Bye , Marcello
-Messaggio originale-Da: Santosh Varma 
[mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 
11.48A: Multiple recipients of list ORACLE-LOggetto: 
Difference Between DBMS/RDBMS

  could any body 
  point me the difference(s) between DBMS and RDBMS ?? because in DBMS also 
  as in RDBMS, we can related two or more tables..if a column exists in 
  another table for relation ??
  Thanks and regards,
  Santosh

Re: NOT IN performance problem

2002-06-25 Thread Dennis M. Heisler


select personid from person
where not exists (select '1' from phonenumber
where personid = person.personid);

Nils Höglund wrote:
 
 Hello,
 
 I have encountered a performance problem. I use Oracle8 Enterprise Edition
 Release 8.0.5.0.0 - Production.
 
 I have two tables. phonenumber and person, each person has none, one or
 many phonenumbers referenced to him.
 
 The phonenumber-table is structured like:
 phonenumber.personid
 phonenumber.phonenumber
 
 The person-table is structured like:
 person.personid
 person.name
 person.address
 
 I wan't to know which persons that does NOT have any phonenumber(s).
 
 I can write the query as:
 SELECT personid FROM phonenumber WHERE personid NOT IN (
SELECT personid FROM person);
 
 However, since my tables are quite large, it takes forever to run my query.
 In the real database both (or
 atleast one) of person or phonenumber are views.
 
 To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster.
 (SELECT DISTINCT person.personid FROM person, phonenumber WHERE
 person.personid=phonenumber.personid)
 
 I'm wondering how I could restructure or rewrite my query (who doesn't have
 any phoinenumbers?) to run faster,
 or if there is anything else I can do to optimize the query?
 
 Any suggestions?
 
 --
 /Nils Höglund, Naqua KB
 
 E-mail: [EMAIL PROTECTED]
 Web:http://www.naqua.se/
 Home Phone: +46 (0)18  30 09 19
 Cellular Phone: +46 (0)736 51 74 58
 Address:Nya Valsätrav. 26 B
 SE-756 46
 Uppsala, Sweden
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?Q?Nils_H=F6glund?=
   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: Dennis M. Heisler
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Robson, Peter

-Original Message-From: Marcello Savino
[mailto:[EMAIL PROTECTED]]Sent: 25 June 2002
12:28To: Multiple recipients of list ORACLE-LSubject: R:
Difference Between DBMS/RDBMS
DBMS
=Data Base Management System
RDBMS=Relational Data Base Management System
But actually i do not know any dbms that's not an
rdbms. [Robson,
Peter]

Try Oracle * -
hee hee hee !

More seriously - IMS
is non-relational. I'm sure we will be inundated with other products. But there are three major types - Network, Hierarchical and Relational. (Oh all
right, Object...).

peter

* ps - its a SQL
DBMS
.

Bye , Marcello
-Messaggio originale-Da: Santosh Varma
[mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002
11.48A: Multiple recipients of list ORACLE-LOggetto:
Difference Between DBMS/RDBMS

could any body
point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as
in RDBMS, we can related two or more tables..if a column exists in another
table for relation ??
Thanks and regards,
Santosh

*
This e-mail message, and any files transmitted with it, are
confidential and intended solely for the use of the addressee. If
this message was not addressed to you, you have received it in error
and any copying, distribution or other use of any part of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent those of the British
Geological Survey. The security of e-mail communication cannot be
guaranteed and the BGS accepts no liability for claims arising as a
result of the use of this medium to transmit messages from or to the
BGS. The BGS cannot accept any responsibility for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*

Re: Difference Between DBMS/RDBMS

2002-06-25 Thread Yechiel Adar




Well,DBMS do NOT always have relational 
attribute.
In the good old days there whereDBMS likeTotal 
or IMS
which are hierarchical DBMS

I am working on ADABAS on the mainframe. 
This DBMS have array and array of structure that exclude 
it
from the relational model. One of the fastest in the 
mainframe world.

Yechiel AdarMehish

  - Original Message - 
  From: 
  Santosh 
  Varma 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, June 25, 2002 2:18 
PM
  Subject: RE: Difference Between 
  DBMS/RDBMS
  
  full 
  form i also knew.
  and 
  also that all dbms have the features of rdbms also
  then, what is the difference ??
  
  santosh
  
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 
Marcello SavinoSent: Tuesday, June 25, 2002 4:58 
PMTo: Multiple recipients of list ORACLE-LSubject: R: 
Difference Between DBMS/RDBMS
DBMS =Data Base Management System
RDBMS=Relational Data Base Management System
But actually i do not know any dbms that's not an rdbms. 

Bye , Marcello
-Messaggio originale-Da: Santosh Varma 
[mailto:[EMAIL PROTECTED]]Inviato: martedì 25 giugno 2002 
11.48A: Multiple recipients of list ORACLE-LOggetto: 
Difference Between DBMS/RDBMS

  could any body 
  point me the difference(s) between DBMS and RDBMS ?? because in DBMS also 
  as in RDBMS, we can related two or more tables..if a column exists in 
  another table for relation ??
  Thanks and regards,
  Santosh

RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Mercadante, Thomas F


Oh you bunch of young whipper-snappers!

A long time ago in a place far-away, we started with simple File Systems.  
Then came ISAM file systems.
These begate DBMS systems.  Note there was no 'R' in original DBMS systems.
Some of these were simply an extention to ISAM files that allowed (and
demanded) a more formalized collection of files.  In these files, there were
tables and indexes and primary keys.  I remember these as Hierarchical
Database Systems.  Still no such thing as foreign keys.

Finally, I believe, DEC came out with the RBMS system which was (I know I
will be corrected on this) one of the first Relational Database Managment
Systems to be made available for large systems.  (I have no knowledge of IBM
products - anybody?  When did DB2 make itself known?).

On PC's there was also something called RDB I think.

See, its good to be old!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? 
 because in DBMS also as in RDBMS, we can related two or more 
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: Mercadante, Thomas F
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Santosh Varma



only fool's like you can point such differences...when not able to find
valid differences.

-Original Message-
Sent: Tuesday, June 25, 2002 5:54 PM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ??
 because in DBMS also as in RDBMS, we can related two or more
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
  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: Santosh Varma
  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: the ora certified masters cert, yet again

2002-06-25 Thread Jack Silvey


The question is, are you going to allow your
clearminded moral stance and total disdain for a
thinly veiled DBA tax to interfere with your pursuit
of filth lucre? *I* ain't!

;)

It is just another hoop to jump through so that a
hring manager can say that is an impressive hoop you
jumped through and you can respond yes, and I can
jump through some hoops for you too and allow them to
say here is an outrageous sum of money to work on our
computers. 

I love this job.

jack silvey
ocp 7.3, 8.0, 8i, 9i


--- Don Granaman [EMAIL PROTECTED] wrote:
 They aren't - unless it exceeds a non-trivial
 percentage (6%? 7%? more?  I
 can't remember now...) of their income and is
 required (?).
 
 This new requirement for OCP is just another in a
 long line of
 propaganda/baloney from Oracle in its never-ending
 attempts to suck up every
 buck it possibly can.  [Oracle likes $.  HR
 likes mindless checklist
 items.  It is a match made in heaven.]  I thought
 that the need practically
 any two ILT classes, no matter how irrelevant 9i
 OCM was going to be the
 limit of extending the the greedy grab for OCP bucks
 - for 9i at least.
 This isn't about certification anymore (as if it
 ever was), its about
 revenue.
 
 Since this new requirement (for the moment at
 least) doesn't apply to
 upgrade from an 8i certification, does anyone know
 if there is (or soon will
 be) a new constraint/surprise/ambush limiting that
 to 8i OCP obtained prior
 to, oh say, June 15, 2002?  September 2002?
 
 Don Granaman
 [OraSaurus - with more disdain than ever for the
 evil vampire Larry's OCP
 DBA tax]
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Friday, June 21, 2002 12:23 AM
 
 
  I thought employees were not allowed to write
 things off as business
  expenses...
 
  Confusedly yours,
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)
 
  -Original Message-
  Sent: Thursday, June 20, 2002 10:13 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: the ora certified masters cert, yet
 again
 
  Are you trying to promote it?
 
  -Original Message-
  Sent: Thursday, June 20, 2002 6:50 PM
  To: Multiple recipients of list ORACLE-L
 
 
  I am seriously considering pursuing one, since it
 can
  be sold to hiring managers as a sign of
 professional
  competence.
 
  Look at it from a cost/benefit ratio standpoint.
 Will
  someone with this cerifification make $2000 more
 over
  her professional life than she would without?
 
  So it takes a round trip ticket and three days of
  vacation. Get the company to pay for it or write
 it
  off as a business expense.
 
  Good investment, easy money, instant credibility
 to
  many hiring managers.
 
  jack silvey
 
 
 
 
 
   On 19 Jun 2002 at 4:38, Ron Rogers wrote:
  
   Date sent:  Wed, 19 Jun 2002 04:38:18 -0800
   To: Multiple recipients of list
   ORACLE-L [EMAIL PROTECTED]
  
It seems that our list has made mention in
 this
   report from
Searchdatabase.com. And Oracle is trying to
   justify the $2000 expence.
If I read this correct the $2000 is for 9i
 OCP.
===
LEAD STORY
   
ORACLE FUELS CERTIFICATION CONTROVERSY |
   SearchDatabase
Oracle has a new requirement for its potential
   certified
professionals, and the price tag is about
 $2,000.
   Many DBAs aren't
happy about the new policy but Oracle says the
   class makes their
certification more valuable than ever. Read
 the
   details of the new
mandate, and what DBAs and industry experts
 have
   to say about it.
   
For the full details, click:
   
  
 

http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht
  ml
  
   ...
  
  
   --
   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).
 
 
 
 
  __
  Do You Yahoo!?
  Yahoo! - Official partner of 2002 FIFA World Cup
  http://fifaworldcup.yahoo.com
  --
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  --
  Author: Jack Silvey
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

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 Testa [EMAIL PROTECTED] wrote:
 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 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 solve the problem open a TAR.
 
 Why are we paying so much $? Let them work !!!
 
 Yechiel Adar
 Mehish
 
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe Testa
   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!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Difference Between DBMS/RDBMS


Ah yes, what newcomers to the computer age! The part I always find
fascinating is that when the relational ideas were coming together around
the time Codd made his 12 rules, the big question was: will a relational
database ever be practical?. Another point is that there were many
competitors to SQL as a relational database access language at one time. In
the end, SQL won, many would claim not because it was the best, but because
of a series of the right historical circumstances coming together. Now, of
course, the SQL RDBMS rules the database kingdom. The non-SQL RDBMS is a
historical artifact. The non-RDBMS DBMS is still widely used in the
mainframe world. If you take a trip this summer, realize that your ticket is
probably processed by a non-relational DBMS and your aircraft is tracked by
a non-relational DBMS.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, June 25, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L


OK.
First were pre-relational DBMS. Like fms, network, hierarchical;
programmatic  pragmatic. Different types. Some are still useful.
Than Codd came with his 12 rules (12?) I believe INGRES was the fist one
based on his research.
Than (80's) came Oracle, Sybase, DB2, Informix. btw, I believe Oracle was
not relational until version... mmm 6 or 7? was 6 relational?
Than came post-relational dbms with extended semantic, rule-based, etc.
90's - object oriented DB, spatial, distributed db, multi-dimensional, data
warehouses and data mining, AI.
about 2000 came XML
 
They all seem to be DMBS, but not all are RDBMS.
In fact, can anybody name pure relational dbms?
 
What did I forget, missed or make wrong?

- Original Message - 
To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED]  
Sent: Tuesday, June 25, 2002 2:18 PM

full form i also knew.
and also that all dbms have the features of rdbms also
then, what is the difference ??
 
santosh

-Original Message-
[mailto:[EMAIL PROTECTED]]On Behalf Of Marcello Savino
Sent: Tuesday, June 25, 2002 4:58 PM
To: Multiple recipients of list ORACLE-L


DBMS =Data Base Management System
RDBMS=Relational Data Base Management System
But actually i do not know any dbms that's not an rdbms. 
Bye , Marcello
-Messaggio originale-
Da: Santosh Varma [mailto:[EMAIL PROTECTED]]
Inviato: martedì 25 giugno 2002 11.48
A: Multiple recipients of list ORACLE-L
Oggetto: Difference Between DBMS/RDBMS



could any body point me the difference(s) between DBMS and RDBMS ?? because
in DBMS also as in RDBMS, we can related two or more tables..if a column
exists in another table for relation ??

Thanks and regards,



Santosh

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
  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: NOT IN performance problem

2002-06-25 Thread Stephane Faroult


C'mon, Larry, don't be shy :-)


Hello,

I have encountered a performance problem. I use
Oracle8 Enterprise Edition
Release 8.0.5.0.0 - Production.

I have two tables. phonenumber and person, each
person has none, one or
many phonenumbers referenced to him.

The phonenumber-table is structured like:
phonenumber.personid
phonenumber.phonenumber

The person-table is structured like:
person.personid
person.name
person.address


I wan't to know which persons that does NOT have
any phonenumber(s).

I can write the query as:
SELECT personid FROM phonenumber WHERE personid NOT
IN (
   SELECT personid FROM person);
   
However, since my tables are quite large, it takes
forever to run my query.
In the real database both (or
atleast one) of person or phonenumber are
views.

To figure out who _does_ have phonenumbers is
SIGNIFICANTLY faster.
(SELECT DISTINCT person.personid FROM person,
phonenumber WHERE
person.personid=phonenumber.personid)

I'm wondering how I could restructure or rewrite my
query (who doesn't have
any phoinenumbers?) to run faster, 
or if there is anything else I can do to optimize
the query?

Any suggestions?


-- 
/Nils Höglund, Naqua KB

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  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: NOT IN performance problem


Move to EXISTS like this:

SELECT pn.personid
FROM phonenumber pn
WHERE NOT EXISTS (
SELECT NULL
FROM person p
WHERE p.personid=pn.personid);

--
hth
Alexandre

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 3:08 PM




 Hello,

 I have encountered a performance problem. I use Oracle8 Enterprise
Edition
 Release 8.0.5.0.0 - Production.

 I have two tables. phonenumber and person, each person has none, one
or
 many phonenumbers referenced to him.

 The phonenumber-table is structured like:
 phonenumber.personid
 phonenumber.phonenumber

 The person-table is structured like:
 person.personid
 person.name
 person.address


 I wan't to know which persons that does NOT have any phonenumber(s).

 I can write the query as:
 SELECT personid FROM phonenumber WHERE personid NOT IN (
SELECT personid FROM person);

 However, since my tables are quite large, it takes forever to run my
query.
 In the real database both (or
 atleast one) of person or phonenumber are views.

 To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster.
 (SELECT DISTINCT person.personid FROM person, phonenumber WHERE
 person.personid=phonenumber.personid)

 I'm wondering how I could restructure or rewrite my query (who doesn't
have
 any phoinenumbers?) to run faster,
 or if there is anything else I can do to optimize the query?

 Any suggestions?


 --
 /Nils Höglund, Naqua KB

 E-mail: [EMAIL PROTECTED]
 Web:http://www.naqua.se/
 Home Phone: +46 (0)18  30 09 19
 Cellular Phone: +46 (0)736 51 74 58
 Address:Nya Valsätrav. 26 B
 SE-756 46
 Uppsala, Sweden
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?Q?Nils_H=F6glund?=
   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: Alexandre Gorbatchev
  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: Backup and restore


Marcello - Oracle backup and recovery is an extensive subject because
different organization's requirements vary so widely. For example, a small
personal test database has very simple backup requirements, while a large
eCommerce Web site that absolutely must be up 24x7 has very complex ones.
Backup  recovery is one of the most important requirements for an Oracle
site and it is absolutely critical that you have a competent backup scheme
that matches your site's requirements. One good way to begin is to take the
Oracle Education class for Backup and Recovery, if that is available to you.
 Why don't you give us a hint as to what your requirements are, and some
of us can better advise you how to start. What Oracle version are you using?
How many databases? What type of server (Unix, NT)? Are you easily able to
shut the database down in evenings or weekends for a cold (offline) backup?
Include any other factors that you feel are significant to your backup and
recovery situation.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
 

-Original Message-
Sent: Tuesday, June 25, 2002 3:33 AM
To: Multiple recipients of list ORACLE-L


Hi i am an oracle newbie.
I can't find an exaustive explanation about backup and restore in Oracle.
I mean policy, commands and syntax without using wizards.
I did a fast run cross orafaq, but i can't find it ...
Any help 
thank you, Marcello
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marcello  Savino
  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: DENNIS WILLIAMS
  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: V9.2 SGA

2002-06-25 Thread Charlie Mengler


Thanks to all that replied.

oracle@actaeon:RPT# sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jun 25 06:24:55 2002

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

[EMAIL PROTECTED] sho sga

Total System Global Area   76514152 bytes
Fixed Size   729960 bytes
Variable Size  37748736 bytes
Database Buffers   33554432 bytes
Redo Buffers4481024 bytes

When I posted my plea yesterday I was extraordinarily tired  frustrated.
I'm a command line guy who dislikes GUI wizards, which includes OUI!

One of my ongoing complaints WRT the OUI is that it tends to pop
informational frames/boxes/windows, but I can NOT cut  paste or
otherwise capture the contents for later review and such. With V9.2
one such frame included a list of all the initSID.ora changes that
were made; such a V7 parameters which went away and V9 parameters
which were added.

I spent way too much time changing values within the initSID.ora
file without seeing any changes in the instance before I realized
that OUI had made an spfileSID.ora which was being used to the
exclusion of my initSID.ora file.

Thanks again to everyone who responded  I wish you have better
times with V9.2 than I did yesterday.

HAND!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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: NOT IN performance problem

2002-06-25 Thread Jan Pruner


Try EXISTS.
SELECT personid FROM person WHERE NOT EXISTS (
SELECT 0 FROM phonenumber WHERE person.personid=phonenumber.personid
);
You'll get all persons without any telephone number.

JP


On Tuesday 25 June 2002 15:08, Nils Höglund wrote:
 Hello,

 I have encountered a performance problem. I use Oracle8 Enterprise Edition
 Release 8.0.5.0.0 - Production.

 I have two tables. phonenumber and person, each person has none, one or
 many phonenumbers referenced to him.

 The phonenumber-table is structured like:
 phonenumber.personid
 phonenumber.phonenumber

 The person-table is structured like:
 person.personid
 person.name
 person.address


 I wan't to know which persons that does NOT have any phonenumber(s).

 I can write the query as:
 SELECT personid FROM phonenumber WHERE personid NOT IN (
SELECT personid FROM person);

 However, since my tables are quite large, it takes forever to run my query.
 In the real database both (or
 atleast one) of person or phonenumber are views.

 To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster.
 (SELECT DISTINCT person.personid FROM person, phonenumber WHERE
 person.personid=phonenumber.personid)

 I'm wondering how I could restructure or rewrite my query (who doesn't
 have any phoinenumbers?) to run faster,
 or if there is anything else I can do to optimize the query?

 Any suggestions?

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
--
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).

Fw: Installing Oracle 9i Release 2 RAC in a single node?

2002-06-25 Thread chaos


hi, dbas:
I ever tested 9i 9.0.1 in linux single node according to metalink note:
  166830.1 
Since 9i release 2 is out, it seems that we should conver to that version.
I Hope to setup 9i rac(release 2) on linux single node as 9i release 1, but 
cannot enable the RAC option as i did inrelease 1.
I had configured the cmcfg.ora like:
 [oracle@eachnettest admin]$ cat cmcfg.ora
HeartBeat=15000
ClusterName=Oracle Cluster Manager, version 9i
PollInterval=1000
MissCount=20
PrivateNodeNames=eachnettest 
PublicNodeNames=eachnettest 
ServicePort=9998
WatchdogSafetyMargin=5000
WatchdogTimerMargin=6
CmDiskFile=/home/oracle/oradata/RAC_Node_Monitor_file

and started softdog deamon and oracm .
But when i begin to install the software, rac option just refuse to come out.

[oracle@eachnettest admin]$ ps -ef|grep ora
root  1001  1000  0 20:42 pts/000:00:00 login -- oracle 
oracle1002  1001  0 20:42 pts/000:00:00 -bash
root  1046  1045  0 20:43 pts/100:00:00 login -- oracle 
oracle1047  1046  0 20:43 pts/100:00:00 -bash
root  1273 1  0 20:50 pts/000:00:00 oracm
root  1275  1273  0 20:50 pts/000:00:00 oracm
root  1276  1275  0 20:50 pts/000:00:00 oracm
root  1277  1275  0 20:50 pts/000:00:00 oracm
root  1278  1275  0 20:50 pts/000:00:00 oracm
root  1279  1275  0 20:50 pts/000:00:00 oracm
root  1280  1275  0 20:50 pts/000:00:00 oracm
root  1281  1275  0 20:50 pts/000:00:00 oracm
root  1282  1275  0 20:50 pts/000:00:00 oracm
oracle1310  1047  0 20:51 pts/100:00:00 xterm
oracle1312  1310  0 20:51 pts/200:00:00 bash
oracle1526  1047  0 21:29 pts/100:00:00 ps -ef
oracle1527  1047  0 21:29 pts/100:00:00 grep ora
Can someone help?



Good luck


chaos
[EMAIL PROTECTED]

zhu chao
DBA of Eachnet.com
86-021-32174588-667


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: chaos
  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: SEQ#, DUAL and Oracle literacy

2002-06-25 Thread Orr, Steve


 I had to ponder this for a few seconds.
Economize synapses... paste and execute in SQL*Plus.


-Original Message-
Sent: Saturday, June 22, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L

LOL!  I had to ponder this for a few seconds.

Good one Steve.

Jared

On Tuesday 18 June 2002 14:23, Orr, Steve wrote:
 Here's a performance tuning query to help identify the problem:

 SELECT  column_name The problem is the...
 FROMdba_tab_columns
 WHERE   owner='SYS'
 AND table_name = 'DUAL'
 /

 :-)

 -Original Message-
 Sent: Tuesday, June 18, 2002 3:07 PM
 To: Multiple recipients of list ORACLE-L

 Want to have a good laugh?... read on... I don't  think its OT :)

 A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle
 Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the
 application will get a *specific* Sequence Number for something.

 DBA: Why do you think DUAL is the problem?
 Duhveloper:  ...'cause I see the PL/SQL code that says 'from dual'.

 Boy! Are we in trouble or what??   ;)

 - Kirti
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  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: NOT IN performance problem

2002-06-25 Thread Yechiel Adar


Maybe you can get faster results with minus:
select distinct personid from persons
minus
select distinct personid from phones

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 3:08 PM




 Hello,

 I have encountered a performance problem. I use Oracle8 Enterprise
Edition
 Release 8.0.5.0.0 - Production.

 I have two tables. phonenumber and person, each person has none, one
or
 many phonenumbers referenced to him.

 The phonenumber-table is structured like:
 phonenumber.personid
 phonenumber.phonenumber

 The person-table is structured like:
 person.personid
 person.name
 person.address


 I wan't to know which persons that does NOT have any phonenumber(s).

 I can write the query as:
 SELECT personid FROM phonenumber WHERE personid NOT IN (
SELECT personid FROM person);

 However, since my tables are quite large, it takes forever to run my
query.
 In the real database both (or
 atleast one) of person or phonenumber are views.

 To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster.
 (SELECT DISTINCT person.personid FROM person, phonenumber WHERE
 person.personid=phonenumber.personid)

 I'm wondering how I could restructure or rewrite my query (who doesn't
have
 any phoinenumbers?) to run faster,
 or if there is anything else I can do to optimize the query?

 Any suggestions?


 --
 /Nils Höglund, Naqua KB

 E-mail: [EMAIL PROTECTED]
 Web:http://www.naqua.se/
 Home Phone: +46 (0)18  30 09 19
 Cellular Phone: +46 (0)736 51 74 58
 Address:Nya Valsätrav. 26 B
 SE-756 46
 Uppsala, Sweden
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?Q?Nils_H=F6glund?=
   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: Yechiel Adar
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Robertson Lee - lerobe


Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K
ram !!


-Original Message-
Sent: 25 June 2002 15:58
To: Multiple recipients of list ORACLE-L


Tom,

As I recall DB2 on a PC came about way back in the dark days of the 8080
processor and DOS (no version) somewhere around 1980 I believe.  I seem to
vaguely remember running it on a very old (now a days) predecessor of the
laptop.  If memory is serving I believe it was called an Osborne?  RDB was
offered on the IBM mainframe and there was a VAX version that I remember
playing
with as well.

Yeah, it's good to be old and reflect on the twists  turns we went
through
to make things work.  Anyone remember programming with less than 1MB of ram?
I
remember trying to make things work on 16K.

Dick Goulet
Human memory is fragile, thank GOD!

Reply Separator
Author: Mercadante; Thomas F [EMAIL PROTECTED]
Date:   6/25/2002 6:08 AM

Oh you bunch of young whipper-snappers!

A long time ago in a place far-away, we started with simple File Systems.  
Then came ISAM file systems.
These begate DBMS systems.  Note there was no 'R' in original DBMS systems.
Some of these were simply an extention to ISAM files that allowed (and
demanded) a more formalized collection of files.  In these files, there were
tables and indexes and primary keys.  I remember these as Hierarchical
Database Systems.  Still no such thing as foreign keys.

Finally, I believe, DEC came out with the RBMS system which was (I know I
will be corrected on this) one of the first Relational Database Managment
Systems to be made available for large systems.  (I have no knowledge of IBM
products - anybody?  When did DB2 make itself known?).

On PC's there was also something called RDB I think.

See, its good to be old!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? 
 because in DBMS also as in RDBMS, we can related two or more 
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



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




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

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

Fat City Network Services-- (858)

RE: NOT IN performance problem

2002-06-25 Thread Richard Huntley

Title: RE: NOT IN performance problem





Nils, try this...(replaces NOT IN with an Outer Join)


select a.id from person a, phonenumber b
where a.id = b.id(+)
and b.id is null;


-Original Message-
From: Nils Höglund [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Subject: NOT IN performance problem





Hello,


I have encountered a performance problem. I use Oracle8 Enterprise Edition
Release 8.0.5.0.0 - Production.


I have two tables. phonenumber and person, each person has none, one or
many phonenumbers referenced to him.


The phonenumber-table is structured like:
phonenumber.personid
phonenumber.phonenumber


The person-table is structured like:
person.personid
person.name
person.address



I wan't to know which persons that does NOT have any phonenumber(s).


I can write the query as:
SELECT personid FROM phonenumber WHERE personid NOT IN (
 SELECT personid FROM person);
 
However, since my tables are quite large, it takes forever to run my query.
In the real database both (or
atleast one) of person or phonenumber are views.


To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster.
(SELECT DISTINCT person.personid FROM person, phonenumber WHERE
person.personid=phonenumber.personid)


I'm wondering how I could restructure or rewrite my query (who doesn't have
any phoinenumbers?) to run faster, 
or if there is anything else I can do to optimize the query?


Any suggestions?



-- 
/Nils Höglund, Naqua KB


E-mail: [EMAIL PROTECTED]
Web: http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)736 51 74 58
Address: Nya Valsätrav. 26 B
 SE-756 46
 Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
 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: R: Backup and restore

2002-06-25 Thread Suzy Vordos



http://technet.oracle.com/docs/content.html

Marcello Savino wrote:
 
 What is RFTM (Rapid Fast Training Machine ? ;-)
 How can i get into a RFTM ?
 Sorry but, you know, i am a newbie .
 Marcello
 
 Marcello,
 Didn't you find the answer for the most common kind of questions in Oracle
 FAQs? The answer is RTFM.
 Fasten your seatbelts and get into, for examlpe, Oracle Backup and
 Recovery
 Concepts or better  Oracle Backup and Recovery Documentation Online
 Roadmap.
 Good Luck!
 --
 Alexandre
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Marcello  Savino
   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: Suzy Vordos
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Eric D. Pierce


did you ever read a basic college level textbook on database technology?

google search on codd date rdbms yielded the following:

http://www.palslib.com/Fundamentals/The_Relational_Model.html

enjoy,
ep


On 25 Jun 2002 at 1:48, Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS 
 also as in RDBMS, we can related two or more tables..if a column exists in another 
table for 
 relation ??

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

Re:RE: Difference Between DBMS/RDBMS

2002-06-25 Thread dgoulet


Tom,

As I recall DB2 on a PC came about way back in the dark days of the 8080
processor and DOS (no version) somewhere around 1980 I believe.  I seem to
vaguely remember running it on a very old (now a days) predecessor of the
laptop.  If memory is serving I believe it was called an Osborne?  RDB was
offered on the IBM mainframe and there was a VAX version that I remember playing
with as well.

Yeah, it's good to be old and reflect on the twists  turns we went through
to make things work.  Anyone remember programming with less than 1MB of ram?  I
remember trying to make things work on 16K.

Dick Goulet
Human memory is fragile, thank GOD!

Reply Separator
Author: Mercadante; Thomas F [EMAIL PROTECTED]
Date:   6/25/2002 6:08 AM

Oh you bunch of young whipper-snappers!

A long time ago in a place far-away, we started with simple File Systems.  
Then came ISAM file systems.
These begate DBMS systems.  Note there was no 'R' in original DBMS systems.
Some of these were simply an extention to ISAM files that allowed (and
demanded) a more formalized collection of files.  In these files, there were
tables and indexes and primary keys.  I remember these as Hierarchical
Database Systems.  Still no such thing as foreign keys.

Finally, I believe, DEC came out with the RBMS system which was (I know I
will be corrected on this) one of the first Relational Database Managment
Systems to be made available for large systems.  (I have no knowledge of IBM
products - anybody?  When did DB2 make itself known?).

On PC's there was also something called RDB I think.

See, its good to be old!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? 
 because in DBMS also as in RDBMS, we can related two or more 
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: Mercadante, Thomas F
  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: 
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Rachel Carmichael


Wang Basic (anyone else remember Wang computers?) in 64K of ram

rather than rewrite the system when we maxed out on allowable
datafiles, the manager of the system (can you say desperate for job
security?) found a product which emulated the Wang machine on a VAX but
allowed you to expand the number of datafiles. Still limited to 64K of
memory though.


--- [EMAIL PROTECTED] wrote:
 Tom,
 
 As I recall DB2 on a PC came about way back in the dark days of
 the 8080
 processor and DOS (no version) somewhere around 1980 I believe.  I
 seem to
 vaguely remember running it on a very old (now a days) predecessor of
 the
 laptop.  If memory is serving I believe it was called an Osborne? 
 RDB was
 offered on the IBM mainframe and there was a VAX version that I
 remember playing
 with as well.
 
 Yeah, it's good to be old and reflect on the twists  turns we
 went through
 to make things work.  Anyone remember programming with less than 1MB
 of ram?  I
 remember trying to make things work on 16K.
 
 Dick Goulet
 Human memory is fragile, thank GOD!
 
 Reply Separator
 Author: Mercadante; Thomas F [EMAIL PROTECTED]
 Date:   6/25/2002 6:08 AM
 
 Oh you bunch of young whipper-snappers!
 
 A long time ago in a place far-away, we started with simple File
 Systems.  
 Then came ISAM file systems.
 These begate DBMS systems.  Note there was no 'R' in original DBMS
 systems.
 Some of these were simply an extention to ISAM files that allowed
 (and
 demanded) a more formalized collection of files.  In these files,
 there were
 tables and indexes and primary keys.  I remember these as
 Hierarchical
 Database Systems.  Still no such thing as foreign keys.
 
 Finally, I believe, DEC came out with the RBMS system which was (I
 know I
 will be corrected on this) one of the first Relational Database
 Managment
 Systems to be made available for large systems.  (I have no knowledge
 of IBM
 products - anybody?  When did DB2 make itself known?).
 
 On PC's there was also something called RDB I think.
 
 See, its good to be old!
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Tuesday, June 25, 2002 8:24 AM
 To: Multiple recipients of list ORACLE-L
 
 
 i give up the R, is that the difference?
 
 joe
 
 
 Santosh Varma wrote:
 
  could any body point me the difference(s) between DBMS and RDBMS ??
 
  because in DBMS also as in RDBMS, we can related two or more 
  tables..if a column exists in another table for relation ??
 
  Thanks and regards,
 
  Santosh
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe Testa
   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: Mercadante, Thomas F
   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: 
   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!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

Re: the ora certified masters cert, yet again

2002-06-25 Thread Rachel Carmichael


okay, I realize this won't work for everyone on this list but...

I hand them my resume. the third page of which is FILLED with lists of
presentations I have given, awards I have gotten for presentations I
have given and books I have written

if they STILL want me to have OCP on my resume after that, I don't want
to work there anyway

--- Jack Silvey [EMAIL PROTECTED] wrote:
 The question is, are you going to allow your
 clearminded moral stance and total disdain for a
 thinly veiled DBA tax to interfere with your pursuit
 of filth lucre? *I* ain't!
 
 ;)
 
 It is just another hoop to jump through so that a
 hring manager can say that is an impressive hoop you
 jumped through and you can respond yes, and I can
 jump through some hoops for you too and allow them to
 say here is an outrageous sum of money to work on our
 computers. 
 
 I love this job.
 
 jack silvey
 ocp 7.3, 8.0, 8i, 9i
 
 
 --- Don Granaman [EMAIL PROTECTED] wrote:
  They aren't - unless it exceeds a non-trivial
  percentage (6%? 7%? more?  I
  can't remember now...) of their income and is
  required (?).
  
  This new requirement for OCP is just another in a
  long line of
  propaganda/baloney from Oracle in its never-ending
  attempts to suck up every
  buck it possibly can.  [Oracle likes $.  HR
  likes mindless checklist
  items.  It is a match made in heaven.]  I thought
  that the need practically
  any two ILT classes, no matter how irrelevant 9i
  OCM was going to be the
  limit of extending the the greedy grab for OCP bucks
  - for 9i at least.
  This isn't about certification anymore (as if it
  ever was), its about
  revenue.
  
  Since this new requirement (for the moment at
  least) doesn't apply to
  upgrade from an 8i certification, does anyone know
  if there is (or soon will
  be) a new constraint/surprise/ambush limiting that
  to 8i OCP obtained prior
  to, oh say, June 15, 2002?  September 2002?
  
  Don Granaman
  [OraSaurus - with more disdain than ever for the
  evil vampire Larry's OCP
  DBA tax]
  
  - Original Message -
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Sent: Friday, June 21, 2002 12:23 AM
  
  
   I thought employees were not allowed to write
  things off as business
   expenses...
  
   Confusedly yours,
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
  
   -Original Message-
   Sent: Thursday, June 20, 2002 10:13 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: the ora certified masters cert, yet
  again
  
   Are you trying to promote it?
  
   -Original Message-
   Sent: Thursday, June 20, 2002 6:50 PM
   To: Multiple recipients of list ORACLE-L
  
  
   I am seriously considering pursuing one, since it
  can
   be sold to hiring managers as a sign of
  professional
   competence.
  
   Look at it from a cost/benefit ratio standpoint.
  Will
   someone with this cerifification make $2000 more
  over
   her professional life than she would without?
  
   So it takes a round trip ticket and three days of
   vacation. Get the company to pay for it or write
  it
   off as a business expense.
  
   Good investment, easy money, instant credibility
  to
   many hiring managers.
  
   jack silvey
  
  
  
  
  
On 19 Jun 2002 at 4:38, Ron Rogers wrote:
   
Date sent:  Wed, 19 Jun 2002 04:38:18 -0800
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
   
 It seems that our list has made mention in
  this
report from
 Searchdatabase.com. And Oracle is trying to
justify the $2000 expence.
 If I read this correct the $2000 is for 9i
  OCP.
 ===
 LEAD STORY

 ORACLE FUELS CERTIFICATION CONTROVERSY |
SearchDatabase
 Oracle has a new requirement for its potential
certified
 professionals, and the price tag is about
  $2,000.
Many DBAs aren't
 happy about the new policy but Oracle says the
class makes their
 certification more valuable than ever. Read
  the
details of the new
 mandate, and what DBAs and industry experts
  have
to say about it.

 For the full details, click:

   
  
 

http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht
   ml
   
...
   
   
--
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

Re: NOT IN performance problem

2002-06-25 Thread Pat Hildebrand



 
 
 
 Hello,
 
 I have encountered a performance problem. I use Oracle8 Enterprise Edition
 Release 8.0.5.0.0 - Production.
 
 I have two tables. phonenumber and person, each person has none, one or
 many phonenumbers referenced to him.
I'm not sure what you want since your query doesn't correspond to what
you are saying you want. Therefore no sample just a general statement,
use minus.

 Pat




 
 The phonenumber-table is structured like:
 phonenumber.personid
 phonenumber.phonenumber
 
 The person-table is structured like:
 person.personid
 person.name
 person.address
 
 
 I wan't to know which persons that does NOT have any phonenumber(s).
 
 I can write the query as:
 SELECT personid FROM phonenumber WHERE personid NOT IN (
SELECT personid FROM person);

 However, since my tables are quite large, it takes forever to run my query.
 In the real database both (or
 atleast one) of person or phonenumber are views.
 
 To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster.
 (SELECT DISTINCT person.personid FROM person, phonenumber WHERE
 person.personid=phonenumber.personid)
 
 I'm wondering how I could restructure or rewrite my query (who doesn't have
 any phoinenumbers?) to run faster, 
 or if there is anything else I can do to optimize the query?
 
 Any suggestions?
 
 
 -- 
 /Nils Höglund, Naqua KB
 
 E-mail: [EMAIL PROTECTED]
 Web:http://www.naqua.se/
 Home Phone: +46 (0)18  30 09 19
 Cellular Phone: +46 (0)736 51 74 58
 Address:Nya Valsätrav. 26 B
 SE-756 46
 Uppsala, Sweden
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: =?iso-8859-1?Q?Nils_H=F6glund?=
   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: Pat Hildebrand
  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).

Remote execution of pl/sql

2002-06-25 Thread John Weatherman


I am in the process of writing a pl/sql block to run on instance A.  At one
point, I need to run a procedure that resides in instance B against instance
B's dataset.  Is there an easy way to do this?

The basic problem is:

  ### Set up Instance Source for replication ###
  ...
  ...
  dbms_offline_og.begin_instantiation(gname = 'gname', new_site =
'new_site');

  ### Execute begin load against target ###
  dbms_offline_og.begin_load(gname = 'gname', new_site = 'new_site');
  
  ### Return to Instance A to return code if everything is ready ###

Is it possible to issue a connect within a PL/Sql block?

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  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: HP-UX 11.0/8.1.6.2.0/Optimizer

2002-06-25 Thread John . Hallas


Ferenc,

Looks like you got your way with the result. Depressing but true
What happened to your web site, is it still up and if so what is the URL

Regards

John


-Original Message-
Sent: 25 June 2002 13:33
To: Multiple recipients of list ORACLE-L


Mike

Siebel does not support CBO either, and I have seen your exact problem.

If you have the segment level degree of parallelism on any of the tables or
indexes in the query with a non serial degree of parallelism, the optimizer
immediately invokes CBO for the query, regardless of what optimizer_mode is
set to, and of course in the absence of statistics, a query written for CBO
will stink like nothing stinketh, especially on large data set. I tore my
hair out for a day with such a query at a customer's site, and like you, all
I could say is 'ba-a-a-a-a-a-a'. But I will never forget it.

I'd love to chat more, but the game is about to start, and I want to see
Germany hand justice to Korea, though it will be difficult because the
Germans only have 11 players, and the Koreans up to now have had 14 on the
field (team plus ref plus two lines men ). At least I have my priorities
straight.

Hope that helps you.

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Only Robinson Crusoe had all his work done by Friday


-Original Message-
Sent: Monday, 24 June 2002 4:34 PM
To: Multiple recipients of list ORACLE-L


Hi All:

Here's a strange thing.  I did a reorg of a very nasty tablespace
over the weekend.  I broke it out into 4 new tablespaces for the
large tables and the rest into a single tablespace.  This database
has 'optimizer_mode = rule' set in the initSID.ora file because
the Cognos application can't seem to handle the CBO, so I did
not compute any statistics as part of the process.

Sounds like routine maintenance, right?

Nope.  It went weird.  One query, which included an outer join
and a sub-query went from about 2 minutes to not finishing in
over two hours.  All indexes and objects were back in the DB.  I
verified that about a dozen times, all with manglement breathing
down my neck.  I EXPLAINED the query till I was blue in the face.
I rebuilt (again!) all the indexes.  No joy.

Finally, I thought oh heck...might as well analyze them.

Shazzam.  Back to 2 minutes.  Huh?  But Optimizer-mode is RULE!!

How?  Why?  I look stupid and so does my whole DBA group.
Does anybody have any insights about this behavior?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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: Ferenc Mantfeld
  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: 
  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: RTFM/ SUPPORT, etc WASRe: Index Constraint


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 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 Testa [EMAIL PROTECTED] wrote:

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 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 solve the problem open a TAR.

Why are we paying so much $? Let them work !!!

Yechiel Adar
Mehish




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com



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


Santosh, byte me.  Since if you got off your a$$ and did some research 
you'd find out the differences.

joe


Santosh Varma wrote:

only fool's like you can point such differences...when not able to find
valid differences.

-Original Message-
Sent: Tuesday, June 25, 2002 5:54 PM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

could any body point me the difference(s) between DBMS and RDBMS ??
because in DBMS also as in RDBMS, we can related two or more
tables..if a column exists in another table for relation ??

Thanks and regards,

Santosh



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

2002-06-25 Thread Connor McDonald


For the previous poster, my understanding of
_disable_logging is that all of the normal operations
take place EXCEPT the actual physical write.  Hence
you will get log switches, check points etc etc.  If
you were *really* needing to use it (say for a large
load on a non-production system) then you would want
massive log files to minimise the switch frequency

hth
connor


 --- Tim Gorman [EMAIL PROTECTED] wrote:  I
hesitated mentioning that parameter in this forum,
 but I figured what the
 heck?  Could be fun, in a sick way...  :-)
 
 Once I was teaching a DBA class and mentioned
 _DISABLE_LOGGING.
 Immediately, I saw every head in the class look
 down, scribbling furiously!
 I had to backtrack very quickly and warn of the
 consequences of disabling
 redo logging (i.e. database corruption if not
 shutdown normally for any
 reason)...
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Monday, June 24, 2002 2:48 PM
 
 
  Hi Tim
 
  Yes, I have tried the _disable_logging, does not
 work on all platforms. DB
  starts up fine, but redo log is generated,
 evidenced by log switching
 going
  on.
 
  Also if I do a normal DML (large-ish one to
 verify), then dump the redo
 log,
  I see my transaction there, so for a 420R, running
 Solaris8 and Oracle
  9.0.1, it would seem that _disable_logging does
 not work.
 
  I don't want to complicate the picture even
 further with transportable
  tablespaces, which would mean that I would need to
 store all dependent
  objects (in this case indexes only) in the same
 tablespace, which I could
  easily achieve by rebuilding all indexes using a
 dynamic SQL.
 
  Informatica BTW does not only do single level
 inserts, version 5.0 onwards
  has a 'bulk load' feature, but I am not sure what
 this actually does.
  Previously Sagent also had a 'direct load' switch,
 which meant that it
 wrote
  all of its data to large (very large) flat files
 and then used Sql*Loader
  direct path to load. Fast, but Sagent at the time
 was very unreliable,
  because on identical runs, it would sometimes load
 all the data, sometimes
  only a portion, and every time, would report no
 errors and everything
 hunky
  dory, until you went looking for your data. I
 remember that took me about
 a
  week of arguing to prove that Sagent was at fault.
 
  Thanks for the suggestion of the Non volatile RAM
 (NVRAM) unit, it makes
 the
  most sense. I will suggest this to my damagers.
 
  Regards:
  Ferenc Mantfeld
  Senior Performance Engineer
  Siebel Performance Engineering
  Melbourne, 3000, VIC, Australia
  Only Robinson Crusoe had all his work done by
 Friday
 
 
  -Original Message-
  Sent: Sunday, 23 June 2002 9:03 PM
  To: Multiple recipients of list ORACLE-L
 
 
  Have you considered setting _DISABLE_LOGGING =
 TRUE
  instead?  It could be just as disastrous...  ;-)
 
  Buying an NVRAM unit would probably be more
 sensible, since
  at least then you have some probability of the
 file-system
  on such a unit surviving node failure or restart.
 
  I don't use Informatica, but I believe it mainly
 does
  single-row inserts, so not using the APPEND hint
 is a
  blessing anyway.  After all, who likes one row in
 each
  database block?  However, I could be wrong about
 that and it
  may actually be performing multi-row/array
 insertions...
 
  I don't know what your loads are like, but how
 about
  something like this instead?
 
- create a small database with _DISABLE_LOGGING
 set to
  TRUE
- use Informatica to load into a tablespace on
 that small,
  sacrificial db
- use transportable tablespace to copy the
 tablespace to
  your real DW
 
  Just an idea (better you than me to try it!)...
 
  - Original Message -
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Sent: Sunday, June 23, 2002 8:53 PM
 
 
   Hi All
  
   does anyone have any white paper or info on how
 to
  configure a dedicated
   portion of real memory as a virtual drive on
 Solaris ? I
  want to move my
   online redo logs (4 X 128 M single threaded) for
 a 300 GB
  DW onto it, to
   speed up Informatica ETL, since Informatica does
 not allow
  me to specify /*+
   APPEND */ mode of insert. I know I will not
 bypass the SQL
  layer this way,
   but at least, the LGWR will be writing to memory
 instead
  of disk. Thanks in
   advance.
  
   Regards:
   Ferenc Mantfeld
   Senior Performance Engineer
   Siebel Performance Engineering
   Melbourne, 3000, VIC, Australia
   Only Robinson Crusoe had all his work done by
 Friday
  
  
   -Original Message-
   Sent: Saturday, 22 June 2002 9:03 PM
   To: Multiple recipients of list ORACLE-L
  
  
   On Solaris
  
   ps -ef -opid,ppid,vsz=VIRTMEM -orss=PHYSMEM
  -opmem,pcpu,user,args
  
   use:
  
   psrinfo -v
   prtconf | grep Mem
   format
   uname -a
  
   HTH
  
   Richard
  
   -Original Message-
   Sent: Saturday, June 22, 2002 1:38 PM
   To: Multiple recipients of list ORACLE-L

Re: Difference Between DBMS/RDBMS

2002-06-25 Thread Nicolai Tufar


Oracle was the first commercial Realtional Database Management System.
And it was relational from day one (version two :), and it was built with 
relational theory in mind. IBM was the first to implement RDBMS though. 
It was called System R, or something, later it became known as DB2.

Take a look at this paper:
http://www.mcjones.org/System_R/SQL_Reunion_95/index.html

Very fascinating reading. They tell how Larry was trying to get tle list
of DB2 error codes so that Oracle would be compatible with it.
Also a bit about Larry luring IBM engeneers promising that they
would become millionares with Oracle. He was right.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicolai Tufar
  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).

R: Backup and restore


Ok Oracle 8i
1 development DB (a very small one) installed on a W2K Pro (NT)
I can shutdown DB at any time.
I need a cold backup just in case i have to recover the whole DB.
An Export/import script (dump/load to/from  ascii files) would be enough for
me.
Tanks in advance, Marcello
PS(the wizard does not work , other way ...)



-Messaggio originale-
Da: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Inviato: martedì 25 giugno 2002 16.08
A: Multiple recipients of list ORACLE-L
Oggetto: RE: Backup and restore


Marcello - Oracle backup and recovery is an extensive subject because
different organization's requirements vary so widely. For example, a small
personal test database has very simple backup requirements, while a large
eCommerce Web site that absolutely must be up 24x7 has very complex ones.
Backup  recovery is one of the most important requirements for an Oracle
site and it is absolutely critical that you have a competent backup scheme
that matches your site's requirements. One good way to begin is to take the
Oracle Education class for Backup and Recovery, if that is available to you.
 Why don't you give us a hint as to what your requirements are, and some
of us can better advise you how to start. What Oracle version are you using?
How many databases? What type of server (Unix, NT)? Are you easily able to
shut the database down in evenings or weekends for a cold (offline) backup?
Include any other factors that you feel are significant to your backup and
recovery situation.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
 

-Original Message-
Sent: Tuesday, June 25, 2002 3:33 AM
To: Multiple recipients of list ORACLE-L


Hi i am an oracle newbie.
I can't find an exaustive explanation about backup and restore in Oracle.
I mean policy, commands and syntax without using wizards.
I did a fast run cross orafaq, but i can't find it ...
Any help 
thank you, Marcello
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marcello  Savino
  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: DENNIS WILLIAMS
  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: Marcello  Savino
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Charlie Mengler




[EMAIL PROTECTED] wrote:
[...snip...]
 
 Yeah, it's good to be old and reflect on the twists  turns we went through
 to make things work.  Anyone remember programming with less than 1MB of ram?  I
 remember trying to make things work on 16K.

In 1967 I learned machine language programming on a Univac box with only 8K words.

I was the Sys. Admin on a VAX 11/780 (VMS V1.3) in 1979 which had 256KB of RAM 
and supported a s/w development staff of more than a dozen programmers!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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: V9.2 SGA

2002-06-25 Thread Ramon E. Estevez


Joe, what happened with your weekly tip about 9i ?

Ramon

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 9:58 PM


 For those who dont know(and might not care),
 
 OLD: db_block_buffers
 NEW: db_cache_size
 OLD: buffer_pool_keep
 NEW: db_keep_cache_size
 OLD: buffer_pool_recycle
 NEW: db_recycle_cache_size
 
 NEW: db_2K_cache_size
 NEW: db_4k_cache_size
 NEW: db_8k_cache_size
 NEW: db_16K_cache_size
 NEW: db_32K_cache_size
 NEW: sga_max_size
 
 Joe
 
 
 
 Jared Still wrote:
 
 Try shared_pool_size, large_pool_size, java_pool_size and 
 shared_pool_reserved size.
 
 This is from 8i, there may be additional ones on 9i, or 1 or 2 
 of those I mentioned may be deprecated.
 
 Jared
 
 On Monday 24 June 2002 15:05, Charlie Mengler wrote:
 
 Yes, I know I need to RTFM, but if some kine soul has a quick
 answer for me, I'd appreciate it.
 
 startup
 
 ORACLE instance started.
 
 Total System Global Area  168788768 bytes
 Fixed Size   729888 bytes
 Variable Size 100663296 bytes
 Database Buffers   33554432 bytes
 Redo Buffers   33841152 bytes
 Database mounted.
 Database opened.
 
 exit
 
 Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit
 Production With the Partitioning, OLAP and Oracle Data Mining options
 JServer Release 9.2.0.1.0 - Production
 oracle@actaeon:CAN#
 
 
 I just got done upgrading two V7.3.4.5 instances to V9.2 on a sandbox
 which has only 256MB RAM. Both SGAs are currently sized the same way.
 The OS is paging/swapping like carzy because SGA1+SGA2256MB. :-(
 
 Which initSGA.ora parameters control the Variable Size piece of
 the 9i SGA? I'd like to shrink this total to around 32MB.
 
 TIA  HAND!
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Joe Testa
   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: Ramon E. Estevez
  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: NOT IN performance problem

2002-06-25 Thread Charlie Mengler


select personid from person_table
minus
select personid from phonenumber_table
/

Nils Höglund wrote:
 
 Hello,
 
 I have encountered a performance problem. I use Oracle8 Enterprise Edition
 Release 8.0.5.0.0 - Production.
 
 I have two tables. phonenumber and person, each person has none, one or
 many phonenumbers referenced to him.
 
 The phonenumber-table is structured like:
 phonenumber.personid
 phonenumber.phonenumber
 
 The person-table is structured like:
 person.personid
 person.name
 person.address
 
 I wan't to know which persons that does NOT have any phonenumber(s).
 
 I can write the query as:
 SELECT personid FROM phonenumber WHERE personid NOT IN (
SELECT personid FROM person);
 
 However, since my tables are quite large, it takes forever to run my query.
 In the real database both (or
 atleast one) of person or phonenumber are views.
 
 To figure out who _does_ have phonenumbers is SIGNIFICANTLY faster.
 (SELECT DISTINCT person.personid FROM person, phonenumber WHERE
 person.personid=phonenumber.personid)
 
 I'm wondering how I could restructure or rewrite my query (who doesn't have
 any phoinenumbers?) to run faster,
 or if there is anything else I can do to optimize the query?
 
 Any suggestions?
 
 --
 /Nils Höglund, Naqua KB
 
 E-mail: [EMAIL PROTECTED]
 Web:http://www.naqua.se/
 Home Phone: +46 (0)18  30 09 19
 Cellular Phone: +46 (0)736 51 74 58
 Address:Nya Valsätrav. 26 B
 SE-756 46
 Uppsala, Sweden
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?Q?Nils_H=F6glund?=
   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).

-- 
Charlie Mengler  Maintenance Warehouse  
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 The Micro$oft Haiku Creed   San Diego, CA 92131
Chaos reigns within. Reflect, repent, and reboot. Order shall return.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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: database 9iR2 and client-server with Forms 6i / RE: (Fwd) Re:

2002-06-25 Thread Eric D. Pierce


interesting.

do you have any explanation of why oracle says that database 91 R2 (9.2.x) *doesn't* 
support 
client-server?

am I missing something?

(i haven't read the database 9iR2 3-tier architecture docs extensively, assuming that 
it would be 
a waste of time for the environment i work in.)

have you run afoul of oracle tech support with that configuration?

what were the problems with your package specifications?

regards,
ep


On 24 Jun 2002 at 12:18, Shaw John-P55297 wrote:

 you only need 9ias if you are running webforms and then you only need 9ias
 if you are running in servlet mode.  I found that Client server works fine.
 THere were problems with our package specifications, but once I corrected
 them it seemed to work.
 
 -Original Message-
 Sent: Monday, June 24, 2002 11:34 AM
 To: Multiple recipients of list ORACLE-L
 
 
 My understanding is that the developer mode is still client-server, but to
 do the deployment 
 (more or less runtime?), you have to also have 9iAS set up and running.
 
 Can you execute a form in client-server mode in the same manner as a user
 would (in other 
 words, not in developer mode)?
 
 Thanks,
 Eric
 
 On 24 Jun 2002 at 6:08, Shaw John-P55297 wrote:
 
 Date sent:Mon, 24 Jun 2002 06:08:28 -0800
 To:   Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 
  9iR2 enterprise from the otn download Forms 6i 6.0.8.10.3 on W2K Dell 
  
  -Original Message-
  Sent: Friday, June 21, 2002 12:07 PM
  To: Multiple recipients of list ORACLE-L
  
  
  in pure client-server mode?
  
  if so:
  
  quick, someone tell oracle tech support !!! :)
  
  what versions of the database? personal, standard, enterprise,
 etc???
  
  
  On 21 Jun 2002 at 5:23, Shaw John-P55297 wrote:
  
  Date sent:  Fri, 21 Jun 2002 05:23:20 -0800
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Send reply to:  [EMAIL PROTECTED]
  
   I have 9iR2 and forms 6i on my pc and its running ok so far. 
   
   -Original Message-
   Sent: Friday, June 21, 2002 5:08 AM
   To: Multiple recipients of list ORACLE-L
   
   
   
   --- Forwarded message follows ---
   ...


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

Re: RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Jan Pruner


I've used Atari 800XL (still have it).

JP

On Tuesday 25 June 2002 17:13, you wrote:
 Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K
 ram !!


 -Original Message-
 Sent: 25 June 2002 15:58
 To: Multiple recipients of list ORACLE-L


 Tom,

 As I recall DB2 on a PC came about way back in the dark days of the
 8080 processor and DOS (no version) somewhere around 1980 I believe.  I
 seem to vaguely remember running it on a very old (now a days) predecessor
 of the laptop.  If memory is serving I believe it was called an Osborne? 
 RDB was offered on the IBM mainframe and there was a VAX version that I
 remember playing
 with as well.

 Yeah, it's good to be old and reflect on the twists  turns we went
 through
 to make things work.  Anyone remember programming with less than 1MB of
 ram? I
 remember trying to make things work on 16K.

 Dick Goulet
 Human memory is fragile, thank GOD!

 Reply Separator
 Author: Mercadante; Thomas F [EMAIL PROTECTED]
 Date:   6/25/2002 6:08 AM

 Oh you bunch of young whipper-snappers!

 A long time ago in a place far-away, we started with simple File Systems.
 Then came ISAM file systems.
 These begate DBMS systems.  Note there was no 'R' in original DBMS systems.
 Some of these were simply an extention to ISAM files that allowed (and
 demanded) a more formalized collection of files.  In these files, there
 were tables and indexes and primary keys.  I remember these as
 Hierarchical Database Systems.  Still no such thing as foreign keys.

 Finally, I believe, DEC came out with the RBMS system which was (I know I
 will be corrected on this) one of the first Relational Database Managment
 Systems to be made available for large systems.  (I have no knowledge of
 IBM products - anybody?  When did DB2 make itself known?).

 On PC's there was also something called RDB I think.

 See, its good to be old!

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Tuesday, June 25, 2002 8:24 AM
 To: Multiple recipients of list ORACLE-L


 i give up the R, is that the difference?

 joe

 Santosh Varma wrote:
  could any body point me the difference(s) between DBMS and RDBMS ??
  because in DBMS also as in RDBMS, we can related two or more
  tables..if a column exists in another table for relation ??
 
  Thanks and regards,
 
  Santosh

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
--
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: Fw: Installing Oracle 9i Release 2 RAC in a single node?

2002-06-25 Thread chaos


And someting addon:
the result of lsnodes:
lsnodes exists in /tmp/orainstallxxx dir, but does not have execution bit.I 
chmod +x it. And it said no libcmdll.so file, i copy it from $ORACLE_HOME/lib 
direcotry, and it works.
The result is:

CMCLI WARNING:CMInitContext: Init ctx (0x804ad00)
eachnettest
CMCLI WARNING:CommonContextCleanup:ctx(0x804ad00)
CMCLI WARNING:COmmonCOntextCleanup:closing comm port.

And the cm.log file:
oracm, version[ 9.2.0.1.0.31 ] started {Tue Jun 25 22:25:20 2002 }
InitializeCM: WatchdogTimerMargin(-1), WatchdogDaemonMargin(5000) {Tue Jun 25 22:25:20 
2002 }
WARNING:  InitializeCM: WatchdogTimerMargin cannot be obtained from kernel, tid = 
main:1024 file = cmstartup.c, line = 258 {Tue Jun 25 22:25:20 2002 }
OemNodeConfig(): Network Address of node0: 127.0.0.1 (port 9998)
 {Tue Jun 25 22:25:20 2002 }
WARNING:  OemNodeConfig(): Using suspicious address 127.0.0.1, tid = main:1024 file = 
oem.c, line = 457 {Tue Jun 25 22:25:20 2002 }
InitializeCM: WatchdogTimerMargin = 6
  WatchdogDaemonMargin = 5000
  WatchdogSafetyMargin = 5000
 {Tue Jun 25 22:25:20 2002 }
ClusterListener (pid=1352, tid=3076): Registered with watchdog daemon. {Tue Jun 25 
22:25:20 2002 }
CreateLocalEndpoint(): Network Address: 127.0.0.1
 {Tue Jun 25 22:25:20 2002 }
WARNING:  CreateLocalEndPoint(): Using suspicious address 127.0.0.1
, tid = main:1024 file = cmipc.c, line = 142 {Tue Jun 25 22:25:20 2002 }
NMEVENT_SUSPEND [00][00][00][00][00][00][00][01] {Tue Jun 25 22:25:25 2002 }
HandleUpdate(): SYNC(0) from node(0) completed {Tue Jun 25 22:25:27 2002 }
HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER {Tue Jun 25 22:25:27 2002 }
NMEVENT_RECONFIG [00][00][00][00][00][00][00][01] {Tue Jun 25 22:25:27 2002 }
Successful reconfiguration,  1 active node(s) node 0 is the master, my node num is 0 
(reconfig 1) {Tue Jun 25 22:25:27 2002 }
PrepareForConnectsX (pid=1360, tid=9226): Registered with watchdog daemon. {Tue Jun 25 
22:25:27 2002 }

And the last part of the wdd.log file:
wddProcRegisterPacket: info: registered client
name = /tmp/.watchdog/cl_sock_1506_18441,
pid = 1506,
tid = 18441,
margin = 5000,
level = 1,
option = 0,
description = ClientProcListen.
Time: Tue Jun 25 22:45:07 CST 2002 (587489)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (587489)
wddSendRegisterReply: info: sent register ack to client.
Time: Tue Jun 25 22:45:07 CST 2002 (588091)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (588091)
wddDelClient: info: deleted client (name=cl_sock_1506_18441)
Time: Tue Jun 25 22:45:07 CST 2002 (588102)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (588102)
wddProcUnregisterPacket: info: unregistered client (name=cl_sock_1506_18441).
Time: Tue Jun 25 22:45:07 CST 2002 (588156)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (588156)
wddSendUnregisterReply: info: sent unregister ack to client.
Time: Tue Jun 25 22:45:07 CST 2002 (593244)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (593244)
wddAddClient: info: added client (name=cl_sock_1507_19466)
Time: Tue Jun 25 22:45:07 CST 2002 (593262)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (593262)
wddProcRegisterPacket: info: registered client
name = /tmp/.watchdog/cl_sock_1507_19466,
pid = 1507,
tid = 19466,
margin = 5000,
level = 1,
option = 0,
description = ClientProcListen.
Time: Tue Jun 25 22:45:07 CST 2002 (593284)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (593284)
wddSendRegisterReply: info: sent register ack to client.
Time: Tue Jun 25 22:45:07 CST 2002 (594154)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (594154)
wddDelClient: info: deleted client (name=cl_sock_1507_19466)
Time: Tue Jun 25 22:45:07 CST 2002 (594167)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (594167)
wddProcUnregisterPacket: info: unregistered client (name=cl_sock_1507_19466).
Time: Tue Jun 25 22:45:07 CST 2002 (594195)
UTC:  Tue Jun 25 14:45:07 GMT 2002 (594195)
wddSendUnregisterReply: info: sent unregister ack to client.




Good luck!

chaos
[EMAIL PROTECTED]

zhu chao
DBA of Eachnet.com
86-021-32174588-667


ÔÚ 2002-06-25 07:13:00 You wrote:
hi, dbas:
   I ever tested 9i 9.0.1 in linux single node according to metalink note:
  166830.1
   Since 9i release 2 is out, it seems that we should conver to that version.
   I Hope to setup 9i rac(release 2) on linux single node as 9i release 1, but 
cannot enable the RAC option as i did inrelease 1.
   I had configured the cmcfg.ora like:
 [oracle@eachnettest admin]$ cat cmcfg.ora
HeartBeat=15000
ClusterName=Oracle Cluster Manager, version 9i
PollInterval=1000
MissCount=20
PrivateNodeNames=eachnettest
PublicNodeNames=eachnettest
ServicePort=9998
WatchdogSafetyMargin=5000
WatchdogTimerMargin=6
CmDiskFile=/home/oracle/oradata/RAC_Node_Monitor_file

and started softdog deamon and oracm .
But when i begin to install the software, rac option just refuse to come out.

[oracle@eachnettest admin]$ ps -ef|grep ora
root  1001  1000  0 20:42 pts/000:00:00 login -- oracle

Re: Remote execution of pl/sql

2002-06-25 Thread Jeff Herrick



Create a dblink to instance B from A and then within your
proc on A do


proc_on_b@B_INSTANCE(parameter1parameter_n);

The schema that you use for the link to B must have execute
access to the procedure on B

HTH

Jeff Herrick
Jeff HErrick  Associates

On Tue, 25 Jun 2002, John Weatherman wrote:

 I am in the process of writing a pl/sql block to run on instance A.  At one
 point, I need to run a procedure that resides in instance B against instance
 B's dataset.  Is there an easy way to do this?

 The basic problem is:

   ### Set up Instance Source for replication ###
   ...
   ...
   dbms_offline_og.begin_instantiation(gname = 'gname', new_site =
 'new_site');

   ### Execute begin load against target ###
   dbms_offline_og.begin_load(gname = 'gname', new_site = 'new_site');

   ### Return to Instance A to return code if everything is ready ###

 Is it possible to issue a connect within a PL/Sql block?

 TIA,

 John P Weatherman
 Database Administrator
 Replacements Ltd.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: John Weatherman
   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: Jeff Herrick
  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: the ora certified masters cert, yet again

2002-06-25 Thread Jack Silvey


Rachel,

So, you substitute books and presentations in place of
the OCP? This sounds like we are in agreement in
principle...

;)

jack



--- Rachel Carmichael [EMAIL PROTECTED] wrote:
 okay, I realize this won't work for everyone on this
 list but...
 
 I hand them my resume. the third page of which is
 FILLED with lists of
 presentations I have given, awards I have gotten for
 presentations I
 have given and books I have written
 
 if they STILL want me to have OCP on my resume after
 that, I don't want
 to work there anyway
 
 --- Jack Silvey [EMAIL PROTECTED] wrote:
  The question is, are you going to allow your
  clearminded moral stance and total disdain for a
  thinly veiled DBA tax to interfere with your
 pursuit
  of filth lucre? *I* ain't!
  
  ;)
  
  It is just another hoop to jump through so that a
  hring manager can say that is an impressive hoop
 you
  jumped through and you can respond yes, and I
 can
  jump through some hoops for you too and allow
 them to
  say here is an outrageous sum of money to work on
 our
  computers. 
  
  I love this job.
  
  jack silvey
  ocp 7.3, 8.0, 8i, 9i
  
  
  --- Don Granaman [EMAIL PROTECTED] wrote:
   They aren't - unless it exceeds a non-trivial
   percentage (6%? 7%? more?  I
   can't remember now...) of their income and is
   required (?).
   
   This new requirement for OCP is just another in
 a
   long line of
   propaganda/baloney from Oracle in its
 never-ending
   attempts to suck up every
   buck it possibly can.  [Oracle likes $.  HR
   likes mindless checklist
   items.  It is a match made in heaven.]  I
 thought
   that the need practically
   any two ILT classes, no matter how irrelevant
 9i
   OCM was going to be the
   limit of extending the the greedy grab for OCP
 bucks
   - for 9i at least.
   This isn't about certification anymore (as if it
   ever was), its about
   revenue.
   
   Since this new requirement (for the moment at
   least) doesn't apply to
   upgrade from an 8i certification, does anyone
 know
   if there is (or soon will
   be) a new constraint/surprise/ambush limiting
 that
   to 8i OCP obtained prior
   to, oh say, June 15, 2002?  September 2002?
   
   Don Granaman
   [OraSaurus - with more disdain than ever for the
   evil vampire Larry's OCP
   DBA tax]
   
   - Original Message -
   To: Multiple recipients of list ORACLE-L
   [EMAIL PROTECTED]
   Sent: Friday, June 21, 2002 12:23 AM
   
   
I thought employees were not allowed to write
   things off as business
expenses...
   
Confusedly yours,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
   
-Original Message-
Sent: Thursday, June 20, 2002 10:13 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: the ora certified masters cert,
 yet
   again
   
Are you trying to promote it?
   
-Original Message-
Sent: Thursday, June 20, 2002 6:50 PM
To: Multiple recipients of list ORACLE-L
   
   
I am seriously considering pursuing one, since
 it
   can
be sold to hiring managers as a sign of
   professional
competence.
   
Look at it from a cost/benefit ratio
 standpoint.
   Will
someone with this cerifification make $2000
 more
   over
her professional life than she would without?
   
So it takes a round trip ticket and three days
 of
vacation. Get the company to pay for it or
 write
   it
off as a business expense.
   
Good investment, easy money, instant
 credibility
   to
many hiring managers.
   
jack silvey
   
   
   
   
   
 On 19 Jun 2002 at 4:38, Ron Rogers wrote:

 Date sent:  Wed, 19 Jun 2002 04:38:18
 -0800
 To: Multiple recipients of list
 ORACLE-L [EMAIL PROTECTED]

  It seems that our list has made mention in
   this
 report from
  Searchdatabase.com. And Oracle is trying
 to
 justify the $2000 expence.
  If I read this correct the $2000 is for 9i
   OCP.
  ===
  LEAD STORY
 
  ORACLE FUELS CERTIFICATION CONTROVERSY |
 SearchDatabase
  Oracle has a new requirement for its
 potential
 certified
  professionals, and the price tag is about
   $2,000.
 Many DBAs aren't
  happy about the new policy but Oracle says
 the
 class makes their
  certification more valuable than ever.
 Read
   the
 details of the new
  mandate, and what DBAs and industry
 experts
   have
 to say about it.
 
  For the full details, click:
 

   
  
 

http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht
ml

 ...


 --
 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 
 
=== message truncated ===


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup

Re: Re:RE: Difference Between DBMS/RDBMS


DOS 1.0 (based on CP/M) came in '81 (or '82?) along with 8086 and the Basic
from M$ :).
8080 - CP/M?

I remeber I loaded punched tape in refrigerator-sized heaters and entered
loader's binary code in the middle 80's. :)
That was 16 bytes. :)

It's good to be young! but old enough to remember :-p

--
Alexandre
OCP DBA/Devel

 Tom,

 As I recall DB2 on a PC came about way back in the dark days of the
8080
 processor and DOS (no version) somewhere around 1980 I believe.  I seem to
 vaguely remember running it on a very old (now a days) predecessor of the
 laptop.  If memory is serving I believe it was called an Osborne?  RDB was
 offered on the IBM mainframe and there was a VAX version that I remember
playing
 with as well.

 Yeah, it's good to be old and reflect on the twists  turns we went
through
 to make things work.  Anyone remember programming with less than 1MB of
ram?  I
 remember trying to make things work on 16K.

 Dick Goulet
 Human memory is fragile, thank GOD!

 Reply Separator
 Author: Mercadante; Thomas F [EMAIL PROTECTED]
 Date:   6/25/2002 6:08 AM

 Oh you bunch of young whipper-snappers!

 A long time ago in a place far-away, we started with simple File Systems.
 Then came ISAM file systems.
 These begate DBMS systems.  Note there was no 'R' in original DBMS
systems.
 Some of these were simply an extention to ISAM files that allowed (and
 demanded) a more formalized collection of files.  In these files, there
were
 tables and indexes and primary keys.  I remember these as Hierarchical
 Database Systems.  Still no such thing as foreign keys.

 Finally, I believe, DEC came out with the RBMS system which was (I know I
 will be corrected on this) one of the first Relational Database Managment
 Systems to be made available for large systems.  (I have no knowledge of
IBM
 products - anybody?  When did DB2 make itself known?).

 On PC's there was also something called RDB I think.

 See, its good to be old!

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Tuesday, June 25, 2002 8:24 AM
 To: Multiple recipients of list ORACLE-L


 i give up the R, is that the difference?

 joe


 Santosh Varma wrote:

  could any body point me the difference(s) between DBMS and RDBMS ??
  because in DBMS also as in RDBMS, we can related two or more
  tables..if a column exists in another table for relation ??
 
  Thanks and regards,
 
  Santosh
 


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Joe Testa
   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: Mercadante, Thomas F
   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:
   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: Alexandre Gorbatchev
  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

Re: the ora certified masters cert, yet again

2002-06-25 Thread KENNETH JANUSZ


Putting on my cost accounting hat I'd like to say this.  At $2,000 a pop and
probably with a small group of people attending these classes, Oracle would
be lucky to break even.  The costs of developing, hardware and staff to
proctor these exams are very high.  A lot of people would have to take this
test for Oracle to break even.  A thousand test takers in a year would only
generate $2,000,000 in sales which wouldn't even show up on their financial
statements.

My $0.02 as a former cost accountant,

Ken Janusz, CPIM

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 2:08 AM


 They aren't - unless it exceeds a non-trivial percentage (6%? 7%? more?  I
 can't remember now...) of their income and is required (?).

 This new requirement for OCP is just another in a long line of
 propaganda/baloney from Oracle in its never-ending attempts to suck up
every
 buck it possibly can.  [Oracle likes $.  HR likes mindless checklist
 items.  It is a match made in heaven.]  I thought that the need
practically
 any two ILT classes, no matter how irrelevant 9i OCM was going to be the
 limit of extending the the greedy grab for OCP bucks - for 9i at least.
 This isn't about certification anymore (as if it ever was), its about
 revenue.

 Since this new requirement (for the moment at least) doesn't apply to
 upgrade from an 8i certification, does anyone know if there is (or soon
will
 be) a new constraint/surprise/ambush limiting that to 8i OCP obtained
prior
 to, oh say, June 15, 2002?  September 2002?

 Don Granaman
 [OraSaurus - with more disdain than ever for the evil vampire Larry's OCP
 DBA tax]

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, June 21, 2002 12:23 AM


  I thought employees were not allowed to write things off as business
  expenses...
 
  Confusedly yours,
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)
 
  -Original Message-
  Sent: Thursday, June 20, 2002 10:13 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: the ora certified masters cert, yet again
 
  Are you trying to promote it?
 
  -Original Message-
  Sent: Thursday, June 20, 2002 6:50 PM
  To: Multiple recipients of list ORACLE-L
 
 
  I am seriously considering pursuing one, since it can
  be sold to hiring managers as a sign of professional
  competence.
 
  Look at it from a cost/benefit ratio standpoint. Will
  someone with this cerifification make $2000 more over
  her professional life than she would without?
 
  So it takes a round trip ticket and three days of
  vacation. Get the company to pay for it or write it
  off as a business expense.
 
  Good investment, easy money, instant credibility to
  many hiring managers.
 
  jack silvey
 
 
 
 
 
   On 19 Jun 2002 at 4:38, Ron Rogers wrote:
  
   Date sent:  Wed, 19 Jun 2002 04:38:18 -0800
   To: Multiple recipients of list
   ORACLE-L [EMAIL PROTECTED]
  
It seems that our list has made mention in this
   report from
Searchdatabase.com. And Oracle is trying to
   justify the $2000 expence.
If I read this correct the $2000 is for 9i OCP.
===
LEAD STORY
   
ORACLE FUELS CERTIFICATION CONTROVERSY |
   SearchDatabase
Oracle has a new requirement for its potential
   certified
professionals, and the price tag is about $2,000.
   Many DBAs aren't
happy about the new policy but Oracle says the
   class makes their
certification more valuable than ever. Read the
   details of the new
mandate, and what DBAs and industry experts have
   to say about it.
   
For the full details, click:
   
  
 

http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht
  ml
  
   ...
  
  
   --
   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).
 
 
 
 
  __
  Do You Yahoo!?
  Yahoo! - Official partner of 2002 FIFA World Cup
  http://fifaworldcup.yahoo.com
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Jack Silvey
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists

RE: RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Hately Mike


Heh, I started programming in PL/1 with DL/1 databases.
All hierarchical and you had to navigate round the tree using calls like
GN (get next) and GU (get unique). Oh the memories!

Regards,
Mike Hately

__Reply Separator
 Author: Mercadante; Thomas F [EMAIL PROTECTED]
 Date:   6/25/2002 6:08 AM
 
 Oh you bunch of young whipper-snappers!
 
 A long time ago in a place far-away, we started with simple File
 Systems.  
 Then came ISAM file systems.
 These begate DBMS systems.  Note there was no 'R' in original DBMS
 systems.
 Some of these were simply an extention to ISAM files that allowed
 (and
 demanded) a more formalized collection of files.  In these files,
 there were
 tables and indexes and primary keys.  I remember these as
 Hierarchical
 Database Systems.  Still no such thing as foreign keys.
 
 Finally, I believe, DEC came out with the RBMS system which was (I
 know I
 will be corrected on this) one of the first Relational Database
 Managment
 Systems to be made available for large systems.  (I have no knowledge
 of IBM
 products - anybody?  When did DB2 make itself known?).
 
 On PC's there was also something called RDB I think.
 
 See, its good to be old!
 
 Tom Mercadante
 Oracle Certified Professional
 


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Sherman, Paul R.


Hello,

I would have to look at my (very dusty) notes to check on the system
attributes and other particulars, but I recall using a system called RAX
(relational something something), running on a IBM mainframe (OS/MVS ?), in
1964, at the Univ. of R.I. The execute command was  /end run. I can not
remember anything else about RAX at this time.

Thank you,

Paul Sherman
DBAElcom, Inc.
voice -  781-501-4143 (direct #)
fax-  781-278-8341 (secure)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, June 25, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L


Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K
ram !!


-Original Message-
Sent: 25 June 2002 15:58
To: Multiple recipients of list ORACLE-L


Tom,

As I recall DB2 on a PC came about way back in the dark days of the 8080
processor and DOS (no version) somewhere around 1980 I believe.  I seem to
vaguely remember running it on a very old (now a days) predecessor of the
laptop.  If memory is serving I believe it was called an Osborne?  RDB was
offered on the IBM mainframe and there was a VAX version that I remember
playing
with as well.

Yeah, it's good to be old and reflect on the twists  turns we went
through
to make things work.  Anyone remember programming with less than 1MB of ram?
I
remember trying to make things work on 16K.

Dick Goulet
Human memory is fragile, thank GOD!

Reply Separator
Author: Mercadante; Thomas F [EMAIL PROTECTED]
Date:   6/25/2002 6:08 AM

Oh you bunch of young whipper-snappers!

A long time ago in a place far-away, we started with simple File Systems.  
Then came ISAM file systems.
These begate DBMS systems.  Note there was no 'R' in original DBMS systems.
Some of these were simply an extention to ISAM files that allowed (and
demanded) a more formalized collection of files.  In these files, there were
tables and indexes and primary keys.  I remember these as Hierarchical
Database Systems.  Still no such thing as foreign keys.

Finally, I believe, DEC came out with the RBMS system which was (I know I
will be corrected on this) one of the first Relational Database Managment
Systems to be made available for large systems.  (I have no knowledge of IBM
products - anybody?  When did DB2 make itself known?).

On PC's there was also something called RDB I think.

See, its good to be old!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? 
 because in DBMS also as in RDBMS, we can related two or more 
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



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




The information contained in this communication is
confidential, is intended only for the use of the

Re: Urgent - Upgrade from 8.1.6 to 8.1.6.3

2002-06-25 Thread Hemant K Chitale



Check if the Database is in ARCHIVELOG mode and the LOG_ARCHIVE_DEST is full ?

At 05:48 PM 22-06-02 -0800, you wrote:

Hi,

I have upgraded two databases from 8.1.6 to 8.1.6.3. After upgrade I ran
catalogand catproc.sql for both of them. For first database ir ran fine. But
for the second one it never started. So I cacelled that one. I started again
and now it is been 20-25 minutes. But, stll there is no activity. Am I
hitting some bug or something??

Regards

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



Hemant K Chitale

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  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: Difference Between DBMS/RDBMS


My Z-80 based PC had 64K (useful only 48). That was the standard
architecture for Z80 4.77MHz 8-)

--
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 5:13 PM


 Erm, programmed at college on something called a Sinclair ZX80 Spectrum 1K
 ram !!


 -Original Message-
 Sent: 25 June 2002 15:58
 To: Multiple recipients of list ORACLE-L


 Tom,

 As I recall DB2 on a PC came about way back in the dark days of the
8080
 processor and DOS (no version) somewhere around 1980 I believe.  I seem to
 vaguely remember running it on a very old (now a days) predecessor of the
 laptop.  If memory is serving I believe it was called an Osborne?  RDB was
 offered on the IBM mainframe and there was a VAX version that I remember
 playing
 with as well.

 Yeah, it's good to be old and reflect on the twists  turns we went
 through
 to make things work.  Anyone remember programming with less than 1MB of
ram?
 I
 remember trying to make things work on 16K.

 Dick Goulet
 Human memory is fragile, thank GOD!

 Reply Separator
 Author: Mercadante; Thomas F [EMAIL PROTECTED]
 Date:   6/25/2002 6:08 AM

 Oh you bunch of young whipper-snappers!

 A long time ago in a place far-away, we started with simple File Systems.
 Then came ISAM file systems.
 These begate DBMS systems.  Note there was no 'R' in original DBMS
systems.
 Some of these were simply an extention to ISAM files that allowed (and
 demanded) a more formalized collection of files.  In these files, there
were
 tables and indexes and primary keys.  I remember these as Hierarchical
 Database Systems.  Still no such thing as foreign keys.

 Finally, I believe, DEC came out with the RBMS system which was (I know I
 will be corrected on this) one of the first Relational Database Managment
 Systems to be made available for large systems.  (I have no knowledge of
IBM
 products - anybody?  When did DB2 make itself known?).

 On PC's there was also something called RDB I think.

 See, its good to be old!

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Tuesday, June 25, 2002 8:24 AM
 To: Multiple recipients of list ORACLE-L


 i give up the R, is that the difference?

 joe


 Santosh Varma wrote:

  could any body point me the difference(s) between DBMS and RDBMS ??
  because in DBMS also as in RDBMS, we can related two or more
  tables..if a column exists in another table for relation ??
 
  Thanks and regards,
 
  Santosh
 


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


 

 The information contained in this communication is
 confidential, is intended only for the use of the recipient
 named above, and may be legally privileged.
 If the reader of this message is not the intended
 recipient, you are hereby notified that any dissemination,
 distribution, or copying of this communication is strictly
 prohibited.
 If you have received this

RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Farnsworth, Dave


In 1982 ANSI charged its X3H2 committee with defining a standard relational database.  
IBM became committed to SQL as the standard database language.  The resultind ANSI 
standard is largly based on DB2 SQL.

Dave

-Original Message-
Sent: Tuesday, June 25, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


Oh you bunch of young whipper-snappers!

A long time ago in a place far-away, we started with simple File Systems.  
Then came ISAM file systems.
These begate DBMS systems.  Note there was no 'R' in original DBMS systems.
Some of these were simply an extention to ISAM files that allowed (and
demanded) a more formalized collection of files.  In these files, there were
tables and indexes and primary keys.  I remember these as Hierarchical
Database Systems.  Still no such thing as foreign keys.

Finally, I believe, DEC came out with the RBMS system which was (I know I
will be corrected on this) one of the first Relational Database Managment
Systems to be made available for large systems.  (I have no knowledge of IBM
products - anybody?  When did DB2 make itself known?).

On PC's there was also something called RDB I think.

See, its good to be old!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? 
 because in DBMS also as in RDBMS, we can related two or more 
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: Mercadante, Thomas F
  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: Farnsworth, Dave
  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: NEED YOUR OPINION

2002-06-25 Thread Hamid Alavi


LYNDA,

If you look at my table staructure service_code in varchar2(30)and the data
in this column can be a number or a number start with a charachter(A-Z)like
A1200,B6500,Z9098 etc,in first subquery I want to select all those
service_code wich start with (0-9) then in WHERE Clause I use TO_NUMBER
becaz I know in subqury It returns all the numeric values:
E.G
select count(*)
   from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID
 from MTF_SERVICE_CODE_MSC 
   where 
 substr(MSC_SERVICE_CODE, 1, 1) in  
 ('9','8','7','6','5','4','3','2','1','0')) a  - reurn all service
code start with 0-9
   where
to_number(a.MSC_SERVICE_CODE) between 7 and 30
--- Here a.MSC_SERVICE_CODE convert it to TO_NUMBER  .

Thanks allot

-Original Message-
Sent: Tuesday, June 25, 2002 2:09 AM
To: Multiple recipients of list ORACLE-L


Hi Hamid,
Can you to give me what you want to obtain as result to this requette.
I believe that in your request you have a problem of conversion of a
varchar2 in number.

LYNDA HAOUHACH
Ingénieur Systèmes
SONATRACH LTH 
Émail: [EMAIL PROTECTED]




 -Message d'origine-
 De:   Hamid Alavi [SMTP:[EMAIL PROTECTED]]
 Date: lundi 24 juin 2002 11:23
 À:Multiple recipients of list ORACLE-L
 Objet:NEED YOUR OPINION
 
 List,
 
 I have a table with the following structure:
 
 CREATE TABLE SERVICE_CODE_MSC ( 
   MSC_SERVICE_ID  NUMBER (4)NOT NULL, 
   MSC_SERVICE_CODEVARCHAR2 (30)  NOT NULL, 
   CONSTRAINT MSC_PK
   PRIMARY KEY ( MSC_SERVICE_ID, MSC_SERVICE_CODE ) 
 USING INDEX 
  TABLESPACE USERS
 
 Here is some sample of this table:
 service_id service_code
 -  --
 7 a1000
 7 a2000
 30e1230
 30e1234
 1012098
 20130987
 
 
 When I run the followinh query on this table I get invalid
 number(ORA-01722), then when I drop tha table and reload the data the
 query
 running OK, Here is the query I am running:
 
 select count(*)
   from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID
 from MTF_SERVICE_CODE_MSC 
   where 
 substr(MSC_SERVICE_CODE, 1, 1) in
 ('9','8','7','6','5','4','3','2','1','0')) a
   where
to_number(a.MSC_SERVICE_CODE) between 7 and 30
 Any Idea ? why this hapenning?
 
 Thanks Allot.
 
 
 
 
 
 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987
 
 
 
 
 
 
 === Confidentiality Statement === 
 The information contained in this message and any attachments is 
 intended only for the use of the individual or entity to which it is 
 addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
 and exempt from disclosure under applicable law.  If you have received 
 this message in error, you are prohibited from copying, distributing, or 
 using the information.  Please contact the sender immediately by return 
 e-mail and delete the original message from your system. 
 = End Confidentiality Statement =
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Hamid Alavi
   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: SIM/HAOUHACH
  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).





=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail

RE: the ora certified masters cert, yet again

2002-06-25 Thread Robertson Lee - lerobe


Sorry can you rephrase the question please but give me multiple choice
answers :-)



-Original Message-
Sent: 25 June 2002 16:59
To: Multiple recipients of list ORACLE-L


Yes, I KNOW you know what you are talking about and know how to do your
job... but CAN you take a TEST?!?!

-Original Message-
Sent: Tuesday, June 25, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L


okay, I realize this won't work for everyone on this list but...

I hand them my resume. the third page of which is FILLED with lists of
presentations I have given, awards I have gotten for presentations I
have given and books I have written

if they STILL want me to have OCP on my resume after that, I don't want
to work there anyway

--- Jack Silvey [EMAIL PROTECTED] wrote:
 The question is, are you going to allow your
 clearminded moral stance and total disdain for a
 thinly veiled DBA tax to interfere with your pursuit
 of filth lucre? *I* ain't!
 
 ;)
 
 It is just another hoop to jump through so that a
 hring manager can say that is an impressive hoop you
 jumped through and you can respond yes, and I can
 jump through some hoops for you too and allow them to
 say here is an outrageous sum of money to work on our
 computers. 
 
 I love this job.
 
 jack silvey
 ocp 7.3, 8.0, 8i, 9i
 
 
 --- Don Granaman [EMAIL PROTECTED] wrote:
  They aren't - unless it exceeds a non-trivial
  percentage (6%? 7%? more?  I
  can't remember now...) of their income and is
  required (?).
  
  This new requirement for OCP is just another in a
  long line of
  propaganda/baloney from Oracle in its never-ending
  attempts to suck up every
  buck it possibly can.  [Oracle likes $.  HR
  likes mindless checklist
  items.  It is a match made in heaven.]  I thought
  that the need practically
  any two ILT classes, no matter how irrelevant 9i
  OCM was going to be the
  limit of extending the the greedy grab for OCP bucks
  - for 9i at least.
  This isn't about certification anymore (as if it
  ever was), its about
  revenue.
  
  Since this new requirement (for the moment at
  least) doesn't apply to
  upgrade from an 8i certification, does anyone know
  if there is (or soon will
  be) a new constraint/surprise/ambush limiting that
  to 8i OCP obtained prior
  to, oh say, June 15, 2002?  September 2002?
  
  Don Granaman
  [OraSaurus - with more disdain than ever for the
  evil vampire Larry's OCP
  DBA tax]
  
  - Original Message -
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Sent: Friday, June 21, 2002 12:23 AM
  
  
   I thought employees were not allowed to write
  things off as business
   expenses...
  
   Confusedly yours,
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
  
   -Original Message-
   Sent: Thursday, June 20, 2002 10:13 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: the ora certified masters cert, yet
  again
  
   Are you trying to promote it?
  
   -Original Message-
   Sent: Thursday, June 20, 2002 6:50 PM
   To: Multiple recipients of list ORACLE-L
  
  
   I am seriously considering pursuing one, since it
  can
   be sold to hiring managers as a sign of
  professional
   competence.
  
   Look at it from a cost/benefit ratio standpoint.
  Will
   someone with this cerifification make $2000 more
  over
   her professional life than she would without?
  
   So it takes a round trip ticket and three days of
   vacation. Get the company to pay for it or write
  it
   off as a business expense.
  
   Good investment, easy money, instant credibility
  to
   many hiring managers.
  
   jack silvey
  
  
  
  
  
On 19 Jun 2002 at 4:38, Ron Rogers wrote:
   
Date sent:  Wed, 19 Jun 2002 04:38:18 -0800
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
   
 It seems that our list has made mention in
  this
report from
 Searchdatabase.com. And Oracle is trying to
justify the $2000 expence.
 If I read this correct the $2000 is for 9i
  OCP.
 ===
 LEAD STORY

 ORACLE FUELS CERTIFICATION CONTROVERSY |
SearchDatabase
 Oracle has a new requirement for its potential
certified
 professionals, and the price tag is about
  $2,000.
Many DBAs aren't
 happy about the new policy but Oracle says the
class makes their
 certification more valuable than ever. Read
  the
details of the new
 mandate, and what DBAs and industry experts
  have
to say about it.

 For the full details, click:

   
  
 

http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht
   ml
   
...
   
   
--
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

RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Whittle Jerome Contr NCI

Title: RE: Difference Between DBMS/RDBMS






That's nothing. I use to bang the rocks together to make the sand from which the silicon was extracted that was used to create the first memory chips

Jerry Whittle

ACIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

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 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 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 Testa [EMAIL PROTECTED] wrote:

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 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 solve the problem open a TAR.

Why are we paying so much $? Let them work !!!

Yechiel Adar
Mehish




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: Farnsworth, Dave
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Mercadante, Thomas F


A - but is a system truely Relational if they don't support foreign
keys?
That did not happen within Oracle-Land until release 7 (maybe it was in 6.2
- I forget).

Anybody remember why there was never a release 6.1 - we went from 6.0
directly to 6.2???

Correct answer gets a virtual beer.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L


Oracle was the first commercial Realtional Database Management System.
And it was relational from day one (version two :), and it was built with 
relational theory in mind. IBM was the first to implement RDBMS though. 
It was called System R, or something, later it became known as DB2.

Take a look at this paper:
http://www.mcjones.org/System_R/SQL_Reunion_95/index.html

Very fascinating reading. They tell how Larry was trying to get tle list
of DB2 error codes so that Oracle would be compatible with it.
Also a bit about Larry luring IBM engeneers promising that they
would become millionares with Oracle. He was right.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicolai Tufar
  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: Mercadante, Thomas F
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread Robertson Lee - lerobe


Ooh, someone needs a chill pill. 

I suggest when you are asking such a basic question you refrain from
insulting one of the more respected members of this list.

Regards

Lee


-Original Message-
Sent: 25 June 2002 14:38
To: Multiple recipients of list ORACLE-L



only fool's like you can point such differences...when not able to find
valid differences.

-Original Message-
Sent: Tuesday, June 25, 2002 5:54 PM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ??
 because in DBMS also as in RDBMS, we can related two or more
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



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




The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  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: the ora certified masters cert, yet again

2002-06-25 Thread Grabowy, Chris


So isn't the problem with HR at the company, or specifically with the
recruiters.  They have  a myopic view when reviewing resumes...they match
key words...DBA, # of years, degrees, OCP, etc.  Which I guess explains the
one page requirement.  So your being treated like another number, either
you fit or you don't.

The recruiters don't actually read your resume and try to understand you and
your background, they just play a word matching game. 

I guess this would explain why networking is the best option for finding a
job.  You end up bypassing that recruiter word matching game.

-Original Message-
Sent: Tuesday, June 25, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L


okay, I realize this won't work for everyone on this list but...

I hand them my resume. the third page of which is FILLED with lists of
presentations I have given, awards I have gotten for presentations I
have given and books I have written

if they STILL want me to have OCP on my resume after that, I don't want
to work there anyway

--- Jack Silvey [EMAIL PROTECTED] wrote:
 The question is, are you going to allow your
 clearminded moral stance and total disdain for a
 thinly veiled DBA tax to interfere with your pursuit
 of filth lucre? *I* ain't!
 
 ;)
 
 It is just another hoop to jump through so that a
 hring manager can say that is an impressive hoop you
 jumped through and you can respond yes, and I can
 jump through some hoops for you too and allow them to
 say here is an outrageous sum of money to work on our
 computers. 
 
 I love this job.
 
 jack silvey
 ocp 7.3, 8.0, 8i, 9i
 
 
 --- Don Granaman [EMAIL PROTECTED] wrote:
  They aren't - unless it exceeds a non-trivial
  percentage (6%? 7%? more?  I
  can't remember now...) of their income and is
  required (?).
  
  This new requirement for OCP is just another in a
  long line of
  propaganda/baloney from Oracle in its never-ending
  attempts to suck up every
  buck it possibly can.  [Oracle likes $.  HR
  likes mindless checklist
  items.  It is a match made in heaven.]  I thought
  that the need practically
  any two ILT classes, no matter how irrelevant 9i
  OCM was going to be the
  limit of extending the the greedy grab for OCP bucks
  - for 9i at least.
  This isn't about certification anymore (as if it
  ever was), its about
  revenue.
  
  Since this new requirement (for the moment at
  least) doesn't apply to
  upgrade from an 8i certification, does anyone know
  if there is (or soon will
  be) a new constraint/surprise/ambush limiting that
  to 8i OCP obtained prior
  to, oh say, June 15, 2002?  September 2002?
  
  Don Granaman
  [OraSaurus - with more disdain than ever for the
  evil vampire Larry's OCP
  DBA tax]
  
  - Original Message -
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Sent: Friday, June 21, 2002 12:23 AM
  
  
   I thought employees were not allowed to write
  things off as business
   expenses...
  
   Confusedly yours,
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
  
   -Original Message-
   Sent: Thursday, June 20, 2002 10:13 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: the ora certified masters cert, yet
  again
  
   Are you trying to promote it?
  
   -Original Message-
   Sent: Thursday, June 20, 2002 6:50 PM
   To: Multiple recipients of list ORACLE-L
  
  
   I am seriously considering pursuing one, since it
  can
   be sold to hiring managers as a sign of
  professional
   competence.
  
   Look at it from a cost/benefit ratio standpoint.
  Will
   someone with this cerifification make $2000 more
  over
   her professional life than she would without?
  
   So it takes a round trip ticket and three days of
   vacation. Get the company to pay for it or write
  it
   off as a business expense.
  
   Good investment, easy money, instant credibility
  to
   many hiring managers.
  
   jack silvey
  
  
  
  
  
On 19 Jun 2002 at 4:38, Ron Rogers wrote:
   
Date sent:  Wed, 19 Jun 2002 04:38:18 -0800
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
   
 It seems that our list has made mention in
  this
report from
 Searchdatabase.com. And Oracle is trying to
justify the $2000 expence.
 If I read this correct the $2000 is for 9i
  OCP.
 ===
 LEAD STORY

 ORACLE FUELS CERTIFICATION CONTROVERSY |
SearchDatabase
 Oracle has a new requirement for its potential
certified
 professionals, and the price tag is about
  $2,000.
Many DBAs aren't
 happy about the new policy but Oracle says the
class makes their
 certification more valuable than ever. Read
  the
details of the new
 mandate, and what DBAs and industry experts
  have
to say about it.

 For the full details, click:

   
  
 

http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht
   ml
   
...
   
   
--
Please see the official

RE: Difference Between DBMS/RDBMS


Tom
I don't have the book here at work, so I'm doing this from memory.
IBM created an experimental relational database named System R, which is
usually acknowledged as the first RDBMS. Being a large bureaucratic
organization that was making a fortune on non-relational databases, IBM did
not swiftly move the RDBMS to production status. I recall System R used SQL
as its query language. The historical irony is that a small organization
rushed its SQL-based product, Oracle, into production well ahead of IBM. How
the dates relate to DEC, I'm not sure. Also, I believe that Oracle was only
available on small systems for a long time. I feel your statement that DEC
had the first RDBMS on large systems is probably correct. I think Oracle's
strength in the early days was in proliferation (many small systems), not
large systems.

I believe Oracle had four advantages which caused it to come out as the
RDBMS leader:
   1. VERY, VERY aggressive organization. At one time the industry leader
was Ingres, now mostly a historical footnote. Read the book The Difference
Between God and Larry Ellison. Fortunately Oracle seems to have tempered
its aggressiveness as it grew large, unlike Microsoft. Or maybe Oracle
simply hasn't achieved the monopoly status.
   2. Ported its product to many, many platforms.
   3. Was not a proprietary product. Many hardware companies like DEC, HP,
IBM were run by hardware people that felt the sole purpose of software was
to sell more hardware. I know, I used to work for a hardware company.
Independent companies like Oracle didn't have these handicaps.
   4. Selected SQL as the interface language. As SQL emerged as the standard
RDBMS query language, Oracle was well-positioned. Other excellent companies
that happened to select query languages that were technically superior to
SQL were forced into awkward migrations.
Interested in any other recollections.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, June 25, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


Oh you bunch of young whipper-snappers!

A long time ago in a place far-away, we started with simple File Systems.  
Then came ISAM file systems.
These begate DBMS systems.  Note there was no 'R' in original DBMS systems.
Some of these were simply an extention to ISAM files that allowed (and
demanded) a more formalized collection of files.  In these files, there were
tables and indexes and primary keys.  I remember these as Hierarchical
Database Systems.  Still no such thing as foreign keys.

Finally, I believe, DEC came out with the RBMS system which was (I know I
will be corrected on this) one of the first Relational Database Managment
Systems to be made available for large systems.  (I have no knowledge of IBM
products - anybody?  When did DB2 make itself known?).

On PC's there was also something called RDB I think.

See, its good to be old!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? 
 because in DBMS also as in RDBMS, we can related two or more 
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: Mercadante, Thomas F
  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: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

Re:RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Eric D. Pierce



On 25 Jun 2002 at 7:33, Rachel Carmichael wrote:

 Wang Basic (anyone else remember Wang computers?) in 64K of ram

First computer company to advertise during the Superbowl?

My dad was the first guy to bring them into the Pentagon (document management 
system?), 
somewhere around 1972.

When the incompetent secretaries got mad about being replaced with computers, and 
their 
union got pissy about same, he fired them.

regards,
ep

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

RE: the ora certified masters cert, yet again

2002-06-25 Thread Wong, Bing


Whether Oracle is just making break even on education, their entire profit
margin was one time over 50% and now it is in 23% in profit margin and 36%
in operating margin, according to Yahoo.  They still make a lot of money!

IBM now offer certification tetsing program.  If you pass the online
assessment 75% or better, you will get free electronic voucher that enable
you to take the final exam for DB2 certification at NO CHARGE.  

My $0.02 as looking at Financial report.


-Original Message-
Sent: Tuesday, June 25, 2002 8:29 AM
To: Multiple recipients of list ORACLE-L


Putting on my cost accounting hat I'd like to say this.  At $2,000 a pop and
probably with a small group of people attending these classes, Oracle would
be lucky to break even.  The costs of developing, hardware and staff to
proctor these exams are very high.  A lot of people would have to take this
test for Oracle to break even.  A thousand test takers in a year would only
generate $2,000,000 in sales which wouldn't even show up on their financial
statements.

My $0.02 as a former cost accountant,

Ken Janusz, CPIM

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 2:08 AM


 They aren't - unless it exceeds a non-trivial percentage (6%? 7%? more?  I
 can't remember now...) of their income and is required (?).

 This new requirement for OCP is just another in a long line of
 propaganda/baloney from Oracle in its never-ending attempts to suck up
every
 buck it possibly can.  [Oracle likes $.  HR likes mindless checklist
 items.  It is a match made in heaven.]  I thought that the need
practically
 any two ILT classes, no matter how irrelevant 9i OCM was going to be the
 limit of extending the the greedy grab for OCP bucks - for 9i at least.
 This isn't about certification anymore (as if it ever was), its about
 revenue.

 Since this new requirement (for the moment at least) doesn't apply to
 upgrade from an 8i certification, does anyone know if there is (or soon
will
 be) a new constraint/surprise/ambush limiting that to 8i OCP obtained
prior
 to, oh say, June 15, 2002?  September 2002?

 Don Granaman
 [OraSaurus - with more disdain than ever for the evil vampire Larry's OCP
 DBA tax]

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, June 21, 2002 12:23 AM


  I thought employees were not allowed to write things off as business
  expenses...
 
  Confusedly yours,
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)
 
  -Original Message-
  Sent: Thursday, June 20, 2002 10:13 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: the ora certified masters cert, yet again
 
  Are you trying to promote it?
 
  -Original Message-
  Sent: Thursday, June 20, 2002 6:50 PM
  To: Multiple recipients of list ORACLE-L
 
 
  I am seriously considering pursuing one, since it can
  be sold to hiring managers as a sign of professional
  competence.
 
  Look at it from a cost/benefit ratio standpoint. Will
  someone with this cerifification make $2000 more over
  her professional life than she would without?
 
  So it takes a round trip ticket and three days of
  vacation. Get the company to pay for it or write it
  off as a business expense.
 
  Good investment, easy money, instant credibility to
  many hiring managers.
 
  jack silvey
 
 
 
 
 
   On 19 Jun 2002 at 4:38, Ron Rogers wrote:
  
   Date sent:  Wed, 19 Jun 2002 04:38:18 -0800
   To: Multiple recipients of list
   ORACLE-L [EMAIL PROTECTED]
  
It seems that our list has made mention in this
   report from
Searchdatabase.com. And Oracle is trying to
   justify the $2000 expence.
If I read this correct the $2000 is for 9i OCP.
===
LEAD STORY
   
ORACLE FUELS CERTIFICATION CONTROVERSY |
   SearchDatabase
Oracle has a new requirement for its potential
   certified
professionals, and the price tag is about $2,000.
   Many DBAs aren't
happy about the new policy but Oracle says the
   class makes their
certification more valuable than ever. Read the
   details of the new
mandate, and what DBAs and industry experts have
   to say about it.
   
For the full details, click:
   
  
 

http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht
  ml
  
   ...
  
  
   --
   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

RE: the ora certified masters cert, yet again

2002-06-25 Thread Lyuda Hoska


I know that some companies like mine (about 500 employees) encourage people
to get certified and pay incentives for each exam passed.
A lot of our employees are certified in things you would not think about
(example: 'Certified Excel user', 'Certified Powerpoint User').  I am not
talking about network admins.  One of my friends who is network admin when
talking about himself said 'I am so certified, it would make you sick...'.
While we all know experience and ability to do work, which is what really
matters, managers want to see money on the table, and they want contracts.
Certified employees are one of the ways to impress clients when company bids
for projects, especially government projects.
Just to share my experience: I like my company's enfaces on certifications.
It forces people to study, not to be thrown behind technology (we are using
Oracle 8i). I am currently studying for 9i certification.  Isn't it
beneficial for me personally? Financial incentives are great! ($500 for each
exam passed, subtract taxes from it :-) ).
Just my 2 cents.

 -Original Message-
Sent: Tuesday, June 25, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L

So isn't the problem with HR at the company, or specifically with the
recruiters.  They have  a myopic view when reviewing resumes...they match
key words...DBA, # of years, degrees, OCP, etc.  Which I guess explains the
one page requirement.  So your being treated like another number, either
you fit or you don't.

The recruiters don't actually read your resume and try to understand you and
your background, they just play a word matching game. 

I guess this would explain why networking is the best option for finding a
job.  You end up bypassing that recruiter word matching game.

-Original Message-
Sent: Tuesday, June 25, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L


okay, I realize this won't work for everyone on this list but...

I hand them my resume. the third page of which is FILLED with lists of
presentations I have given, awards I have gotten for presentations I
have given and books I have written

if they STILL want me to have OCP on my resume after that, I don't want
to work there anyway

--- Jack Silvey [EMAIL PROTECTED] wrote:
 The question is, are you going to allow your
 clearminded moral stance and total disdain for a
 thinly veiled DBA tax to interfere with your pursuit
 of filth lucre? *I* ain't!
 
 ;)
 
 It is just another hoop to jump through so that a
 hring manager can say that is an impressive hoop you
 jumped through and you can respond yes, and I can
 jump through some hoops for you too and allow them to
 say here is an outrageous sum of money to work on our
 computers. 
 
 I love this job.
 
 jack silvey
 ocp 7.3, 8.0, 8i, 9i
 
 
 --- Don Granaman [EMAIL PROTECTED] wrote:
  They aren't - unless it exceeds a non-trivial
  percentage (6%? 7%? more?  I
  can't remember now...) of their income and is
  required (?).
  
  This new requirement for OCP is just another in a
  long line of
  propaganda/baloney from Oracle in its never-ending
  attempts to suck up every
  buck it possibly can.  [Oracle likes $.  HR
  likes mindless checklist
  items.  It is a match made in heaven.]  I thought
  that the need practically
  any two ILT classes, no matter how irrelevant 9i
  OCM was going to be the
  limit of extending the the greedy grab for OCP bucks
  - for 9i at least.
  This isn't about certification anymore (as if it
  ever was), its about
  revenue.
  
  Since this new requirement (for the moment at
  least) doesn't apply to
  upgrade from an 8i certification, does anyone know
  if there is (or soon will
  be) a new constraint/surprise/ambush limiting that
  to 8i OCP obtained prior
  to, oh say, June 15, 2002?  September 2002?
  
  Don Granaman
  [OraSaurus - with more disdain than ever for the
  evil vampire Larry's OCP
  DBA tax]
  
  - Original Message -
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Sent: Friday, June 21, 2002 12:23 AM
  
  
   I thought employees were not allowed to write
  things off as business
   expenses...
  
   Confusedly yours,
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
  
   -Original Message-
   Sent: Thursday, June 20, 2002 10:13 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: the ora certified masters cert, yet
  again
  
   Are you trying to promote it?
  
   -Original Message-
   Sent: Thursday, June 20, 2002 6:50 PM
   To: Multiple recipients of list ORACLE-L
  
  
   I am seriously considering pursuing one, since it
  can
   be sold to hiring managers as a sign of
  professional
   competence.
  
   Look at it from a cost/benefit ratio standpoint.
  Will
   someone with this cerifification make $2000 more
  over
   her professional life than she would without?
  
   So it takes a round trip ticket and three days of
   vacation. Get the company to pay for it or write
  it
   off as a business expense.

RE: Backup and restore


Marcello - Sounds as if you have answered most of the issues. I am pretty
much a Unix person, so someone may provide some more NT-specific answers. 
   - For the cold backup, shut down the database (I always prefer SHUTDOWN
IMMEDIATE). Copy all the files, including all data files, control files,
initialization file. Yesterday we had a rousing discussion on the pros/cons
of copying the redo log files. Rather than re-open that discussion, I hope
you saved the emails. You can also research this issue on the net. 
   - When you make structural changes to the database, enter the command
ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
   - When you get tired of manually shutting the database down, you can get
fancy and create a script to do that. Again, there are probably examples to
be found on the Internet.
   - In addition to the exports, I would try to do the cold backup each
week, simply because it is an easy time frame to remember.
These points should get you started. Good luck and I hope you enjoy your
experiences with Oracle
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, June 25, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L


Ok Oracle 8i
1 development DB (a very small one) installed on a W2K Pro (NT)
I can shutdown DB at any time.
I need a cold backup just in case i have to recover the whole DB.
An Export/import script (dump/load to/from  ascii files) would be enough for
me.
Tanks in advance, Marcello
PS(the wizard does not work , other way ...)



-Messaggio originale-
Da: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Inviato: martedì 25 giugno 2002 16.08
A: Multiple recipients of list ORACLE-L
Oggetto: RE: Backup and restore


Marcello - Oracle backup and recovery is an extensive subject because
different organization's requirements vary so widely. For example, a small
personal test database has very simple backup requirements, while a large
eCommerce Web site that absolutely must be up 24x7 has very complex ones.
Backup  recovery is one of the most important requirements for an Oracle
site and it is absolutely critical that you have a competent backup scheme
that matches your site's requirements. One good way to begin is to take the
Oracle Education class for Backup and Recovery, if that is available to you.
 Why don't you give us a hint as to what your requirements are, and some
of us can better advise you how to start. What Oracle version are you using?
How many databases? What type of server (Unix, NT)? Are you easily able to
shut the database down in evenings or weekends for a cold (offline) backup?
Include any other factors that you feel are significant to your backup and
recovery situation.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
 

-Original Message-
Sent: Tuesday, June 25, 2002 3:33 AM
To: Multiple recipients of list ORACLE-L


Hi i am an oracle newbie.
I can't find an exaustive explanation about backup and restore in Oracle.
I mean policy, commands and syntax without using wizards.
I did a fast run cross orafaq, but i can't find it ...
Any help 
thank you, Marcello
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marcello  Savino
  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: DENNIS WILLIAMS
  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: Marcello  Savino
  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

Re:RE: Difference Between DBMS/RDBMS

2002-06-25 Thread dgoulet


There was a 6.1 and/or 6.2?  I went from 6.0.36 straight to 7.2.

Dick Goulet

Reply Separator
Author: Mercadante; Thomas F [EMAIL PROTECTED]
Date:   6/25/2002 8:18 AM

A - but is a system truely Relational if they don't support foreign
keys?
That did not happen within Oracle-Land until release 7 (maybe it was in 6.2
- I forget).

Anybody remember why there was never a release 6.1 - we went from 6.0
directly to 6.2???

Correct answer gets a virtual beer.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L


Oracle was the first commercial Realtional Database Management System.
And it was relational from day one (version two :), and it was built with 
relational theory in mind. IBM was the first to implement RDBMS though. 
It was called System R, or something, later it became known as DB2.

Take a look at this paper:
http://www.mcjones.org/System_R/SQL_Reunion_95/index.html

Very fascinating reading. They tell how Larry was trying to get tle list
of DB2 error codes so that Oracle would be compatible with it.
Also a bit about Larry luring IBM engeneers promising that they
would become millionares with Oracle. He was right.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicolai Tufar
  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: Mercadante, Thomas F
  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: 
  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: the ora certified masters cert, yet again

2002-06-25 Thread April Wells


Yes, I KNOW you know what you are talking about and know how to do your
job... but CAN you take a TEST?!?!

-Original Message-
Sent: Tuesday, June 25, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L


okay, I realize this won't work for everyone on this list but...

I hand them my resume. the third page of which is FILLED with lists of
presentations I have given, awards I have gotten for presentations I
have given and books I have written

if they STILL want me to have OCP on my resume after that, I don't want
to work there anyway

--- Jack Silvey [EMAIL PROTECTED] wrote:
 The question is, are you going to allow your
 clearminded moral stance and total disdain for a
 thinly veiled DBA tax to interfere with your pursuit
 of filth lucre? *I* ain't!
 
 ;)
 
 It is just another hoop to jump through so that a
 hring manager can say that is an impressive hoop you
 jumped through and you can respond yes, and I can
 jump through some hoops for you too and allow them to
 say here is an outrageous sum of money to work on our
 computers. 
 
 I love this job.
 
 jack silvey
 ocp 7.3, 8.0, 8i, 9i
 
 
 --- Don Granaman [EMAIL PROTECTED] wrote:
  They aren't - unless it exceeds a non-trivial
  percentage (6%? 7%? more?  I
  can't remember now...) of their income and is
  required (?).
  
  This new requirement for OCP is just another in a
  long line of
  propaganda/baloney from Oracle in its never-ending
  attempts to suck up every
  buck it possibly can.  [Oracle likes $.  HR
  likes mindless checklist
  items.  It is a match made in heaven.]  I thought
  that the need practically
  any two ILT classes, no matter how irrelevant 9i
  OCM was going to be the
  limit of extending the the greedy grab for OCP bucks
  - for 9i at least.
  This isn't about certification anymore (as if it
  ever was), its about
  revenue.
  
  Since this new requirement (for the moment at
  least) doesn't apply to
  upgrade from an 8i certification, does anyone know
  if there is (or soon will
  be) a new constraint/surprise/ambush limiting that
  to 8i OCP obtained prior
  to, oh say, June 15, 2002?  September 2002?
  
  Don Granaman
  [OraSaurus - with more disdain than ever for the
  evil vampire Larry's OCP
  DBA tax]
  
  - Original Message -
  To: Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED]
  Sent: Friday, June 21, 2002 12:23 AM
  
  
   I thought employees were not allowed to write
  things off as business
   expenses...
  
   Confusedly yours,
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
  
   -Original Message-
   Sent: Thursday, June 20, 2002 10:13 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: the ora certified masters cert, yet
  again
  
   Are you trying to promote it?
  
   -Original Message-
   Sent: Thursday, June 20, 2002 6:50 PM
   To: Multiple recipients of list ORACLE-L
  
  
   I am seriously considering pursuing one, since it
  can
   be sold to hiring managers as a sign of
  professional
   competence.
  
   Look at it from a cost/benefit ratio standpoint.
  Will
   someone with this cerifification make $2000 more
  over
   her professional life than she would without?
  
   So it takes a round trip ticket and three days of
   vacation. Get the company to pay for it or write
  it
   off as a business expense.
  
   Good investment, easy money, instant credibility
  to
   many hiring managers.
  
   jack silvey
  
  
  
  
  
On 19 Jun 2002 at 4:38, Ron Rogers wrote:
   
Date sent:  Wed, 19 Jun 2002 04:38:18 -0800
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
   
 It seems that our list has made mention in
  this
report from
 Searchdatabase.com. And Oracle is trying to
justify the $2000 expence.
 If I read this correct the $2000 is for 9i
  OCP.
 ===
 LEAD STORY

 ORACLE FUELS CERTIFICATION CONTROVERSY |
SearchDatabase
 Oracle has a new requirement for its potential
certified
 professionals, and the price tag is about
  $2,000.
Many DBAs aren't
 happy about the new policy but Oracle says the
class makes their
 certification more valuable than ever. Read
  the
details of the new
 mandate, and what DBAs and industry experts
  have
to say about it.

 For the full details, click:

   
  
 

http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht
   ml
   
...
   
   
--
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

RE: NEED YOUR OPINION

2002-06-25 Thread Jamadagni, Rajendra


where
to_number(replace(msc_service_code,'ABCDEFGHIJKLMNOPQRSTUVWXYZqazwsxedcrfvtg
byhnujmikolp')) between 7 and 30 ...

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Tuesday, June 25, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L


LYNDA,

If you look at my table staructure service_code in varchar2(30)and the data
in this column can be a number or a number start with a charachter(A-Z)like
A1200,B6500,Z9098 etc,in first subquery I want to select all those
service_code wich start with (0-9) then in WHERE Clause I use TO_NUMBER
becaz I know in subqury It returns all the numeric values:
E.G
select count(*)
   from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID
 from MTF_SERVICE_CODE_MSC 
   where 
 substr(MSC_SERVICE_CODE, 1, 1) in  
 ('9','8','7','6','5','4','3','2','1','0')) a  - reurn all service
code start with 0-9
   where
to_number(a.MSC_SERVICE_CODE) between 7 and 30
--- Here a.MSC_SERVICE_CODE convert it to TO_NUMBER  .

Thanks allot



*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

Re: the ora certified masters cert, yet again


Bravo, Rachel! :-)

- Original Message - 
 okay, I realize this won't work for everyone on this list but...

yeeeah... doesn't work for me... not yet ;)

 
 I hand them my resume. the third page of which is FILLED with lists of
 presentations I have given, awards I have gotten for presentations I
 have given and books I have written
 
 if they STILL want me to have OCP on my resume after that, I don't want
 to work there anyway
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alexandre Gorbatchev
  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: Backup and restore

2002-06-25 Thread Yechiel Adar


Why do not bring down the DB and then copy the whole directory
to another place on the disk.
In case of trouble just copy back.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 5:23 PM


Ok Oracle 8i
1 development DB (a very small one) installed on a W2K Pro (NT)
I can shutdown DB at any time.
I need a cold backup just in case i have to recover the whole DB.
An Export/import script (dump/load to/from  ascii files) would be enough for
me.
Tanks in advance, Marcello
PS(the wizard does not work , other way ...)



-Messaggio originale-
Da: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Inviato: martedì 25 giugno 2002 16.08
A: Multiple recipients of list ORACLE-L
Oggetto: RE: Backup and restore


Marcello - Oracle backup and recovery is an extensive subject because
different organization's requirements vary so widely. For example, a small
personal test database has very simple backup requirements, while a large
eCommerce Web site that absolutely must be up 24x7 has very complex ones.
Backup  recovery is one of the most important requirements for an Oracle
site and it is absolutely critical that you have a competent backup scheme
that matches your site's requirements. One good way to begin is to take the
Oracle Education class for Backup and Recovery, if that is available to you.
 Why don't you give us a hint as to what your requirements are, and some
of us can better advise you how to start. What Oracle version are you using?
How many databases? What type of server (Unix, NT)? Are you easily able to
shut the database down in evenings or weekends for a cold (offline) backup?
Include any other factors that you feel are significant to your backup and
recovery situation.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, June 25, 2002 3:33 AM
To: Multiple recipients of list ORACLE-L


Hi i am an oracle newbie.
I can't find an exaustive explanation about backup and restore in Oracle.
I mean policy, commands and syntax without using wizards.
I did a fast run cross orafaq, but i can't find it ...
Any help 
thank you, Marcello
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Marcello  Savino
  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: DENNIS WILLIAMS
  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: Marcello  Savino
  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: Yechiel Adar
  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).

Message ARC0: Failed to archive log

2002-06-25 Thread Baker, Barbara


Sun Solaris 5.8
Oracle Release 8.1.7.2.0 

List:
We have a small but critical database that gets bursts of activity.  If left
to their own devices, the 50meg redo logs sometimes switch a few per hour;
sometimes do not switch for several hours.

We're manually populating a standby database, so we're forcing a switch
(alter system archive log current) with a cron job every 30 minutes.

Every time a manual log switch occurs, we see this message in the alert log:
ARC0: Failed to archive log# 2 seq# 854
However, the switch always completes a few tenths of a second later.

Would this be considered normal activity?  Seems odd to see a message like
this in the alert, but since we see a successful switch so quickly, I'm
thinking maybe it's ok.

Thanks for any advice.

Barb

Mon Jun 24 15:55:01 2002
ARCH: Beginning to archive log# 1 seq# 841
Mon Jun 24 15:55:01 2002
ARC0: Beginning to archive log# 1 seq# 841
ARC0: Failed to archive log# 1 seq# 841
Mon Jun 24 15:55:07 2002
ARCH: Completed archiving log# 1 seq# 841
Mon Jun 24 16:55:01 2002
Thread 1 advanced to log sequence 843
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  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: NEED YOUR OPINION

2002-06-25 Thread Hamid Alavi


Stefan,

If you look at the query in the first part it returns all the numbers then I
use TO_NUMBER, the strange is when I drop the table and recreate it the
query work fine.
Thanks

-Original Message-
Sent: Tuesday, June 25, 2002 2:48 AM
To: Multiple recipients of list ORACLE-L


Hi Hamid

by making sure that the first charakter of msc_service_code is in the range
[0-9], 
you have no guarantee for the rest of the VARCHAR being numeric, too. It
could 
contain anything else, so your to_number might go down the drain ...

Regards,
Stefan


-Ursprüngliche Nachricht-
Von: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 25. Juni 2002 01:23
An: Multiple recipients of list ORACLE-L
Betreff: NEED YOUR OPINION


List,

I have a table with the following structure:

CREATE TABLE SERVICE_CODE_MSC ( 
  MSC_SERVICE_ID  NUMBER (4)NOT NULL, 
  MSC_SERVICE_CODEVARCHAR2 (30)  NOT NULL, 
  CONSTRAINT MSC_PK
  PRIMARY KEY ( MSC_SERVICE_ID, MSC_SERVICE_CODE ) 
USING INDEX 
 TABLESPACE USERS

Here is some sample of this table:
service_id service_code
-  --
7   a1000
7   a2000
30  e1230
30  e1234
10  12098
20  130987


When I run the followinh query on this table I get invalid
number(ORA-01722), then when I drop tha table and reload the data the query
running OK, Here is the query I am running:

select count(*)
from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID
  from MTF_SERVICE_CODE_MSC 
  where 
  substr(MSC_SERVICE_CODE, 1, 1) in
('9','8','7','6','5','4','3','2','1','0')) a
where
 to_number(a.MSC_SERVICE_CODE) between 7 and 30
Any Idea ? why this hapenning?

Thanks Allot.





Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  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: Stefan Jahnke
  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).





=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  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

RE: RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Jesse, Rich


AFAIK, RDB was DEC's Relational offering and was only available on VAXen,
and eventually Alphas.  It was preceeded by DEC's CODASYL DBMS, known
generically as DBMS.  Perhaps IBM had an RDB, too, since the names are
generic enough.

I worked extensively with DEC's DBMS and COBOL in my first programming job
back in '88, but I'll be damned if I remember one bit of DBMS.  I know that
it shared a bunch of features (and probably code) with RDB, and was also
acquired by Oracle in the RDB purchase back in '95.

One of the coolest things with RDB that Oracle should've jumped on is the
idea of SQL Modules for 3GL support, instead of the icky pre-compilers.
Since all of your SQL was in a separate module, it was language independant.
It was also nice from a development standpoint in that all of your SQL was
in one module, instead of interspersed throughout your 3GL code.

Oh well...back to truncating tables...  ;)

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


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, June 25, 2002 9:58 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re:RE: Difference Between DBMS/RDBMS
 
 
 Tom,
 
 As I recall DB2 on a PC came about way back in the dark 
 days of the 8080
 processor and DOS (no version) somewhere around 1980 I 
 believe.  I seem to
 vaguely remember running it on a very old (now a days) 
 predecessor of the
 laptop.  If memory is serving I believe it was called an 
 Osborne?  RDB was
 offered on the IBM mainframe and there was a VAX version that 
 I remember playing
 with as well.
 
 Yeah, it's good to be old and reflect on the twists  
 turns we went through
 to make things work.  Anyone remember programming with less 
 than 1MB of ram?  I
 remember trying to make things work on 16K.
 
 Dick Goulet
 Human memory is fragile, thank GOD!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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: Difference Between DBMS/RDBMS


Dave - And since Oracle had bet its company on the SQL language, it was
well-positioned to ride that horse to victory. Ironic that for so many years
it appears that Oracle reaped so much more benefit from SQL than IBM did.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, June 25, 2002 10:03 AM
To: Multiple recipients of list ORACLE-L


In 1982 ANSI charged its X3H2 committee with defining a standard relational
database.  IBM became committed to SQL as the standard database language.
The resultind ANSI standard is largly based on DB2 SQL.

Dave

-Original Message-
Sent: Tuesday, June 25, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


Oh you bunch of young whipper-snappers!

A long time ago in a place far-away, we started with simple File Systems.  
Then came ISAM file systems.
These begate DBMS systems.  Note there was no 'R' in original DBMS systems.
Some of these were simply an extention to ISAM files that allowed (and
demanded) a more formalized collection of files.  In these files, there were
tables and indexes and primary keys.  I remember these as Hierarchical
Database Systems.  Still no such thing as foreign keys.

Finally, I believe, DEC came out with the RBMS system which was (I know I
will be corrected on this) one of the first Relational Database Managment
Systems to be made available for large systems.  (I have no knowledge of IBM
products - anybody?  When did DB2 make itself known?).

On PC's there was also something called RDB I think.

See, its good to be old!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, June 25, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L


i give up the R, is that the difference?

joe


Santosh Varma wrote:

 could any body point me the difference(s) between DBMS and RDBMS ?? 
 because in DBMS also as in RDBMS, we can related two or more 
 tables..if a column exists in another table for relation ??

 Thanks and regards,

 Santosh



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: Mercadante, Thomas F
  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: Farnsworth, Dave
  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: DENNIS WILLIAMS
  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: Difference Between DBMS/RDBMS

2002-06-25 Thread mkb


Nicolai,

Thank you very much.  Very interesting paper.

mkb

--- Nicolai Tufar [EMAIL PROTECTED] wrote:
 Oracle was the first commercial Realtional Database
 Management System.
 And it was relational from day one (version two :),
 and it was built with 
 relational theory in mind. IBM was the first to
 implement RDBMS though. 
 It was called System R, or something, later it
 became known as DB2.
 
 Take a look at this paper:

http://www.mcjones.org/System_R/SQL_Reunion_95/index.html
 
 Very fascinating reading. They tell how Larry was
 trying to get tle list
 of DB2 error codes so that Oracle would be
 compatible with it.
 Also a bit about Larry luring IBM engeneers
 promising that they
 would become millionares with Oracle. He was right.
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Nicolai Tufar
   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!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: mkb
  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: the ora certified masters cert, yet again