Re: Exporting and Importing table statistics
It sounds like you want to ensure that an external database has the same execution plan for a query as the one you are developing and/or testing on. There's a little more to it than that. You must make sure you have the proper init.ora params set, create outlines, and export the outlines for use in another database. Take a look at Chapter 10 'Using Plan Stability' in the 'Designing and Tuning for Performance' manual. Jared On Thursday 24 May 2001 15:18, [EMAIL PROTECTED] wrote: Hi all, According to the 8i utilities manual I should be able to export a tables' statistics from one database, then import those statistics into another database. I have tried various combinations of export and import scripts but nothing seems to work. My table has none of the restrictions described in the utilities manual that would prevent the statistics from being exported and then imported. Can this export/import of statistics be done at a single table level or does it have to be a full database export? If not at the table level can it be done at the schema level? Thanks everyone, Gary Bonner [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to send email from pl/sql in 806?
HI,
i tried creating this procedure. but it results into compilation errors.
says..
utl_tcp.connection must be declared, and so does for
utl_tcp.get_line and
utl_tcp.write_line
how do we fefine them. where is this package utl_tcp
pls explore.
thanks.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 11:05 AM
try this procedure it works just replace the IP address in the line
c := utl_tcp.open_connection('192.168.1.1', 25);
with the IP address of u'r mail server
regards
__
Omar Khalid
Software Engineer
LMKResources
A LANDMARK AFFILIATE
(Formerly Mathtech Pakistan Pvt. Ltd)
18, F-8/3, Main Margalla Road,
Islamabad, Pakistan
Voice: 111-101-101*780
Fax: 92-051-2255989
Email: [EMAIL PROTECTED]
Web: www.lmkr.com
rem ---
rem Filename: smtp.sql
rem Purpose:Send e-mail messages from PL/SQL
rem Notes: From Oracle8i release 8.1.6 one can send e-mail messages
rem directly from PL/SQL using either the UTL_TCP or UTL_SMTP
rem packages. No pipes or external procedures required.
rem Date: 27-Mar-2000
rem Author: Frank Naude ([EMAIL PROTECTED])
rem ---
CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_fromvarchar2 := 'oracle',
msg_to varchar2,
msg_subject varchar2 := 'E-Mail message from your database',
msg_textvarchar2 := '' )
IS
c utl_tcp.connection;
rc integer;
BEGIN
c := utl_tcp.open_connection('192.168.1.1', 25); -- open the SMTP
port 25 on local machine
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'HELO 192.168.1.1');
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'MAIL FROM: '||msg_from);
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'RCPT TO: '||msg_to);
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'DATA'); -- Start message
body
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'Subject: '||msg_subject);
rc := utl_tcp.write_line(c, '');
rc := utl_tcp.write_line(c, msg_text);
rc := utl_tcp.write_line(c, '.');-- End of message
body
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'QUIT');
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
utl_tcp.close_connection(c); -- Close the
connection
EXCEPTION
when others then
raise_application_error(-2,'Unable to send e-mail message from
pl/sql');
END;
/
show errors
-- Examples:
set serveroutput on
exec send_mail(msg_to ='Omar Khalid/IT/LotusCert/Pk');
exec send_mail(msg_to ='[EMAIL PROTECTED]');
exec send_mail(msg_to ='[EMAIL PROTECTED]',
msg_text='Look Ma I can send mail from plsql');
Oracle DBA
acur8dba@yaho To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
o.com cc:
Sent by: Subject: How to send email
from pl/sql in 806?
[EMAIL PROTECTED]
om
05/23/2001
11:35 AM
Please respond
to ORACLE-L
Hi,
I am aware that 817 supports UTL_SMTP for this same
functionality. But how can one send email from pl/sql
in 806?
thanx
=
Vicky D. Foster,
Senior Oracle DBA:
email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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
QUERRY DOUBT..
hi all, i've a querry that is to find out what all columns have constraints applied on them. giving the table_name,column_name,constraint name and constraint type. the querry goes like.. select a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom user_tables a,user_constraints b,user_cons_columns cwhere a.table_name=b.table_name andb.constraint_name=c.constraint_name/ now i need to make a report which gives out in the same result all the tables' columns which have constraints and which have not, both. leaving the constraint_type and constraint name columns null in the same querry. is it possible, or do we have other alternative to do that. pls suggest. thanks saurabh
Re: Odd core dump - possibly listener related
--core dump ended up in $ORACLE_HOME/dbs i think there is no space in the destination where u r storing the dumps... just one point to have a look atmay or may not be correct RB Deshpande, Kirti wrote: Hi Lisa, Yes, we have seen this occasional core dump in the ?/dbs dir. Tried to chase it down, gave up on OWS and TAR got closed. The last time it happened was a month or so ago on HP-UX 11.0 and 8.1.6.2. As you said, there are many other things to worry about. If your 'mini-me' chases this down, I would like to know. BTW... How does he like Oracle's new music selection? Congratulations for getting another job !! Going further South or back to North? Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Subject: Odd core dump - possibly listener related Hello all, My mini-me (aka Junior DBA) noticed a core dump this morning. Good, attention to detail. However, there's no unusual errors in the alert log for either databases on this host and there's no errors in the listener log at all. The core dump says something about pseudo cursor and references a port that isn't dedicated to the listener. Here's my take on it: The database is fine. The listener is fine. The app is fine. With nothing in the logs I have no idea where to look. I don't even know how this core dump ended up in $ORACLE_HOME/dbs (the default), my core_dump_dest is set to a different directory. Searching on metalink returns nothing. Mini-me (mini? 6'4) wants to chase this down. I think it works, don't fix it. The occasional core dump is normal and there are a ton of other things to attend to. Does anyone disagree? So my question is, has anyone seen this before? we are hp/ux 11.0, 8.1.6.2 Thanks everyone, and au revoir. I start a new job on Tuesday. Lisa Rutland Koivu Oracle Database Administrator?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess -- 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: rupali belsare INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to unsubscribe ?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: QUERRY DOUBT..
Try this: select d.owner, d.table_name,b.constraint_name,b.constraint_type,d.column_namefrom all_tables a,all_constraints b,all_cons_columns c, all_tab_columns dwhere d.owner = c.owner (+)and d.table_name = c.table_name (+)and d.column_name = c.column_name (+)and c.table_name = a.table_name (+)and c.table_name = b.table_name (+)and c.constraint_name = b.constraint_name(+)and c.owner = a.owner (+)and c.owner = b.owner (+)order by d.owner, d.table_name, d.column_id; HTH Linda -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 12:46 AMTo: Multiple recipients of list ORACLE-LSubject: QUERRY DOUBT.. hi all, i've a querry that is to find out what all columns have constraints applied on them. giving the table_name,column_name,constraint name and constraint type. the querry goes like.. select a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom user_tables a,user_constraints b,user_cons_columns cwhere a.table_name=b.table_name andb.constraint_name=c.constraint_name/ now i need to make a report which gives out in the same result all the tables' columns which have constraints and which have not, both. leaving the constraint_type and constraint name columns null in the same querry. is it possible, or do we have other alternative to do that. pls suggest. thanks saurabh
Re: Exporting and Importing table statistics
i feel this is at the full database export level. once u export ur database, u can import it as it is into another database and it'll create allthe required definitions for u. the statistics are exported with the tablespace and table definitions. hope i'm sure. if not pls correct. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 25, 2001 3:48 AM Hi all, According to the 8i utilities manual I should be able to export a tables' statistics from one database, then import those statistics into another database. I have tried various combinations of export and import scripts but nothing seems to work. My table has none of the restrictions described in the utilities manual that would prevent the statistics from being exported and then imported. Can this export/import of statistics be done at a single table level or does it have to be a full database export? If not at the table level can it be done at the schema level? Thanks everyone, Gary Bonner [EMAIL PROTECTED] -- 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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ULIMIT Problem continues: Please Help
Hello every one, I have got this major problem on my hands. I am trying to install Oracle 8.05.0 on SCO Unixware 7.1.0. Now, I am stuck in trying to install Oracle, the error says:- ULIMIT is not as high as 2113674. In order to install Oracle, my ULIMIT needs to be 2113674. The problem is that I have set the ULIMIT=500, in the /etc/default/login file. Further when I telnet from an outside system and then do ulimit, it says I have, -3388608, but when I am on the system itself, then I get the value as 2097152. Further, when I try to install from the outside system(by outside system I mean a unix machine in out network), I get the File Size Exceeded message and my termnial freezes. Please help with the above problem, as to how I can increase my ulimit, and move ahead with the installation. Thanks and Regards, Raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [OT] Jobs in UK
Diana, That sounds way too high for Scotland, although the odd contract like that does appear from time to time. There was a couple of contracts like that where I live (Newcastle Upon Tyne,about 110 miles south of Edinburgh) but they were for experienced Oracle Apps DBAs. To make that sort of cash, I think you may have to be contracting in London. I think the norm regionally is anywhere between 45-75 an hour, but I would like to hear from any other UK based people if I've got that wrong. I am unsure as to how easy it is for foreign nationals to get employment over here although there do seem to be a fair few. I certainly don't think we are as strict as the U.S for example. I quite fancied a stint over there (or Canada - Vancouver to be precise) but keep getting put off by the Green Card thing and the fact that I am not University educated. Worked my way up from junior programmer in Cobol etc etc etc Anyway, there are no spare jobs in the UK AT ALL.:-) Lee (Oracle DBA in the UK who likes the apparent shortage as I am always getting calls to improve my situation !!). -Original Message- Sent: 24 May 2001 21:24 To: Multiple recipients of list ORACLE-L My husband is Scottish, and he heard from a Scottish pal of his that top Oracle consultants can earn up to ?1000 a day in Edinburgh! Made me want to up and go, I'll tell you...then again, having a husband with a British passport means I can work without too many problems. Regards, Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] antonio.belloni@hst ern.com.br To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Fax to: Subject: [OT] Jobs in UK 05/24/2001 02:57 PM Please respond to ORACLE-L Hi fellows, Sorry for the offtopic but I had been in UK last week and my friends from there told me that there is a shortage of IT professionals and , that if you really got the skills , is very easy to migrate and find a job. But none of my friends are IT professionals and I don´t know how much they know from this market. So I wish to know , if possible , from the IT professionals working in UK if it is really easy to find a job and migrate ? What are the governamental restrictions ? How much we can earn in a year of work ? Where I can find more information about immigration to UK ? TIA, Antonio Belloni -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
Re: How to send email from pl/sql in 806?
Saurabh Sharma wrote:
HI,
i tried creating this procedure. but it results into compilation errors.
says..
utl_tcp.connection must be declared, and so does for
utl_tcp.get_line and
utl_tcp.write_line
how do we fefine them. where is this package utl_tcp
pls explore.
thanks.
Simple.
Its in %ORACLE_BASE%\Ora81\rdbms\admin\
where you're find utltcp.sql and utlsmtp.sql, and lots of other
goodies.
It would not be included with an Oracle 8.0.x distribution.
8.1.6 goes off support 31-OCT-2001 - go straight to 8.1.7.1.x.
Paul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 11:05 AM
try this procedure it works just replace the IP address in the line
c := utl_tcp.open_connection('192.168.1.1', 25);
with the IP address of u'r mail server
regards
__
Omar Khalid
Software Engineer
LMKResources
--
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: SQL PROBLEM
Title: MS access Can you try this: select count (1) from ( select1 from table_ a where ord_id =17 union select 1 from table_b where ord_id = 17) / Hi, Favour me insuggest ahint in writing a sql forfollowing scenaio: Table A has 2 columns ord_id and line_id example rows are: ord_id line_id 17 null null42 TableB has columns ord_id and line_id ord_id line_id 17 42 17 43 1744 I have to write a sql to count(*) from table A where ord_id=17 .. as u see from table B line 42 is row of ord_id=17 ..so i want count(*) should show =2 from tabel A but if i do count(*) from table A where ord_id=17..it shows 1.. i need to put another condition which will check line id with TABLE B and if it is for this particular order ...add that also in count(*). I know scenario is little fuzzy sorry for it..but if u got my point kindly respond. Thanks Harvinder
RE: [OT] Jobs in UK
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. I suppose it depends what top means and how many days you want to work. I am sure it is possible to earn £1000/day as an Oracle Consultant but that will be for only 1 or 2 days work at a site and there are not many sites prepared to offer that sort of rate. Also Edingburgh or Scotland in general does not pay as much for Oracle DBA skills as you can earn in London (although it is a lot nicer place in my opinion). Currently there is a bit of a mini recession in the contracting market and jobs are at a premium (I know because I am looking at the moment). . General rates for a good (3-5 years experience 7-8I etc) are between £45-55 / hour with maybe £60 in London. (pounds not dollars, in case the symbol does not translate in the mail system). John John Hallas *+44 (0) 115 945 6643 * +44 (0) 115 945 6774 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 21:24 To: Multiple recipients of list ORACLE-L Subject:Re: [OT] Jobs in UK My husband is Scottish, and he heard from a Scottish pal of his that top Oracle consultants can earn up to ?1000 a day in Edinburgh! Made me want to up and go, I'll tell you...then again, having a husband with a British passport means I can work without too many problems. Regards, Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] antonio.belloni@hst ern.com.br To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Fax to: Subject: [OT] Jobs in UK 05/24/2001 02:57 PM Please respond to ORACLE-L Hi fellows, Sorry for the offtopic but I had been in UK last week and my friends from there told me that there is a shortage of IT professionals and , that if you really got the skills , is very easy to migrate and find a job. But none of my friends are IT professionals and I don´t know how much they know from this market. So I wish to know , if possible , from the IT professionals working in UK if it is really easy to find a job and migrate ? What are the governamental restrictions ? How much we can earn in a year of work ? Where I can find more information about immigration to UK ? TIA, Antonio Belloni -- 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
RE: How to send email from pl/sql in 806?
hi sharma
The builtin packages UTL_SMTP and UTL_TCP are available with oracle 8.1.5
onwards , thats the reason you were getting compilation errors.
Ramana
--
From: Saurabh Sharma[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: How to send email from pl/sql in 806?
HI,
i tried creating this procedure. but it results into compilation errors.
says..
utl_tcp.connection must be declared, and so does for
utl_tcp.get_line and
utl_tcp.write_line
how do we fefine them. where is this package utl_tcp
pls explore.
thanks.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 11:05 AM
try this procedure it works just replace the IP address in the line
c := utl_tcp.open_connection('192.168.1.1', 25);
with the IP address of u'r mail server
regards
__
Omar Khalid
Software Engineer
LMKResources
A LANDMARK AFFILIATE
(Formerly Mathtech Pakistan Pvt. Ltd)
18, F-8/3, Main Margalla Road,
Islamabad, Pakistan
Voice: 111-101-101*780
Fax: 92-051-2255989
Email: [EMAIL PROTECTED]
Web: www.lmkr.com
rem
---
rem Filename: smtp.sql
rem Purpose:Send e-mail messages from PL/SQL
rem Notes: From Oracle8i release 8.1.6 one can send e-mail messages
rem directly from PL/SQL using either the UTL_TCP or UTL_SMTP
rem packages. No pipes or external procedures required.
rem Date: 27-Mar-2000
rem Author: Frank Naude ([EMAIL PROTECTED])
rem
---
CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_fromvarchar2 := 'oracle',
msg_to varchar2,
msg_subject varchar2 := 'E-Mail message from your database',
msg_textvarchar2 := '' )
IS
c utl_tcp.connection;
rc integer;
BEGIN
c := utl_tcp.open_connection('192.168.1.1', 25); -- open the
SMTP
port 25 on local machine
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'HELO 192.168.1.1');
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'MAIL FROM: '||msg_from);
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'RCPT TO: '||msg_to);
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'DATA'); -- Start message
body
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'Subject: '||msg_subject);
rc := utl_tcp.write_line(c, '');
rc := utl_tcp.write_line(c, msg_text);
rc := utl_tcp.write_line(c, '.');-- End of message
body
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'QUIT');
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
utl_tcp.close_connection(c); -- Close the
connection
EXCEPTION
when others then
raise_application_error(-2,'Unable to send e-mail message
from
pl/sql');
END;
/
show errors
-- Examples:
set serveroutput on
exec send_mail(msg_to ='Omar Khalid/IT/LotusCert/Pk');
exec send_mail(msg_to ='[EMAIL PROTECTED]');
exec send_mail(msg_to ='[EMAIL PROTECTED]',
msg_text='Look Ma I can send mail from plsql');
Oracle DBA
acur8dba@yaho To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
o.com cc:
Sent by: Subject: How to send email
from pl/sql in 806?
[EMAIL PROTECTED]
om
05/23/2001
11:35 AM
Please respond
to ORACLE-L
Hi,
I am aware that 817 supports UTL_SMTP for this same
functionality. But how can one send email from pl/sql
in 806?
thanx
=
Vicky D. Foster,
Senior Oracle DBA:
email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or
Re: how to unsubscribe ?
have u read any email on this list? if you had you would have known it. To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).-- On Thu, 24 May 2001 23:16:24 Andy wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [OT] Jobs in UK
Alex. There have been more taxes and restrictions applied to UK IT contractors in the last year or so prompting more people than usual to move outside the UK for work. This has prompted the UK to grant more visas to non British IT workers. I don't know about the qualifications or details for gaining UK working visa status, try searching the web for UK passport agency ,visa etc.. I've worked in the US and UK and, as always, job availability dramatically varies on actual location. However there is still a demand for quality IT experience, including Oracle DBAs. The main (only in my opinion) site is www.jobserve.com Have fun. - Mike. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 19:58 To: Multiple recipients of list ORACLE-L Hi fellows, Sorry for the offtopic but I had been in UK last week and my friends from there told me that there is a shortage of IT professionals and , that if you really got the skills , is very easy to migrate and find a job. But none of my friends are IT professionals and I don´t know how much they know from this market. So I wish to know , if possible , from the IT professionals working in UK if it is really easy to find a job and migrate ? What are the governamental restrictions ? How much we can earn in a year of work ? Where I can find more information about immigration to UK ? TIA, Antonio Belloni -- 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: Jenner 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).
RE: SQL PROBLEM
Title: MS access Ido not seem to have exactlyunderstood u r problem..but try this anyway select count(*) from awhere l_id in (selectb.bl_idfroma,bwherea.o_id = 17anda.o_id = b.bo_id )OR(a.o_id = 17) COUNT(*)-- 2 1 row selected. The table data is as listed below SQL select * from a; O_ID L_ID -- -- 17NULLNULL 42 2 rows selected. SQL select * from b; BO_ID BL_ID-- -- 17 42 17 43 17 44 3 rows selected. Regards, Karthik Mohan TCS Consultant at GEP (HK) DialComm 3310962 ISD : 852-26290962 -Original Message-From: Niyi Olajide [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 4:36 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SQL PROBLEM Can you try this: select count (1) from ( select1 from table_ a where ord_id =17 union select 1 from table_b where ord_id = 17) / Hi, Favour me insuggest ahint in writing a sql forfollowing scenaio: Table A has 2 columns ord_id and line_id example rows are: ord_id line_id 17 null null42 TableB has columns ord_id and line_id ord_id line_id 17 42 17 43 1744 I have to write a sql to count(*) from table A where ord_id=17 .. as u see from table B line 42 is row of ord_id=17 ..so i want count(*) should show =2 from tabel A but if i do count(*) from table A where ord_id=17..it shows 1.. i need to put another condition which will check line id with TABLE B and if it is for this particular order ...add that also in count(*). I know scenario is little fuzzy sorry for it..but if u got my point kindly respond. Thanks Harvinder
RE: Steve Adam's Removal
Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From: Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject: RE: Steve Adam's Removal Henry, List I second you on this one. I respect Henry being the list owner, having authority to do as he pleases. ORACLE -L is possibly the best Oracle list out there,and has brought so many Oracle professionals together, but lets not lose our experts. Please reconsider the removal of Steve Adams from the list. He takes up lots of his time to answer performance related questions posted by list members with precise actions to be taken and great explanations. He is an invaluable member to the Oracle world and his expertise, generosity will surely be missed if he removed. Kind Regards and pls reconsider Suhen List, While I respect Henry's authority as list owner to remove people from the list, and the need to do so when people are breaking the rules, I would like to protest the removal of Steve Adams. He is one of the top experts in Oracle internals in the world, and he was gracious enough to take time to answer people's questions on the list. I am not sure what he ever did that was thought to be spamming, except answer people's questions. He has a link to his website in his signature, and often his answers were links to a place on his site where he had already answered that question. I don't see what's wrong with that, none of it seems to violate the rules of the list. If it was a matter of one or two people complaining about Steve's posts, perhaps the list should have been asked. I can only hope that the overwhelming majority understood Steve's method of answering questions and were not annoyed with it. The show now knows a lot less about Oracle Internal Services. Reed Sutton -Original Message- From: Henry O'Keeffe [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 8:58 AM To: LazyDBA.com Discussion Subject: Re: Spamming the list I'm afraid, you'll actually have to leave the list Steve. Picking lines from private emails sent between us, and presenting them out of context isn't something that most people would have expected from you. I'm sorry that it's had to come to this. Indeed, the show will go on. Goodbye. Henry. Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
SQL PROBLEM for duplicate rows..
Hi Table A got some duplicated rows.. The requirement is to delete the duplicate records by maintaing one copy.. Is it manageable thru single query? or have to go for PL/SQL procedure? Pl. send me ur valuable inputs. Saravanakumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N. SARAVANA KUMAR INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Steve Adam's Removal
Erm... am I missing something but wasn't the original mail removing Steve Adams from the lazydba discussion list and not this one ?? Cheers Lee -Original Message- Sent: 25 May 2001 10:56 To: Multiple recipients of list ORACLE-L Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From: Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject: RE: Steve Adam's Removal Henry, List I second you on this one. I respect Henry being the list owner, having authority to do as he pleases. ORACLE -L is possibly the best Oracle list out there,and has brought so many Oracle professionals together, but lets not lose our experts. Please reconsider the removal of Steve Adams from the list. He takes up lots of his time to answer performance related questions posted by list members with precise actions to be taken and great explanations. He is an invaluable member to the Oracle world and his expertise, generosity will surely be missed if he removed. Kind Regards and pls reconsider Suhen List, While I respect Henry's authority as list owner to remove people from the list, and the need to do so when people are breaking the rules, I would like to protest the removal of Steve Adams. He is one of the top experts in Oracle internals in the world, and he was gracious enough to take time to answer people's questions on the list. I am not sure what he ever did that was thought to be spamming, except answer people's questions. He has a link to his website in his signature, and often his answers were links to a place on his site where he had already answered that question. I don't see what's wrong with that, none of it seems to violate the rules of the list. If it was a matter of one or two people complaining about Steve's posts, perhaps the list should have been asked. I can only hope that the overwhelming majority understood Steve's method of answering questions and were not annoyed with it. The show now knows a lot less about Oracle Internal Services. Reed Sutton -Original Message- From: Henry O'Keeffe [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 8:58 AM To: LazyDBA.com Discussion Subject: Re: Spamming the list I'm afraid, you'll actually have to leave the list Steve. Picking lines from private emails sent between us, and presenting them out of context isn't something that most people would have expected from you. I'm sorry that it's had to come to this. Indeed, the show will go on. Goodbye. Henry. Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
Re: SQL PROBLEM for duplicate rows..
I think this query eliminates the duplicated rows: delete from table_name where rowid not in (select maxrowid from (select column1,column2, max(rowid) maxrowid from den group by column1,column2)); - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 25, 2001 1:01 PM Hi Table A got some duplicated rows.. The requirement is to delete the duplicate records by maintaing one copy.. Is it manageable thru single query? or have to go for PL/SQL procedure? Pl. send me ur valuable inputs. Saravanakumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N. SARAVANA KUMAR INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: =?iso-8859-1?B?QnVy52luINxzdPxuIEv9bP3n?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: hosting forums
Hello, do you know an organization supplies web-forums hosting. I'll launch my FQA page, but I don't want to deal with setup/backup etc. thanks... *** Unal Bilisim http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ok two databases..two machines..one database name
Paul, why are you sorry? You CAN have two databases with the same database name on different machines. Differing passwords is a good idea, I should have thought of it. I would NOT however, name the tnsnames.ora entries the same name on the two machines, that's another way to help prevent problems. From: Paul Drake [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Ok two databases..two machines..one database name Date: Thu, 24 May 2001 21:20:21 -0800 Rachel Carmichael wrote: short answer: yes you can From: Steve McClure [EMAIL PROTECTED] My question is can I have databases with the same name running simultaneously on two different machines if I make sure the tnsnames for each database points to it's own server? The database is 7.3.4. As soon as I send this off I am going to create a small DB just to test this out, but your input, as usual, is appreciated. Thanks, Steve McClure Well, on 7.3.4 I guess that there wasn't a service_name, so this isn't that helpful: Use the service_name : schema in your sql prompt - and - more importantly - use unique passwords on each database. Very helpful when you're brain dead to prevent you from having to test your recovery skills in an unscheduled setting. Sorry Rachel. :) Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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: Steve Adam's Removal
you're right -- Henry isn't the list owner here in any case. For those of you who want to discuss this, Henry set up a discussion forum on the lazydba site. AFAIK, Steve is still a member of Oracle-L :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Steve Adam's Removal Date: Fri, 25 May 2001 02:16:06 -0800 Erm... am I missing something but wasn't the original mail removing Steve Adams from the lazydba discussion list and not this one ?? Cheers Lee -Original Message- Sent: 25 May 2001 10:56 To: Multiple recipients of list ORACLE-L Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From: Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject:RE: Steve Adam's Removal Henry, List I second you on this one. I respect Henry being the list owner, having authority to do as he pleases. ORACLE -L is possibly the best Oracle list out there,and has brought so many Oracle professionals together, but lets not lose our experts. Please reconsider the removal of Steve Adams from the list. He takes up lots of his time to answer performance related questions posted by list members with precise actions to be taken and great explanations. He is an invaluable member to the Oracle world and his expertise, generosity will surely be missed if he removed. Kind Regards and pls reconsider Suhen List, While I respect Henry's authority as list owner to remove people from the list, and the need to do so when people are breaking the rules, I would like to protest the removal of Steve Adams. He is one of the top experts in Oracle internals in the world, and he was gracious enough to take time to answer people's questions on the list. I am not sure what he ever did that was thought to be spamming, except answer people's questions. He has a link to his website in his signature, and often his answers were links to a place on his site where he had already answered that question. I don't see what's wrong with that, none of it seems to violate the rules of the list. If it was a matter of one or two people complaining about Steve's posts, perhaps the list should have been asked. I can only hope that the overwhelming majority understood Steve's method of answering questions and were not annoyed with it. The show now knows a lot less about Oracle Internal Services. Reed Sutton -Original Message- From: Henry O'Keeffe [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 8:58 AM To: LazyDBA.com Discussion Subject: Re: Spamming the list I'm afraid, you'll actually have to leave the list Steve. Picking lines from private emails sent between us, and presenting them out of context isn't something that most people would have expected from you. I'm sorry that it's had to come to this. Indeed, the show will go on. Goodbye. Henry. Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED]
RE:
Title: RE: Hi , When trying to exceute a PL/SQL program which reads data from a file into a record (using utlfile) , I get an error as listed below ORA-04030: out of process memory when trying to allocate 8208 bytes (PLS non-lib hp,PL/SQL STACK) ORA-07324: smpall: malloc error while allocating pga. HP-UX Error: 12: Not enough space Any ideas on what the problem is Regards, Karthik Mohan TCS Consultant at GEP (HK) DialComm 3310962 ISD : 852-26290962 Please see the official ORACLE-L FAQ: http://www.orafaq.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL PROBLEM for duplicate rows..
I am sorry I made a mistake in naming . Correct one is below: delete from table_name where rowid not in (select maxrowid from (select column1,column2, max(rowid) maxrowid from table_name group by column1,column2)); - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 25, 2001 1:22 PM I think this query eliminates the duplicated rows: delete from table_name where rowid not in (select maxrowid from (select column1,column2, max(rowid) maxrowid from den group by column1,column2)); - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 25, 2001 1:01 PM Hi Table A got some duplicated rows.. The requirement is to delete the duplicate records by maintaing one copy.. Is it manageable thru single query? or have to go for PL/SQL procedure? Pl. send me ur valuable inputs. Saravanakumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N. SARAVANA KUMAR INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: =?iso-8859-1?B?QnVy52luINxzdPxuIEv9bP3n?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: =?iso-8859-1?B?QnVy52luINxzdPxuIEv9bP3n?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL PROBLEM for duplicate rows..
Yes, It works .. Thanks.. On Fri, 25 May 2001, [iso-8859-1] Burçin Üstün Kýlýç wrote: I think this query eliminates the duplicated rows: delete from table_name where rowid not in (select maxrowid from (select column1,column2, max(rowid) maxrowid from den group by column1,column2)); - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 25, 2001 1:01 PM Hi Table A got some duplicated rows.. The requirement is to delete the duplicate records by maintaing one copy.. Is it manageable thru single query? or have to go for PL/SQL procedure? Pl. send me ur valuable inputs. Saravanakumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N. SARAVANA KUMAR INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: =?iso-8859-1?B?QnVy52luINxzdPxuIEv9bP3n?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: N. SARAVANA KUMAR INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ok two databases..two machines..one database name
When we do this (alongwith giving different passwords), we differentiate in tnsnames by using the server_sid type idea eg, SERVER1_TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT = 1521)) (CONNECT_DATA = (SID = TEST) ) ) SERVER2_TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER2)(PORT = 1521)) (CONNECT_DATA = (SID = TEST) ) ) Therefore when we need to connect it would use the differing connect strings. Regards Lee -Original Message- Sent: 25 May 2001 12:11 To: Multiple recipients of list ORACLE-L Paul, why are you sorry? You CAN have two databases with the same database name on different machines. Differing passwords is a good idea, I should have thought of it. I would NOT however, name the tnsnames.ora entries the same name on the two machines, that's another way to help prevent problems. From: Paul Drake [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Ok two databases..two machines..one database name Date: Thu, 24 May 2001 21:20:21 -0800 Rachel Carmichael wrote: short answer: yes you can From: Steve McClure [EMAIL PROTECTED] My question is can I have databases with the same name running simultaneously on two different machines if I make sure the tnsnames for each database points to it's own server? The database is 7.3.4. As soon as I send this off I am going to create a small DB just to test this out, but your input, as usual, is appreciated. Thanks, Steve McClure Well, on 7.3.4 I guess that there wasn't a service_name, so this isn't that helpful: Use the service_name : schema in your sql prompt - and - more importantly - use unique passwords on each database. Very helpful when you're brain dead to prevent you from having to test your recovery skills in an unscheduled setting. Sorry Rachel. :) Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to send email from pl/sql in 806?
hi,
i've oracle 8.1.5 on NT. but could'nt find the utltcp.sql , infact it had
the procedure utl_http
could it help?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 1:56 PM
hi sharma
The builtin packages UTL_SMTP and UTL_TCP are available with oracle 8.1.5
onwards , thats the reason you were getting compilation errors.
Ramana
--
From: Saurabh Sharma[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, May 25, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: How to send email from pl/sql in 806?
HI,
i tried creating this procedure. but it results into compilation
errors.
says..
utl_tcp.connection must be declared, and so does for
utl_tcp.get_line and
utl_tcp.write_line
how do we fefine them. where is this package utl_tcp
pls explore.
thanks.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 11:05 AM
try this procedure it works just replace the IP address in the line
c := utl_tcp.open_connection('192.168.1.1', 25);
with the IP address of u'r mail server
regards
__
Omar Khalid
Software Engineer
LMKResources
A LANDMARK AFFILIATE
(Formerly Mathtech Pakistan Pvt. Ltd)
18, F-8/3, Main Margalla Road,
Islamabad, Pakistan
Voice: 111-101-101*780
Fax: 92-051-2255989
Email: [EMAIL PROTECTED]
Web: www.lmkr.com
rem
---
rem Filename: smtp.sql
rem Purpose:Send e-mail messages from PL/SQL
rem Notes: From Oracle8i release 8.1.6 one can send e-mail
messages
rem directly from PL/SQL using either the UTL_TCP or UTL_SMTP
rem packages. No pipes or external procedures required.
rem Date: 27-Mar-2000
rem Author: Frank Naude ([EMAIL PROTECTED])
rem
---
CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_fromvarchar2 := 'oracle',
msg_to varchar2,
msg_subject varchar2 := 'E-Mail message from your database',
msg_textvarchar2 := '' )
IS
c utl_tcp.connection;
rc integer;
BEGIN
c := utl_tcp.open_connection('192.168.1.1', 25); -- open the
SMTP
port 25 on local machine
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'HELO 192.168.1.1');
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'MAIL FROM: '||msg_from);
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'RCPT TO: '||msg_to);
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'DATA'); -- Start
message
body
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'Subject: '||msg_subject);
rc := utl_tcp.write_line(c, '');
rc := utl_tcp.write_line(c, msg_text);
rc := utl_tcp.write_line(c, '.');-- End of
message
body
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'QUIT');
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
utl_tcp.close_connection(c); -- Close the
connection
EXCEPTION
when others then
raise_application_error(-2,'Unable to send e-mail message
from
pl/sql');
END;
/
show errors
-- Examples:
set serveroutput on
exec send_mail(msg_to ='Omar Khalid/IT/LotusCert/Pk');
exec send_mail(msg_to ='[EMAIL PROTECTED]');
exec send_mail(msg_to ='[EMAIL PROTECTED]',
msg_text='Look Ma I can send mail from plsql');
Oracle DBA
acur8dba@yaho To: Multiple recipients
of
list ORACLE-L [EMAIL PROTECTED]
o.com cc:
Sent by: Subject: How to send
email
from pl/sql in 806?
[EMAIL PROTECTED]
om
05/23/2001
11:35 AM
Please respond
to ORACLE-L
Hi,
I am aware that 817 supports UTL_SMTP for this same
functionality. But how can one send email from pl/sql
in 806?
thanx
=
Vicky D. Foster,
Senior Oracle DBA:
email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services--
Re: QUERRY DOUBT..
THANKS A LOT, Seley the querry works absolutely fine. instead i've created a view. which can be easier to querry. and it also let me able to devise way for finding each individuals' report. thanks again. saurabh sharma - Original Message - From: Seley, Linda To: Multiple recipients of list ORACLE-L Sent: Friday, May 25, 2001 1:51 PM Subject: RE: QUERRY DOUBT.. Try this: select d.owner, d.table_name,b.constraint_name,b.constraint_type,d.column_namefrom all_tables a,all_constraints b,all_cons_columns c, all_tab_columns dwhere d.owner = c.owner (+)and d.table_name = c.table_name (+)and d.column_name = c.column_name (+)and c.table_name = a.table_name (+)and c.table_name = b.table_name (+)and c.constraint_name = b.constraint_name(+)and c.owner = a.owner (+)and c.owner = b.owner (+)order by d.owner, d.table_name, d.column_id; HTH Linda -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 12:46 AMTo: Multiple recipients of list ORACLE-LSubject: QUERRY DOUBT.. hi all, i've a querry that is to find out what all columns have constraints applied on them. giving the table_name,column_name,constraint name and constraint type. the querry goes like.. select a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom user_tables a,user_constraints b,user_cons_columns cwhere a.table_name=b.table_name andb.constraint_name=c.constraint_name/ now i need to make a report which gives out in the same result all the tables' columns which have constraints and which have not, both. leaving the constraint_type and constraint name columns null in the same querry. is it possible, or do we have other alternative to do that. pls suggest. thanks saurabh
RE: Ok two databases..two machines..one database name
We have two 804 db's with same sid running on two different machines. One is production and another is development. Our TNSNAMES contain machine_name + sid. This way we identify which db we are connecting. Initially I had lot of problems getting OEM recognize these two db's. When I called up Oracle support, they said that I cannot have two db's with same sid and global name and OEM agent would not recognize. Essentially, they washed off their hands clean. Then, I played around with the intelligent agent file and finally OEM started recognizing the two db's. ONE CAUTION: Keep your archived redo's stored separately and come up with a plan on identifying which tape belongs to what machine. Passwords, yes, be careful. Rao -Original Message- Sent: Thursday, May 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L I have been tasked with moving a production database to a 'backup' machine. I ran my plan past you a week or so ago. Essentially I will put the DB in backup mode, copy the datafiles, shutdown, copy redo and control files, then recover on the second machine. So far plain vanilla. I understand the above procedure enough to have actually thought of it. My problem now is this. I need to test this instance on the 'backup' machine before we actually do the move. This is Just to make sure the application is completely in order. One of the developers is telling me that having the two databases up and running with the same SID, even on separate machines MAY cause trouble for the production instance. I believe that if I make sure the tnsnames.ora file for both servers points to their own local instances, that I will not have a problem. The clients will only access the database pointed to in their tnsnames files, so I am confident we are ok there. My question is can I have databases with the same name running simultaneously on two different machines if I make sure the tnsnames for each database points to it's own server? The database is 7.3.4. As soon as I send this off I am going to create a small DB just to test this out, but your input, as usual, is appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Full user export
Hi DBA's What is the proper syntax of the exp command to get export of all objects owned by a user - tables, views, stored procedures, synonyms, grants. And will the import require special parameters too? I have a small development database on Windows NT and would like to create a copy on Windows Me running Personal Oracle for Win 98. When I duplicated the database to anotehr Windows NT machine it was simple - copy all datafiles, mount the database, update control files, etc. But here I have different operating systems so can not simply copy files. Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to send email from pl/sql in 806?
hi saurabh
nops utl_http will not help it's a different procedure
here is the code in utltcp.sql file
hope it solves u'r problem
__
Omar Khalid
Software Engineer
LMKResources
A LANDMARK AFFILIATE
(Formerly Mathtech Pakistan Pvt. Ltd)
18, F-8/3, Main Margalla Road,
Islamabad, Pakistan
Voice: 111-101-101*780
Fax: 92-051-2255989
Email: [EMAIL PROTECTED]
Web: www.lmkr.com
REM Copyright (c) 1999 by Oracle Corporation.
REM
REM NAME
REMutltcp.sql - PL/SQL Package for TCP/IP communication
REM (Package Specification of UTL_TCP)
REM
REM DESCRIPTION
REMRoutines to perform TCP/IP communication.
REM
REM NOTES
REMThe procedural option is needed to use this package.
REMThis package must be created under SYS.
REM
REM MODIFIED (MM/DD/YY)
REM jmuller 09/16/99 - Fix bug 708690: final pass
REM rpang 08/11/99 - Added constants for error codes
REM rpang 07/28/99 - Added BAD_ARGUMENT exception
REM rpang 05/14/99 - Created
CREATE OR REPLACE PACKAGE utl_tcp AS
/***
* OVERVIEW
*
* This package provides TCP/IP client-side access functionality in
PL/SQL.
* With this package, a PL/SQL program can communicate with external
TCP/IP
* services and retrieve data. The API only allows connections to be
* initiated by the PL/SQL program. It does not allow the PL/SQL program
* to accept connections initiated from outside of the program.
*
* USES
*
* A TCP/IP connection is initiated by a call to open_connection, which
* returns a TCP/IP connection. Text and binary data can be sent or
* received on the connection. It is also possible to look ahead at the
* data before it is actually read. The connection is terminated by
* a call to close_connection.
*
* EXAMPLES
* Retrieve the home page from http://www.acme.com/
*
* DECLARE
* c utl_tcp.connection; -- TCP/IP connection to the Web server
* BEGIN
* c := utl_tcp.open_connection('www.acme.com', 80); -- open
connection
*
* utl_tcp.write_line(c, 'GET / HTTP/1.0'); -- send HTTP
request
* utl_tcp.write_line(c);
* BEGIN
* LOOP
* dbms_output.put_line(utl_tcp.get_line(c, TRUE)); -- read
result
* END LOOP;
* EXCEPTION
* WHEN utl_tcp.end_of_input THEN
* NULL; -- end of input
* END;
* utl_tcp.close_connection(c);
* END;
*/
/*
* TCP connection type
*/
TYPE connection IS RECORD (
remote_host VARCHAR2(255), -- Remote host name
remote_port PLS_INTEGER, -- Remote port number
local_hostVARCHAR2(255), -- Local host name
local_portPLS_INTEGER, -- Local port number
charset VARCHAR2(30),-- Character set for on-the-wire comm.
newline VARCHAR2(2), -- Newline character sequence
private_sdPLS_INTEGER, -- For internal use only
private_bfRAW(32767), -- For internal use only
private_bfsz PLS_INTEGER, -- For internal use only
private_pos PLS_INTEGER, -- For internal use only
private_end PLS_INTEGER, -- For internal use only
private_mkpos PLS_INTEGER -- For internal use only
);
/*
* Carriage-return line-feed character sequence.
*/
CRLF CONSTANT VARCHAR2(10) := chr(13) || chr(10);
/*
* Exceptions
*/
buffer_too_small EXCEPTION; -- Buffer is too small for I/O
end_of_input EXCEPTION; -- End of input from the connection
network_error EXCEPTION; -- Network error
bad_argument EXCEPTION; -- Bad argument passed in API call
buffer_too_small_errcode CONSTANT PLS_INTEGER:= -2;
end_of_input_errcode CONSTANT PLS_INTEGER:= -20001;
network_error_errcodeCONSTANT PLS_INTEGER:= -20002;
bad_argument_errcode CONSTANT PLS_INTEGER:= -20003;
PRAGMA EXCEPTION_INIT(buffer_too_small, -2);
PRAGMA EXCEPTION_INIT(end_of_input, -20001);
PRAGMA EXCEPTION_INIT(network_error,-20002);
PRAGMA EXCEPTION_INIT(bad_argument, -20003);
/**
* Opens a connection to a TCP/IP service. When connection is made
* succesfully, the remote host name and remote port number will be
stored in
* the connection. If local_host, local_port or charset is specified,
* it will be stored in the connection as well.
*
* PARAMETERS
* remote_host remote host name to connect to
* remote_port remote port number to connect to
* local_host local host name to connect from
* local_port local port number to connect from
* in_buffer_size input buffer size
* out_buffer_size output buffer size
* charset character set for
Re: OT: Winnie quote
On Thu, 24 May 2001,Campbell, James scribbled on the wall in glitter crayon: -If you live to be a hundred, I want to live to be a hundred minus one -day,so I never have to live without you. -- Winnie the Pooh - -Dear me, Bill, where on earth did you get that from? I think I can hear -A.A. Milne revolving in his grave. off the web somewhere, and yes i am aware it's not the real pooh having all the pooh books from christopher robin milne himself. but i like it anyway.;-) and i always was a contrary person. just ask the Goddess.;-) -- 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. ~~ From C:\*.* to shining C:\*.* -- 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: BUNYAMIN POSTS HAVE A VIRUS
Title: RE: BUNYAMIN POSTS HAVE A VIRUS Didn't he send an email to the list yesterday apologizing for this and stated that he had no idea it was happening? Laura -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 9:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: BUNYAMIN POSTS HAVE A VIRUS Well, I sent him an email about this last night, and no reply yet. Or was it this morning? Anyway, it was dark. :) I guess he gets unsubscribed now. :( Jared
Hot Backup Temp Data Files
hi DBA's All the hot backup scripts that i have seen on the web do not backup the temp datafiles ( files in sys.dba_temp_files ). While their contents may be irrelevent for recovery operations, are'nt the files (identical in path, name size ) required to be created if lost. Regards, Joseph Raj Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Database Down
Title: Another Database Down snip Just to put you a little more in the picture I have recovered a couple of DBs now without archived redo log files etc where all hope had been lost and resumes were being updated and got them back by fudging a couple of issues. (Oracle would probably throw their hands up in horror and refuse to support what I did, but the database opened, I didn't lose any data (this I believe was down to good fortune rather than skill) and everyone was happy. (snip Lee snip Lee, I am just glad someone has responded and wants to help! I am not sure how much I told you about my situation, so bear with me while I recite it to you. Our OS is Windows NT. We had 2 disks to crash. Two of my databases are ok because I had archive logs for one and a cold backup for the other. However, I have one that I have not done anything too as far as backup, other than a physical backup of the database datafiles, redo logs, etc. The Sysadm had a full backup of the previous Friday and a differential backup from the following Thursday which he loaded back to the server when the new disks were installed. I tried to recover the database and when it asked for the logs I entered cancel. It said that recovery was successful but gave me a warning that if I tried to open the database with the Resetlogs option it would tell me that my system datafile was too incomplete (or something to that affect). Yesterday (Thursday) I did call Oracle and this is what this first guy had me do: 1) Startup Mount 2) Select from v$datafile to check the status of my datafiles. They were all online, which per Support, that was not good. 3) Alter database datafile ??? offline. This command gave me the error 'offline immediate disallowed unless media recovery enabled (ORA 01145). So then I was referred to another Support person. He had me shutdown the database, startup mount, recover database. Of course the recover asked for a log and Support had me input each of my five redo logs, but the log with the info needed had already been overwritten so the info wasn't there and I didn't get any further. Next Support wanted me to restore my files from the Friday backup only. This is where I have stopped because now I am waiting on my Sysadm to come in and restore them for me. I tried to call the Support guy back and let him know the status, but got a message stating that because I had only 'basic or bronze' support that I could only speak to someone between certain hours, and then was cut off. I had gone through Metalink though so I just updated the tar. If you have any ideas for me I would appreciate any and all. Thanks, Laura
RE: FTP process exceeds ulimit as oracle user
John - Thank you! I refreshed the inetd and it works. [EMAIL PROTECTED] 05/24/01 03:11PM Hi Gene, However, when FTP'ing using the oracle user id, it aborts at 1gb. I guessed the ftp daemon used some other user id for this. Wrong ( well maybe). I changed the default limits to unlimited for all users (i.e. default) and deleted the oracle user id from /etc/security/limits file. Same problem, ftp process dies at 1gb. Now, I am trying to get the file rather than putting it. Lets see if this works? Your workaround is correct. The reason why this errored out before is this : Root on the remote server receives a signal via inetd and starts up an 'ftpd' daemon under it's own account to serve you when you 'put' a file. This is configured in the /etc/inetd.conf file (diff path in AIX) by the following line: ftp tli tcp nowait root/usr/etc/ftpd ftpd $ ps -ef | grep ftpd root 28825 923 0 07:07:08 ? 0:00 ftpd --- this does the job on the remote server oracle 28917 686 0 07:07:44 ttyAF/AFFL 0:00 grep ftpd When 'root' started out, the inetd process which triggers the start of the ftpd inherits the previous limit of 1gb and hence you had this problem. To solve this permanently, you will need to run the command 'refresh -s inetd' as 'root' on AIX which restarts the inetd daemon. Hth, (Hope this helps!) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Winnie quote
Speaking of the Goddess, which Winnie the Pooh character does she correspond to? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:37 AM To: Multiple recipients of list ORACLE-L Subject:Re: OT: Winnie quote On Thu, 24 May 2001,Campbell, James scribbled on the wall in glitter crayon: -If you live to be a hundred, I want to live to be a hundred minus one -day,so I never have to live without you. -- Winnie the Pooh - -Dear me, Bill, where on earth did you get that from? I think I can hear -A.A. Milne revolving in his grave. off the web somewhere, and yes i am aware it's not the real pooh having all the pooh books from christopher robin milne himself. but i like it anyway.;-) and i always was a contrary person. just ask the Goddess.;-) -- 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. ~~ From C:\*.* to shining C:\*.* -- 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: Steve Adam's Removal
I guess the lazy DBAs got tired of reading Oracle Internals. They just want simple answers. :) Richard Ji [EMAIL PROTECTED] 05/25/01 07:15AM you're right -- Henry isn't the list owner here in any case. For those of you who want to discuss this, Henry set up a discussion forum on the lazydba site. AFAIK, Steve is still a member of Oracle-L :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Steve Adam's Removal Date: Fri, 25 May 2001 02:16:06 -0800 Erm... am I missing something but wasn't the original mail removing Steve Adams from the lazydba discussion list and not this one ?? Cheers Lee -Original Message- Sent: 25 May 2001 10:56 To: Multiple recipients of list ORACLE-L Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From: Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject:RE: Steve Adam's Removal Henry, List I second you on this one. I respect Henry being the list owner, having authority to do as he pleases. ORACLE -L is possibly the best Oracle list out there,and has brought so many Oracle professionals together, but lets not lose our experts. Please reconsider the removal of Steve Adams from the list. He takes up lots of his time to answer performance related questions posted by list members with precise actions to be taken and great explanations. He is an invaluable member to the Oracle world and his expertise, generosity will surely be missed if he removed. Kind Regards and pls reconsider Suhen List, While I respect Henry's authority as list owner to remove people from the list, and the need to do so when people are breaking the rules, I would like to protest the removal of Steve Adams. He is one of the top experts in Oracle internals in the world, and he was gracious enough to take time to answer people's questions on the list. I am not sure what he ever did that was thought to be spamming, except answer people's questions. He has a link to his website in his signature, and often his answers were links to a place on his site where he had already answered that question. I don't see what's wrong with that, none of it seems to violate the rules of the list. If it was a matter of one or two people complaining about Steve's posts, perhaps the list should have been asked. I can only hope that the overwhelming majority understood Steve's method of answering questions and were not annoyed with it. The show now knows a lot less about Oracle Internal Services. Reed Sutton -Original Message- From: Henry O'Keeffe [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 8:58 AM To: LazyDBA.com Discussion Subject: Re: Spamming the list I'm afraid, you'll actually have to leave the list Steve. Picking lines from private emails sent between us, and presenting them out of context isn't something that most people would have expected from you. I'm sorry that it's had to come to this. Indeed, the show will go on. Goodbye. Henry. Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these
RE: BUNYAMIN POSTS HAVE A VIRUS
Yes, he did. And, AFAIK he fixed the problem. I haven't received any more virused messages from his system (Not from HIM they were sent without his knowledge). Rodd Holman Original Message dated 5/25/01, 8:51:44 AM Author: Burton, Laura L. [EMAIL PROTECTED] Re: RE: BUNYAMIN POSTS HAVE A VIRUS: Didn't he send an email to the list yesterday apologizing for this and stated that he had no idea it was happening? Laura -Original Message- Sent: Thursday, May 24, 2001 9:10 PM To: Multiple recipients of list ORACLE-L Well, I sent him an email about this last night, and no reply yet. Or was it this morning? Anyway, it was dark. :) I guess he gets unsubscribed now. :( Jared --=_4D4800808CFC090CAA90 Content-Description: filename=text1.html Content-Type: text/html Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=CONTENT-TYPE CONTENT=text/html; charset=iso-8859-1 TITLERE: BUNYAMIN POSTS HAVE A VIRUS/TITLE META NAME=GENERATOR CONTENT=StarOffice/5.2 (Linux) META NAME=CREATED CONTENT=20010525;8352400 META NAME=CHANGEDBY CONTENT=Rodd Holman META NAME=CHANGED CONTENT=20010525;8424700 /HEAD BODY PYes, he did. And, AFAIK he fixed the problem. I haven't received any more virused messages from his system (Not from HIM they were sent without his knowledge)./P PRodd Holman/P HR P STYLE=margin-bottom: 0inOriginal Message dated 5/25/01, 8:51:44 AM/P P STYLE=margin-bottom: 0inAuthor: quot;Burton,quot; Laura quot;L.quot; lt;[EMAIL PROTECTED]gt;/P P STYLE=margin-bottom: 0inRe: RE: BUNYAMIN POSTS HAVE A VIRUS:/P HR PBRBR /P PFONT SIZE=2Didn't he send an email to the list yesterday apologizing for this and stated that he had no idea it was happening?/FONT /P PFONT SIZE=2Laura/FONT /P PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: Jared Still [A HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=2Sent: Thursday, May 24, 2001 9:10 PM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: Re: BUNYAMIN POSTS HAVE A VIRUS/FONT /P PBRBR /P PFONT SIZE=2Well, I sent him an email about this last night, and no/FONT BRFONT SIZE=2reply yet./FONT /P PFONT SIZE=2Or was it this morning?nbsp; Anyway, it was dark.nbsp; :)/FONT /P PFONT SIZE=2I guess he gets unsubscribed now.nbsp; :(/FONT /P PFONT SIZE=2Jared/FONT /P PBRBR /P /BODY /HTML --=_4D4800808CFC090CAA90-- -- 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: Full user export
exp owner=username file=user.dmp imp full=y file=user.dmp Use additional options with exp and imp as desired. For a complete list of options use 'exp help=y' and 'imp help=y'. Detail information is available in the Oracle Utilities Guide. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 8:16 AM To: Multiple recipients of list ORACLE-L Subject: Full user export Hi DBA's What is the proper syntax of the exp command to get export of all objects owned by a user - tables, views, stored procedures, synonyms, grants. And will the import require special parameters too? I have a small development database on Windows NT and would like to create a copy on Windows Me running Personal Oracle for Win 98. When I duplicated the database to anotehr Windows NT machine it was simple - copy all datafiles, mount the database, update control files, etc. But here I have different operating systems so can not simply copy files. Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Database Down
Laura, I fight this nearly every damn day. We constantly refresh several SAP systems from production copies via EMC BCV's and TimeFinder. About half of the time, I get the same error, where recovery was successful, but open resetlogs would fail. It turns out, in my case, that no amount of recovery will every get this database open (even with resetlogs) with this backup set. Apparently there is an issue with a piece of the EMC software that causes problems when mirrors are split during a hot backup. To make a long story short, there is an event you can set in via a server manager session that will dump all datafile headers. What you look for is what Oracle calls a fuzzy SCN. That is, an SCN hex value that evaluates to a non- sensical number. In English, the SCN for the header should have some hex value that corresponds to a number. If it is set to something like FFx, then you have a fuzzy SCN which means your backup is bad and will never work. I don't know if this is your exact problem or not, but since you're getting the same symptoms I was, I thought I would throw it out there. You can read more on MetaLink by searching for fuzzy SCN. By the way, as soon as our RS/6000 SA upgraded our version of PowerPath, the bug went away, we have consistent mirror splits, and all is well on the SAP backup/restore front... Sorry if I threw you way off on a tangent on this one. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) snip Just to put you a little more in the picture I have recovered a couple of DBs now without archived redo log files etc where all hope had been lost and resumes were being updated and got them back by fudging a couple of issues. (Oracle would probably throw their hands up in horror and refuse to support what I did, but the database opened, I didn't lose any data (this I believe was down to good fortune rather than skill) and everyone was happy. (snip Lee snip Lee, I am just glad someone has responded and wants to help! I am not sure how much I told you about my situation, so bear with me while I recite it to you. Our OS is Windows NT. We had 2 disks to crash. Two of my databases are ok because I had archive logs for one and a cold backup for the other. However, I have one that I have not done anything too as far as backup, other than a physical backup of the database datafiles, redo logs, etc. The Sysadm had a full backup of the previous Friday and a differential backup from the following Thursday which he loaded back to the server when the new disks were installed. I tried to recover the database and when it asked for the logs I entered cancel. It said that recovery was successful but gave me a warning that if I tried to open the database with the Resetlogs option it would tell me that my system datafile was too incomplete (or something to that affect). Yesterday (Thursday) I did call Oracle and this is what this first guy had me do: 1) Startup Mount2) Select from v$datafile to check the status of my datafiles. They were all online, which per Support, that was not good. 3) Alter database datafile ??? offline. This command gave me the error 'offline immediate disallowed unless media recovery enabled (ORA 01145). So then I was referred to another Support person. He had me shutdown the database, startup mount, recover database. Of course the recover asked for a log and Support had me input each of my five redo logs, but the log with the info needed had already been overwritten so the info wasn't there and I didn't get any further. Next Support wanted me to restore my files from the Friday backup only. This is where I have stopped because now I am waiting on my Sysadm to come in and restore them for me. I tried to call the Support guy back and let him know the status, but got a message stating that because I had only 'basic or bronze' support that I could only speak to someone between certain hours, and then was cut off. I had gone through Metalink though so I just updated the tar. If you have any ideas for me I would appreciate any and all. Thanks, Laura -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,
New member
Hello, Just wanted to introduce myself before posting to the list. I look forward to interacting with you guys/ladies on the list. Have a great Friday! Chuck Speaks, MCSE Database Administrator Lithonia Lighting 770-922-9000 x3450 http://www.lithonia.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Speaks, Chuck W. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: was about a virus now a song ...
-Original Message- Sent: Friday, May 25, 2001 10:41 AM To: Multiple recipients of list ORACLE-L BUNYAMIN POSTS HAD A VIRUS EEE - III - EEE - III - O TGIF !! Happy Weekend everyone... Raj *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Full user export
At the OS level give the following command. exp owner=user name Now, the program will ask you the username. This time either give a user name who has dba priviliger or give the same user name you mentioned in the above command (exp owner=username) If you had given the dba user name, then while importing you need to import the file into that specific user using the dba user name. hth Rao -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 9:16 AM To: Multiple recipients of list ORACLE-L Hi DBA's What is the proper syntax of the exp command to get export of all objects owned by a user - tables, views, stored procedures, synonyms, grants. And will the import require special parameters too? I have a small development database on Windows NT and would like to create a copy on Windows Me running Personal Oracle for Win 98. When I duplicated the database to anotehr Windows NT machine it was simple - copy all datafiles, mount the database, update control files, etc. But here I have different operating systems so can not simply copy files. Thanks Witold -- 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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Steve Adam's Removal
Yeah, amoung the complaints I saw against me where. 1. I plugged my website (which I make no money, and provided for the benefit for others) 2. Two my emails were too long (I obviously spent too much time answering) 3. Someone would come back and there would be 30 emails from me (Obviously I answered too many questions) 4. I would just say i agree at times (I guess backing up someone's comment and basically saying I couldn't said it better and I would only repeat his answer to strengthen it). This is all after I left from hearing about Henry's plot. Now someone on this list has already posted someone on the board saying I am only plugging my site, yet I have answered around 30 questions in less than 3 days. Granted I try to get people to look at my site so they may find something to help them. Shame on me. The funniest thing is there is 1500 or so list members on the other list, 30-50 of them post answers, 1450-1470 just post questions. I have yet to see the 30-50 of the complain about the same issues or much of anything. People don't understand it takes time to answer these emails and we have better things to do. We do this because we want to help people, with all the barage of crap from people, it makes you want to just not bother. As such, my site will be unavailable due to it's helpful nature. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, May 25, 2001 10:17 AM To: Multiple recipients of list ORACLE-L I guess the lazy DBAs got tired of reading Oracle Internals. They just want simple answers. :) Richard Ji [EMAIL PROTECTED] 05/25/01 07:15AM you're right -- Henry isn't the list owner here in any case. For those of you who want to discuss this, Henry set up a discussion forum on the lazydba site. AFAIK, Steve is still a member of Oracle-L :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Steve Adam's Removal Date: Fri, 25 May 2001 02:16:06 -0800 Erm... am I missing something but wasn't the original mail removing Steve Adams from the lazydba discussion list and not this one ?? Cheers Lee -Original Message- Sent: 25 May 2001 10:56 To: Multiple recipients of list ORACLE-L Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From: Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject:RE: Steve Adam's Removal Henry, List I second you on this one. I respect Henry being the list owner, having authority to do as he pleases. ORACLE -L is possibly the best Oracle list out there,and has brought so many Oracle professionals together, but lets not lose our experts. Please reconsider the removal of Steve Adams from the list. He takes up lots of his time to answer performance related questions posted by list members with precise actions to be taken and great explanations. He is an invaluable member to the Oracle world and his expertise, generosity will surely be missed if he removed. Kind Regards and pls reconsider Suhen List, While I respect Henry's authority as list owner to remove people from the list, and the need to do so when people are breaking the rules, I would like to protest the removal of Steve Adams. He is one of the top experts in Oracle internals in the world, and he was gracious enough to take time to answer people's questions on the list. I am not sure what he ever did that was thought to be spamming, except answer people's questions. He has a link to his website in his signature, and often his answers were links to a place on his site where he had already answered that question. I don't see what's wrong with that, none of it seems to violate the rules of the list. If it was a matter of one or two people complaining about Steve's posts, perhaps the
Re[2]: Ok two databases..two machines..one database name
Rachel, I love that nice short answer. But I'll take the LONG road, if you please. Steve, The SID has nothing to do with the database outside of the physical bounds of the computer your running it on. Over here I'm still running with a very OLD way of setting up SIDs that came up through V5. Back then with SQL*Net V1 Oracle recommended setting your SIDs to something that was case insensitive. The reason is that the connect string back then was T:hostname:sid so a SID of 'PROD' was different than 'prod' and it could become troublesome to explain it all the time. Well the only thing I can think of that are totally case insensitive are numbers. Consequently whenever we set up a new machine the first instance thereon was designated '02'. Fifteen machines later the strategy still works, makes sense to those of us configuring Oracle Names, and the users could care less. So just as long tnsnames or Oracle Names points to the right database with the right name, your all right. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 5/24/2001 5:10 PM short answer: yes you can From: Steve McClure [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Ok two databases..two machines..one database name Date: Thu, 24 May 2001 16:40:50 -0800 I have been tasked with moving a production database to a 'backup' machine. I ran my plan past you a week or so ago. Essentially I will put the DB in backup mode, copy the datafiles, shutdown, copy redo and control files, then recover on the second machine. So far plain vanilla. I understand the above procedure enough to have actually thought of it. My problem now is this. I need to test this instance on the 'backup' machine before we actually do the move. This is Just to make sure the application is completely in order. One of the developers is telling me that having the two databases up and running with the same SID, even on separate machines MAY cause trouble for the production instance. I believe that if I make sure the tnsnames.ora file for both servers points to their own local instances, that I will not have a problem. The clients will only access the database pointed to in their tnsnames files, so I am confident we are ok there. My question is can I have databases with the same name running simultaneously on two different machines if I make sure the tnsnames for each database points to it's own server? The database is 7.3.4. As soon as I send this off I am going to create a small DB just to test this out, but your input, as usual, is appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: was about a virus now a song ...
get help !! -Original Message- Sent: 25 May 2001 16:01 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Friday, May 25, 2001 10:41 AM To: Multiple recipients of list ORACLE-L BUNYAMIN POSTS HAD A VIRUS EEE - III - EEE - III - O TGIF !! Happy Weekend everyone... Raj *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener.log....writing to renamed file
Title: RE: Listener.logwriting to renamed file Thanks all. Very clear and it works. rgds, Li -Original Message- From: Reardon, Bruce (CALBBAY) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 11:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file On NT, if you don't want to lose any listener.log entries and you want to keep using the same logfile name then you will need to use set log_file twice. Also, under NT (at least with 815 and 817) don't specify an extension for the log file - it automatically gets .log appended. For example (something like the following untested code): lsnrctl set log_file temp1 ren listener.log listener_tmp.log lsnrctl set log_file listener copy /b listener_tmp.log + temp1.log listener-date.log del listener_tmp.log del temp1.log You could put the date into the archived listener log using the for command to process output of date/t and time/t. Note that using set log_file requires the listener password to be entered. This can be automated under NT by using something like: rem create the temp file echo set password %lnrpwd% %lnrstart_file% echo stop %1 %lnrstart_file% echo exit %lnrstart_file% echo. %lnrstart_file% rem feed it into lsnrctl lsnrctl %lnrstart_file% Regards, Bruce -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, 25 May 2001 5:53 To: Multiple recipients of list ORACLE-L Issue the SET LOG_FILE command using lsnrctl, then move/delete/whatever the old file. -Original Message- Sent: Thursday, May 24, 2001 1:58 PM To: ORACLE-L; Xiangli.Li May I know how to clear the content of listener.log without restart listener on NT platform ? thanks. Li -Original Message- From: Brian MacLean [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/ksh cat listener.log listener.log.hist ex listener.log EOF 1,$d wq EOF Or if you wish to purge 90% of the file: #!/bin/ksh wc -l listener.log | read v_lines junk v_keep=$(($(($v_lines * 10)) / 100)) v_purge=$(($v_lines - $v_keep)) ex listener.log EOF 1,$v_purged wq EOF -Original Message- Sent: Thursday, May 24, 2001 7:15 AM To: Multiple recipients of list ORACLE-L On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List, -As a regular maintainance work,I have moved the listener.log file to -listener.log.old -and 'touch'ed the listener.log, expecting the logging into this new file. -But I am observing the logging being done to listener.log.old, instead. -I could not recall any such previous experience. -FYI, I cannot do any 'experiments' as far as this system is concerned as I -have to deal with -desupported HP-UX(10.01), Oracle (7.2.2.3). -I have my logging being done to default path($ORACLE_HOME/network/log), as -no parameter settings in listener.ora. -Has anybody experienced this? - -TIA, - -Suren -Oracle DBA -Sony Electronics Ltd. - - The file handle listener is using is still pointed at the old file. To fix this you need to stop and start the listener. This will not affect anybody who is already connected. I'm not sure if a reload will do the same thing. -- 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. ~~ No program done by an undergrad will work after she graduates. -- 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: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
RE: Full user export
Welcome to [EMAIL PROTECTED] hahahaha :) your dba Salman Faheem --- Deshpande, Kirti [EMAIL PROTECTED] wrote: exp owner=username file=user.dmp imp full=y file=user.dmp Use additional options with exp and imp as desired. For a complete list of options use 'exp help=y' and 'imp help=y'. Detail information is available in the Oracle Utilities Guide. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 8:16 AM To: Multiple recipients of list ORACLE-L Subject:Full user export Hi DBA's What is the proper syntax of the exp command to get export of all objects owned by a user - tables, views, stored procedures, synonyms, grants. And will the import require special parameters too? I have a small development database on Windows NT and would like to create a copy on Windows Me running Personal Oracle for Win 98. When I duplicated the database to anotehr Windows NT machine it was simple - copy all datafiles, mount the database, update control files, etc. But here I have different operating systems so can not simply copy files. Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Salman Faheem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 RE: was about a virus now a song ...
ROFL!!! These two posts were funny as hell! || -Original Message- || From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 11:26 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: was about a virus now a song ... || || || get help !! || || || || -Original Message- || Sent: 25 May 2001 16:01 || To: Multiple recipients of list ORACLE-L || || || -Original Message- || Sent: Friday, May 25, 2001 10:41 AM || To: Multiple recipients of list ORACLE-L || || || BUNYAMIN POSTS HAD A VIRUS || EEE - III - EEE - III - O || || || TGIF !! || Happy Weekend everyone... || Raj || || || * || 4 || || This e-mail message is confidential, intended only for the named || recipient(s) above and may contain information that is || privileged, attorney || work product or exempt from disclosure under applicable law. || If you have || received this message in error, or are not the named || recipient(s), please || immediately notify corporate MIS at (860) 766-2000 and || delete this e-mail || message from your computer, Thank you. || || * || 4 || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jamadagni, Rajendra || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || || The information contained in this communication is || confidential, is intended only for the use of the recipient || named above, and may be legally privileged. If the reader || of this message is not the intended recipient, you are || hereby notified that any dissemination, distribution or || copying of this communication is strictly prohibited. || If you have received this communication in error, please || re-send this communication to the sender and delete the || original message or any copy of it from your computer || system. || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Robertson Lee - lerobe || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Winnie quote
that's easy! I'm Eeyore. sometimes maybe I'm Christopher Robin, but I'm not really sure about that From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Winnie quote Date: Fri, 25 May 2001 06:00:31 -0800 Speaking of the Goddess, which Winnie the Pooh character does she correspond to? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:37 AM To: Multiple recipients of list ORACLE-L Subject:Re: OT: Winnie quote On Thu, 24 May 2001,Campbell, James scribbled on the wall in glitter crayon: -If you live to be a hundred, I want to live to be a hundred minus one -day,so I never have to live without you. -- Winnie the Pooh - -Dear me, Bill, where on earth did you get that from? I think I can hear -A.A. Milne revolving in his grave. off the web somewhere, and yes i am aware it's not the real pooh having all the pooh books from christopher robin milne himself. but i like it anyway.;-) and i always was a contrary person. just ask the Goddess.;-) -- 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. ~~ From C:\*.* to shining C:\*.* -- 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). _ 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: Steve Adam's Removal
Christopher You have a nice site, why take it off. If 30 people complain, they have an option not to click on the link. For every good thing there will be a lot of bad things. I just feel sad that we lost a good resource on the net. Please bring it back. A request to everyone ... a mere mention of a website doesn't mean that someone is pushing for a product, if you don't like it, don't visit the site. Everyone has the choice ... why complain? It is same as using the delete key for unwanted email. On a lighter note, how many of us feel compelled to send an email every time they see an email address? Oh Well ... I'll go hide now ... the Politically Correct police is already in the lobby ... and the only thing I can say is ' AM I STUPID? ' Just my thoughts ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Again Recovery
Hi Friends I want to test recovery on my AIX test box, Iam planning full recovery from Y'day night backup including Operating system. Next scenario is only Database recovery by restoring datafiles!! Could you shed some light on both scenarios, steps and precautions to take. I appreciate your comments very much. I have oracle version7.3 and AIX4.3 TIA Raghu. _ 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: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 member
Welcome, Chuck. Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. Welcome to a List where politics and recipes are posted with equal fervor as SQL Tuning tips. The water's fine! || -Original Message- || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 11:07 AM || To: Multiple recipients of list ORACLE-L || Subject: New member || || || Hello, || || Just wanted to introduce myself before posting to the list. || I look forward || to interacting with you guys/ladies on the list. Have a || great Friday! || || Chuck Speaks, MCSE || Database Administrator || Lithonia Lighting || 770-922-9000 x3450 || http://www.lithonia.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Speaks, Chuck W. || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ULIMIT Problem continues: Please Help
Hi Raja, Try setting ' ulimit -f unlimited' in the profile file for oracle user id before starting the installer. You may have to enable the large file support, if not already done. A casual search for 'How to set ulimit on Unixware?' on http://www.google.com found this link http://www.sco.com/developer/core9/migpth9.htm. Let us know if that helps you out. Else, I suggest a call to SCO Support. HTH.. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Viraj Luthra [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 3:11 AM To: Multiple recipients of list ORACLE-L Subject: ULIMIT Problem continues: Please Help Hello every one, I have got this major problem on my hands. I am trying to install Oracle 8.05.0 on SCO Unixware 7.1.0. Now, I am stuck in trying to install Oracle, the error says:- ULIMIT is not as high as 2113674. In order to install Oracle, my ULIMIT needs to be 2113674. The problem is that I have set the ULIMIT=500, in the /etc/default/login file. Further when I telnet from an outside system and then do ulimit, it says I have, -3388608, but when I am on the system itself, then I get the value as 2097152. Further, when I try to install from the outside system(by outside system I mean a unix machine in out network), I get the File Size Exceeded message and my termnial freezes. Please help with the above problem, as to how I can increase my ulimit, and move ahead with the installation. Thanks and Regards, Raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Fire your DBA's you don't need them anymore...
Title: Fire your DBA's you don't need them anymore... My boss just received a cold call from Oracle that he let me listen in on. They have a new push on for their i-dba support package. For just a little more money (they did not define little), we will replace your dba's with our superior support team that will monitor your database 24x7 and proactively eliminate problems. This will allow you to redesign you office to offload these cumbersome DBA tasks and allow your workers to do other things. You will never have another database problem. I felt good when my boss indicated that we had no base problems but based on this, I guess we will have to become sqlserver DBAs or gasp developers... :) Ahh, Friday, wonderful Friday, it seems like you've been away all week... --Chris [EMAIL PROTECTED]
RE: Full user export
Welcome? Gee!! ... Thanks... I thought I have been here for the past several years !! - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Salman Faheem [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:32 AM To: Multiple recipients of list ORACLE-L Subject: RE: Full user export Welcome to [EMAIL PROTECTED] hahahaha :) your dba Salman Faheem --- Deshpande, Kirti [EMAIL PROTECTED] wrote: exp owner=username file=user.dmp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Winnie quote
At 04:55 PM 5/24/01 -0800, you wrote: That 'quote' isn't from Pooh at all, it's probably from Walt @#$$^^@! Disney. The REAL Pooh is much wiser than that cheap greetings-card stuff! Oh, bother. Dennis Taylor BIDIRECTIONAL: A type of printer or tape drive able to wrench the medium from both the right- and left-hand reels simultaneously. -- 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: Steve Adam's Removal
I agree with Raj; and, yes, I am one of those 1450 who lurk on the list, not contributing much. I'm still learning Oracle, and am in awe of those on the list with so much knowledge! I've been a DBA for many years (IMS and DB2 before learning Oracle), and I've learned that you never know when you're going to need a resource. We all have delete keys, and hopefully know how to use them! -Original Message- Sent: Friday, May 25, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Christopher You have a nice site, why take it off. If 30 people complain, they have an option not to click on the link. For every good thing there will be a lot of bad things. I just feel sad that we lost a good resource on the net. Please bring it back. A request to everyone ... a mere mention of a website doesn't mean that someone is pushing for a product, if you don't like it, don't visit the site. Everyone has the choice ... why complain? It is same as using the delete key for unwanted email. On a lighter note, how many of us feel compelled to send an email every time they see an email address? Oh Well ... I'll go hide now ... the Politically Correct police is already in the lobby ... and the only thing I can say is ' AM I STUPID? ' Just my thoughts ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peddycoart, Judy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: Winnie quote
I'm out for some department beers tonight and then on to a casino till the wee small hours. By tomorrow, I will be Eyesore -Original Message- Sent: 25 May 2001 16:43 To: Multiple recipients of list ORACLE-L that's easy! I'm Eeyore. sometimes maybe I'm Christopher Robin, but I'm not really sure about that From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Winnie quote Date: Fri, 25 May 2001 06:00:31 -0800 Speaking of the Goddess, which Winnie the Pooh character does she correspond to? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:37 AM To: Multiple recipients of list ORACLE-L Subject:Re: OT: Winnie quote On Thu, 24 May 2001,Campbell, James scribbled on the wall in glitter crayon: -If you live to be a hundred, I want to live to be a hundred minus one -day,so I never have to live without you. -- Winnie the Pooh - -Dear me, Bill, where on earth did you get that from? I think I can hear -A.A. Milne revolving in his grave. off the web somewhere, and yes i am aware it's not the real pooh having all the pooh books from christopher robin milne himself. but i like it anyway.;-) and i always was a contrary person. just ask the Goddess.;-) -- 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. ~~ From C:\*.* to shining C:\*.* -- 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). _ 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Standby vs. Adv. Replication (Multi-master)
Hi, I'm looking for feedback on setting up a high-availability architecture for our production database. In a nutshell, we are a 24-hour shop and I need to be able to keep a secondary database (failover) in sync with the primary in case the primary fails. I have supported advanced replication (asynchronous) in the past but it was a single master relationship not multi-master. I'm leaning towards a standby database setup because my experience with advanced replication is less than favorable if/when transactions get out of sync. Also, one of the tables contains a LONG RAW. This column may go away or may be converted to a CLOB in the very near future but still needs to be kept in consideration when selecting a solution. The platform is Sun (SunOS 5.7) with 8.1.6. The secondary machine and database will most likely be located in another state. The database is small right now (~10Gb) and will continue to grow, but not too fast. What are your opinions? Is there an obvious choice between the two alternatives? Is there another alternative that I should be considering? Thanks VERY much in advance. -w __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Winnie quote
nah, Tigger bounces and has only a small brain... and he's ALWAYS happy From: Thater, William [EMAIL PROTECTED] To: Rachel Carmichael [EMAIL PROTECTED] CC: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Winnie quote Date: Fri, 25 May 2001 11:09:25 -0400 On Fri, 25 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -that's easy! I'm Eeyore. - -sometimes maybe I'm Christopher Robin, but I'm not really sure about that i think of you more as Tiggeresqe. -- 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. ~~ From C:\*.* to shining C:\*.* _ 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: Steve Adam's Removal
What is the purpose of subscibing to Lazydba list at all?. I subscribed sometime ago and in several months unsubscribed. There are only couple of people who know what they are talking about and a lot of them on this list. Number of cluless questions tremendows etc. Again, my impressions from about a year ago. But I think nothing changed. However it would be intersting to read selected lines from Henry's e-mails which Steve picked up and and what was main Steve's sin. Of cource mentioning his website in his e-mail it is something uconsionable and unprovoked :-) Why would anybody do it when they already have www.lazydba.com - I don't understand it. Alex Hillman -Original Message- Sent: Friday, May 25, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Yeah, amoung the complaints I saw against me where. 1. I plugged my website (which I make no money, and provided for the benefit for others) 2. Two my emails were too long (I obviously spent too much time answering) 3. Someone would come back and there would be 30 emails from me (Obviously I answered too many questions) 4. I would just say i agree at times (I guess backing up someone's comment and basically saying I couldn't said it better and I would only repeat his answer to strengthen it). This is all after I left from hearing about Henry's plot. Now someone on this list has already posted someone on the board saying I am only plugging my site, yet I have answered around 30 questions in less than 3 days. Granted I try to get people to look at my site so they may find something to help them. Shame on me. The funniest thing is there is 1500 or so list members on the other list, 30-50 of them post answers, 1450-1470 just post questions. I have yet to see the 30-50 of the complain about the same issues or much of anything. People don't understand it takes time to answer these emails and we have better things to do. We do this because we want to help people, with all the barage of crap from people, it makes you want to just not bother. As such, my site will be unavailable due to it's helpful nature. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, May 25, 2001 10:17 AM To: Multiple recipients of list ORACLE-L I guess the lazy DBAs got tired of reading Oracle Internals. They just want simple answers. :) Richard Ji [EMAIL PROTECTED] 05/25/01 07:15AM you're right -- Henry isn't the list owner here in any case. For those of you who want to discuss this, Henry set up a discussion forum on the lazydba site. AFAIK, Steve is still a member of Oracle-L :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Steve Adam's Removal Date: Fri, 25 May 2001 02:16:06 -0800 Erm... am I missing something but wasn't the original mail removing Steve Adams from the lazydba discussion list and not this one ?? Cheers Lee -Original Message- Sent: 25 May 2001 10:56 To: Multiple recipients of list ORACLE-L Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From: Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject:RE: Steve Adam's Removal Henry, List I second you on this one. I respect Henry being the list owner, having authority to do as he pleases. ORACLE -L is possibly the best Oracle list out there,and has brought so many Oracle professionals together, but lets not lose our experts. Please reconsider the removal of Steve Adams from the list. He takes up lots of his time to answer performance related questions posted by list members with precise actions to be taken and great explanations. He is an invaluable member to the Oracle world and his expertise, generosity will surely be missed if he removed. Kind Regards and pls reconsider Suhen List, While I
RE: OT: Winnie quote
On Fri, 25 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -that's easy! I'm Eeyore. - -sometimes maybe I'm Christopher Robin, but I'm not really sure about that i think of you more as Tiggeresqe. -- 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. ~~ From C:\*.* to shining C:\*.* -- 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: New member
Sounds great. I am a Lazy DBA refugee and I must say that I like the tone and banter on this list a lot better. I'll be talking to you guys soon. It's good to see familiar names like Chris Spence and Steve Adams, for they are outlaws on other sites. REAL TROUBLEMAKERS! Chuck Speaks, MCSE Database Administrator Lithonia Lighting 770-922-9000 x3450 http://www.lithonia.com -Original Message- Sent: Friday, May 25, 2001 11:43 AM To: Multiple recipients of list ORACLE-L Welcome, Chuck. Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. Welcome to a List where politics and recipes are posted with equal fervor as SQL Tuning tips. The water's fine! || -Original Message- || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 11:07 AM || To: Multiple recipients of list ORACLE-L || Subject: New member || || || Hello, || || Just wanted to introduce myself before posting to the list. || I look forward || to interacting with you guys/ladies on the list. Have a || great Friday! || || Chuck Speaks, MCSE || Database Administrator || Lithonia Lighting || 770-922-9000 x3450 || http://www.lithonia.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Speaks, Chuck W. || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Speaks, Chuck W. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sessions are waiting on buffer busy wait with P3 value 130 in v$s
Hi Sri, If you can identify the segments involved from the p1 and p2 parameters and put those segments into a KEEP buffer pool you should be able to get a lot of relief. Failing that, or if they are too big, consider either increasing db_block_buffers if you can or setting _db_percent_hot_default to something like 80. That would allow up to 80% of the DEFAULT buffer pool to be used for hot buffers thereby improving the caching of the buffers that are causing you to wait. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 25 May 2001 9:26 To: Multiple recipients of list ORACLE-L v$s We've lot buffer busy waits in data block with P3 value 130 in V$session. I've read about this in few notes, but still I do not understand few things. P3=130 means: - Block is being read by another session and no other suitable block image was found, so we wait until the read is completed. This may also occur after a buffer cache assumed deadlock. The kernel can't get a buffer in a certain amount of time and assumes a deadlock. Therefore it will read the CR version of the block. Does it mean that the block is being held in an incompatible mode by the first session or set of sessions reading it in shared mode, and current session is trying to lock it exclusively for a DML and waiting for the same. What are steps we can take to avoid this types of buffer busy waits? Thanks for your help. Sri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srikannan Gopalsamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Steve Adam's Removal
You need... HELP -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: Steve Adam's Removal SNIP Oh Well ... I'll go hide now ... the Politically Correct police is already in the lobby ... and the only thing I can say is ' AM I STUPID? ' Just my thoughts ... Raj -- 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: Winnie quote
On Fri, 25 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: - -nah, Tigger bounces and has only a small brain... and he's ALWAYS happy but he also pushes the envlope, does things because he wants to, and always manages to make them work. -- 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. ~~ From C:\*.* to shining C:\*.* -- 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: Fire your DBA's you don't need them anymore...
Title: Fire your DBA's you don't need them anymore... Very stupid thing to do by Oracle, considering the fact that many Oracle purchasing decisions are made by Oracle DBAs. To shut us out like that will most certainly have an effect on Oracle Sales. Hell, you don't need me anymore? I'll switch political sides and jump the ship to IBM, or gasp Microsoft... Far as their "superior" i-dba team, I sure hope those are different people from the ones you get on first line of Support... Gary Weber PS. Or maybe we should all become Oracle salesmen (saleswomen) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: Friday, May 25, 2001 12:02 PMTo: Multiple recipients of list ORACLE-LSubject: Fire your DBA's you don't need them anymore... My boss just received a cold call from Oracle that he let me listen in on. They have a new push on for their i-dba support package. For just a little more money (they did not define little), "we will replace your dba's with our superior support team that will monitor your database 24x7 and proactively eliminate problems. This will allow you to redesign you office to offload these cumbersome DBA tasks and allow your workers to do other things. You will never have another database problem." I felt good when my boss indicated that we had no base problems but based on this, I guess we will have to become sqlserver DBAs or gasp developers... :) Ahh, Friday, wonderful Friday, it seems like you've been away all week... --Chris [EMAIL PROTECTED]
Re: OT: Winnie quote
On Fri, 25 May 2001,Dennis Taylor scribbled on the wall in glitter crayon: -At 04:55 PM 5/24/01 -0800, you wrote: - -That 'quote' isn't from Pooh at all, it's probably from Walt @#$$^^@! -Disney. The REAL Pooh is much wiser than that cheap greetings-card stuff! - - -Oh, bother. said Pooh,Eyore lock phasers on the Heffalump. Piglet meet me in transporter room three. -- 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. ~~ From C:\*.* to shining C:\*.* -- 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: Full user export
a :( so you should welcome me today is my first day :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Welcome? Gee!! ... Thanks... I thought I have been here for the past several years !! - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Salman Faheem [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:32 AM To: Multiple recipients of list ORACLE-L Subject:RE: Full user export Welcome to [EMAIL PROTECTED] hahahaha :) your dba Salman Faheem --- Deshpande, Kirti [EMAIL PROTECTED] wrote: exp owner=username file=user.dmp -- 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Salman Faheem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Steve Adam's Removal
Isn't that (removing Steve from Lazydba) akin to removing your brain to spite the space between your ears? Scott Shafer San Antonio, TX 210-581-6217 And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Grâce via your Ninja Death Touch, you step on a beer bottle and fall backwards into the juke box and get your head stove in by a drunk with a pool cue. --Jay Trigg -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 5:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: Steve Adam's Removal Erm... am I missing something but wasn't the original mail removing Steve Adams from the lazydba discussion list and not this one ?? Cheers Lee -- 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: Winnie quote
The most wonderful thing about Tiggers Is that Tiggers are wonderful things. Their tops are made out of rubber; Their bottoms are made out of springs. They're bouncy, bouncy, bouncy, bouncy, Fun, fun, fun, fun! But the most wonderful thing about Tiggers is I'm the only one. I don't recall anything about Tiggers being small-brained. Pooh is a bear of very litte brain. Tigger does seem very much an overgrown child, and one wonders how he survived before taking that large gollolup of Roo's strengthening medicine. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, May 25, 2001 9:13 AM To: Multiple recipients of list ORACLE-L nah, Tigger bounces and has only a small brain... and he's ALWAYS happy From: Thater, William [EMAIL PROTECTED] To: Rachel Carmichael [EMAIL PROTECTED] CC: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Winnie quote Date: Fri, 25 May 2001 11:09:25 -0400 On Fri, 25 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -that's easy! I'm Eeyore. - -sometimes maybe I'm Christopher Robin, but I'm not really sure about that i think of you more as Tiggeresqe. -- 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. ~~ From C:\*.* to shining C:\*.* _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standby vs. Adv. Replication (Multi-master)
Walter, We have a Standby database and I love it - especially compared to the complexities of replication! Once you set up the standby database, automate the mechanism for transferring archived redo logs from your production db to the standby, applying them, and deleting them once applied, it requires almost no intervention. About the only time I have to fiddle with the standby is after I add a datafile to a tablespace on the production db. We're on 8.1.6 under Win2k and our production db has almost 8 million CLOB documents, with about 50,000 added each night. The standby keeps up nicely. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Friday, May 25, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Hi, I'm looking for feedback on setting up a high-availability architecture for our production database. In a nutshell, we are a 24-hour shop and I need to be able to keep a secondary database (failover) in sync with the primary in case the primary fails. I have supported advanced replication (asynchronous) in the past but it was a single master relationship not multi-master. I'm leaning towards a standby database setup because my experience with advanced replication is less than favorable if/when transactions get out of sync. Also, one of the tables contains a LONG RAW. This column may go away or may be converted to a CLOB in the very near future but still needs to be kept in consideration when selecting a solution. The platform is Sun (SunOS 5.7) with 8.1.6. The secondary machine and database will most likely be located in another state. The database is small right now (~10Gb) and will continue to grow, but not too fast. What are your opinions? Is there an obvious choice between the two alternatives? Is there another alternative that I should be considering? Thanks VERY much in advance. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Winnie quote: Don't you Know What Ther Means
The first Pooh story has an exchange between Christopher Robin and his father that goes something like this ... AAM: ... anyway here he is ready to be introdcued to you now, Winnie-the-Pooh. When I first heard the name, I said, just as you are about to say, But I thought he was a boy. CR: He is. AAM: Then you can't call him Winnie. CR: I don't, he's Winne-ther-Pooh. Don't you know what 'ther' means? AAM: Ah yes now I do, and I hope your do to, for it's all the explanation you are going to get. I don't know what ther means. Perhaps I'm a DBA of very little brain. I cannot see Rachael as the ever-depressed Eeyore. Although I can envision her chomping on thistles without complaining about how hot they are. Ian A. MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, May 25, 2001 6:37 AM To: Multiple recipients of list ORACLE-L On Thu, 24 May 2001,Campbell, James scribbled on the wall in glitter crayon: -If you live to be a hundred, I want to live to be a hundred minus one -day,so I never have to live without you. -- Winnie the Pooh - -Dear me, Bill, where on earth did you get that from? I think I can hear -A.A. Milne revolving in his grave. off the web somewhere, and yes i am aware it's not the real pooh having all the pooh books from christopher robin milne himself. but i like it anyway.;-) and i always was a contrary person. just ask the Goddess.;-) -- 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. ~~ From C:\*.* to shining C:\*.* -- 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
backspace in Oracle.
List, I have created a test server using Linux 7.1 and Oracle 8.1.7.3 and it works great. The major problem I am having is I am NOT a typist and make errors at the SQL prompt. What do I set or define in the glogin to allow backspace to work as a backspace in Oracle? It has been a while since I had the privilege of UNIX ( in any flavor) Any info would be appreciated. Thanks, ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New member
We have one little rule that most folks follow pretty well. If it's not about Oracle or oracle proper, we usually place an OFFTOPIC or OT in the first position of the subject line. || -Original Message- || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 12:21 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: New member || || || Sounds great. I am a Lazy DBA refugee and I must say that I || like the tone || and banter on this list a lot better. I'll be talking to || you guys soon. || It's good to see familiar names like Chris Spence and Steve || Adams, for they || are outlaws on other sites. REAL TROUBLEMAKERS! || || Chuck Speaks, MCSE || Database Administrator || Lithonia Lighting || 770-922-9000 x3450 || http://www.lithonia.com || || || -Original Message- || Sent: Friday, May 25, 2001 11:43 AM || To: Multiple recipients of list ORACLE-L || || || Welcome, Chuck. || || Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. || || Welcome to a List where politics and recipes are posted with || equal fervor as SQL Tuning tips. || || The water's fine! || || || -Original Message- || || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 25, 2001 11:07 AM || || To: Multiple recipients of list ORACLE-L || || Subject: New member || || || || || || Hello, || || || || Just wanted to introduce myself before posting to the list. || || I look forward || || to interacting with you guys/ladies on the list. Have a || || great Friday! || || || || Chuck Speaks, MCSE || || Database Administrator || || Lithonia Lighting || || 770-922-9000 x3450 || || http://www.lithonia.com || || || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Speaks, Chuck W. || || INET: [EMAIL PROTECTED] || || || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || To REMOVE yourself from this mailing list, send an E-Mail message || || to: [EMAIL PROTECTED] (note EXACT spelling of || 'ListGuru') and in || || the message BODY, include a line containing: UNSUB ORACLE-L || || (or the name of mailing list you want to be removed || from). You may || || also send the HELP command for other information (like || subscribing). || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Mohan, Ross || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Speaks, Chuck W. || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bad SQL.....
I am trying to write an update statement but seem to be having problems.
Below is my statement and the error in SQL*Plus.
1 UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
2WHERE available_power.driver_id = manpowerprofile.mpp_id
3*and manpowerprofile.mpp_terminationdt
TO_DATE('31-DEC-2049','DD-MON-')
SQL /
and manpowerprofile.mpp_terminationdt
TO_DATE('31-DEC-2049','DD-MON-')
*
ERROR at line 3:
ORA-00904: invalid column name
I know that manpowerprofile.mpp_terminationdt is a valid table column. Do I
need to do some type of join on these two tables? Or is it just Friday and
I should give up and go have a cold beer!!:o) Any advice would be
appreciated.
Thanks,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: New member
Welcome over Chuck :) Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, May 25, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Sounds great. I am a Lazy DBA refugee and I must say that I like the tone and banter on this list a lot better. I'll be talking to you guys soon. It's good to see familiar names like Chris Spence and Steve Adams, for they are outlaws on other sites. REAL TROUBLEMAKERS! Chuck Speaks, MCSE Database Administrator Lithonia Lighting 770-922-9000 x3450 http://www.lithonia.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Steve Adam's Removal
Are you suggesting a mailing list without Our Highly Esteemed Mr. Adams would be empty of content? Hmmm. || -Original Message- || From: [EMAIL PROTECTED] || [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 12:21 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Steve Adam's Removal || || || Isn't that (removing Steve from Lazydba) akin to removing || your brain to || spite the space between your ears? || || Scott Shafer || San Antonio, TX || 210-581-6217 || || And no amount of training or preparedness can eliminate the almost || certainty that in the middle of your Angry Crane stance, as || you transition || to your Combative Monkey to administer the Coup de Grâce via || your Ninja || Death Touch, you step on a beer bottle and fall backwards || into the juke box || and get your head stove in by a drunk with a pool cue. --Jay Trigg || || -Original Message- || From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 5:16 AM || To:Multiple recipients of list ORACLE-L || Subject: RE: Steve Adam's Removal || || Erm... am I missing something but wasn't the original mail || removing Steve || Adams from the lazydba discussion list and not this one ?? || || Cheers || || Lee || || -- || 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: backspace in Oracle.
This message uses a character set that is not supported by the Internet Service. To view the original message content, open the attached message. If the text doesn't display correctly, save the attachment to disk, and then open it using a viewer that can display the original character set. message.txt Received: from corpws7-163.telergycorp.com ([10.10.7.163]) by tgcpmail01.telergycorp.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id LTZQ0H1P; Fri, 25 May 2001 12:18:08 -0400 Date: Fri, 25 May 2001 12:19:10 -0400 (Eastern Daylight Time) To: Ron Rogers [EMAIL PROTECTED] cc: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE On Fri, 25 May 2001,Ron Rogers scribbled on the wall in glitter crayon: -List, - I have created a test server using Linux 7.1 and Oracle 8.1.7.3 and it w= orks great. The major problem I am having is I am NOT a typist and make e= rrors at the SQL prompt. What do I set or define in the glogin to allow bac= kspace to work as a backspace in Oracle? It has been a while since I had th= e privilege of UNIX ( in any flavor) - Any info would be appreciated. -Thanks, -ROR m=AA=BF=AAm - - depends on your keyboard but in general: stty erase what ever your backspace key returns -- 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. ~~ From=20C:\*.* to shining C:\*.*
RE: Steve Adam's Removal
Henry, I am with all of our fellow DBA's requesting reconsideration of Steve Adams' removal from list. Being a list member for couple of years , I found Steve Adam's replies as one of the finest and most authentic on oracle subject. It looks that the matter is handled on personal account rather than professionally. I never saw Steve's reply as insulting or personal to anybody rather it looks his replies and advices like fatherly and helping a lot of DBA community experienced or newbi equally. Besides, I was thinking that Jared Still is list owner so far Have a nice long weekend to all. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 25 May 2001 01:56:07 -0800 Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From:Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent:Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject: RE: Steve Adam's Removal Henry, List I second you on this one. I respect Henry being the list owner, having authority to do as he pleases. ORACLE -L is possibly the best Oracle list out there,and has brought so many Oracle professionals together, but lets not lose our experts. Please reconsider the removal of Steve Adams from the list. He takes up lots of his time to answer performance related questions posted by list members with precise actions to be taken and great explanations. He is an invaluable member to the Oracle world and his expertise, generosity will surely be missed if he removed. Kind Regards and pls reconsider Suhen List, While I respect Henry's authority as list owner to remove people from the list, and the need to do so when people are breaking the rules, I would like to protest the removal of Steve Adams. He is one of the top experts in Oracle internals in the world, and he was gracious enough to take time to answer people's questions on the list. I am not sure what he ever did that was thought to be spamming, except answer people's questions. He has a link to his website in his signature, and often his answers were links to a place on his site where he had already answered that question. I don't see what's wrong with that, none of it seems to violate the rules of the list. If it was a matter of one or two people complaining about Steve's posts, perhaps the list should have been asked. I can only hope that the overwhelming majority understood Steve's method of answering questions and were not annoyed with it. The show now knows a lot less about Oracle Internal Services. Reed Sutton -Original Message- From: Henry O'Keeffe [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 8:58 AM To: LazyDBA.com Discussion Subject: Re: Spamming the list I'm afraid, you'll actually have to leave the list Steve. Picking lines from private emails sent between us, and presenting them out of context isn't something that most people would have expected from you. I'm sorry that it's had to come to this. Indeed, the show will go on. Goodbye. Henry. Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here:
RE: Fire your DBA's you don't need them anymore...
On Fri, 25 May 2001,Gary Weber scribbled on the wall in glitter crayon: -Very stupid thing to do by Oracle, considering the fact that many Oracle -purchasing decisions are made by Oracle DBAs. To shut us out like that -will most certainly have an effect on Oracle Sales. Hell, you don't need -me anymore? I'll switch political sides and jump the ship to IBM, or -gasp Microsoft... however it's just the thing my damagement would like to hear. guess i better get working on my resume. -- 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. ~~ From C:\*.* to shining C:\*.* -- 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: Winnie quote
Rachel, They just had a party for you here in Austin. If I'd known you were going to be in town, I would have come by. Today is Eeyore's Birthday Party . . . It's time to DRESS UP THE DOG! Author: Date: 04-28-2001 Publication: The Austin American-Statesman Page Number: D1 Word Count: 378 Size: 2K Relevancy: 81 38th annual Eeyore's Birthday Party When: 11 a.m. until dark today Where: Pease Park (on North Lamar between Martin Luther King Boulevard and 15th Street) Parking: None; free shuttle buses run from 10 a.m. to 8 p.m. from 16th Street and San Jacinto It's a pretty celebrated event around here. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] carmichr@hotcc: mail.comSubject: RE: OT: Winnie quote Sent by: root@fatcity. com 05/25/2001 10:43 AM Please respond to ORACLE-L that's easy! I'm Eeyore. sometimes maybe I'm Christopher Robin, but I'm not really sure about that From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Winnie quote Date: Fri, 25 May 2001 06:00:31 -0800 Speaking of the Goddess, which Winnie the Pooh character does she correspond to? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:37 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: Winnie quote On Thu, 24 May 2001,Campbell, James scribbled on the wall in glitter crayon: -If you live to be a hundred, I want to live to be a hundred minus one -day,so I never have to live without you. -- Winnie the Pooh - -Dear me, Bill, where on earth did you get that from? I think I can hear -A.A. Milne revolving in his grave. off the web somewhere, and yes i am aware it's not the real pooh having all the pooh books from christopher robin milne himself. but i like it anyway.;-) and i always was a contrary person. just ask the Goddess.;-) -- 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,
RE: Oracle Applications Suite CDs.
FYI, The Oracle Store only ships to the U.S. (NAFTA doesn't apply I guess.). So I called the number provided on the link for Canada... was told this was the wrong 1-800 number, they gave me another one with an extension. I called this number, and was told this was the wrong extension, they transferred me to someone else. The applications rep for Canada didn't know what to do, this is the first time apparently that someone wants to purchase the Oracle Applications CD pack in this country. ??? They will call me back once they figure out what they are supposed to do. I think that telling them this is for personal use because I'm curious threw them into a loop. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Sherman, Edward [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 5:03 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Applications Suite CDs. Get ready for some mystery meat web page navigation. Go to http://www.oracle.com Click on the Oracle Store Button You should see a row of tabs near the top of the page. Click on the Applications tab. After the Applications tab is selected click on the CD Packs link (just under and to the left of the Applications tab). Now you should see a list of Financial Applications products. They are $39.95 each. I'm gussing you want Oracle Applications 11i (You choose the OS). You'll get a box of about 40 CDs. HTH Ed -Original Message- Sent: Thursday, May 24, 2001 2:52 PM To: Multiple recipients of list ORACLE-L I would like to know how to obtain a trial or developer version of the Oracle Applications Suite... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- 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). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
OT: RE: Steve Adam's Removal
Title: OT: RE: Steve Adam's Removal Disclaimer: I have no affiliation with LazyDba or the owner of the LazyDba mailing list, and have not subscribed to that list. My personal opinion, for what it's worth: I don't think that this list is an appropriate place to impugn the motives of the owner(s), or discuss the inadequacies, of other mailing lists/personal websites, unless the question is posed to the list, e.g. Should I join lazydba? In addition, I would think it would be more professional to restrict one's comments to the technical value of said website or list. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Welcome !
Welcome to Oracle-L ! Nice to have you here with the rest of us. - Kirti -Original Message- From: Salman Faheem [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Subject: RE: Full user export a :( so you should welcome me today is my first day :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Steve Adam's Removal
TGIF !! - Kirti It is never friday when you are working on the weekends to get a product out. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, May 25, 2001 1:08 PM To: Multiple recipients of list ORACLE-L According to a comment posted there, Rachel Carmichael is a spammer too !! Sure, Rachel The Spammer Goddess Carmichael, posts nothing but some junk recipes (How about 'Cooking 101 for DBAs to go with your 'junk' recipes, Racheal? Sounds like there will be a few takers ;) TGIF !! - Kirti -Original Message- From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 11:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: Steve Adam's Removal What is the purpose of subscibing to Lazydba list at all?. I subscribed sometime ago and in several months unsubscribed. There are only couple of people who know what they are talking about and a lot of them on this list. Number of cluless questions tremendows etc. Again, my impressions from about a year ago. But I think nothing changed. However it would be intersting to read selected lines from Henry's e-mails which Steve picked up and and what was main Steve's sin. Of cource mentioning his website in his e-mail it is something uconsionable and unprovoked :-) Why would anybody do it when they already have www.lazydba.com - I don't understand it. Alex Hillman -Original Message- Sent: Friday, May 25, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Yeah, amoung the complaints I saw against me where. 1. I plugged my website (which I make no money, and provided for the benefit for others) 2. Two my emails were too long (I obviously spent too much time answering) 3. Someone would come back and there would be 30 emails from me (Obviously I answered too many questions) 4. I would just say i agree at times (I guess backing up someone's comment and basically saying I couldn't said it better and I would only repeat his answer to strengthen it). This is all after I left from hearing about Henry's plot. Now someone on this list has already posted someone on the board saying I am only plugging my site, yet I have answered around 30 questions in less than 3 days. Granted I try to get people to look at my site so they may find something to help them. Shame on me. The funniest thing is there is 1500 or so list members on the other list, 30-50 of them post answers, 1450-1470 just post questions. I have yet to see the 30-50 of the complain about the same issues or much of anything. People don't understand it takes time to answer these emails and we have better things to do. We do this because we want to help people, with all the barage of crap from people, it makes you want to just not bother. As such, my site will be unavailable due to it's helpful nature. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, May 25, 2001 10:17 AM To: Multiple recipients of list ORACLE-L I guess the lazy DBAs got tired of reading Oracle Internals. They just want simple answers. :) Richard Ji [EMAIL PROTECTED] 05/25/01 07:15AM you're right -- Henry isn't the list owner here in any case. For those of you who want to discuss this, Henry set up a discussion forum on the lazydba site. AFAIK, Steve is still a member of Oracle-L :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Steve Adam's Removal Date: Fri, 25 May 2001 02:16:06 -0800 Erm... am I missing something but wasn't the original mail removing Steve Adams from the lazydba discussion list and not this one ?? Cheers Lee -Original Message- Sent: 25 May 2001 10:56 To: Multiple recipients of list ORACLE-L Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this
Re: Sessions are waiting on buffer busy wait with P3 value 130 in v$s
Hi Steve, A couple questions: whihc p3 value is the value that indicates a need to increase freelists? Are there any plans to adapt your freeliusts estimation script for tables for indexes as well, or pointers on how to do so (I think I can do a direct port to work off dba_indexes, butparts of the logic aren't clear to me, so I feel like that would be shooting in the dark.) Thanks, George - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 25, 2001 12:09 PM v$s Hi Sri, If you can identify the segments involved from the p1 and p2 parameters and put those segments into a KEEP buffer pool you should be able to get a lot of relief. Failing that, or if they are too big, consider either increasing db_block_buffers if you can or setting _db_percent_hot_default to something like 80. That would allow up to 80% of the DEFAULT buffer pool to be used for hot buffers thereby improving the caching of the buffers that are causing you to wait. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 25 May 2001 9:26 To: Multiple recipients of list ORACLE-L v$s We've lot buffer busy waits in data block with P3 value 130 in V$session. I've read about this in few notes, but still I do not understand few things. P3=130 means: - Block is being read by another session and no other suitable block image was found, so we wait until the read is completed. This may also occur after a buffer cache assumed deadlock. The kernel can't get a buffer in a certain amount of time and assumes a deadlock. Therefore it will read the CR version of the block. Does it mean that the block is being held in an incompatible mode by the first session or set of sessions reading it in shared mode, and current session is trying to lock it exclusively for a DML and waiting for the same. What are steps we can take to avoid this types of buffer busy waits? Thanks for your help. Sri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srikannan Gopalsamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
recommendations and Ideas for apps server
List, Upper Damagement is in the process of determining the requirements for an Application package and have asked me for information on hardware needs and expenses. There is an anticipated max users of 25. I do not know what parts of the application package that they want. Scenario 1. We use the Compaq ES40 server using Open VMS as the database server and purchase a front end server to run the applications on hitting the back-end database. Scenario 2. We use the Compaq ES40 server running True64 as both the database and the Application server. Depending on the scenario selected, what would be the recommended cpu speed, memory, and disk space needed. Raid 1 disks for the application package. The current ES40 servers have a 250 GIG disk farm available. Thanks, ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Winnie quote
How about: Oh bother!, said Pooh, as the police closed in... Scott Shafer San Antonio, TX 210-581-6217 And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Grâce via your Ninja Death Touch, you step on a beer bottle and fall backwards into the juke box and get your head stove in by a drunk with a pool cue. --Jay Trigg -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: Winnie quote On Fri, 25 May 2001,Dennis Taylor scribbled on the wall in glitter crayon: -At 04:55 PM 5/24/01 -0800, you wrote: - -That 'quote' isn't from Pooh at all, it's probably from Walt @#$$^^@! -Disney. The REAL Pooh is much wiser than that cheap greetings-card stuff! - - -Oh, bother. said Pooh,Eyore lock phasers on the Heffalump. Piglet meet me in transporter room three. -- 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: Steve Adam's Removal
4) I agree Peddycoart, Judy [EMAIL PROTECTED] 05/25/01 11:02AM I agree with Raj; and, yes, I am one of those 1450 who lurk on the list, not contributing much. I'm still learning Oracle, and am in awe of those on the list with so much knowledge! I've been a DBA for many years (IMS and DB2 before learning Oracle), and I've learned that you never know when you're going to need a resource. We all have delete keys, and hopefully know how to use them! -Original Message- Sent: Friday, May 25, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Christopher You have a nice site, why take it off. If 30 people complain, they have an option not to click on the link. For every good thing there will be a lot of bad things. I just feel sad that we lost a good resource on the net. Please bring it back. A request to everyone ... a mere mention of a website doesn't mean that someone is pushing for a product, if you don't like it, don't visit the site. Everyone has the choice ... why complain? It is same as using the delete key for unwanted email. On a lighter note, how many of us feel compelled to send an email every time they see an email address? Oh Well ... I'll go hide now ... the Politically Correct police is already in the lobby ... and the only thing I can say is ' AM I STUPID? ' Just my thoughts ... Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peddycoart, Judy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=text/html; charset=iso-8859-1 http-equiv=Content-Type META content=MSHTML 5.00.3105.105 name=GENERATOR/HEAD BODY style=FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px; MARGIN-TOP: 2pxFONT size=14) I agree/FONTBRBRgt;gt;gt; Peddycoart, Judy lt;[EMAIL PROTECTED]gt; 05/25/01 11:02AM gt;gt;gt;BRI agree with Raj; and, yes, I am one of those 1450 who lurk on the list,BRnot contributing much.nbsp; I'm still learning Oracle, and am in awe of those onBRthe list with so much knowledge!nbsp; I've been a DBA for many years (IMS andBRDB2 before learning Oracle), and I've learned that you never know whenBRyou're going to need a resource.nbsp; We all have delete keys, and hopefullyBRknow how to use them!BRBRBR-Original Message-BRSent: Friday, May 25, 2001 10:46 AMBRTo: Multiple recipients of list ORACLE-LBRBRBRChristopherBRBRYou have a nice site, why take it off. If 30 people complain, they have anBRoption not to click on the link. For every good thing there will be a lotBRof bad things. I just feel sad that we lost a good resource on the net.BRPlease bring it back.BRBRA request to everyone ... a mere mention of a website doesn't mean thatBRsomeone is pushing for a product, if you don't like it, don't visit theBRsite. Everyone has the choice ... why complain? It is same as using theBRdelete key for unwanted email.BRBROn a lighter note, how many of us feel compelled to send an email every timeBRthey see an
Re: backspace in Oracle.
stty erase ^H The ^H is your backspace key. Ron Rogers wrote: List, I have created a test server using Linux 7.1 and Oracle 8.1.7.3 and it works great. The major problem I am having is I am NOT a typist and make errors at the SQL prompt. What do I set or define in the glogin to allow backspace to work as a backspace in Oracle? It has been a while since I had the privilege of UNIX ( in any flavor) Any info would be appreciated. Thanks, ROR mª¿ªm -- 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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT RE: Steve Adam's Removal
Please stop cross posting to Oracle-L. The tempest is in the LazyDBA teapot, not this one Thanks! || -Original Message- || From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 1:12 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Steve Adam's Removal || || || Henry, || I am with all of our fellow DBA's requesting reconsideration || of Steve Adams' || removal from list. || Being a list member for couple of years , I found Steve || Adam's replies || as one of the finest and most authentic on oracle subject. || It looks that the || matter is handled on personal account rather than || professionally. I never || saw Steve's reply as insulting or personal to anybody rather || it looks his || replies and advices like fatherly and helping a lot of DBA community || experienced or newbi equally. || || Besides, I was thinking that Jared Still is list owner so far || || Have a nice long weekend to all. || || Regards || Rafiq || || || || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Date: Fri, 25 May 2001 01:56:07 -0800 || || Dear Henry, || || Please reconsider this issue ! || I am sure there are many-many more who want to request not || to remove Steve and would support my mail, but are afraid || that other's mail-box would fill up by these request only.. || To be frank honest, he is the only list member who || has a folder in my outlook( I am not offending any-body || else) || Seriously ... please dont' do this || || Best Regards, || Rajesh || || -Original Message- || Sent: Friday, May 25, 2001 9:26 AM || To: Multiple recipients of list ORACLE-L || || || i hope this thread is still alive and my reply makes it to the || list... || || by removing Steve from the list , we all will miss the insight into || oracle || internals, || which he provided , thru his answers and the links (plugs ? ) to his || website.. || || many threads would end when Steve provides his || explanation/answer, this || show || || the respect posters have for his knowledge or Oracle. || || please reconsider || || Regards || Rahul || || || -- || From: Suhen Pather[SMTP:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 6:36 AM || To: LazyDBA.com Discussion || Subject: RE: Steve Adam's Removal || || Henry, List || || I second you on this one. || I respect Henry being the list owner, having authority to do as he || pleases. || || ORACLE -L is possibly the best Oracle list out there,and || has brought || so || many || || Oracle professionals together, but lets not lose our experts. || || Please reconsider the removal of Steve Adams from the list. || || He takes up lots of his time to answer performance || related questions || posted by list members with precise actions to be taken and great || explanations. || || He is an invaluable member to the Oracle world and his expertise, || generosity || will || surely be missed if he removed. || || Kind Regards and pls reconsider || Suhen || || || || || List, || || While I respect Henry's authority as list owner to remove || people from || the || list, and the need to do so when people are breaking the rules, I || would || like || to protest the removal of Steve Adams. He is one of the || top experts || in || Oracle internals in the world, and he was gracious enough || to take time || to || answer people's questions on the list. || || I am not sure what he ever did that was thought to be || spamming, except || answer people's questions. He has a link to his website in his || signature, || and often his answers were links to a place on his site || where he had || already || answered that question. I don't see what's wrong with || that, none of || it || seems to violate the rules of the list. || || If it was a matter of one or two people complaining about Steve's || posts, || perhaps the list should have been asked. I can only hope that the || overwhelming majority understood Steve's method of || answering questions || and || were not annoyed with it. || || The show now knows a lot less about Oracle Internal Services. || || Reed Sutton || || || || -Original Message- || From: Henry O'Keeffe [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 24, 2001 8:58 AM || To: LazyDBA.com Discussion || Subject: Re: Spamming the list || || || I'm afraid, you'll actually have to leave the list Steve. Picking || lines || from || private emails sent between us, and presenting them out of context || isn't || something that most people would have expected from you. I'm sorry || that || it's || had to come to this. || || Indeed, the show will go on. || || Goodbye. || Henry. || || || || Oracle documentation is here: ||
RE: OT: Winnie quote
but he's ORANGE!!! At least Eeyore is a decent shade of blue :) From: Thater, William [EMAIL PROTECTED] To: Rachel Carmichael [EMAIL PROTECTED] CC: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Winnie quote Date: Fri, 25 May 2001 11:29:26 -0400 On Fri, 25 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: - -nah, Tigger bounces and has only a small brain... and he's ALWAYS happy but he also pushes the envlope, does things because he wants to, and always manages to make them work. -- 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. ~~ From C:\*.* to shining C:\*.* _ 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: backspace in Oracle.
You'll have to define it in your profile using prompt stty erase press backspace key (without the and ) it is not something that can be set in glogin.sql. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fire your DBA's you don't need them anymore...
Title: Fire your DBA's you don't need them anymore... I can remember as far back as version 7.3 where Oracle was touting that "you won't need a DBA for our new database". It hasn't happened yet, has it? Oh yes, it's easier, but we're still here! And besides, what were they offering in the cold call? Replacing your DBAs with their DBAs. At (probably) twice the price. Outsourcing Lives! Just my $0.02 worth. Mike --- === Michael P. Vergara | Ive got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -Original Message-From: Gary Weber [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 9:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Fire your DBA's you don't need them anymore... Very stupid thing to do by Oracle, considering the fact that many Oracle purchasing decisions are made by Oracle DBAs. To shut us out like that will most certainly have an effect on Oracle Sales. Hell, you don't need me anymore? I'll switch political sides and jump the ship to IBM, or gasp Microsoft... Far as their "superior" i-dba team, I sure hope those are different people from the ones you get on first line of Support... Gary Weber PS. Or maybe we should all become Oracle salesmen (saleswomen) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: Friday, May 25, 2001 12:02 PMTo: Multiple recipients of list ORACLE-LSubject: Fire your DBA's you don't need them anymore... My boss just received a cold call from Oracle that he let me listen in on. They have a new push on for their i-dba support package. For just a little more money (they did not define little), "we will replace your dba's with our superior support team that will monitor your database 24x7 and proactively eliminate problems. This will allow you to redesign you office to offload these cumbersome DBA tasks and allow your workers to do other things. You will never have another database problem." I felt good when my boss indicated that we had no base problems but based on this, I guess we will have to become sqlserver DBAs or gasp developers... :) Ahh, Friday, wonderful Friday, it seems like you've been away all week... --Chris [EMAIL PROTECTED]
RE: Steve Adam's Removal
According to a comment posted there, Rachel Carmichael is a spammer too !! Sure, Rachel The Spammer Goddess Carmichael, posts nothing but some junk recipes (How about 'Cooking 101 for DBAs to go with your 'junk' recipes, Racheal? Sounds like there will be a few takers ;) TGIF !! - Kirti -Original Message- From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 11:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: Steve Adam's Removal What is the purpose of subscibing to Lazydba list at all?. I subscribed sometime ago and in several months unsubscribed. There are only couple of people who know what they are talking about and a lot of them on this list. Number of cluless questions tremendows etc. Again, my impressions from about a year ago. But I think nothing changed. However it would be intersting to read selected lines from Henry's e-mails which Steve picked up and and what was main Steve's sin. Of cource mentioning his website in his e-mail it is something uconsionable and unprovoked :-) Why would anybody do it when they already have www.lazydba.com - I don't understand it. Alex Hillman -Original Message- Sent: Friday, May 25, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Yeah, amoung the complaints I saw against me where. 1. I plugged my website (which I make no money, and provided for the benefit for others) 2. Two my emails were too long (I obviously spent too much time answering) 3. Someone would come back and there would be 30 emails from me (Obviously I answered too many questions) 4. I would just say i agree at times (I guess backing up someone's comment and basically saying I couldn't said it better and I would only repeat his answer to strengthen it). This is all after I left from hearing about Henry's plot. Now someone on this list has already posted someone on the board saying I am only plugging my site, yet I have answered around 30 questions in less than 3 days. Granted I try to get people to look at my site so they may find something to help them. Shame on me. The funniest thing is there is 1500 or so list members on the other list, 30-50 of them post answers, 1450-1470 just post questions. I have yet to see the 30-50 of the complain about the same issues or much of anything. People don't understand it takes time to answer these emails and we have better things to do. We do this because we want to help people, with all the barage of crap from people, it makes you want to just not bother. As such, my site will be unavailable due to it's helpful nature. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, May 25, 2001 10:17 AM To: Multiple recipients of list ORACLE-L I guess the lazy DBAs got tired of reading Oracle Internals. They just want simple answers. :) Richard Ji [EMAIL PROTECTED] 05/25/01 07:15AM you're right -- Henry isn't the list owner here in any case. For those of you who want to discuss this, Henry set up a discussion forum on the lazydba site. AFAIK, Steve is still a member of Oracle-L :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Steve Adam's Removal Date: Fri, 25 May 2001 02:16:06 -0800 Erm... am I missing something but wasn't the original mail removing Steve Adams from the lazydba discussion list and not this one ?? Cheers Lee -Original Message- Sent: 25 May 2001 10:56 To: Multiple recipients of list ORACLE-L Dear Henry, Please reconsider this issue ! I am sure there are many-many more who want to request not to remove Steve and would support my mail, but are afraid that other's mail-box would fill up by these request only.. To be frank honest, he is the only list member who has a folder in my outlook( I am not offending any-body else) Seriously ... please dont' do this Best Regards, Rajesh -Original Message- Sent: Friday, May 25, 2001 9:26 AM To: Multiple recipients of list ORACLE-L i hope this thread is still alive and my reply makes it to the list... by removing Steve from the list , we all will miss the insight into oracle internals, which he provided , thru his answers and the links (plugs ? ) to his website.. many threads would end when Steve provides his explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul -- From: Suhen Pather[SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:36 AM To: LazyDBA.com Discussion Subject: RE: Steve Adam's Removal Henry, List I second you on this one. I
how to turn off password prompt in NT???
Hi all, In Windows NT, how to disable the password prompt when login as internal through svrmgrl. I read an article in Metalink. The solution is for Unix which I don't see useful to my case. I checked all the sqlnet.ora files and all of them comment out SQLNET.AUTHENTICATION_SERVICES. Suggestion? Thanks, Janet __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
