date:20010821


TWO_TASK is like ORACLE_SID, but it directs Oracle clients to resolve
via TNS rather than looking for that SID directly via BEQ.

So, if my SID is TEST on the local machine, and I do:

$ export ORACLE_SID=TEST
$ sqlplus system/manager

I will connect to the instance with a SID of TEST on the local machine.
But if Oracle is running on a remote machine, and I set up TNS name
TEST (in tnsnames.ora) for it, then try those commands, it will fail,
even tho'

$ sqlplus system/manager@TEST

will succeed. However, if I then do

$ export TWO_TASK=TEST
$ sqlplus system/manager

It will work as expected - the client will take the TNS name TEST to
be its default instance, and connect via TNS.

HTH,

g


-Original Message-
Sent: Tuesday, August 21, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L


Hello All,

Can anyone tell me what is the significance of the env variable
TWO_TASK?
when and where it is used etc ?

Thanks in advance
Uma
--
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: Significance of TWO_TASK

2001-08-21 Thread Rao, UmaSankara S (CAP)


Thanks a lot Guy for the explanation

-Original Message-
Sent: Tuesday, August 21, 2001 6:11 AM
To: Multiple recipients of list ORACLE-L


TWO_TASK is like ORACLE_SID, but it directs Oracle clients to resolve
via TNS rather than looking for that SID directly via BEQ.

So, if my SID is TEST on the local machine, and I do:

$ export ORACLE_SID=TEST
$ sqlplus system/manager

I will connect to the instance with a SID of TEST on the local machine.
But if Oracle is running on a remote machine, and I set up TNS name
TEST (in tnsnames.ora) for it, then try those commands, it will fail,
even tho'

$ sqlplus system/manager@TEST

will succeed. However, if I then do

$ export TWO_TASK=TEST
$ sqlplus system/manager

It will work as expected - the client will take the TNS name TEST to
be its default instance, and connect via TNS.

HTH,

g


-Original Message-
Sent: Tuesday, August 21, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L


Hello All,

Can anyone tell me what is the significance of the env variable
TWO_TASK?
when and where it is used etc ?

Thanks in advance
Uma
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, UmaSankara S (CAP)
  INET: [EMAIL PROTECTED]

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

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


Raja:

You will know you have freelist contention if you have a significant
buffer busy waits ratio (5%). 
 
Jon Walthour

-Original Message-
Luthra
Sent: Monday, August 20, 2001 11:45 PM
To: Multiple recipients of list ORACLE-L


Hello folks,

How do I come to know that there is a contention going on in the
freelists? Is there any v$ table or this type of contention you derive
from some other info. like a ripple effect from some parameter?

TIA.

raja


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

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

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

2001-08-21 Thread Bill Gentry


Please read the bottom of any e-mail on this list!


Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 20, 2001 3:04 PM


 Would some one please tell me how to sign-off this group. It was a
 pleasure to be in this excellent group in the past years. Thank you.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ben Le
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Bill Gentry
  INET: [EMAIL PROTECTED]

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

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

2001-08-21 Thread Rachel Carmichael


Here's a radical thought. You could actually go into sqlplus and do a select 
from the dba_errors or user_errors view. I realize that this is will cause 
many on this list to think of me as a dinosaur, ready to be relegated to the 
old DBAs home, but come on, if you are going to call yourself a DBA you 
should be able to look things up in the database WITHOUT a GUI tool.

I'll even be nice and give you the query:

log into sqlplus as the procedure owner

select * from user_errors order by line;

here's an example:

SQL create procedure this_is_bad
  2  as
  3select * from dual
  4  end;
  5
  5
  5  /

Warning: Procedure created with compilation errors.

SQL select * from user_errors order by line;

NAME TYPE  SEQUENCE  LINE  
POSITION
  - - 
-
TEXT
---
THIS_IS_BAD  PROCEDURE1 3
  3
PLS-00103: Encountered the symbol SELECT when expecting one of the 
following:

   begin function package pragma procedure subtype type use
   an identifier a double-quoted delimited-identifier cursor
   form current external language
The symbol begin was substituted for SELECT to continue.

THIS_IS_BAD  PROCEDURE2 4
  1
PLS-00103: Encountered the symbol END when expecting one of the following:

   . , @ ; for an identifier
   a double-quoted delimited-identifier group having intersect
   minus order partition start subpartition union where connect
   SAMPLE_
The symbol ; was substituted for END to continue.




From: Beatriz Martínez Jiménez [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: No errors showed in the DBA Studio
Date: Tue, 21 Aug 2001 01:21:37 -0800

Hello list,
Oracle 8.1.7. NT4.0
I have created some procedures in the DBA Studio, and when I try to
compile them I get that the procedure status is Invalid, but in the
'show error' window there is no message. The window appears but it´s
completely empty.
Could somebody tell me what happens? Do i Have to configure anything to
display this errors?
A lot of thanks,
 beamar.vcf 


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

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

Spool 32 Error

2001-08-21 Thread Huy_Le



We recently have Spool 32 Error message appear on almost all of computers
when user request printing. Could anyone share the experience why and how
to solve this problem. Thx.


Warmest regards,

Le Quang Huy
Manager -- Information Technology
Chinfon Manulife Insurance Company Limited
Diamond Plaza, 12fl, 34 Le Duan, District 1, Ho Chi Minh city, Vietnam
Phone: (848) 825 7722 Ext: 2999 --- Fax: (848) 825 7718 --- Mobile: (848)

==
This message is confidential and may also be privileged.  If you are not
the intended recipient, please notify me by return e-mail and delete this
message from your system.  If you are not the intended recipient, any use
by you of this message is strictly prohibited.

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

SQL Question

2001-08-21 Thread Bill Tantzen



Greetings!

I don't see a lot of general sql questions on this list, so if this is the
wrong place to post this sort of thing, just let me know!  This will
hopefully seem like a simple question, but I am a relative novice in sql
programming!

Here is the (simplified) scenario with three tables:

biblio table
id integer
isbn   varchar2
title  varchar2

subject table (0 or many per id)
id  integer  (fk biblio.id)
subject varchar2

keyword table (0 or many per id)
id  integer  (fk biblio.id)
keyword varchar2

I wish to find all the id's that contain a given word in any of the varchar
fields.  My approach has been something like:

select id from biblio
where title like '%word%'
union
select id from subject
where subject like '%word%'
union
select id from keyword
where keyword like '%word%'

First question:  do you think this is a good way to do it?  Is there a
better way?
Second question, how do I do a negative search, that is, find all the id's
that DO NOT contain a given word in any of the varchar fields.  Using an
approach similar to the previous sql (using intersect instead of union) does
not work, since there may be biblio records that do not have corresponding
subject or keyword records.

Perhaps there is not a simple query that will do the trick and I should be
using a stored procedure?

Thanks in advance for any advice
Bill

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

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

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




Jon, sorry it was a 9i thing.

joe
 [EMAIL PROTECTED] 08/20/01 10:10PM 

Joe:

Can you tell me if you were able to do this? 
I just tried it and it errored out on me:

SQL create 
table test_lob (col1 varchar2(30), col_lob long);

Table 
created.

SQL desc 
test_lobName 
Null? Type- 
 
COL1 
VARCHAR2(30)COL_LOB 
LONG

SQL alter table 
test_lob modify col_lob clob;alter table test_lob modify col_lob 
clob 
*ERROR at line 1:ORA-22858: invalid alteration of 
datatype

Thanks,

Jon 
Walthour

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of JOE TESTASent: 
  Monday, August 20, 2001 4:26 PMTo: Multiple recipients of list 
  ORACLE-LSubject: changing long to lob
  while looking thru the migration guide(for downgrade info in case it 
  happens),
  
  alter table table_name modify long_col clob;
  
  and supposedly POOF its now a clob.
  
  interesting.
  
  joe

RE: DBA tasks


Y'know, like Captain Kirk in Star Trek does. This is a wholesome family
mailing list!!

g


-Original Message-
Sent: Monday, August 20, 2001 6:52 PM
To: Multiple recipients of list ORACLE-L


At 01:38 PM 8/20/2001, Rachel Carmichael wrote:
ahem... get the girl

lol

well, now, they didn't define get now did they?;-)




--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

One ping to rule them all,
One ping to find them,
One ping to bring them all,
And in the MUTX bind them.

Quote will be inserted here



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

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

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

2001-08-21 Thread Gene Sais


Lisa - Use perl.  Thats the nice thing about perl, it runs on almost all OS's.  And 
its FREE :)

Gene

 [EMAIL PROTECTED] 08/20/01 12:37PM 


Lisa,
I use Tcl and OraTcl  that comes with Oracle Enterprise Manager.
Chaim




Koivu, Lisa [EMAIL PROTECTED] on 08/19/2001 05:15:21 PM

Please respond to [EMAIL PROTECTED] 

To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)




Bonjour,

I've been digging around for scripting documentation on w2k.  Microsoft's
website talks about Jscript and vbscript and xml - none of which are my
strengths and all look like they are much more complicated than I need.  I
need to find a scripting language that will allow me to do simple things on
w2k - fire export, fire backup, send me email/pages, etc.  If I wanted to
learn another language,  I'd sit down and learn Perl, not
xml/VBscript/Jscript!

Can anyone point me to a scripting language they have used on w2k?  All my
scripts were in ksh...  I may just bite the bullet and learn Perl anyway.
I've got more than enough time.

Thanks in advance to anyone with suggestions
Lisa Koivu
Oracle Database Administrator
Ft. Lauderdale, FL, USA


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

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

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

2001-08-21 Thread Jamadagni, Rajendra


In 8i you can use ... (straight from SQL reference manual)

TO_LOB

Purpose Converts LONG or LONG RAW values in the column long_column to LOB
values. You can apply this function only to a LONG or LONG RAW column, and
only in the SELECT list of a subquery in an INSERT statement (see INSERT
on page 7-512).
Before using this function, you must create a LOB column to receive the
converted LONG values. To convert LONGs, the LOB column must be of type CLOB
or NCLOB. To convert LONG RAWs, the LOB column must be of type BLOB.

TO_LOB ( long_column )

Example Given the following tables:

CREATE TABLE long_table (n NUMBER, long_col LONG);
CREATE TABLE lob_table (n NUMBER, lob_col CLOB);

use this function to convert LONG to LOB values as follows:

INSERT INTO lob_table
SELECT n, TO_LOB(long_col) FROM long_table;

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 ! 

*2

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

*2

-- 
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: SQL Question

2001-08-21 Thread nlzanen1



Hi,


How 'bout not like

these querries will always use a full tablescan though.

Quicker ways? maybe the oracle context search or something like that
anyway, but I've never used it.


Jack


   
  
Bill Tantzen 
  
[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
mn.edu  cc:   
  
Sent by: Subject: SQL Question 
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
21-08-2001 
  
15:06  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Greetings!

I don't see a lot of general sql questions on this list, so if this is the
wrong place to post this sort of thing, just let me know!  This will
hopefully seem like a simple question, but I am a relative novice in sql
programming!

Here is the (simplified) scenario with three tables:

biblio table
id integer
isbn   varchar2
title  varchar2

subject table (0 or many per id)
id  integer  (fk biblio.id)
subject varchar2

keyword table (0 or many per id)
id  integer  (fk biblio.id)
keyword varchar2

I wish to find all the id's that contain a given word in any of the varchar
fields.  My approach has been something like:

select id from biblio
where title like '%word%'
union
select id from subject
where subject like '%word%'
union
select id from keyword
where keyword like '%word%'

First question:  do you think this is a good way to do it?  Is there a
better way?
Second question, how do I do a negative search, that is, find all the id's
that DO NOT contain a given word in any of the varchar fields.  Using an
approach similar to the previous sql (using intersect instead of union)
does
not work, since there may be biblio records that do not have corresponding
subject or keyword records.

Perhaps there is not a simple query that will do the trick and I should be
using a stored procedure?

Thanks in advance for any advice
Bill

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

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

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




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

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

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid

RE: SQL Question

2001-08-21 Thread Amar Kumar Padhi


Your method is correct. The only issue is if you are processing huge amount
of data, this will take some (may be lot of) time.  You can use not like
option for DO NOT contain query.
...
where title not like '%word%'

rgds
amar

-Original Message-
Sent: Tuesday, August 21, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L



Greetings!

I don't see a lot of general sql questions on this list, so if this is the
wrong place to post this sort of thing, just let me know!  This will
hopefully seem like a simple question, but I am a relative novice in sql
programming!

Here is the (simplified) scenario with three tables:

biblio table
id integer
isbn   varchar2
title  varchar2

subject table (0 or many per id)
id  integer  (fk biblio.id)
subject varchar2

keyword table (0 or many per id)
id  integer  (fk biblio.id)
keyword varchar2

I wish to find all the id's that contain a given word in any of the varchar
fields.  My approach has been something like:

select id from biblio
where title like '%word%'
union
select id from subject
where subject like '%word%'
union
select id from keyword
where keyword like '%word%'

First question:  do you think this is a good way to do it?  Is there a
better way?
Second question, how do I do a negative search, that is, find all the id's
that DO NOT contain a given word in any of the varchar fields.  Using an
approach similar to the previous sql (using intersect instead of union) does
not work, since there may be biblio records that do not have corresponding
subject or keyword records.

Perhaps there is not a simple query that will do the trick and I should be
using a stored procedure?

Thanks in advance for any advice
Bill

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

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

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

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

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


Thanks for the information. How does your mainframe guy 
get the data out of IMS?

Thanks,
Ken
 We do not pull data directly from IMS but load it in batch jobs.  Our
 mainframe guy either dumps the data report-style (ASCII) or copies records
 in native EBCDIC to files on the mainframe.  We ftp them to the Oracle side
 (binary mode to EBCDIC files) and use sql loader to move into Oracle.  On
 the files that come over in EBCDIC, I use sqlloader with the following in
 the control file.  There are a few bugs with loading EBCDIC (search
 metalink)  but we manage to get it loaded.
 
 
 
 LOAD DATA
 CHARACTERSET WE8EBCDIC500
 INFILE 'e:\filename.dat' fix 688 
 ...
 
 
 
 
 
 -Original Message-
 Sent: Friday, August 17, 2001 9:37 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I may be moving data from an IMS db which is stored in 
 EBCDIC.  Oracle stores data in ASCII format.  How do I 
 go about converting EBCDIC to ASCII to store the data in 
 Oracle (8.1.?)?
 
 Thanks,
 Ken Janusz, CPIM
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Bond Mike A Contr OC-ALC/TILC
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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).

High DML Table - I/O Suggestions???

2001-08-21 Thread Walter K


Sorry to repost this, but I just lost all of my email
from the past two days. Arghh!

I have a table that is ~100Mb in size. The table will
always contain 500,000 to 1,000,000 records in it at
any given time and approximately that number of
inserts, updates and deletes will be performed against
it on a daily basis. Only one user will be performing
the DML operations on the table and that will be via a
background process (i.e. daemon).

The table has no foreign keys nor a primary key but it
may require an index or two because of the updates and
deletes. Unfortunately, I can't put the table on a
dedicated disk and I am stuck with Raid-5.

My question is, what suggestions does anyone have to
offer that will give me the best possible I/O in this
case? Is trying to put this table in a Keep pool going
to help at all?

Thanks again for your advise (and patience).
-w

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter 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).

Re: Converting EBCDIC to ASCII


Thanks for the help. How did you create the flat files?  
How did you get the data out of IMS and into the flat 
files?  TCP/IP or SQL Loader or what?

Thanks,
Ken
 
 I did it by creating flat files containing only character data (no packed
 fields),
 and using sqlloader to load the data.
 
 I think the only thing Oracle didn't know how to convert was the verticle bar
 ( | )
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mike J Kurth
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: net 8 / 8i ?

2001-08-21 Thread A. Bardeen


Darren,

Paul has made some excellent points.  

Just keep in mind that only versions 8.1.6 and later
are supported on Win2K.  

I'm not saying earlier versions *won't* work (I have
the 7.3.4 client running on Win2K), only that if you
find yourself in a situation where you're getting
bizarre behavior the first thing that OWS is likely to
tell you to do is to move to a supported
configuration.

HTH,

-- Anita

--- Paul Drake [EMAIL PROTECTED] wrote:
 Browett, Darren wrote:
  
  We are running 8.0.5 and due to upgrade fatigue on
 our applications, we are
  at least one year away before we upgrade
  to 8i and/or possibly 9i.
  
  But we are upgrading our desktops to windows 2000.
  
  The question I have,
  
  1. Should I install the net 8.0 client on the base
 image and upgrade it to
  8i later  ?
  or
  2. Should I go ahead and install the 8i client on
 the base image and be done
  with it.
  
  The larger question being will the 8i client work
 with the 8.0 databases ??
  
  Any tips, suggestions, experiences would be
 greatly appreciated
  
  Thank you in advance
  
  Darren
  
 
 What's behind door #3?
 
 Are you planning to move the server binaries to
 8.0.6 in the meantime,
 as I believe that 8.0.6 has several weeks of support
 (error correction)
 left. (See Note:118156.1) 
 At least Extended Maintenance Support is available
 for 8.0.6.
 
 The 8.1.7 Client Install as Application User is
 around 150 MB. Kinda
 big.
 Will you be using Java for anything anytime soon?
 No?
 Do you forecast needing to run Net8 over SSL soon?
 No?
 Do you see moving to an LDAP solution for
 authentication? No?
 Will you be deploying the Oracle Client on Pentium
 IV desktops? No?
 How soon will MS Windows XP be deployed? Never?
 
 Since you're deploying images to desktops - I'd
 stick with the 8.0
 client.
 
 just my opinion.
 
 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).

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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).

User access within/outside of app

2001-08-21 Thread Larry Hahn


List,

We have purchased a system where users login through
an ODBC connection using a generic Oracle userid. This
userid has full rights to do insert, update, delete,
select on any table in the schema. The app asks for
another username and password which checks the
application security table, which limits what areas of
the apps they can access. 

Although this may work fine for the app, the users
also have the ability to use Access and other ODBC
compliant programs to look at the data. When doing so,
they use the same ODBC DSN and, what do you know, they
have capabilities beyond their wildest imagination. 

This is obviously not a situation I want to implement.
I am looking for a way to allow a user into the app to
do their normal work, but only allow read access for
anything outside the app. 

Any suggestions or ideas would be more than welcome.

Thanks,

Larry Hahn
Journal Sentinel, Inc. 

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Hahn
  INET: [EMAIL PROTECTED]

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

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


Thanks for the help.  Oracle will be located on a W/2000 
box.

Could you go into more detail on how one exports data 
from IMS on the mainframe to flat textfiles?

Thanks,
Ken  
 
  
  If you export the IMS data out to flat textfiles,
  and then transfer them via ftp in ASCII mode, the
  conversion will be done automagically for you.
  
  Alternatively if on Unix the dd utility will
  do the conversion for you.
 
 
 One problem that we encountered with using dd to convert EBCDIC to
 ASCII (in a completely different situation so it might not apply here)
 is that brackets came out as the characters having octal values 342
 and 343 in ASCII.
 
 
 Pat
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Pat Hildebrand
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
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: Spool 32 Error




because there isnt 32 days in any month, sounds like a windoze error.

joe
 [EMAIL PROTECTED] 08/21/01 09:30AM 
We recently have Spool 32 Error message appear on almost all 
of computerswhen user request printing. Could anyone share the experience 
why and howto solve this problem. Thx.Warmest regards,Le 
Quang HuyManager -- Information TechnologyChinfon Manulife Insurance 
Company LimitedDiamond Plaza, 12fl, 34 Le Duan, District 1, Ho Chi Minh 
city, VietnamPhone: (848) 825 7722 Ext: 2999 --- Fax: (848) 825 7718 --- 
Mobile: 
(848)==This 
message is confidential and may also be privileged. If you are notthe 
intended recipient, please notify me by return e-mail and delete thismessage 
from your system. If you are not the intended recipient, any useby you 
of this message is strictly prohibited.-- 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-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: DBA tasks

2001-08-21 Thread Kevin Kostyszyn


Sorry, but that made me think of a funny site.  I found this a while back,
it's pretty funny reading.
http://www.grudge-match.com/History/ensign-stormtrooper.shtml

It's the red shirt dudes from star trek that always die when they go down to
a planet vs the storm troopers who couldn't hit the pacific ocean with a
shot from their blaster!!
KK

-Original Message-
Sent: Tuesday, August 21, 2001 10:01 AM
To: Multiple recipients of list ORACLE-L


Y'know, like Captain Kirk in Star Trek does. This is a wholesome family
mailing list!!

g


-Original Message-
Sent: Monday, August 20, 2001 6:52 PM
To: Multiple recipients of list ORACLE-L


At 01:38 PM 8/20/2001, Rachel Carmichael wrote:
ahem... get the girl

lol

well, now, they didn't define get now did they?;-)




--
Bill Shrek Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

One ping to rule them all,
One ping to find them,
One ping to bring them all,
And in the MUTX bind them.

Quote will be inserted here



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

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

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

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

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

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

Apologies... linux Oracle

Title: Apologies... linux  Oracle





Sorry everyone, I know you were just discussing this recently. 


What is the most stable combination of Oracle  Linux? What would you recommend? I want to say the consensus was SCO Linux but I don't quite remember. 

Thank you


Lara Croft
Oracle Database Administrator 
Fairfield Resorts, Inc

foreign key constraints


Let's say I had two tables:

CREATE TABLE t1 (
col1 NUMBER PRIMARY KEY);

CREATE TABLE t2 (
col2 REFERENCES t1(col1),
col3 VARCHAR2(40));


Then I ran the query:

select a.table_name, b.table_name, b.column_name from user_constraints
a, user_cons_columns b where a.r_constraint_name = b.constraint_name and
a.constraint_type='R';

I will get back a result set containing

a.table_name = t2
b.table_name = t1
b.column_name = col1

But what query would I run to find col2?

Thanks,

g



--
Guy Hammond
AVT Technologies
12-16 Westland Place
London N1 7LP UK

Email: [EMAIL PROTECTED]
Office: +44 (0) 207 454 1224
Mobile: +44 (0) 7966 164687

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

Nolog writes log ?

2001-08-21 Thread Aldi Barco


Hi,
I have Emp table NOLOGGING.
Does it write to log files the insert,update,delete activity on that table ?
Tia

Aldi


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

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

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

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

2001-08-21 Thread Johnson Poovathummoottil


Bufer busy waits can also be caused by parallel query
servers trying to read the same buffer block at the
same time. So does it always indicate a freelist
problem?
.
--- Jon Walthour [EMAIL PROTECTED] wrote:
 Raja:
 
 You will know you have freelist contention if you
 have a significant
 buffer busy waits ratio (5%). 
  
 Jon Walthour
 
 -Original Message-
 Luthra
 Sent: Monday, August 20, 2001 11:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hello folks,
 
 How do I come to know that there is a contention
 going on in the
 freelists? Is there any v$ table or this type of
 contention you derive
 from some other info. like a ripple effect from some
 parameter?
 
 TIA.
 
 raja
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Viraj Luthra
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

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

2001-08-21 Thread Gogala, Mladen


You have to learn to listen to your database, grasshoppa'. A good 
alternative to the Buddhist and kung fu techniques is the v$waitstat 
table. If you see accumulating time for 'extent map' or 'free list', 
then you know that you have to rebuild the table with more free lists.
To see the actual segments you'll have to use v$session_wait, v$access,
v$bh and some other beautiful v$ tables.



 -Original Message-
 From: Viraj Luthra [mailto:[EMAIL PROTECTED]]
 Sent: Monday, August 20, 2001 11:45 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Freelist Contention
 
 
 Hello folks,
 
 How do I come to know that there is a contention going on in 
 the freelists? Is there any v$ table or this type of 
 contention you derive from some other info. like a ripple 
 effect from some parameter?
 
 TIA.
 
 raja
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Viraj Luthra
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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).

What is in archive log...

2001-08-21 Thread Aldi Barco


Hi Lister,

Can we read what activities are in archive log files ?
(utility like 'tkprof' to read trace file).
Tia.

Aldi


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

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

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

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

2001-08-21 Thread Kumanan Balasundaram


I was bitten but this badly and thanks to all those people who 
helped me. This may some of you, so I'm posting it.

Scenario:
I wanted to extract one table as of a time the previous day. So I decided 
to recover to the closest time as possible before the unwanted change 
was made.
This meant that I only wanted two application tablespaces (data and 
index) out of many. 

As I was told its possible, I assumed it would be OK if I went with the 
basics - system TS data files, RBS (3 out of 4 files), the datafiles of the 
application TS's and even member of each redo-logs group .

I recreated the control file, did the recovery to the point in time and
opened it. 
Now when I did a select on any object, I was hit with the following:

ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-0: name for data file 2 is unknown - rename to correct file
ORA-01110: data file 2: '/emc/vol1/oracle/product/8.1.6/dbs/MISSING2'

I tried recovering again with all the RBS files as the last one also had
online 
public rollback segments.
That also didn't help and file2 was constantly being a pain - checking 
dba_data_files showed that it was belonging to the TOOLS tablespace.
On closer examination I discovered it had 237 SYS and SYSTEM 
objects. 

Another DBA must have loaded these objects in TOOLS t/s.
Recovering DB with tools and the other essentials resolved the problem.

So, watch out for this in the future.

Kumanan Balasundaram
Database Administrator, IT
QXL ricardo plc
www.qxl.com
P: +44 (0)208 962 7409

 QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road,
 London W6 9DP
 Registered in England No 3430894 VAT number - GB 701 8915 43
 
 The information transmitted is intended only for the person or entity to
 which it is addressed and may contain confidential and/or privileged
 material.  Any review, retransmission, dissemination or other use of, or
 taking of any action in reliance upon, this information by persons or
 entities other than the intended recipient is prohibited.   If you
 received  this in error, please contact the sender and delete the material
 from any computer


**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]

This footnote also confirms that this email message has been swept by
MIMEsweeper and Nortons Anti-Virus, for the presence of computer viruses.

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

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

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

2001-08-21 Thread Igor Neyman


Read Docs about LogMiner.

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


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 11:41 AM


 Hi Lister,

 Can we read what activities are in archive log files ?
 (utility like 'tkprof' to read trace file).
 Tia.

 Aldi


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

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

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

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

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

2001-08-21 Thread Li, Xiangli


 Hi, DBAs
Just wonder if there is any good oracle training programs for oracle
performence tuning, backuprecovery etc. ?

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

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

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

2001-08-21 Thread VIVEK_SHARMA



We got Some Error ( Forget the Exact Error Number NOW ) on Oracle
8.1.7.1 with CURSOR_SHARING=FORCE 

We Applied the Patch 8.1.7.2  the Error was Resolved


 -Original Message-
 From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, August 20, 2001 10:58 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: WARNING: CURSOR_SHARING=FORCE on 8.1.7
 
 I think I need to have a chat with Kevin when I see him at the NYOUG 
 meeting...
 
 I'm on 8.1.6 and have been using CURSOR_SHARING=FORCE for about a
 year. No 
 problems. Admittedly, we don't do too many complicated queries and we 
 analyze all tables and don't use hints...
 
 
 From: Jesse, Rich [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: WARNING: CURSOR_SHARING=FORCE on 8.1.7
 Date: Mon, 20 Aug 2001 07:05:29 -0800
 
 Hi all,
 
 Just thought I'd share an experience (ON-TOPIC!) with everyone.
 After
 upgrading from 8.0.6 to 8.1.7 on HP/UX 11.0, we've had a few problems
 with
 CURSOR_SHARING=FORCE.  The reason I decided to use it is because our
 apps
 don't use bind variables and I wanted to decrease the size of our
 shared
 pool to help reduce latch contention.  I figured this was the *easy*
 solution!
 
 Well, after almost three weeks, we're OK, but there is one lingering
 occasional problem.  Under certain circumstances (I can't seem to get
 what
 exactly those are), specific DML will always generate an ORA-12704
 character set mismatch error when using CURSOR_SHARING=FORCE and
 CBO.
 Oracle knows about this and say it's fixed in 9i.  However, they also
 say
 that a backport of the fix to 8.1.7 is not feasible.  sigh
 
 One common theme in the offending DML seems to be the use of
 functions in a
 GROUP BY or ORDER BY clause, but it's not consistent.  However,
 Oracle
 Support was able to consistently reproduce the error.  I've attached
 the
 output from the script (set echo on) in case anyone is interested in
 testing.  Note however that not all SQL I've had blow up with this
 uses the
 ORDERED hint or deals with unanalyzed tables.  Also note that Oracle 
 Support
 says the workaround is to ALTER SESSION SET CURSOR_SHARING=EXACT for
 each
 problem statement.
 
 And last week I went to a quickie seminar with Kevin
 Loney/TUSC/Veritas,
 where Kevin recommended waiting for 9i before using
 CURSOR_SHARING=FORCE.
 sigh  Now I think I'll need to plan how I'm going to turn it off:
 How 
 big
 to make the shared pool?  Do I now use histograms?  etc.  Like I
 didn't 
 have
 enough to do...
 
 Hope this helps someone else planning an upgrade to 8i!  :)
 
 Rich Jesse  System/Database Administrator
 [EMAIL PROTECTED] Quad/Tech International, Sussex,
 WI USA
 
 
 
  CS_FORCE.txt 
 
 
 _
 Get your FREE download of MSN Explorer at
 http://explorer.msn.com/intl.asp
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 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: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

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

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

Re: Memory Sizing

2001-08-21 Thread Yosi Greenfield


Did you maybe use a different init file? Did you check the
parameters in your email from sql or from the init file you
think you're using to start the database?

Just a sanity check, I'm sure you did all the right things...



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

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

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




an assumption is made that the same 2 teachers are not teaching subject 102 
and 105 for if they were then, only 2 teachers would be getting raises.

but if you go with 4 different teachers are teaching that class(2 groups of 
2) then answer c would be correct.

I think C SHOULD say at least 2 teachers will be getting a raise.

but thats just my opinion. :)

joe

 [EMAIL PROTECTED] 08/21/01 12:25PM I am 
taking the Self-Test software test for the SQL exam and don't see how they 
get the answer to this problem. They don't explain how it is arrived 
at.Any help you can give me will be appreciated.Thanks,Ken 
Janusz, CPIM--Examine the 
structure of the TEACHER table:Name  
  Null?  
TypeID   
 NOT NULL 
NUMBER(9)SALARY   
   
NUMBER(7,2)SUBJECT_ID  
 NOT NULL 
NUMBER(3)SUBJECT_DESCRIPTION  
 VARCHAR2(2)There are 200 teachers and 15 
subjects. Each subject is taughtby at least 2 
teachers.Evaluate this PL/SQL 
block:DECLARE v_pct_raise 
 number := 1.10;BEGIN 
UPDATE  teacher 
SET  salary = salary * 
1.10 WHERE  subject_id 
IN (102, 105); COMMIT;END;Which result will 
the PL/SQL block provide?(A) Only two teachers will receive a 10% salary 
increase.(B) All of the teachers will receive a 10% salary 
increase.(C) At least four teachers will receive a 10% salary 
increase.(D) A syntax error will occur.Answer:(C) 
-- 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-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: SQL Question

2001-08-21 Thread Bill Tantzen


-
- Your method is correct. The only issue is if you are processing
- huge amount
- of data, this will take some (may be lot of) time.  You can use not like
- option for DO NOT contain query.
- ...
- where title not like '%word%'

If you are suggesting a query such as:

select id from biblio
where title not like '%word%'
intersect
select id from subject
where subject not like '%word%'
intersect
select id from keyword
where keyword not like '%word%'

I don't believe this will work.  Let's say you have a title that satisfies
the query, that is it doesn't contain word  If no child records in the
subject or keyword tables exist, the intersect will elimimate this valid id
from the results.

Or am I not understanding something?

And yes, I can see what you mean already about taking lots of time -- even
for a rather small amount of data!!

Bill T.

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

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

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

RE: SQL Question

2001-08-21 Thread Lord, David - CS


Bill

You can do this with intermedia text, but I wouldn't recommend it unless: a)
your tables are big; b) you need to do this all the time; and c) doing it
the way you suggested is too slow.

Essentially, this involves creating an IMT index on biblio.title that
actually indexes biblio.title, subject.subject and keyword.keyword, all
concatenated together - see the IMT Reference - 3 Indexing - Datastore
Objects - USER_DATASTORE for details and an example.

Regards
David Lord

 -Original Message-
 From: Bill Tantzen [mailto:[EMAIL PROTECTED]]
 Sent: 21 August 2001 14:06
 To: Multiple recipients of list ORACLE-L
 Subject: SQL Question
 
 
 
 Greetings!
 
 I don't see a lot of general sql questions on this list, so 
 if this is the
 wrong place to post this sort of thing, just let me know!  This will
 hopefully seem like a simple question, but I am a relative 
 novice in sql
 programming!
 
 Here is the (simplified) scenario with three tables:
 
 biblio table
 id integer
 isbn   varchar2
 title  varchar2
 
 subject table (0 or many per id)
 id  integer  (fk biblio.id)
 subject varchar2
 
 keyword table (0 or many per id)
 id  integer  (fk biblio.id)
 keyword varchar2
 
 I wish to find all the id's that contain a given word in any 
 of the varchar
 fields.  My approach has been something like:
 
 select id from biblio
 where title like '%word%'
 union
 select id from subject
 where subject like '%word%'
 union
 select id from keyword
 where keyword like '%word%'
 
 First question:  do you think this is a good way to do it?  Is there a
 better way?
 Second question, how do I do a negative search, that is, find 
 all the id's
 that DO NOT contain a given word in any of the varchar 
 fields.  Using an
 approach similar to the previous sql (using intersect instead 
 of union) does
 not work, since there may be biblio records that do not have 
 corresponding
 subject or keyword records.
 
 Perhaps there is not a simple query that will do the trick 
 and I should be
 using a stored procedure?
 
 Thanks in advance for any advice
 Bill
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Bill Tantzen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Lord, David - CS
  INET: [EMAIL PROTECTED]

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

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


Actually, I have it:

select a.table_name, b.table_name, b.column_name, c.column_name from
user_constraints a, user_cons_columns b, user_cons_columns c where
a.r_constraint_name = b.constraint_name and a.constraint_name =
c.constraint_name and b.column_name != c.column_name  and
a.constraint_type='R';

:0)

g


  -Original Message-
 From: Guy Hammond  
 Sent: Tuesday, August 21, 2001 2:44 PM
 To:   '[EMAIL PROTECTED]'
 Subject:  foreign key constraints
 
 Let's say I had two tables:
 
 CREATE TABLE t1 (
   col1 NUMBER PRIMARY KEY);
 
 CREATE TABLE t2 (
   col2 REFERENCES t1(col1),
   col3 VARCHAR2(40));
 
 
 Then I ran the query:
 
 select a.table_name, b.table_name, b.column_name from user_constraints
 a, user_cons_columns b where a.r_constraint_name = b.constraint_name
 and a.constraint_type='R';
 
 I will get back a result set containing
 
 a.table_name = t2
 b.table_name = t1
 b.column_name = col1
 
 But what query would I run to find col2?
 
 Thanks,
 
 g
 
 
 
 --
 Guy Hammond
 AVT Technologies
 12-16 Westland Place
 London N1 7LP UK
 
 Email: [EMAIL PROTECTED]
 Office: +44 (0) 207 454 1224
 Mobile: +44 (0) 7966 164687
 
--
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: No errors showed in the DBA Studio




Yea but what happens when you need to perform something that you dont have 
a gui tool for?

then you really will look like a BAD(and no not bad slang as in good) 
DBA.

joe [EMAIL PROTECTED] 08/21/01 12:01PM A 
lot of thanks Rachel,it helps me a lot, although I would prefer to use a GUI 
tool (despite of looking like abad DBA).Thank you,Rachel 
Carmichael wrote: Here's a radical thought. You could actually go 
into sqlplus and do a select from the dba_errors or user_errors view. I 
realize that this is will cause many on this list to think of me as a 
dinosaur, ready to be relegated to the old DBAs home, but come on, if 
you are going to call yourself a DBA you should be able to look things 
up in the database WITHOUT a GUI tool. I'll even be nice and 
give you the query: log into sqlplus as the procedure 
owner select * from user_errors order by line; 
here's an example: SQL create procedure 
this_is_bad 2 as 
3 select * from dual 4 
end; 5 5 5 
/ Warning: Procedure created with compilation 
errors. SQL select * from user_errors order by 
line; 
NAME 
TYPE 
SEQUENCE LINE POSITION 
  - 
- - TEXT 
--- 
THIS_IS_BAD 
PROCEDURE 
1 
3 3 PLS-00103: Encountered 
the symbol "SELECT" when expecting one of the 
following: begin function package pragma 
procedure subtype type use an identifier a 
double-quoted delimited-identifier cursor form 
current external language The symbol "begin" was substituted for 
"SELECT" to continue. 
THIS_IS_BAD 
PROCEDURE 
2 
4 1 PLS-00103: Encountered 
the symbol "END" when expecting one of the 
following: . , @ ; for an 
identifier a double-quoted 
delimited-identifier group having intersect minus 
order partition start subpartition union where connect 
SAMPLE_ The symbol ";" was substituted for "END" to 
continue. From: Beatriz Martínez Jiménez 
[EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] Subject: No errors showed in the DBA 
Studio Date: Tue, 21 Aug 2001 01:21:37 -0800  
Hello list, Oracle 8.1.7. NT4.0 I have created some 
procedures in the DBA Studio, and when I try to compile them I get 
that the procedure status is Invalid, but in the 'show error' window 
there is no message. The window appears but it´s completely 
empty. Could somebody tell me what happens? Do i Have to configure 
anything to display this errors? A lot of 
thanks,  beamar.vcf  
_ Get 
your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp 
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 
Author: 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: How do they get the answer?

2001-08-21 Thread Hallas John

Title: RE: How do they get the answer?





My thoughts are


Typical OCP question.
a) Could be the answer depending on if both the subjects are taught by the same 2 teachers
b) Cannot be the answer because only 2 subjects are mentioned (102,105)
c) Could be the answer if the 2 subjects are taught by 4 different teachers (not it cannot be more than 4 therefor the 'at least 4' is misleading

d) If a syntax error did occur you would correct and run again so why you should fail the OCP question for that reason is bizarre anyway.


John


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 21 August 01 17:26
To: Multiple recipients of list ORACLE-L
Subject: How do they get the answer?



I am taking the Self-Test software test for the SQL exam 
and don't see how they get the answer to this problem. 
They don't explain how it is arrived at.


Any help you can give me will be appreciated.


Thanks,
Ken Janusz, CPIM


--


Examine the structure of the TEACHER table:


NameNull?  Type
IDNOT NULL NUMBER(9)
SALARY  NUMBER
(7,2)
SUBJECT_ID   NOT NULL NUMBER(3)
SUBJECT_DESCRIPTION   VARCHAR2(2)


There are 200 teachers and 15 subjects. Each subject is 
taught
by at least 2 teachers.


Evaluate this PL/SQL block:


DECLARE
 v_pct_raise  number := 1.10;
BEGIN
 UPDATE  teacher
 SET  salary = salary * 1.10
 WHERE  subject_id IN (102, 105);
 COMMIT;
END;


Which result will the PL/SQL block provide?


(A) Only two teachers will receive a 10% salary increase.
(B) All of the teachers will receive a 10% salary 
increase.
(C) At least four teachers will receive a 10% salary 
increase.
(D) A syntax error will occur.


Answer:
(C) 



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




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

RE: MOVE Tables from One Tablespace to Another Tablespace !!

2001-08-21 Thread Christopher Spence


But make sure you rebuild indexes afterwards.


Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 4:26 AM
To: Multiple recipients of list ORACLE-L


8i - alter tbale move tablespace new_tbs

 --
 From: Dash, Saroj  (CAP,CEF)[SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Tuesday, August 21, 2001 3:15 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  MOVE Tables from One Tablespace to Another Tablespace !!
 
 
 Hello All,
 
 
 Please tell me the detailed steps to move tables from one tablespace 
 to another tablespace.
 
 Regards,
 Saroj.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Dash, Saroj  (CAP,CEF)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L (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: Rahul
  INET: [EMAIL PROTECTED]

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

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

2001-08-21 Thread Beatriz Martínez Jiménez


A lot of thanks Rachel,
it helps me a lot, although I would prefer to use a GUI tool (despite of looking  like 
a
bad DBA).
Thank you,

Rachel Carmichael wrote:

 Here's a radical thought. You could actually go into sqlplus and do a select
 from the dba_errors or user_errors view. I realize that this is will cause
 many on this list to think of me as a dinosaur, ready to be relegated to the
 old DBAs home, but come on, if you are going to call yourself a DBA you
 should be able to look things up in the database WITHOUT a GUI tool.

 I'll even be nice and give you the query:

 log into sqlplus as the procedure owner

 select * from user_errors order by line;

 here's an example:

 SQL create procedure this_is_bad
   2  as
   3select * from dual
   4  end;
   5
   5
   5  /

 Warning: Procedure created with compilation errors.

 SQL select * from user_errors order by line;

 NAME TYPE  SEQUENCE  LINE
 POSITION
   - -
 -
 TEXT
 
---
 THIS_IS_BAD  PROCEDURE1 3
   3
 PLS-00103: Encountered the symbol SELECT when expecting one of the
 following:

begin function package pragma procedure subtype type use
an identifier a double-quoted delimited-identifier cursor
form current external language
 The symbol begin was substituted for SELECT to continue.

 THIS_IS_BAD  PROCEDURE2 4
   1
 PLS-00103: Encountered the symbol END when expecting one of the following:

. , @ ; for an identifier
a double-quoted delimited-identifier group having intersect
minus order partition start subpartition union where connect
SAMPLE_
 The symbol ; was substituted for END to continue.

 From: Beatriz Martínez Jiménez [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: No errors showed in the DBA Studio
 Date: Tue, 21 Aug 2001 01:21:37 -0800
 
 Hello list,
 Oracle 8.1.7. NT4.0
 I have created some procedures in the DBA Studio, and when I try to
 compile them I get that the procedure status is Invalid, but in the
 'show error' window there is no message. The window appears but it´s
 completely empty.
 Could somebody tell me what happens? Do i Have to configure anything to
 display this errors?
 A lot of thanks,
  beamar.vcf 

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

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


begin:vcard 
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
org:Fundación CIDAUT;Departamento de Informática
adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain
version:2.1
email;internet:[EMAIL PROTECTED]
title:Ingeniera Informática
fn:Beatriz Martínez Jiménez
end:vcard

RE: Freelist Contention - PQ slaves

Title: RE: Freelist Contention - PQ slaves





I thought that parallel query slaves were smart enough to divide up the work between them so there was no overlap? What am I missing? Can you elaborate?

-Original Message-
From: Johnson Poovathummoottil [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 11:21
To: Multiple recipients of list ORACLE-L
Subject: RE: Freelist Contention


Bufer busy waits can also be caused by parallel query
servers trying to read the same buffer block at the
same time. So does it always indicate a freelist
problem?
.
--- Jon Walthour [EMAIL PROTECTED] wrote:
 Raja:
 
 You will know you have freelist contention if you
 have a significant
 buffer busy waits ratio (5%). 
 
 Jon Walthour
 
 -Original Message-
 Luthra
 Sent: Monday, August 20, 2001 11:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hello folks,
 
 How do I come to know that there is a contention
 going on in the
 freelists? Is there any v$ table or this type of
 contention you derive
 from some other info. like a ripple effect from some
 parameter?
 
 TIA.
 
 raja
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Viraj Luthra
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- (858) 538-5051 FAX:
 (858) 538-5051
 San Diego, California -- Public Internet
 access / Mailing Lists


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



__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
 INET: [EMAIL PROTECTED]


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

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

2001-08-21 Thread Robertson Lee - lerobe

Title: Apologies... linux & Oracle



Lisa

SuSe 
is the best so I have been told. I am about to install 8i on 7.1 and another guy 
here is installing 9i on 7.2.

Totally untested on my behalf as I haven't started yet 
but that is the best I have been told.

Probably of no use whatsoever !!!

Lee



  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: 21 August 2001 
  16:51To: Multiple recipients of list ORACLE-LSubject: 
  Apologies... linux  Oracle
  Sorry everyone, I know you were just discussing 
  this recently. 
  What is the most stable combination of Oracle  
  Linux? What would you recommend? I want to say the consensus was 
  SCO Linux but I don't quite remember. 
  Thank you 
  Lara Croft Oracle Database Administrator Fairfield Resorts, Inc 

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

How do they get the answer?


I am taking the Self-Test software test for the SQL exam 
and don't see how they get the answer to this problem.  
They don't explain how it is arrived at.

Any help you can give me will be appreciated.

Thanks,
Ken Janusz, CPIM

--

Examine the structure of the TEACHER table:

NameNull?   Type
ID  NOT NULLNUMBER(9)
SALARY  NUMBER
(7,2)
SUBJECT_ID  NOT NULLNUMBER(3)
SUBJECT_DESCRIPTION VARCHAR2(2)

There are 200 teachers and 15 subjects.  Each subject is 
taught
by at least 2 teachers.

Evaluate this PL/SQL block:

DECLARE
v_pct_raise number := 1.10;
BEGIN
UPDATE  teacher
SET salary = salary * 1.10
WHERE   subject_id IN (102, 105);
COMMIT;
END;

Which result will the PL/SQL block provide?

(A) Only two teachers will receive a 10% salary increase.
(B) All of the teachers will receive a 10% salary 
increase.
(C) At least four teachers will receive a 10% salary 
increase.
(D) A syntax error will occur.

Answer:
(C) 


-- 
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: No errors showed in the DBA Studio

2001-08-21 Thread Rachel Carmichael


I'm not morally opposed to GUI tools... and using them doesn't make you a 
bad DBA. But I really think that you (generic you) need to understand what 
the tool is doing, so that if you end up somewhere that doesn't have and 
won't buy the tool, you can still do your job.



From: Beatriz Martínez Jiménez [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: No errors showed in the DBA Studio
Date: Tue, 21 Aug 2001 08:01:20 -0800

A lot of thanks Rachel,
it helps me a lot, although I would prefer to use a GUI tool (despite of 
looking  like a
bad DBA).
Thank you,

Rachel Carmichael wrote:

  Here's a radical thought. You could actually go into sqlplus and do a 
select
  from the dba_errors or user_errors view. I realize that this is will 
cause
  many on this list to think of me as a dinosaur, ready to be relegated to 
the
  old DBAs home, but come on, if you are going to call yourself a DBA you
  should be able to look things up in the database WITHOUT a GUI tool.
 
  I'll even be nice and give you the query:
 
  log into sqlplus as the procedure owner
 
  select * from user_errors order by line;
 
  here's an example:
 
  SQL create procedure this_is_bad
2  as
3select * from dual
4  end;
5
5
5  /
 
  Warning: Procedure created with compilation errors.
 
  SQL select * from user_errors order by line;
 
  NAME TYPE  SEQUENCE  
LINE
  POSITION
    - 
-
  -
  TEXT
  
---
  THIS_IS_BAD  PROCEDURE1 
3
3
  PLS-00103: Encountered the symbol SELECT when expecting one of the
  following:
 
 begin function package pragma procedure subtype type use
 an identifier a double-quoted delimited-identifier cursor
 form current external language
  The symbol begin was substituted for SELECT to continue.
 
  THIS_IS_BAD  PROCEDURE2 
4
1
  PLS-00103: Encountered the symbol END when expecting one of the 
following:
 
 . , @ ; for an identifier
 a double-quoted delimited-identifier group having intersect
 minus order partition start subpartition union where connect
 SAMPLE_
  The symbol ; was substituted for END to continue.
 
  From: Beatriz Martínez Jiménez [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: No errors showed in the DBA Studio
  Date: Tue, 21 Aug 2001 01:21:37 -0800
  
  Hello list,
  Oracle 8.1.7. NT4.0
  I have created some procedures in the DBA Studio, and when I try to
  compile them I get that the procedure status is Invalid, but in the
  'show error' window there is no message. The window appears but it´s
  completely empty.
  Could somebody tell me what happens? Do i Have to configure anything to
  display this errors?
  A lot of thanks,
   beamar.vcf 
 
  _
  Get your FREE download of MSN Explorer at 
http://explorer.msn.com/intl.asp
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: 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).
 beamar.vcf 


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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: How do they get the answer?

2001-08-21 Thread Brian McGraw


I think you're being tricked by the question.

If each subject is taught by two or more teachers, and you're updating the
salaries of all teachers teaching two subjects, 2 x (2+?) = 4

Brian

[EMAIL PROTECTED] wrote:

 I am taking the Self-Test software test for the SQL exam
 and don't see how they get the answer to this problem.
 They don't explain how it is arrived at.

 Any help you can give me will be appreciated.

 Thanks,
 Ken Janusz, CPIM

 --

 Examine the structure of the TEACHER table:

 NameNull?   Type
 ID  NOT NULLNUMBER(9)
 SALARY  NUMBER
 (7,2)
 SUBJECT_ID  NOT NULLNUMBER(3)
 SUBJECT_DESCRIPTION VARCHAR2(2)

 There are 200 teachers and 15 subjects.  Each subject is
 taught
 by at least 2 teachers.

 Evaluate this PL/SQL block:

 DECLARE
 v_pct_raise number := 1.10;
 BEGIN
 UPDATE  teacher
 SET salary = salary * 1.10
 WHERE   subject_id IN (102, 105);
 COMMIT;
 END;

 Which result will the PL/SQL block provide?

 (A) Only two teachers will receive a 10% salary increase.
 (B) All of the teachers will receive a 10% salary
 increase.
 (C) At least four teachers will receive a 10% salary
 increase.
 (D) A syntax error will occur.

 Answer:
 (C)

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

--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--


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

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

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

2001-08-21 Thread Cale, Rick T (Richard)


See

http://www.computerhope.com/issues/ch000373.htm
http://www.completeclinic.com/sn_spool32.html

Rick
-Original Message-
Sent: Tuesday, August 21, 2001 9:31 AM
To: Multiple recipients of list ORACLE-L



We recently have Spool 32 Error message appear on almost all of computers
when user request printing. Could anyone share the experience why and how
to solve this problem. Thx.


Warmest regards,

Le Quang Huy
Manager -- Information Technology
Chinfon Manulife Insurance Company Limited
Diamond Plaza, 12fl, 34 Le Duan, District 1, Ho Chi Minh city, Vietnam
Phone: (848) 825 7722 Ext: 2999 --- Fax: (848) 825 7718 --- Mobile: (848)

==
This message is confidential and may also be privileged.  If you are not
the intended recipient, please notify me by return e-mail and delete this
message from your system.  If you are not the intended recipient, any use
by you of this message is strictly prohibited.

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

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

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

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

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

Re: Nolog writes log ?




yes.

i've tested it and you should too.

joe
 [EMAIL PROTECTED] 08/21/01 11:21AM 
Hi,I have Emp table NOLOGGING.Does it write to log files 
the insert,update,delete activity on that table 
?TiaAldi_Get 
your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Aldi 
Barco 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: What is in archive log...

Check out the Oracle 8i Administrator's Guide, look at the chapter entitled: Using 
LogMiner to Analyze Online and Archived Redo Logs.

Jon Walthour

 From: Aldi Barco [EMAIL PROTECTED]
 Date: 2001/08/21 Tue AM 11:41:32 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: What is in archive log...

 Hi Lister,

 Can we read what activities are in archive log files ?
 (utility like 'tkprof' to read trace file).
 Tia.

 Aldi

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

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

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

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

No. Just because you have a high bbw ratio, that doesn't indicate strictly a freelist 
problem. However, having problems with freelists often results in a high bbw ratio.

Jon Walthour

 From: Johnson Poovathummoottil [EMAIL PROTECTED]
 Date: 2001/08/21 Tue AM 11:21:02 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Freelist Contention

 Bufer busy waits can also be caused by parallel query
 servers trying to read the same buffer block at the
 same time. So does it always indicate a freelist
 problem?
 .
 --- Jon Walthour [EMAIL PROTECTED] wrote:
  Raja:

  You will know you have freelist contention if you
  have a significant
  buffer busy waits ratio (5%). 

  Jon Walthour

  -Original Message-
  Luthra
  Sent: Monday, August 20, 2001 11:45 PM
  To: Multiple recipients of list ORACLE-L

  Hello folks,

  How do I come to know that there is a contention
  going on in the
  freelists? Is there any v$ table or this type of
  contention you derive
  from some other info. like a ripple effect from some
  parameter?

  TIA.

  raja

  Get 250 color business cards for FREE!
  http://businesscards.lycos.com/vp/fastpath/
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: Viraj Luthra
INET: [EMAIL PROTECTED]

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

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

 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute with Yahoo! Messenger
 http://phonecard.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Johnson Poovathummoottil
   INET: [EMAIL PROTECTED]

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

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

Exporting partitioned tables

2001-08-21 Thread Stephen Andert




Greetings and salutations oh magnificent Oracles of Oracle, 

I am experiencing something that I don't understand. (No comments 
from the peanut gallery!) When I do an export for a schema that contains a 
number of partitioned tables most of the time everything works fine. 


Sometimes however, the last partition of one object produces the following 
errors:

EXP-8: Oracle error 8103 encountered
ORA-08103: object no longer exists 

This error happens overnight and when I check in the morning (select 
count(*) from schema.table partition (P026);) and it always shows that I have 
rows.

I RTFM'd and that error message indicates that the object is gone. 
This object is not dropped and re-created by any process. 

Any ideas?

Stephen Andert

DB size question?

2001-08-21 Thread Seema Singh


Hi
If redo log files are multiplexed in database.
In computation of Database size is multiplexed redo log files size would be 
consider or not?
Thanks
-Seema

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

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

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

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

Re: What is in archive log...

2001-08-21 Thread Traci Rebman


Aldi,

You can use LogMiner to view activity in the archive logs.

See Note:111886.1 for how to set it up.

Traci Rebman
Database Administrator
DE Communications, Inc.

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

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

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

2001-08-21 Thread Peter Gram


Hi Aldi

You can use Logminer !

Aldi Barco wrote:

 Hi Lister,

 Can we read what activities are in archive log files ?
 (utility like 'tkprof' to read trace file).
 Tia.

 Aldi


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


-- 
Regards

Peter Gram

Miracle A/S 
http://MiracleAS.dk 
Tel: +45 2527 7107



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

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

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

2001-08-21 Thread Mercadante, Thomas F


two subjects in the in clause, times at least two teachers per subject
equals at least four records updated.

sometimes it is easier to eliminate answers first. 
like, you can throw out d) syntax will occur. and b) all teachers will get
an increase.
you are then left with a) two teachers and c). at least four teachers.

Since the where clause is looking at the 'subject_id' column, rather than
the 'teacher_id' column, you can almost guess that it is c).

hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, August 21, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


I am taking the Self-Test software test for the SQL exam 
and don't see how they get the answer to this problem.  
They don't explain how it is arrived at.

Any help you can give me will be appreciated.

Thanks,
Ken Janusz, CPIM

--

Examine the structure of the TEACHER table:

NameNull?   Type
ID  NOT NULLNUMBER(9)
SALARY  NUMBER
(7,2)
SUBJECT_ID  NOT NULLNUMBER(3)
SUBJECT_DESCRIPTION VARCHAR2(2)

There are 200 teachers and 15 subjects.  Each subject is 
taught
by at least 2 teachers.

Evaluate this PL/SQL block:

DECLARE
v_pct_raise number := 1.10;
BEGIN
UPDATE  teacher
SET salary = salary * 1.10
WHERE   subject_id IN (102, 105);
COMMIT;
END;

Which result will the PL/SQL block provide?

(A) Only two teachers will receive a 10% salary increase.
(B) All of the teachers will receive a 10% salary 
increase.
(C) At least four teachers will receive a 10% salary 
increase.
(D) A syntax error will occur.

Answer:
(C) 


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

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

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

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

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

RE: Apologies... linux Oracle

2001-08-21 Thread Ed . Haskins

Title: Apologies... linux & Oracle

O.K...it looks like SCO was bought by Caldera, who
sells a distribution of Linux under that name.

-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 12:36
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Apologies... linux Oracle
Lisa

SuSe
is the best so I have been told. I am about to install 8i on 7.1 and another
guy here is installing 9i on 7.2.

Totally untested on my behalf as I haven't started
yet but that is the best I have been told.

Probably of no use whatsoever !!!

Lee

-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: 21 August 2001
16:51To: Multiple recipients of list ORACLE-LSubject:
Apologies... linux Oracle
Sorry everyone, I know you were just discussing
this recently.
What is the most stable combination of Oracle
Linux? What would you recommend? I want to say the
consensus was SCO Linux but I don't quite remember.
Thank you
Lara Croft Oracle Database Administrator Fairfield Resorts, Inc 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[2]: How do they get the answer?

2001-08-21 Thread dgoulet


I think someone had difficulties with word problems in Math class.  Gotcha
again!!

Dick Goulet

Reply Separator
Author: Brian McGraw [EMAIL PROTECTED]
Date:   8/21/2001 8:57 AM

I think you're being tricked by the question.

If each subject is taught by two or more teachers, and you're updating the
salaries of all teachers teaching two subjects, 2 x (2+?) = 4

Brian

[EMAIL PROTECTED] wrote:

 I am taking the Self-Test software test for the SQL exam
 and don't see how they get the answer to this problem.
 They don't explain how it is arrived at.

 Any help you can give me will be appreciated.

 Thanks,
 Ken Janusz, CPIM

 --

 Examine the structure of the TEACHER table:

 NameNull?   Type
 ID  NOT NULLNUMBER(9)
 SALARY  NUMBER
 (7,2)
 SUBJECT_ID  NOT NULLNUMBER(3)
 SUBJECT_DESCRIPTION VARCHAR2(2)

 There are 200 teachers and 15 subjects.  Each subject is
 taught
 by at least 2 teachers.

 Evaluate this PL/SQL block:

 DECLARE
 v_pct_raise number := 1.10;
 BEGIN
 UPDATE  teacher
 SET salary = salary * 1.10
 WHERE   subject_id IN (102, 105);
 COMMIT;
 END;

 Which result will the PL/SQL block provide?

 (A) Only two teachers will receive a 10% salary increase.
 (B) All of the teachers will receive a 10% salary
 increase.
 (C) At least four teachers will receive a 10% salary
 increase.
 (D) A syntax error will occur.

 Answer:
 (C)

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

--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--


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

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

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

2001-08-21 Thread Jared Still


On Tuesday 21 August 2001 08:21, Johnson Poovathummoottil wrote:
 Bufer busy waits can also be caused by parallel query
 servers trying to read the same buffer block at the
 same time.

Just off the top of my head, and without giving it a lot
of thought, this doesn't sound right.

PQS divvy up the blocks to read, and should not be trying
to access the same block.

Got any documentation or evidence to back that up?

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

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

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

9i Via Oracle 8 ODBC Drivers?

2001-08-21 Thread Hal Hempe


Greetings,

Current Client: NT Workstation 4.0, w/ Oracle 8.00.05.00 ODBC driver and

SQL*Plus Rel 8.0.5.0.0
Current DB Server: Oracle 8.0.6.0.0 EE for HP-UX 11.0

Will our current client config work with 9i databases?
If not, what driver, SQL*Plus client, or other config changes would be
required?

Thank you in advance,
Hal

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

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

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

2001-08-21 Thread Deshpande, Kirti


 Each subject is taught by at least 2 teachers.
So, if 102 and 105 are the 2 subject-ids, then a total of at least 4
teachers will get selected for salary update. 
Correct ? 

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 21, 2001 11:26 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  How do they get the answer?
 
 I am taking the Self-Test software test for the SQL exam 
 and don't see how they get the answer to this problem.  
 They don't explain how it is arrived at.
 
 Any help you can give me will be appreciated.
 
 Thanks,
 Ken Janusz, CPIM
 
 --
 
 Examine the structure of the TEACHER table:
 
 Name  Null?   Type
 IDNOT NULLNUMBER(9)
 SALARYNUMBER
 (7,2)
 SUBJECT_IDNOT NULLNUMBER(3)
 SUBJECT_DESCRIPTION   VARCHAR2(2)
 
 There are 200 teachers and 15 subjects.  Each subject is 
 taught
 by at least 2 teachers.
 
 Evaluate this PL/SQL block:
 
 DECLARE
   v_pct_raise number := 1.10;
 BEGIN
   UPDATE  teacher
   SET salary = salary * 1.10
   WHERE   subject_id IN (102, 105);
   COMMIT;
 END;
 
 Which result will the PL/SQL block provide?
 
 (A) Only two teachers will receive a 10% salary increase.
 (B) All of the teachers will receive a 10% salary 
 increase.
 (C) At least four teachers will receive a 10% salary 
 increase.
 (D) A syntax error will occur.
 
 Answer:
 (C) 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Re: High DML Table - Suggestions??

2001-08-21 Thread CC Harvest


I have a big table too, about 16GB.
It is a vert static one(customer table), will add data

once in it, but queried all the time, and do the
segmentations against it all the time.

It also has 12 indexes. Right now , the performance is
ok. Any special consideration for such a big table.

Thanks,

Harvest.

--- Christian Trassens [EMAIL PROTECTED] wrote:
 Don't put it in a buffer keep because of the amount
 of
 consistent gets the table could have. It seems to be
 a
 high volatile table.
 
 Maybe it is too late but you should look on the
 initrans, freelist of the table. Also if the table
 has
 foreign keys, talk with Development to leave the
 table
 without them. I should consider to partition the
 tablemaybe a hash one.
 
 Regards.
 
 
 --- Walter K [EMAIL PROTECTED] wrote:
  Hi,
  
  I have a table that is going to have a large
 amount
  of
  inserts, updates and deletes performed against it
  daily. Approximately 1,000,000 transactions per
 day
  (some single-record, some multi-record). The table
  is
  ~100Mb in size.
  
  I'm looking for some suggestions on what I can do
 to
  have the most optimal I/O for the table. I've been
  doing a little reading about buffer pools. Is
  assigning this table to a KEEP pool a practical
  approach or is that not going to buy me anything
  because DML is involved? Does anyone have any
 other
  suggestions?
  
  Unfortunately, I can't put the table on a
 dedicated
  disk and I am stuck with Raid-5 currently.
  
  Any suggestions would be appreciated.
  
  Thanks in advance!
  -w
  
  __
  Do You Yahoo!?
  Make international calls for as low as $.04/minute
  with Yahoo! Messenger
  http://phonecard.yahoo.com/
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: Walter 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).
 
 
 =
 Eng. Christian Trassens
 Senior DBA
 Systems Engineer
 [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 Phone : 541149816062
 
 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute
 with Yahoo! Messenger
 http://phonecard.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).


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CC Harvest
  INET: [EMAIL PROTECTED]

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

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

2001-08-21 Thread Ron Rogers


Aldi,
How did you create a table as NOLOGGING. The fine manual states that you can use 
nologging only on a table created with the select as clause. The fine manual also 
states that you can create a table based on a query without generating redo log 
entries. Keep in mind that in the event of a failure/recovery action before you do a 
backup the new table will not be recovered.
ROR mª¿ªm

 [EMAIL PROTECTED] 08/21/01 11:21AM 
Hi,
I have Emp table NOLOGGING.
Does it write to log files the insert,update,delete activity on that table ?
Tia

Aldi


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

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

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

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

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

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

2001-08-21 Thread Rachel Carmichael

what version of Oracle? but yes, read the manuals on logminer

From: Aldi Barco [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: What is in archive log...
Date: Tue, 21 Aug 2001 07:41:32 -0800

Hi Lister,

Can we read what activities are in archive log files ?
(utility like 'tkprof' to read trace file).
Tia.

Aldi

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

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

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

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

-- 
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: How do they get the answer?

in the where clause, the IN says any teachers that are in any of these subjects. 
Since there are two subjects in the IN set and at least 2 teachers have to teach each 
subject, 2*2=4. Basic mathematics: at least 4 teachers will get a raise.

Jon Walthour

 From: [EMAIL PROTECTED]
 Date: 2001/08/21 Tue PM 12:25:54 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: How do they get the answer?

 I am taking the Self-Test software test for the SQL exam 
 and don't see how they get the answer to this problem.  
 They don't explain how it is arrived at.

 Any help you can give me will be appreciated.

 Thanks,
 Ken Janusz, CPIM

 --

 Examine the structure of the TEACHER table:

 Name  Null?   Type
 IDNOT NULLNUMBER(9)
 SALARYNUMBER
 (7,2)
 SUBJECT_IDNOT NULLNUMBER(3)
 SUBJECT_DESCRIPTION   VARCHAR2(2)

 There are 200 teachers and 15 subjects.  Each subject is 
 taught
 by at least 2 teachers.

 Evaluate this PL/SQL block:

 DECLARE
   v_pct_raise number := 1.10;
 BEGIN
   UPDATE  teacher
   SET salary = salary * 1.10
   WHERE   subject_id IN (102, 105);
   COMMIT;
 END;

 Which result will the PL/SQL block provide?

 (A) Only two teachers will receive a 10% salary increase.
 (B) All of the teachers will receive a 10% salary 
 increase.
 (C) At least four teachers will receive a 10% salary 
 increase.
 (D) A syntax error will occur.

 Answer:
 (C) 

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

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: WARNING: CURSOR_SHARING=FORCE on 8.1.7

2001-08-21 Thread Jesse, Rich


Eeeek!  It just keeps getting worse!  Can someone on 8.1.7.x on a NON-HP
platform using CURSOR_SHARING=FORCE and CBO at the system level try the
following test for me?

--

DROP TABLE REJ_TEST CASCADE CONSTRAINTS ; 

CREATE TABLE REJ_TEST ( 
  ACCESSCONTROLID  NUMBER (10)   NOT NULL, 
  RESOURCE_NAMEVARCHAR2 (10)  NOT NULL, 
  ACTION   VARCHAR2 (10)  NOT NULL, 
  ISALLOWEDNUMBER (5)NOT NULL, 
  PARTYID  NUMBER (10)   NOT NULL, 
  PTYPENUMBER (3)NOT NULL);

insert into rej_test
values (23, 'ESR', 'upd1', -1, 60, 1);
insert into rej_test
values (60, 'ESR', 'upd1', -1, 13, 2);

analyze table rej_test compute statistics;

REM SELECT 1

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1) OR (PartyID=13  AND IsAllowed=-1
AND PType=2);

ALTER SESSION SET CURSOR_SHARING=EXACT;

REM SELECT 2

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1) OR
(PartyID=13  AND IsAllowed=-1 AND PType=2);

ALTER SESSION SET CURSOR_SHARING=FORCE;

REM SELECT 3

SELECT Resource_Name, Action
FROM rej_test   
WHERE 
(PartyID=60 AND IsAllowed=-1 AND PType=1)
OR
(PartyID=13  AND IsAllowed=-1 AND PType=2);

--

I've purposely formatted each SELECT a little differently in order to force
a hard parse.  The problem I'm seeing is that SELECT #1 and #3 *RETURN NO
ROWS*!  If #3's formatted to be just like #2, it works fine, which leads me
to believe the problem's in the parse.

TIA!

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


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

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

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

RE: Apologies... linux Oracle

2001-08-21 Thread Ed . Haskins

Title: Apologies... linux & Oracle



SCO 
makes a version of Linux now? 

Ed

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 
  11:51 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Apologies... linux  Oracle
  Sorry everyone, I know you were just discussing 
  this recently. 
  What is the most stable combination of Oracle  
  Linux? What would you recommend? I want to say the consensus was 
  SCO Linux but I don't quite remember. 
  Thank you 
  Lara Croft Oracle Database Administrator Fairfield Resorts, Inc

RE: linux Oracle -- best combination

2001-08-21 Thread Daniel Curry


Lisa and others,
 
 About a year ago, I was working for a company as a Linux systems
engineer (Read as: Tech guy doing sales support).  Most of our customers
wanted Linux systems, and it was my responsibility to provide them the
correct combination of Linux and hardware to meet their needs.  I had an
ISO 9002 compliance to maintain as I provided testing and supporting
data to our clients.
 
My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have the
benchmarks any more, but it worked the best.
 
SCO Unix was bought by Caldera Linux and is not yet being implemented to
the full capability (IMHO).
 
Mandrake, SuSe, Storm were all tested as well,  And had less
satisfactory performance and reliability.  
 
Slackware 7 was the next best solution, followed by TurboLinux 6.
 
All of these configurations were tested on the same machine, completely
formatted and the same installation performed on each test cycle.
 
I hope this is helpful information.
 
Daniel Curry
Systems Administrator
CGtime, Inc. 
625 Second Street 
Suite 201
San Francisco, CA 94107 
ph: 415-348-6516
fx: 415-348-6505 
cell: 510-304-7889
 
-Original Message-
Sent: Tuesday, August 21, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
 
Lisa
 
SuSe is the best so I have been told. I am about to install 8i on 7.1
and another guy here is installing 9i on 7.2.
 
Totally untested on my behalf as I haven't started yet but that is the
best I have been told.
 
Probably of no use whatsoever !!!
 
Lee
-Original Message-
Sent: 21 August 2001 16:51
To: Multiple recipients of list ORACLE-L
Sorry everyone, I know you were just discussing this recently.  
What is the most stable combination of Oracle  Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  
Thank you 
Lara Croft 
Oracle Database Administrator 
Fairfield Resorts, Inc 
 


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. 
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Daniel Curry
  INET: [EMAIL PROTECTED]

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

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

DB2 Question


Does DB2 store data as EBCDIC or ASCII?

Thanks,
Ken Janusz, CPIM
-- 
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: User access within/outside of app

Create another user with select privileges only on the objects in the app's schema. 
Give that one to them and then change the password on the original app id so they 
won't be able to use that one anymore.

Jon Walthour

 From: Larry Hahn [EMAIL PROTECTED]
 Date: 2001/08/21 Tue AM 11:21:04 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: User access within/outside of app

 List,

 We have purchased a system where users login through
 an ODBC connection using a generic Oracle userid. This
 userid has full rights to do insert, update, delete,
 select on any table in the schema. The app asks for
 another username and password which checks the
 application security table, which limits what areas of
 the apps they can access. 

 Although this may work fine for the app, the users
 also have the ability to use Access and other ODBC
 compliant programs to look at the data. When doing so,
 they use the same ODBC DSN and, what do you know, they
 have capabilities beyond their wildest imagination. 

 This is obviously not a situation I want to implement.
 I am looking for a way to allow a user into the app to
 do their normal work, but only allow read access for
 anything outside the app. 

 Any suggestions or ideas would be more than welcome.

 Thanks,

 Larry Hahn
 Journal Sentinel, Inc. 

 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute with Yahoo! Messenger
 http://phonecard.yahoo.com/
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Larry Hahn
   INET: [EMAIL PROTECTED]

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

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

2001-08-21 Thread Stephen Andert




Well, 

to me it looks like 
 WHERE  subject_id IN 
(102, 105);will select 2 classes. Since there are a minimum of 2 teachers 
per class, this will select at least 4 teachers. 

Am I missing something?

Stephen [EMAIL PROTECTED] 08/21/01 09:25AM 
I am taking the Self-Test software test for the SQL exam and 
don't see how they get the answer to this problem. They don't explain 
how it is arrived at.Any help you can give me will be 
appreciated.Thanks,Ken Janusz, 
CPIM--Examine the structure of 
the TEACHER table:Name  
  Null?  
TypeID   
 NOT NULL 
NUMBER(9)SALARY   
   
NUMBER(7,2)SUBJECT_ID  
 NOT NULL 
NUMBER(3)SUBJECT_DESCRIPTION  
 VARCHAR2(2)There are 200 teachers and 15 
subjects. Each subject is taughtby at least 2 
teachers.Evaluate this PL/SQL 
block:DECLARE v_pct_raise 
 number := 1.10;BEGIN 
UPDATE  teacher 
SET  salary = salary * 
1.10 WHERE  subject_id 
IN (102, 105); COMMIT;END;Which result will 
the PL/SQL block provide?(A) Only two teachers will receive a 10% salary 
increase.(B) All of the teachers will receive a 10% salary 
increase.(C) At least four teachers will receive a 10% salary 
increase.(D) A syntax error will occur.Answer:(C) 
-- 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-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 analysis (enqueue and buffer busy waits)

2001-08-21 Thread Jonathan Lewis



Does that mean you think it is impossible
to have rollback segments that are too big ?

Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 20 August 2001 21:54


|Increase the snapshot too old query mortality rate?
|
| -Original Message-
| From: Babette Turner-Underwood
[mailto:[EMAIL PROTECTED]]
| Sent: Monday, August 20, 2001 9:22 AM
| To: Multiple recipients of list ORACLE-L
| Subject: RE: Performance analysis (enqueue and buffer busy waits)
|
|
| I am curious.
| What are you trying to accomplish by
| decreasing rollback segment size??
|
| - Babette


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

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

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

2001-08-21 Thread Boivin, Patrice J


Likewise, I always believed that if you had to use DOS, then you have a
better understanding of how Windows operates, because it has to go through
DOS to reach the hardware.

Assembly language is useful too, if you like headaches.

Another reason to learn the command line is that GUI tools very rarely
include all the options, you usually have more flexibility when using
commands than when using the GUI.  The GUI is useful for doing simple,
standardized tasks like creating one or two user accounts at a time.

e.g. when you install 8.1.7, you can't tell Oracle to use local
administration of the tablespaces.  You have to go in after the
installation, delete all those tablespaces, and re-create them manually...
using another GUI tool (DBA Studio)!  When both tools should be able to do
the same work.

Also, let's say Oracle decides they don't like a tool, and they drop it
altogether, and come up with a different GUI.  What will you do then?  You
have to learn a new application, and if you don't understand what is
happening underneath, you won't be able to adapt as easily.

The GUI tools are not consistent either, some use the .ora file extension
for datafiles, others use .dbf.  It seems to change from version to version.
I am also not clear on how the tools user small case vs. capital letters
when creating datafiles on case-sensitive OSes.  You have to be careful with
these tools.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
From:   Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 21, 2001 2:08 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: No errors showed in the DBA Studio

I'm not morally opposed to GUI tools... and using them doesn't make
you a 
bad DBA. But I really think that you (generic you) need to
understand what 
the tool is doing, so that if you end up somewhere that doesn't have
and 
won't buy the tool, you can still do your job.



From: Beatriz Martínez Jiménez [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: No errors showed in the DBA Studio
Date: Tue, 21 Aug 2001 08:01:20 -0800

A lot of thanks Rachel,
it helps me a lot, although I would prefer to use a GUI tool
(despite of 
looking  like a
bad DBA).
Thank you,

Rachel Carmichael wrote:

  Here's a radical thought. You could actually go into sqlplus and
do a 
select
  from the dba_errors or user_errors view. I realize that this is
will 
cause
  many on this list to think of me as a dinosaur, ready to be
relegated to 
the
  old DBAs home, but come on, if you are going to call yourself a
DBA you
  should be able to look things up in the database WITHOUT a GUI
tool.
 
  I'll even be nice and give you the query:
 
  log into sqlplus as the procedure owner
 
  select * from user_errors order by line;
 
  here's an example:
 
  SQL create procedure this_is_bad
2  as
3select * from dual
4  end;
5
5
5  /
 
  Warning: Procedure created with compilation errors.
 
  SQL select * from user_errors order by line;
 
  NAME TYPE  SEQUENCE

LINE
  POSITION
    - 
-
  -
  TEXT
  

---

  THIS_IS_BAD  PROCEDURE1

3
3
  PLS-00103: Encountered the symbol SELECT when expecting one of
the
  following:
 
 begin function package pragma procedure subtype type use
 an identifier a double-quoted delimited-identifier cursor
 form current external language
  The symbol begin was substituted for SELECT to continue.
 
  THIS_IS_BAD  PROCEDURE2

4
1
  PLS-00103: Encountered the symbol END when expecting one of
the 
following:
 
 . , @ ; for an identifier
 a double-quoted delimited-identifier group having intersect
 minus order partition start subpartition union

RE: Apologies... linux Oracle

2001-08-21 Thread Christopher Spence


Anyone have luck with 9i on RedHat?  I am sure the answer is yes as people
has mentioned trying.
Do they have it documented what is needed to be done to accomplish this?

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


Lora, lisa, what ever...
Oracle only supports SUSE 7.1 for Oracle 9i.
 I use RedHat 6.2 with Oracle 8.1.7 and RedHat upgraded to 7.0 afterwards.
Works great but not supported. SCO was bought out by RedHat a while back I
believe. ROR mª¿ªm

 [EMAIL PROTECTED] 08/21/01 11:50AM 
Sorry everyone, I know you were just discussing this recently.  

What is the most stable combination of Oracle  Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  

Thank you

Lara Croft
Oracle Database Administrator 
Fairfield Resorts, Inc




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

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

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

Index question ???

2001-08-21 Thread Andrea Oracle


Hi, all

I got couple of indices questions:

Is it REQUIRED or just recommended to build an index
on FK column/s?

I used Alter Table ... Move and Alter Index ...
Rebulid to move the table into differenct block and
then rebuild index.  Table Move works fine, but after
index rebuilt, some indices disappeared! How come?

Thanks!

Andrea

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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




quickly looking at metalstink, it appears quite often with an ora-600 
message, got one of those in the alert.log?

joe
 [EMAIL PROTECTED] 08/21/01 12:35PM 

Greetings and salutations oh magnificent Oracles of Oracle, 

I am experiencing something that I don't understand. (No comments 
from the peanut gallery!) When I do an export for a schema that contains a 
number of partitioned tables most of the time everything works fine. 


Sometimes however, the last partition of one object produces the following 
errors:

EXP-8: Oracle error 8103 encountered
ORA-08103: object no longer exists 

This error happens overnight and when I check in the morning (select 
count(*) from schema.table partition (P026);) and it always shows that I have 
rows.

I RTFM'd and that error message indicates that the object is gone. 
This object is not dropped and re-created by any process. 

Any ideas?

Stephen Andert

RE: linux Oracle -- best combination

2001-08-21 Thread Christopher Spence


I would be curious to see these tests going forward, seeing as RedHat
support is difficult to do with 9i and such.  And suse now being Oracle's
perfered linux.  I wonder if these results have changed.  I never really
played with Oracle on Linux, but if I ever had to, I would be curious.  

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 21, 2001 1:53 PM
To: Multiple recipients of list ORACLE-L


Lisa and others,
 
 About a year ago, I was working for a company as a Linux systems
engineer (Read as: Tech guy doing sales support).  Most of our customers
wanted Linux systems, and it was my responsibility to provide them the
correct combination of Linux and hardware to meet their needs.  I had an ISO
9002 compliance to maintain as I provided testing and supporting data to our
clients.
 
My first test was RedHat linux 6.1 with Oracle 8.1.5.  I don't have the
benchmarks any more, but it worked the best.
 
SCO Unix was bought by Caldera Linux and is not yet being implemented to the
full capability (IMHO).
 
Mandrake, SuSe, Storm were all tested as well,  And had less satisfactory
performance and reliability.  
 
Slackware 7 was the next best solution, followed by TurboLinux 6.
 
All of these configurations were tested on the same machine, completely
formatted and the same installation performed on each test cycle.
 
I hope this is helpful information.
 
Daniel Curry
Systems Administrator
CGtime, Inc. 
625 Second Street 
Suite 201
San Francisco, CA 94107 
ph: 415-348-6516
fx: 415-348-6505 
cell: 510-304-7889
 
-Original Message-
Sent: Tuesday, August 21, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
 
Lisa
 
SuSe is the best so I have been told. I am about to install 8i on 7.1 and
another guy here is installing 9i on 7.2.
 
Totally untested on my behalf as I haven't started yet but that is the best
I have been told.
 
Probably of no use whatsoever !!!
 
Lee
-Original Message-
Sent: 21 August 2001 16:51
To: Multiple recipients of list ORACLE-L
Sorry everyone, I know you were just discussing this recently.  
What is the most stable combination of Oracle  Linux?  What would you
recommend?  I want to say the consensus was SCO Linux but I don't quite
remember.  
Thank you 
Lara Croft 
Oracle Database Administrator 
Fairfield Resorts, Inc 
 


The information contained in this communication is confidential, is intended
only for the use of the recipient named above, and may be legally
privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. 
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Curry
  INET: [EMAIL PROTECTED]

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

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

2001-08-21 Thread Ron Rogers


Joe,
 I do not have the ability to test it at my sight. Would you test this and respond. 
Thanks,
Oracle Performance Tuning Tips  Techniques Page 538. Subject NOLOGGING: It specifies 
whether subsequent direct loader (SQL*LOADER) and direct-load INSERT operations 
against the table, partition, or LOB storage are logged.
Sounds like only under special conditions the logging is not performed.
Thanks,
ROR mª¿ªm

 [EMAIL PROTECTED] 08/21/01 12:42PM 
yes.

i've tested it and you should too.

joe


 [EMAIL PROTECTED] 08/21/01 11:21AM 
Hi,
I have Emp table NOLOGGING.
Does it write to log files the insert,update,delete activity on that table ?
Tia

Aldi


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

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

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

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

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

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

Title: RE: How do they get the answer?





Ken, after reading through the quesiton and thinking it through I arrived at the answer they give. They are trying to trick you into choosing syntax error. You'll find questions similar to this on the exams. 

Lara Croft. 
Certified Tomb Raider and DBA.
Ft. Lauderdale, FL, USA


-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 12:26
To: Multiple recipients of list ORACLE-L
Subject: How do they get the answer?


I am taking the Self-Test software test for the SQL exam 
and don't see how they get the answer to this problem. 
They don't explain how it is arrived at.


Any help you can give me will be appreciated.


Thanks,
Ken Janusz, CPIM


--


Examine the structure of the TEACHER table:


NameNull?  Type
IDNOT NULL NUMBER(9)
SALARY  NUMBER
(7,2)
SUBJECT_ID   NOT NULL NUMBER(3)
SUBJECT_DESCRIPTION   VARCHAR2(2)


There are 200 teachers and 15 subjects. Each subject is 
taught
by at least 2 teachers.


Evaluate this PL/SQL block:


DECLARE
 v_pct_raise  number := 1.10;
BEGIN
 UPDATE  teacher
 SET  salary = salary * 1.10
 WHERE  subject_id IN (102, 105);
 COMMIT;
END;


Which result will the PL/SQL block provide?


(A) Only two teachers will receive a 10% salary increase.
(B) All of the teachers will receive a 10% salary 
increase.
(C) At least four teachers will receive a 10% salary 
increase.
(D) A syntax error will occur.


Answer:
(C) 



-- 
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: How do they get the answer?

2001-08-21 Thread Jamadagni, Rajendra


What if there are only two teachers among all teachers that teach both the
(specified) subjects ?

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

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

-Original Message-
Sent: Tuesday, August 21, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L

in the where clause, the IN says any teachers that are in any of these
subjects. Since there are two subjects in the IN set and at least 2 teachers
have to teach each subject, 2*2=4. Basic mathematics: at least 4 teachers
will get a raise.

Jon Walthour

*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: Apologies... linux Oracle