Recommended Init File for Standby
Evening folks; Does anyone happen to have any recommended init file settings for a standby database ?? We are running Oracle 8.1.7.4 on a Solaris system. I think that we may have the settings on the standbys too high and are therefore wasting resources. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recommended Init File for Standby
I knew I would be providing more information. 1. Other standby databases (14). 2. Disaster Recovery. Automatic process applying logs only. 3. Bare essentials. When/If we have to turn to it we will replace the init file with the production init file. I am looking for exactly what you said. A bare essential init file. -Original Message- Sent: Friday, July 11, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Hi Kevin, I guess all I have is more questions: 1) What else do you have running on the server that has your standby database? 2) What is the purpose of the standby database (disaster recovery or reporting)? 3) If it is for disaster recovery, shouldn't the settings on the standby reflect the settings for your non standby database or are you looking at handling bare essentials and not your normal capacity? Maybe some of the answers to these questions will help answer your question to the settings. Bryan Rodrigues -Original Message- Sent: Friday, July 11, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Evening folks; Does anyone happen to have any recommended init file settings for a standby database ?? We are running Oracle 8.1.7.4 on a Solaris system. I think that we may have the settings on the standbys too high and are therefore wasting resources. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recommended Init File for Standby
Thanks Dennis. THat is what I have been doing . Guess I will continue. Kevin -Original Message- Sent: Friday, July 11, 2003 5:09 PM To: Multiple recipients of list ORACLE-L Kevin Sounds like a trial-and-error to me. Someone else's settings probably wouldn't help you because maybe they only have 12 standby databases. My guess is that your objective is to minimize the memory usage. Some thoughts: - Try reducing the settings until the database won't run, or fails frequently enough to be annoying (like 4031 errors). - Monitor how far behind production the standby lags. - Too much reduction may be self-defeating. For example, making DB_BLOCK_BUFFERS too small might cause the same blocks to be continually reloaded, increasing I/O. This sounds like most DBA work - make a pass or two at it, then move on to the next fire. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 11, 2003 4:35 PM To: Multiple recipients of list ORACLE-L I knew I would be providing more information. 1. Other standby databases (14). 2. Disaster Recovery. Automatic process applying logs only. 3. Bare essentials. When/If we have to turn to it we will replace the init file with the production init file. I am looking for exactly what you said. A bare essential init file. -Original Message- Sent: Friday, July 11, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Hi Kevin, I guess all I have is more questions: 1) What else do you have running on the server that has your standby database? 2) What is the purpose of the standby database (disaster recovery or reporting)? 3) If it is for disaster recovery, shouldn't the settings on the standby reflect the settings for your non standby database or are you looking at handling bare essentials and not your normal capacity? Maybe some of the answers to these questions will help answer your question to the settings. Bryan Rodrigues -Original Message- Sent: Friday, July 11, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Evening folks; Does anyone happen to have any recommended init file settings for a standby database ?? We are running Oracle 8.1.7.4 on a Solaris system. I think that we may have the settings on the standbys too high and are therefore wasting resources. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: DECODE AND SELECT
One thing you could consider is to make functions out of each of the sql statements in the case. Then, in your decode statement you could call the correct function based on the value of X. Either that or put the entire logic into a function that has all the case statement broken down into individual IF tests . -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/11/03 11:39 PM Hi I am in urgent need of backporting oracle9i pl/sql to oracle8i.I have encountered some case satements like this CASE when x0 then (select y from deptno) else (select Z from emp) end i need to convert them to decode statements.Can anybody tell me how to write a select statement within decode. regards Hrishy Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Space Remaining in Current Extent - Done
Thanks for everyone for responding. I think I have enough to get as close
as I can to what was requested.
Kevin
-Original Message-
Sent: Tuesday, May 27, 2003 5:40 PM
To: Multiple recipients of list ORACLE-L
I'll beg/borrow steal from John Beresniewicz's book on Oracle Built-in
Packages by O'Reilly RevealNet to give you an answer. Here is the script
that John provides with the book. I use it in a somewhat different form,
but it appears to tell the truth.
DECLARE
free_blocks NUMBER;
BEGIN
DBMS_OUTPUT.PUT_LINE(RPAD('TABLE NAME',30)||' FREELIST BLOCKS');
FOR user_tables_rec IN
(SELECT table_name
FROM user_tables)
LOOP
DBMS_SPACE.FREE_BLOCKS
(segment_owner = USER
,segment_name = user_tables_rec.table_name
,segment_type = 'TABLE'
,freelist_group_id = 0
,free_blks = free_blocks
,scan_limit = NULL);
DBMS_OUTPUT.PUT_LINE(RPAD(user_tables_rec.table_name,30)||' '||
TO_CHAR(free_blocks));
END LOOP;
END;
/
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, May 27, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L
As to what this is for .
I have a request to come up with a way to guage space remaining on an on
going basis i.e.If I look at the space available between 2
different user transactions I will see a difference. Most of the methods I
have seen so far either rely on Analyze or show simply the amount of space
that has been allocated to the table at this time (not the actual This is
what you have allocated and This is what you have free).
I have tried using dbms_space but it again shows (at least I interpret it
that way) the amount of space allocated , not neccessarily exactly what is
in use.
If there is an obvious v$ or x$ view out there someplace where I can get
this info, it would be great.
-Original Message-
Sent: Tuesday, May 27, 2003 2:40 PM
To: Multiple recipients of list ORACLE-L
Kevin - Since you haven't received any replies, here goes.
Within an extent, Oracle uses blocks. I haven't seen a way to find the used
space within a block. There are methods to find the number of empty blocks
underneath the high water mark. Analyze does that, but you've ruled that
out. It might help if you could explain what you are trying to accomplish.
Other ideas are:
- Write a program that will scan the table, read each row and count the
bytes as it reads it. This would be very accurate, but time-consuming.
- An approximate answer could be arrived at by doing an analyze and
getting average row length. This shouldn't change much unless some operation
is performed that would alter that. Then by getting the number of rows in
the table you could get a very close estimate of the table size at any time.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 27, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
Hey guys;
Does anyone know where I can look to find the space remaining in an
individual extent ?? I know that you can get the freespace from
dba_free_space but that seems to be based only on unallocated extents. I
have been asked to find out, down to the byte, how much free space is
available . on the fly (which means not only after every analyze)
Any suggestions ??? I am sure Oracle has a table with the information
somewhere .
Thanks
Kevin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Space Remaining in Current Extent
Hey guys; Does anyone know where I can look to find the space remaining in an individual extent ?? I know that you can get the freespace from dba_free_space but that seems to be based only on unallocated extents. I have been asked to find out, down to the byte, how much free space is available . on the fly (which means not only after every analyze) Any suggestions ??? I am sure Oracle has a table with the information somewhere . Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Space Remaining in Current Extent
As to what this is for . I have a request to come up with a way to guage space remaining on an on going basis i.e.If I look at the space available between 2 different user transactions I will see a difference. Most of the methods I have seen so far either rely on Analyze or show simply the amount of space that has been allocated to the table at this time (not the actual This is what you have allocated and This is what you have free). I have tried using dbms_space but it again shows (at least I interpret it that way) the amount of space allocated , not neccessarily exactly what is in use. If there is an obvious v$ or x$ view out there someplace where I can get this info, it would be great. -Original Message- Sent: Tuesday, May 27, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Kevin - Since you haven't received any replies, here goes. Within an extent, Oracle uses blocks. I haven't seen a way to find the used space within a block. There are methods to find the number of empty blocks underneath the high water mark. Analyze does that, but you've ruled that out. It might help if you could explain what you are trying to accomplish. Other ideas are: - Write a program that will scan the table, read each row and count the bytes as it reads it. This would be very accurate, but time-consuming. - An approximate answer could be arrived at by doing an analyze and getting average row length. This shouldn't change much unless some operation is performed that would alter that. Then by getting the number of rows in the table you could get a very close estimate of the table size at any time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 27, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Hey guys; Does anyone know where I can look to find the space remaining in an individual extent ?? I know that you can get the freespace from dba_free_space but that seems to be based only on unallocated extents. I have been asked to find out, down to the byte, how much free space is available . on the fly (which means not only after every analyze) Any suggestions ??? I am sure Oracle has a table with the information somewhere . Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sort ip addresses
I've had this around for a while ... and just dug it out of my scripts and tried it again . Works for sorting 4 octet ips. You can always add sections on if they are ipv6. Ugly looking ... but it works. Note, you can probably clean up the math a bit ... i.e. combine plusses into +2, +3 etc. I just never did because it worked. select ip from iptable orderby lpad(substr(ip,1,instr(ip,'.')-1),3,'0')|| lpad(substr(ip, instr(ip,'.')+1,(instr(ip,'.',instr(ip,'.')+1)-1)-instr(ip,'.')),3,'0')|| lpad(substr(ip, instr(ip,'.',instr(ip,'.')+1)+1,(instr(ip,'.',instr(ip,'.',instr(ip,'.')+1)+ 1))-instr(ip,'.',instr(ip,'.')+1)-1),3,'0')|| lpad(substr(ip, instr(ip,'.',instr(ip,'.',instr(ip,'.')+1)+1)+1),3,'0') -Original Message- Sent: Tuesday, March 25, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Need a trick to sort ip addresses into numerical order. I have them stored as varchar2. If I select without a sort I get rows in order of their character value: 10.0.112.1 10.0.113.1 10.0.113.2 10.0.12.1 10.0.78.1 I'd like to order them numerically within the octets: 10.0.12.1 10.0.78.1 10.0.112.1 10.0.113.1 10.0.113.2 === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Quick Question -- 8.1.7 logs applied to 9.2.0 database instan
We just went 8.0.5 to 8.1.7 and the instructions explicitly said to NOT apply logs from the 8.0.5 on the 8.1.7. Not sure on the 9.2.0. -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]Sent: Monday, March 24, 2003 2:24 PMTo: Multiple recipients of list ORACLE-LSubject: Quick Question -- 8.1.7 logs applied to 9.2.0 database instance? Can I take a hot backup of an 8.1.7 instance... and then upgrade the backup to 9.2.0 (upgrading data dictionary tables and everything) and then apply logs created by the 8.1.7 instance to this 9.2.0 backup? Please answer as soon as possible... Thanks! Nick Wagner
RE: Job Needed
I hear the job of Prime Minister in England will probably be open soon. Any political ambitions ? -Original Message- Sent: Tuesday, March 18, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Greetings! I hope Jared doesn't kick me off the list for this, but I was just layed off this morning and am now in the need of a job. I have over 10 years of experience with Oracle, mostly using SQL and PL/SQL as a developer, but the last 2 years have been as a development support DBA. I am currently in Columbus, Ohio but am willing to relocate to most places in the South-East. I would appreciate any leads that can be thrown my way Thanks Kevin Toepke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Corrected SQL Question...
Not quite random. Note that the value is field 1 of the first record is the value in field 2 in the second. It looks like they want to pair up the cities if they appear in both columns. i.e. Since Dallas is in column 1 with Austin in Column 2 in one record, and Dallas is in Column 2 with Austin in column 1 in a seperate record, they want those records to follow each other. Could be a cleanup effort ... duplicate but reversed data -Original Message- Sent: Thursday, March 13, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Kirti, Can you explain the required result order? It looks random to me - or like one of the tests we were forced to take in High School. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, March 13, 2003 9:31 AM To: Multiple recipients of list ORACLE-L Okay, let me do this right this time,... (Now that I have my hot tea going;) Here is the test data: SQL select c1,c2 from cp; C1 C2 --- --- AUS DAL AUS HOU DAL AUS DAL HOU DAL LIT DAL XYZ HOU AUS HOU DAL HOU LIT HOU XYZ LIT DAL C1 C2 --- --- LIT HOU XYZ DAL XYZ HOU 14 rows selected. SQL Here is what is required: C1 C2 --- --- AUS DAL DAL AUS AUS HOU HOU AUS DAL HOU HOU DAL DAL LIT LIT DAL DAL XYZ XYZ DAL HOU LIT LIT HOU HOU XYZ XYZ HOU I think I am clear now... Sorry about the wrong test data earlier... Thanks, - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BMC Patrol
Past history with an oracle system I worked on at my previous job. This was around 1997-2000. Patrol sucked resources like there was no end to them. We canned it really fast. That was on IBM AIX and Oracle 7.3.4. -Original Message- Sent: Wednesday, March 12, 2003 3:45 PM To: Multiple recipients of list ORACLE-L We are in the process of implementing BMC Patrol for monitoring our databases. This is a good thing since we have hundreds of database across several states. Monitoring from a single location with one tool makes sense. However, the question has arisen about the actual load that Patrol will put on the databases. To read Patrol's data, there are words such as, 'negligible' or 'minimal' but they offer no solid metrics. In the not too distant past, BMC's Perform and Predict product literally consumed all of the memory on our database machines and ground them to a halt. It took several weeks before BMC was able to correctly diagnose the problem and come up with a fix. Rather than repeat this experience I would like to hear from others using Patrol. If anyone has any hands on experience with performance problems resulting from implementing the Patrol KMs for Oracle, SQL Server or Sybase, I would appreciate hearing about them. Thanks, = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback Segments on 8.1.7.4
I will have to check your question on 'fewer sorts'. As far as changes to the SQL statements, there were 1 or 2 sql statements changed in the application because they no longer worked efficiently with the change to 8.1.7. But, on the whole (lets say 98%+ of the time) no changes were made. -Original Message- Sent: Monday, March 10, 2003 5:39 PM To: Multiple recipients of list ORACLE-L Did any of the rollback segment storage parameters (i.e. INITIAL, NEXT, PCTINCREASE, MINEXTENTS, MAXEXTENTS, OPTIMAL) or the number of rollback segments change between 8.0.5 and 8.1.7? Changes to any of these variables could impact the space available for storing inactive undo blocks for read-consistency purposes. If the answer is of course not, then here comes the harder question: did the SQL statements change between 8.0.5 and 8.1.7? Not just outright different SQL statements, but even the same SQL statements running with different execution plans? For example, changing explain plans so that SORT-MERGE join is no longer use could have significant impact on ORA-01555, as forcing sorts are one way to minimize SNAPSHOT TOO OLD. Having queries run faster is another way to minimize ORA-01555, so getting rid of SORT-MERGE joins will likely help, but if the performance improvements aren't good enough, then the conversion to HASH or NESTED LOOP joins may allow more ORA-01555 to occur. Have you noticed fewer sorts occurring since 8.0.5? Just some ideas... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:59 PM Evening; Has anyone noticed any difference on the way Oracle uses Rollback Segments on 8.1.7.4 versus 8.0.5 ?? Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have noticed more SNAPSHOT TOO OLD errors than we used to. Are there any suggestions as to rollback tuning that has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback Segments on 8.1.7.4
Dan; Everything remained the same on the DB except the version. No changes made. -Original Message- Sent: Monday, March 10, 2003 5:34 PM To: Multiple recipients of list ORACLE-L Kevin, The ORA-01555 errors are almost certainly symptoms, not the actual problem. It has been a few years since I tested an 8.0.x db, but I do not recall seeing any changes in rollback segments from 7.3 to 8.1. Have you converted from Dictionary to Locally managed RBS tablespaces? When you upgraded, did you change any of the settings, like OPTIMAL, for the rollback segments? Were they dropped and recreated or upgraded inline? -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals Kevin Lange wrote: Evening; Has anyone noticed any difference on the way Oracle uses Rollback Segments on 8.1.7.4 versus 8.0.5 ?? Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have noticed more SNAPSHOT TOO OLD errors than we used to. Are there any suggestions as to rollback tuning that has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback Segments on 8.1.7.4
Evening; Has anyone noticed any difference on the way Oracle uses Rollback Segments on 8.1.7.4 versus 8.0.5 ?? Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have noticed more SNAPSHOT TOO OLD errors than we used to. Are there any suggestions as to rollback tuning that has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: nt script
Title: RE: nt script
If you
just do a HELP COMMAND, where command is the name of the command you need help
on, you can find out as much as you really need to know about
BATCH.
In
your sample of FOR /F
"TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
They were trying to set a variable called
DATE based on the system date.
First of all , %%A should be %A and %%B
should be %B if you are running this command in a command line. If
you place it in a batch file the way you have it, it will work.
First 2 values from the DATE/T command are
placed in the variables %A and %B. Then, for each line returned in this
command (1), you set the variable DATE equal to the second returned value
(%B).
For example, today the DATE/T returns 'Fri
03/07/2003". Therefore, %A gets set to FRI and %B gets set to
03/07/2003. When your command completes, the variable DATE will be equal
to %B or 03/07/2003.
--
This was determined by doing a help on the
FOR command:
help for
FOR /F ["options"] %variable IN
(file-set) DO command [command-parameters]FOR /F ["options"] %variable IN
("string") DO command [command-parameters]FOR /F ["options"] %variable IN
('command') DO command [command-parameters]
or, if usebackq
option present:
FOR /F ["options"] %variable IN
(file-set) DO command [command-parameters]FOR /F ["options"] %variable IN
('string') DO command [command-parameters]FOR /F ["options"] %variable IN
(`command`) DO command [command-parameters]
filenameset is one
or more file names. Each file is opened, read and
processed before going on to the next file in filenameset.
Processing consists of reading in the file, breaking it up
into individual lines of text and then parsing each line
into zero or more tokens. The body of the for loop
is then called with the variable value(s) set to the found
token string(s). By default, /F passes the first
blank separated token from each line of each file. Blank
lines are skipped. You can override the default
parsing behavior by specifying the optional "options"
parameter. This is a quoted string which contains
one or more keywords to specify different parsing
options. The keywords are:
eol=c - specifies an
end of line comment
character
(just one)
skip=n - specifies the
number of lines to skip at
the
beginning of the file.
delims=xxx - specifies a delimiter set. This
replaces
the
default delimiter set of space and
tab. tokens=x,y,m-n -
specifies which tokens from each line are
to
be passed to the for body for each
iteration.
This will cause additional variable names
to
be allocated. The m-n form is a
range,
specifying the mth through the nth tokens.
If
the last character in the tokens= string is
an
asterisk, then an additional variable
is
allocated and receives the remaining text
on
the line after the last token
parsed.
usebackq - specifies that the new
semantics are in
force,
where a back quoted string is executed as
a
command and a single quoted string is
a
literal string command and allows the use
of
double quotes to quote file names
in
filenameset.
Another Question on Authority and Security
Title: RE: Question related to security Given: User_A Owns procedure 'MY_PROCEDURE'. User_B originally compiles procedure ''USER_A.MY_PROCEDURE", thereby allowing'MY_PROCEDURE" to be able to do whatever User_B can. User_C recompiles"USER_A.MY_PROCEDURE" by issuing the "ALTER PROCEDUREUSER_A.MY_PROCEDURE COMPILE;" command. Question: Is procedure "USER_A.MY_PROCEDURE"now able to do whatever User C can do instead of User B ?? Or does it retain the authority from User_B instead. Thanks Kevin
RE: Big SGA.......
... large burlap sack and a small bat -Original Message-From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 7:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Big SGA... duct tape -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]Sent: Monday, March 03, 2003 5:10 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Big SGA... Sybase, Schmybase, Oracle, Schmoracle -- the concepts are still the same. Developers create tables and indexes and then write SQL, thinking that the RDBMS is at fault if performance doesn't match expectations. They have to understand that the structures they have created or the queries they have written may simply be inefficient, expending too much work. I don't know how to measure that in Sybase, but I'm reasonably sure that there must be a way. I used to joke that I could get OracleERP/Appsto run on a Palm Pilot if I were permitted to reallytune the SQL. The work performed by an application is not an immutable monolith, especially with the Oracle RDBMS and all of the performance statistics it keeps. It is very much susceptible to improvement. First, they must make a reasonable attempt to *fix* the problem (by making SQL more efficient). If that doesn't work, thenthey should*accomodate* the problem by buying more hardware, increasing buffer sizes, etc. The key with the latter approachis to realize that you haven't fixed anything, only accomodated it by throwing resources at it. Pop quiz: Think of a parent with a spoiled child who is making a scene in public. How do you quiet the child? :-) - Original Message - From: Loughmiller, Greg To: Multiple recipients of list ORACLE-L Sent: Monday, March 03, 2003 2:28 PM Subject: RE: Big SGA... one little piece of information..(considered critical probably:-) ) There isn't an opportunity to use statspack... The current application is running on sybase:-) I do have other teams researching the questions you mention. its a real fun project... -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]Sent: Monday, March 03, 2003 2:02 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Big SGA... Please start using STATSPACK now to gather and keep statistics. You are certainly going to need "before" and "after" statistics to analyze. Some questions: Why does the development group think that I/O is the problem? Have they been gathering data? Have you seen it? Do you concur that their data proves that I/O is a performance problem belonging to the Oracle database? Let's assume that there is an I/O problem. There are two ways to address I/O (as stated in the YAPP report of www.oraperf.com): reduce the *cost* per I/O request or reduce the *number* of I/O requests. The former implies getting a better/faster I/O subsystem, redistributing I/O load to different volumes, etc. Not trivial. The latter implies improving the Buffer Cache Hit Ratio (BCHR) by increasing the size of the Buffer Cache or it implies making queries more efficient, so that they simply don't issue so many I/O requests (either to the Buffer Cache or to the disk). Gathering STATSPACK data and searching for the SQL statements generating the largest number of "physical I/O" requests might be illuminating for the developers. If you work with them on a one-by-one basis on tuning each of these SQL statements, you might see dramatic improvements in performance. Suggest to them that *after* you are confident that there are no tunable SQL statements, then you might consider increasing the size of the Buffer Cache.Doing sois a last resort, not a first response. This is because doing so does not fix the real problem, it only accomodates the real problem, which is inefficient SQL. Hope this helps... -Tim - Original Message - From: Loughmiller, Greg To: Multiple recipients of list ORACLE-L Sent: Monday, March 03, 2003 10:59 AM Subject: Big SGA... hey folks.. Hoping for a little feedback and opinion please. Having a discussion with the development group ... The development group is thinking that a VERY LARGE SGA would solve some
RE: db create with DBCA and scripts
I did the same thing last night to an 8.1.7.4 DB and the Default Tablespace for SYSTEM was TOOLS but the Default Tablespace for SYS was SYSTEM this is the way I would hope it would run on 9.2 as well. -Original Message- Sent: Monday, March 03, 2003 4:14 PM To: Multiple recipients of list ORACLE-L List, Has anybody noticed this behavior: When you create a db with the DBCA in 9iRel2 for unix it does: usernamedefaulttemporary _ sys system temp system system temp but if you do it manually; username default temporary _ systools temp system toolstemp is there any other behavior during manual creation I should be aware of? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AIX question
Title: AIX question Lisa; Here is a set of 3 scripts that I used to map our disks on an IBM S70a with a large SSA Disk set that used the AIX Logical Disk Manager. You might be able to glean all the commands from the scripts or just use them yourself if they work on your system. The get_info.sh script calls the procedure that the included sql script creates. A sample output is in the info.dat file. Any questions, contact me off list . Kevin -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Friday, February 21, 2003 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: AIX question AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here but the SA for this system is scarce. Thanks for any suggestions, and have a great weekend everyone Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). diskinfo.sh Description: Binary data get_info.sh Description: Binary data info.sh Description: Binary data mount_points.sql Description: Binary data info.dat Description: Binary data
RE: AIX question
Smitty was indeed a wonderful interface. I believe it is the F6 key you hit to display the command. -Original Message- Sent: Friday, February 21, 2003 1:35 PM To: Multiple recipients of list ORACLE-L And, though I'm not sure if you need root to run it, I remember smitty was a wonderful little menu-driven tool for finding such information. And you hit a key combo that would show you the actual command for future reference. You'll have to forgive the vagueness, it's been quite some time since I had to use AIX. (Ah, the party we had when they took that RS6000 out of here) -Candi On Fri, 2003-02-21 at 13:39, Gene Sais wrote: Everything in IBM land is 'ls...' something. I think lscfg should give you more info, not sure of all the switches. Gene [EMAIL PROTECTED] 02/21/03 12:19PM AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here but the SA for this system is scarce. Thanks for any suggestions, and have a great weekend everyone Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: GRRRRR OWS
Title: Message I had a meeting once with the VP in charge of support for the south when I worked for my last job in Texas. We had been having major support problems with Oracle and were tired of paying such high prices for crap. One of the things he told me was that you can always tell them that you want to speak directly with the next tier of support i.e. skip the first tier all together and go to the more knowledgeable ones. When you ask, they are supposed to hand you off to the next group. I tried it a couple times and it actually worked.. of course, that was back in '97. They may have changed policies by now. -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 19, 2003 11:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: GR OWS Yes, in general since they moved most support to India, you get analysts that are more interested in playing the blame game than solving problems. Sigh, I miss the Aussies. I sometimes used to wait to submit a TAR until they were on shift just because I got better. faster solutions. I find that I generally know more about what's going on than the new first tier support people. Allan -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 8:39 AMTo: Multiple recipients of list ORACLE-LSubject: GR OWS Are these people at Oracle Support always this stupid??! I'm having an argument with an analyst regarding the permissions to the listener.log (which is set to full control) but keeps blowing errors!!! G Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
RE: Programming languages that make DBA's lives easier
My vote as well. If you don't know PL/SQL you are not too effective as a DBA. Just a point and click addict. Knowing the shell you are in and having a utilitiy language to use while you are in it are good additions. Although , if you use Unix I would add AWK and SED to that list. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Send Mail in Unix
UUENCODE the file then send it as text.UUDECODE it back to a file at the recipient. -Original Message- Sent: Thursday, February 13, 2003 9:44 AM To: Multiple recipients of list ORACLE-L All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Borderline OT - Unix for Oracle at home
Hey Dan; I currently am running a Sun Sparc 20 at home with oracle 8.1.7.4 and am adding 9.0.2. I got mine off of e-bay as you were talking about. The Sun software wasprety easyto load and configure so far. I have a DSL setup and its working just fine. I can even get to the DB from here at work . I am currently adding a lot of other features (like samba and a named daemon and such). As for e-bay there is both good and bad. First, you get what you pay for ... sight unseen. I ended up going back to e-bay after I got my sparc 20 to pick up a different motherboard (only cost me $12.50) because my original one was bad. Plus, I went back and got extra memory and drive space as well. All in all, the cost of the workstation was around 400. Right now it has 3 processors, 500 megs memory, and about 36 gigs of drive space. To cut it short . it was a good investment. Just took some time. -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: Borderline OT - Unix for Oracle at home I am looking to add a unix box to my collection of wintel machines at home. It will be used solely for running/testing Oracle, so I don't need bells whistles. My thoughts are either Linux/intel or Sun Ultra workstation. While it would be convenient to be able to network it into a DSL configuration, it is not essential. My original thought was a Linux desktop, but I can also get Ultra 5 or 10 workstations on ebay for less than $500. Anyone having experience good/bad/ugly for this type of task? All tips, challenges, things to consider are greatly appreciated. Dan Fink
RE: Borderline OT - Unix for Oracle at home
Definitely use SUN equipment if you use Solaris. Way too many questions and problems on the Solaris message boards related to getting Intel hardware to work right with solaris. Ugly. -Original Message-From: Richard Ji [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 11:01 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Borderline OT - Unix for Oracle at home Dan I personally run Linux/Oracle on all of my own test/dev boxes. But I'd like to vote for Solaris/Oracle. I would also recommand the Sun Blades, which are based on PC architectures and the advantage is it uses PC RAM and IDE hard drive, so it's cheaper than the Sun parts. You can get a 2GB of RAM from curcial for like two hundred bucks. Richard Ji -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 30, 2003 10:14 AMTo: Multiple recipients of list ORACLE-LSubject: Borderline OT - Unix for Oracle at home I am looking to add a unix box to my collection of wintel machines at home. It will be used solely for running/testing Oracle, so I don't need bells whistles. My thoughts are either Linux/intel or Sun Ultra workstation. While it would be convenient to be able to network it into a DSL configuration, it is not essential. My original thought was a Linux desktop, but I can also get Ultra 5 or 10 workstations on ebay for less than $500. Anyone having experience good/bad/ugly for this type of task? All tips, challenges, things to consider are greatly appreciated. Dan Fink
RE: Base conversion
Just happen to have this lying around CREATE OR REPLACE function base_x2y ( input varchar2, basein integer, baseout integer ) Return varchar2 is output varchar2(255); output_val integer := 0; char_valvarchar2(1) := null; number_val integer := 0; input_size integer := 0; pos integer := 0; begin select length(input) into input_size from dual; pos := 1; while pos = input_size loop select decode(substr(input,pos,1),'0', 0,'1', 1,'2', 2,'3', 3,'4', 4,'5', 5, '6', 6,'7', 7,'8', 8,'9', 9,'A',10,'B',11, 'C',12,'D',13,'E',14,'F',15,'G',16,'H',17, 'I',18,'J',19,'K',20,'L',21,'M',22,'N',23, 'O',24,'P',25,'Q',26,'R',27,'S',28,'T',29, 'U',30,'V',31,'W',32,'X',33,'Y',34,'Z',35, 0) into number_val from dual; select (output_val + number_val * power(basein,(input_size-pos))) into output_val from dual; pos := pos + 1; end loop; while output_val 0 loop number_val := baseout * ((output_val/baseout) - trunc(output_val/baseout)); output_val := trunc(output_val/baseout); select decode(number_val, 0,'0', 1,'1', 2,'2', 3,'3', 4,'4', 5,'5', 6,'6', 7,'7', 8,'8', 9,'9',10,'A',11,'B', 12,'C',13,'D',14,'E',15,'F',16,'G',17,'H', 18,'I',19,'J',20,'K',21,'L',22,'M',23,'N', 24,'O',25,'P',26,'Q',27,'R',28,'S',29,'T', 30,'U',31,'V',32,'W',33,'X',34,'Y',35,'Z',' ') into char_val from dual; output := char_val||output; end loop; return output; end; / -Original Message- Sent: Tuesday, January 28, 2003 9:45 AM To: Multiple recipients of list ORACLE-L For very obscure reasons (read: one of those developer decisions that you want to use a time-machine to go back and change), we're storing some information in base-36 (0,1,2,3...8,9,A,B,C,...,Y,Z) in a varchar field. And you thought hexadecimal was fun :-) Now some bright spark would like me to build some PL/SQL to do base conversion - in the first instance from base 36 to base 10 (i.e decimal). Has anyone done something similar in the past ... that I could borrow or co-opt? As you've guessed, the deadline is yesterday :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: strange SQL with TOAD
Do you have the Option, Show Rowid enabled under Options/Data Grids-Data ?? -Original Message- Sent: Tuesday, January 14, 2003 11:34 AM To: Multiple recipients of list ORACLE-L List, We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the why the statement is the way it is. The developer wrote Select to_char(sysdate,'mm-dd-') from dual; in a VB application. We use the Oracle and MS ODBC drivers to connect to the database. What I saw as the SQL statement: select ROWID,to_char(sysdate,'mm-dd-') from dual where ROWID = :v1 Where did the select ROWID come from? In other statements where the select written is Select table.* ... I see Select table.ROWID, table.*... Again, where does the ROWID come from? Is it a VB,/+ODBC thing that I should not be concerned with? Any links to the info would be helpfull in understanding the query. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Some of you may find this useful
Not bad at all . but now I get to ask if there is a way to improve it ... When running the query below, the following was returned : INSERT INTO TEMP_TABLE ( FIELD_1, FIELD_2, FIELD3 ) VALUES ( :b1,:b2,:b3 ) What I would like to know is is there any way thru Oracle to obtain the values for the bind variables that the query is using ?? Kevin -Original Message- Sent: Friday, January 10, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Log on as SYS and run it. I have it on my 8.1.7 DB. Dave -Original Message- Sent: Friday, January 10, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron [EMAIL PROTECTED] 01/10/03 05:03AM break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Orawomen
Title: RE: Orawomen April, I could tell back when I was in 8th grade that the Teaching System in Texas was a joke. I moved from Missouri to Texas that year andwent from a math class where we were doing geometry, trig, and algebra to a math class where they were teaching the Metric System. This was back in 1975. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Orawomen Be glad that you aren't in Texas. I DESPISE the testing system here. I realize that to a great extent it is needed (there are high school JRs who can't divide 6 by 3 and get an accurate answer) but they TEACH to the TEKS (or whatever the stupid name is this year). My 8 year old came home in tears because she was going to flunk 3rd grade (she came home in OCTOBER telling me this) because she went fromgetting an A in math to getting a Bwhen they started division.The logic in stressing her out like this? "We have never taken this test before, and we want to maintain our perfect school rating"... if our kids aren't perfect then we aren't perfect and we will loose our status in the community. She got a B... and it wasn't even on her report cardas a B... just on a test... she's 8. I would hate math and school too if allthat mattered to anyone was"the" test and the stellar reputation of the school. Sorry... sore subject. LOVED logic! IfA then B, If B then C, A therefore C... all dogs are animals with fur, but not all animals with furare dogs! April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Orawomen I don't know about you, but the first time I took a logic course it was in university... It seems to me it would be fun for high school students to take newspaper or magazine articles (Teen magazine comes to mind) and pull them apart to show that statement B doesn't necessarily follow from the previous paragraph, etc. In our logic class we had a lot of fun examining statements made by "pundits" in the media. But ooops! Logic falls under philosophy, that's not teachable in the public system, seen as irrelevant. Logic is done by unconscious habit by most people it seems to me, rarely consciously applied. So generalized statements abound, misperceptions spread... My 6 year old son has asked me at least three times now if it's OK for boys to play with Barbies... he doesn't have one but am thinking of purchasing him one for his birthday, just to see where he will go with that. My wife hates Barbies with a passion. But I think she hates Universal Soldiers more. ; ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 12:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Orawomen I will agree to some extent. But I have TRIED to get my daughter on the computers, into math and science, interested in anything technology... she tells me that Computers are geeky (she's 8). She is my militant little feminist and into sports and precision jump rope... I try to explain that I work with computers. The geeky logic doesn't always stick. April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Orawomen
I believe its hard to stop a snowball once its rolling downhill Jared -Original Message- Sent: Wednesday, January 08, 2003 12:40 PM To: Multiple recipients of list ORACLE-L I think this should be moved to the OT list. Thanks, Jared Rodd Holman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/08/2003 09:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Orawomen The real key to this issue is not making it a GS requirement, but in getting parents off their butts and being parents. I continually work with my kids, especially my daughters (ages 17,16,12) to be individuals and go for what they like and find interesting. Forget the pop culture and fashion junk you see in the mags and on the tube! I encourage them to be themselves and find contentment in that. This whole Dork Factor thing is out of control with the 10-19 age group, especially among girls. Rodd Holman [EMAIL PROTECTED] Romans 1:16-17 On Wed, 2003-01-08 at 07:54, Rachel Carmichael wrote: Dorky rules :) It's sad that there isn't a requirement for the science/math activities in the Girl Scouts. The problem is that society in general doesn't show images of science as being cool and definitely doesn't show images of women as scientists. Or at least, not enough images. --- [EMAIL PROTECTED] wrote: Dennis, I think that the article is correct that girls and teens are sensitive to the geek stigma factor.Even in our 10-year-old Girl Scout troop, the girls are already concerned about their images and not being too dorky. We have many more girls vote for activities involving animals and crafts than activities centered on math and science. The votes are usually about 8 to 1 with only one or two girls voting to do the math or science activities. Pretty sad, especially considering that the Girl Scouts organization tries really hard to push those technical and math/science programs and make them interesting and fun. The 25% number cited in the article for women in the IT sector seems pretty close to the number that we have show up at our local Oracle User's Group meeting. I think that the participation by women in our user's group has increased steadily in the last 10 years. Perhaps more women are drawn to database work than IT in general as it tends to be more administrative than say, programming. I'd also have to say that in many cases, being an Oracle DBA can be pretty grueling for those with families and for women with families in particular. Cherie Machler Oracle DBA Gelco Information Network DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: Sent by: Subject: Orawomen [EMAIL PROTECTED] 01/07/03 05:11 PM Please respond to ORACLE-L Recently this list had a discussion of female Oracle DBAs. The consensus was that the numbers were increasing, which I view as a good thing. Here is an article with industry statistics saying that the number of women in IT is decreasing. http://itmanagement.earthweb.com/career/article.php/1564501 Any theories? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora -1002
I was getting that when I tried to select accros a DB Link when my Database and my Client Code were at different levels. In our case, Database 8.0.5 and Client Code of 8.1.7 caused a failure. Since we upgrade our database to 8.1.7 all is well. What are the versions of your client code and database ?? Kevin -Original Message- Sent: Tuesday, January 07, 2003 4:34 PM To: Multiple recipients of list ORACLE-L HI. Does anyone have any info regarding ora-1002 error fetch out of sequence? All the info I've found on the MEtalink is referring to a PL/SQL or a select for update. All I'm doing is select from table@dblink and I'm getting ora-1002. I set autocommit off, but this didn't help. Does anyone have any ideas? thanks Gene __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: strange issue with setting transaction
Sergei; Is it a simple update/insert into a single table ?? Does the table have any triggers on it ? Do you commit anywhere in the update and then do another update/insert ? How about showing the update/insert code you are running. -Original Message- Sent: Friday, January 03, 2003 1:49 PM To: Multiple recipients of list ORACLE-L I am running 8.1.6 on solaris 2.8. Before running a large update, I tried to set a specific rollback segment by: Set transaction use rollback segment RBIG20; The transaction runs for a while and fails with: ORA-01555: snapshot too old: rollback segment number 29 with name R27 too Small Any idea? Thank you Sergei -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SavePoint doubts
No. -Original Message-From: Shishir Kumar Mishra [mailto:[EMAIL PROTECTED]]Sent: Friday, January 03, 2003 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: SavePoint doubts Hi List, One dumb question I wantto ask is : Is it possible to declare Savepoint with same name in different session on same database. I just want to know will commit or rollback vanish savepoint with same namein other session also . Thanks and Regards Shishir Kumar MishraAgni Software (P) Ltd.www.agnisoft.com
RE: doubt
Excuse the heresy for answering an SS question on this list. When I first read that statement I was wondering why you would be asking a question about the Nazi SS on an Oracle List . then it dawned on me that you were talking about Microsoft SQL Server ... at which point it did not mater ... Nazi SS ... Microsoft ... prety much the same thing. -Original Message-From: Grant Allen [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003 9:20 AMTo: Multiple recipients of list ORACLE-LSubject: RE: doubt Excuse the heresy for answering an SS question on this list. Jai, you can fight with the INFORMATION_SCHEMA views, or use sp_help to see all the objects for allusers(not just tables). If you looking for just tables, and only for a given user, use select o.namefrom sysobjects o, sysusers u where o.uid = u.uidand o.xtype = 'U'and u.name = 'yourusernamehere' (obviously change the yourusernamehere bit to the username desired). You might want to try the usenet comp.databases.ms-sqlserver group for more info. Ciao Fuzzy (yech ... I'm sorry, the MS brainwashing must be stronger than I thought ... I have this irresistible urge to clap my hands and sway back and forth with a moronic grin on my face after thinking of SQL Server. Can anyone suggest a therapist? :-) :-) :-) ). -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: Thursday, January 02, 2003 14:04To: Multiple recipients of list ORACLE-LSubject: doubtDear all, we use "select * from tab" to list all objects in a particular user in oracle. could you tell me the equivalent query in sql server ? Regards Jai
RE: Automatic backup on Oracle 9i -- For Jared
Lighten up Frances -Original Message- Sent: Thursday, January 02, 2003 10:46 AM To: Multiple recipients of list ORACLE-L Although I hate to make my first submission to The List in 2003 as negative one, I would still like to suggest that text messages have no place in a forum such as this. Quite apart from being needless, such a message format shows a total lack of respect for the recipient and a distinct arrogance towards technology by trying to interchange a message format between totally different media. Even if the message in question was indeed in an acceptable format, the content clearly shows that no effort has been made to do any research on the subject matter. I have a deep affection and respect for this List and how there is such readily available help from it. So OraCop, I would say that you should try a more considered approach and you may be pleasantly surprised. -Original Message- WILLIAMS Sent: 02 January 2003 15:30 To: Multiple recipients of list ORACLE-L Raj - I go through episodes where I get pretty frustrated with the cryptic language, but then I take a deep breath and remember that for some people English isn't their first language. Also, I think text messages on cell phones are changing the way many people deal with English. I also get irritated with people who won't post their names. It is hard to reply to an anonymous person. But then I recall that I previously worked for a company that wouldn't let me post to newsgroups. It would be easier if people would pick a nom de plume that was more human, like Joe Smith. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, January 02, 2003 7:40 AM To: Multiple recipients of list ORACLE-L As far as we know there is no bandwidth limit on this list and problems can be understood better if you state them in a lucid and clear language. I had to really read twice (sorry haven't had my Great One yet) to understand the abbreviations. Am I the only one or is there anyone else who has trouble with such language? TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, December 31, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Jared what exactly U use Veritas Netbackup fr in Ur backup strategy. I use rman to take backup on disk. Please describe the role of veritas NB in detail and if u can send me example script to perform what tasks, that would be gr8. OraCop -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1410 Silliness
Title: ORA-1410 Silliness How about posting the table structure and the lines around 1970 in the Elvis package. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Nope... nothing named rowid. -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Is there a column with a datatype of rowid? -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness Hello all, 8.1.7, Windows 2000 SP2 Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 Has anyone seen this error before? I run into this error periodically during data loads. I have done the following to search for the root of the problem: 1. No code references ROWID. Deletes are never applied to this table. 2. No inline views in any of the code. 3. Ran dbv on all datafiles while database was down. No problems identified. 4. Ran analyze table table name validate structure cascade on all recent partitions. No rows found in INVALID_ROWS table. 5. Was able to export the entire table without any problem. I can't easily drop the indexes and recreate them. This is a very large table - ~25GB, 38 million rows. I also can't easily export/drop/recreate/import. Usually when this happens I can re-fire the load and it will complete, no problem. It's a big annoyance and it seems like every time I take a day off it happens. Any ideas, suggestions, or thoughts are appreciated. Thanks everyone. Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
RE: ORA-1410 Silliness
,fac_code,owner_last_name,owner_first_name,owner_address1,owner_address2,owner_city,owner_state,owner_zip,net_purchase_price,original_down_payment,total_down_payment,cr_bal,interest_rate,first_payment_date,qualification_code,payment_amount,payment_frequency,aging_10_to_30_days_due,aging_31_to_60_days_due,aging_61_to_90_days_due,assigned_loan_admin_rep,date_of_sale,status_of_account,contract_type,was_pender,credit_life_on_contract,document_status_code,fixed_week_sale,udi_sale,phase_number,fairshare_plus_member,points_owned,deed_date,pre_auth_draft_account,reservation_code,international_code,unit_phase_completion_code,aging_0_to_90_days_due,aging_91_to_120_days_due,aging_121_to_150_days_due,aging_151_over,lot_location,payments_made,suppression_code,accrued_interest_bal,pac_freeze_code,credit_card_freeze_code,association_number,rfs_assignment_date,override_maint_fee_balance,reservation_pending,credit_reporting_code,cancel_deferment_reason_code,equity_in,date_coded_7,adjustable_rate_mortgage,number_of_pays_left,deferred_interest,deferred_principal,current_year_deferments,current_year_total_deferments,last_payment_date,next_payment_date,pac_due_date,eft_routing_number,eft_account_number,eft_manual_number,bank,status_change_date,assigned_loan_rep,credit_card_pac_account,principal_balance,cr_discount_balance,credit_life_prem_bal,rfp_pac_code,rfp_draft_code,rfp_route_number,rfp_eft_number,rfp_manual_number,rfp_bank_name,fppa_pac_code,fppa_draft_code,fppa_route_number,fppa_eft_number,fppa_manual_number,fppa_bank_name,ts_bal_due_recognized,ts_late_fee_recognized,ts_ytd_maint_fee_coll,ts_maint_fee_amount,po_birth_date,ssn,ts_location,cr_date_rec_in_deeding,area_code,phone_number,cr_refund,cr_credit_life_type,cr_qualification_date,cr_eqt_in_from_cont_no1,cr_eqt_in_from_cont_no2,cr_hc_amt1,cr_hc_amt2, -- Line 1970cr_hc_post1,cr_hc_post2,cr_hc_date1,cr_hc_date2,cr_date_in_lr,cr_trade_allow,cr_title_ins_charged,cr_title_ins_collected,cr_filing_fee_charged,cr_filing_fee_collected,cr_accrued_int_bal_rsv,cr_late_fee_bal_rsv,fico_scoreFROM vegas_rawWHERE id = vegas_raw_rec.id; Makes no sense at all. And if you read this far, don't say I didn't warn you. -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness How about posting the table structure and the lines around 1970 in the Elvis package. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Nope... nothing named rowid. -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Is there a column with a datatype of rowid? -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-1410 Silliness Hello all, 8.1.7, Windows 2000 SP2 Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at "ELVIS.CLEANUP_VEGAS_PK", line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 Has anyone seen this error before? I run into this error periodically during data loads. I have done the following to search for the root of the problem: 1. No code references ROWID. Deletes are never applied to this table. 2. No inline views in any of the code. 3. Ran dbv on all datafiles while database was down. No problems identified. 4. Ran analyze table table name validate structure cascade on all recent partitions. No rows found in INVALID_ROWS table. 5. Was able to export the entire table without any problem. I can't easily drop the indexes and recreate them. This is a very large table - ~25GB, 38 million rows. I also can't easily export/drop/recreate/import. Usually when this happens I can re-fire the load and it will complete, no problem. It's a big annoyance and it seems like every time I take a day off it happens. Any ideas, suggestions, or thoughts are appreciated. Thanks everyone. Lisa Koivu Oracle Dorkbase Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
RE: Those Pesky Little Audit Files (ora_99999.aud)
Thanks. Guess its clean-up job time. -Original Message- Sent: Thursday, December 26, 2002 7:59 PM To: Multiple recipients of list ORACLE-L IIRC, these files are generated whenever someone logs in as sysdba or internal. I don't know of any way to stop them. --- Kevin Lange [EMAIL PROTECTED] wrote: I thought I had these files stopped but apparently not. Is there somone out there who can tell me how to stop the Audit files from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Versioning the Database !
Used to use that method in a former company with our DB2 database. We had one DB with schemas of DBPROD, DBTEST, DBSTST, and DBRTST. At various testing stages we would move the objects to a different schema The application had a variable for who owned the structure. That way we could be developing (DBTEST), in the development test phase (DBRTST), into user acceptance testing (DBSTST), and into production (DBPROD) with different versions all at the same time. I could see it happening with Oracle as well..but why not just use different instances to house the different stages of development. That way you can have everything under the same schema and not have to worry about any synonym or schema switching. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 1:44 PM To: Multiple recipients of list ORACLE-L I am in a peculiar situation where the development design is happening in parellel. It would table definitions, table data (Reference Data), View definitions, the design itself ( LDM). It would be a situation, where there are different schema's need to be maintained at different stages of the project (Devlp, IT, QA, Staging). Since these activities would be parellel versioning would help. Hence this versioning. Regards Shree -Original Message- Sent: Friday, December 27, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Versioning the database ? Take a backup of the database on a seperate tape each day ! What components of the database do you want to version ? Table definitions ? View definitions ? Packages/Procedures/Triggers ? Code Objects should be versioned, but data objects [Tables/Indexes/Sequences] would generally not vary once the design is done, save for a few changes/additions/enhancements. Hemant At 06:28 AM 27-12-02 -0800, you wrote: Hi, I want to version the Database for development, IT, QA and staging environment. Can some one suggest different methods and best possible approach to maintain the database. Database is in design stage development has partially started. We are using MKS for versioning. Regards Shree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (CAP, CARD) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Rama, Shreekantha (CAP, CARD) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: compile errors
Does the compiling ID have a direct grant on the package P_MESSAGES If you have access to it via a grant on a role and not a direct grant, then you will get error messages like this.Check your authorities and see if you have a direct grant. -Original Message- Sent: Thursday, December 26, 2002 2:59 PM To: Multiple recipients of list ORACLE-L List, Can anybody tell me what is happening here. I am constantly getting the PLS-00201 error when I try to compile. It is looking inside the package at a procedure and saying the identifier must be declared. I have gone over metalink docs and notes. I first compile the package spec and then the package body. I get the following response: SQL alter package schema.p_messages compile package; Warning: Package altered with compilation errors. SQL show errors Errors for PACKAGE schema.P_MESSAGES: LINE/COL ERROR - 193/5PL/SQL: Declaration ignored 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared 218/5PL/SQL: Declaration ignored 219/34 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared SQL alter package schema.p_messages compile body; Warning: Package Body altered with compilation errors. SQL show errors Errors for PACKAGE BODY schema.P_MESSAGES: LINE/COL ERROR - 0/0 PL/SQL: Compilation unit analysis terminated 1/14 PLS-00905: object schema.P_MESSAGES is invalid 1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its specification thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: compile errors
I think you do. I would suggest that you go ahead and try it with the grant. Should be very easy to test out that way. -Original Message- Sent: Thursday, December 26, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Yes, I read that off of metalink. I granted execute any procedure to the user. And still got the same error. Do I still need a direct grant off of that package? thanks. -Original Message- Sent: Thursday, December 26, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Does the compiling ID have a direct grant on the package P_MESSAGES If you have access to it via a grant on a role and not a direct grant, then you will get error messages like this.Check your authorities and see if you have a direct grant. -Original Message- Sent: Thursday, December 26, 2002 2:59 PM To: Multiple recipients of list ORACLE-L List, Can anybody tell me what is happening here. I am constantly getting the PLS-00201 error when I try to compile. It is looking inside the package at a procedure and saying the identifier must be declared. I have gone over metalink docs and notes. I first compile the package spec and then the package body. I get the following response: SQL alter package schema.p_messages compile package; Warning: Package altered with compilation errors. SQL show errors Errors for PACKAGE schema.P_MESSAGES: LINE/COL ERROR - 193/5PL/SQL: Declaration ignored 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared 218/5PL/SQL: Declaration ignored 219/34 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared SQL alter package schema.p_messages compile body; Warning: Package Body altered with compilation errors. SQL show errors Errors for PACKAGE BODY schema.P_MESSAGES: LINE/COL ERROR - 0/0 PL/SQL: Compilation unit analysis terminated 1/14 PLS-00905: object schema.P_MESSAGES is invalid 1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its specification thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Those Pesky Little Audit Files (ora_99999.aud)
I thought I had these files stopped but apparently not. Is there somone out there who can tell me how to stop the Audit files from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: kinda OT: veritas netbackup
How about running a script just before the backup that 1) Reads the current log number. 2) Forces a log switch. 3) Copies the logs to a seperate directory. 4) Backups up that seperate directory Leave the archive directory alone. Do not back it up. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: kinda OT: veritas netbackup RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe
RE: kinda OT: veritas netbackup
In that case Brian ... sorry, not going to be any help. Good luck. -Original Message-From: Spears, Brian [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: FW: kinda OT: veritas netbackup Yes, we have coded it to do thisand it works but for many reasons.. including simplicitywe want to avoid thissolution for theentire12B enterprise solution... when it confuses others, and is much more vulnerable for screwups with Mount point management and recovery. Brian Spears -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: kinda OT: veritas netbackup How about running a script just before the backup that 1) Reads the current log number. 2) Forces a log switch. 3) Copies the logs to a seperate directory. 4) Backups up that seperate directory Leave the archive directory alone. Do not back it up. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: kinda OT: veritas netbackup RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe
API for TNSPING
Does anyone happen to have a pointer to documentation on any APIs for TNSPING that exist ?? One of our developers is putting together a page and he would like to get the value of the 'length of time' that TNSPING returns. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Happy Holidays
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
Bob; I do have a set of sqlplus scripts that we wrote for 7.3.4 that generate DDL for objects in the database. So, you can write your own. All the neccessary information is in the catalog. -Original Message- Sent: Wednesday, December 18, 2002 9:16 AM To: Multiple recipients of list ORACLE-L I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sun Solaris
Go to this page and join the SOLARIS-L list. http://www.openitx.com/nav/t.asp?t=507p=607h1=507h2=571h3=607 This page has a bunch of other OS lists as well. -Original Message- Sent: Monday, December 16, 2002 9:59 AM To: Multiple recipients of list ORACLE-L List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help Urgent Where is Tablespace Manager??
Title: RE: Help Urgent Where is Tablespace Manager?? OEM had the tablesapce manager in it. Its called the Storage Manager now. Maybe that is where the mixup is ? Run oemapp by itself. It will tell you which applications are loaded. If you have loaded it, you should see STORAGE in the list. If its been loaded , then start it up using oemapp storage -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002 7:59 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Help Urgent Where is Tablespace Manager?? What is the tablespace manager? When I bring up DBA studio I do not see it anywhere. 8.1.6 on NT Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 5:14 PM Subject: RE: Help Urgent Where is Tablespace Manager?? This is driving me crazy. Can't seem to find the tablespace manager which I used to pull up from DBA Studio - now I have a different version which doesn't have DBA Studio - where has it been moved or is there a replacement? Help! -Original Message- From: orafaq [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:04 AM To: Multiple recipients of list ORACLE-L Subject: Re: Increase size of data files and rollback segments A cruel joke Jeremy! BTW may be you can help me out here. I am not receiving back any of the messages I send to the the list and I do not know if list is receiving my messages either. Do you know how to solve this problem? Thanks in advance Shaleen Garg - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, December 09, 2002 3:38 AM On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: archiving redo logs
Title: RE: Oracle 9i installation - Basic Qs - HELP! And what is the problem with having a standby DB on a different OS than the primary ??? -Original Message-From: Bala Regupathy [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002 2:06 PMTo: Multiple recipients of list ORACLE-LSubject: archiving redo logs Hi, How can I archive redo logs automatically to a different machine ?. Standby database is not an option because the target machine's OS is different from the primary. Primary db is 8.1.7.2 resides on SUN E10k with SunOS 5.8. Target server is DEC Alpha 4.0 If UNIX script is the only option, I appreciate if you can share it here. Thanks, Bala.
RE: To_Number
Title: To_Number
I
believe its the $ and , in the data. I got the same error until I
did
select
to_number(replace(replace(unit_cost,'$',''),',','')) from
elas.qdr
-Original
Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 1:24
PMTo: Multiple recipients of list ORACLE-LSubject:
To_Number
I have a table which contains a
Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I
enter select
to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: invalid number.
Is there any other way to do
this? I am trying to add a varchar2 field
that contains $ and commas. I thought the
to_number function would convert the data to a number field.
Thanks,
Laura
RE: To_Number
Title: RE: To_Number
Lisa;
I wonder if it depends on the DB version. I did this on an 8.0.5 and
got the invalid number error running the exact query that succeeded on
yours. I had to do a replace on both the commas and the dollar
sign.
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002
1:55 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: To_Number
Laura are you sure you aren't trying
this with the quotes? See below
SQL select * from
testnum;
COL1 --- $24,990.09
SQL select
to_number('col1','$999,999,999.99') from testnum; select
to_number('col1','$999,999,999.99') from testnum *
ERROR at line 1: ORA-01722: invalid number
SQL select
to_number(col1,'$999,999,999.99') from testnum;
TO_NUMBER(COL1,'$999,999,999.99') -
24990.09
Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259
Coconut Creek Parkway Ft. Lauderdale, FL,
USA 33063
-Original Message- From: Burton, Laura L. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Subject: To_Number
I have a table which contains a Unit_Cost
varchar2(16) which contains $34,000.05. I
can enter
select
to_number('$34,990.08','$999,999,999.99') from dual; and the results
is 34990.08.
However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get
ora-01722: invalid number.
Is there any other way to do this? I am trying to add a
varchar2 field that contains $ and commas. I thought the to_number
function would convert the data to a number field.
Thanks,
Laura
RE:
David;
Try the parameter
show=Y
on the import command. This should show you whats in the export file.
example parm file:
FILE=('expdat.dmp')
LOG=('temp.log')
FULL=Y
SHOW=Y
-Original Message-
Sent: Monday, November 25, 2002 3:41 PM
To: Multiple recipients of list ORACLE-L
List,
Is there anyway to know absolutely that a table is not in an export file?
My import bought in 6 tables, but not the seventh ( I don't think it is in
the export). The import bought in the other 544 tables! I have queried
under the schema name, after logging in as that user:
select table_name from user_tables
where table_name like '%BATCH_%';
all other tables are there like they should be, but not the 7th table. This
is 8.1.7 to 8.1.7. When I imp I get IMP-00033 Warning table not found in
export file. When I test my imp statement against one of the other tables
from the export file that I know are there under the schema owner I get:
IMP-00015 object already exists. I can't convince this guy the table is
not there. What else can I do?
David Ehresmann.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ltrim?
The cron part is easy but you have to make sure your Unix script works. Next time, before you post a question ... please try looking up the answer for yourself on any of the available sources. In this case, the man function of unix tells you exactly what you need to know.You should have done a man on crontab. 00 06 * * 5 your_unix_script minute (0-59), 00 = 0 minutes hour (0-23), 06 = 6 am day of the month (1-31), month of the year (1-12), day of the week (0-6 with 0=Sunday). 5 = Friday command name -Original Message- Sent: Friday, November 22, 2002 8:19 AM To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could help me how to write in cron when scheduling the start of a unixprogram. I would like that the unix script will run every monday on 6 am. I have tried but it fails. Any suggestions, please help Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Identifying indexes
This may not do all you need but it will list out all the indexes in dba_indexes that do not have a corresponding entry in the dba_constraints table. You might have to put a few other criteria on it ... but this might get you in the right direction. select a.owner, a.index_name, a.table_owner, a.table_name from dba_indexes a where not exists ( select '' from dba_constraints b where a.owner = b.owner and a.index_name = b.constraint_name) -Original Message- Sent: Friday, November 22, 2002 12:40 PM To: Multiple recipients of list ORACLE-L I am trying to find out what indexes are in the database only for performance reasons and do not enforce a constraint. What would be the query to do that? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Identifying indexes
1. Since DBA_CONSTRAINTS is already connecting to cons$ and cdef, why are
you using them in your join ?
2. Why are you joining to dba_objects ?? What purpose does it fill ?
3. Why not just join dba_indexes to dba_constraints and rule out the kind of
constraints you are not interested in ... i.e. Check Constraints ?
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
I don't get it. Do a minus? Mr. Shao could you explain that please.
RWB
Shao, Chunning [EMAIL PROTECTED]@fatcity.com on 11/22/2002 02:49:15 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
The following will give you all the indexes that belongs to a constraint
select distinct t.owner as table_owner, i.table_name, o.owner as
index_owner, o.object_name as index_name,s.name as
constraint_name,c.constraint_type from sys.cdef$ cd,dba_objects o,sys.con
$ s,dba_constraints c,dba_indexes i, dba_tables t Where t.Table_Name =
i.Table_Name and i.owner=o.owner and i.index_name=o.object_name and
c.constraint_name=s.name and cd.Enabled = o.object_id and cd.con# = s.con#
and o.owner not in ('SYS','SYSTEM')
do a minus will get what you want.
-Original Message-
Sent: Friday, November 22, 2002 1:40 PM
To: Multiple recipients of list ORACLE-L
I am trying to find out what indexes are in the database only for
performance
reasons and do not enforce a constraint. What would be the query to do
that?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Shao, Chunning
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: catrepad - how tell if run
Why not open the script up find an object created with that script ... then log onto your database and see if the object is there. ? -Original Message- Sent: Friday, November 15, 2002 1:39 PM To: Multiple recipients of list ORACLE-L How can you tell if catrepad.sql has already been run on a database? I am sure that catrep has already been run, but not catrepad. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent : Shell Script is needed !!!!!
Title: Blank Madhu Three years ago we wrote a system that would except files from an outside data system, take those files and , in a rotating 18 month cycle, load the data into a partitioned view dropping the oldest set of data and adding the next set in its place. Ifs complicated, but if you think you might be interested in looking thru it to make your own,I can find the SQL code and UNIX code that went with it. If you would be interested, contact me offline at [EMAIL PROTECTED] . I will need to take the time to find the code outside of work. Kevin -Original Message-From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 14, 2002 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Urgent : Shell Script is needed ! Hello All, I have to do automation of manual process of the following things, being not good at the Shell scripting , I need your help or at least a sample script would be great Manual process: 1. get the oldest partition name from a partitioned table 2. create a non-partitioned table same as the oldest partition name from the partitioned table with the same structure 2. exchange the partition with the newly created table 3. then export the new table to a Unix directory. Later I have to drop the oldest partition .( For this we have a procedure to take care of ) Regards, Madhu Reddy
RE: AIX vs Solaris
Bill; I came from a shop that ran AIX servers and Oracle 7.3.4 to 8.1.7. As for the OS and Oracle, all our 7.3.4 scripts worked just fine when we were under 8.1.7 we used the k-shell exclusively as well. I do not think you have any problems there. As for AIX in particular . I loved it. It was very easy to manage and update. Plus, the journal file system was supurb. We had very few crashes on the hardware (at the time we were running an S70a with over 70 or so SSA drives). We did have a couple system crashes due to failed hardware ... but when the system came back up the journals would automatically replay and our Oracle systems would come back with no recovery neccessary. As for maintenance we had a contract with IBM where they were out to our location within 24 hrs and they were very efficient. I remember they Engineer staying there with us for about 48 hours as we all tried to find the problem with the hardware (turned out to be a 25 dollar circuit on the hot swap drive tray). The point is they had very good service techs. What I also liked on AIX was the ease at file system setup, patch application and tracking, and overall System Administration. (Yes , I am biased towards AIX). At my new location we are running Solaris with a Netapp filer . nice combination. The WAFL file system on the netapp is most excellent for use with Oracle. The bad side of AIX was always the cost. The hardware was damn costly , the software was damn costly, and the maintenance contract was damn costly .. get the trend here ?? Well, there is my two cents worth. You might go out to Suns site and get the list of features for their OS and then go to IBMs site and get its features list and compare. Good luck Kevin -Original Message- [mailto:becker.bill;marshfieldclinic.org] Sent: Wednesday, November 13, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Hello, What are the major differences between AIX and Solaris regarding operating system features? We are planning a new machine purchase; currently we are on a Sun machine running Solaris, but IBM is making a strong proposal to management (meaning significantly less cost), and we are wondering what would need to be changed. We use korn shell scripts extensively, and features such as crontab, background processing, the sqlplus EOF ... EOF construct (not sure what this is called). I'm fairly sure these are standard in most flavors of unix, but I have never had contact with AIX. Does anyone know what features differ between the two OS's? If we went with Solaris, we would go with Solaris 9 running Oracle 9.2 on a Sun 4800. Thanks for any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to Excel
Title: Oracle to Excel Without extra software the easiest way is to setup a delimited file in a sql statement and spool output to a file. Then import the file into a spreadsheet. If you have it, Toad will save data into spreadsheets for you. -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle to Excel I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet. We now have a need for this. Could anyone enlighten me? Thank you in advance. Laura
RE: Oracle to Excel
Title: Oracle to Excel Brain freeze thats the only reason I did not think of it doh ! -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 1:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle to ExcelIs there a reason why you can't just extract it directly in to Excel using ODBC or Oracle Objects for OLE? ODBC would be the easiest, OO4OLE will give you the most control and better macro scripting for auto updating. Both of these come with the Oracle client install. Rodd On Wed, 2002-11-06 at 13:12, Kevin Lange wrote: Without extra software the easiest way is to setup a delimited file in a sql statement and spool output to a file. Then import the file into a spreadsheet. If you have it, Toad will save data into spreadsheets for you. -Original Message- From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 06, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: Oracle to Excel I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet. We now have a need for this. Could anyone enlighten me? Thank you in advance. Laura -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED]
RE: RE: Oracle DBA with SAP Needed
FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Brain Teaser Challenge
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
End of Communication Channel Error
Hey Gang; Anyone here familliar with an End Of Communication Channel error every time I try and Build a database ?? I am trying to build an 8.1.7.0 database on a Sun Sparc 20 running Solaris 9. I have a feeling it might be settings on the box itself, but thought I would ask the list just in case anyone had any insight. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Error ORA-12638 Credential Retrieval Failed During DB Creatio
Moses; You can get this patch by ftp'ing to updates.oracle.com. I already did and saw that it was there. Log in with your Metalink User ID and Password Then CD to the patch number. You can not list the patches , nothing shows up. Just CD to the number and then ls to see the patch. I did this and got the following : ftp open updates.oracle.com Connected to ap103aru.oracle.com. 220 FTP server ready. User (ap103aru.oracle.com:(none)): x 331 Username OK, please send password. Password: 230- 230- Welcome to the Oracle Patch Download FTP Server 230- 230- Access 230- -- 230- Access to this system is limited to authorized users of Oracle 230- Metalink. Unauthorized access to or use of this system is prohibited 230- and may subject you to civil and criminal prosecution. Use of this 230- system may be monitored for the purpose of maintaining system 230- security, and system information may be accessed or disclosed under 230- limited circumstances. 230- 230- All transmissions of Oracle software, documentation, source code, 230- technical data or technology must comply with Oracle's Export 230- Compliance Corporate Policy. For more information, refer to Oracle's 230- Internal Export Control Compliance Manual or contact your division's 230- Export Control Officer. 230- 230- Usage 230- - 230- To download a patch, you must know the patch number. At any time you 230- can cd patch number and then ls to find a listing of patches 230- with that number. Enter quote site help to get this welcome banner 230- and additional helpful instructions. 230- 230- Caveats 230- --- 230- - You may not list files or directories from the root directory. 230- - You must select binary transfers for this service to work. 230 ftp cd 1522966 250 Changed directory OK. ftp ls 200 PORT command OK. 150 Opening data connection for file listing. p1522966_8170_WINNT.zip 226 Listing complete. Data connection has been closed. ftp: 25 bytes received in 0.00Seconds 25000.00Kbytes/sec. ftp -Original Message- Sent: Friday, October 25, 2002 9:35 AM To: Multiple recipients of list ORACLE-L Creatio I doubt if 8.1.6 is supported on Win XP. - Kirti -Original Message- Sent: Friday, October 25, 2002 2:38 AM To: Multiple recipients of list ORACLE-L Using DBCA Hi gurus, I just installed Oracle 8.1.6 on Windows XP successfully. However on creation of database using the Database Configuration Assistant, I get the error ORA-12638 'Credential Retrieval Failed' on initialisation of database and thereafter the process stalls. I visited Metalink and found out that I require patch 1522966. However, this patch cannot be found. Does any one have it? Secondly, I am using SQLNET.AUTHENTICATION_SERVICES= (NTS) in my SQLNET.ORA file (which is suggested as a probable fix to no avail. Any suggestions? Moses Moya Ngati -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Error ORA-12638 Credential Retrieval Failed During DB Creatio
This is an 8.17 patch, not an 8.16 -Original Message- Sent: Friday, October 25, 2002 9:35 AM To: Multiple recipients of list ORACLE-L Creatio I doubt if 8.1.6 is supported on Win XP. - Kirti -Original Message- Sent: Friday, October 25, 2002 2:38 AM To: Multiple recipients of list ORACLE-L Using DBCA Hi gurus, I just installed Oracle 8.1.6 on Windows XP successfully. However on creation of database using the Database Configuration Assistant, I get the error ORA-12638 'Credential Retrieval Failed' on initialisation of database and thereafter the process stalls. I visited Metalink and found out that I require patch 1522966. However, this patch cannot be found. Does any one have it? Secondly, I am using SQLNET.AUTHENTICATION_SERVICES= (NTS) in my SQLNET.ORA file (which is suggested as a probable fix to no avail. Any suggestions? Moses Moya Ngati -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA vs JAVA programmer???
My only comment is ... New Jersey over Colorado Are you mad woman -Original Message- Sent: Friday, October 25, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Hi all, I need your idea. I got laid off as an Oracle DBA (3 yrs experience), and it's hard to find a DBA position here(I'm in Colorado). I had couple of years experience programming (3 yrs) in VB, and currently learning JAVA. I'd like to know is JAVA market still hot? (I can relocate to New Jersey, any memeber in New Jersey? how is the market over there, for Oracle DBA or JAVA programmer?) What do you think which position is better, Oracle DBA or Java programmer? Based on compensation, workload, market demand, etc, etc ... Thanks a lot! Janet __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB monitoring using SNMP MIBs
hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Flat file generation integrity ideas...
Title: Message Trouble with this is that there is a possibility that a change in the number in the file could result in the same sum. Then you have different data but your checks says everything is ok. Checksums are far more accurate. -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 24, 2002 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Flat file generation integrity ideas... (slapping my forehead) Duh. Nice. I like it. Simple but effective. Minimal impact on performance. And easy for the other systems to implement. You da man, Tom, I don't care what Jared and Rachel said about you... Thanks. -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Flat file generation integrity ideas... Chris, have you thought aboutsumming a number column in the record and placing this sum in a trailer record? this way, you have a header and trailer record which helps you be confident that the whole file made it to the target system. and by comparing the sum of the imported records with the trailer record, it gives you a better level of confidence that things didn't get scrambled. I used to do all sorts of these things when file transfer was not as good as it is now. the above method is pretty simple, easy to do, and pretty accurate. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 24, 2002 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if "somehow" a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
RE: Flat file generation integrity ideas...
Title: Flat file generation integrity ideas... Chris; I would suggest the following: 1. Generating Check Sums of the files before they are sent. 2.Send the files. 3. Generating an after Check Sum and compare. Here are the steps I go thru to make sure our Oracle Archive Logs are correctly transfered to our Standby Server: 1. Zip the Archive Logs into 1 Zip. 2. Check Sum the Zip. 3. Use the TEST option to make sure the Zip is good. 4. RCP the zip file to the standby location. 5. RSH a test of the Zip. 6. RSH a Check Sum of the Transfered Zip and compare to original value. 7. Unzip the file With this method you have 2 independent checks the Check Sum and the Zip Integrity Check. -Original Message-From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 24, 2002 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record count is stored on the first line of the file to ensure that the correct amount of records was received. The systems group is chartered to ensure the flat files are correctly FTPed between systems, so that's covered. I just worry that if "somehow" a flat file is scrambled then the scrambled data is loaded into the database, therefore corrupting it. At this phase, XML is not an option I keep thinking that some sort of CRC should be stored with each line in the flat file. And then before the line is loaded into the database, the CRC is compared against the generated CRC of the just read line. Has anyone done anything like this? Any examples out there? Many TIA!!
RE: DB monitoring using SNMP MIBs
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: secure connection
These days . just hire a 15 year old kid with a computer at home He might do beter than an expensive 'security firm' ... -Original Message- Sent: Thursday, October 24, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Hire a special company that handle this. We are doing it to see how unbreakable are our servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:08 PM Hi, how can I be sure that the connection between our web server and Oracle Server to be secure. What's the best method to accomplish this? Any good links for Oracle Nwtwork Security. Any help would be greatly appreciated. Murat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle or mssql
Its been a while since I used MS SQL but one of the downsides that I experienced was the fact that MSSQL could not support the user loads we needed right out of the box. We had to cluster servers together to get the throughput that we got out of Oracle. MSSQL might be cheaper at the database software level but it was more expensive at the hardware level.. at least in our case. -Original Message- Sent: Wednesday, October 23, 2002 10:09 AM To: Multiple recipients of list ORACLE-L No it doesn't. MicroSoft is a card-carrying member of the Axis Of Evil. Last I heard they were developing nuclear weapons, probably in a huge bunker under Bill Gates' house. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, October 23, 2002 8:54 AM To: Multiple recipients of list ORACLE-L It depends on your companies needs. On Tue, 22 Oct 2002 [EMAIL PROTECTED] wrote: Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So why he should not choose mssql is the question g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback segment space usage
SELECT r.NAME, -- rbs name s.sid, s.serial#, s.username, s.machine, t.status, t.cr_get, -- consistent gets t.phy_io, -- physical IO t.used_ublk, -- Undo blocks used t.noundo, -- Is a noundo transaction SUBSTR (s.program, 1, 78) COMMAND, s.username DB User, t.start_time, s.sql_address Address, s.sql_hash_value Sql Hash FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r WHERE t.addr = s.taddr AND t.xidusn = r.usn ORDER BY t.start_time Try this. It shows the undo blocks used in the rollback segment. Plus some other variables for query usage. -Original Message- Sent: Wednesday, October 23, 2002 12:02 PM To: Multiple recipients of list ORACLE-L Hi all, Trying here now since have tried to find it online and build the query myself. I need to figure out how much space a user/session is using of a rollback segment. I got the queries to show which segment the user is attached to but need to know how much is being used (something like a fuel gauge). Any takers. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Theory v Practice
-- Make sure that they wear clothing in bright colors. Not exactly a nice comment Gogala I have friends in that area who are dealing with the sniper every day I am sure there are others as well. -Original Message- Sent: Wednesday, October 23, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Can you send them to oracle training in Bethesda, MD or Reston, VA? Benefits could be multiple, especially for you. Make sure that they wear clothing in bright colors. -Original Message- From: Craig Healey [mailto:C.Healey;hhsuk.com] Sent: Wednesday, October 23, 2002 1:45 PM To: Multiple recipients of list ORACLE-L Subject: Theory v Practice The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as they say they will handle all the constraints via VB. I only have a theoretical knowledge of database design, which says this is very wrong. Is the Oracle system being used as anything more than an expensive file system? In real world scenarios, is this a common practice? Regards Craig Healey ** 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 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. Statements and opinions expressed in this e-mail may not represent those of the company. 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 for the presence of computer viruses (www.mimesweeper.com) ** * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB monitoring using SNMP MIBs
Title: RE: DB monitoring using SNMP MIBs
Yes. You can use PERL to do such things such as getting the
database state, name, consistent gets, system block gets, etc from
SNMP:
#!/usr/local/bin/perl
use
BER;
use
SNMP_Session;use SNMP_util;use Getopt::Std;
getopts("h:i:");
my($host, $community, $response, $bindings, $binding, $value, @oid,
@retvals);my $session;
$host
= $opt_h;$community = "public";$db_index = $opt_i;
#
Database State$oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2';#Database
Name$oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index
.
'.7.100.98.95.110.97.109.101.1';# Consistent Block Gets$oid[2] =
'enterprises.111.4.1.1.1.2.' . $db_index;# System Block Gets$oid[3] =
'enterprises.111.4.1.1.1.4.' . $db_index;
my
@retvals = SNMP_util::snmpget ( $host, @oid );
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 23,
2002 5:20 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: DB monitoring using SNMP
MIBs
Thanks Dennis, Gary
I have tools at my disposal to monitor the db, and I have no
problem with that. I was just reading through snmp and was intrigues by the
idea that I could get some information without running scripts through sqlplus
interface and if so how to accomplish that.
I know it is doable because IA does that, just wondering if it
would be feasible to do it be some scripting ...
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- From:
DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB monitoring using SNMP MIBs
Raj - I'm no expert on SNMP, so maybe someone that is more
knowledgeable will reply. I believe that SNMP
underlies most of the monitoring tools on the market
today. OEM may even use SNMP. I can see two approaches for you.
1. You write your own tool that will issue SNMP
alerts. Perhaps this would be a Unix daemon process
that executes database queries, and then based on what
it finds, issues SNMP alerts. 2. Use an
existing tool to accomplish what you want. If your desire is to create a database
monitoring tool that you can give away for free, then
sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2.
Dennis Williams DBA, 40%OCP
Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message- Sent:
Wednesday, October 23, 2002 4:39 PM To: Multiple
recipients of list ORACLE-L
Has anyone implemented basic DB monitoring using snmp MIB
information rather than running queries against the
db?
I am looking into this and have no clue or available docs on
how to do this (esp on AIX). If someone can point me
to the right direction, I would really appreciate
that.
TIA Raj __ Rajendra
Jamadagni
MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't
reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an
art!
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.com --
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (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: kill session
Give that out only if you want said user to be able to do such minor things as : mess with archive loging kill anyones session flush the shared pool shutdown dispatchers etc. I would NOT suggest doing that. Create a procedure that finds the appropriate session ID and then kills it. Then give execute on this procedure to those using the application. Do NOT give out Alter System to your users. -Original Message- [mailto:becker.bill;marshfieldclinic.org] Sent: Thursday, October 17, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Hello, I received a request from a developer, who is working on a client C++ front end application intended to perform semi-customized queries against a star schema in a datawarehouse. By semi- customized, I mean the fields selected are usually the same, the user can change date ranges, age ranges, etc., affecting the where clause. This app communicates with Oracle 8.1.7.4 server on Solaris via an oracle8 ODBC driver. The developer is looking for a way to allow the user to interrupt/kill any queries from the application. Here is an excerpt of his request: Apparently the Oracle8 ODBC drivers don't support asynchronous execution at all, so it can't be done through ODBC. After hunting through Oracle documentation, I've considered starting the query in one thread, and killing it in another with a command like ALTER SYSTEM KILL SESSION '[sid], [serial#]'. A couple of questions: 1. How big a deal would it be to grant users the ALTER SYSTEM privilege, so app_name could kill their sessions? Would this have the desired effect of just abandoning the query? 2. Are you aware of any other, better ways to kill a query, given that ODBC doesn't directly support it? I am hesitant to grant alter system to users. Does anyone have a better suggestion? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM can't seem to discover 1 instance
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Phil Wilson (DBA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SNP acronym?
Title: SNP acronym? Snapshot Refresh Processes. -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 4:29 PMTo: Multiple recipients of list ORACLE-LSubject: SNP acronym? What does the background job queue acronym SNP stand for ?
RE: OEM can't seem to discover 1 instance
services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Phil Wilson (DBA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..
Dpeneding on the state of course . at least here in Texas there is not (currently) state income tax. -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 9:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..Figure on paying about 30% of that to Federal, State, and Local taxes, Social Security, Medicaid Taxes, etc.. On Mon, 2002-10-14 at 02:43, Lyndon Tiu wrote: Keep on dreaming. On Sun, 13 Oct 2002, Sinardy Xing wrote: Hi US friends, How high is your income tax ? 90-110K is this the take home pay ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation [EMAIL PROTECTED]
RE: Elementary question about triggers
Why not just remove delete authority from anyone not authorized to delete from it ?? -Original Message- Sent: Monday, October 14, 2002 2:34 PM To: Multiple recipients of list ORACLE-L CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW BEGIN RAISE_APPLICATION_ERROR(-2,'Do not delete ...'); END; / Bala. -Original Message- Sent: Monday, October 14, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Dear Listers, I hope you won't mind a question that (I think) looks unfit for this list: Can we prevent a delete trigger from deleting a row? To make it clear, here's the code for a trigger: CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW ??? END; What statement should I write in the PL/SQL block, that will prevent the deletion of the row. Thanks regards, Charu. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Balakrishnan Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Shell scripting
ORACLE-L FAQ: http://www.orafaq.com -- Author: Omar Khalid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Shell scripting
Ahhh I had not seen that part of the response. Well, now they have a
sample of just how complicated it can get.
-Original Message-
Sent: Tuesday, October 08, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L
Kevin,
Thanks for the 'coprocess', I couldn't remember what it was called.
This is what I was describing in my previous email.
Jared
Kevin Lange [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/08/2002 09:23 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Re: Shell scripting
Actually Jared, you can by setting up a sqlplus coprocess and using unix
pipes. The routine below will get a parameter from the v$parameter table
using sqlplus.
Kevin
===
get_db_parm()
{
unset vRETURNED_PARM
unset vRESPONSE
typeset -u vPARM
vPARM=$1
sqlplus -silent /NOLOG |
print -p 'set feedback off'
print -p 'set echo off'
print -p 'set heading off'
print -p 'set pagesize 0'
print -p 'connect internal'
read -p vRESPONSE
while [ ${vRESPONSE:-Z} != 'Connected.' -a \
${vRESPONSE%ORA*}Z != 'Z' ]
do
read -p vRESPONSE
done
if [ ${vRESPONSE:-Z} = Z ] ; then
return 1
fi
vTERMINATOR='Z'
print -p SELECT UPPER(name)||':'||value t FROM v\$parameter
print -p WHERE UPPER(name) = '${vPARM}'
print -p UNION
print -p SELECT '${vTERMINATOR}' t FROM dual
print -p ORDER BY 1;
read -p vRESPONSE
while [ ${vRESPONSE} != ${vTERMINATOR} ]
do
if [ ${vRESPONSE%%:*} = $vPARM ] ; then
vRETURNED_PARM=${vRESPONSE##*:}
if [ ${vRETURNED_PARM%%\?*}Z = Z ] ; then
vRETURNED_PARM=${ORACLE_HOME}${vRETURNED_PARM#\?}
fi
fi
read -p vRESPONSE
done
print -p exit
# Flush Buffer after exiting
while [ $? -eq 0 ]
do
read -p $vRESPONSE
done
vRETURNED_PARM=`echo $vRETURNED_PARM|sed s/%/%%/g`
printf ${vRETURNED_PARM}\n
return 0
}
-Original Message-
Sent: Tuesday, October 08, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L
Omar,
If what you mean is:
How do I send a value from sqlplus plus directly
to a variable in my shell environment?
You can't.
What you've done is the way it is usually done.
Another way to do it is to use the '|' korn shell mechanism.
e.g.
sqlplus -silent scott/tiger@$ORACLE_SID |
This allows you to send commands straight to sqlplus
from the ksh command line, and retrieve the results
of queries from the cmd line.
It's not as easy as it appears. I wrote a set of shell functions
once upon a time to do this, and it gets more complex than
you expect.
The method you are currently using works ok.
Of course, you could use Perl with DBI and avoid all this
subshell nonsense.
Jared
On Tuesday 08 October 2002 01:23, Cyril Thankappan wrote:
Sure
THanks Omar
But I was looking for a
'non-file based' solution :)
Thanks anyway
On Mon, 07 Oct 2002 Omar Khalid wrote :
hi
well i think i did this once, you can read
the output of the SQL query into shell variables by
first redirecting the output of the SQL query to an
OS file and then reading the file and loading
the data in the file into shell variables.
/* here is sample code to redirect the output of sql query to OS
file */
#!/bin/sh
CMD_FILE=sql_input.sql
LOC_FILE=output.log
SQLCMD=connect internal ;
select * from sys.dba_users ;
echo $SQLCMD ${CMD_FILE}
svrmgrl ${CMD_FILE} ${LOC_FILE} /* redirecting the
out of
svrmgrl to OS file */
regards
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Omar Khalid
Software Engineer
LMK Resources
Voice: 111-101-101*780
Mobile: 0333-510-4465
Web: www.lmkr.com
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Cyril
Thankappan To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
cyril_thank@redif cc:
fmail.com Subject: Shell
scripting
Sent by:
[EMAIL PROTECTED]
10/04/2002 09:18
PM
Please respond to
ORACLE-L
Hi
I wanted to select a column from a v$ table
struggled with it
and finally came with a workaround as follows
archived_log='$archived_log'
begin_seq=`sqlplus -s /nolog EOF
connect / as sysdba
set head off
set echo off
set feedback off
set verify off
select max(sequence#)-1 from v$archived_log ;
exit
EOF`
echo $begin_seq
---
However, the question is how to
'directly' take the output into a shell variable?
there 'shud be' a better workaround than this !
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
RE: SQL and case structure
Look up the DECODE function select acct_no, decode(substr(acct_no,16,1),'1','one','2','two','other') from star.kills; -Original Message- Sent: Monday, October 07, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Listers: I've used SAS's version of SQL and it allows the coding of conditional logic in the SELECT statement: proc sql; select acct_no, case substr(acct_no,16,1) when '1' then 'one' when '2' then 'two' else 'other' end as desc from star.kills; quit; The same syntax does not work in SQL*Plus for Oracle 8. Can someone point me to the correct syntax? Secondly, any URLs for this kind of information would be most appreciated. Regards, Harry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rollback_segment who is using?
If you have TOAD with the DBA module , it can tell you which is being used by whom. If not, here is the sql statement that generates the list : SELECT r.NAME, -- rbs name s.sid, s.serial#, s.username, s.machine, t.status, t.cr_get, -- consistent gets t.phy_io, -- physical IO t.used_ublk, -- Undo blocks used t.noundo, -- Is a noundo transaction SUBSTR (s.program, 1, 78) COMMAND, s.username DB User, t.start_time, s.sql_address Address, s.sql_hash_value Sql Hash FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r WHERE t.addr = s.taddr AND t.xidusn = r.usn ORDER BY t.start_time -Original Message- Sent: Friday, October 04, 2002 4:38 PM To: Multiple recipients of list ORACLE-L Dear List, Some developers had written the code to use the particular rollback segments. how to find out which session is using which rollback segment? Thanks in advance Sarath __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sarath kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Restrict certain database access using 3rd party tools.
Except for the fact that they could always change the program name that they are running to match what you need. Then that security is bypassed. -Original Message- Sent: Thursday, October 03, 2002 11:08 AM To: Multiple recipients of list ORACLE-L In homemade applications, by default users have a role with read only, in the applications we change the default role that allows insert, update, delete. I've not tested this scenario but how about if, in a database logon trigger, you check the v$process.program field then depending of that value you may be able to change the user default's role. Should work on 8i using dedicated connection. --- [EMAIL PROTECTED] a écrit : Hi All, We have users that have OPS$ accounts that have full DML privs when they run forms application via citrix. Currently they do not have sqlplus,etc. There is a requirement that some can have sqlplus,toad,etc. I know you can set up security for sqlplus,etc using product_user_profile but is there a way to allow only SELECT when using a 3rd party tool such as TOAD. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: svrmgrl echo v$database in script
In order for the K Shell to let you use a Dollar Sign ($) as a litteral
you need to use the escape character before it (\)
So, instead of
select name from v$database;
use
select name from v\$database;
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L
echo $ORACLE_SID logfile
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 6:28 PM
To: Multiple recipients of list ORACLE-L
Subject: svrmgrl echo v$database in script
Oracle 8.0.5
Solaris 2.6
List:
I've created a script (ksh) called from elsewhere that shuts down the
database. I REALLY want to echo the name of the database into my log file
before I shut down.While select name from v$database works fine from
svrmgrl interactively, it throws up in the script. I'd guess the $ sign
is
screwing it up. (I can get other commands to work within the script.)
However, I don't know what to do about it.
Any ideas?
Thx!!!
Barb
$ svrmgrl
SVRMGR connect internal
Connected.
SVRMGR select name from v$database;
NAME
-
TADENT
1 row selected.
#!/usr/bin/ksh
# $Id: stop_db.sh ver.1 10/02/2002 B.Baker Exp $
# Name: stop_db.sh
# Author: Barb Baker
# Purpose: execute shutdown immediate on current database
# (i.e., database pointed to by current value of ORACLE_SID)
echo Stop oracle instance \${ORACLE_SID}\ at `date`
${ORACLE_HOME}/bin/svrmgrl EOF
connect internal
select name from v_$database;
EOF
$ ./stop_db.sh
Stop oracle instance tadent at Wed Oct 2 16:24:59 MDT 2002
SVRMGR Connected.
SVRMGRselect name from v_
*
ORA-00942: table or view does not exist
SVRMGR
Server Manager complete.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Selecting Next X Values From Dual
I created a package that would easily loop thru and select x number of entries, but not return them in a select to you. This way, you can make 1 simple call passing it X. Is that what you wanted ??? Or do you have to have them as returned values of a select ? Kevin -Original Message- Sent: Friday, September 27, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Anjo... Thanks for the reply!! If X is fixed for all sessions, do a step increase of X so that you only have to select 1 row from dual. Unfortunately, I don't feel I can do that. I'm using the returned values as unique identifiers to protect against duplicate database submissions from a web-based application. I have implemented a workaround by selecting a row from dual X number of times. I wanted something a bit cleaner, and [seemingly] less database-intensive than querying in a loop. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Staspack Grapher/Viewer ?
We use MRTG to produce graphs for data from different sources network stats, hardware stats, database stats. Maybe you could use it for statspack. -Original Message- Sent: Thursday, September 19, 2002 8:39 AM To: Multiple recipients of list ORACLE-L Does anyone have or know of any utilities, preferably freeeware or very cheap, that can produce graphs of the data collected by statspack? Thanks VERY much in advance. -walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 for Off-Topic Question - Where has Oracle-l-OT gone
Its still out there on Yahoo Groups. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 19, 2002 7:18 AMTo: Multiple recipients of list ORACLE-LSubject: Apologies for Off-Topic Question - Where has Oracle-l-OT gone ?Has the Off-Topic group gone ? Steve ParkerE Mail: [EMAIL PROTECTED] --
RE: Listener load balance
I did not know about the LOAD_BALANCE=ON . Thanks. -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 18, 2002 10:33 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Listener load balance TKS Yechiel for your help, Two more questions. Is there any way I can find out which one of the 2 addresses I am using ? Which isbetter solution this method or add another listener ? Tks for your help TIA Ramon - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 18, 2002 4:09 AM Subject: Re: Listener load balance Hello Ramon I think that you have an error in your parameters. As far as I know (not much) the second network card have a different TCP/IP address. You have to put this address in the added line in listener.ora and add (load_balance=on). (ADDRESS_LIST = (load_balance=on) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = newnetwork card address)(PORT = 1526)) --- Added ) In the tnsnames you have to use load_balance=on and put both addresses and ports in the address list: (description= (address list= (load_balance=on) (address=(protocol=TCP,host=225.125.110.5,port=1521)) (address=(protocol=TCP,host=newnetwork card address,port=1526)) This way the clients will use both address. Yechiel AdarMehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 10:19 PM Subject: Re: Listener load balance Tks Kevin, I didn't setup the DNS to do that. I ping myserver and is using the new address. Don't know how to do it either. What I am planning to do is to setthe manually the ip address to the both port. I am using local names. (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.5)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.6)(PORT = 1526)) --- Added Ramon - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 12:03 PM Subject: RE: Listener load balance Your HOSTNAME of 'myserver' would tell you which. Since you have the same hostname on the listener, both ports would currently be using the same IP address. Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 17, 2002 9:43 AMTo: Multiple recipients of list ORACLE-LSubject: Listener load balance Hi list, Scenario Win2000 server, 8.1.7. I added anetwork card to my DB Server. I want the listener to accept connections for the 2 IP address to make load balance. I just added a line to the listener file with a different port. How can I assure that the port 1521 is listening for the net address 01 and the port 1526 in the address 02 ? Is that correct ? --- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1526)) --- Added ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\Oracle\Ora8I) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\Oracle\Ora8I) (SID_NAME = ORCL) ) ) TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
RE: Listener load balance
Your HOSTNAME of 'myserver' would tell you which. Since you have the same hostname on the listener, both ports would currently be using the same IP address. Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 17, 2002 9:43 AMTo: Multiple recipients of list ORACLE-LSubject: Listener load balance Hi list, Scenario Win2000 server, 8.1.7. I added anetwork card to my DB Server. I want the listener to accept connections for the 2 IP address to make load balance. I just added a line to the listener file with a different port. How can I assure that the port 1521 is listening for the net address 01 and the port 1526 in the address 02 ? Is that correct ? --- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1526)) --- Added ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\Oracle\Ora8I) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\Oracle\Ora8I) (SID_NAME = ORCL) ) ) TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
RE: backup controlfile to trace
The way we do it is not 100% but it seems close enough. We run the backup command and then do a descending order listing by date from the trace directory. The first file is the one containing the trace. If anyone has a beter idea, I am all ears. Kevin -Original Message- Sent: Tuesday, September 17, 2002 1:13 PM To: Multiple recipients of list ORACLE-L 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Decode
decode(test_value,if_A,then_B,if_C,then_D,...,otherwise_E) decode(city,'San Francisco','CA','Dallas','TX','Unknown') If the city is 'San Francisco', return 'CA'. If the city is 'Dallas', return 'TX' If neither, return 'Unknown' -Original Message- Sent: Wednesday, September 11, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Hello everyone, I am having a senior moment and I have forgetten the syntax for 'decode'. Can anyone give me a hint. I have leant out my sql books and of course I need them now. Thanks in advance, Ruth Gramolini Oracle DBA, Vermont Department of Taxes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RBO/CBO question
How about the profile of the user ?? Can that be used to set a different default optimizer mode for a particular user ?? If so ,then maybe the profile of the user that the copy is connecting as would setup the right mode. -Original Message- Sent: Wednesday, September 11, 2002 2:08 PM To: Multiple recipients of list ORACLE-L Listers, How do you set optimizer_goal to 'choose' to take effect for sessions connecting using COPY command? The database runs with optimizer_mode=RULE. I want to test if CBO would be better for queries used for data selection via COPY. Thanks. - Kirti -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: methodology to keep only certain programs to connect to
With a setup like this, how do you stop a user from simply renaming the program they are using to match what you expect to see and, therefore, getting past your security ?? -Original Message-From: Shaw John-P55297 [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: methodology to keep only certain programs to connect to use v_$mystat - it has the sid - then do your join with v$session -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 10:58 AMTo: Multiple recipients of list ORACLE-LSubject: methodology to keep only certain programs to connect to I've been tasked to ensure only certain app programs access the database. I'm thinking on-logon trigger, check the program field from v$session. unfortunately v$session is for all sessions, i can't seem to find the view that tells me only MY info during login. I only want the sid, serial#, username and program for my just now connection to the database. Does this exist or am I going about this the wrong way? We're thinking of checking those fields to make sure sql*plus, toad, etc can't connect as a particular user(even though the password is known out in the community). any ideas would be greatly appreciated. joe
RE: methodology to keep only certain programs to connect to
I have always thought this was the best way to implement a security package. Nice to see you implemented the seed number for changing encryption. -Original Message- Sent: Tuesday, September 10, 2002 1:49 PM To: Multiple recipients of list ORACLE-L I'm working with an application that uses a combination of encrypted seed numbers and password protected roles to limit access to the application tables to the specific application and version. In this database, any external application (sqlplus, etc) cannot provide access to the application tables since that requires activation of the password protected role. The only default role for users is a connect role that has only connect privs. And, you can't just grab a copy of the application from anywhere and use it against the database since the encrypted seed number compiled into the application is checked against the value in the database before a connection is permitted. Glenn Stauffer On Tue, 2002-09-10 at 11:58, JOE TESTA wrote: I've been tasked to ensure only certain app programs access the database. I'm thinking on-logon trigger, check the program field from v$session. unfortunately v$session is for all sessions, i can't seem to find the view that tells me only MY info during login. I only want the sid, serial#, username and program for my just now connection to the database. Does this exist or am I going about this the wrong way? We're thinking of checking those fields to make sure sql*plus, toad, etc can't connect as a particular user(even though the password is known out in the community). any ideas would be greatly appreciated. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recreate database script
I have used Visio to do that . It links the tables together if they have foreign/primary keys. If you have no relations like that then it will at least list all the tables you pick. -Original Message- Sent: Monday, September 09, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Could anyone here suggest a software package that can create an ER diagram by simply connecting to an Oracle database, reverse engineer it to see the schema in an ER diagram - instead of in a file with ddl/dml statements. I haven't tested it, but Microsoft Visio 2000 claims to be able to reverse engineer a database. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
