date:20010710


Jared and Ron,

As Jared mentioned, dbv can incorrectly report corrupt
blocks on an open datafile, although this is likely to
happen only if there is heavy write activity to the
datafile and dbv scans a block as it is being written.
 In which case scanning the file when the db is closed
or copying the datafile before scanning it should
work.

The pages listed by dbv are eqivalent to the blocks
in the datafile, so if dbv reports page 12345 is
corrupt, then that's the same as block 12345.  

Dbv scans *all* blocks in the datafile, not just those
belonging to objects.  Versions 8.1.6+ will report
Found block already marked corrupted if the block
doesn't belong to an existing object.  These blocks
will also not be counted in the stats for the file. 
These corruptions can be safely ignored as the corrupt
block will be reformatted when it is allocated to an
extent.

In any case, you can identify the object to which the
corrupt block belongs (if it's currently allocated to
an object) using the following query:

SELECT tablespace_name, segment_type, owner,
segment_name
 FROM dba_extents
 WHERE file_id = file#
 and block# between block_id AND block_id + blocks -
1;

Where file# is the absolute file # (e.g. from
V$DBFILE) and block# is the page# reported corrupt.

If only the DBA is given then, as someone else
mentioned, used note: 113005.1 to convert the DBA to a
file and block #.

I always recommend running dbv and ATVSC (analyze
table validate structure cascade) multiple times as
flaky hardware will often manifest itself as
intermittent block corruptions (i.e. if a block is
truly corrupt it should be reported as corrupt every
time it is checked).

HTH,

-- Anita

--- [EMAIL PROTECTED] wrote:
 
 
 Ron,
 
 Was the database open when you ran dbverify?
 
 If so, run it on the file again and see if it still
 reports corruption.
 
 I've done this a number of times on an open
 database. When
 a corruption was found, running dbverify a second
 time would
 show that the file was ok.
 
 The only sure way to run dbverify is on a closed
 database.
 
 Jared
 
 
 
 
 
 
 Smith, Ron 
 
 
 L.  To:
 Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]  
 [EMAIL PROTECTED]   cc:
 
 
 om  Subject:   
  Corrupt block in DBVERIFY  
 
 Sent by:
 
 
 [EMAIL PROTECTED]  
 
 
 om  
 
 
 
 
 
 
 
 
 07/09/01 09:51  
 
 
 AM  
 
 
 Please respond  
 
 
 to ORACLE-L 
 
 
 
 
 
 
 
 
 
 
 
 
 I have a corrupt block according to DBVERIFY.  The
 block is on an index so
 I
 can rebuild it but I don't know how to find the
 object with the information
 displayed in DBVERIFY.  Can anyone tell me how to
 find the object?
 
 Thanks!
 Ron
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Smith, Ron L.
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

Re: Corrupt block in DBVERIFY

2001-07-10 Thread Christian Trassens


The workaround that first comes to my mind is to take
all the objects of that tablespace and do an analyze
.validate structure. Take into account that the
validate structure clause locks the object. This could
be a script for that:

set pagesi 0
set feedba off
spool validate.sql
select 'analyze '||segment_type||'
'||owner||'.'||segment_name||' validate structure;'
from sys.dba_segments where
tablespace=upper('tbsp.');
spool off
set feedba on
set echo on
set pagesi 25
spool validate.out
@validate.sql
spool off

You could improve it changing the query from
dba_segments. That it is an slowly view.

Regards.-
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
 I have a corrupt block according to DBVERIFY.  The
 block is on an index so I
 can rebuild it but I don't know how to find the
 object with the information
 displayed in DBVERIFY.  Can anyone tell me how to
 find the object?
 
 Thanks!
 Ron
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Smith, Ron L.
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: [EMAIL PROTECTED]

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

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

81714 aborted upgrade and core dumps on NT

2001-07-10 Thread Reardon, Bruce (CALBBAY)


Hi,
I have just had the experience of upgrading to 81714, discovering a problem
in our application that did not show up in any testing and having to go back
to 815.

The 815 instance is on a different server to the 817 instance and we still
have the 817 instance available for further troubleshooting.

This is on NT4.

With 817, we were getting ora-3113 in the forms application and in ODBC
connections and also seeing ora-03121 as well.

We got core dump files produced (under 817 they are produced on NT) but
Oracle support does not seem to know how to interpret them on NT - has
anyone had any experience with this?

No mention of the core dump file was contained within the alert log and no
files were produced in the user dump directory.

When I turned sql trace on for the session running forms, the ora-3113 did
not occur - has anyone seen behaviour like this where SQL Trace will cause
an ora-3113 to stop occurring?

All suggestions on what to look for or how to interpret NT core dumps are
welcome.

Thanks,
Bruce Reardon
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

arrays in PL/SQL

2001-07-10 Thread John Dunn


I want to create arrays of a user defined record in PL/SQL

Do I need nested tables/varrays and therefore the Object option : do I need
Enterprise

Version is 8.1.7

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

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

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


Jared and Ron,

As Jared mentioned, dbv can incorrectly report corrupt
blocks on an open datafile, although this is likely to
happen only if there is heavy write activity to the
datafile and dbv scans a block as it is being written.
 In which case scanning the file when the db is closed
or copying the datafile before scanning it should
work.

The pages listed by dbv are eqivalent to the blocks
in the datafile, so if dbv reports page 12345 is
corrupt, then that's the same as block 12345.  

Dbv scans *all* blocks in the datafile, not just those
belonging to objects.  Versions 8.1.6+ will report
Found block already marked corrupted if the block
doesn't belong to an existing object.  These blocks
will also not be counted in the stats for the file. 
These corruptions can be safely ignored as the corrupt
block will be reformatted when it is allocated to an
extent.

In any case, you can identify the object to which the
corrupt block belongs (if it's currently allocated to
an object) using the following query:

SELECT tablespace_name, segment_type, owner,
segment_name
 FROM dba_extents
 WHERE file_id = file#
 and block# between block_id AND block_id + blocks -
1;

Where file# is the absolute file # (e.g. from
V$DBFILE) and block# is the page# reported corrupt.

If only the DBA is given then, as someone else
mentioned, used note: 113005.1 to convert the DBA to a
file and block #.

I always recommend running dbv and ATVSC (analyze
table validate structure cascade) multiple times as
flaky hardware will often manifest itself as
intermittent block corruptions (i.e. if a block is
truly corrupt it should be reported as corrupt every
time it is checked).

HTH,

-- Anita

--- [EMAIL PROTECTED] wrote:
 
 
 Ron,
 
 Was the database open when you ran dbverify?
 
 If so, run it on the file again and see if it still
 reports corruption.
 
 I've done this a number of times on an open
 database. When
 a corruption was found, running dbverify a second
 time would
 show that the file was ok.
 
 The only sure way to run dbverify is on a closed
 database.
 
 Jared
 
 
 
 
 
 
 Smith, Ron 
 
 
 L.  To:
 Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]  
 [EMAIL PROTECTED]   cc:
 
 
 om  Subject:   
  Corrupt block in DBVERIFY  
 
 Sent by:
 
 
 [EMAIL PROTECTED]  
 
 
 om  
 
 
 
 
 
 
 
 
 07/09/01 09:51  
 
 
 AM  
 
 
 Please respond  
 
 
 to ORACLE-L 
 
 
 
 
 
 
 
 
 
 
 
 
 I have a corrupt block according to DBVERIFY.  The
 block is on an index so
 I
 can rebuild it but I don't know how to find the
 object with the information
 displayed in DBVERIFY.  Can anyone tell me how to
 find the object?
 
 Thanks!
 Ron
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Smith, Ron L.
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

Re: [Fwd: Importing data from dump exported with different character set]


Brijesh,

The actual error number(s) would be more helpful ;)

There are issues with exp/imp between single-byte and
multi-byte character sets.

Did you do a conventional or direct-path export?

What are the OS's for the export and import db's?

Have you tried explicitly setting env variable
NLS_LANG to language_territory.UTF8 prior to
importing?

HTH,

-- Anita
--- David A. Barbour [EMAIL PROTECTED] wrote:
 
 
 Brijesh Lal wrote:
  
  Hi
  
  The oracle version I am using is 8.15 and I am
  exporting the data into 8.1.6. When I try to
 import
  the data I get error that cannot that data cannot
 be
  imported as it is exported from database with
 USASCII7
  and being impored into UTF8 format.
  
  Brijesh
  --- David A. Barbour [EMAIL PROTECTED]
 wrote:
   Brijesh,
  
   What are the Oracle versions you're exporting
 from
   and import into?
   UTF8 is a superset of US7ASCII, so you shouldn't
 be
   having problems.
   What error are you receiving?  If you can't get
 it
   to work, can you redo
   the export?  There are several ways to change
   character sets, which are
   documented on OTN and Metalink.  Most involve
   changing the NLS_LANG for
   the session (import or export) but there was an
   interesting piece on
   editing the export file to change the reported
   character set last month
   on the list.  Go to:
  
  
 

http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400274
  
   for a précis on the procedure, and check out the
   various Metalink
   references.  If you're going to edit the export
   file, you MUST use a
   binary editor.
  
   Brijesh Lal wrote:
   
Hi All
   
I have been given the task to export the data
 from
   the
database which has the character set of
 USASCII7
   and
import it into Databse with UTF8 character.
   However
when I try to this the import fails with
 error. I
   also
searched oracle mannual but was unable to find
 any
relevant information. Can anyone please tell
 me
   how to
accomplish this task
   
Thanks and Regards
   
Brijesh
   
   
 __
Do You Yahoo!?
Get personalized email addresses from Yahoo!
 Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ:
   http://www.orafaq.com
--
Author: Brijesh Lal
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- (858) 538-5051
   FAX: (858) 538-5051
San Diego, California-- Public
 Internet
   access / Mailing Lists
   
  
 


To REMOVE yourself from this mailing list,
 send an
   E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling
 of
   'ListGuru') and in
the message BODY, include a line containing:
 UNSUB
   ORACLE-L
(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: David A. Barbour
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051 
 FAX:
   (858) 538-5051
   San Diego, California-- Public Internet
   access / Mailing Lists
  
 


   To REMOVE yourself from this mailing list, send
 an
   E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
   'ListGuru') and in
   the message BODY, include a line containing:
 UNSUB
   ORACLE-L
   (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 personalized email addresses from Yahoo! Mail
  http://personal.mail.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: David A. Barbour
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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 personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

RE: UNIX SA

2001-07-10 Thread Guy Hammond

Title: OT: UNIX SA



The 
Solaris FAQ:

http://www.science.uva.nl/pub/solaris/solaris2.html

Sun's 
own documentation, all available online for free (in PDF 
too):

http://docs.sun.com/

The 
"Ferrari book" is excellent, even tho' that's actually a Porsche on the 
cover:

http://www.amazon.com/exec/obidos/ASIN/0130952494/qid=994751878/sr=1-3/ref=sc_b_3/103-7758889-6011002

And 
for the truly hard of core, Solaris Internals:

http://www.amazon.com/exec/obidos/ASIN/0130224960/ref=lm_lb_3/103-7758889-6011002

HTH,

g


  -Original Message-From: Andrey Bronfin 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 09, 2001 4:55 
  PMTo: Multiple recipients of list ORACLE-LSubject: OT: 
  UNIX SA
  Dear list ! I'd 
  like to start getting into some beginner level UNIX (Solaris) system 
  administration . I have some knowledge in 
  UNIX (scripting, basic commands , etc ... - user/programmer/DBA level , 
  not a sys. admin. level).
  Can U please recommend what to start with ? 
  I prefer free resources on the web over the books 
  i'll have to buy, off course. Thanks a lot 
  for your recommendations. Andrey.

Re: How to execute Unix Command/program within a pl/sql block.

2001-07-10 Thread MHately




Hi,
you can't do this from PL/SQL but you can do it from Java and it's fairly easy
too.  I'm not able to check the name of the class tht does it but armed with the
phrase java os command and either the Metalink or Ask Tom web site you
should be able to track it down.

Regards,
Mike



|+---
||  Stephane |
||  Faroult  |
||  sfaroult@ori|
||  ole.com |
||   |
||  07/10/01 |
||  12:20 AM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+---
  |
  ||
  |   To: Multiple recipients of list  |
  |   ORACLE-L [EMAIL PROTECTED]  |
  |   cc: (bcc: Mike Hately/ETECH) |
  |   Subject: Re: How to execute Unix |
  |   Command/program within a pl/sql block.   |
  |




Seema Singh wrote:

 Hi
 How to execute unix command in PL/SQL ?
 Thanks in advance.
 -Seema

You can't. The nearest you can get is to write a daemon program which
waits for commands on a (dbms) pipe, executes them (popen(),
while(fgets()) {}, pclose() in C) and feeds the output back to the pipe.
Needless to say, it can be a serious security gap if you do not screen
the commands, since you are likely to execute them with the privileges
of the user under which the said program is run.
Many moons ago, there used to be something named 'flex' developed by
Oracle consultants and freely available on the web which was more or
less doing that. It may or may not still be around. I have had a look at
it after having developed my own (in Pro*Fortran and under VMS, nothing
stops me - no pipe, but a /OUTPUT=... was appended to the command and I
was reading and sending back the ouput file) and I can tell you that
Flex was unnecessarily complicated. To make simple seems very difficult
to many people.

--
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269
Fax:+44  (0) 7050-696-449
Performance Tools  Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

Trigger help

2001-07-10 Thread Ranganath K


Dear DBA Gurus,

I have a table with two fields name and status.  What I want to do is once
the current system date rolls over from 30th to 31st the status should be
entered as closed other wise from 1st to 30th the status should be entered
as open.  How do I do this using trigger or any dbms packages?  Any help in
this regard will be very much appreciated.

TIA and Regards,

Ranganath


DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions expressed
are solely those of the author and do not represent those of Subex Systems
Limited.


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

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

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

table aliases save time when parsing??

2001-07-10 Thread novicedba




Hi,
 was reading CorrelatedSubqueries.pdf 
from oriolecorp.
In fact it's good programming 
practice to use aliases in every situation where more than one table is referred 
to in a statement, since it saves time when parsing.

Can some one please explain how it 
helps?

cozI am anoviceOracle Certifiable 
DBBS

Re: 81714 aborted upgrade and core dumps on NT


Bruce,

Core dumps are even more of a pain on NT since they
don't generate a helpful trace file as on other
platforms.  You should have a core.log file in one of
the dump directories (core_dump_dest didn't work on
NT, although I've heard it does on 8.1.7+, but haven't
tested it).

There should be a stack trace in it somewhere, but
that's about it.  If you're lucky, it will be unique
enough to help support identify an existing bug.

Yes, I have had cases where enabling tracing prevented
the error from occurring, thereby making it incredibly
difficult to resolve.

HTH,

-- Anita

--- Reardon, Bruce (CALBBAY)
[EMAIL PROTECTED] wrote:
 Hi,
 I have just had the experience of upgrading to
 81714, discovering a problem
 in our application that did not show up in any
 testing and having to go back
 to 815.
 
 The 815 instance is on a different server to the 817
 instance and we still
 have the 817 instance available for further
 troubleshooting.
 
 This is on NT4.
 
 With 817, we were getting ora-3113 in the forms
 application and in ODBC
 connections and also seeing ora-03121 as well.
 
 We got core dump files produced (under 817 they are
 produced on NT) but
 Oracle support does not seem to know how to
 interpret them on NT - has
 anyone had any experience with this?
 
 No mention of the core dump file was contained
 within the alert log and no
 files were produced in the user dump directory.
 
 When I turned sql trace on for the session running
 forms, the ora-3113 did
 not occur - has anyone seen behaviour like this
 where SQL Trace will cause
 an ora-3113 to stop occurring?
 
 All suggestions on what to look for or how to
 interpret NT core dumps are
 welcome.
 
 Thanks,
 Bruce Reardon
 [EMAIL PROTECTED]
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Reardon, Bruce (CALBBAY)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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 personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

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

2001-07-10 Thread Peter McLarty


Andrey 
If you have some spare PC hardware lying around then consider installing
a copy of Linux, purchase it or download it and burn your own distro.

Get that installed and running and then get something like Oracle running
on it set up and get apache running on it, Mysql and Postgress are others
that you might like to play around with. 
Start learning Perl compile and set up some tools you want to have
a look at. 
Install VNC on it and then be able to run X sessions on you PC with the
VNC client. maybe install the Java SDK and leverage some of that spare
time in discovering Java it really has a lot of uses and the skills won't
go astray especially as it is tied to Larry's future. Configure SAMBA and
use it as a file and print server, you have yourself you own NT server
:-) g
These are all everyday sorts of task that SA might have to consider and
do. Have a look at some security sites start with CERT or your local
associate site and learn the basics of securing a UNIX
server
If you want any other bright ideas you can contact me
offline. 
HTH 
Peter
10/07/2001, you wrote:
Hi,

Do you have any Unix SA
experience already? If not, maybe a general Unix SA book would be more
useful than specializing in Solaris straight away, O'Reilly publish
Unix for Oracle DBAs Pocket Reference and
Essential System Administration. I've only actually
read the latter, it is a good general overview and 
reference.

The reason I say this, is
because all Unixes are basically similar when it comes to configuration,
but vendors like to put their own tools on too, for example AIX has SMIT,
Sun have their admintool, etc. Best to learn the underlying structure so
you'll be at home on any system. Then learn the platform specific stuff.
Unix is quirky for example

in /etc/system, the comment character is *

in /etc/sendmail.cf the comment character is # 
in /etc/named.boot the comment character is ; 
in source code, the comment is /* */ (like in PL/SQL).
If you mark your comments in the wrong way in the wrong file, you might end up with a system that cannot even boot! (Offtopic: if you have been on this list for a while, you will know that I hate Unix, but know a lot about it. The two go together).

HTH,

g



-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 11:23 AM
To: Guy Hammond
Subject: RE: UNIX SA

Guy , thanks a lot !
Just another question :
what do U recommend to START with , for a beginner , like me .
Thanks in advance.
-Original Message-
From: Guy Hammond [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: UNIX SA

The Solaris FAQ:

http://www.science.uva.nl/pub/solaris/solaris2.html

Sun's own documentation, all available online for free (in PDF too):

http://docs.sun.com/

The Ferrari book is excellent, even tho' that's actually a Porsche on the cover:

http://www.amazon.com/exec/obidos/ASIN/0130952494/qid=994751878/sr=1-3/ref=sc_b_3/103-7758889-6011002

And for the truly hard of core, Solaris Internals:

http://www.amazon.com/exec/obidos/ASIN/0130224960/ref=lm_lb_3/103-7758889-6011002

HTH,

g

-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L
Subject: OT: UNIX SA

Dear list ! 
I'd like to start getting into some beginner level UNIX (Solaris) system administration . 
I have some knowledge in UNIX (scripting, basic commands , etc ... - user/programmer/DBA level , not a sys. admin. level).
Can U please recommend what to start with ? 
I prefer free resources on the web over the books i'll have to buy, off course. 
Thanks a lot for your recommendations. 
Andrey.

RE: arrays in PL/SQL

2001-07-10 Thread Yexley Robert D SSgt AFIT/SCA


No, you can use PL/SQL tables for that.  PL/SQL tables are the PL/SQL
equivalent of arrays in other languages (well, it's about as  close as
you're going to get anyway).

-Original Message-
Sent: Tuesday, July 10, 2001 4:41 AM
To: Multiple recipients of list ORACLE-L


I want to create arrays of a user defined record in PL/SQL

Do I need nested tables/varrays and therefore the Object option : do I need
Enterprise

Version is 8.1.7

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

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

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

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

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


Malini,

Personal Oracle is not designed for production use,
but for development use.  As such it doesn't allow
more than one session to connect via the listener (I
don't believe they've increased this limit with 8.x).

Olite will work with Personal Oracle, but it's not
very practical since you won't be able to have
multiple Olite sessions connecting.

Olite replication is limited to read-only and/or
updatable snapshots.  The Olite application must
determine how often refreshes are made when connecting
to the master site.

There used to be several .pdf files included on the
Olite CD that gave more detailed info on replication
with Olite.  You might also want to check the 8iLite
Discussion Forum on technet.oracle.com (free
registration).

HTH,

-- Anita


--- Malini Krishnamurthy
[EMAIL PROTECTED] wrote:
  Hi,
This is what my application is supposed to do...
 
  There has to be data synchronisation between
 Oracle 8Lite and Personal
  Oracle...
 Can this automatically happen?Does iConnect
 automatically do this???
  In the documentation on Oracle 8 Lite, there is no
 documentation as to
  whether it supports Personal Oracle (7.3 and
 above)!!!
  Pls help!
 
  thanks.
 
 
  The Information contained and transmitted by this
 E-MAIL is proprietary to 
 Wipro Limited and is intended for  use only by the
 individual or entity to which 
 it is addressed, and may contain information that is
 privileged, confidential or 
 exempt from disclosure under applicable law. If this
 is a forwarded message, 
 the content of this E-MAIL may not have been sent
 with the authority of the 
 Company. If you are not the intended recipient, an
 agent of the intended 
 recipient or a  person responsible for delivering
 the information to the named 
 recipient,  you are notified that any use,
 distribution, transmission, printing, 
 copying or dissemination of this information in any
 way or in any manner is 
 strictly prohibited. If you have received this
 communication in error, please 
 delete this mail  notify us immediately at
 [EMAIL PROTECTED] 
 
 


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

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

Date / Time

2001-07-10 Thread Sajid Iqbal


Hello All

I want to display the time elapsed between two dates - in days, hours,
minutes and seconds.

If I do select date1 - date2, the result is : 12.0194907

Is there a function that will turn the number of days into something more
legible?  Ideally i'd like to do ;

to_char(12.0194907,'DD:HH:MI:SS') but obviously that won't work.  Is
there a solution other than writing a complex function myself which will
have to * by 24, / by 60 and substr etc to get the different bits of the
number?

Please CC any replies directly to me at [EMAIL PROTECTED]

Thanks in advance,
Saj.



-- 
Sajid Iqbal
Database Team Leader



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

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

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

2001-07-10 Thread Koivu, Lisa

Title: RE: Sizing a new server





Bruce, 


It's going to be Unix, tru64. Unfortunately I will be stuck with some old hardware to start with - an Alpha, 8400, I believe maxes out at 8 cpu's, along with two old disk farms (compaq esa10k). I'm slapping together a bunch of old pieces of hardware, upgrading where needed, obtaining software licensing where needed, compaq hardware/software support, and with some duct tape, political brown-nosing done by others and a few users screaming for their data, I'll hopefully end up with some sort of reporting tool hitting this. (BizObj or Cogno$). Man Cognos is expensive. 

I wish I could choose AIX here. It's not an option. 


See doesn't this sound like a director's job??
Say it again: I LOVE MY JOB


Lisa


-Original Message-
From: Reardon, Bruce (CALBBAY) [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 8:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Sizing a new server


Lisa,


Some may laugh at the question but what OS - NT, Unix, VMS or ?


Regards,
Bruce Reardon
-Original Message-
Sent: Tuesday, 10 July 2001 4:36 
To: Multiple recipients of list ORACLE-L



Thanks Kimberly, 
I wish it was that way. I have to justify my request with hard numbers or
they are going to laugh at me when I say, Because that's what I want. :)
They don't yet know how I'd react to that, it would be a knee-jerk type of
reaction involving creative expletives... not pretty. 
Good for you. At least you have some real hardware and true HA. I wish I
did 
Lisa 



-Original Message- 
Sent: Monday, July 09, 2001 12:51 PM 
To: Multiple recipients of list ORACLE-L 
Get the biggest, kick ass server they will let you buy. If your site is
anything like mine they just keep asking for more and more databases. So no
matter what I have now I know its not enough. I am really happy with the
nice new N-class HP cluster I have sitting next door running Service Guard.
I am also getting a A-class database cluster for some important but not fab
critical databases. Now if I can only get ride of the 5 K-class database
servers. Its kind of like when you go from a fast to a slow PC. Drives me
crazy. Not that there are issues with performance from the databases. It
would only be me, while playing (which of course means working) on the
server, that would notice.
-Original Message-
Sent: Monday, July 09, 2001 8:30 AM
To: Multiple recipients of list ORACLE-L



Good morning everyone, 
Lucky me, I get to choose the size of the server this company should
consider purchasing. I have been poking around on the net for any
guidelines - I can make guesses based upon my gut feel and how strapped the
current unix server is, but I want to be able to back this up with hard
numbers. This is for a dw application.
Can anyone point me to a website, book, or anything in particular that can
help me justify sizing a machine? It's so fun working for a company that
doesn't have a sysadmin on staff... 
Thanks 
Lisa Koivu
Oracle Data Bored Administrator
Ft. Lauderdale, FL, USA
954-935-4117 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
 INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: gzip does not want to work with files 2G

2001-07-10 Thread Guy Hammond


Yup, it's cos you have the 32-bit version. There's a large files
version on http://sunfreeware.com/ if I remember correctly. 

HTH,

g


-Original Message-
Sent: Tuesday, July 10, 2001 12:12 AM
To: Multiple recipients of list ORACLE-L


I have Solaris 5.8 angzip does not want to work with files  2G - tells
that
file is too large. Anybody has any idea why?

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

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

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

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

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

2001-07-10 Thread Igor Neyman




Well, it's not aliases themselves, but the practice of using 
aliases as prefixes, when referring to columns:

SELECTt1.col1, t1.col2, t2.col1
FROM table1 t1, table2 t2
WHERE t1.col2 = t2.col2

that's what saves time when parsing: this way you tell the 
parser which table column list to look for,otherwise(when no 
prefixes used) ithasto search through all tables column lists for 
particular column definition (andalso to make sure, that this column name 
is unique in all column lists - if not you'll be getting an error, if not using 
prefixes).

But, you can get the same result (save time on parsing), when 
using table names as prefixes:


SELECTtable1.col1, table1.col2, table2.col1
FROM table1, table2
WHERE table1.col2 = table2.col2

It's just that aliases are usually short (while table names could be long), 
and it's easier to read the code.

List, please correct me, if I'm wrong.

Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED] 


  - Original Message - 
  From: 
  novicedba 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, July 10, 2001 7:10 
AM
  Subject: table aliases save time when 
  parsing??
  
  Hi,
   was reading 
  CorrelatedSubqueries.pdf from 
  oriolecorp.
  In fact it's good programming 
  practice to use aliases in every situation where more than one table is 
  referred to in a statement, since it saves time when parsing.
  
  Can some one please explain how it 
  helps?
  
  cozI am anoviceOracle Certifiable 
  DBBS

RE: UNIX SA


Thanks Guy, I needed to a) spend money on books b) go blind reading docs 
online and c) lose what little free time/life I have left  :)

Okay, okay, so I probably won't read it all cover to cover. And I mostly 
likely won't understand even 20% of what I read. But it can't hurt in 
talking to my SAs if I at least make an effort to understand what it is I am 
asking of them.

Rachel


From: Guy Hammond [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: UNIX SA
Date: Tue, 10 Jul 2001 01:05:22 -0800

The Solaris FAQ:

http://www.science.uva.nl/pub/solaris/solaris2.html

Sun's own documentation, all available online for free (in PDF too):

http://docs.sun.com/

The Ferrari book is excellent, even tho' that's actually a Porsche on
the cover:

http://www.amazon.com/exec/obidos/ASIN/0130952494/qid=994751878/sr=1-3/r
ef=sc_b_3/103-7758889-6011002

And for the truly hard of core, Solaris Internals:

http://www.amazon.com/exec/obidos/ASIN/0130224960/ref=lm_lb_3/103-775888
9-6011002

HTH,

g


-Original Message-
Sent: Monday, July 09, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L



Dear list !
I'd like to start getting into some beginner level UNIX (Solaris) system
administration .
I have some knowledge in UNIX  (scripting, basic commands , etc ... -
user/programmer/DBA level , not a sys. admin. level).

Can U please recommend what to start with ?
I prefer free resources on the web over the books i'll have to buy, off
course.
Thanks a lot for your recommendations.
Andrey.


_
Get your FREE download of MSN Explorer at http://explorer.msn.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).

Alert log scan script

2001-07-10 Thread Smith, Ron L.


Last week I was bit by a corrupt block on an index.  I run Analyze every
week which I found has been blowing up for some time due to the block
corruption.  Since Analyze does not create a log I did not know the Analyze
was blowing up.  Now I know that there are messages in the alert log that
would have told me I had problems with the Analyze and the index.

To make a long story short I need a good log scan script.  Hopefully one
that will work on Unix and NT.  Mainly Unix.  If anyone can help I would
appreciate it.

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

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

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


Guy,

You may already have this:

http://www.amazon.com/exec/obidos/ASIN/1568842031/qid=994768530/sr=1-55/ref=sc_b_55/104-1460714-8103942

as it is currently out of print -- it's sitting on my bookshelf at home

The Unix-Hater's Handbook  Simson Garfinkel and Daniel Wiese

Rachel


From: Guy Hammond [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: UNIX SA
Date: Tue, 10 Jul 2001 02:35:20 -0800

Hi,

Do you have any Unix SA experience already? If not, maybe a general Unix
SA book would be more useful than specializing in Solaris straight away,
O'Reilly publish Unix for Oracle DBAs Pocket Reference and Essential
System Administration. I've only actually read the latter, it is a good
general overview and reference.

The reason I say this, is because all Unixes are basically similar when
it comes to configuration, but vendors like to put their own tools on
too, for example AIX has SMIT, Sun have their admintool, etc. Best to
learn the underlying structure so you'll be at home on any system. Then
learn the platform specific stuff. Unix is quirky for example

*  in /etc/system, the comment character is *
*  in /etc/sendmail.cf the comment character is #
*  in /etc/named.boot the comment character is ;
*  in source code, the comment is /* */ (like in PL/SQL).

If you mark your comments in the wrong way in the wrong file, you might
end up with a system that cannot even boot! (Offtopic: if you have been
on this list for a while, you will know that I hate Unix, but know a lot
about it. The two go together).

HTH,

g




-Original Message-
Sent: Tuesday, July 10, 2001 11:23 AM
To: Guy Hammond


Guy , thanks a lot !
Just another question :
what do U recommend to START with , for a beginner , like me .
Thanks in advance.

-Original Message-
Sent: Tuesday, July 10, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L


The Solaris FAQ:

http://www.science.uva.nl/pub/solaris/solaris2.html

Sun's own documentation, all available online for free (in PDF too):

http://docs.sun.com/

The Ferrari book is excellent, even tho' that's actually a Porsche on
the cover:

http://www.amazon.com/exec/obidos/ASIN/0130952494/qid=994751878/sr=1-3/r
ef=sc_b_3/103-7758889-6011002

And for the truly hard of core, Solaris Internals:

http://www.amazon.com/exec/obidos/ASIN/0130224960/ref=lm_lb_3/103-775888
9-6011002

HTH,

g


-Original Message-
Sent: Monday, July 09, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L



Dear list !
I'd like to start getting into some beginner level UNIX (Solaris) system
administration .
I have some knowledge in UNIX  (scripting, basic commands , etc ... -
user/programmer/DBA level , not a sys. admin. level).

Can U please recommend what to start with ?
I prefer free resources on the web over the books i'll have to buy, off
course.
Thanks a lot for your recommendations.
Andrey.


_
Get your FREE download of MSN Explorer at http://explorer.msn.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[2]: table aliases save time when parsing??


Igor,

Square hit as I remember it.  I've read a couple of items from oriole corp
and while I have never found anything they've written to be wrong, they have
been less than completely clear on the why's and wherefores as in this case.

Dick Goulet

Reply Separator
Author: Igor Neyman [EMAIL PROTECTED]
Date:   7/10/2001 5:26 AM

Well, it's not aliases themselves, but the practice of using aliases as
prefixes, when referring to columns:

SELECT t1.col1, t1.col2, t2.col1
FROM table1 t1, table2 t2
WHERE t1.col2 = t2.col2

that's what saves time when parsing: this way you tell the parser which table
column list to look for, otherwise (when no prefixes used) it has to search
through all tables column lists for particular column definition (and also to
make sure, that this column name is unique in all column lists - if not you'll
be getting an error, if not using prefixes).

But, you can get the same result (save time on parsing), when using table names
as prefixes:

SELECT table1.col1, table1.col2, table2.col1
FROM table1, table2
WHERE table1.col2 = table2.col2

It's just that aliases are usually short (while table names could be long), and
it's easier to read the code.

List, please correct me, if I'm wrong.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
  

  - Original Message - 
  From: novicedba 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, July 10, 2001 7:10 AM
  Subject: table aliases save time when parsing??


  Hi,
was reading CorrelatedSubqueries.pdf from oriole corp.
  In fact it's good programming practice to use aliases in every situation where
more than one table is referred to in a statement, since it saves time when
parsing.

  Can some one please explain how it helps?

  coz
  I am a
  novice
  Oracle Certifiable DBBS

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META http-equiv=Content-Type content=text/html; charset=iso-8859-1
META content=MSHTML 5.50.4522.1800 name=GENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=#ff
DIVFONT size=2Well, it's not aliases themselves, but the practice of using 
aliases as prefixes, when referring to columns:/FONT/DIV
DIVFONT size=2/FONTnbsp;/DIV
DIVFONT size=2SELECTnbsp;t1.col1, t1.col2, t2.col1/FONT/DIV
DIVFONT size=2FROM table1 t1, table2 t2/FONT/DIV
DIVFONT size=2WHERE t1.col2 = t2.col2/FONT/DIV
DIVFONT size=2/FONTnbsp;/DIV
DIVFONT size=2that's what saves time when parsing: this way you tell the 
parser which table column list to look for,nbsp;otherwisenbsp;(when no 
prefixes used) itnbsp;hasnbsp;to search through all tables column lists for 
particular column definition (andnbsp;also to make sure, that this column name 
is unique in all column lists - if not you'll be getting an error, if not using 
prefixes)./FONT/DIV
DIVFONT size=2/FONTnbsp;/DIV
DIVFONT size=2But, you can get the same result (save time on parsing), when 
using table names as prefixes:/FONT/DIV
DIVFONT size=2/FONTnbsp;/DIV
DIVFONT size=2
DIVFONT size=2SELECTnbsp;table1.col1, table1.col2, table2.col1/FONT/DIV
DIVFONT size=2FROM table1, table2/FONT/DIV
DIVFONT size=2WHERE table1.col2 = table2.col2/FONT/DIV
DIVnbsp;/DIV
DIVIt's just that aliases are usually short (while table names could be long),

and it's easier to read the code./DIV
DIVnbsp;/DIV
DIVList, please correct me, if I'm wrong./DIV/FONT/DIV
DIVFONT size=2/FONTnbsp;/DIV
DIVIgor Neyman, OCP DBABRPerceptron, Inc.BR(734)414-4627BRA 
href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/ABRnbsp; 
BR/DIV
BLOCKQUOTE dir=ltr 
style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
#00 2px solid; MARGIN-RIGHT: 0px
  DIV style=FONT: 10pt arial- Original Message - /DIV
  DIV 
  style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B 
  A [EMAIL PROTECTED] 
  href=mailto:[EMAIL PROTECTED];novicedba/A /DIV
  DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] 
  href=mailto:[EMAIL PROTECTED];Multiple recipients of list ORACLE-L/A 
  /DIV
  DIV style=FONT: 10pt arialBSent:/B Tuesday, July 10, 2001 7:10 
AM/DIV
  DIV style=FONT: 10pt arialBSubject:/B table aliases save time when 
  parsing??/DIV
  DIVBR/DIV
  DIVFONT face=Arial size=2Hi,/FONT/DIV
  DIVFONT face=Arial size=2nbsp; was reading 
  STRONGCorrelatedSubqueries.pdf /STRONG/FONTFONT face=Arial size=2from 
  oriolenbsp;corp./FONT/DIV
  DIVFONT face=Times New Roman size=3STRONGIn fact it's good programming

  practice to use aliases in every situation where more than one table is 
  referred to in a statement, since it saves time when /STRONG/FONTIFONT 
  face=Times New Roman size=3STRONGparsin/STRONG/I/FONTFONT 
  face=Times New Roman size=3STRONGg./STRONG/FONT/DIV
  DIVFONT face=Times New Roman size=3/FONTnbsp;/DIV
  DIVFONT face=Times New Roman size=3Can some one please explain how it 
  helps?/FONT/DIV
  DIVFONT face=Times New Roman size=3nbsp;/DIV/FONT
  DIVFONT face=Arial size=2cozBRI am aBRnoviceBROracle Certifiable

Re: UTL_SMTP

2001-07-10 Thread novicedba


thanks arno
it works like a charm

coz
I am a
novice
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 04, 2001 9:14 PM


 Try this one:

 create or replace PROCEDURE send2
 (sender IN VARCHAR2,
 recipient IN VARCHAR2,
 subj IN VARCHAR2,
 body IN VARCHAR2)
 crlf VARCHAR2(2):= CHR( 13 ) || CHR( 10 );
 mesg VARCHAR2(4000);
 mail_conn UTL_SMTP.CONNECTION;
 cc_recipient VARCHAR2(50) default '[EMAIL PROTECTED]';
 bcc_recipient VARCHAR2(50) default '[EMAIL PROTECTED]';
 BEGIN

 mail_conn := utl_smtp.open_connection('mailhost', 25);
 utl_smtp.helo(mail_conn, 'mailhost');
 utl_smtp.mail(mail_conn, sender);
 utl_smtp.rcpt(mail_conn, recipient);
 utl_smtp.rcpt(mail_conn, cc_recipient);
 utl_smtp.rcpt(mail_conn, bcc_recipient);
 mesg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
 'From: ' || sender || crlf ||
 'To: ' || recipient || crlf ||
 'Cc: ' || cc_recipient || crlf ||
 'Bcc: ' || bcc_recipient || crlf ||
 'Subject: ' || subj || crlf;
 mesg:= mesg || '' || crlf || body;
 utl_smtp.data(mail_conn, mesg);
 utl_smtp.quit(mail_conn);
 EXCEPTION
 WHEN OTHERS THEN
 dbms_output.put_line(sqlerrm);
 END;
 /

 Arno
 -Original Message-
 Sent: Wednesday, July 04, 2001 1:01 PM
 To: Multiple recipients of list ORACLE-L


 Hi Gurus,

 I am trying to used UTL_SMTP to send an e-mail form my oracle machine. I
 tried the sample code from oracle documentation.

 PROCEDURE send_mail (senderIN VARCHAR2,
recipient IN VARCHAR2,
message   IN VARCHAR2)
 as
 mailhostVARCHAR2(30) := 'mail.somewhere.com';
 mail_conn  utl_smtp.connection;

 BEGIN
 mail_conn := utl_smtp.open_connection(mailhost, 25);
 utl_smtp.helo(mail_conn, mailhost);
 utl_smtp.mail(mail_conn, sender);
 utl_smtp.rcpt(mail_conn, recipient);
 utl_smtp.data(mail_conn, message);
 utl_smtp.quit(mail_conn);
 EXCEPTION
 WHEN OTHERS THEN
 dbms_output.put_line('error');
 -- Handle the error
 END;

 and i call the procedure from sqlplus


 begin
 send_mail('[EMAIL PROTECTED]','[EMAIL PROTECTED]','test from oracle');
 end;


 and i receive the e-mail like this


 Return-Path: [EMAIL PROTECTED]
 Delivered-To: [EMAIL PROTECTED]
 Received: (qmail 3139 invoked from network); 4 Jul 2001 09:58:00 -
 Received: from oracle.somewhere.com (HELO mail.somewhere.com)
(192.169.0.25)

 by mail.somewhere.com with SMTP; 4 Jul 2001 09:58:01 -
 X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/)

 test form oracle


 the problem is i lost the sender ( it sould be [EMAIL PROTECTED]) and the
 title (i don't know where i must put the title).

 Regards,

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: novicedba
  INET: [EMAIL PROTECTED]

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

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

OEM 2.2 client for Sun

2001-07-10 Thread DEMANCHE Luc (Cetelem)

Title: OEM 2.2 client for Sun





Hi gurus,


We work with OEM 2.1 client on PC and Sun stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stations). 
I can't find OEM 2.2 client for Sun on the Sun Solaris 8.1.7 CD pack, I can only find it for Windows. Is it just me or does Oracle not release a client version for Sun? 

TIA 



-
Luc Demanche
CETELEM
Tél.: 01-46-39-14-49
Fax : 01-46-39-59-88

RE: table aliases save time when parsing??

2001-07-10 Thread Gillies, Garry





Consider

SQL select deptno from emp, 
dept; select deptno from emp, 
dept  * ERROR at line 1: 
ORA-00918: column ambiguously defined

The 
column deptno would be checked against one of the tables and would be found 
to
be 
valid, but the checking cannot stop there. The other table must also be checked 
for
a 
possible conflict ( which there is in this case ).


select 
d.deptno from emp e, dept d;

Does 
not just resolve the conflict, it removes the need for any checking on 
emp.

Any 
column which is not aliased will have to be checked against ALL tables 
mentioned,
so 
aliasing can save quite a lot of time.

Regards

Garry
-Original 
Message-From: novicedba 
[mailto:[EMAIL PROTECTED]]Sent: 10 July 2001 
12:11

  Hi,
   was reading 
  CorrelatedSubqueries.pdf from 
  oriolecorp.
  In fact it's good programming 
  practice to use aliases in every situation where more than one table is 
  referred to in a statement, since it saves time when parsing.
  
  Can some one please explain how it 
  helps?
All internet traffic to this site is 
automatically scanned for viruses 
and vandals.

Re:O9i Licensing


Steve,

I have heard nothing to suggest that Oracle is abandoning the standard vs.
enterprise edition packaging.  What I have heard and read at Oracle.com is that
they are abandoning the Universal Power Unit in favor of Per Processor pricing. 
Namely there is today two license models that they offer and support, named user
and per processor.  For named user you have to be able to specify the users who
will be using the database, sometimes referred to as Concurrent Devices.  For
Per Processor I think there is more than meets the eye, but basically you pay
them $X for each processor you have in the box.  The number I've heard bandied
about is $40K per processor, but I don't think that applies to all platforms
equally.  I've also been told by the sales gerbils that if you're using software
that divies up the processors to particular tasks they will make allowances.  By
that I mean that if you have the appropriate software to assure Oracle that no
more than 2 out of 8 processors in your OEM box will be used for Oracle then
they'll consider it a 2 processor box.  At any rate, I'm happier.  That UPU
thing caused a lot of consternation around here.  Our Oracle licenses were
turning out to be twice the cost, or more, of the computers we were hoping to
get.  Now at least in our case that's been cut in half.

Thanks Larry!!  Knew you'd smell the roses/coffee sooner or later.

Dick Goulet
Senior Oracle DBA
Vicor Corporation

Reply Separator
Author: Orr; Steve [EMAIL PROTECTED]
Date:   7/9/2001 3:36 PM

Anyone familiar with Oracle9i Licensing... is there still a standard edition
versus an enterprise edition? At OpenWorld LEllison said there would only be
two types of licenses for Oracle... the database server and the application
server. If that's the case is there nolonger a standard vs enterprise
license?

On a related note, our sales rep said that 80% of Oracle's customer base is
on standard edition and only 20% is on enterprise edition. A lot less
enterprise licenses than I would have thought. I believe the recent
decrease in license fees is only true for enterprise edition but actually
could amount to a price increase for standard edition if you were using
power units. 

Feeling like a second class citizen... stuck with standard edition and in
need of transportable tablespaces, bitmapped indexes, function-based
indexes, and PQO...
Steve Orr

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

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

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

2001-07-10 Thread Orr, Steve


Thanks Rachel. Is there any breakdown as to Enterprise Edition vs Standard
Edition features?

Steve


-Original Message-
Sent: Monday, July 09, 2001 7:21 PM
To: Multiple recipients of list ORACLE-L



According to the 9i concepts manual, there is a standard and enterprise 
edition.


From: Orr, Steve [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: O9i Licensing
Date: Mon, 09 Jul 2001 15:36:30 -0800

Anyone familiar with Oracle9i Licensing... is there still a standard 
edition
versus an enterprise edition? At OpenWorld LEllison said there would only 
be
two types of licenses for Oracle... the database server and the application
server. If that's the case is there nolonger a standard vs enterprise
license?

On a related note, our sales rep said that 80% of Oracle's customer base is
on standard edition and only 20% is on enterprise edition. A lot less
enterprise licenses than I would have thought. I believe the recent
decrease in license fees is only true for enterprise edition but actually
could amount to a price increase for standard edition if you were using
power units.

Feeling like a second class citizen... stuck with standard edition and in
need of transportable tablespaces, bitmapped indexes, function-based
indexes, and PQO...
Steve Orr

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: Orr, Steve
  INET: [EMAIL PROTECTED]

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

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

RE: UNIX SA

2001-07-10 Thread JDonson


Here's a very readable one...
  http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0201353954vm=

If the link doesn't stick, then just look for unix
and redhat 'quickstart guides' on fatbrain.com

They are cheap, readable and easy to reference.
-- 
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: gzip does not want to work with files 2G

2001-07-10 Thread Hillman, Alex


I use version 1.3 for Solaris 5.8 - it is the same version that is on
www.sunfreeware.com What version do you use and for which version on
Solaris?


Alex Hillman

-Original Message-
Sent: Monday, July 09, 2001 10:46 PM
To: Multiple recipients of list ORACLE-L


What version of gzip are you using?  I had the same problem before, just had
to get the latest version.

Richard Ji

 [EMAIL PROTECTED] 07/09/01 07:12PM 
I have Solaris 5.8 angzip does not want to work with files  2G - tells that
file is too large. Anybody has any idea why?

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

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

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

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

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

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

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

2001-07-10 Thread JDonson


RedHat 7.0 Running
Oracle for Linux 8.1.6 - INSTALLATION HELP NEEDED!

I am s close...

Despite good install, including Net8, the sample db install hung at 80% completed.

Now I am trying to startup nomount
and create a dbase manually.
I cannot STARTUP NOMOUNT PFILE=

svrmgrl can connect internal,
but just hangs on startup nomount

I wish it returned an error.
I would be less stuck.

My first attempt was with 128 MB RAM, so just to be sure
I dropped in add'l 300+ MB, then deinstalled and reinstalled O8i.

Again, installation ran to completion,
except starter database creation crapped out at '80%'.

Still just hangs on startup nomount
with manual attempt after connecting internal.

Is there a problem with these versions of RH and O8i?
Is there a known workaround to this glitch?

If something was wrong in my pfile, then
I would get an error returned, right?

thanks very much

Jeremy Donson

-- 
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: O9i Licensing

2001-07-10 Thread Weaver, Walt


Well, if you're lucky enough to use the Enterprise Edition you'll be saving
money. We use the Standard Edition, and at this time it looks like it's
going to cost us quite a bit more, actually, for a per-processor license. 

So, we're currently in delicate negotiations with our Oracle rep and various
resellers to see what kind of deal we can get. Fortunately we can still buy
licenses through the old power unit scheme through the end of July. Since
we're opening up a new hosting data center in New Jersey next month we're
gonna scarf up as many licenses as we can afford.

So, Larry, I got something you can smell right here.:)

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, July 10, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L

Steve,

I have heard nothing to suggest that Oracle is abandoning the standard
vs.
enterprise edition packaging.  What I have heard and read at Oracle.com is
that
they are abandoning the Universal Power Unit in favor of Per Processor
pricing. 
Namely there is today two license models that they offer and support, named
user and per processor.  

Thanks Larry!!  Knew you'd smell the roses/coffee sooner or later.

Dick Goulet
Senior Oracle DBA
Vicor Corporation

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

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

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


Even for inserts, index key values cannot span
multiple blocks.  An attempt to create an index where
a single key value won't fit in a single block will
result in an ORA-1450 maximum key length exceeded.

-- Anita

--- Hillman, Alex [EMAIL PROTECTED]
wrote:
 Update in the index is done as delete and insert, so
 there is no chaining.
 
 Alex Hillman
 
 -Original Message-
 Sent: Thursday, July 05, 2001 5:46 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I've been asked to create an index which combines
 two fields, date 
 location.
 For reasons I don't really want to explain, we
 need/desire this index to
 be in the order of date, location. The minor gotcha
 is that while location
 will be populated at the time the record is created,
 the date field is not
 updated until a later point in time. This date is a
 document print date.
 So this date field will be going from a NULL value
 to a non-null value.
 I recognize that this can result in record chaining
 in the data table.
 In thinking about this, I realized this could have a
 similar affect
 within the index. However, I've never read anything
 about index chaining.
 
 Do/can indexes chain? 
 Should I be concerned about this?
 
 
 -- 
 Charlie Mengler  Maintenance
 Warehouse  
 [EMAIL PROTECTED] 10641 Scripps
 Summit Ct.
 858-831-2229   .NET? Not yet!San Diego, CA
 92131
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Charlie Mengler
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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 personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

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

Client Connection-SQLNET and?/or? ODBC.

2001-07-10 Thread James Damiano


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do ODBC, do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- ODBC itselfor
- ODBC through SQLNET?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

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

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

2001-07-10 Thread Scott Canaan


Sajid,
Unfortunately, I ran into the same problem.  I didn't find anything to do
it for me, either, so I had to write the pl/sql code.  It is very long and
messy, but can be done.  When I did it, I didn't even attempt the days
notation.  Here is the code that I wrote:

date_diff := trans_cur.modified_date - last_date;
date_diff_tot := trans_cur.modified_date - first_date;
SELECT decode( trunc( date_diff * 24),0,
  to_char( trunc( date_diff * 1440), 'FM90') || ':' ||
  to_char( round( date_diff * 86400) - trunc( date_diff
* 1440) * 60,'FM00'),
  to_char( trunc( date_diff * 24),'FM90') || ':' ||
  to_char( trunc( date_diff * 1440 - trunc( date_diff *
24)
* 60),'FM00') || ':' ||
  to_char( round( date_diff * 86400 - trunc( date_diff
* 1440) * 60), 'FM00')),
  decode( trunc( date_diff_tot * 24), 0,
  to_char( trunc( date_diff_tot * 1440),'FM90') || ':' ||

  to_char( round( date_diff_tot * 86400)
- trunc( date_diff_tot * 1440) * 60,'FM00'),
  to_char( trunc( date_diff_tot * 24),'FM90') || ':' ||
  to_char( trunc( date_diff_tot * 1440
- trunc( date_diff_tot * 24) * 60),'FM00') || ':' ||
  to_char( round( date_diff_tot * 86400
- trunc( date_diff_tot * 1440) * 60), 'FM00'))
INTO elapsed_1, elapsed_2
FROM dual;

I hope this helps.

Sajid Iqbal wrote:

 Hello All

 I want to display the time elapsed between two dates - in days, hours,
 minutes and seconds.

 If I do select date1 - date2, the result is : 12.0194907

 Is there a function that will turn the number of days into something more
 legible?  Ideally i'd like to do ;

 to_char(12.0194907,'DD:HH:MI:SS') but obviously that won't work.  Is
 there a solution other than writing a complex function myself which will
 have to * by 24, / by 60 and substr etc to get the different bits of the
 number?

 Please CC any replies directly to me at [EMAIL PROTECTED]

 Thanks in advance,
 Saj.

 --
 Sajid Iqbal
 Database Team Leader

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

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

--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
Life is like a sewer, what you get out of it depends on what you put into
it - Tom Lehrer


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 DBA with Data Warehouse Exp.-Albany, New York

2001-07-10 Thread OraStaff


Healthcare solutions company in Albany, New York needs an Oracle DBA to join
it's
I.T. team.
This company provides technical solutions to pharmacy, HMO and hospital clients.
They are calling it a Developmental DBA:
You will be responsible for all facets of development related to the
logical database facilities.  Responsibilities will include working with
the Data Architect, Product Developers, and Application Programmers to
architect new solutions and enhance existing solutions. 

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

*Requirements:
- A B.S. Degree in C.S. or related field
- 3+ years Enterprise level Oracle DBA experience
- Proficiency in the following:
  development and modeling of OLTP, Warehouse, 
  data Marts databases and in leading database modeling tools
- Experience with and in writing and performance tuning PL-SQL.

- U.S. citizens or permanent residents only

This position offers:
* Opportunity to become a key member of the I.T. team
* Competitive Salary and Benefits package
* Relocation package may be available for the right candidate

For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Ph: 1-800-549-8502-Please do not call if you need sponsorship
Email: [EMAIL PROTECTED]
Please use job code: One/Albany/DBA/Suzanne

Note: This is only one of the many opportunities that we have available
across the U.S. 
for candidates with Oracle skills who are U.S. citizens or permanent residents. 
So if this one is not a match for you, we invite you 
to send us your resume- as we quite possibly have the opportunity that you
are seeking.

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law




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

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

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

2001-07-10 Thread Gogala, Mladen


1-800-223-1711 (Silver)

-Original Message-
Sent: Monday, July 09, 2001 4:52 PM
To: Multiple recipients of list ORACLE-L



1-407-240-8900 

-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent: Monday, July 09, 2001 4:05 PM 
To: Multiple recipients of list ORACLE-L 


Could somebody give me support 800 or long dist. phone number. I know that I

need to log itar first but this is a damagement request and I cannot find 
mine. 

Alex Hillman 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

2001-07-10 Thread Shaw, John B


Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have some
as yet unexplained errors connecting older versions to 8.1.7 - most notably
with large objects.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 3:05 AM
To: Multiple recipients of list ORACLE-L


Hi,
I have just had the experience of upgrading to 81714, discovering a problem
in our application that did not show up in any testing and having to go back
to 815.

The 815 instance is on a different server to the 817 instance and we still
have the 817 instance available for further troubleshooting.

This is on NT4.

With 817, we were getting ora-3113 in the forms application and in ODBC
connections and also seeing ora-03121 as well.

We got core dump files produced (under 817 they are produced on NT) but
Oracle support does not seem to know how to interpret them on NT - has
anyone had any experience with this?

No mention of the core dump file was contained within the alert log and no
files were produced in the user dump directory.

When I turned sql trace on for the session running forms, the ora-3113 did
not occur - has anyone seen behaviour like this where SQL Trace will cause
an ora-3113 to stop occurring?

All suggestions on what to look for or how to interpret NT core dumps are
welcome.

Thanks,
Bruce Reardon
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

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

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

2001-07-10 Thread Guy Hammond

Title: RE: Sizing a new server



Hi 
Lisa,

That 
doesn't sound too bad, the 8400 is a solid piece of kit. 64-bit, up to 14 CPUs 
and 28G of memory. They have seriously good I/O bandwidth. Needs a three-phase 
power supply and weighs, literally, half a tonne. And best of all, you can run 
VMS on them!

g


  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 2:46 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Sizing a new server
  Bruce, 
  It's going to be Unix, tru64. 
  Unfortunately I will be stuck with some old hardware to start with - an Alpha, 
  8400, I believe maxes out at 8 cpu's, along with two old disk farms (compaq 
  esa10k). I'm slapping together a bunch of old pieces of hardware, 
  upgrading where needed, obtaining software licensing where needed, compaq 
  hardware/software support, and with some duct tape, political brown-nosing 
  done by others and a few users screaming for their data, I'll hopefully end up 
  with some sort of reporting tool hitting this. (BizObj or Cogno$). 
  Man Cognos is expensive. 
  I wish I could choose AIX here. 
  It's not an option. 
  See doesn't this sound like a 
  director's job?? Say it 
  again: I LOVE MY JOB 
  Lisa 
  
-Original Message- From: Reardon, Bruce (CALBBAY) 
[SMTP:[EMAIL PROTECTED]] Sent: Monday, July 09, 
2001 8:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: Sizing a new server 
Lisa, 
Some may laugh at the question but what OS - NT, 
Unix, VMS or ? 
Regards, Bruce 
Reardon -Original Message- 
Sent: Tuesday, 10 July 2001 4:36 
To: Multiple recipients of list 
ORACLE-L 
Thanks Kimberly, I wish it was that way. I have to justify my request with hard 
numbers or they are going to laugh at me 
when I say, "Because that's what I want". :) They don't yet know how I'd react to that, it would be a 
knee-jerk type of reaction involving 
creative expletives... not pretty. Good for you. At least you have some real hardware and true 
HA. I wish I did Lisa 
-Original Message- Sent: Monday, July 09, 2001 12:51 PM 
To: Multiple 
recipients of list ORACLE-L Get the 
biggest, kick ass server they will let you buy. If your site is 
anything like mine they just keep asking for 
more and more databases. So no matter what I have now I know its not enough. I am really happy 
with the nice new N-class HP cluster I 
have sitting next door running Service Guard. I am also getting a A-class database cluster for some important but 
not fab critical databases. Now if 
I can only get ride of the 5 K-class database servers. Its kind of like when you go from a fast to a slow 
PC. Drives me crazy. Not that 
there are issues with performance from the databases. It 
would only be me, while playing (which of course 
means working) on the server, that would 
notice. -Original Message- 
Sent: Monday, July 09, 2001 8:30 AM 
To: Multiple recipients of list ORACLE-L 

Good morning everyone, Lucky me, I get to choose the size of the server this 
company should consider purchasing. 
I have been poking around on the net for any guidelines - I can make guesses based upon my gut feel and how 
strapped the current unix server is, but 
I want to be able to back this up with hard numbers. This is for a dw application. Can anyone point me to a website, book, or anything in 
particular that can help me justify 
sizing a machine? It's so fun working for a company that 
doesn't have a sysadmin on staff... 
Thanks Lisa Koivu Oracle Data Bored 
Administrator Ft. Lauderdale, FL, 
USA 954-935-4117 -- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce 
(CALBBAY)  INET: 
[EMAIL PROTECTED] 
Fat City Network Services -- 
(858) 538-5051 FAX: (858) 538-5051 San Diego, California -- 
Public Internet access / Mailing Lists  
To REMOVE yourself from this mailing list, send 
an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: 
UNSUB ORACLE-L (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: Date / Time

2001-07-10 Thread Stephane Faroult


Sajid Iqbal wrote:
 
 Hello All
 
 I want to display the time elapsed between two dates - in days, hours,
 minutes and seconds.
 
 If I do select date1 - date2, the result is : 12.0194907
 
 Is there a function that will turn the number of days into something more
 legible?  Ideally i'd like to do ;
 
 to_char(12.0194907,'DD:HH:MI:SS') but obviously that won't work.  Is
 there a solution other than writing a complex function myself which will
 have to * by 24, / by 60 and substr etc to get the different bits of the
 number?
 
 Please CC any replies directly to me at [EMAIL PROTECTED]
 
 Thanks in advance,
 Saj.
 
 --
 Sajid Iqbal
 Database Team Leader

Sajid,

   The difference of two dates is a number of days. If you want to use a
function similar to the dates function, you have to treat the day and
fractional parts separately, eg

 select trunc(date2 - date1) days,
to_char(trunc(sysdate) + (date2 - date1) - trunc(date2 - date1),
 'HH24:MI')

 This uses a trick, the fact that date + number is a date ('number' is
assumed to be a number of days) - so we can use 0:00 today as 'base' and
just display hours and minutes (and seconds if you need them).
--
Regards,

  Stephane Faroult
  Oriole Corporation
--
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

2001-07-10 Thread JDonson


I believe that a dedicated window running

tail -f 10 /alert_log_filename

  will keep an eye on the last 10 lines of the
  alert log in Unix/Linux.

 - jeremy donson
 CateredComputing
-- 
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: O9i Licensing

haven't found it in the concepts manual... can't remember where it was in 
the 8i docs

From: Orr, Steve [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: O9i Licensing
Date: Tue, 10 Jul 2001 06:05:25 -0800

Thanks Rachel. Is there any breakdown as to Enterprise Edition vs Standard
Edition features?

Steve

-Original Message-
Sent: Monday, July 09, 2001 7:21 PM
To: Multiple recipients of list ORACLE-L

According to the 9i concepts manual, there is a standard and enterprise
edition.

 From: Orr, Steve [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: O9i Licensing
 Date: Mon, 09 Jul 2001 15:36:30 -0800

 Anyone familiar with Oracle9i Licensing... is there still a standard
 edition
 versus an enterprise edition? At OpenWorld LEllison said there would only
 be
 two types of licenses for Oracle... the database server and the 
application
 server. If that's the case is there nolonger a standard vs enterprise
 license?

 On a related note, our sales rep said that 80% of Oracle's customer base 
is
 on standard edition and only 20% is on enterprise edition. A lot less
 enterprise licenses than I would have thought. I believe the recent
 decrease in license fees is only true for enterprise edition but 
actually
 could amount to a price increase for standard edition if you were using
 power units.

 Feeling like a second class citizen... stuck with standard edition and in
 need of transportable tablespaces, bitmapped indexes, function-based
 indexes, and PQO...
 Steve Orr

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: Orr, Steve
   INET: [EMAIL PROTECTED]

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: any dangers of using UTL_SMTP

2001-07-10 Thread Naik, Sandesh S


Thank you very much everybody for your expert comments. That really helped
me to put my case with manager who has concerns about using UTL_SMTP with
loading java in database.

Thanks again

Sandesh

-Original Message-
Sent: Friday, July 06, 2001 4:38 PM
To: Multiple recipients of list ORACLE-L


Sandesh:

We're running the same environment as you, except that we're using HP/UX
11.0 64-bit.  I just ran the install scripts and everything's been working
fine.  This machine is (don't yell!) half-Test and half-Production, and
the 8.1.6 database is the production half.  It just worked.

Good Luck!
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |


-Original Message-
Sent: Friday, July 06, 2001 1:09 PM
To: Multiple recipients of list ORACLE-L


Dear Friends,
 I have a Oracle 8.1.6.2.0 database on HP-UX 11.0 of about 25M Shared pool
about 10,000 db_block_buffers.
 One of our development team wants to use UTL_SMTP. I know I have install
Jserver and run initjvm.sql to install all the classes.
 I want to know any dangers or problems people have faced using this and
what are the precautions they have taken. Steps to set up Jserver to
UTL_SMTP to work smoothly are appreciated.
 All replies are welcome.

Thanks
Sandesh Naik
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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

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

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


Alex,

Yes, the connection remains open unless it is
explicitly closed (see Note: 1034343.6).

The session also takes out a lock on the local RBS
(see Note:74811.1) as this could be part of a
distributed transaction.  If this is a long running
query this can lead to abnormal growth in the RBS
since the active transaction in the RBS will prevent
the RBS from wrapping into that extent.  You can avoid
this by issuing SET TRANSACTION READ ONLY; prior to
running the distributed query.

AFAIK, you can use MTS connections, although I would
recommend using dedicated connections for any links
used for replication (push and refresh operations).

HTH,

-- Anita


--- Hillman, Alex [EMAIL PROTECTED]
wrote:
 So you mean that connection to the remote DB stays
 open until session ends
 which issued query on remote DB. Are these
 connection dedicated? I think yes
 bur did not check. Is it possible to use MTS for
 such connection? And all
 new features like connection pooling etc.
 
 Alex Hillman
 
 -Original Message-
 Sent: Monday, July 09, 2001 6:55 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Yes, it creates a session. If you want to do a(n)
 SQL trace, you can do a
 SELECT 'x' FROM dual@remote_site, find the session
 at the remote site and
 turn on the trace, then run your next query. 
 
 Henry
 
 -Original Message-
 Sent: Monday, July 09, 2001 5:06 PM
 To: Multiple recipients of list ORACLE-L
 
 
 If I query table in the remote database using
 database link does user in the
 remote database which is referenced in the database
 link  create session in
 the remote database and if not could somebody
 explain how remote query is
 executed.
 
 Alex Hillman
 
 P.S. I know that I could try it myself but I am
 layzy (sp?) and tired
 (fighting with Ross for access to printing presses
 :-) )
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Hillman, Alex
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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: Henry Poras
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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: Hillman, Alex
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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 personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

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

Rename alert log

2001-07-10 Thread Smith, Ron L.


Can the alert log be renamed while the database is up and running?

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

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

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

2001-07-10 Thread Gorthy BhanuPrakash


Hi,
I had installed oracle 8.1.7 on WINNT and installed
oracle client with administrator utility on win2k
system. When i want to connect to this client on win2k
to server on winnt. But i am getting the error
ORA:12514.
Can any one slove this for me.
The listener.ora and tnsnames.ora files seems to be
ok.

Thanks in advance
Bhanu

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorthy BhanuPrakash
  INET: [EMAIL PROTECTED]

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

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

2001-07-10 Thread Ruth Gramolini


Try AlertView from zephyrus.com.  It is a free tool for analyzing your alert
logs.

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 9:31 AM


 Last week I was bit by a corrupt block on an index.  I run Analyze every
 week which I found has been blowing up for some time due to the block
 corruption.  Since Analyze does not create a log I did not know the
Analyze
 was blowing up.  Now I know that there are messages in the alert log that
 would have told me I had problems with the Analyze and the index.

 To make a long story short I need a good log scan script.  Hopefully one
 that will work on Unix and NT.  Mainly Unix.  If anyone can help I would
 appreciate it.

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

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

2001-07-10 Thread Greg Solomon


Hi

Definitely check whether you can ping the server from the client.
If not, then it's a network config problem.

After that, I once had this problem when a highly creative user (actually,
our CTO) had entered a setting for Oracle Names when we were using local
names only.  I had to delete the setting.

If that doesn't help, suggest that you turn on the trace files for 
a) the client you're trying to set up, and
b) another client which is known to work OK.

Comparing the trace files should give you a few clues.

HTH

Cheers
Greg

-Original Message-
Sent: Tuesday, 10 July 2001 16:56
To: Multiple recipients of list ORACLE-L


Hi,
I had installed oracle 8.1.7 on WINNT and installed
oracle client with administrator utility on win2k
system. When i want to connect to this client on win2k
to server on winnt. But i am getting the error
ORA:12514.
Can any one slove this for me.
The listener.ora and tnsnames.ora files seems to be
ok.

Thanks in advance
Bhanu

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorthy BhanuPrakash
  INET: [EMAIL PROTECTED]

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

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

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

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

old stats and temp space

2001-07-10 Thread Steve Sapovits



Is there any correlation between out of date analyze stats
and temp space usage?  i.e., could old stats cause overly
large temp space usage?


Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell:   610-574-7706
Pager:  877-239-4003

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

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

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

2001-07-10 Thread Vergara, Michael (TEM)


Ron:

Yep.  Do it every night at midnight.  But...you can't just rename it!
If you do a command like...

mv alert_SID.log alert_SID_010710.log
touch alert_SID.log

...Oracle will still append new entries to the old file, and your new
alert_SID.log file will continue to have 0 bytes.  What you need to 
do is...

cp -p alert_SID.log alert_SID_010710.log
 alert_SID.log

...This copies the file while maintaining the timestamp, and then nulls 
out the existing file.  This should work on most flavors of UNIX.

HTH,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |


-Original Message-
Sent: Tuesday, July 10, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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

Re: OEM 2.2 client for Sun

2001-07-10 Thread JOE TESTA




i dont know the answer to that one for sure, but its available for 
linux(java based) so i'd think it should be available.

joe
 [EMAIL PROTECTED] 07/10/01 09:45AM 

Hi gurus, 
We work with OEM 2.1 client on PC and Sun 
stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stations). 
I can't find OEM 2.2 client for Sun on 
the Sun Solaris 8.1.7 CD pack, I can only find it for Windows. Is it just me or 
does Oracle not release a client version for Sun? 
TIA 
- Luc Demanche CETELEM 
Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88

RE: Alert log scan script

2001-07-10 Thread Mark Leith


Ron,

I've attached one that I also got from the list some time ago, you may need
to use something like bablefish to translate the comments :)

HTH

Mark

-Original Message-
L.
Sent: Tuesday, July 10, 2001 02:32
To: Multiple recipients of list ORACLE-L


Last week I was bit by a corrupt block on an index.  I run Analyze every
week which I found has been blowing up for some time due to the block
corruption.  Since Analyze does not create a log I did not know the Analyze
was blowing up.  Now I know that there are messages in the alert log that
would have told me I had problems with the Analyze and the index.

To make a long story short I need a good log scan script.  Hopefully one
that will work on Unix and NT.  Mainly Unix.  If anyone can help I would
appreciate it.

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

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

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

 alerts.sql

RE: Date / Time

2001-07-10 Thread Jamadagni, Rajendra


SELECT  12.0194907 
   ,FLOOR((12.0194907*86400)/86400) || ':' || 
 
TO_CHAR(TO_DATE(ROUND(SUBSTR(12.0194907,INSTR(12.0194907,'.'))*86400),'s
'),'HH24:MI:SS')
FROM dual

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

*1

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.

*1

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

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

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


James,

First off, Linux does not use DLL's, that's a MicroSlop thing.  It does make
use of .so files for Shared Object, which is a Unix thing.

Now as to the subject of ODBC: ODBC stands for Open Data Base Connectivity
which again was a MicroSlop idea that has caught one.  OK, I'll give Gates  CO
a pat on the back for a good idea that went bad elswhere.  Anyway, the idea is
that your application has a common interface, namely ODBC, that then connects to
each database vendor's proprietary transport.  This way the interface to the
database from your perspective (as the developer) is the same no matter who's
database is underneath.  In theory it is a great idea, but the implementation
results in a pile of ODBC driver HELL.  BUT to answer your question, if your
going to use ODBC to get to Oracle, you'll have to have the SQL*Net client stuff
on that machine as well.

Dick Goulet

Reply Separator
Author: James Damiano [EMAIL PROTECTED]
Date:   7/10/2001 7:15 AM

Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do ODBC, do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- ODBC itselfor
- ODBC through SQLNET?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

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

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

2001-07-10 Thread Kimberly Smith

Title: RE: Sizing a new server

Actually, it really depends on the industry at the moment as to whether
or not money is no object. Currently money is a huge issue. The
semi-conductor fabs are not doing so hot right now (at least not the memory
producing ones). Fabs are all pretty much in a slow down.

-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 12:45
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Sizing a new server
By
the sounds of it, Kimberley was in a very similar situation to me when I was
working for a semi-conductor manufacturing company afew years ago (the worst
job I ever had).Basically money was no object and anything was feasible as
long as the fab kept running 24x7.

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: 09 July 2001
19:36To: Multiple recipients of list ORACLE-LSubject:
RE: Sizing a new server
Thanks Kimberly,
I wish it was that way. I
have to justify my request with hard numbers or they are going to laugh at
me when I say, "Because that's what I want". :) They don't yet
know how I'd react to that, it would be a knee-jerk type of reaction
involving creative expletives... not pretty.
Good for you. At least you
have some real hardware and true HA. I wish I did
Lisa

-Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Sizing a new server
Get the biggest, kick ass server
they will let you buy. If your site is anything like mine they just
keep asking for more and more databases. So no matter what I have
now I know its not enough. I am really happy with the nice new
N-class HP cluster I have sitting next door running Service Guard. I
am also getting a A-class database cluster for some important but not fab
critical databases. Now if I can only get ride of the 5 K-class
database servers. Its kind of like when you go from a fast to a slow
PC. Drives me crazy. Not that there are issues with
performance from the databases. It would only be me, while
playing(which of course means working) on the server, that would
notice.

-Original
Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday,
July 09, 2001 8:30 AMTo: Multiple recipients of
list ORACLE-LSubject: Sizing a new
server
Good morning everyone,
Lucky me, I get to choose the size
of the server this company should consider purchasing. I have been
poking around on the net for any guidelines - I can make guesses based
upon my gut feel and how strapped the current unix server is, but I want
to be able to back this up with hard numbers. This is for a dw
application.
Can anyone point me to a website,
book, or anything in particular that can help me justify sizing a
machine? It's so fun working for a company that doesn't have a
sysadmin on staff...
Thanks

Lisa KoivuOracle Data Bored
AdministratorFt. Lauderdale, FL, USA954-935-4117
The information in the electronic mail
message is Cendant confidential and may be legally privileged, it is
intended solely for the addressee(s) access to this internet electronic
mail message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken or
omitted to be taken in reliance on it is prohibited and may be
unlawful.
The sender believes that this E-mail and any
attachments were free of any virus, worm, Trojan horse, and/or malicious
code when sent. This message and its attachments could have been
infected during transmission. By reading the message and opening any
attachments, the recipient accepts full responsibility for taking
protective and remedial action about viruses and other defects. Cendant
Corporation or Affiliates are not liable for any loss or damage arising
in any way from this message or its attachments.
The information
contained in this communication isconfidential, is intended only for the
use of the recipientnamed above, and may be legally privileged. If the
reader of this message is not the intended recipient, you arehereby
notified that any dissemination, distribution orcopying 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
computersystem.

RE: Client Connection-SQLNET and?/or? ODBC.

2001-07-10 Thread Shaw, John B


Yes you need SQLNET. odbc uses sqlnet on the client.

-Original Message-
Sent: Tuesday, July 10, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do ODBC, do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- ODBC itselfor
- ODBC through SQLNET?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

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

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

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

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

OT : Oracle datawarehouse DBA available in Canada

2001-07-10 Thread paquette stephane


Hi,

Sorry for the out of topic post.

I'm going back to Canada.   
I'll be looking for a position as an Oracle devlopment
dba in the datawarehousing field for the Montreal
area. 

I do not know if they are recruiters looking for
candidates in the Montreal area but if so you can
contact me at [EMAIL PROTECTED]



=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

need to recreate database

2001-07-10 Thread lhoska


Hello,
I need to recreate a database, basically make a complete copy of one of the
existing databases on a new server.  My networking people already copied all
datafiles, control file, log files, init file, etc to the target server.
They also reproduced operating system directory structure.
What I need to do is to make the second part of the task work, create the
database, services, etc and make it run.
I have not done it before and if I was doing it I would probably do
export/import type of thing but the higher ups would like to have it done
this way.
One of the people has an idea suggesting just recreating the registry
setting by exporting it from the existing machine to the new one.
The other option is to reinstall Oracle but I am not sure how to make it to
accept existing physical components(datafiles, control file, etc).
If someone has a suggestion I would greatly appreciate it.
Thank you in advance.

Lyuda Hoska

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

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

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

2001-07-10 Thread Christopher Spence


Yeah, I noticed that about the pricing too, for the E10k it is still 2.6
Million, same exact price as before.

-Original Message-
Sent: Tuesday, July 10, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


Both are still there, and despite the hype it actually looks like a price
increase unless your cpu's are over 1Gz.

-Original Message-
Sent: Monday, July 09, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L


Anyone familiar with Oracle9i Licensing... is there still a standard edition
versus an enterprise edition? At OpenWorld LEllison said there would only be
two types of licenses for Oracle... the database server and the application
server. If that's the case is there nolonger a standard vs enterprise
license?

On a related note, our sales rep said that 80% of Oracle's customer base is
on standard edition and only 20% is on enterprise edition. A lot less
enterprise licenses than I would have thought. I believe the recent
decrease in license fees is only true for enterprise edition but actually
could amount to a price increase for standard edition if you were using
power units. 

Feeling like a second class citizen... stuck with standard edition and in
need of transportable tablespaces, bitmapped indexes, function-based
indexes, and PQO... Steve Orr

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

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

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

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

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

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

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

2001-07-10 Thread Robin Ilardi


Yes, you do need to have Net8 installed in order for Cold Fusion to connect
to the database through ODBC.  It uses ODBC through SqlNet.  First set up
the Sqlnet connection to the database, then set up the ODBC connection using
the service name you used for the Sqlnet connection.

hth,
Robin


-Original Message-
Damiano
Sent: Tuesday, July 10, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do ODBC, do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- ODBC itselfor
- ODBC through SQLNET?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

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

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

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

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

2001-07-10 Thread Jeffrey Beckstrom



We have 
been running 8.1.7 for a couple weeks. The clients are 8.1.6 
still [EMAIL PROTECTED] 7/10/01 11:55:59 AM 
Are you running the 8.1.7 sqlnet clients and odbc drivers. We 
did have someas yet unexplained errors connecting older versions to 8.1.7 - 
most notablywith large objects.-Original Message-[mailto:[EMAIL PROTECTED]]Sent: 
Tuesday, July 10, 2001 3:05 AMTo: Multiple recipients of list 
ORACLE-LHi,I have just had the experience of upgrading to 81714, 
discovering a problemin our application that did not show up in any testing 
and having to go backto 815.The 815 instance is on a different 
server to the 817 instance and we stillhave the 817 instance available for 
further troubleshooting.This is on NT4.With 817, we were getting 
ora-3113 in the forms application and in ODBCconnections and also seeing 
ora-03121 as well.We got core dump files produced (under 817 they are 
produced on NT) butOracle support does not seem to know how to interpret 
them on NT - hasanyone had any experience with this?No mention of 
the core dump file was contained within the alert log and nofiles were 
produced in the user dump directory.When I turned sql trace on for the 
session running forms, the ora-3113 didnot occur - has anyone seen behaviour 
like this where SQL Trace will causean ora-3113 to stop 
occurring?All suggestions on what to look for or how to interpret NT 
core dumps arewelcome.Thanks,Bruce 
Reardon[EMAIL PROTECTED]-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
Reardon, Bruce (CALBBAY) INET: 
[EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Shaw, John B INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

RE: Performance/Optimization/Monitoring Tools

2001-07-10 Thread Kimberly Smith


I would say now that CA owns ERwin it pretty much is terminal, regardless of

whether or not its the last release they send out.

-Original Message-
Sent: Monday, July 09, 2001 9:00 PM
To: Multiple recipients of list ORACLE-L


[EMAIL PROTECTED] wrote:

 For those of you who maybe interested:

 Kumar: CA to organize products into four brands

 At CA World, Computer Associates President and CEO Sanjay Kumar outlined
the
 software vendor's plan to refocus on six core segments divided into four
branded
 product lines.

 http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62061_NLTam%2C00.html
 --

so - does this mean 4.0 is a terminal release for ERWin?

I couldn't read that far between the lines.

Paul


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

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

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


depends on the version of the database you are running.. it used to be that 
yes, you could just rename it and Oracle would open a new one of the 
original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an 
open file pointer to it, similar to the way it handles the listener log 
file. So you will need to do the same sort of tricks to the alert log as you 
have to do to the listener log (make a copy then copy /dev/null to the 
original)



From: Smith, Ron L. [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Rename alert log
Date: Tue, 10 Jul 2001 06:56:31 -0800

Can the alert log be renamed while the database is up and running?

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: Performance/Optimization/Monitoring Tools

2001-07-10 Thread Mark Leith


Other than those from the companies you have mentioned (and personally - as
already mentioned - I would stay away from CA) here are a few others to bear
in mind:

SHAMELESS PLUG
NORAD Surveillance Module - www.bradmark.com (also www.cool-tools.co.uk)
(Sits in between Spotlight  Foglight from Quest, except cheaper, well
established, and highly configurable)
/SHAMELESS PLUG

Performance Centre - www.embarcadero.com
(Only version 1.something at the moment, but a solid start for a monitoring
tool)

Mamba - www.luminate.com
(it's free but a cool tool all the same)

Precise SQL - www.precise.com ?
(Very low impact on the actual server, meaning you can have very low
monitoring periods (2 seconds even) as they have mapped the system memory,
and do not need to connect to the database to monitor it)

Experience from market:

CA
(Don't even go there, support is bad, the products may be good, but not
really going anywhere in a hurry)

Quest
(Good solid tools, constantly moving forward in development, support a
little flaky at times and pretty expensive, but widely used)

BMC
(Plenty of $$, hard to configure for monitoring (have even heard you need
consultants to do this) but again good tools if you can afford them)

This is really a quick overview..

HTH

Mark

Disclaimer: These are my own personal views, from my experience in the DBA
tool market place, and in no way reflects the views of my employer
Cool-Tools


-Original Message-
Michael (TEM)
Sent: Monday, July 09, 2001 06:06
To: Multiple recipients of list ORACLE-L


DBA's:

We're looking at tools for monitoring and tuning our databases.  Our
primary applications are data warehouse, data marts, document control,
help desk, and laboratory management.  (We also have SAP but they have
their own tool set).

Anybody have any experience/recommendations/stay-away-froms for stuff from
vendors like BMC, Quest, CA, etc.?

Thanks,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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

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

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

2001-07-10 Thread Farnsworth, Dave


Yes

-Original Message-
Sent: Tuesday, July 10, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

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

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

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

help how get the n top rows for any table?

2001-07-10 Thread Alexander Ordonez


Hi, gurus!!!

A need know how get n top row for any table somebody can help me!!

Thanks!!!

@lex

  Lic. Alexander Ordóñez Arroyo 
  Caja Costarricense del Seguro Social 
  Soporte Técnico - División de Informática 
  Telefono: 295-2004, San José, Costa Rica
  [EMAIL PROTECTED]


UNIX is very user friendly, 
It's just very particular about who it makes friends with.



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

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

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

Question about OFA and RAID 5

2001-07-10 Thread Tom Schruefer



Any suggestions on the message below would be greatly appreciated.  
Thanks in advance.

I have been appointed our new Oracle DBA and have since been taking 
classes and reading books.  I quite enjoyed the recent thread on OFA.  I 
seem to have a bit of a quandary, here it is.


We have 68 schools with 46,000 students, each with their own student 
database, we have purchased a product that will allow us to aggregate all 
of these databases into one central database.  This project is but one 
step toward a centralized student data system, which we currently do not 
have the infrastructure for.

Here is the suggested configuration for the database server for this 
product.

2 9GB HD in a RAID 1 - Suggested for the OS and LOGS
6 18GB HD in RAID 5  - Database
1 18GB HD Hot Spare

I realize that something of this nature would allow for a lot of disk 
through-put (I would think), but it doesn't really allow for a OFA 
configuration.


I should clarify at this time that there were two choices for the DB 
either Oracle or SQL Server, we chose Oracle.  I have a suspicion that 
this configuration is either intended to maximize database access, at the 
expense of recoverability or its the SQL Server version of OFA, or both.  
If it is both is there a way to provide for OFA and also maximize disk 
access?

BTW, I actually purchased a system with much more disk space than the 
above, 14 18gb HD and 2 9gb HD.



--
Howard County Public School System, Maryland, USA
[EMAIL PROTECTED]

The views expressed in this message do not represent the views of the 
Howard County Public School System, blaa, blaa, blaa.  You get the idea.

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

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

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

2001-07-10 Thread Tom Schruefer



This is the list for 8i:

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server
.817/a76962/ch4.htm

http://technet.oracle.com/doc/oracle8i_816/server.816/a76962/ch4.htm   

http://technet.oracle.com/doc/server.815/a68020/ch4.htm  


Although they are two different URL's the 8.1.6 and 8.1.7 pages look the 
same.  I haven't found anything for 9i yet.


Rachel Carmichael - [EMAIL PROTECTED] on 7/10/2001 12:25 PM writes us:


haven't found it in the concepts manual... can't remember where it was in 
the 8i docs


From: Orr, Steve [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: O9i Licensing
Date: Tue, 10 Jul 2001 06:05:25 -0800

Thanks Rachel. Is there any breakdown as to Enterprise Edition vs Standard
Edition features?

Steve


-Original Message-
Sent: Monday, July 09, 2001 7:21 PM
To: Multiple recipients of list ORACLE-L



According to the 9i concepts manual, there is a standard and enterprise
edition.


 From: Orr, Steve [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: O9i Licensing
 Date: Mon, 09 Jul 2001 15:36:30 -0800
 
 Anyone familiar with Oracle9i Licensing... is there still a standard
 edition
 versus an enterprise edition? At OpenWorld LEllison said there would only
 be
 two types of licenses for Oracle... the database server and the 
application
 server. If that's the case is there nolonger a standard vs enterprise
 license?
 
 On a related note, our sales rep said that 80% of Oracle's customer base 
is
 on standard edition and only 20% is on enterprise edition. A lot less
 enterprise licenses than I would have thought. I believe the recent
 decrease in license fees is only true for enterprise edition but 
actually
 could amount to a price increase for standard edition if you were using
 power units.
 
 Feeling like a second class citizen... stuck with standard edition and in
 need of transportable tablespaces, bitmapped indexes, function-based
 indexes, and PQO...
 Steve Orr
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Orr, Steve
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: Orr, Steve
   INET: [EMAIL PROTECTED]

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.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).

OT - get together for list participants in DC area

2001-07-10 Thread Mohan, Ross


It's possible, sure..good idea.

It may just wind up being you and I
Alex, in which case I can buy your beersif you don't mind the speedo. 

:)

-Original Message-
Sent: Monday, July 09, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L


There will be MAOP DBA SIG meeting on July 20 from 1 to 4PM in Reston Oracle
building. Details on www.maop.org  I am doing presentation about LMT,
temporary tablespaces and Global Temporary tables( very rude sel promo :-)).
I think it can be good opportunity to meet. After that we can go to get
couple of beers etc. I do not know that area very well, so any suggestions
welcome.

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

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

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

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

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

Re:RE: O9i Licensing


Walt,

Thanks man, my 401K can use the boost!!

Dick Goulet

Reply Separator
Author: Weaver; Walt [EMAIL PROTECTED]
Date:   7/10/2001 8:02 AM

Well, if you're lucky enough to use the Enterprise Edition you'll be saving
money. We use the Standard Edition, and at this time it looks like it's
going to cost us quite a bit more, actually, for a per-processor license. 

So, we're currently in delicate negotiations with our Oracle rep and various
resellers to see what kind of deal we can get. Fortunately we can still buy
licenses through the old power unit scheme through the end of July. Since
we're opening up a new hosting data center in New Jersey next month we're
gonna scarf up as many licenses as we can afford.

So, Larry, I got something you can smell right here.:)

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, July 10, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L

Steve,

I have heard nothing to suggest that Oracle is abandoning the standard
vs.
enterprise edition packaging.  What I have heard and read at Oracle.com is
that
they are abandoning the Universal Power Unit in favor of Per Processor
pricing. 
Namely there is today two license models that they offer and support, named
user and per processor.  

Thanks Larry!!  Knew you'd smell the roses/coffee sooner or later.

Dick Goulet
Senior Oracle DBA
Vicor Corporation

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

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

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

2001-07-10 Thread lhoska


Yes, it can.  Just rename it and there will be new one created with an old
name at some point.

-Original Message-
Sent: Tuesday, July 10, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

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

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

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

2001-07-10 Thread Unal Bilisim


Hello,

you can email me with zipped core file.



10/7/01 07:51:51, Jeffrey Beckstrom [EMAIL PROTECTED] wrote:




We have been running 8.1.7 for a couple weeks.  The clients are 8.1.6
still
 [EMAIL PROTECTED] 7/10/01 11:55:59 AM 
Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have
some
notablyunexplained errors connecting older versions to 8.1.7 - most
with large objects.

-Original Message-
[mailto:[EMAIL PROTECTED]]
To: Multiple recipients of list ORACLE-L


Hi,
I have just had the experience of upgrading to 81714, discovering a
in our application that did not show up in any testing and having to go
back
to 815.

have the 817 instance available for further troubleshooting.e and we still

This is on NT4.

With 817, we were getting ora-3113 in the forms application and in ODBC
connections and also seeing ora-03121 as well.
We got core dump files produced (under 817 they are produced on NT) but
Oracle support does not seem to know how to interpret them on NT - has
anyone had any experience with this?

files were produced in the user dump directory.within the alert log and no

When I turned sql trace on for the session running forms, the ora-3113 did
not occur - has anyone seen behaviour like this where SQL Trace will cause
an ora-3113 to stop occurring?
All suggestions on what to look for or how to interpret NT core dumps are
welcome.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message---
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
  INET: [EMAIL PROTECTED]

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



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

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

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

2001-07-10 Thread Kevin Lange


Yes.  Rename delete trimmedetc.

-Original Message-
Sent: Tuesday, July 10, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

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

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

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

RE: gzip does not want to work with files 2G

2001-07-10 Thread Richard Ji


I also uses gzip 1.3 on Solaris 8 (1999-12-21 build).  The one that comes with Solaris 
8 was 1.2.24 or something
which doesn't support file 2G.  Did you get rid of the old gzip 1.2.24?  Make sure 
it's using the new one that you installed not the old version.

 [EMAIL PROTECTED] 07/10/01 10:05AM 
I use version 1.3 for Solaris 5.8 - it is the same version that is on
www.sunfreeware.com What version do you use and for which version on
Solaris?


Alex Hillman

-Original Message-
Sent: Monday, July 09, 2001 10:46 PM
To: Multiple recipients of list ORACLE-L


What version of gzip are you using?  I had the same problem before, just had
to get the latest version.

Richard Ji

 [EMAIL PROTECTED] 07/09/01 07:12PM 
I have Solaris 5.8 angzip does not want to work with files  2G - tells that
file is too large. Anybody has any idea why?

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

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

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

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

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

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

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

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

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

2001-07-10 Thread Tommy Wareing


On Tue, Jul 10, 2001 at 05:26:09AM -0800, Sajid Iqbal wrote:

 I want to display the time elapsed between two dates - in days, hours,
 minutes and seconds.
 
 If I do select date1 - date2, the result is : 12.0194907
 
 Is there a function that will turn the number of days into something more
 legible?  Ideally i'd like to do ;
 
 to_char(12.0194907,'DD:HH:MI:SS') but obviously that won't work.  Is
 there a solution other than writing a complex function myself which will
 have to * by 24, / by 60 and substr etc to get the different bits of the
 number?

using a as your value (cos it's shorter to write)

trunc(a)||':'||to_char(trunc(sysdate)+a-trunc(a), 'HH24:MI:SS')

You could get away with using
to_char(a+to_date('31-Dec-00'), 'DD:HH24:MI:SS')
if you can ensure that 1 = a  32

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

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

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

2001-07-10 Thread Jon Walthour




Ron:

If you mean, Can the alert log be renamed for archiving purposes
while the db is up? the answer is yes. Oracle will just recreate
the alert log the next time it needs to write an entry to it.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

--- Original Message ---
From: Smith, Ron L. [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/10/01 10:56:31 AM


Can the alert log be renamed while the database is up and running?

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

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

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

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

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

2001-07-10 Thread Wolfe, Charles




Look in your $ORACLE_HOME/bin 
directory. There should be an "oemapp" executable. The OEM console 
is started by: "oemapp console".

hth

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 11:41 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OEM 2.2 client for Sun
  i dont know the answer to that one for sure, but its available for 
  linux(java based) so i'd think it should be available.
  
  joe
   [EMAIL PROTECTED] 07/10/01 09:45AM 
  
  Hi gurus, 
  We work with OEM 2.1 client on PC and Sun 
  stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stations). 
  I can't find OEM 2.2 client for Sun on 
  the Sun Solaris 8.1.7 CD pack, I can only find it for Windows. Is it just me 
  or does Oracle not release a client version for Sun? 
  TIA 
  - Luc Demanche CETELEM 
  Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88

RE: Rename alert log

2001-07-10 Thread Mercadante, Thomas F


In 816 on NT, you can rename it any time you want.

is this changing in 817 Rachel?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, July 10, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L


depends on the version of the database you are running.. it used to be that 
yes, you could just rename it and Oracle would open a new one of the 
original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an 
open file pointer to it, similar to the way it handles the listener log 
file. So you will need to do the same sort of tricks to the alert log as you

have to do to the listener log (make a copy then copy /dev/null to the 
original)



From: Smith, Ron L. [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Rename alert log
Date: Tue, 10 Jul 2001 06:56:31 -0800

Can the alert log be renamed while the database is up and running?

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

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

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

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: 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: help how get the n top rows for any table?

2001-07-10 Thread Stas


If you're running  Oracle8i,
you can do this: 
SELECT *
FROM  (SELECT * FROM my_table ORDER BY col_name_1
DESC)
WHERE  ROWNUM  10;

Use this workaround with prior releases: 
SELECT *
FROM my_table a
WHERE 10 = (SELECT COUNT(DISTINCT maxcol)
  FROM my_table b
  WHERE b.maxcol = a.maxcol)
 ORDER BY maxcol DESC
;

Hope this helps!







--- Alexander Ordonez [EMAIL PROTECTED] wrote:
 Hi, gurus!!!
 
 A need know how get n top row for any table somebody
 can help me!!
 
 Thanks!!!
 
 @lex


   Lic. Alexander Ordóñez Arroyo 
   Caja Costarricense del Seguro Social  
   
   Soporte Técnico - División de Informática 

   Telefono: 295-2004, San José, Costa Rica  
  
   [EMAIL PROTECTED]
 


 UNIX is very user friendly, 
 It's just very particular about who it makes friends
 with.
 
 
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Alexander Ordonez
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (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 personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stas
  INET: [EMAIL PROTECTED]

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

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

2001-07-10 Thread Witold . Iwaniec




Hi

The script below may help you - it will display different components in separate
columns, modify it with your two dates and proper table name and remove what you
don't need

select sysdate,
   sysdate - to_date('0307200100', 'DDMMHH24MISS') diffr,
trunc(sysdate - to_date('0307200100', 'DDMMHH24MISS')) days,
trunc(mod(sysdate - to_date('0307200100', 'DDMMHH24MISS'), 1) *
24) hrs,
trunc(mod(mod(sysdate - to_date('0307200100', 'DDMMHH24MISS'),
1) * 24, 1) * 60) min,
round(mod(mod(mod(sysdate - to_date('0307200100',
'DDMMHH24MISS'), 1) * 24, 1) * 60, 1) * 60) sec,
to_char(trunc(sysdate - to_date('0307200100', 'DDMMHH24MISS')))
|| ' ' ||
lpad(trunc(mod(sysdate - to_date('0307200100', 'DDMMHH24MISS'),
1) * 24), 2, '0') || ':' ||
lpad(trunc(mod(mod(sysdate - to_date('0307200100',
'DDMMHH24MISS'), 1) * 24, 1) * 60), 2, '0') || ':' ||
lpad(round(mod(mod(mod(sysdate - to_date('0307200100',
'DDMMHH24MISS'), 1) * 24, 1) * 60, 1) * 60), 2, '0') Difference
 from dual

HTH

Witold



Sajid Iqbal wrote:

 Hello All

 I want to display the time elapsed between two dates - in days, hours,
 minutes and seconds.

 If I do select date1 - date2, the result is : 12.0194907

 Is there a function that will turn the number of days into something more
 legible?  Ideally i'd like to do ;

 to_char(12.0194907,'DD:HH:MI:SS') but obviously that won't work.  Is
 there a solution other than writing a complex function myself which will
 have to * by 24, / by 60 and substr etc to get the different bits of the
 number?

 Please CC any replies directly to me at [EMAIL PROTECTED]

 Thanks in advance,
 Saj.

 --
 Sajid Iqbal
 Database Team Leader

 --






-- 
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: Client Connection-SQLNET and?/or? ODBC.

2001-07-10 Thread Miller, Jay


Hello James,

Every ODBC connection I've seen or used has connected through SQL Net
(i.e,., app-odbc-sqlnet-database).  But ODBC isn't really my area of
expertise...

Jay Miller

-Original Message-
Sent: Tuesday, July 10, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do ODBC, do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- ODBC itselfor
- ODBC through SQLNET?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

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

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

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

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

2001-07-10 Thread Jon Walthour




Sajid:

Try this piece. I use a version of it for my uptime.sql script:

TO_CHAR(TRUNC(date1 - date2)) || ' day(s), ' || TO_CHAR(TRUNC(MOD(date1
- date2 - 1, 1) * 24)) || ' hour(s), ' || TO_CHAR(TRUNC(((MOD(date1
- date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24)))
* 60)) || ' minute(s) and ' || TO_CHAR(ROUND(MOD(((MOD(date1
- date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24)))
* 60, 1) * 60, 1)) || ' seconds.'

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

--- Original Message ---
From: Sajid Iqbal [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 7/10/01 9:26:09 AM


Hello All

I want to display the time elapsed between two dates - in
days, hours,
minutes and seconds.

If I do select date1 - date2, the result is : 12.0194907

Is there a function that will turn the number of days into something
more
legible?  Ideally i'd like to do ;

to_char(12.0194907,'DD:HH:MI:SS') but obviously that won't
work.  Is
there a solution other than writing a complex function myself
which will
have to * by 24, / by 60 and substr etc to get the different
bits of the
number?

Please CC any replies directly to me at [EMAIL PROTECTED]

Thanks in advance,
Saj.



-- 
Sajid Iqbal
Database Team Leader



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

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

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

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

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