Re: select from dual?

[Michal Zaschke]

Did you mean somethink like this:

select 30,'where name in (''NAME1'',''NAME2'')' || ' ;' from dual;



"Tatireddy, Shrinivas (MED, Keane)" píše:
> 
> Hi lists
> 
> Whats wrong with the following statement:-
> 
>   select 30,'where name in ('NAME1','NAME2')' || ' ;' from dual;
> 
> where as the following is working fine:
> 
>   select 30, 'where id in (10,20)' || ' ;' from dual;
> 
> can anybody throw some light?
> 
> thanx in adv
> srinivas
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
>   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).

-- 
 Ing. Michal Zaschke   
   DB Administrator 
Sokolovska uhelna, a.s.
phone: +420-168-465417
e-mail: [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michal Zaschke
  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 question - please reply fast

[Michal Zaschke]

create table AAA (NAME varchar2(30));
insert into AAA values ('Pelle T');
insert into AAA values ('Kalle S1000');
insert into AAA values ('Info missing');
insert into AAA values ('Pelle Svensson T3');
insert into AAA values ('Bad info');
select decode(name, 'Info missing',NAME,'Bad info',NAME,substr(NAME, 1, instr(NAME, ' 
', -1)-1)) NAME from AAA;

HTH,
   Mike


[EMAIL PROTECTED] píše:
> 
> Hej
> 
> Would like to have som help with this. Please give me an example of sql statement.
> 
> I have field1.
> 
> Pelle T
> Kalle S1000
> Info missing
> Pelle Svensson T3
> Bad info
> 
> and  want this result after the selectstatement.
> 
> Pelle
> Kalle
> Info missing
> Pelle Svensson
> Bad info
> 
> which means that I dont want to have the last word in this field except
> 'Info missing' and 'Bad info'. These two should remain unchanged, but all other 
>should not have the last word .
> 
> Thanksin advance
> 
> Roland S
> 
> --
> 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).

-- 
 Ing. Michal Zaschke   
   DB Administrator 
Sokolovska uhelna, a.s.
phone: +420-168-465417
e-mail: [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michal Zaschke
  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).

is there an archive for this mailing list...

[grace]

hi gurus
is there an archive for this mailing list? if yes , how can i access them

Best regards,

Grace Lim
Suy Sing Comm'l Corp.

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

[nlzanen1]

Hi,


O'Reilly has a pocket size reference book about it, I believe


Jack




"grace" <[EMAIL PROTECTED]>@fatcity.com on 15-11-2001 05:30:17

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

hi,

is there a dba checklist to know a dba does?

Best regards,

Grace Lim
Suy Sing Comm'l Corp.

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




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / 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: select from dual?

[Santosh Varma]

i think the following code should work ->

select 30,'where name in (''NAME1'',''NAME2'')' || ' ;' from dual;

the character fields should be seperated by double quotes instead of single.
santosh


 Hi lists

 Whats wrong with the following statement:-
>
>   select 30,'where name in ('NAME1','NAME2')' || ' ;' from dual;
>
> where as the following is working fine:
>
>   select 30, 'where id in (10,20)' || ' ;' from dual;
>
> can anybody throw some light?
>
> thanx in adv
> srinivas
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
>   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).

--
 Ing. Michal Zaschke
   DB Administrator
Sokolovska uhelna, a.s.
phone: +420-168-465417
e-mail: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michal Zaschke
  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: Sql question - please reply fast

[Robertson Lee - lerobe]

For the final time Roland.

SQL> select * from mytable;

FIELD1

Pelle T
No Info
Pelle Svensson T
Missing Info
Kalle S1000

SQL> get lee.sql
  1  SELECT  field1, DECODE(field1,'No Info','No Info','Missing
Info','Missing Info',ltrim(substr(field1,1,instr(field1,' ')-1)))
  2* FROM mytable

SQL> /

FIELD1   DECODE(FIELD1,'NOINF
 
Pelle T  Pelle
No Info  No Info
Pelle Svensson T Pelle
Missing Info Missing Info
Kalle S1000  Kalle

SQL>

Hope this helps

Lee


-Original Message-
Sent: 15 November 2001 06:56
To: Multiple recipients of list ORACLE-L


Hej

Would like to have som help with this. Please give me an example of sql
statement.

I have field1.

Pelle T
Kalle S1000
Info missing
Pelle Svensson T3
Bad info

and  want this result after the selectstatement.

Pelle
Kalle
Info missing
Pelle Svensson
Bad info

which means that I dont want to have the last word in this field except
'Info missing' and 'Bad info'. These two should remain unchanged, but all
other should not have the last word .

Thanksin advance

Roland S



-- 
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.
-- 
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: DBA CHECKLIST

[Arslan Bahar]

  OCP  exam guide of oracle  may be usefull

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, November 15, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L



Hi,


O'Reilly has a pocket size reference book about it, I believe


Jack




"grace" <[EMAIL PROTECTED]>@fatcity.com on 15-11-2001 05:30:17

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

hi,

is there a dba checklist to know a dba does?

Best regards,

Grace Lim
Suy Sing Comm'l Corp.

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




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / 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: Arslan Bahar
  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).

Move data from Oracle into Access

[Daiminger, Helmut]

Title: Move data from Oracle into Access





Hi!


What would be the easiest way to dump out an Oracle table and move it into Access? (approx. 100,000 rows) No flaming, please... ;)

I assume that there is no tool for Access to read Oracle dmp-files, right?


Is spooling it out into an ASCII file (blanks or comma-seperated) the only way? I just need a single table (no refs or the like).

Any ideas?


This is 8.1.7 on Solaris.


Thanks,
Helmut

RE: is there an archive for this mailing list...

[Sinard Xing]

I have for few weeks

-Original Message-
Sent: Thursday, 15 November 2001 4:25 PM
To: Multiple recipients of list ORACLE-L


hi gurus
is there an archive for this mailing list? if yes , how can i access them

Best regards,

Grace Lim
Suy Sing Comm'l Corp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: grace
  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: Sinard Xing
  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: DBA CHECKLIST

[C.S.Venkata Subramanian]

Hi List,
Check this out,
http://www.geocities.com/tbcox23/dba_checklist15.doc
It is really gd.

Venkat
 
--

On Wed, 14 Nov 2001 23:40:19  
 nlzanen1 wrote:
>
>Hi,
>
>
>O'Reilly has a pocket size reference book about it, I believe
>
>
>Jack
>
>
>
>
>"grace" <[EMAIL PROTECTED]>@fatcity.com on 15-11-2001 05:30:17
>
>Please respond to [EMAIL PROTECTED]
>
>Sent by:  [EMAIL PROTECTED]
>
>
>To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
>
>hi,
>
>is there a dba checklist to know a dba does?
>
>Best regards,
>
>Grace Lim
>Suy Sing Comm'l Corp.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: grace
>  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).
>
>
>
>
>=
>De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
>uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
>vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
>derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
>Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
>volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
>voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
>verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
>worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
>Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
>vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
>en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
>Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
>voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
>algemene voorwaarden worden u op verzoek kosteloos toegezonden.
>=
>The information contained in this communication is confidential and is
>intended solely for the use of the individual or entity to whom it is
>addressed. You should not copy, disclose or distribute this communication
>without the authority of Ernst & Young. Ernst & Young is neither liable for
>the proper and complete transmission of the information contained in this
>communication nor for any delay in its receipt. Ernst & Young does not
>guarantee that the integrity of this communication has been maintained nor
>that the communication is free of viruses, interceptions or interference.
>
>If you are not the intended recipient of this communication please return
>the communication to the sender and delete and destroy all copies.
>
>In carrying out its engagements, Ernst & Young applies general terms and
>conditions, which contain a clause that limits its liability. A copy of
>these terms and conditions is available on request free of charge.
>=
>
>
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: 
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / 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: C.S.Venkata Subramanian
  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: is there an archive for this mailing list...

[C.S.Venkata Subramanian]

Goto the following link and sign in and select Oracle-L list and you have an option 
called Archives.
 http://www.fatcity.com/
HTH
Venkat
--

On Thu, 15 Nov 2001 00:25:19  
 grace wrote:
>hi gurus
>is there an archive for this mailing list? if yes , how can i access them
>
>Best regards,
>
>Grace Lim
>Suy Sing Comm'l Corp.
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: grace
>  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: C.S.Venkata Subramanian
  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: Configuring for Online Redo Logfiles

[Connor McDonald]

An unmirrored disk will run faster (with respect to
writes) than a mirrored one (not twice as fast since
writes on a mirror are typically done in parallel). 
Then again - now you've got an unmirrored redo
log...not a good idea.  To get around this, you'd need
to duplex it through Oracle - which pretty much gets
you back to a "mirrored" redo log.

hth
connor

 --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: >
EXCERPT from "Implementing Raid On Oracle Systems"
> by Gaja Krishna
> Vaidyanatha, Quest Software Inc. :-
> "RAID 1 - Ideal for online and archived redo logs,
> Leaves the write-head
> at the location of the last write.  On most systems,
> you will need 3
> volumes for the online redo logs (for 3 groups) and
> 1 volume for the
> archived redo logs. If your database is in
> NOARCHIVELOG mode, you
> probably can get away with a single RAID 1 volume
> for your redo-logs.
> However, for databases in ARCHIVELOG mode you will
> need to further
> separate you"
> Qs. Puttting an Online Redo log on a RAID1 Volume (
> Volume Containing 1
> Disk Mirrored to Another Disk ) versus putting the
> Same Online redo file
> on a Single Disk (NON-Mirrored) , which would give
> Better performance ,
> Why ? 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: VIVEK_SHARMA
>   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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
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?Connor=20McDonald?=
  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 question - please reply fast

[Iulian . ILIES]

Can you tell us what the last word in the field value mean (except 'Info
missing' and 'Bad info')
I mean is there a rule that those T, S1 does respect?
Something like this:
- first character is a letter and in this set of values ('S', 'T' etc)
- the rest are digits
etc.
Try to find out a pattern and let us know, may be we can help you out.

Iulian

-Original Message-
Sent: Thursday, November 15, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L


**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Network Department.
**

Hej

Would like to have som help with this. Please give me an example of sql
statement.

I have field1.

Pelle T
Kalle S1000
Info missing
Pelle Svensson T3
Bad info

and  want this result after the selectstatement.

Pelle
Kalle
Info missing
Pelle Svensson
Bad info

which means that I dont want to have the last word in this field except
'Info missing' and 'Bad info'. These two should remain unchanged, but all
other should not have the last word .

Thanksin advance

Roland S



-- 
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 and 
may be legally privileged. It is intended solely for the use of the 
individual or entity to whom it is addressed and others authorised to 
receive it. If you are not the intended recipient you are hereby 
notified that any disclosure, copying, distribution or taking action in 
reliance of the contents of this information is strictly prohibited and 
may be unlawful. Mobil Rom is neither liable for the proper, complete 
transmission of the information contained in this communication nor 
any delay in its receipt.
**

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

ORAxxxx & trace files.

[Mark Leith]

Hi list,

Does anybody have a good list of all the ORA errors that will cause a trace
file to be generated? We have a user of our tools that wants to monitor for
any trace files/dumps being generated. I can think of two ways:

1) monitor the alert log as above for specific errors
2) monitor the directories that these are generated in (bdump/cdump etc.)
for any new files generated in the timeframe..

Anybody already doing this - or have any scripts to save me re-inventing the
wheel?

Cheers

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  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: DBA CHECKLIST

[Mark Leith]

Also you can check this pdf document out:

http://www.geocities.com/tbcox23/dba_checklist13.doc

HTH

Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 15 November 2001 07:40
To: Multiple recipients of list ORACLE-L



Hi,


O'Reilly has a pocket size reference book about it, I believe


Jack




"grace" <[EMAIL PROTECTED]>@fatcity.com on 15-11-2001 05:30:17

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

hi,

is there a dba checklist to know a dba does?

Best regards,

Grace Lim
Suy Sing Comm'l Corp.

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




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / 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: Mark Leith
  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: Operating Systems

[Farnsworth, Dave]

>-And maybe (gods help me! ) NT?

Get a rope!

:O)

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


Linux or Solaris Intel.  And maybe (gods help me! ) NT?

Scott Shafer
San Antonio, TX


Regina Harter wrote:
> 
> Hi Guys,
> 
> Our SA/DBA is considering dumping Unixware and moving to a different
> OS.  Sun is out for reasons that are not being shared with me, probably
> because they don't want to buy new hardware, so aside from that, would
> anyone care to weigh in with opinions on what OS is most stable with
> Oracle?  AAnd will run on an intel based box?  Ours is not a high
> transaction system, mostly reads, maybe 100 users a day.
> 
> Thanks for your opinions,
> Regina
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Regina Harter
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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: DBA CHECKLIST

[O'Neill, Sean]

Grace,

Free sources:
=
www.orapub.com  
Technical Papers section 
#115 Oracle DBA Checklist

Thomas B. Cox wrote a paper called "Database Administration Mautrity Model".
This is IMHO rleated to DBA checklists.  I have version 1.1 but only as
hardcopy.  It does not appear to be accessible now from his homepage at
Geocites.  Maybe someone else on the list can help you with this.

Cost sources:
=
"Oracle DBA Checklists", published by O'Reilly ISBN: 0-596-00122-3

"Oracle DBA 101" ISBN: 0-072-121203 has a chapter "What we do daily"

-
Sean O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

>> From: "grace" <[EMAIL PROTECTED]>
>> Date: Thu, 15 Nov 2001 12:34:08 +0800
>> Subject: DBA CHECKLIST
>>
>>hi,
>>
>>is there a dba checklist to know a dba does?
>>
>>Best regards,
>>
>>Grace Lim
>>Suy Sing Comm'l Corp.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  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: is there an archive for this mailing list...

[Mark Leith]

Grace,

Go here: http://www.fatcity.com/ListGuru/login.php and click on the "sign up
here" link to create a new online account..

HTH

Mark

-Original Message-
Sent: 15 November 2001 08:25
To: Multiple recipients of list ORACLE-L


hi gurus
is there an archive for this mailing list? if yes , how can i access them

Best regards,

Grace Lim
Suy Sing Comm'l Corp.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: grace
  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: Mark Leith
  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 Query OutPut

[Pruthvi]

Hi,

I need the Query for the following result.
If any body help it will be very great. Its very urgent.


the output needed is



DeptNoEmpNo

101
2
3
4
5
2011
12
13

The DeptNo should not repeat for all the employees.
Thanks in advance

Regards

Pruthvi


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Connecting 8.0 to 8.1

[Jones, David]

Forgive me if this is a RTFM question - I have not been able to find the
right bit of the FM.

Can someone please tell me how to Net8 connect an 8.0 NT client to an 8.1
Linux server.

Everything was working fine until a second Oracle instance was installed on
the server.  I now get 

ERROR:
ORA-12545: Connect failed because target host or object does not exist


My tnsnames.ora looks like this...

ORANGE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.798.101)(PORT = 1521))
(CONNECT_DATA = (SID = ORANGE))
  )

The server listener.ora looks like this

# LISTENER.ORA Network Configuration File:
/opt/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 1521))
  )
)
(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
  (ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 2481))
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (PROGRAM = extproc)
)
(SID_DESC =
  (GLOBAL_DBNAME = TEST.abc123de)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = TEST)
)
(SID_DESC =
  (GLOBAL_DBNAME = ORANGE.acn032hq)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = ORANGE)
)
  )

I anonymised the data (obviously)

Many thanks to anyone who understands this stuff.

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

Ang: RE: Sql question - please reply fast

[Roland . Skoldblom]

Thanks for all your repliesReally appreciate this..
next time I willtake more time to check the errors myself

Roland

-- 
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: Configuring for Online Redo Logfiles

[VIVEK_SHARMA]

Ed/List

Would NOT reads be Faster with RAID 1 than NO-Raid for the online redo
logfile ?

Thanks

> -Original Message-
> From: Edward Shevtsov [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 15, 2001 12:50 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Configuring for Online Redo Logfiles
> 
> Hi Vivek,
> 
> From performance point of view a single disk will be a little faster
> as
> there is a small overhead associated with the process of mirroring to
> the
> second member of the RAID1.
> 
> Regards,
> Ed
> 
> 
> > EXCERPT from "Implementing Raid On Oracle Systems" by Gaja Krishna
> > Vaidyanatha, Quest Software Inc. :-
> > "RAID 1 - Ideal for online and archived redo logs, Leaves the
> write-head
> > at the location of the last write.  On most systems, you will need 3
> > volumes for the online redo logs (for 3 groups) and 1 volume for the
> > archived redo logs. If your database is in NOARCHIVELOG mode, you
> > probably can get away with a single RAID 1 volume for your
> redo-logs.
> > However, for databases in ARCHIVELOG mode you will need to further
> > separate you"
> > Qs. Puttting an Online Redo log on a RAID1 Volume ( Volume
> Containing 1
> > Disk Mirrored to Another Disk ) versus putting the Same Online redo
> file
> > on a Single Disk (NON-Mirrored) , which would give Better
> performance ,
> > Why ?
> >
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  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: OT_salary

[SARKAR, Samir]

Title: RE: OT_salary



Well, what better could it 
be when I get a bus  every 5 minutes during peak hours and 

every 10 minutes during 
off-peak ??
I have visited New Jersy 
and Richmond in the US and I have seen that it is very 
difficult
to commute there if u dont 
have a car which is the reason getting a car remains the one of 

the priorities for anybody 
emigrating there.
 
Samir Sarkar 
Oracle DBA - Lennon 
Team SchlumbergerSema 
Email :  
[EMAIL PROTECTED]     
[EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 
EPABX : +44 (0) 115 - 957 6418 
Ext. 76217 Fax 
: +44 (0) 115 - 957 
6018    


  -Original Message-From: Hallas John 
  [mailto:[EMAIL PROTECTED]]Sent: 12 November 2001 
  15:35To: Multiple recipients of list ORACLE-LSubject: 
  RE: OT_salary
  I live in UK (Leeds) and frankly I would disagree with 
  everything you have said (no offense intended!!). DBA 
  salary differs depending on skill and location. I would have thought that 
  mid-level DBA for non London/Scotland  area is as you say £30-35K/annum. 
  From contractor rates I would say lower in Scotland and London could range 
  from £35-55K. 
  Banks , city instititution may pay more but I am sure it is 
  very hard getting in there. 
  As for transport I have worked in Nottingham 6 months ago (for 
  Logica) and I don't see the public transport system there any better than 
  Leeds,Manchester,London etc. They are all pretty poor. Unfortunately the 
  underlying transport infrastructure has been left underfunded and badly 
  managed for much too long. 
  John   
  -Original Message- From: 
  SARKAR, Samir [mailto:[EMAIL PROTECTED]] 
  Sent: 12 November 2001 13:50 To: 
  Multiple recipients of list ORACLE-L Subject: RE: 
  OT_salary 
  Well, if u r in London, u wont feel the difference. I am in 
  Nottingham in the Midlands and I can assure u that the 
  cost of living here is low compared to the US. So is 
  true for most of the other UK cities like Manchester, 
  Sheffield, Glasgow etc... Secondly, since the public 
  transport system is so good in the UK, u can save 
  money on ur car expenses if u wish to. 
  Samir Sarkar Oracle DBA - Lennon 
  Team SchlumbergerSema Email 
  :  [EMAIL PROTECTED]     
  [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 
  76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 
  Fax : +44 (0) 115 - 957 
  6018    
  
  -Original Message- Sent: 12 
  November 2001 13:15 To: Multiple recipients of list 
  ORACLE-L 
  cost of living is low?   I didn't see prices that 
  low or different than the US when I was in London... 
  did something change in the last year or so? 
  
  --- "SARKAR, Samir" 
  <[EMAIL PROTECTED]> wrote: > Of course its a per annum salary. We DBAs would have been 
  > millionaires by > now if that 
  kind of a salary were paid monthly.and people would > have > flocked > to the UK instead of the US :)). But then again, it is quite a 
  comfy > salary > in the 
  UK since the cost of living is low. > 
  > Samir Sarkar > Oracle 
  DBA - Lennon Team > SchlumbergerSema 
  > Email :  
  [EMAIL PROTECTED] > 
  [EMAIL PROTECTED] > Phone : +44 (0) 115 - 95 
  76217 > EPABX : +44 (0) 115 - 957 6418 Ext. 
  76217 > Fax : +44 (0) 115 - 957 
  6018    
  > > > -Original Message- > Sent: 12 
  November 2001 11:01 > To: SARKAR, Samir 
  > > > Hi Samir, > >   Is this salary per annum or per 
  month?  Please clarify. > > Regards, > > 
  Ranganath > > 
  -Original Message- > Sent: Monday, November 
  12, 2001 4:00 PM > To: Multiple recipients of list 
  ORACLE-L > > 
  > In the UK, it is around £30-35K. It used to be 
  around £40K but the > salaries have dropped after 
  the IT bubble burst. > > 
  Samir Sarkar > Oracle DBA - Lennon Team 
  > SchlumbergerSema > Email 
  :  [EMAIL PROTECTED] > 
  [EMAIL PROTECTED] > Phone : +44 (0) 115 - 95 
  76217 > EPABX : +44 (0) 115 - 957 6418 Ext. 
  76217 > Fax : +44 (0) 115 - 957 
  6018    
  > > > -Original Message- > Sent: 12 
  November 2001 09:15 > To: Multiple recipients of 
  list ORACLE-L > > 
  > Hi > i'd like to know 
  what average salarys are in european countries for a > medium > skilled DBA. > my first contribution is 40 USD > 
  > > vr. gr. 
  > g.g. kor > rdw ict the 
  netherlands > > 
  > -- > 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 co

Tricky Query

[Swajit Satam]

Hi All,

I am working on a application in which I have to find the Min and Max time of the user 
session. Since there will be multiple records for a single session with the 
overlapping time. the example data is as foll.

MMCR_APPNO MMCR_START_TIME  MMCR_END_TIME
--  --
110 30
120 40
140 45
110 50

160 80
170 90
165100

1   110120
1   105140

expected result

MMCR_APPNO MMCR_START_TIME  MMCR_END_TIME
--  --
110 50
160100
1   105140

the comparision has to be done on end time not lying between starttime and endtime of 
the next record if it does then the user belong to same session

cheers
Swajit


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Swajit Satam
  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: Move data from Oracle into Access

[Jan Pruner]

Instal ODBC for Oracle on your Access machine and open  from Access.
It's somewhere in menu (something like import data or ..)

JP

On Thu 15. November 2001 10:05, you wrote:
> Hi!
>
> What would be the easiest way to dump out an Oracle table and move it into
> Access? (approx. 100,000 rows) No flaming, please... ;)
>
> I assume that there is no tool for Access to read Oracle dmp-files, right?
>
> Is spooling it out into an ASCII file (blanks or comma-seperated) the only
> way? I just need a single table (no refs or the like).
>
> Any ideas?
>
> This is 8.1.7 on Solaris.
>
> Thanks,
> Helmut


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

-- 
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: Operating Systems

[Jan Pruner]

>From our root:
Don't use Solaris on Intel.
It's very very unstable and doesn't support too much HW.

JP



On Thu 15. November 2001 11:00, you wrote:
> >-And maybe (gods help me! ) NT?
>
> Get a rope!
>
> :O)
>
> -Original Message-
> Sent: Wednesday, November 14, 2001 12:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Linux or Solaris Intel.  And maybe (gods help me! ) NT?
>
> Scott Shafer
> San Antonio, TX
>
> Regina Harter wrote:
> > Hi Guys,
> >
> > Our SA/DBA is considering dumping Unixware and moving to a different
> > OS.  Sun is out for reasons that are not being shared with me, probably
> > because they don't want to buy new hardware, so aside from that, would
> > anyone care to weigh in with opinions on what OS is most stable with
> > Oracle?  AAnd will run on an intel based box?  Ours is not a high
> > transaction system, mostly reads, maybe 100 users a day.
> >
> > Thanks for your opinions,
> > Regina
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Regina Harter
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
-- 
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: SQL Query OutPut

[Robertson Lee - lerobe]

Look up group by clause in the SQL Reference Manual.

Regards

Lee


-Original Message-
Sent: 15 November 2001 10:05
To: Multiple recipients of list ORACLE-L


Hi,

I need the Query for the following result.
If any body help it will be very great. Its very urgent.


the output needed is



DeptNoEmpNo

101
2
3
4
5
2011
12
13

The DeptNo should not repeat for all the employees.
Thanks in advance

Regards

Pruthvi


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pruthvi
  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.
-- 
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: SQL Query OutPut

[Cale, Rick T (Richard)]

In sqlplus

BREAK ON deptno skip 1
SELECT deptno,empno
FROM your_table
ORDER BY deptno,empno;

You may want to set pagesize,spool etc.

Rick

-Original Message-
Sent: Thursday, November 15, 2001 5:05 AM
To: Multiple recipients of list ORACLE-L


Hi,

I need the Query for the following result.
If any body help it will be very great. Its very urgent.


the output needed is



DeptNoEmpNo

101
2
3
4
5
2011
12
13

The DeptNo should not repeat for all the employees.
Thanks in advance

Regards

Pruthvi


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pruthvi
  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: Cale, Rick T (Richard)
  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: Move data from Oracle into Access

[Stefan Jahnke]

Hi,

why don't you connect via ODBC or OO4O and "insert into ... select from
... " the data into your access tables.

cheers,
Stefan

"Daiminger, Helmut" schrieb:

>
>
> Hi!
>
> What would be the easiest way to dump out an Oracle table and move it
> into Access? (approx. 100,000 rows) No flaming, please... ;)
>
> I assume that there is no tool for Access to read Oracle dmp-files,
> right?
>
> Is spooling it out into an ASCII file (blanks or comma-seperated) the
> only way? I just need a single table (no refs or the like).
>
> Any ideas?
>
> This is 8.1.7 on Solaris.
>
> Thanks,
> Helmut
>
>
> -
> This Mail has been checked for Viruses
> Attention: Encrypted mails can NOT be checked!
>
> **
>
> Diese Mail wurde auf Viren geprueft
> Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft
> werden!
> -

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

RE: Move data from Oracle into Access

[Mark Leith]

Title: Move data from Oracle into Access



Helmut,
 
You 
can "import" the table via an ODBC link. 
 
Make 
sure that you have an ODBC datasource set up with Micro$ofts ODBC driver for 
Oracle for the Oracle instance, open up your Access "database window" then from 
your File menu choose "Get External Data/Import" you will be faced with a normal 
select file menu, down in the box "Files of type" choose ODBC Databases. Set up 
your connection accordingly and away you go. Another alternative is just to link 
to the table via ODBC (depending on what you want to do with the access 
database, this will just get the data from Oracle as and when requested, and you 
don't have to worry about synchronising or anything), or as you said, export to 
a comma delimited file, then import in much the same way as above, just choosing 
a different "File of type".
 
HTH
 
Mark
 
P.S. I 
seem to remember there being a fairly comprehensive section on this in the 
access help files.. Maybe they could help describe it a little better than 
I..;)
 
P.P.S. 
Flaming? How could we flame such a robust "RDBMS"! The shear joy of working with 
access that I get EVERY DAY doesn't warrant FLAMING! ;P No sir.. Not from me... 
(Seriously though - 100,000 in an Access table is really 
nothing..)

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, HelmutSent: 
  15 November 2001 09:05To: Multiple recipients of list 
  ORACLE-LSubject: Move data from Oracle into 
  Access
  Hi! 
  What would be the easiest way to dump out an Oracle table and 
  move it into Access? (approx. 100,000 rows) No flaming, please... 
;)
  I assume that there is no tool for Access to read Oracle 
  dmp-files, right? 
  Is spooling it out into an ASCII file (blanks or 
  comma-seperated) the only way? I just need a single table (no refs or the 
  like).
  Any ideas? 
  This is 8.1.7 on Solaris. 
  Thanks, Helmut 

RE: Sql question - please reply fast

[Iulian . ILIES]

select field1, decode(field1, 'Info missing', 'Info missing', 'Bad info',
'Bad info', substr(field1, 1, instr(translate(field1, '0123456789',
'@@'), '@')-3))
from 

HTH
Iulian

-Original Message-
Sent: Thursday, November 15, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L


**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Network Department.
**

Hej

Would like to have som help with this. Please give me an example of sql
statement.

I have field1.

Pelle T
Kalle S1000
Info missing
Pelle Svensson T3
Bad info

and  want this result after the selectstatement.

Pelle
Kalle
Info missing
Pelle Svensson
Bad info

which means that I dont want to have the last word in this field except
'Info missing' and 'Bad info'. These two should remain unchanged, but all
other should not have the last word .

Thanksin advance

Roland S



-- 
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 and 
may be legally privileged. It is intended solely for the use of the 
individual or entity to whom it is addressed and others authorised to 
receive it. If you are not the intended recipient you are hereby 
notified that any disclosure, copying, distribution or taking action in 
reliance of the contents of this information is strictly prohibited and 
may be unlawful. Mobil Rom is neither liable for the proper, complete 
transmission of the information contained in this communication nor 
any delay in its receipt.
**

-- 
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: Connecting 8.0 to 8.1

[Mark Leith]

There is something wrong with your host address.. If I were you I would
check the HOST value in your TNSNAMES.ora, and make sure the IP is correct.
Then, change the HOST values in your LISTENER.ora to use the IP address as
well instead of the host names.

Also, do you have the GLOBAL_NAMES parameter set to true in your initSID.ora
file? If it's set to false, then you can loose the :

 (GLOBAL_DBNAME = ORANGE**.acn032hq**)

bit, and keep it like this:

 (GLOBAL_DBNAME = ORANGE)

Try these out:

---tnsnames---

ORANGE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.798.101)(PORT = 1521))
(CONNECT_DATA = (SID = ORANGE))
  )

--

---listener---

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.798.101)(PORT = 1521))
  )
)
(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
  (ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.798.101)(PORT = 2481))
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (PROGRAM = extproc)
)
(SID_DESC =
  (GLOBAL_DBNAME = TEST)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = TEST)
)
(SID_DESC =
  (GLOBAL_DBNAME = ORANGE)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = ORANGE)
)
  )



HTH

Mark


-Original Message-
David
Sent: 15 November 2001 11:25
To: Multiple recipients of list ORACLE-L



Forgive me if this is a RTFM question - I have not been able to find the
right bit of the FM.

Can someone please tell me how to Net8 connect an 8.0 NT client to an 8.1
Linux server.

Everything was working fine until a second Oracle instance was installed on
the server.  I now get

ERROR:
ORA-12545: Connect failed because target host or object does not exist


My tnsnames.ora looks like this...

ORANGE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.798.101)(PORT = 1521))
(CONNECT_DATA = (SID = ORANGE))
  )

The server listener.ora looks like this

# LISTENER.ORA Network Configuration File:
/opt/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 1521))
  )
)
(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
  (ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 2481))
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (PROGRAM = extproc)
)
(SID_DESC =
  (GLOBAL_DBNAME = TEST.abc123de)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = TEST)
)
(SID_DESC =
  (GLOBAL_DBNAME = ORANGE.acn032hq)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = ORANGE)
)
  )

I anonymised the data (obviously)

Many thanks to anyone who understands this stuff.

David Jones
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jones, David
  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: Mark Leith
  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).

Command line utility to show installed Oracle software

[Cale, Rick T (Richard)]

Hi All,

I have forgotten the command line utility to show installed Oracle software.
Oracle 8.0.5/NT 4.

Can someone tell me?

Thanks
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  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: Operating Systems

[Boivin, Patrice J]

Time to get the leeches.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From:   Scott Shafer [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 14, 2001 6:56 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Operating Systems

Yeah, what was I thinking?  Must be too much blood in my tequila
system... ;-)

--S

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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 Query OutPut

[Robertson Lee - lerobe]

Whoops - misunderstood the question.

BREAK

Lee


-Original Message-
Sent: 15 November 2001 12:00
To: Multiple recipients of list ORACLE-L


Look up group by clause in the SQL Reference Manual.

Regards

Lee


-Original Message-
Sent: 15 November 2001 10:05
To: Multiple recipients of list ORACLE-L


Hi,

I need the Query for the following result.
If any body help it will be very great. Its very urgent.


the output needed is



DeptNoEmpNo

101
2
3
4
5
2011
12
13

The DeptNo should not repeat for all the employees.
Thanks in advance

Regards

Pruthvi


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

[Maria Aurora VT de la Vega]

SQL> break on DeptNo

Robertson Lee - lerobe wrote:

> Look up group by clause in the SQL Reference Manual.
>
> Regards
>
> Lee
>
> -Original Message-
> Sent: 15 November 2001 10:05
> To: Multiple recipients of list ORACLE-L
>
> Hi,
>
> I need the Query for the following result.
> If any body help it will be very great. Its very urgent.
>
> the output needed is
>
> DeptNoEmpNo
>
> 101
> 2
> 3
> 4
> 5
> 2011
> 12
> 13
>
> The DeptNo should not repeat for all the employees.
> Thanks in advance
>
> Regards
>
> Pruthvi
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Pruthvi
>   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.
> --
> 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).

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  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: Operating Systems

[Boivin, Patrice J]

That leaves NT for shops that require customer support...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Jan Pruner [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 15, 2001 7:55 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Operating Systems

From our root:
Don't use Solaris on Intel.
It's very very unstable and doesn't support too much HW.

JP


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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 Query OutPut

[Riswandi]

SQL> Break on DeptNo
SQL> Select ...


- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 5:05 PM


> Hi,
> 
> I need the Query for the following result.
> If any body help it will be very great. Its very urgent.
> 
> 
> the output needed is
> 
> 
> 
> DeptNoEmpNo
> 
> 101
> 2
> 3
> 4
> 5
> 2011
> 12
> 13
> 
> The DeptNo should not repeat for all the employees.
> Thanks in advance
> 
> Regards
> 
> Pruthvi
> 
> 
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Pruthvi
>   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: Riswandi
  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: Connecting 8.0 to 8.1

[Farnsworth, Dave]

You might have install the 8.1 client.  I may be wrong but I think with the
8.1 client you can connect to 8.1 and any version lower but with the 8.0
client you cannot connect to a higher version.  If you don't have the 8.1
client CD you can download the client at Oracle's site.

Dave

-Original Message-
Sent: Thursday, November 15, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L



Forgive me if this is a RTFM question - I have not been able to find the
right bit of the FM.

Can someone please tell me how to Net8 connect an 8.0 NT client to an 8.1
Linux server.

Everything was working fine until a second Oracle instance was installed on
the server.  I now get 

ERROR:
ORA-12545: Connect failed because target host or object does not exist


My tnsnames.ora looks like this...

ORANGE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.798.101)(PORT = 1521))
(CONNECT_DATA = (SID = ORANGE))
  )

The server listener.ora looks like this

# LISTENER.ORA Network Configuration File:
/opt/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 1521))
  )
)
(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
  (ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 2481))
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (PROGRAM = extproc)
)
(SID_DESC =
  (GLOBAL_DBNAME = TEST.abc123de)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = TEST)
)
(SID_DESC =
  (GLOBAL_DBNAME = ORANGE.acn032hq)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = ORANGE)
)
  )

I anonymised the data (obviously)

Many thanks to anyone who understands this stuff.

David Jones
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jones, David
  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: ORAxxxx & trace files.

[Hallas John]

Title: RE: ORA & trace files.





Hi Mark,


I wrote the following bit of code (not good enough to call a script!) to check our alert log for deadlock trace files


awk -f j.awk -v DateStr="Nov" -v SearchStr="info" alert.log > a.lis


numberOfLines=`grep info a.lis |wc -l`
if  [ $numberOfLines -gt 0 ]
then 


cat a.lis|mailx -s "Trace files detected" [EMAIL PROTECTED]


else 
cat a.lis|mailx -s "No problems" [EMAIL PROTECTED] 
fi


output looks something like this



Mon Nov 05 10:04:09 2001 ORA-00060: Deadlock detected. More info in file e:\ora.
Mon Nov 05 11:10:28 2001 ORA-00060: Deadlock detected. More info in file e:\ora.
Mon Nov 05 11:10:38 2001 ORA-00060: Deadlock detected. More info in file e:\ora.
Mon Nov 05 11:46:55 2001 ORA-00060: Deadlock detected. More info in file e:\ora.



Not perfect but almost there. Searching for Nov or Dec etc and the word info and then pulling the next line out


a.awk looks like


$2==DateStr{ oldline=$0
    getline
    if (match($0,SearchStr) >0){
    print oldline,$0
    }
}



 
I am sure there will be better examples provided but at least I wrote this myself and I am learning from it. It still needs something doing with the date. I am trying to translate this into a perl script as well but even less progress on that.

John







-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 15 November 2001 10:00
To: Multiple recipients of list ORACLE-L
Subject: ORA & trace files.



Hi list,


Does anybody have a good list of all the ORA errors that will cause a trace
file to be generated? We have a user of our tools that wants to monitor for
any trace files/dumps being generated. I can think of two ways:


1) monitor the alert log as above for specific errors
2) monitor the directories that these are generated in (bdump/cdump etc.)
for any new files generated in the timeframe..


Anybody already doing this - or have any scripts to save me re-inventing the
wheel?


Cheers


Mark


===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance



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




**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: Configuring for Online Redo Logfiles

[VIVEK_SHARMA]

Conor,List

1) Mirrored Redo Logs WRITES may have an Overhead of 15-20 %   
EXCERPT from Gaja's Doc "One of the common myths with mirroring, is that
it takes "twice as long" to write.But in many performance measurements
and benchmarks, the overhead has been observed to be around 15-20%."

2) Mirrored Redo Logs READS are Twice as Fast than NON-Mirrored 

Considering BOTH the Above to POINTS , FINALLY  Strictly w.r.t.
performance of Online Redo Logs , WITHOUT any Consideration for Data
Safety , Which would be Better ?

Thanks


> -Original Message-
> From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 15, 2001 3:15 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Configuring for Online Redo Logfiles
> 
> An unmirrored disk will run faster (with respect to
> writes) than a mirrored one (not twice as fast since
> writes on a mirror are typically done in parallel). 
> Then again - now you've got an unmirrored redo
> log...not a good idea.  To get around this, you'd need
> to duplex it through Oracle - which pretty much gets
> you back to a "mirrored" redo log.
> 
> hth
> connor
> 
>  --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: >
> EXCERPT from "Implementing Raid On Oracle Systems"
> > by Gaja Krishna
> > Vaidyanatha, Quest Software Inc. :-
> > "RAID 1 - Ideal for online and archived redo logs,
> > Leaves the write-head
> > at the location of the last write.  On most systems,
> > you will need 3
> > volumes for the online redo logs (for 3 groups) and
> > 1 volume for the
> > archived redo logs. If your database is in
> > NOARCHIVELOG mode, you
> > probably can get away with a single RAID 1 volume
> > for your redo-logs.
> > However, for databases in ARCHIVELOG mode you will
> > need to further
> > separate you"
> > Qs. Puttting an Online Redo log on a RAID1 Volume (
> > Volume Containing 1
> > Disk Mirrored to Another Disk ) versus putting the
> > Same Online redo file
> > on a Single Disk (NON-Mirrored) , which would give
> > Better performance ,
> > Why ? 
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: VIVEK_SHARMA
> >   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). 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the statue"
> 
> __
> 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?Connor=20McDonald?=
>   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: VIVEK_SHARMA
  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).

ORA 600 error can't find reference on Metalink

[Jamadagni, Rajendra]

Hi all,

I recently found following errors in alert log, but couldn't locate any
information on Metalink, does anyone know what these errors are? I will be
opening a TAR with OWS this AM.

ORA-00600: internal error code, arguments: [4427], [], [], [], [], [], [],
[]
ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [], [], [],
[], [], []

TIA
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 !




*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

hide password

[Tatireddy, Shrinivas (MED, Keane)]

Hi lists,

We can see users password using

ps -ef |grep  sqlplus

(if we run a job using sqlplus scott/tiger @${runfile}  ).

To prevent this we can run our code

sqlplus -s 

OT: Sybase

[Vladimir Barac - posao]

Question for dual - dbms dba people.

Beside Oracle, I have some Sybase stuff to do. And I'm sure that there are
some of you that do know something about Sybase.

Do you have any documents that deal with:

- tricks'n'tips

- do's and dont's

- introductions

- backups

- best practices

- worst practices...

Feel free to send either docs or links.

Thanks in advance,
Vladimir Barac

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vladimir Barac - posao
  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: Enterprise Versus Standard

[Gilbert, Ashley]

I received the attachment from my Oracle License Manager when we were
moving toward purchasing Oracle Standard Edition.  It compares
SqlServer2000, Oracle9i and DB2.  It's very handy if your in a
heterogeneous environment.  
After reviewing the document it was clear to us Enterprise Edition was
the way to go.

Hope it helps.
Ashley

-Original Message-
Sent: Wednesday, November 14, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L


Does anyone have a good Oracle Standard to Oracle Enterprise comparison
Chart ??   I am looking on the various Oracle ran sites and most of the
docs
seem to try and steer you to Enterprise.

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



O9COMPETMATRIX.DOC
Description: MS-Word document

Re: hide password

[nlzanen1]

Hi,


Use a controlfile.


Jack




"Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]>
@fatcity.com on 15-11-2001 14:10:26

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Hi lists,

We can see users password using

ps -ef |grep  sqlplus

(if we run a job using sqlplus scott/tiger @${runfile}  ).

To prevent this we can run our code

sqlplus -s 

RE: CLOB datatype

[Jack C. Applewhite]

Rick,

CLOBs been bery bery good to me.  ;-)(8.1.6 on Win2k)

We collect 50,000 - 200,000 documents per day and store them in out-of-line
CLOBs in a partitioned table.  The CLOB column has an interMedia Text index
on it, which allows us to query up to about 12 million documents with great
performance.

CLOBs can be stored in separate segments from the "regular" data, allowing
better storage and access control.  CLOBs can be easily manipulated with the
DBMS_LOB package.  They suffer from none of the many problems caused by LONG
columns.

They're GRREAT!

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2001 4:37 PM
To: Multiple recipients of list ORACLE-L


Does anyone have any opinions on using CLOB/NCLOB datatypes in Oracle?  I
am running 8.1.7.2 on Solaris.
Oracle Docs state that CLOBs can handle up to 4 Gig.  Are there any gotchas
by using CLOBs?

Thanks for any information,

Rick Stephenson

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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: Configuring for Online Redo Logfiles

[Edward Shevtsov]

Hi Vivek,

If I didn't worry about data safety I would choose redo logs on dedicated
single disks.
The reason is that usually the speed of LGWR's writes is more important for
performance compared with speed of ARCH's reads.

Regards,
Ed


> Conor,List
>
> 1) Mirrored Redo Logs WRITES may have an Overhead of 15-20 %
> EXCERPT from Gaja's Doc "One of the common myths with mirroring, is that
> it takes "twice as long" to write.But in many performance measurements
> and benchmarks, the overhead has been observed to be around 15-20%."
>
> 2) Mirrored Redo Logs READS are Twice as Fast than NON-Mirrored
>
> Considering BOTH the Above to POINTS , FINALLY  Strictly w.r.t.
> performance of Online Redo Logs , WITHOUT any Consideration for Data
> Safety , Which would be Better ?
>
> Thanks
>
>
> > -Original Message-
> > From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, November 15, 2001 3:15 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Configuring for Online Redo Logfiles
> >
> > An unmirrored disk will run faster (with respect to
> > writes) than a mirrored one (not twice as fast since
> > writes on a mirror are typically done in parallel).
> > Then again - now you've got an unmirrored redo
> > log...not a good idea.  To get around this, you'd need
> > to duplex it through Oracle - which pretty much gets
> > you back to a "mirrored" redo log.
> >
> > hth
> > connor
> >
> >  --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: >
> > EXCERPT from "Implementing Raid On Oracle Systems"
> > > by Gaja Krishna
> > > Vaidyanatha, Quest Software Inc. :-
> > > "RAID 1 - Ideal for online and archived redo logs,
> > > Leaves the write-head
> > > at the location of the last write.  On most systems,
> > > you will need 3
> > > volumes for the online redo logs (for 3 groups) and
> > > 1 volume for the
> > > archived redo logs. If your database is in
> > > NOARCHIVELOG mode, you
> > > probably can get away with a single RAID 1 volume
> > > for your redo-logs.
> > > However, for databases in ARCHIVELOG mode you will
> > > need to further
> > > separate you"
> > > Qs. Puttting an Online Redo log on a RAID1 Volume (
> > > Volume Containing 1
> > > Disk Mirrored to Another Disk ) versus putting the
> > > Same Online redo file
> > > on a Single Disk (NON-Mirrored) , which would give
> > > Better performance ,
> > > Why ?
> > > --


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Edward Shevtsov
  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: Operating Systems

[Jan Pruner]

I guess that on Intel platform you don't have other choice than Linux and 
Oracle fo Linux.

Database on NT = highway to hell and you cruise at high speed

JP

On Thu 15. November 2001 13:40, you wrote:
> That leaves NT for shops that require customer support...
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>   -Original Message-
>   From:   Jan Pruner [SMTP:[EMAIL PROTECTED]]
>   Sent:   Thursday, November 15, 2001 7:55 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject:Re: Operating Systems
>
>   From our root:
>   Don't use Solaris on Intel.
>   It's very very unstable and doesn't support too much HW.
>
>   JP
-- 
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: Enterprise Versus Standard

[Gilbert, Ashley]

I didn't relize we couldn't send binary attachments.  If anyone else
needs the document, let me know and I'll send it to you directly.

Ashley

-Original Message-
Sent: Thursday, November 15, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L


I received the attachment from my Oracle License Manager when we were
moving toward purchasing Oracle Standard Edition.  It compares
SqlServer2000, Oracle9i and DB2.  It's very handy if your in a
heterogeneous environment.  
After reviewing the document it was clear to us Enterprise Edition was
the way to go.

Hope it helps.
Ashley

-Original Message-
Sent: Wednesday, November 14, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L


Does anyone have a good Oracle Standard to Oracle Enterprise comparison
Chart ??   I am looking on the various Oracle ran sites and most of the
docs
seem to try and steer you to Enterprise.

Kevin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  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: Gilbert, Ashley
  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:Mass Storage/Network Stuff

[dgoulet]

Ed,

The answer is yes and no, or more accurately it depends.  First off there
are only two storage vendors, to my knowledge, certified by Oracle for this. 
They are Net Appliance and EMC.  The reason is that they have software and
hardware that 'guarantees' to get the data from the buffers to the drives. 
Secondly you need absolutely dedicated TCP/IP connectivity between the computer
and the storage array.  Look at it as replacing scsi adapters and cables with
network cards and cables.

Dick Goulet

Reply Separator
Author: "Ed" <[EMAIL PROTECTED]>
Date:   11/14/2001 4:36 PM

Are there any problems running Oracle on one box, and pointing the database
files to a mass storage network device (ie. a disk array or some external
storage solution).  In other words, will Oracle run using network
addressable storage?  I'm assuming this is not a difficult thing to do, but
I would love to hear some war stories.

Any configuration or specific recommendations on how to do this?  Unix/NT an
issue?

Best,

Ed


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed
  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: Mass Storage/Network Stuff

[Mercadante, Thomas F]

Ed,

I am running NT with EMC storage arrays over dedicated fiber connections.  

Very good, very fast, very stable (and very happy).

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, November 15, 2001 8:58 AM
To: Multiple recipients of list ORACLE-L


Ed,

The answer is yes and no, or more accurately it depends.  First off
there
are only two storage vendors, to my knowledge, certified by Oracle for this.

They are Net Appliance and EMC.  The reason is that they have software and
hardware that 'guarantees' to get the data from the buffers to the drives. 
Secondly you need absolutely dedicated TCP/IP connectivity between the
computer
and the storage array.  Look at it as replacing scsi adapters and cables
with
network cards and cables.

Dick Goulet

Reply Separator
Author: "Ed" <[EMAIL PROTECTED]>
Date:   11/14/2001 4:36 PM

Are there any problems running Oracle on one box, and pointing the database
files to a mass storage network device (ie. a disk array or some external
storage solution).  In other words, will Oracle run using network
addressable storage?  I'm assuming this is not a difficult thing to do, but
I would love to hear some war stories.

Any configuration or specific recommendations on how to do this?  Unix/NT an
issue?

Best,

Ed


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

[Mercadante, Thomas F]

All,

Interesting comments regarding OS selection.  Of course, this has been
covered in the past at great length.

Let me add my 2 cents.

NT is a very viable option if it is being administered by a competent NT
Admin who does not treat the box like a home desktop.

I have been working on NT boxes for two years now, and have seen the worst
and best it has to offer.  The worst is when it is not respected as a true
operating system.  The best is when it is managed carefully and with great
fore-thought.

I have not experienced *any* of the comments made in this thread - like
rebooting every so often.  I have very stable, powerfull machines that are
being managed by the best NT admins I have every seen, and they are
performing very nicely, thank you.

In my opinion, they are a viable platform solution.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, November 15, 2001 8:53 AM
To: Multiple recipients of list ORACLE-L


I guess that on Intel platform you don't have other choice than Linux and 
Oracle fo Linux.

Database on NT = highway to hell and you cruise at high speed

JP

On Thu 15. November 2001 13:40, you wrote:
> That leaves NT for shops that require customer support...
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>   -Original Message-
>   From:   Jan Pruner [SMTP:[EMAIL PROTECTED]]
>   Sent:   Thursday, November 15, 2001 7:55 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject:Re: Operating Systems
>
>   From our root:
>   Don't use Solaris on Intel.
>   It's very very unstable and doesn't support too much HW.
>
>   JP
-- 
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).
-- 
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: hide password

[Tatireddy, Shrinivas (MED, Keane)]

Can you explain in detail how to use a controlfile in exports?

thnx and regards,
Srinvias
-Original Message-
Sent: Thursday, November 15, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L



Hi,


Use a controlfile.


Jack




"Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]>
@fatcity.com on 15-11-2001 14:10:26

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Hi lists,

We can see users password using

ps -ef |grep  sqlplus

(if we run a job using sqlplus scott/tiger @${runfile}  ).

To prevent this we can run our code

sqlplus -s 

RE: Operating Systems

[Mark Leith]

At last! Somebody who speaks my language!

The biggest problem I have found with NT is when people insist on adding
this and that and that over there, add this piece of software that
overwrites this .dll but hasn't been properly tested.. Poor drivers etc..

Grab an Intel system, fresh off the press.. Install Oracle, set up your
network card, set up your database, set up security, open to the network -
LEAVE IT ALONE.. you got yourself a pretty damn stable system..

We have a Win2K system here that is used for file storage.. It has two HDs,
one with the OS, the other with all files & backups shared across a network.
I have NEVER had to reboot this system! Oh sorry I did ONCE when I had to
move it's location.

-Original Message-
Thomas F
Sent: 15 November 2001 14:11
To: Multiple recipients of list ORACLE-L


All,

Interesting comments regarding OS selection.  Of course, this has been
covered in the past at great length.

Let me add my 2 cents.

NT is a very viable option if it is being administered by a competent NT
Admin who does not treat the box like a home desktop.

I have been working on NT boxes for two years now, and have seen the worst
and best it has to offer.  The worst is when it is not respected as a true
operating system.  The best is when it is managed carefully and with great
fore-thought.

I have not experienced *any* of the comments made in this thread - like
rebooting every so often.  I have very stable, powerfull machines that are
being managed by the best NT admins I have every seen, and they are
performing very nicely, thank you.

In my opinion, they are a viable platform solution.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, November 15, 2001 8:53 AM
To: Multiple recipients of list ORACLE-L


I guess that on Intel platform you don't have other choice than Linux and
Oracle fo Linux.

Database on NT = highway to hell and you cruise at high speed

JP

On Thu 15. November 2001 13:40, you wrote:
> That leaves NT for shops that require customer support...
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>   -Original Message-
>   From:   Jan Pruner [SMTP:[EMAIL PROTECTED]]
>   Sent:   Thursday, November 15, 2001 7:55 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject:Re: Operating Systems
>
>   From our root:
>   Don't use Solaris on Intel.
>   It's very very unstable and doesn't support too much HW.
>
>   JP
--
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).
--
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: Mark Leith
  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: Failures in creating Oracle database file.

[Tirumala, Surendra]

In one of my previous assignments, even if my ulimit was unlimited, I could
not create datafiles bigger than 2 GB,
The OS was Sun Solaris 2.6. So best thing is to test what Kirti suggested.
 
Thanks,
Suren

-Original Message-
Sent: Wednesday, November 14, 2001 12:25 AM
To: Multiple recipients of list ORACLE-L



I checked the ulimit and it is set to "unlimited" so I don't think that is
the problem.  I think it is a little more insidious than that

Deshpande, Kirti wrote:


Sounds like a large file can not be created in the file system (the large
file option at FS level?) or your 'ulimit' is not set large enough to handle
large sized files. 

- Kirti 


-Original Message-
From:   Jesse W. Asher [ SMTP:[EMAIL PROTECTED]
 ]
Sent:   Tuesday, November 13, 2001 9:35 PM
To: Multiple recipients of list ORACLE-L
Subject:Failures in creating Oracle database file.

  
I'm attempting to create a 3GB file on an XFS filesystem using Oracle 8i
running on RedHat 7.1 with a generic 2.4.10 kernel and I'm getting some
errors.  Here's the command and output I'm getting: 

CREATE TABLESPACE ALTUSER DATAFILE
'/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE AUTOEXTEND ON
NEXT 1280K 
MINIMUM EXTENT 128K DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1
MAXEXTENTS 4096 PCTINCREASE 0); 

CREATE TABLESPACE ALTUSER DATAFILE
'/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE 
* 
ORA-01119: error in creating database file
'/export/4/oracle/oradata/alt/data01.dbf'

 
ORA-27037: unable to obtain file status 
Linux Error: 75: Value too large for defined data type 

= 

Any ideas as to what could be causing this?  I thought the file size limit
is 4GB which is why I made the file 3GB.  Is this correct or am I missing
something??  Many thanks!! 
  
-- 
Jesse W. Asher   [EMAIL PROTECTED]
 
 




-- 

Jesse W. Asher



"They that can give up essential liberty to purchase a little temporary

safety, deserve neither liberty or safety."  - Benjamin Franklin


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

Oracle express errors

[Zenor, Patty]

Hi All,
I have a customer that is getting the following errors when attempting to
connect to a Folder in Oracle Express Server. 
Error #7219 in XPCUBE: Informational (0100): Reset to default
CAUSESB selection
Error #7218 in XPCUBE: informational (0100): No CAUSESB values in
status.

They also get the following error when attempting to connect to another
Folder in express server.
Error #31701 in GRAPHCC.DLL: Non-fatal (0300): Wait or No-Hit-Test
state in effect

These errors are not show stoppers but have just recently been showing up
according to the client. I know very little about Oracle Express Server and
have not been able to find any error messages that will give me any clue as
to what might be the problem. Any information would be greatly appreciated!
System Information: Sun Solaris: 2.6
  Oracle: 8.1.6.3.0
  Express Server: 6.1
Thanks! 



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

hide password

[Tirumala, Surendra]

Jack, 
I think you are referring to PARFILE...


Suren


-Original Message-
Sent: Thursday, November 15, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L



Hi,


Use a controlfile.


Jack




"Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]>
@fatcity.com on 15-11-2001 14:10:26

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Hi lists,

We can see users password using

ps -ef |grep  sqlplus

(if we run a job using sqlplus scott/tiger @${runfile}  ).

To prevent this we can run our code

sqlplus -s 

Re: Operating Systems

[Jan Pruner]

Hmm, I'm not trying  to start flamewar!

I was hired 3 years ago and the company has 3 databases on MS SQL (every 
about 1GB).
Today we have * in 1 Oracle db running on Linux.

And now.
I have done an import daemon from pure text files (replication between 
servers) in C++.
On NTFS import into MS SQL - 3 inserts / second.
On ext2 import into Oracle   - 12 inserts / second.

The same HW (but on Linux is RAID 10!!!).

Yes, NT is nice with 5 or 20 people. I know it and I'm using it so.

JP

On Thu 15. November 2001 15:10, you wrote:
> All,
>
> Interesting comments regarding OS selection.  Of course, this has been
> covered in the past at great length.
>
> Let me add my 2 cents.
>
> NT is a very viable option if it is being administered by a competent NT
> Admin who does not treat the box like a home desktop.
>
> I have been working on NT boxes for two years now, and have seen the worst
> and best it has to offer.  The worst is when it is not respected as a true
> operating system.  The best is when it is managed carefully and with great
> fore-thought.
>
> I have not experienced *any* of the comments made in this thread - like
> rebooting every so often.  I have very stable, powerfull machines that are
> being managed by the best NT admins I have every seen, and they are
> performing very nicely, thank you.
>
> In my opinion, they are a viable platform solution.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Thursday, November 15, 2001 8:53 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I guess that on Intel platform you don't have other choice than Linux and
> Oracle fo Linux.
>
> Database on NT = highway to hell and you cruise at high speed
>
> JP
>
> On Thu 15. November 2001 13:40, you wrote:
> > That leaves NT for shops that require customer support...
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > -Original Message-
> > From:   Jan Pruner [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, November 15, 2001 7:55 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Re: Operating Systems
> >
> > From our root:
> > Don't use Solaris on Intel.
> > It's very very unstable and doesn't support too much HW.
> >
> > JP
-- 
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).

select and rollback

[Hatzistavrou Giannis]

Dear All,


I have a select statement that when runs it complains about limited rollback
segment extents. Do selects use rollback?

Regards
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hatzistavrou Giannis
  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: hide password

[Deshpande, Kirti]

Use parfile option. 

- Kirti 

> -Original Message-
> From: Tatireddy, Shrinivas (MED, Keane)
> [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 15, 2001 7:10 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  hide password
> 
> Hi lists,
> 
> We can see users password using
> 
> ps -ef |grep  sqlplus
> 
> (if we run a job using sqlplus scott/tiger @${runfile}  ).
> 
> To prevent this we can run our code
> 
> sqlplus -s < scott/tiger
> @${runfile}
> EOF
> 
> Is there a similar way in export hiding the password (preventing users
> to see the password) . I tried it with EOF. But its not working.
> 
> I need to setup the export in cron.
> 
> can anybody through some light on this.
> 
> Thnx and regards,
> Srinivas
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tatireddy, Shrinivas (MED, Keane)
>   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: Deshpande, Kirti
  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).

Migration from Oracle 7.3.4 to Oracle 8.1.7 on IBM Cluster

[VIVEK_SHARMA]

On an IBM AIX 4.3.3 Having HSEMP Cluster Allowing to Machines to Share
the SAME Storage Box
( But Different respective Partitons though )

STEPS :-
- From ORACLE_HOME of 8i
mig <$ORACLE_HOME of 8i> <$ORACLE_HOME of 7.3.4>
RESULT Creates conv$SID.dbf in ORACLE_HOME of 7.3.4
- mv conv$SID.dbf  from ORACLE_HOME of 7.3.4 to ORACLE_HOME of 8i
- From $ORACLE_HOME of 8i
SVRMGRL> STARTUP NOMOUNT
SVRMGRL> ALTER DATABASE CONVERT 

ORA-29702 
29702, 0, "error occurred in Cluster Group Service operation"


NOTE We have NEVER Done Migrations on CLUSTER
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  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: Configuring for Online Redo Logfiles

[VIVEK_SHARMA]

Ed,List

Since we Enable log_checkpoint_interval to a Very High Value ,
Qs Would READs for Data of Tables Also NOT Occur from the Online Redo
Logfiles ?

NOTE Oracle version 8.1.7.2 

Thanks


> -Original Message-
> From: Edward Shevtsov [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 15, 2001 7:16 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Configuring for Online Redo Logfiles
> 
> Hi Vivek,
> 
> If I didn't worry about data safety I would choose redo logs on
> dedicated
> single disks.
> The reason is that usually the speed of LGWR's writes is more
> important for
> performance compared with speed of ARCH's reads.
> 
> Regards,
> Ed
> 
> 
> > Conor,List
> >
> > 1) Mirrored Redo Logs WRITES may have an Overhead of 15-20 %
> > EXCERPT from Gaja's Doc "One of the common myths with mirroring, is
> that
> > it takes "twice as long" to write.But in many performance
> measurements
> > and benchmarks, the overhead has been observed to be around 15-20%."
> >
> > 2) Mirrored Redo Logs READS are Twice as Fast than NON-Mirrored
> >
> > Considering BOTH the Above to POINTS , FINALLY  Strictly w.r.t.
> > performance of Online Redo Logs , WITHOUT any Consideration for Data
> > Safety , Which would be Better ?
> >
> > Thanks
> >
> >
> > > -Original Message-
> > > From: Connor McDonald [SMTP:[EMAIL PROTECTED]]
> > > Sent: Thursday, November 15, 2001 3:15 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Configuring for Online Redo Logfiles
> > >
> > > An unmirrored disk will run faster (with respect to
> > > writes) than a mirrored one (not twice as fast since
> > > writes on a mirror are typically done in parallel).
> > > Then again - now you've got an unmirrored redo
> > > log...not a good idea.  To get around this, you'd need
> > > to duplex it through Oracle - which pretty much gets
> > > you back to a "mirrored" redo log.
> > >
> > > hth
> > > connor
> > >
> > >  --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: >
> > > EXCERPT from "Implementing Raid On Oracle Systems"
> > > > by Gaja Krishna
> > > > Vaidyanatha, Quest Software Inc. :-
> > > > "RAID 1 - Ideal for online and archived redo logs,
> > > > Leaves the write-head
> > > > at the location of the last write.  On most systems,
> > > > you will need 3
> > > > volumes for the online redo logs (for 3 groups) and
> > > > 1 volume for the
> > > > archived redo logs. If your database is in
> > > > NOARCHIVELOG mode, you
> > > > probably can get away with a single RAID 1 volume
> > > > for your redo-logs.
> > > > However, for databases in ARCHIVELOG mode you will
> > > > need to further
> > > > separate you"
> > > > Qs. Puttting an Online Redo log on a RAID1 Volume (
> > > > Volume Containing 1
> > > > Disk Mirrored to Another Disk ) versus putting the
> > > > Same Online redo file
> > > > on a Single Disk (NON-Mirrored) , which would give
> > > > Better performance ,
> > > > Why ?
> > > > --
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Edward Shevtsov
>   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: VIVEK_SHARMA
  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: select and rollback

[Charlie Mengler]

The timing of this question is amazing.
Just yesterday I was reading in Tom Kyte's book
"Expert One-on-One" ISBN 1-861004-82-6
about this specific topic.

The short answer is "YES!"
For a more complete answer RTFB.

Hatzistavrou Giannis wrote:
> 
> Dear All,
> 
> I have a select statement that when runs it complains about limited rollback
> segment extents. Do selects use rollback?
> 
> Regards
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hatzistavrou Giannis
>   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-2229San Diego, CA 92131
Extraordinary DBA - Design on the Fly & Just In Time Programming
-- 
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).

Need help rewriting SQL with TRUNC function

[Cherie_Machler]

I think that the following statement is keeping this application from using
an index in my cost-based execution plan.  This is an 8.0.4 database so I
don't have the option of creating a function-based index.

I'm not that great with SQL.  Can anyone help me rewrite this statement so
that I don't need to use the TRUNC function on this column in blue?

  (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
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: select and rollback

[Larry Elkins]

They can, most notably for read consistency.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> Hatzistavrou Giannis
> Sent: Thursday, November 15, 2001 8:41 AM
> To: Multiple recipients of list ORACLE-L
> Subject: select and rollback
> 
> 
> Dear All,
> 
> 
> I have a select statement that when runs it complains about 
> limited rollback
> segment extents. Do selects use rollback?
> 
> Regards

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  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: ORA 600 error can't find reference on Metalink

[K Gopalakrishnan]

Raj,

You didn't tell me the Oracle Version. So I would assume this is most
current version.

Your error OERI:4427 is a transaction layer component internal error.
By any chance you are using 2 phase commits (or ditributed
transactions) in thiese databases? or database resource manager ?




--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> I recently found following errors in alert log, but couldn't locate
> any
> information on Metalink, does anyone know what these errors are? I
> will be
> opening a TAR with OWS this AM.
> 
> ORA-00600: internal error code, arguments: [4427], [], [], [], [],
> [], [],
> []
> ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [],
> [], [],
> [], [], []


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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: Mass Storage/Network Stuff

[Ed]

To those who answered: thanks!  This mailing list is a wonderful resource.

Ed


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed
  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: is there an archive for this mailing list...

[Rachel Carmichael]

www,fatcity.com  you will need to sign up for it but you can then
access old messages from this list


--- grace <[EMAIL PROTECTED]> wrote:
> hi gurus
> is there an archive for this mailing list? if yes , how can i access
> them
> 
> Best regards,
> 
> Grace Lim
> Suy Sing Comm'l Corp.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: grace
>   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!?
Find the one for you at Yahoo! Personals
http://personals.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: Need help rewriting SQL with TRUNC function

[Jan Pruner]

Hmm,

my_limit_date   DATE:= trunc(sysdate) - 6; -- !!! only 6

erh.arrival_dt < my_limit_date 


JP

On Thu 15. November 2001 16:00, you wrote:
> I think that the following statement is keeping this application from using
> an index in my cost-based execution plan.  This is an 8.0.4 database so I
> don't have the option of creating a function-based index.
>
> I'm not that great with SQL.  Can anyone help me rewrite this statement so
> that I don't need to use the TRUNC function on this column in blue?
>
>   (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND
>
> Thanks,
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
-- 
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).

Oracle Expert and FK indexes

[Boivin, Patrice J]

Does someone know why the Oracle Expert would recommend dropping indexes on
FK columns?

Maybe it calculates there is a low likelihood of the table being locked
during referential integrity checks ?

I thought it was a good idea to have indexes on FK columns... this is an old
7.3.4.5. database.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  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: Import Help

[Rachel Carmichael]

And if you are importing into a database on the same machine, make sure
you set destroy=n 


--- John Kanagaraj <[EMAIL PROTECTED]> wrote:
> Sujatha,
> 
> > I have an export file from an 8.0.6 database which I need to 
> > import into an
> > 8.1.7 db. However, the locations of the tablespaces are 
> > different in the
> > 8.1.7 db.
> 
> Precreate the databases, i.e. (a) Create the database (CREATE
> DATABASE
> statment) via dbassist or scripts, (b) Create the non-SYSTEM/TEMP/RBS
> tablespaces via a script in the required location (c) Import the
> database
> making sure that 'IGNORE=Y' is set (i.e. you will have to specify
> this
> parameter as the default is N.
> 
> Hth,
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
> 
> Listen to great commercial-free christian music 24x7 at www.klove.com
> 
> 
> ** The opinions and statements above are entirely my own and not
> those of my employer or clients **
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Kanagaraj
>   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!?
Find the one for you at Yahoo! Personals
http://personals.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: Disk Layout Document

[Kimberly Smith]

Every time they ask for a new database I try that 22 disk thing
also.  I also settle for 6 mount points (not 6 disks).  Its still
fun to try though.  Especially when we hire new people.

-Original Message-
Sent: Wednesday, November 14, 2001 6:45 PM
To: Multiple recipients of list ORACLE-L


the very first time I ever saw Kevin present, he was talking about
that. I went out and bought the DBA Handbook and came home to the
operations people saying "I need 22 disks"

when they picked themselves up off the floor I said "okay, I can get
away with 17"

again, I waited until they stopped laughing and said "can I get 9?"

I settled for 6


then I kept reading the book and emailing kevin with the typos I would
find. And that dear ones, is how Kevin Loney and I met and became
friends.

He got his revenge for my bothering him though -- he got me to
co-author a book :)

Rachel

--- Larry Elkins <[EMAIL PROTECTED]> wrote:
> Bingo! Chapter 4. I knew I had read the variations somewhere. 
> 
> Thanks for the assist. 
> 
> Regards,
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
> 214.954.1781
> 
> > -Original Message-
> > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 14, 2001 3:32 PM
> > To: '[EMAIL PROTECTED]'
> > Cc: '[EMAIL PROTECTED]'
> > Subject: RE: Disk Layout Document
> > 
> > 
> > I believe the Oracle DBA Handbook by Kevin Loney has that...
> > 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Larry Elkins
>   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!?
Find the one for you at Yahoo! Personals
http://personals.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

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

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

Re: hide password

[claudio cutelli]

Hi, you should use
os_authent_prefix = "" in your init file and some other
parameters that i don't remember
but you can find it in the reference,
that allow you to make a connect like sqlplus / or exp /

By :-)

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 3:40 PM


Jack,
I think you are referring to PARFILE...


Suren


-Original Message-
Sent: Thursday, November 15, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L



Hi,


Use a controlfile.


Jack




"Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]>
@fatcity.com on 15-11-2001 14:10:26

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Hi lists,

We can see users password using

ps -ef |grep  sqlplus

(if we run a job using sqlplus scott/tiger @${runfile}  ).

To prevent this we can run our code

sqlplus -s 

RE: Import Help

[Hand, Michael T]

Sujatha,

Yes it will try to create them, but John's point is that if you create the
database/tablespaces before you import then the tablespaces will already
exist.  The import will generate errors on the tablespace create steps then
move on to schema & object import steps.

Mike Hand

-Original Message-
Sent: Wednesday, November 14, 2001 7:56 PM
To: Multiple recipients of list ORACLE-L


Hi John,

But wont this try and create the datafiles in the same location as the
original database???

Regs

Sujatha
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  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 help rewriting SQL with TRUNC function

[Cherie_Machler]

Jan,

Thanks for this reply.  What I forgot to mention is that this 7 is a
literal
that I substituted for a bind variable :b2.

Sorry about leaving out that critical piece of information.

Cherie


   
  
Jan Pruner 
  
<[EMAIL PROTECTED]   To: [EMAIL PROTECTED]  
  
>cc: [EMAIL PROTECTED]  
  
 Subject: Re: Need help rewriting SQL with 
TRUNC function
11/15/01 10:13 
  
AM 
  
Please respond 
  
to jan 
  
   
  
   
  




Hmm,

my_limit_dateDATE   := trunc(sysdate) - 6; -- !!! only 6

erh.arrival_dt < my_limit_date


JP

On Thu 15. November 2001 16:00, you wrote:
> I think that the following statement is keeping this application from
using
> an index in my cost-based execution plan.  This is an 8.0.4 database so I
> don't have the option of creating a function-based index.
>
> I'm not that great with SQL.  Can anyone help me rewrite this statement
so
> that I don't need to use the TRUNC function on this column in blue?
>
>   (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND
>
> Thanks,
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network




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

[no subject]

[SARKAR, Samir]

So which was the book u co-authored with Kevin Loney, Rachel ?? 
Can't wait to get my hands on it :)

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018



___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

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

9i new features series: yea i'm late with this weeks 9i feature on datatypes

[jtesta]

But it will be worthwhile since i'm learning ALOT about the new datatypes for dealign 
with dates/time/timezone/fractional seconds, etc.

anyways in the meantime, i had quite a few people ask about back issues :)

they are up on my website

http://www.oracle-dba.com/9i

that will take you to the main page with the links for the previous 5 weeks.

joe


---
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
IM: JoeN8XCT or N8XCTHOME



-- 
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: Operating Systems

[Kimberly Smith]

I can't argue with that one.  NT does have its place.  If its not a critical
application and you only need a predetermined amount of users to access
it, its a pretty cheap way to get a very expensive database up.  Its all
a matter of economics.  

However, then you have 6 million NT servers cause you really can only have
one
application on it or they don't play so nice.  As opposed to one nice
kick-ass HPUX server (or two in my case as we Service Guard them).  OK, so
I have more then two but to put what I have on Unix on NT would mean a whole
new data center.  

-Original Message-
Sent: Thursday, November 15, 2001 6:41 AM
To: Multiple recipients of list ORACLE-L


At last! Somebody who speaks my language!

The biggest problem I have found with NT is when people insist on adding
this and that and that over there, add this piece of software that
overwrites this .dll but hasn't been properly tested.. Poor drivers etc..

Grab an Intel system, fresh off the press.. Install Oracle, set up your
network card, set up your database, set up security, open to the network -
LEAVE IT ALONE.. you got yourself a pretty damn stable system..

We have a Win2K system here that is used for file storage.. It has two HDs,
one with the OS, the other with all files & backups shared across a network.
I have NEVER had to reboot this system! Oh sorry I did ONCE when I had to
move it's location.

-Original Message-
Thomas F
Sent: 15 November 2001 14:11
To: Multiple recipients of list ORACLE-L


All,

Interesting comments regarding OS selection.  Of course, this has been
covered in the past at great length.

Let me add my 2 cents.

NT is a very viable option if it is being administered by a competent NT
Admin who does not treat the box like a home desktop.

I have been working on NT boxes for two years now, and have seen the worst
and best it has to offer.  The worst is when it is not respected as a true
operating system.  The best is when it is managed carefully and with great
fore-thought.

I have not experienced *any* of the comments made in this thread - like
rebooting every so often.  I have very stable, powerfull machines that are
being managed by the best NT admins I have every seen, and they are
performing very nicely, thank you.

In my opinion, they are a viable platform solution.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, November 15, 2001 8:53 AM
To: Multiple recipients of list ORACLE-L


I guess that on Intel platform you don't have other choice than Linux and
Oracle fo Linux.

Database on NT = highway to hell and you cruise at high speed

JP

On Thu 15. November 2001 13:40, you wrote:
> That leaves NT for shops that require customer support...
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>   -Original Message-
>   From:   Jan Pruner [SMTP:[EMAIL PROTECTED]]
>   Sent:   Thursday, November 15, 2001 7:55 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject:Re: Operating Systems
>
>   From our root:
>   Don't use Solaris on Intel.
>   It's very very unstable and doesn't support too much HW.
>
>   JP
--
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).
--
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: Mark Leith
  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: UNSU

RE: Mass Storage/Network Stuff

[Johnston, Tim]

Ed...

  Make sure you read the last couple lines of Dick's email carefully...  He
is absolutely correct...  There is a big difference between being certified
by Oracle and being certified by Oracle USING THE SUPPORTED CONFIGURATION...
This is a bit of a touchy subject for me since I had several go arounds with
a customer using NetApp recently...  When our PS folks arrived on site, the
database server was connected to the box over the LAN!  Performance was
horrible...  It took about two hours just to issue the CREATE DATABASE
statement...  The customers opinion was "The NetApp filer is supported by
Oracle...  You must be doing something wrong..."  We finally got it straight
a few days later and performance has been much better...  But, then we went
to install it into production...  The PS guys walked in and checked things
out...  It looked good...  This time they got the dedicated connectivity
correct and their sysadmins said we were all set...  They started the
install and again it was slow...  Come to find out that even though it was a
dedicated connection, they had it set at 10 Megabit!!!  Just some words of
warning to be careful...  Make sure you understand what exactly the
supported config is and spec it that way from day one...

Tim

-Original Message-
Sent: Thursday, November 15, 2001 8:58 AM
To: Multiple recipients of list ORACLE-L

Ed,

The answer is yes and no, or more accurately it depends.  First off
there
are only two storage vendors, to my knowledge, certified by Oracle for this.

They are Net Appliance and EMC.  The reason is that they have software and
hardware that 'guarantees' to get the data from the buffers to the drives. 
Secondly you need absolutely dedicated TCP/IP connectivity between the
computer
and the storage array.  Look at it as replacing scsi adapters and cables
with
network cards and cables.

Dick Goulet

Reply Separator
Author: "Ed" <[EMAIL PROTECTED]>
Date:   11/14/2001 4:36 PM

Are there any problems running Oracle on one box, and pointing the database
files to a mass storage network device (ie. a disk array or some external
storage solution).  In other words, will Oracle run using network
addressable storage?  I'm assuming this is not a difficult thing to do, but
I would love to hear some war stories.

Any configuration or specific recommendations on how to do this?  Unix/NT an
issue?

Best,

Ed


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

Parsing free-form text for InterMedia indexing

[Jesse, Rich]

Hi all,

I've been struggling with trying to provide our users with a quick text
search.  InterMedia's doing OK, but I'm having trouble setting it up because
the text I'm searching is free-form data entered by several users over the
span of years.  In other words, it's a word-jumble.

For example, one indexed string might contain "25 PIN", while another
contains "25PIN", but I need to make sure that both come up in a query
without needing the user to know to enter for multiple scenarios.  How can
that be indexed in IM?  I think I want to have digits as separators, but not
in words that are only digits, e.g. I don't want "123456" to be indexed as
"1", "2", "3", "4", "5", "6".

I'm also having other problems with volumninous printjoins, but I'll tackle
one problem at a time.  :)

Thx!

Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-- 
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: Need help rewriting SQL with TRUNC function

[Jan Pruner]

The same song

my_interval VARCHAR(1) := 7;
my_limit_dateDATE;

begin 
...
select (TRUNC(sysdate)-TO_NUMBER(my_interval)+1) into my_limit_date from dual;
...
sql_stmt := 'SELECT * FROM my_table WHERE  :1 AND erh.arrival_dt < :2 
AND... ';

EXECUTE IMMEDIATE sql_stmt USING my_first, my_limit_date ... ;


JP

On Thu 15. November 2001 17:24, [EMAIL PROTECTED] wrote:
> Jan,
>
> Thanks for this reply.  What I forgot to mention is that this 7 is a
> literal
> that I substituted for a bind variable :b2.
>
> Sorry about leaving out that critical piece of information.
>
> Cherie
>
>
>
> Jan Pruner
> <[EMAIL PROTECTED]   To: [EMAIL PROTECTED]
>
> >cc: [EMAIL PROTECTED]
>
>  Subject: Re: Need help
> rewriting SQL with TRUNC function 11/15/01 10:13
> AM
> Please respond
> to jan
>
>
>
>
>
>
> Hmm,
>
> my_limit_dateDATE   := trunc(sysdate) - 6; -- !!! only 6
>
> erh.arrival_dt < my_limit_date
>
>
> JP
>
> On Thu 15. November 2001 16:00, you wrote:
> > I think that the following statement is keeping this application from
>
> using
>
> > an index in my cost-based execution plan.  This is an 8.0.4 database so I
> > don't have the option of creating a function-based index.
> >
> > I'm not that great with SQL.  Can anyone help me rewrite this statement
>
> so
>
> > that I don't need to use the TRUNC function on this column in blue?
> >
> >   (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND
> >
> > Thanks,
> >
> > Cherie Machler
> > Oracle DBA
> > Gelco Information Network
-- 
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).

how know solaris bit

[Seema Singh]

Hi
How we know the OS is 32 bit or 64 bit on SOlaris?
Thanks
-Seema

_
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: Seema Singh
  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: hide password

[Connor McDonald]

#!/bin/ksh

print "the_password" | exp userid=blah 

hth
connor

 --- "Tirumala, Surendra"
<[EMAIL PROTECTED]> wrote: > Jack, 
> I think you are referring to PARFILE...
> 
> 
> Suren
> 
> 
> -Original Message-
> Sent: Thursday, November 15, 2001 8:36 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi,
> 
> 
> Use a controlfile.
> 
> 
> Jack
> 
> 
> 
> 
> "Tatireddy, Shrinivas (MED, Keane)"
> <[EMAIL PROTECTED]>
> @fatcity.com on 15-11-2001 14:10:26
> 
> Please respond to [EMAIL PROTECTED]
> 
> Sent by:  [EMAIL PROTECTED]
> 
> 
> To:   Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:(bcc: Jack van
> Zanen/nlzanen1/External/MEY/NL)
> 
> Hi lists,
> 
> We can see users password using
> 
> ps -ef |grep  sqlplus
> 
> (if we run a job using sqlplus scott/tiger
> @${runfile}  ).
> 
> To prevent this we can run our code
> 
> sqlplus -s < scott/tiger
> @${runfile}
> EOF
> 
> Is there a similar way in export hiding the password
> (preventing users
> to see the password) . I tried it with EOF. But its
> not working.
> 
> I need to setup the export in cron.
> 
> can anybody through some light on this.
> 
> Thnx and regards,
> Srinivas
> 
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
>   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).
> 
> 
> 
> 
>
=
> De informatie verzonden in dit e-mailbericht is
> vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde.
> Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking
> van deze informatie aan
> derden is, behoudens voorafgaande schriftelijke
> toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in
> voor de juiste en
> volledige overbrenging van de inhoud van een
> verzonden e-mailbericht, noch
> voor tijdige ontvangst daarvan. Ernst & Young kan
> niet garanderen dat een
> verzonden e-mailbericht vrij is van virussen, noch
> dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst
> van onbevoegde derden.
> 
> Indien bovenstaand e-mailbericht niet aan u is
> gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te
> retourneren aan de verzender
> en het origineel en eventuele kopieën te verwijderen
> en te vernietigen.
> 
> Ernst & Young hanteert bij de uitoefening van haar
> werkzaamheden algemene
> voorwaarden, waarin een beperking van
> aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos
> toegezonden.
>
=
> The information contained in this communication is
> confidential and is
> intended solely for the use of the individual or
> entity to whom it is
> addressed. You should not copy, disclose or
> distribute this communication
> without the authority of Ernst & Young. Ernst &
> Young is neither liable for
> the proper and complete transmission of the
> information contained in this
> communication nor for any delay in its receipt.
> Ernst & Young does not
> guarantee that the integrity of this communication
> has been maintained nor
> that the communication is free of viruses,
> interceptions or interference.
> 
> If you are not the intended recipient of this
> communication please return
> the communication to the sender and delete and
> destroy all copies.
> 
> In carrying out its engagements, Ernst & Young
> applies general terms and
> conditions, which contain a clause that limits its
> liability. A copy of
> these terms and conditions is available on request
> free of charge.
>
=
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / 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 ORA

Re: Need help rewriting SQL with TRUNC function

[sfaroult]

>
>I think that the following statement is keeping this application from using
>an index in my cost-based execution plan.  This is an 8.0.4 database so I
>don't have the option of creating a function-based index.
>
>I'm not that great with SQL.  Can anyone help me rewrite this statement so
>that I don't need to use the TRUNC function on this column in blue?
>
>  (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND
>
>Thanks,
>
>Cherie Machler
>Oracle DBA
>Gelco Information Network
>

erh.arrival_dt <= trunc(sysdate) - 7 should give exactly the same result, even without 
the second trunc().
Try a count(*) with both versions if you have any doubt.


--
Diese E-Mail wurde mit http://www.mail-inspector.de verschickt
Mail Inspector ist ein kostenloser Service von http://www.is-fun.net
Der Absender dieser E-Mail hatte die IP: 194.51.96.14

-- 
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: Move data from Oracle into Access

[Rachel Carmichael]

do you have an odbc connection?  you can select directly from oracle
into the ms access table.


--- "Daiminger, Helmut" <[EMAIL PROTECTED]> wrote:
> Hi!
> 
> What would be the easiest way to dump out an Oracle table and move it
> into
> Access? (approx. 100,000 rows) No flaming, please... ;)
> 
> I assume that there is no tool for Access to read Oracle dmp-files,
> right?
> 
> Is spooling it out into an ASCII file (blanks or comma-seperated) the
> only
> way? I just need a single table (no refs or the like).
> 
> Any ideas?
> 
> This is 8.1.7 on Solaris.
> 
> Thanks,
> Helmut
> 
> 
> 


__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.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: Operating Systems

[Johnston, Tim]

Well...  I figured I'd put my $0.02 in...  I have had some exposure to NT...
As a matter of fact, I did Oracle on NT at a dot com for about a year...
And to tell you the truth, I hated it...  But, I really gave it a honest
chance...  The first couple of places where I had NT exposure were Unix
shops...  There was an intense dislike of NT because it was not Unix...
But, when I went to the dot com, it was an NT only shop...  We discussed
moving to Unix for the DB server at a future date but it NT to start...  So,
I worked with it...  I surfed the web looking for tips and tricks... And you
want to know why I hate it?  I hate it for the exact reasons you guys say it
can work well...  I agree, with competent NT admins and intelligent choices
about what gets installed, NT can be a viable database OS...  But, that is
the exact problem...  I have yet to find a company that views NT as an
operating system that needs "careful management"...  Everywhere I have been,
the NT management has been done by either desktop support people or totally
unqualified admins...  They never want to "solve" the problem...  They just
want to reboot...  Until companies put the same kind of support into NT that
they put into their Unix systems, this will be the case...  Ditto for the
hardware...  Getting the average NT admin to investigate a hardware issue is
like pulling teeth...

Tim

PS - I also hated the limitations of the scripting...  I was not allowed to
install any third party apps on the production server...  Which meant I had
to do everything with .bat files and the at scheduler...  I made it work...
But it is definitely not fun...

-Original Message-
Sent: Thursday, November 15, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L


At last! Somebody who speaks my language!

The biggest problem I have found with NT is when people insist on adding
this and that and that over there, add this piece of software that
overwrites this .dll but hasn't been properly tested.. Poor drivers etc..

Grab an Intel system, fresh off the press.. Install Oracle, set up your
network card, set up your database, set up security, open to the network -
LEAVE IT ALONE.. you got yourself a pretty damn stable system..

We have a Win2K system here that is used for file storage.. It has two HDs,
one with the OS, the other with all files & backups shared across a network.
I have NEVER had to reboot this system! Oh sorry I did ONCE when I had to
move it's location.

-Original Message-
Thomas F
Sent: 15 November 2001 14:11
To: Multiple recipients of list ORACLE-L


All,

Interesting comments regarding OS selection.  Of course, this has been
covered in the past at great length.

Let me add my 2 cents.

NT is a very viable option if it is being administered by a competent NT
Admin who does not treat the box like a home desktop.

I have been working on NT boxes for two years now, and have seen the worst
and best it has to offer.  The worst is when it is not respected as a true
operating system.  The best is when it is managed carefully and with great
fore-thought.

I have not experienced *any* of the comments made in this thread - like
rebooting every so often.  I have very stable, powerfull machines that are
being managed by the best NT admins I have every seen, and they are
performing very nicely, thank you.

In my opinion, they are a viable platform solution.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, November 15, 2001 8:53 AM
To: Multiple recipients of list ORACLE-L


I guess that on Intel platform you don't have other choice than Linux and
Oracle fo Linux.

Database on NT = highway to hell and you cruise at high speed

JP

On Thu 15. November 2001 13:40, you wrote:
> That leaves NT for shops that require customer support...
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>   -Original Message-
>   From:   Jan Pruner [SMTP:[EMAIL PROTECTED]]
>   Sent:   Thursday, November 15, 2001 7:55 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject:Re: Operating Systems
>
>   From our root:
>   Don't use Solaris on Intel.
>   It's very very unstable and doesn't support too much HW.
>
>   JP
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thoma

test

[Jeffrey Beckstrom]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeffrey Beckstrom
  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: ORAxxxx & trace files.

[Rachel Carmichael]

not that I know of... we have a script that runs in cron every 15
minutes and looks for certain words, it's unix, is that usable?


--- Mark Leith <[EMAIL PROTECTED]> wrote:
> Hi list,
> 
> Does anybody have a good list of all the ORA errors that will cause a
> trace
> file to be generated? We have a user of our tools that wants to
> monitor for
> any trace files/dumps being generated. I can think of two ways:
> 
> 1) monitor the alert log as above for specific errors
> 2) monitor the directories that these are generated in (bdump/cdump
> etc.)
> for any new files generated in the timeframe..
> 
> Anybody already doing this - or have any scripts to save me
> re-inventing the
> wheel?
> 
> Cheers
> 
> Mark
> 
> ===
>  Mark Leith | T: +44 (0)1905 330 281
>  Sales & Marketing  | F: +44 (0)870 127 5283
>  Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
> ===
>http://www.cool-tools.co.uk
>Maximising throughput & performance
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mark Leith
>   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!?
Find the one for you at Yahoo! Personals
http://personals.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: DBA CHECKLIST

[Rachel Carmichael]

Openworld 2000, Greg Loughmiller and I did a presentation
"Congratulations, You're the New DBA, Don't Panic", it's out on the
NYOUG website

under the December 2000 presentations -- paper and slides, there's a
section on daily/weekly/etc procedures

--- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote:
> Grace,
> 
> Free sources:
> =
> www.orapub.com  
> Technical Papers section 
> #115 Oracle DBA Checklist
> 
> Thomas B. Cox wrote a paper called "Database Administration Mautrity
> Model".
> This is IMHO rleated to DBA checklists.  I have version 1.1 but only
> as
> hardcopy.  It does not appear to be accessible now from his homepage
> at
> Geocites.  Maybe someone else on the list can help you with this.
> 
> Cost sources:
> =
> "Oracle DBA Checklists", published by O'Reilly ISBN: 0-596-00122-3
> 
> "Oracle DBA 101" ISBN: 0-072-121203 has a chapter "What we do daily"
> 
> -
> Sean O' Neill
> Organon (Ireland) Ltd.
> [subscribed: digest mode] 
> 
> >> From: "grace" <[EMAIL PROTECTED]>
> >> Date: Thu, 15 Nov 2001 12:34:08 +0800
> >> Subject: DBA CHECKLIST
> >>
> >>hi,
> >>
> >>is there a dba checklist to know a dba does?
> >>
> >>Best regards,
> >>
> >>Grace Lim
> >>Suy Sing Comm'l Corp.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: O'Neill, Sean
>   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!?
Find the one for you at Yahoo! Personals
http://personals.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: Oracle Expert and FK indexes

[Connor McDonald]

If you are not making changes to the parent in the
relationship, then the indexes are not needed (at
least for locking concerns).

hth
connor

 --- "Boivin, Patrice J" <[EMAIL PROTECTED]>
wrote: > Does someone know why the Oracle Expert would
> recommend dropping indexes on
> FK columns?
> 
> Maybe it calculates there is a low likelihood of the
> table being locked
> during referential integrity checks ?
> 
> I thought it was a good idea to have indexes on FK
> columns... this is an old
> 7.3.4.5. database.
> 
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Boivin, Patrice J
>   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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
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?Connor=20McDonald?=
  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 help rewriting SQL with TRUNC function

[Connor McDonald]

(trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 

becomes

- trunc(erh.arrival_dt) >= 7 - trunc(sysdate)

becomes by negating

trunc(erh.arrival_dt) <= trunc(sysdate) - 7

becomes

erh.arrival_dt <= trunc(sysdate) - 7 + 0.9

hth
connor

 --- [EMAIL PROTECTED] wrote: > 
> I think that the following statement is keeping this
> application from using
> an index in my cost-based execution plan.  This is
> an 8.0.4 database so I
> don't have the option of creating a function-based
> index.
> 
> I'm not that great with SQL.  Can anyone help me
> rewrite this statement so
> that I don't need to use the TRUNC function on this
> column in blue?
> 
>   (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND
> 
> Thanks,
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> -- 
> 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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
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?Connor=20McDonald?=
  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 help rewriting SQL with TRUNC function

[Mercadante, Thomas F]

Cherie,

Change the clause as follows

orig ==>   (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND

new ==>  erh.arrival_dt <= sysdate - 7  AND

Hope this helps!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, November 15, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L



I think that the following statement is keeping this application from using
an index in my cost-based execution plan.  This is an 8.0.4 database so I
don't have the option of creating a function-based index.

I'm not that great with SQL.  Can anyone help me rewrite this statement so
that I don't need to use the TRUNC function on this column in blue?

  (trunc(sysdate) - trunc(erh.arrival_dt)) >= 7 AND

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
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: 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: Move data from Oracle into Access

[Scott Shafer]

The simplified version:
Connect access to oracle using ODBC and select from the oracle tables
into access tables.

--Scott


> "Daiminger, Helmut" wrote:
> 
> Hi!
> 
> What would be the easiest way to dump out an Oracle table and move it
> into Access? (approx. 100,000 rows) No flaming, please... ;)
> 
> I assume that there is no tool for Access to read Oracle dmp-files,
> right?
> 
> Is spooling it out into an ASCII file (blanks or comma-seperated) the
> only way? I just need a single table (no refs or the like).
> 
> Any ideas?
> 
> This is 8.1.7 on Solaris.
> 
> Thanks,
> Helmut

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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: hide password

[Mohammad Rafiq]

exp parfile=parfile.par

Example of parfile
parfile.par


userid=user/password
tables=(STL_T_TICKET_HIST_199906)
log=/u8/oracle/dba/fullexp/log/STL_T_MTL_TRANS_ACCTS_199906
file=/u227t/oracle/OPRO4/exp/STL_T_TICKET_HIST_199906
#file=/u227t/oracle/OPRO4/exp/exp.dmp
#recordlength=65536
direct=y
compress=N

Hope this helps

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 15 Nov 2001 06:19:22 -0800

Can you explain in detail how to use a controlfile in exports?

thnx and regards,
Srinvias
-Original Message-
Sent: Thursday, November 15, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L



Hi,


Use a controlfile.


Jack




"Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]>
@fatcity.com on 15-11-2001 14:10:26

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Hi lists,

We can see users password using

ps -ef |grep  sqlplus

(if we run a job using sqlplus scott/tiger @${runfile}  ).

To prevent this we can run our code

sqlplus -s 

Re: Mass Storage/Network Stuff

[Ed]

Tim,

Definitely.  We're just researching options right now.  I was
certain we'd end up with something working over a fiber card
or 1000 Megabit NIC of some kind.

Thanks,

Ed

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 10:50 AM


> Ed...
>
>   Make sure you read the last couple lines of Dick's email carefully...
He
> is absolutely correct...  There is a big difference between being
certified
> by Oracle and being certified by Oracle USING THE SUPPORTED
CONFIGURATION...

[SNIP]
>
> Tim
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed
  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: Failures in creating Oracle database file.

[Jesse W. Asher]

Thanks for all the replies - I'm not ignoring them.  I'm doing some 
testing now to see what is going on.  I'm trying out Oracle 9i since it 
appears that this may be related to how Oracle was compiled and an 
innate limitation to Oracle in this case.  I should know today if this 
is the case and will let everyone know

Tirumala, Surendra wrote:

>In one of my previous assignments, even if my ulimit was unlimited, I could
>not create datafiles bigger than 2 GB,
>The OS was Sun Solaris 2.6. So best thing is to test what Kirti suggested.
> 
>Thanks,
>Suren
>
>-Original Message-
>Sent: Wednesday, November 14, 2001 12:25 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>I checked the ulimit and it is set to "unlimited" so I don't think that is
>the problem.  I think it is a little more insidious than that
>
>Deshpande, Kirti wrote:
>
>
>Sounds like a large file can not be created in the file system (the large
>file option at FS level?) or your 'ulimit' is not set large enough to handle
>large sized files. 
>
>- Kirti 
>
>
>-Original Message-
>From:  Jesse W. Asher [ SMTP:[EMAIL PROTECTED]
> ]
>Sent:  Tuesday, November 13, 2001 9:35 PM
>To:Multiple recipients of list ORACLE-L
>Subject:   Failures in creating Oracle database file.
>
>  
>I'm attempting to create a 3GB file on an XFS filesystem using Oracle 8i
>running on RedHat 7.1 with a generic 2.4.10 kernel and I'm getting some
>errors.  Here's the command and output I'm getting: 
>
>CREATE TABLESPACE ALTUSER DATAFILE
>'/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE AUTOEXTEND ON
>NEXT 1280K 
>MINIMUM EXTENT 128K DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1
>MAXEXTENTS 4096 PCTINCREASE 0); 
>
>CREATE TABLESPACE ALTUSER DATAFILE
>'/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE 
>* 
>ORA-01119: error in creating database file
>'/export/4/oracle/oradata/alt/data01.dbf'
>
> 
>ORA-27037: unable to obtain file status 
>Linux Error: 75: Value too large for defined data type 
>
>= 
>
>Any ideas as to what could be causing this?  I thought the file size limit
>is 4GB which is why I made the file 3GB.  Is this correct or am I missing
>something??  Many thanks!! 
>  
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse W. Asher
  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: is there an archive for this mailing list...

[Jared . Still]

Yes,  you will have to register for it at:

http://www.fatcity.com/ListGuru/login.php


Jared



   
 
"grace"
 

e.net>   cc:   
 
Sent by: Subject: is there an archive for this 
mailing list...  
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
11/15/01 12:25 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




hi gurus
is there an archive for this mailing list? if yes , how can i access them

Best regards,

Grace Lim
Suy Sing Comm'l Corp.

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

accessing reports processed by the reports server

[Jeffrey Beckstrom]

We are a two node install of Oracle Apps 11i all on NT.  The question 
though is really with the reports server and the web server being on separate 
nodes.  We are an apps 11i two node install.
 
From the apps, we are able to submit a business intelligence report to the 
report server.  However, the browser never returns.  Continually tries 
to open a page forever.  Oracle's current thought is that since the web 
server and report server are on different nodes, the browser could not access 
it.  Therefore, changed the mapping for the apps "cache" to point to the 
database server and run apache as a user.  If enter the URL directly of 
where the report is in the database server's file system cache, can now view 
it.  However, the apps still hangs.  If try to access the report from 
the "showjobs" screen, it hangs as well.  Almost like web server asking the 
report server for the report but never gets a response??  
 
This has been going on for a few weeks now and getting no where.  Any 
help greatly appreciated.
 
 
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

RE: Disk Layout Document

[Jesse, Rich]

After many DB copies, loads, reloads, upgrades, etc., I've decided that the
22-disk layout just doesn't work for us.  With only two 4-way stripe sets,
we get vastly superior I/O thruput that more than compensates for any
contention on any of the stripes.

Yes, yes, I understand that with mirroring the total drive count is 16.  But
since this is only a volatile test system there's no need for mirroring,
archiving, or duplexing for recovery.  With another stripe/mirror (RAID 10
or 0+1 -- no need to get back to that discussion) of 6 or 8 drives total for
the archiving and maybe a duplexed controlfile, I still say that setup will
smoke an Oracle-sanctioned Kevin Loney 22-disk layout.  At least it does for
our DB and environment.

Think about it:  If a single drive housing a single datafile can pop 100-200
I/Os/sec, that same datafile on a 4-way stripe can hit in the thousands
(w/caching and tuning).  Of course, mutiply this by several datafiles,
redos, controlfiles, and you've got a really fun physical layout project to
minimize contention at peak operating times.

Hey, it can't work for everyone.  But some may see the huge performance
advantage we've seen by using RAID instead of single drives for physical DB
layout.

Just my $.02

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


-Original Message-
Sent: Thursday, November 15, 2001 10:21
To: Multiple recipients of list ORACLE-L


Every time they ask for a new database I try that 22 disk thing
also.  I also settle for 6 mount points (not 6 disks).  Its still
fun to try though.  Especially when we hire new people.

-Original Message-
Sent: Wednesday, November 14, 2001 6:45 PM
To: Multiple recipients of list ORACLE-L


the very first time I ever saw Kevin present, he was talking about
that. I went out and bought the DBA Handbook and came home to the
operations people saying "I need 22 disks"

when they picked themselves up off the floor I said "okay, I can get
away with 17"

again, I waited until they stopped laughing and said "can I get 9?"

I settled for 6


then I kept reading the book and emailing kevin with the typos I would
find. And that dear ones, is how Kevin Loney and I met and became
friends.

He got his revenge for my bothering him though -- he got me to
co-author a book :)

Rachel

--- Larry Elkins <[EMAIL PROTECTED]> wrote:
> Bingo! Chapter 4. I knew I had read the variations somewhere. 
> 
> Thanks for the assist. 
> 
> Regards,
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
> 214.954.1781
> 
> > -Original Message-
> > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 14, 2001 3:32 PM
> > To: '[EMAIL PROTECTED]'
> > Cc: '[EMAIL PROTECTED]'
> > Subject: RE: Disk Layout Document
> > 
> > 
> > I believe the Oracle DBA Handbook by Kevin Loney has that...
-- 
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).