RE: ORA-27101: shared memory realm does not exist
Solaris 7 -Message d'origine- De : Henry Poras [mailto:[EMAIL PROTECTED]] Envoy : lundi 26 mars 2001 17:58 : Multiple recipients of list ORACLE-L Objet : RE: ORA-27101: shared memory realm does not exist What is the OS? -Original Message- Sent: Monday, March 26, 2001 10:41 AM To: Multiple recipients of list ORACLE-L I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cril Telecom Software France -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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-01031: insufficient privileges
Charlie Mengler wrote: Solaris V2.6 Oracle V8.1.8 v8.1.8??? what what what? I gots to get me one of dem dere sOlariz b0xen to get me up on dem gnu releazes. thinking that 8.1.7.0.2 on NT is the latest and greatest ... Pd PTDBAFB part-time dba fh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-01031: insufficient privileges
Issue "set role none" and then see if you can do it in SQL Plus. This mimics the privs that you have within a procedure - ie roles are not activated. You probably need the 'create table' priv granted directly (or select on the one you're reading from) hth connor --- Charlie Mengler [EMAIL PROTECTED] wrote: Solaris V2.6 Oracle V8.1.8 Previously I logged in as username "HR" did SQL GRANT SELECT ON EMPHEADER_MASTER TO BCM; Within a PL/SQL package the following lines exits. EXECUTE IMMEDIATE 'TRUNCATE TABLE HR_EMP'; EXECUTE IMMEDIATE 'DROP TABLE HR_EMP'; EXECUTE IMMEDIATE 'CREATE TABLE HR_EMP TABLESPACE USERS STORAGE ( INITIAL 128K NEXT 128K) UNRECOVERABLE AS SELECT * FROM HR.EMPHEADER_MASTER'; The procedure bombs with ORA-01031: insufficient privileges on the CTAS line. I (schema BCM) own the procedure execute it. I can manually (from SQL*PLUS) successfully cut, paste run the CREATE TABLE ... AS... Any advice on how to make the error go away get the table created would be greatly appreciated -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Small help (To Lee)
Lee, Thanks for your advise, for me this question is just kick off to the world of ORACLE PL/SQL scripting, I don't know why you think that I would like to ask from a Great and full of experiance DBA like you Mr. Lee to spoon feeding me. Again Thank You so much for your advise Xing, -Original Message- Lee Robertson Sent: Thursday, 29 March 2001 3:16 PM To: Multiple recipients of list ORACLE-L Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Log writer waits
Look for "log buffer waits" in v$system_event. You'll always get a few around a log switch, but if you're got heaps, then you're log buffer may a little small - or your log files too slow... The alert log is a good place to check for log file sizing - a commonly accepted rule of thumb is log files should fill no more than every 30 mins hth connor --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: Hi all, Someone had answered this already last week, but being the bone head that I am I forgot to save it. It was something to the effect of seeing how many processes were waiting to write to the log buffer or something like that. And it was a good indicator that your log files are too small? Any help? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: identify which logs are need to start recovery
Lisa/List, when we restore a datafile from a backup, oracle will check the change# in the header of the datafile and will try to match it with the one in the controlfile, correct ? that's how oracle will know that the file is out-of-sync, now oracle will prompt from the change# as well as the log sequence number to apply !! from where does it get the log sequence number ? is it sotred in each datafile ? or oralce queries it from v$log_history ? Rahul -- From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:02 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: identify which logs are need to start recovery Hi Rahul, I'm not sure if there's a v$ view that will tell you, I remember looking for this myself. However if you initiate recovery it will ask for the appropriate arclog, and you can always cancel out. During testing, I found that it will ask for every single one since the backup set from which you restored your datafile, regardless of whether or not it needs it (in this case, the datafile that was lost didn't contain any tables that had changed since the last backup. Go figure). HTH Lisa Rutland Koivu Oracle Database Administrator [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Rahul [ mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 11:13 PM To: Multiple recipients of list ORACLE-L Subject: identify which logs are need to start recovery usually i keep 2-3 previous archived logs, after switching and starting the hotbackup... but is there a v$ view to show which logs are needed to start the recovery ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Small help (To Lee)
Eh ??? I don't think there is any call for that. I told you whereabouts in the doc set the manuals were and suggested that you look there. I am certainly not a "Great and full of experience DBA" as you suggest but was merely passing on what experience I do have whilst coming across a similar problem myself a couple of years ago. FYI, I have been an Oracle DBA for some 4-5 years now. Please bear this in mind when you next need help/advice because it certainly won't be forthcoming from this direction. Not the best way to kick of your "list career" is it ? Lee -Original Message- Sent: 29 March 2001 09:05 To: Multiple recipients of list ORACLE-L Lee, Thanks for your advise, for me this question is just kick off to the world of ORACLE PL/SQL scripting, I don't know why you think that I would like to ask from a Great and full of experiance DBA like you Mr. Lee to spoon feeding me. Again Thank You so much for your advise Xing, -Original Message- Lee Robertson Sent: Thursday, 29 March 2001 3:16 PM To: Multiple recipients of list ORACLE-L Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
Errors in Oracle
Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Does anyone know a link to 9i documentation?
Hi Waleed, Perhaps the best thing to do is to go to http://technet.oracle.com and then do a search on "9i". You should get loads of pages back, but these are very fluid, changing regularly. I've just done a search like this, and three you may be interested in that came back were: = http://technet.oracle.com/docs/products/ias/doc_library/102sol_doc_otn/migrate/intro.htm = http://technet.oracle.com/products/iportal/htdocs/portal_faq.htm = http://technet.oracle.com/products/oracle9i/htdocs/9ipak/schemas/aboutschemas.htm These won't last long though, and searching is the best bet, using something like: = http://technet.oracle.com/files/search/search.htm?9i Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject:Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script to Compare table structures
Following is a script that will compare differences within a schema. If this
is too much, just edit out the table comparison scripts.
HTH
Mark
-
col table_name format a30
col column_nameformat a30
col medph2_format format a30
col med_test_formatformat a30
set feed off
set lines 150
set pages 66
spool match_schema.lst
--
-- MATCHING THE TABLES -
--
ttitle 'THE FOLLOWING TABLES EXIST IN USERA AND DOESN'T EXIST IN USERB'
select table_name from all_tables a
where owner = 'USERA'
and not exists (select 1 from all_tables b
where owner = 'USERB'
and b.table_name = a.table_name)
order by table_name
/
ttitle 'THE FOLLOWING TABLES EXIST IN USERB AND DOESN'T EXIST IN USERA'
select table_name from all_tables a
where owner = 'USERB'
and not exists (select 1 from all_tables b
where owner = 'USERA'
and b.table_name = a.table_name)
order by table_name
/
--
-- MATCHING THE COLUMNS -
--
ttitle 'THE FOLLOWING COLUMNS EXIST IN USERA AND DOESN'T EXIST IN USERB'
select table_name, column_name from all_tab_columns a
where owner = 'USERA'
and not exists (select 1 from all_tab_columns b
where owner = 'USERB'
and b.table_name = a.table_name
and b.column_name = a.column_name)
order by table_name, column_id
/
ttitle 'THE FOLLOWING COLUMNS EXIST IN USERB AND DOESN'T EXIST IN USERA'
select table_name, column_name from all_tab_columns a
where owner = 'USERB
and not exists (select 1 from all_tab_columns b
where owner = 'USERA'
and b.table_name = a.table_name
and b.column_name = a.column_name)
order by table_name, column_id
/
ttitle 'THE FOLLOWING COLUMNS HAVE DIFFERENT CHARACTERISTICS IN EVERY
SCHEMA'
select a.table_name, a.column_name,
decode(a.data_type,'DATE','DATE',
'NUMBER',decode(a.data_scale,0,'NUMBER('||a.data_precision||')',
'NUMBER('||a.data_precision||','||a.data_scale||')'
),
a.data_type||'('||a.data_length||')'
)||' '||decode(a.nullable,'N','not null',' ') USERA_format,
decode(b.data_type,'DATE','DATE',
'NUMBER',decode(b.data_scale,0,'NUMBER('||b.data_precision||')',
'NUMBER('||b.data_precision||','||b.data_scale||')'
),
b.data_type||'('||b.data_length||')'
)||' '||decode(b.nullable,'N','not null',' ') USERB_format
from all_tab_columns a,
all_tab_columns b
where a.owner = 'USERA'
and b.owner = 'USERB'
and a.table_name = b.table_name
and a.column_name = b.column_name
and (a.data_type b.data_type
or a.data_length b.data_length
or a.data_precision b.data_precision
or a.data_scale b.data_scale
or a.nullable b.nullable)
order by 1, 2
/
--
-- MATCHING THE VIEWS -
--
ttitle 'THE FOLLOWING VIEWS EXIST IN USERA AND DOESN'T EXIST IN USERB'
select view_name from all_views a
where owner = 'USERA'
and not exists (select 1 from all_views b
where owner = 'USERB'
and b.view_name = a.view_name)
order by view_name
/
ttitle 'THE FOLLOWING VIEWS EXIST IN USERB AND DOESN'T EXIST IN USERA'
select view_name from all_views a
where owner = 'USERB
and not exists (select 1 from all_views b
where owner = 'USERB'
and b.view_name = a.view_name)
order by view_name
/
--
-- MATCHING THE CONSTRAINTS -
--
ttitle 'THE FOLLOWING CONSTRAINTS EXIST IN USERA AND DOESN'T EXIST IN USERB'
select table_name, constraint_name, constraint_type
from all_constraints a
where owner = 'USERA'
and constraint_type 'C'
and not exists (select 1 from all_constraints b
where owner = 'USERB'
and b.table_name = a.table_name
and b.constraint_name = a.constraint_name
and b.constraint_type = a.constraint_type)
order by table_name, constraint_name
/
ttitle 'THE FOLLOWING CONSTRAINTS EXIST IN USERB AND DOESN'T EXIST IN USERA'
select table_name, constraint_name, constraint_type
from all_constraints a
where owner = 'USERB'
and constraint_type 'C'
and not exists (select 1 from
RE: Oracle Books on Audio Tapes
You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject:Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: New born DBA.....
Hi ! Welcome to the world of DBAs. And you have got some good suggestions too.. This mailing list a good place to ask questions (and get answers). Read Kevin Loney and Rama Velpuri. The titles are Oracle 8i DBA Handbook and Oracle 8i Backup and recovery hand book. Religiously try all the backup/recovery case studies. You will become master one day.. :0 Read Oracle Documentation. It has plenty of information in it. Espicially Oracle Server Concepts and Performance Tuning Manuals along with Backup Recovery manuals. Read the mails/newsgrups. It is nice place to simulate experience. There is another DBA listserv also there. Subsribe to both the lists and brose the mails. Read ***ALL** mails from Steve Adams, John Kanagaraj (Where is he now a days), Gaja Vaidyanatha, etc.. ( Use the mailbox message rules (or fileter rules!!) for better spam control. I have few message rules which redirects some mails to TRASH based on the sender.(May be able to give the list offline..:) And here are few websites.. http://www.orafaq.org http://www.ixora.com.au http://www.jlcomp.demon.co.uk http://www.lonyx.com Wish you all the best !! = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Errors in Oracle
From the command line do oerr prefix code error number eg For an Oracle error # oerr ora 1658 01658, 0, "unable to create INITIAL extent for segment in tablespace %s" // *Cause: Failed to find sufficient contiguous space to allocate INITIAL/ / extent for segment being created. // *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the // tablespace or retry with a smaller value for INITIAL Hope this helps Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 29 March 2001 11:20 To: Multiple recipients of list ORACLE-L Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Errors in Oracle
There is a set of cd's that come with Oracle enterprise edition. I think irs called Orale 8i client online Documentation cd. It has all the error messages on it. Thanks Clint -Original Message- Sent: Thursday, March 29, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Errors in Oracle
- Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 13:20 Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Try the "Oracle8i Error Messages" chapter available online at: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server. 817/a76999/toc.htm hth, Marin "When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking, because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ..." Herman Hesse, "Siddhartha" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backup Advice.
Any suggestions for a particular product? -Original Message- Sent: Wednesday, March 28, 2001 06:16 To: Multiple recipients of list ORACLE-L Mark, I might suggest that you look into a "Ghost" product for making an image of your PC. I "ghost" my pc and keep the image on the network where it is backed up each night and stored on tape. If I have problems with my PC I load the image to the second drive and I have access to all of the original files. My 2 bits. ROR mm [EMAIL PROTECTED] 03/28/01 10:30AM Hi there :) After a rather interesting start of my week, I have a question for you about the backup of local PC test databases. Rant At the end of last week I deleted my current test database along with all Oracle files, and went for a fresh install, due to having some rather interesting ora-600's and a corrupted SYSTEM datafile! Now that was fun to say the least I can tell you! I then went on to try and install Oracle again from a copy of 8.1.6 for Windows NT/2000, which was downloaded from technet, and burned on to a cd, to save disk space.. I had originally installed 8.1.6 from this download, but when I went to decompress the files from the zip, on the CD, I had corruption on the CD!! Now, I dreamed of corrupted datafiles, corrupted CD's, even corrupted politicians over the weekend, and came in early this week to start downloading 8.1.7 (The only bonus in this little story:) which is in fact a download of 584mb. This is now STILL downloading right now at a rate of 4.5kbs, and is scheduled to finish in 17hours, and 37 minutes :( What a joy it is to have to download these extraordinarily huge files over a 56k modem. Even ADSL isn't available here until September.. \Rant The point? Well, I was wondering what you guys do out there to backup any local PC test databases you may have? I have no tape to backup too, and no real experience with backup or recovery situations. I have never backed up Oracle either :) The databases are all pretty static, as we just load up some data exported from our Access tracking system. The database is pretty much used for QA of our performance tools. What files should I backup first of all? There is no real need to have this database running in ARCHIVELOG MODE is there? Also, where would you reccomend backing up to? CD (aahhemmm!!), network drives, seperate directory? I'm really just trying to avoid the fun and games I've had this week, any advice? Thanks guys Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Errors in Oracle
Install oracle documentation, there you can find explanations for all error messages. Regards Volker Schn E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 29. Mrz 2001 12:20 An: Multiple recipients of list ORACLE-L Betreff: Errors in Oracle Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Errors in Oracle
I have a manual in the form of a pdf that has all the Oracle messages in it, though I can't find the link on the technet documentation area for it at the moment? If you want me to send it over by email away from the list, let me know, as it's around 6.5 mb. HTH Mark -Original Message- [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 11:20 To: Multiple recipients of list ORACLE-L Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: storage area networks
Jeff, We are using a Compaq SAN. It was running great for two months. Just last week we began having some issues with databases hanging on our cluster. We haven't nailed down the problem yet, so I am witholding my opinion. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA "Jeffrey Beckstrom" [EMAIL PROTECTED] 03/28/01 03:29PM Anyone using storage area networks for an Oracle database. Who is the vendor and what is your opinion of the product. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: RANT ABOUT OCP, Re: Small help
Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Errors in Oracle
You can also do it from UNIX prompt (if you have instaled Oracle documentation): $ oerr ora number_of_error Sonja -Original Message- Sent: Thursday, March 29, 2001 12:56 PM To: Multiple recipients of list ORACLE-L There is a set of cd's that come with Oracle enterprise edition. I think irs called Orale 8i client online Documentation cd. It has all the error messages on it. Thanks Clint -Original Message- Sent: Thursday, March 29, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sonja Sehovic INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Why can't I see any Application Systems in my Des 2000 Popup Window?
I just migrated my database that supports Des/2000 version 2.1 from 7.3.4 to 8.1.5. I did not upgrade Designer and don't plan to at this time. Due to lack of any specific documentation anywhere on how to migrate this database, I simply created a brand new database of the same name on a different box as 8.1.5 and imported a full database dump that I had exported from the system Oracle ID on the old 7.3.4 database. I doubted this would work but thought I would try. I changed my tnsnames.ora file on my NT to point to the new database and brought Des/2000 up. The Application System pop-up window comes up and shows me no Application Systems. If I hit cancel on this popup, I can get to and bring up the Repository Adminstration Utility. I selected Upgrade, went through the various steps, and everything says that my repository is already up to date. I feel that I am missing some script. Perhaps a cat for Designer/2000. Is there any such thing? Is there anything else I can run from the Repository Administration Utility that will make my Application Systems show up in the pop-up window? Can anyone point me to any documentation on how to migrate a database supporting Des/2000 without upgrading Designer? I have looked through a lot on online documentation on Technet, Metalink but all of it assumes that you are upgrading Designer. Thanks in advance to any kind soul who can help. I've posted multiple times on this topic but not recieved any specific steps to run. Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Errors in Oracle
technet.oracle.com there is an entire doc manual devoted to the error codes well, except for PL/SQL... there you are on your own, there is no good debugger for that as far as I know. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Errors in Oracle Date: Thu, 29 Mar 2001 02:20:19 -0800 Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: What is best practice - differenet schema/different d
Mike, If that's the worst you guys/gals call me I'll be extremely flattered. Over the years I've had names tossed at me that are not normally usable in impolite society! :-) Dick Goulet Reply Separator Author: "Lanteigne; Mike" [EMAIL PROTECTED] Date: 3/28/2001 9:45 AM Actually I meant Dick, nor Doug, sorry Mike -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: What is best practice - differenet schema/different dbs Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject:Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: RANT ABOUT OCP, Re: Small help
ooh goodie, now I don't have to do my OCP rant, you've done it for me :) Joe, tell us how you REALLY feel, okay? From: "Joseph S. Testa" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: RANT ABOUT OCP, Re: Small help Date: Thu, 29 Mar 2001 04:05:54 -0800 Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Response times with different multiblock read count
You may be running into a limitation of HP-UX that can cause this problem. In HP-UX during any one time slice the SO will return a MAX of 32K of data from disk. This does take a little thought to understand. The OS is multitasking between all of the processes. To do so it breaks time up into equal parts called a 'time slice'. It is during this time slice that your process has the full attention of the CPU, but your disk reads are a system process run during a different time slice of a much higher level process. This process leaves the data in a buffer that you can then access during your time slice. That's all well and good, but if HP allowed you to retrieve all of the data you wanted at one time then the system disk read process would consume more and more of the available time slices, since it runs at a higher priority or "nice" level, and the disk buffer would become totally useless to everyone else. Consequently they arbitrarily set the max amount of data that can be retrieved to 32K. Yes it's odd, but that's the way it is. This also gets affected by the number of processes that run on the machine as well and the number that are "waiting" on something and therefore relinquish their time slice. This is strange, odd, and very confusing. It took our HP CE over an hour to explain it to me and I'm not totally sure I understand, but from observation I can tell you that it is true. Try the same query with the same multi_block_read_count when the system is busy, and when your the only one there. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 3/28/2001 8:25 AM Hi All, I am running a test query with different db_file_multiblock_read_count to test the overall throughput. environment: oracle 8.1.6 on hp-ux v11 db_block_size : 16k system is using LVM and file system is using buffered I/O and disk is mirrored but not stripped. I was expecting that having larger multiblock count would result in better performance. But, when I was testing the query with smaller multiblock count,the response time is better. Here is the testing result. Multiblock time in Secs -- 1 12.5 better 2 12.5 better 4 12.6 better 8 27 bad 16 27 bad 32 18.6 okay 64 19.0 okay I don't understand why 8,16 are taking longer time. I did make sure that oracle is issuing proper multiblock read count with the help of multiblock_read_test.sql which is available in Steve Adams's site. Thank you steve for providing valuable information scripts on your web site. select statement that I am using is, select /*+ full(t) noparallel(t) nocache(t) */ count(*) from Table t; I am clueless why it is behaving like this. Please pass your suggestions. If you need more info like oracle/OS settings etc, please let me know. When I was doing some reading on steve adam's site, he suggests the following. Date: 29-Dec-2000 20:55 Nevertheless, it remains best to allow Oracle to use large multiblock reads, as long as the optimizer is not doing inappropriate full scans. The explanation relates to the system call and context switch overheads associated with I/O. It is cheaper in CPU usage terms to request a 256K I/O and allow the operating system to service it in 64K chunks, than to request 4 I/O's of 64K each. As is mentioned in the tip on Why Large Multiblock Reads, the increased latency is not an issue because multiblock reads should not be used in cases where "first rows" response time is critical. Thanks in advance. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Slow database
We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we are quering the database( a procedure runs) it sometimes take so long time to get the result, almost one hour, but sometimes it just takes about 20 seconds to get the result. Which means that this doesnt happen everytime. What do you suggest that I should do? Do we need to split the database? Is there any problem with the Accessapplication, i mean is it possibility that MsAccess cant access oracledatabases always when the database is very big. And that the reason to slow access to the database should be in the Access environment? Please help me with any suggestions how to solve this. /Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: identify which logs are need to start recovery
I believe that it gets the log sequence number by comparing the change# to the change# in the v$log_history table. Nancy -Original Message- Sent: Thursday, March 29, 2001 3:19 AM To: Multiple recipients of list ORACLE-L Lisa/List, when we restore a datafile from a backup, oracle will check the change# in the header of the datafile and will try to match it with the one in the controlfile, correct ? that's how oracle will know that the file is out-of-sync, now oracle will prompt from the change# as well as the log sequence number to apply !! from where does it get the log sequence number ? is it sotred in each datafile ? or oralce queries it from v$log_history ? Rahul -- From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:02 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: identify which logs are need to start recovery Hi Rahul, I'm not sure if there's a v$ view that will tell you, I remember looking for this myself. However if you initiate recovery it will ask for the appropriate arclog, and you can always cancel out. During testing, I found that it will ask for every single one since the backup set from which you restored your datafile, regardless of whether or not it needs it (in this case, the datafile that was lost didn't contain any tables that had changed since the last backup. Go figure). HTH Lisa Rutland Koivu Oracle Database Administrator [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Rahul [ mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 11:13 PM To: Multiple recipients of list ORACLE-L Subject: identify which logs are need to start recovery usually i keep 2-3 previous archived logs, after switching and starting the hotbackup... but is there a v$ view to show which logs are needed to start the recovery ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Peformance Tuning Book
Anybody can give me a name for Performance Tuning book, my knowledge is low and I am not dealing with Performance issue at my work. I am responsible for backup and recover stuff. Now I think, I should update my knowledge on Performance and Tuning. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Syed Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Backup Advice.
Mark, Not to plug a particuler product when there could be many alike products available. We have a registered version of Ghost by Norton, Symantic Corp. I believe that there is a trial version available at their site. It is simple, and easy to run. I prefer to run it from a boot disk without windows running. Saves on swap being activated and copied. ROR mm [EMAIL PROTECTED] 03/29/01 07:01AM Any suggestions for a particular product? -Original Message- Sent: Wednesday, March 28, 2001 06:16 To: Multiple recipients of list ORACLE-L Mark, I might suggest that you look into a "Ghost" product for making an image of your PC. I "ghost" my pc and keep the image on the network where it is backed up each night and stored on tape. If I have problems with my PC I load the image to the second drive and I have access to all of the original files. My 2 bits. ROR mm [EMAIL PROTECTED] 03/28/01 10:30AM Hi there :) After a rather interesting start of my week, I have a question for you about the backup of local PC test databases. Rant At the end of last week I deleted my current test database along with all Oracle files, and went for a fresh install, due to having some rather interesting ora-600's and a corrupted SYSTEM datafile! Now that was fun to say the least I can tell you! I then went on to try and install Oracle again from a copy of 8.1.6 for Windows NT/2000, which was downloaded from technet, and burned on to a cd, to save disk space.. I had originally installed 8.1.6 from this download, but when I went to decompress the files from the zip, on the CD, I had corruption on the CD!! Now, I dreamed of corrupted datafiles, corrupted CD's, even corrupted politicians over the weekend, and came in early this week to start downloading 8.1.7 (The only bonus in this little story:) which is in fact a download of 584mb. This is now STILL downloading right now at a rate of 4.5kbs, and is scheduled to finish in 17hours, and 37 minutes :( What a joy it is to have to download these extraordinarily huge files over a 56k modem. Even ADSL isn't available here until September.. \Rant The point? Well, I was wondering what you guys do out there to backup any local PC test databases you may have? I have no tape to backup too, and no real experience with backup or recovery situations. I have never backed up Oracle either :) The databases are all pretty static, as we just load up some data exported from our Access tracking system. The database is pretty much used for QA of our performance tools. What files should I backup first of all? There is no real need to have this database running in ARCHIVELOG MODE is there? Also, where would you reccomend backing up to? CD (aahhemmm!!), network drives, seperate directory? I'm really just trying to avoid the fun and games I've had this week, any advice? Thanks guys Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Re: Oracle variables; LD_LIBRARY_PATH TNS_ADMIN
In /etc you should have an oratab file. It should look like this: # oracle notes and stuff # # The line below with the * instead of a sid is for use with tools such as # OEM and Orasoft. It can be used in scripts for setting the environment # like the one shown below. *:/usr/oracle/product/8.1.7:N sid for 8.1.7 db:/usr/oracle/product/8.1.7:N sid1 for 8.0.5 db:/usr/oracle/product/8.0.5:N sid2 for 8.0.5 db:/usr/oracle/product/8.0.5:N sid2 for 8.1.7 db:/usr/oracle/product/8.0.5:N The oraenv file is located in the /usr/local/bin directory. To run it, export your sid then type .oraenv and answer the prompt. When I scritp things I usually use a wrapper file to start them off. Here is what I use on my Linux desktop to kick off OEM SQL*Plus Worksheet: #!/bin/ksh # # File: /usr/local/bin/oemworksheet.ksh # Description: Wrapper for OEM Worksheet # export LD_LIBRARY_PATH=/usr/local/lib:/usr/oracle/product/8.1.7/lib export TNS_ADMIN=/usr/oracle/network/admin export ORACLE_SID="*" export ORAENV_ASK=NO; . /usr/local/bin/oraenv # The following line puts me in the directory where my scripts are at. # When I use the File|Open command I'm where I want to be. cd /usr/oracle/admin/common /usr/oracle/product/8.1.7/bin/oemapp worksheet The ORAENV_ASK variable is a way of making oraenv non-interactive for scripting purposes. It will execute the environment using the sid variable preceeding it. HTH On Wednesday 28 March 2001 22:55, you wrote: Rodd, Thanks for the great info. This is good piece of info. I need to know how I can use "oraenv" utility on unix machine. All the info. I need is for unix (sorry did not specify). Also I am trying to set the LD_LIBRARY_PATH via a unix shell script, so I think I can do a "setenv $LD_LIBRARY_PATH". Is that correct? Also I want to know, what is I dont set the LD_LIBRARY_PATH, then what happens, will the Oracle sqlplus session start? (Yes/No)? explain if you can... Also can I do "oraenv $LD_LIBRARY_PATH" in my unix script? Regrads, Raja -- On Wed, 28 Mar 2001 05:46:23 Rodd Holman wrote: Oracle, by default, uses $ORACLE_HOME/network/admin to stor the tnsnames.ora, sqlnet.ora, listener.ora, snmpro.ora and snmprw.ora files for configuration of the Net8 services. If you declare a TNS_ADMIN variable oracle will use that location for these files. It allows you to keep your networking config files separate from the oracle distribution files. Example: On our development machines we have multiple oracle homes of diferent versions 8.0.x, 8.1.7, etc. All these versions use the same TNS files from a directory under the $ORACLE_BASE. Our setup is: /usr/oracle admin common SID product 8.0.5.1 8.1.7 jre oui oraInventory network admin log trace We then use the 8.1.7 listener and OEM agent against all db's. We have one sqlnet.ora and tnsnames.ora configuration for all instances on the machine. One place for log and trace files for TNS issues. It makes administration easier. The LD_LIBRARY_PATH is a variable that tells applications working with the oracle client where the oracle libraries are. It is version dependent and should be set with the oraenv. Normally it is $ORACLE_HOME/lib. If you are not using oraenv then you need to make sure that it is exported before you start doing your oracle stuff. All of this assumes that you are working with oracle on a Unix machine. The discussion applies to NT also except these variables are specified in the registry under \\HKEY_LOCAL_MACHINE\Software\Oracle HTH On Wednesday 28 March 2001 04:00, you wrote: Hello, I need some clarification. What is the significance of the Oracle variables, TNS_ADMIN LD_LIBRARY_PATH? When are the 2 used or what effects what in the environment? Also please if some one knows how do I monitor an Oracle Parallel Server? Any good book where I can read about OPS? Regards, Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
Re: OT: RANT ABOUT OCP, Re: Small help
Anyone who's watched the list for a week will know me, no political correctness here :) and thats probably the only reason i am OCP, the company i worked for at the time, paid for the tests and gave me a bonus to complete them. :) joe From: "Thater, William" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT: RANT ABOUT OCP, Re: Small help Date: Thu, 29 Mar 2001 05:00:25 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id IAA04008for jtestamail@localhost; Thu, 29 Mar 2001 08:36:51 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Thu, 29 Mar 2001 08:36:56 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2TEbEl28072for [EMAIL PROTECTED]; Thu, 29 Mar 2001 08:37:14 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA15519;Thu, 29 Mar 2001 05:24:54 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DB44A; Thu, 29 Mar 2001 05:00:25 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Thater, William" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: "Joseph S. Testa" wrote: Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe you know you really should tell us just how you feel and not beat around the bush that way.;-) i got asked yesterday by damagement why i wasn't certified. when i asked if they would pay for the courses/exams they didn't seem to think that was "in the training budget". so i said they's just have to put up with me the way i was and got back to building the database infrastructure.;-) oh well, guess i'll end up loosing out to someone with an OCP.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:OT: RANT ABOUT OCP, Re: Small help
Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Enqueue types TC and JI
TC is (Thread Checkpoint) enqueue it is related with the global checkpoints. It is used to signal the file checkpoint completion. Thx Gautam -Original Message- Sent: Tuesday, February 27, 2001 11:46 AM To: Multiple recipients of list ORACLE-L "Hagedorn, Linda" posted a message a few weeks ago about enqueue types JI and TC. Anjo Kolk says the following: TC is the incremental checkpoint, if I remember correctly the JI for the job queue processe. He's working on a new version of the wait events paper but not sure when it'll come out. Yong Huang [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Reddy, Gautam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: New born DBA
shameless plug get the book _Oracle DBA 101_ it has not only that kind of list, but lots and lots of other good stuff. and you can always ask one of the authors questions right here on the list.;-) /shameless plug did i do good rachel?;-) Question for the authors here (offline responses ok): with book-writing for technical issues, are these usually work-for-hire affairs or royalty-based? I ask as a DBA who does a small amount of (travel-related) freelance writing on the side. With the relatively higher price tag of technical books but lower number of sales, e.g.: SELECT count(*) from BOOK_SALES where SUBJECT = 'DATABASE ADMINISTRATION'; SELECT count(*) from BOOK_SALES where SUBJECT = 'PERSONAL FINANCE'; Which works out better for technical authors? Work-for-hire (flat one-time fee, publisher purchases the copyright) or royalties? My guess is work-for-hire unless the royalties are a generous percentage of list price (versus net). I've heard co-authors of technical books receive as little as USD (or should that be USC) 25 cents a book when royalties are paid. Thanks. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
Hi, Further to the mail sent , I couldn't find the right one in Download.com can you help me, to download the same. S.S [EMAIL PROTECTED] 03/29/01 05:50AM You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject:Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shankar Shanmugaswamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:OT: RANT ABOUT OCP, Re: Small help
Dick/Lee/Joe, I'm not trying to defend him but unless I have not yet recieved a post in my mail, Xing never said he had an OCP. Plus, Lee, I think you may need to define "silver bullet". It probably doesn't translate for people who don't use English as a second language. Cherie Machler Gelco Information Network (really too busy this morning migrating a database to be sticking my nose where it doesn't belong) [EMAIL PROTECTED]@fatcity.com on 03/29/2001 08:00:45 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
nvl affect on idexes
Does nvl have any effect on indexes. In other words would it slow down a query if you used the nvl function in the where clause on an indexed field. i.e. select * from foo where indexField nvl(xfoo,0); Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT -- # tables in your db (was: Slow database)
"very complex" at 300 tables. I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159 database links. 1064 views, again excluding SYS and SYSTEM. This is on Oracle 7.3.4. I am sure this is not the smallest db out there... (It's my birthday, so what if I feel a bit competitive today -- let's start a thread). : ) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject: Slow database We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we are quering the database( a procedure runs) it sometimes take so long time to get the result, almost one hour, but sometimes it just takes about 20 seconds to get the result. Which means that this doesnt happen everytime. What do you suggest that I should do? Do we need to split the database? Is there any problem with the Accessapplication, i mean is it possibility that MsAccess cant access oracledatabases always when the database is very big. And that the reason to slow access to the database should be in the Access environment? Please help me with any suggestions how to solve this. /Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Peformance Tuning Book
Oracle Performance Tuning, 2nd Edition by Mark Gurry Peter Corrigan Published by O'Reilly ISBN 1-56592-237-9 Syed Ahmed wrote: Anybody can give me a name for Performance Tuning book, my knowledge is low and I am not dealing with Performance issue at my work. I am responsible for backup and recover stuff. Now I think, I should update my knowledge on Performance and Tuning. __ Dwayne Cox DBA, Development Dept. [EMAIL PROTECTED] Info Tech, Inc. 5700 S.W. 34th Street Suite 1235 Gainesville, FL 32608 Phone: 352.381.4400 Fax: 352.381. http://www.infotech.com ___ The opinions expressed are the author's own unless otherwise stated -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
--- Apps Sol [EMAIL PROTECTED] wrote: Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK I doubt it. From what I understand, audio books are primarily made from best-selling fiction. What non-fiction audio books exist are probably limited to stuff with the broadest general appeal (best-sellers). I've personally never heard of technical books on tape/audio CD. However, you might be able to make your own, rather tediously, if you receive a PDF version along with a "dead tree" technical book. 1. Copy-paste the text from the PDF to your word processor of choice. 2. Use text-to-speech software to creave WAV files 3. Burn to CD. Or, you may want to purchase some Oracle Computer-Based-Training CDROMs and burn the audio tracks to an audio CD(if they're in a standard audio format or a format you could convert to WAVs) - or convert and download to an MP3 player. That's probably your best choice, though an expensive one. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: RANT ABOUT OCP, Re: Small help
Same with me. And as budgets dwindled, I stopped after getting my 'shingle' for Ora8 (upgrade, that is).. - Kirti -Original Message- From: Joseph Testa [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 8:06 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: RANT ABOUT OCP, Re: Small help Anyone who's watched the list for a week will know me, no political correctness here :) and thats probably the only reason i am OCP, the company i worked for at the time, paid for the tests and gave me a bonus to complete them. :) joe From: "Thater, William" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT: RANT ABOUT OCP, Re: Small help Date: Thu, 29 Mar 2001 05:00:25 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id IAA04008for jtestamail@localhost; Thu, 29 Mar 2001 08:36:51 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Thu, 29 Mar 2001 08:36:56 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2TEbEl28072for [EMAIL PROTECTED]; Thu, 29 Mar 2001 08:37:14 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA15519;Thu, 29 Mar 2001 05:24:54 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DB44A; Thu, 29 Mar 2001 05:00:25 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Thater, William" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: "Joseph S. Testa" wrote: Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe you know you really should tell us just how you feel and not beat around the bush that way.;-) i got asked yesterday by damagement why i wasn't certified. when i asked if they would pay for the courses/exams they didn't seem to think that was "in the training budget". so i said they's just have to put up with me the way i was and got back to building the database infrastructure.;-) oh well, guess i'll end up loosing out to someone with an OCP.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL
RE: OT: RANT ABOUT OCP, Re: Small help
Xing, Your OCP course may mention the script (depends which course you plan to take), but they will only mention it quickly. You can look it up in the Oracle administration manuals, or in the O'Reilly Oracle Built-In Packages book. Basically it generates statistics for the optimizer within a given schema. The OCP course will give you a basic overview of what Oracle can do and what all its parts are, but it won't give you enough info to administer databases properly. It's a good starting point, though -- you will have been exposed to an overview of what it is all about. To learn to administer Oracle, you MUST have a test instance to "play" with to try different things. At the same time, try to get exposure to it with people who are doing that work. With a test DB you could look up the procedure, then say "I wonder what it really does" and try it on your own instance, then notice what happens. To administer Oracle you must have an understanding of how it works, but also you need experience with it because the courses and the manuals don't tell you everything. Some of it is trial and error, getting bruised, etc. etc. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Subject: Re:OT: RANT ABOUT OCP, Re: Small help Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list,
RE: identify which logs are need to start recovery
Hi, Rahul, Unfortunately, there is no v$view. v$log_history also isn't a good candidate - v$log_history data are stored in the controlfile, and controlfile loss would make database unrecoverable (we know, this is not the case). My assumption is Oracle stores checkpoint SEQ# in the datafile header, as well as SCN, and for recovery purposes Oracle checks every datafile, takes minimum SEQ# and prompt us for this log. The following command is used to dump file headers alter session set events 'immediate trace name file_hdrs level 10'; The following is a small piece of dump, note thread:1 rba:(0xb6.6d.160) at the end - I strongly believe 0xb6 is SEQ# and thread:1 is thread number of redo log, required for recovery. Archived log SEQ# will be this number minus one. DATA FILE #10: (name #13) /u02/oradata/simplydb/simply.dbf creation size=12800 block size=4096 status=0xe head=13 tail=13 dup=1 tablespace 9, index=10 krfil=10 prev_file=0 unrecoverable scn: 0x. 11/21/2000 10:54:54 Checkpoint cnt:1139 scn: 0x.00283091 03/29/2001 09:32:28 Stop scn: 0x. 03/22/2001 13:00:14 Creation Checkpointed at scn: 0x.0001d187 11/16/2000 15:37:16 thread:1 rba:(0xb6.6d.160) I'm not absolutely sure, this is correct, but looks like for me. Best regards, Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, March 29, 2001 3:19 AM To: Multiple recipients of list ORACLE-L Lisa/List, when we restore a datafile from a backup, oracle will check the change# in the header of the datafile and will try to match it with the one in the controlfile, correct ? that's how oracle will know that the file is out-of-sync, now oracle will prompt from the change# as well as the log sequence number to apply !! from where does it get the log sequence number ? is it sotred in each datafile ? or oralce queries it from v$log_history ? Rahul -- From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:02 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: identify which logs are need to start recovery Hi Rahul, I'm not sure if there's a v$ view that will tell you, I remember looking for this myself. However if you initiate recovery it will ask for the appropriate arclog, and you can always cancel out. During testing, I found that it will ask for every single one since the backup set from which you restored your datafile, regardless of whether or not it needs it (in this case, the datafile that was lost didn't contain any tables that had changed since the last backup. Go figure). HTH Lisa Rutland Koivu Oracle Database Administrator [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Rahul [ mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 11:13 PM To: Multiple recipients of list ORACLE-L Subject: identify which logs are need to start recovery usually i keep 2-3 previous archived logs, after switching and starting the hotbackup... but is there a v$ view to show which logs are needed to start the recovery ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL
SGI to AIX conversion
We need to move a 700g Oracle DW from SGI IRIX64 (SGI's 64 bit unix) to AIX and upgrade it from 7.3.3 to 8.1.7 at the same time. Anyone got any suggestions on how to do this quickly? I'd rather only use exp/imp as a last resort because it'll be so slow. One idea we've thought about is to:1. Backup controlfile to trace2. Modify the generated script to recreate the controlfile and reset the logs.3. Do a straight copy of the datafiles from one machine to the other4. Bring up the database on AIX using the modified script.Has anyone ever tried anything like this going from IRIX to AIX? We've done the same thing before going from HPUX to IRIX with no problems, but that was with both systems on the same version of Oracle.Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
Re: OT: RANT ABOUT OCP, Re: Small help
Well done Bill...nicely handled...gotta remember that one! [EMAIL PROTECTED] 03/29/01 08:00AM "Joseph S. Testa" wrote: Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe you know you really should tell us just how you feel and not beat around the bush that way.;-) i got asked yesterday by damagement why i wasn't certified. when i asked if they would pay for the courses/exams they didn't seem to think that was "in the training budget". so i said they's just have to put up with me the way i was and got back to building the database infrastructure.;-) oh well, guess i'll end up loosing out to someone with an OCP.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: RANT ABOUT OCP, Re: Small help
I'll be the first to admit that sometimes I ask a question when I should probably look up the answer, but is it just me, or do about half the messages on the list seem like they could be answered in about 5 minutes by typing the question into google or RTFM. I mean seriously, I was running into issues installing 8.1.5 on Solaris 2.6 x86 and until I worked all the way through the install instructions, I had issues. In the process, I learned a boatload about Solaris and Oracle. No, I'm not slamming anyone who asks simple questions, some things aren't worth the time to research. Kind of like when someone asks for help with a regexp in a shell script. Are we going to tell that person they should become a script guru? No, a quick help is very appropriate. The questions like "How do I install 8.X.X on Linux" or "How do I become a DBA", those are the questions that frost me because they imply a complete lack of effort expended. On the other hand, if someone says, "I read through the docs and this site and that site, but because I'm still new, I don't understand how the Log writer works, can someone explain it?", that's a person I feel good about helping. Dan "growl" -Original Message- Sent: Thursday, March 29, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Re: Peformance Tuning Book - check books at www.OracleTuning.com
There is a list of good books at www.OracleTuning.com "Syed Ahmed" balkhi@hotmaTo: Multiple recipients of list ORACLE-L il.com [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Peformance Tuning Book com 03/29/2001 08:56 AM Please respond to ORACLE-L Anybody can give me a name for Performance Tuning book, my knowledge is low and I am not dealing with Performance issue at my work. I am responsible for backup and recover stuff. Now I think, I should update my knowledge on Performance and Tuning. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Syed Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
INVALID Packages
I have been experiencing some packages that cannot be automatically handled by Oracle when they become invalidated. Here's the scenario: We have package1 that calls package2 which, in turn, calls package3. Under normal circumstances, if package3's specification gets recompiled, package1(?) and package2 will be marked with a status of INVALID. This flags Oracle to re-parse it and mark the status VALID (excluding any coding errors). The problem comes in to play when, every once in a while, a tester or developer will get an error 6508 - could not find program unit... The fix has been to recompile the package being called by the alter package command. You see the bigger problem here... finding the actual library being referred to! I have to jump into the developers code and walk through the execution. And yes I am trying to get the developers to do this on their own. My question is: What is preventing Oracle from re-parsing the package? It has nothing to do with system load or lack of SGA. We're running Oracle 8.0.5.2.1 on Solaris 2.6 w/latest patchset. Thanks in advance - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why can't I see any Application Systems in my Des 2000
This might have worked better had you created a repository from scratch in your new 8.1.5 database, then exported/imported the application systems from your old repository to your new one. This is how I would have done it. [EMAIL PROTECTED] 03/29/01 08:00AM I just migrated my database that supports Des/2000 version 2.1 from 7.3.4 to 8.1.5. I did not upgrade Designer and don't plan to at this time. Due to lack of any specific documentation anywhere on how to migrate this database, I simply created a brand new database of the same name on a different box as 8.1.5 and imported a full database dump that I had exported from the system Oracle ID on the old 7.3.4 database. I doubted this would work but thought I would try. I changed my tnsnames.ora file on my NT to point to the new database and brought Des/2000 up. The Application System pop-up window comes up and shows me no Application Systems. If I hit cancel on this popup, I can get to and bring up the Repository Adminstration Utility. I selected Upgrade, went through the various steps, and everything says that my repository is already up to date. I feel that I am missing some script. Perhaps a cat for Designer/2000. Is there any such thing? Is there anything else I can run from the Repository Administration Utility that will make my Application Systems show up in the pop-up window? Can anyone point me to any documentation on how to migrate a database supporting Des/2000 without upgrading Designer? I have looked through a lot on online documentation on Technet, Metalink but all of it assumes that you are upgrading Designer. Thanks in advance to any kind soul who can help. I've posted multiple times on this topic but not recieved any specific steps to run. Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
Yeph.. see I am blind and at the same time I can type too.. can U read this??? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:15 AM Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this
Book
Hi, Gurus, Can you give me an advice about a performance book. I want to buy a oracle performance tuning book where scripts are available and like a handbook. What is the name and ISDN of this book? Thanks bunyamin
RE: Standard vs Enterprise Edition
At 03:50 PM 3/28/01 -0800, you wrote: RE: Standard vs Enterprise Edition [growl] This is sort of off topic, but on the subject of "Enterprise Edition"s As you may remember, I've been doing comparisons between Oracle, SQLServer, and DB2, pricewise and otherwise. I asked for prices on the "Enterprise" versions of all, so that I could be comparing the full-featured flagships in all cases. Well, it turns out IBM's DB2 also comes in "Extended Enterprise Edition" (E3), which adds clustering to the mix (actually pretty good specs on that feature). Apologies to anyone who gets offended, but this is kind of like how condoms come in "Large", "Larger", and "Huge". Dennis Taylor No one feels quite as helpless as the owner of a sick goldfish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- # tables in your db (was: Slow database)
Happy Birthday Patrice! Here you go: SQL select object_type, count(*) 2 from dba_objects 3 where owner != 'SYS' 4 andowner != 'SYSTEM' 5 andowner != 'CTXSYS' 6 andowner != 'DBSNMP' 7 group by object_type; OBJECT_TYPE COUNT(*) --- -- DATABASE LINK6 FUNCTION 6 INDEX 6173 PACKAGE 3674 PACKAGE BODY 3650 PROCEDURE 11 SEQUENCE 1280 SYNONYM 4758 TABLE 2961 TRIGGER595 VIEW 4430 11 rows selected. Oracle 8.0.5 For those of you on 8i take out the MDSYS, ORDSYS, etc OWNERS. No fair counting Oracle cartridge OWNERS. On Thursday 29 March 2001 08:26, Patrice Boivin wrote: "very complex" at 300 tables. I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159 database links. 1064 views, again excluding SYS and SYSTEM. This is on Oracle 7.3.4. I am sure this is not the smallest db out there... (It's my birthday, so what if I feel a bit competitive today -- let's start a thread). : ) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
Also, for Oracle 7 at least, the documentation is about 10,000 pages long, that would take a lot of tapes. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: dana Sent: Thursday, March 29, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Books on Audio Tapes --- Apps Sol [EMAIL PROTECTED] wrote: Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK I doubt it. From what I understand, audio books are primarily made from best-selling fiction. What non-fiction audio books exist are probably limited to stuff with the broadest general appeal (best-sellers). I've personally never heard of technical books on tape/audio CD. However, you might be able to make your own, rather tediously, if you receive a PDF version along with a "dead tree" technical book. 1. Copy-paste the text from the PDF to your word processor of choice. 2. Use text-to-speech software to creave WAV files 3. Burn to CD. Or, you may want to purchase some Oracle Computer-Based-Training CDROMs and burn the audio tracks to an audio CD(if they're in a standard audio format or a format you could convert to WAVs) - or convert and download to an MP3 player. That's probably your best choice, though an expensive one. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SGI to AIX conversion
Chuck Hamilton wrote: We need to move a 700g Oracle DW from SGI IRIX64 (SGI's 64 bit unix) to AIX and upgrade it from 7.3.3 to 8.1.7 at the same time. Anyone got any suggestions on how to do this quickly? I'd rather only use exp/imp as a last resort because it'll be so slow. ifn it was me, i'd move the database first and then do the upgrade. lessen your chances of failure.;-) if you're keeping the mount points the same, you can just shutdown, copy everything over, and startup. then do the upgrade from there. that worked for me last time i did a move from HP-UX to Solaris. YMMV and all that rot. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: nvl affect on idexes
Eric, Oracle won't use the index in this case. Instead have a function-based index. Prakash -Original Message- Sent: Thursday, March 29, 2001 9:43 AM To: Multiple recipients of list ORACLE-L Does nvl have any effect on indexes. In other words would it slow down a query if you used the nvl function in the where clause on an indexed field. i.e. select * from foo where indexField nvl(xfoo,0); Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- # tables in your db (was: Slow database)
"very complex" at 300 tables. I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159 database links. 1064 views, again excluding SYS and SYSTEM. This is on Oracle 7.3.4. I am sure this is not the smallest db out there... (It's my birthday, so what if I feel a bit competitive today -- let's start a thread). allright, allright got the hint happy birthday Patrice :-)) : ) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject:Slow database We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we are quering the database( a procedure runs) it sometimes take so long time to get the result, almost one hour, but sometimes it just takes about 20 seconds to get the result. Which means that this doesnt happen everytime. What do you suggest that I should do? Do we need to split the database? Is there any problem with the Accessapplication, i mean is it possibility that MsAccess cant access oracledatabases always when the database is very big. And that the reason to slow access to the database should be in the Access environment? Please help me with any suggestions how to solve this. /Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Apostolopoulos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: online backup query
Winnie thanks for ur reply. I am doing online backup by following steps.Is this way is correct or not.Please correct me. 1)Archive log list 2)alter system switch logfile; 3)alter database backup controlfile to trace; 4)ALter tablespace and copy all datafiles one by one. 5)alter system switch logfile; 6)archive log stop; 7)copy all archive logs 8)archive log start; 9)archive log list 10)binary backup of the controlfile Please correct IF I am wrong in sequence let me know. Thanks -Seema From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: online backup query Date: Wed, 28 Mar 2001 13:30:28 -0800 In V$INSTANCE, there is a column named PARALLEL which will tell you whether the instance is in OPS mode or not. In online backup mode, you will need to backup 1) all datafiles 2) a binary backup of the controlfile 3) all archivelog files generated during the online backup period of time 4) I will also backup the init.ora file, a backup trace of the controlfile, password file etc. Winnie "Seema Singh" [EMAIL PROTECTED]@fatcity.com on 03/28/2001 12:25:55 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi gurus I am new to this group. What are those files need to backup in online backup mode? how we know the database is setup in OPS mode? Please help me. Thanks in advance. Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Books on Audio Tapes
Dear me - is it my job today to get sarcastic jibes thrown at me. Whose turn is it tomorrow. You said originally Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK You could have been getting them for a blind colleague. Oh sod it - why do I bother. at least its Friday tomorrow. I wonder what the recipe will be.. lightly grilled Lee ? -Original Message- Sent: 29 March 2001 16:35 To: Multiple recipients of list ORACLE-L Yeph.. see I am blind and at the same time I can type too.. can U read this??? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:15 AM Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the
Re[2]:OT: RANT ABOUT OCP, Re: Small help
Cherie, OK, point well taken, so "silver bullet" would translate into "the one item that will succeed when no other does", "magic formula". And, no he never did say he had an OCP, but he did say he was taking a "course" to get his OCP. To me having an OCP certificate without any experience is totally meaningless. All it tells me is that you can memorize information and take a test. It does not tell me that you'll hold up in a crisis or that you really understand the consequences of your actions. That experience speaks volumes more. Now someone with a number of years experience AND an OCP certificate is a different matter altogether. Consequently my question, are new people looking at the OCP as the gateway into a position that they could not otherwise get? BTW: I'm not trying to either criticize or "brow beat" Xing. If that impression has been left, then I apologize. He asked a question, similar ones I field in house each day, and he was given an answer that is similar to the ones I hand out to my developers although I'd have given him the page number too and a whole lot less trash than Xing has gotten from this list. In my mind that is sufficient to the purpose. Now if that creates additional questions, a much longer dissertation on the results is in order. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 3/29/2001 6:35 AM Dick/Lee/Joe, I'm not trying to defend him but unless I have not yet recieved a post in my mail, Xing never said he had an OCP. Plus, Lee, I think you may need to define "silver bullet". It probably doesn't translate for people who don't use English as a second language. Cherie Machler Gelco Information Network (really too busy this morning migrating a database to be sticking my nose where it doesn't belong) [EMAIL PROTECTED]@fatcity.com on 03/29/2001 08:00:45 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
Oracle training vs IOUG-A vs ECO
My grand-boss thinks that conferences are a waste of money and training classes are a much better dollar value. I probably took my last Oracle Education class about 10 years ago and have been to every ECO conference except last year (and because of personal conflicts cannot do ECO again this year). I have no doubt about the value I have received from ECO over the years. I am probably going to get to go to IOUG-A (despite the sentiments of the grand-boss), but would like to hear some opinions (positive and negative) from people who have experienced at least two out of three of the above. Which was the better conference--ECO or IOUG-A--and why? Perhaps I should be including Oracle Open World in the list also. In the past I have heard complaints about overcrowding at IOUG-A, is this still a big problem? For an experienced person, how good are Oracle training classes for learning new material compared to a conference? My memory is that the training courses were dominated by beginners--is that still true? Specifically, we are getting ready to go to 8.1.6 or 8.1.7 from 7.3.4 on NT and Alpha Open VMS. So the specific training would be Oracle's Migrating to Version 8 seminars (a series of 3 one day classes). In reading the IOUG-A program that came the other day, I could not find a single presenter from Oracle Corporation. Does Oracle no longer permit its people to present or is IOUG-A now excluding them? Where are the Oracle people presenting these days? I have been to some dynamite presentations by Oracle people in the past. Thanks, Sarah Satterthwaite Oracle DBA Case Shiller Weiss, Inc Cambridge, MA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sarah Satterthwaite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
You can search the Oracle Documentation online at http://www.oracletuning.com "Boivin, Patrice J" To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED][EMAIL PROTECTED] mpo.gc.ca cc: Sent by: Subject: RE: Oracle Books on Audio Tapes [EMAIL PROTECTED] 03/29/2001 10:45 AM Please respond to ORACLE-L Also, for Oracle 7 at least, the documentation is about 10,000 pages long, that would take a lot of tapes. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: dana Sent: Thursday, March 29, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Books on Audio Tapes --- Apps Sol [EMAIL PROTECTED] wrote: Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK I doubt it. From what I understand, audio books are primarily made from best-selling fiction. What non-fiction audio books exist are probably limited to stuff with the broadest general appeal (best-sellers). I've personally never heard of technical books on tape/audio CD. However, you might be able to make your own, rather tediously, if you receive a PDF version along with a "dead tree" technical book. 1. Copy-paste the text from the PDF to your word processor of choice. 2. Use text-to-speech software to creave WAV files 3. Burn to CD. Or, you may want to purchase some Oracle Computer-Based-Training CDROMs and burn the audio tracks to an audio CD(if they're in a standard audio format or a format you could convert to WAVs) - or convert and download to an MP3 player. That's probably your best choice, though an expensive one. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: Oracle Books on Audio Tapes
Surely there's a Reader's Digest Condensed Version Or how about Cliff Notes? [EMAIL PROTECTED] 03/29/01 10:45AM Also, for Oracle 7 at least, the documentation is about 10,000 pages long, that would take a lot of tapes. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: dana Sent: Thursday, March 29, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Books on Audio Tapes --- Apps Sol [EMAIL PROTECTED] wrote: Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK I doubt it. From what I understand, audio books are primarily made from best-selling fiction. What non-fiction audio books exist are probably limited to stuff with the broadest general appeal (best-sellers). I've personally never heard of technical books on tape/audio CD. However, you might be able to make your own, rather tediously, if you receive a PDF version along with a "dead tree" technical book. 1. Copy-paste the text from the PDF to your word processor of choice. 2. Use text-to-speech software to creave WAV files 3. Burn to CD. Or, you may want to purchase some Oracle Computer-Based-Training CDROMs and burn the audio tracks to an audio CD(if they're in a standard audio format or a format you could convert to WAVs) - or convert and download to an MP3 player. That's probably your best choice, though an expensive one. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standard vs Enterprise Edition
I am compelled to tell you this story... Many years ago I had a gold fish that had some sort of parasite on it...it was green. My gold fish book actually had a remedy for this. Take the fish out of the water, remove the parasite with tweezers, apply a small drop of mecurchrome(sp?), then bathe the fish in a lite saltwater solution for an hour. Sounds weird? Maybe, but I did it, and it worked! The spot on the fish actually healed. [EMAIL PROTECTED] 03/29/01 10:35AM RE: Standard vs Enterprise Edition [growl] This is sort of off topic, but on the subject of "EnterpriseEdition"s As you may remember, I've been doing comparisons betweenOracle, SQLServer, and DB2, pricewise and otherwise. I asked for priceson the "Enterprise" versions of all, so that I could be comparing thefull-featured flagships in all cases. Well, it turns out IBM's DB2 alsocomes in "Extended Enterprise Edition" (E3), which adds clustering to themix (actually pretty good specs on that feature).Apologies to anyone who gets offended, but this is kind of like howcondoms come in "Large", "Larger", and "Huge".Dennis TaylorNo one feels quite as helpless as the owner of a sick goldfish.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dennis Taylor INET: [EMAIL PROTECTED] City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: nvl affect on idexes
Well, assuming xfoo is a variable, this is not correct...the function is not being used on the indexed field in this case, so the index WILL be used. If xfoo is a column in the table, then I would expect a full table scan to be used. [EMAIL PROTECTED] 03/29/01 11:16AM Eric, Oracle won't use the index in this case. Instead have a function-based index. Prakash -Original Message- Sent: Thursday, March 29, 2001 9:43 AM To: Multiple recipients of list ORACLE-L Does nvl have any effect on indexes. In other words would it slow down a query if you used the nvl function in the where clause on an indexed field. i.e. select * from foo where indexField nvl(xfoo,0); Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 training vs IOUG-A vs ECO
Sarah, Unfortunately, you wouldn't get to go to ECO this year no matter what. Oracle User Resource has decided to discontinue that conference. ECO is dead. Personal opinion: training classes teach you exactly what the trainers want you to see/know. A conference, while it does not give you the same in-depth knowledge that a class does, gives you a broader perspective on what's out there and how it is being used and what does and doesn't work the way they say. Conferences also give you the networking to be able to ask questions of experts. Many of the people I consult for specialized knowledge are people I've met at one or another conference. Of ECO, IOUG and OpenWorld, I have loved ECO best. Because it was very small (usually less than 1000), because you got really up close and personal with the presenters, were able to find them and talk to them after their presentations. Next best (for me) is IOUG. Again, large but smaller than OpenWorld. No sales-pitch presentations. A way to connect with the people who have specialized knowledge. Having said that, I made it part of the deal that I get to go to at least 2 conferences a year. which means IOUG and OpenWorld, since there isn't ECO any more. Rachel From: Sarah Satterthwaite [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Oracle training vs IOUG-A vs ECO Date: Thu, 29 Mar 2001 08:06:25 -0800 My grand-boss thinks that conferences are a waste of money and training classes are a much better dollar value. I probably took my last Oracle Education class about 10 years ago and have been to every ECO conference except last year (and because of personal conflicts cannot do ECO again this year). I have no doubt about the value I have received from ECO over the years. I am probably going to get to go to IOUG-A (despite the sentiments of the grand-boss), but would like to hear some opinions (positive and negative) from people who have experienced at least two out of three of the above. Which was the better conference--ECO or IOUG-A--and why? Perhaps I should be including Oracle Open World in the list also. In the past I have heard complaints about overcrowding at IOUG-A, is this still a big problem? For an experienced person, how good are Oracle training classes for learning new material compared to a conference? My memory is that the training courses were dominated by beginners--is that still true? Specifically, we are getting ready to go to 8.1.6 or 8.1.7 from 7.3.4 on NT and Alpha Open VMS. So the specific training would be Oracle's Migrating to Version 8 seminars (a series of 3 one day classes). In reading the IOUG-A program that came the other day, I could not find a single presenter from Oracle Corporation. Does Oracle no longer permit its people to present or is IOUG-A now excluding them? Where are the Oracle people presenting these days? I have been to some dynamite presentations by Oracle people in the past. Thanks, Sarah Satterthwaite Oracle DBA Case Shiller Weiss, Inc Cambridge, MA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sarah Satterthwaite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to break into DBA/Systems work without going broke doing it?
"Dasko, Dan" wrote: OK, now I have to ask a question. How did you(general) break into the DBA i walked into work one day and found this pile of books on my desk. i said "what's this?" and they said "you're the new DBA and it's broke so fix it now!" and i was a contractor at the time.;-) i've been running scared ever since.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is terminal release of 8.0.x still supported?
I see that a lot. I am starting to put my foot down. I can't even install one product because it insists on 8.1.5. So either get me a version that runs with 8.1.7 or go home. I am tired of having 6 versions of Oracle in this shop. OK 6 may be high. I got 7.3.3, 8.0.5, 8.0.6, 8.1.5, 8.1.6, and 8.1.7. No, my original guess was correct. All because of 3rd party tools. The only thing on terminal releases are stuff written in-house. -Original Message- Sent: Thursday, March 29, 2001 4:45 AM To: Multiple recipients of list ORACLE-L I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: INVALID Packages
Oracle Support never replied satisfactorly on this issue. What I have seen it is a result of some corruption at dictionery level and as a last resort they recommend to run catalog.ora file to rebuild dictionery and compile all resultant invalid objects and then they will compile without any problem. In case of Oracle Fiancials with so may products installed it goes to around 5000+ objects to recompile. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 29 Mar 2001 07:06:35 -0800 I have been experiencing some packages that cannot be automatically handled by Oracle when they become invalidated. Here's the scenario: We have package1 that calls package2 which, in turn, calls package3. Under normal circumstances, if package3's specification gets recompiled, package1(?) and package2 will be marked with a status of INVALID. This flags Oracle to re-parse it and mark the status VALID (excluding any coding errors). The problem comes in to play when, every once in a while, a tester or developer will get an error 6508 - could not find program unit... The fix has been to recompile the package being called by the alter package command. You see the bigger problem here... finding the actual library being referred to! I have to jump into the developers code and walk through the execution. And yes I am trying to get the developers to do this on their own. My question is: What is preventing Oracle from re-parsing the package? It has nothing to do with system load or lack of SGA. We're running Oracle 8.0.5.2.1 on Solaris 2.6 w/latest patchset. Thanks in advance - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT -- Friday Recipe was: Oracle Books on Audio Tapes
dunno any votes for my shortbread cookie recipe? From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle Books on Audio Tapes Date: Thu, 29 Mar 2001 08:06:24 -0800 Dear me - is it my job today to get sarcastic jibes thrown at me. Whose turn is it tomorrow. You said originally Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK You could have been getting them for a blind colleague. Oh sod it - why do I bother. at least its Friday tomorrow. I wonder what the recipe will be.. lightly grilled Lee ? -Original Message- Sent: 29 March 2001 16:35 To: Multiple recipients of list ORACLE-L Yeph.. see I am blind and at the same time I can type too.. can U read this??? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:15 AM Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services
RE: How to break into DBA/Systems work without going broke doing
I annoyed my managers until they realized that there was really no one else to do it and then they gave in. I was really lucky in that I got to work on an excellent project with some very experienced DBAs. Stayed there for a while and picked up tones of experience. -Original Message- Sent: Thursday, March 29, 2001 9:00 AM To: Multiple recipients of list ORACLE-L doing it? "Dasko, Dan" wrote: OK, now I have to ask a question. How did you(general) break into the DBA i walked into work one day and found this pile of books on my desk. i said "what's this?" and they said "you're the new DBA and it's broke so fix it now!" and i was a contractor at the time.;-) i've been running scared ever since.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standard vs Enterprise Edition
Eeeww! OK, I am now grossed out. At 08:48 AM 3/29/01 -0800, you wrote: I am compelled to tell you this story... Many years ago I had a gold fish that had some sort of parasite on it...it was green. My gold fish book actually had a remedy for this. Take the fish out of the water, remove the parasite with tweezers, apply a small drop of mecurchrome(sp?), then bathe the fish in a lite saltwater solution for an hour. Sounds weird? Maybe, but I did it, and it worked! The spot on the fish actually healed. [EMAIL PROTECTED] 03/29/01 10:35AM RE: Standard vs Enterprise Edition [growl] This is sort of off topic, but on the subject of "EnterpriseEdition"s As you may remember, I've been doing comparisons betweenOracle, SQLServer, and DB2, pricewise and otherwise. I asked for priceson the "Enterprise" versions of all, so that I could be comparing thefull-featured flagships in all cases. Well, it turns out IBM's DB2 alsocomes in "Extended Enterprise Edition" (E3), which adds clustering to themix (actually pretty good specs on that feature).Apologies to anyone who gets offended, but this is kind of like howcondoms come in "Large", "Larger", and "Huge".Dennis TaylorNo one feels quite as helpless as the owner of a sick goldfish.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dennis Taylor INET: [EMAIL PROTECTED] City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Dennis Taylor No one feels quite as helpless as the owner of a sick goldfish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
Being Optically challenged is not a problem for some people. At my last employer there was a sharp programmer that worked on a national level project and he was good. If you never met the man you would not know that he was blind and used a guide dog to get around in the different cities and meetings he attended. His email was converted to text and his manuals were in braille. There are people in the world that do not know they are "challenged" until we tell them. They get along perfectly well and some of them can perform better that the "unchallenged". ROR mm [EMAIL PROTECTED] 03/29/01 10:35AM Yeph.. see I am blind and at the same time I can type too.. can U read this??? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:15 AM Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes
Rachel Carmichael wrote: dunno any votes for my shortbread cookie recipe? i move we have the godess' shortbread recipe! seconds?;-) and why do i think it's not going to be good for my diet?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Set transaction does not work
RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Friday Recipe was: Oracle Books on Audio Tapes
I'll stick my hand up : -Original Message- Carmichael Sent: Thursday, March 29, 2001 06:06 To: Multiple recipients of list ORACLE-L dunno any votes for my shortbread cookie recipe? From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle Books on Audio Tapes Date: Thu, 29 Mar 2001 08:06:24 -0800 Dear me - is it my job today to get sarcastic jibes thrown at me. Whose turn is it tomorrow. You said originally Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK You could have been getting them for a blind colleague. Oh sod it - why do I bother. at least its Friday tomorrow. I wonder what the recipe will be.. lightly grilled Lee ? -Original Message- Sent: 29 March 2001 16:35 To: Multiple recipients of list ORACLE-L Yeph.. see I am blind and at the same time I can type too.. can U read this??? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:15 AM Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the
Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes
I'll second that one! What diet? Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 12:38 PM Rachel Carmichael wrote: dunno any votes for my shortbread cookie recipe? i move we have the godess' shortbread recipe! seconds?;-) and why do i think it's not going to be good for my diet?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to break into DBA/Systems work without going broke doing
I started out as a Pro*C developer and helped out our help desk on rotation when our product was released. This was the help desk that fielded all the questions that the administrators out at all the sites needed help finding answers to...kinda like this list (well except that I couldn't pick and choose which questions I would answer). :) Anyways, since I did such a wonderful job helping the admins get their problems resolved, they asked me to help our DBA team out by developing utilities to ease the burden of managing and propagating changes to the 1250 Oracle v6 instances we had. Then one day the boss of a friend of mine (who I had been helping with some Oracle problems he had run into) called and asked if I would be interested in helping with their current project of migrating mainframe apps to Oracle...and after all the hassle of getting me over to his organization, I became the primary DBA and Developer2000 person. As for becoming a DBA and easing the transition, one way is to become friendly with any DBAs you know (preferably where you work at or at least nearby)...show interest in what they do and see if they'll show you stuff. Ask them if you can sit in when they do a reorg late at night or over the weekend (well, if you can't sacrifice your salary, then you generally have to give up some time). Don't ask too many questions or get in the way...just watch and take notes (and then try it on your own on a test box somewhere which will answer most of the questions anyways, but if you still have questions, you can ask them about it now and get better responses because there isn't any crunch-time pressure involved). Network and chat with DBAs all around about Oracle stuff and when they go to hire a new DBA you just might have a chance that they remember you and might give you a call to see if you're interested. Despite appearances sometimes, we're mostly a friendly lot. :) Jeffery Stevenson Chief Database Geek Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, March 29, 2001 10:31 AM To: Multiple recipients of list ORACLE-L it? OK, now I have to ask a question. How did you(general) break into the DBA business? I'm not currently a DBA, I've installed a few development instances with the help of the NT dbassitant, tried looking for work as a DBA a couple of years ago, then realized how much I didn't know and in many ways was glad I didn't get a job as a DBA. Now, I'm playing 8.1.5 on Solaris, but really, I'm not cutting my salary in half in order to break into the systems side of the house, so how does a person move from development to systems without going broke in the process? PS - I have some ideas, but I'm curious about your ideas. Dan -Original Message- Sent: Thursday, March 29, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Cherie, OK, point well taken, so "silver bullet" would translate into "the one item that will succeed when no other does", "magic formula". And, no he never did say he had an OCP, but he did say he was taking a "course" to get his OCP. To me having an OCP certificate without any experience is totally meaningless. All it tells me is that you can memorize information and take a test. It does not tell me that you'll hold up in a crisis or that you really understand the consequences of your actions. That experience speaks volumes more. Now someone with a number of years experience AND an OCP certificate is a different matter altogether. Consequently my question, are new people looking at the OCP as the gateway into a position that they could not otherwise get? BTW: I'm not trying to either criticize or "brow beat" Xing. If that impression has been left, then I apologize. He asked a question, similar ones I field in house each day, and he was given an answer that is similar to the ones I hand out to my developers although I'd have given him the page number too and a whole lot less trash than Xing has gotten from this list. In my mind that is sufficient to the purpose. Now if that creates additional questions, a much longer dissertation on the results is in order. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 3/29/2001 6:35 AM Dick/Lee/Joe, I'm not trying to defend him but unless I have not yet recieved a post in my mail, Xing never said he had an OCP. Plus, Lee, I think you may need to define "silver bullet". It probably doesn't translate for people who don't use English as a second language. Cherie Machler Gelco Information Network (really too busy this morning migrating a database to be sticking my nose where it doesn't belong) [EMAIL PROTECTED]@fatcity.com on 03/29/2001 08:00:45 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Lee Joe, While I do agree that is possible one should try to figure these things out, and this
Re: Set transaction does not work
I think the big rollback segment needs to be private. [EMAIL PROTECTED] 03/29/01 12:50PM RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 training vs IOUG-A vs ECO
Check the IOUG-A sessions again. The presenters from Oracle were added later, after IOUG and Oracle Corp. reached a new "understanding". I looked at the sessions this morning and there are now Oracle presenters in the mix. Dean Jefferson Database Administrator State of Wisconsin Office of Commissioner of Insurance [EMAIL PROTECTED] -Original Message- From: Sarah Satterthwaite [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject: Oracle training vs IOUG-A vs ECO (snip) Which was the better conference--ECO or IOUG-A--and why? Perhaps I should be including Oracle Open World in the list also. In the past I have heard complaints about overcrowding at IOUG-A, is this still a big problem? In reading the IOUG-A program that came the other day, I could not find a single presenter from Oracle Corporation. Does Oracle no longer permit its people to present or is IOUG-A now excluding them? Where are the Oracle people presenting these days? I have been to some dynamite presentations by Oracle people in the past. Thanks, Sarah Satterthwaite Oracle DBA Case Shiller Weiss, Inc Cambridge, MA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jefferson, Dean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
Might want to have a chat with Recording for the Blind and Dyslexic. They might have such books, or they might advise you on how to structure an audio for this purpose. It's convenient that the docs come as small HTML files all linked together -- a voice-activated PC might be able to handle this requirement. -Original Message- Sent: Thursday, March 29, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Surely there's a Reader's Digest Condensed Version Or how about Cliff Notes? [EMAIL PROTECTED] 03/29/01 10:45AM Also, for Oracle 7 at least, the documentation is about 10,000 pages long, that would take a lot of tapes. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: dana Sent: Thursday, March 29, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Books on Audio Tapes --- Apps Sol [EMAIL PROTECTED] wrote: Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK I doubt it. From what I understand, audio books are primarily made from best-selling fiction. What non-fiction audio books exist are probably limited to stuff with the broadest general appeal (best-sellers). I've personally never heard of technical books on tape/audio CD. However, you might be able to make your own, rather tediously, if you receive a PDF version along with a "dead tree" technical book. 1. Copy-paste the text from the PDF to your word processor of choice. 2. Use text-to-speech software to creave WAV files 3. Burn to CD. Or, you may want to purchase some Oracle Computer-Based-Training CDROMs and burn the audio tracks to an audio CD(if they're in a standard audio format or a format you could convert to WAVs) - or convert and download to an MP3 player. That's probably your best choice, though an expensive one. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Shreter, Hilary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrade from 8.0.6 to 8.1.7
Hi Guys, Did anyone do an upgrade from oracle 8.0.6 to 8.1.7 version in a Sun Solaris envrionment ?? Can you send me step by step procedure on how to do it, I cant find any good documents on metalink. Thanks! Pallav Kalva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pallav Kalva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Set transaction does not work
Is there a session that is likewise accessing that table? What may have been blown was not your rollback segment, but the one where the other session was putting it's uncommitted changes. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 3/29/2001 9:50 AM RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes
Being the cookie monster that I am, I must second the motion! "Thater, William" wrote: Rachel Carmichael wrote: dunno any votes for my shortbread cookie recipe? i move we have the godess' shortbread recipe! seconds?;-) and why do i think it's not going to be good for my diet?;-) __ Dwayne Cox DBA, Development Dept. [EMAIL PROTECTED] Info Tech, Inc. 5700 S.W. 34th Street Suite 1235 Gainesville, FL 32608 Phone: 352.381.4400 Fax: 352.381. http://www.infotech.com ___ The opinions expressed are the author's own unless otherwise stated -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Books on Audio Tapes
I agree. I heard somewhere that the person who can read but doesn't delivers the same results as someone who can't read at all. So it's what we do, not the skill set we have in our portfolio that matters. People too often base their opinions on appearance, hearsay, or what a person could do and did in the past. My CDN$0.02. I'm philosophical today. Too many times I didn't do something when I could, and that only leads to regrets because the opportunity is lost. (birthdays get to me...) Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 1:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Books on Audio Tapes Being Optically challenged is not a problem for some people. At my last employer there was a sharp programmer that worked on a national level project and he was good. If you never met the man you would not know that he was blind and used a guide dog to get around in the different cities and meetings he attended. His email was converted to text and his manuals were in braille. There are people in the world that do not know they are "challenged" until we tell them. They get along perfectly well and some of them can perform better that the "unchallenged". ROR mm [EMAIL PROTECTED] 03/29/01 10:35AM Yeph.. see I am blind and at the same time I can type too.. can U read this??? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 6:15 AM Hate to out a dampener on all of this but the guy could be blind. -Original Message- Sent: 29 March 2001 11:50 To: Multiple recipients of list ORACLE-L You know he could be listening to it in his sleep too! Sub-conscious levels and all that.. -Original Message- Ghosalkar Sent: Thursday, March 29, 2001 04:45 To: Multiple recipients of list ORACLE-L try 1. get one of those text to voice tools from download.com 2. next keep a tape recorder near ur comp speakers 3. capture all the text from oracle manuals/soft copy of books(which u can find from the ru domains) and convert to voice 4. enjoy the casette while driving to work -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Books on Audio Tapes Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- 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: Mandar Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Set transaction does not work
Specifying a transaction rollback segment only controls to which RBS rollback information will be written. The "snapshot too old" arises when the DBMS tries to construct a read-consistent block of a table; it goes to the RBS that received rollback for some transaction that changed it, only to find that the relevant rollback info has been overwritten. You'd have to specify the BIG_ROLLBACK to be used by your other transactions *before* you issue the query. Setting an RBS has no effect on a query. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Thursday, March 29, 2001 12:51 PM To: Multiple recipients of list ORACLE-L RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Friday Recipe was: Oracle Books on Audio Tapes
Can you send it through as a .wav file? : ) -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 1:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes Rachel Carmichael wrote: dunno any votes for my shortbread cookie recipe? i move we have the godess' shortbread recipe! seconds?;-) and why do i think it's not going to be good for my diet?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Excel to oracle
You can save the Excel file in comma delimited formated, CSV and use sql*loader to put the data into the database. You can just ftp it from the machine which has Excel to the server housing the database. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 1:46 PM I have a Excel file.How to port the data to Oracle table. I read some artical about using ODBC and things like that.But I am not clear. How can we generate a dat file delimited with comas so that I can use SQlLOADer to port the data. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: RANT ABOUT OCP, Re: Small help
I think what Lee's objection was (I know when I read Xing's reply it got my goat), that Xing critized Lee for giving him a referance to look the answer up himself. I realize that it did not answer in full the actual question, but it asked Xing to do a little work on his own. If someone taking a course or studying to pass the OCP exams can not do a little work themselves, they are not cut out to be a DBA. Terry [EMAIL PROTECTED] wrote: Dick/Lee/Joe, I'm not trying to defend him but unless I have not yet recieved a post in my mail, Xing never said he had an OCP. Plus, Lee, I think you may need to define "silver bullet". It probably doesn't translate for people who don't use English as a second language. Cherie Machler Gelco Information Network (really too busy this morning migrating a database to be sticking my nose where it doesn't belong) [EMAIL PROTECTED]@fatcity.com on 03/29/2001 08:00:45 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Lee Joe, While I do agree that is possible one should try to figure these things out, and this really is a simple one, there does come a time when asking for help is appropriate. In this case Lee's answer is very much so. As far as taking an OCP course, that does torque my jaws. Over the last two years we must have had 10 people looking for a job who's only mention of Oracle on their resume is that they have their OCP certificate. Needless to say, not a one of them has been invited in for an interview. I'll ask the question that's been bugging me for some time, Xing, do you think this is some kind of "silver bullet" to getting a job? Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/29/2001 4:05 AM Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe lerobe - Lee Robertson wrote: Xing, Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages". No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you. To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ?? Regards Lee -Original Message- Sent: 29 March 2001 07:05 To: Multiple recipients of list ORACLE-L Hi DBAs and SAs, Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month. BEGIN dbms_utility.analyze_schema ( 'OWNER', 'ESTIMATE', NULL, 5 ) ; END ; / Thank you Xing -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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
RE: Set transaction does not work
I do not think it matters whether it is private or public. The only difference if public it accessible but all instances. I would try doing a commit right before the SET TRANSACTION... command. Rick -Original Message- From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 1:12 PM To: Multiple recipients of list ORACLE-L Subject: Re: Set transaction does not work I think the big rollback segment needs to be private. [EMAIL PROTECTED] 03/29/01 12:50PM RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject:Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Excel to oracle
I have a Excel file.How to port the data to Oracle table. I read some artical about using ODBC and things like that.But I am not clear. How can we generate a dat file delimited with comas so that I can use SQlLOADer to port the data. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes
Ruth Gramolini wrote: I'll second that one! What diet? Ruth the one that's supposed to make me skinny and solve all my problems.;-) scarstic mode just look at the TV, if you're skinny you're smart, everyone likes you, you get dates with the people you want, and all your problems get solved in less than 23 min., but if you're fat you're stupid and people lugh at you. /sarcastic mode -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Friday Recipe was: Oracle Books on Audio Tapes
(with apologies to the Cookie Monster) Cki!! I love shortbread, go for it [EMAIL PROTECTED] 03/29/01 01:12PM Can you send it through as a .wav file? : ) -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 1:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes Rachel Carmichael wrote: dunno any votes for my shortbread cookie recipe? i move we have the godess' shortbread recipe! seconds?;-) and why do i think it's not going to be good for my diet?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
books on tape: related topics / (Fwd) Re: Forms non-accessibility by screen-readers
selected web sites containing info on "computer access" technologies for disabled (visually impaired) users: --- Forwarded message follows --- T o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m Date sent: Tue, 6 Mar 2001 14:13:43 -0800 (fwiw) I think these are some of the larger national (usa) clearing house type operations for general info on computer accessibility for disabled persons: http://www.rit.edu/~easi - http://www.rit.edu/~easi/itnews/index.htm - Links: http://www.rit.edu/~easi/other.htm Web contest entries (example sites): http://www.rit.edu/~easi/entrants.htm Norm Coombs, CEO EASI: [EMAIL PROTECTED] Dick Banks, CIO EASI: [EMAIL PROTECTED] Questions to EASI Postmaster: [EMAIL PROTECTED] The Trace Research Development Center College of Engineering, University of Wisconsin-Madison: http://www.trace.wisc.edu/ - http://www.news.wisc.edu/wisweek/view.msql?id=5641 - http://www.trace.wisc.edu/about/faq.htm Designing More Usable Web Sites (many additional links): http://www.trace.wisc.edu/world/web/ (eg, "Netsurfing Without a Monitor" by T. V. Raman: http://www.sciam.com/0397issue/0397raman.html , and http://www.webable.com/screenreaders.html , and http://aware.hwg.org/ , and http://www.webaim.org/ , and http://www.trace.wisc.edu/world/java/java.htm , and http://www.trace.wisc.edu/world/java/jscript.htm , and http://www.w3.org/WAI/ ) Grant Funding: http://www.ed.gov/offices/OSERS/NIDRR "The United States Department of Educations Office of Special Education and Rehabilitative Services (OSERS), through its National Institute on Disability and Rehabilitation Research (NIDRR) ..." some Trace Center partner links on web accesssibility: (from http://www.trace.wisc.edu/itrerc/ ) http://www.utoronto.ca/atrc/ - http://www.cast.org/ - http://main.wgbh.org/wgbh/pages/ncam/ - and http://www.trace.wisc.edu/world/udda/ - regards, ep - Original Message - T o : "Multiple recipients of list ODTUG-DEV2K-L" O D T U G - D E V 2 K - L @ f a t c i t y . c o m Sent: Monday, March 05, 2001 1:55 PM Duncan or anyone, Our campus has a new accessibility policy where to meet guidelines new web-based systems open to the public need to be read by screen readers (e.g., JAWS) used by the sight-impaired. ... --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Set transaction does not work
Under your situation of select only statement there is no use of rollback segment whether big or small. This error is a result of some other long running job using that rollback segment. Please advise relevant developer to check his code doing some delete,update,insert and intoduce some commit size in his code first. To implement set transaction use commit first like commit; set transaction use rollback segment BIG_ROLLBACK; then your sql or code HTH Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 29 Mar 2001 09:50:55 -0800 RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From:Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent:Thursday, March 29, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade from 8.0.6 to 8.1.7
Pallav, Go to http://otn.oracle.com and get the Oracle8i Migration document under "Documentation". That will provide you with what you need! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, March 29, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Hi Guys, Did anyone do an upgrade from oracle 8.0.6 to 8.1.7 version in a Sun Solaris envrionment ?? Can you send me step by step procedure on how to do it, I cant find any good documents on metalink. Thanks! Pallav Kalva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pallav Kalva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes
OOOHH, that one. Well I guess I will have to be the fat stupid one because I love shortbread. Bring it on! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 29, 2001 1:21 PM Ruth Gramolini wrote: I'll second that one! What diet? Ruth the one that's supposed to make me skinny and solve all my problems.;-) scarstic mode just look at the TV, if you're skinny you're smart, everyone likes you, you get dates with the people you want, and all your problems get solved in less than 23 min., but if you're fat you're stupid and people lugh at you. /sarcastic mode -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Set transaction does not work
Where is the transaction? Alex Hillman -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject:Set transaction does not work RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
