RE: [Q] privilege allow user kill session???
Thank you for the answer. Do you have sample program? From: Jacques Kilchoer <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: [Q] privilege allow user kill session??? Date: Tue, 25 Sep 2001 14:55:34 -0800 Write a procedure that kills the relevant session(s) and grant the user execute access to that procedure. -Original Message- Sent: mardi, 25. septembre 2001 15:30 To: Multiple recipients of list ORACLE-L We have ORACLE 8.1.6 on UNIX server. My users asked me grant him the right to "kill the run away session." I don't want grant "alter system," alter system kill ..., to him; Because it is too high privilege. Does their has any other privilege which allow user kill session? Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 put accept inside PL/SQL program?
Does their has way to put "accept XXX" inside PL/SQL program? If not, how to work around? Thanks.Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] privilege allow user kill session???
We have ORACLE 8.1.6 on UNIX server. My users asked me grant him theright to "kill the run away session." I don't want grant "alter system," alter system kill ..., to him; Because it is too high privilege. Does their has any other privilege which allow user kill session? Thanks. Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
which view can grant user access DBA_XXX???
On ORACLE 8i their has a view call DBA_XXX which allow user to"select" DBA_XXX and V$XXX view. I can NOT remember the name. Can anyonegive me a hint? Thanks. Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
out of process memory while doing full DB import
I am doing full DB import and have following error message: IMP-00017: following statement failed with ORACLE error 4030:"CREATE PACKAGE BODY dbms_repcat_auth wrapped ""0" "abcd""abcd""abcd""abcd""abcd""abcd""abcd""abcd""abcd""abcd""abcd""abcd" .. IMP-3: ORACLE error 4030 encounteredORA-04030: out of process memory when trying to allocate 452224 bytes (PLSnon-lib hp,PAR.C:parchk:ptb) Anyone know why? Thanks Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] exp from 8.1.7 and import to 8.1.6?
I just upgrade ORACLE from 8.1.6 to 8.1.7 (SUn Solaris). My question is can I export from 8.1.7 and bring the dump file import into 8.1.6 ORACLE server? Thanks.Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] exp from 8.1.7 and import to 8.1.6?
Thank you for your answer. Can you tell me how to make it work? Thanks. From: Tirumala, Surendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: [Q] exp from 8.1.7 and import to 8.1.6? Date: Thu, 26 Jul 2001 10:16:15 -0800 NO. -Original Message- Sent: Thursday, July 26, 2001 10:56 AM To: Multiple recipients of list ORACLE-L I just upgrade ORACLE from 8.1.6 to 8.1.7 (SUn Solaris). My question is can I export from 8.1.7 and bring the dump file import into 8.1.6 ORACLE server? Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com http://go.msn.com/bql/hmtag_itl_EN.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] does Personal ORACLE 8.1.7 support Win98?
the problem are: 1. it did not create DB. 2. no "lsnrctl.exe" Thanks. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: [Q] does Personal ORACLE 8.1.7 support Win98? Date: Thu, 19 Jul 2001 05:40:43 -0800 Yes it is. I have it installed and it works fine. What problems are you havging Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] does Personal ORACLE 8.1.7 support Win98?
I installed personal ORACLE 8.1.7 on Win98 and have a lot ofproblems. Does personal ORACLE 8.1.7 compatible with win98? Thanks Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] populate production DB to test DB?
We have ORACLE 8.1.6 on SUN servers. We just finished phase I developmentand will starting phase II development soon. We will copy our productionDB to development server for phase II. Our contractor request every weekwe need populate new/update information on production DB to developmentserver, but also keep everything they have been doning on developmentserver. Does their has way can be done? thanks.Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] which desugner tool better?
can anyone give me some ideal about which designer tool better (ER win, Oracle designer or Embarcadero)? What I need to know is functions, user interface, price and Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Oracle DBA Needed in Phoenix..
$75,000 is pretty good. Our company (in Washington, DC) just hire a ORACLE DBA. He claimed he have OCP certificate and ONLY asked $60,000. From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: * Oracle DBA Needed in Phoenix.. Date: Fri, 06 Jul 2001 07:35:30 -0800 Lisa, imitating a bird... Cheap! Cheap Cheap Cheap next will be I taught I taw a puddy-tat Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, July 06, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Cheap! Cheap Cheap Cheap $75,000? To move across the country with MINIMAL relo? Are they kidding?? I hope this isn't our parent company Happy Friday everyone! Lisa, the anti-recruiter ninja -Original Message- Sent: Friday, July 06, 2001 9:11 AM To: Multiple recipients of list ORACLE-L orastaff wrote: We would like to submit someone who is a renter and who is interested in Phoenix but has not applied to Phoenix companies and is not working with other recruiters for Phoenix companies. Is this some super secret job or what??? -Original Message- Sent: Thursday, July 05, 2001 3:15 PM To: Multiple recipients of list ORACLE-L If you're interested in a great opportunity, then consider this position in Phoenix, AZ with a leading company that needs an Oracle DBA to join its' I.T. staff. We would like to submit someone who is a renter and who is interested in Phoenix but has not applied to Phoenix companies and is not working with other recruiters for Phoenix companies. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - A degree in C.S. or equivalent - 3+ yrs Oracle DBA experience is needed - Strong Unix - Application development experience; Unix scripting; C or Perl languages are desirable - Must have good communication skills -U.S. citizenship or permanent residency required This position is with a company that offers : * Quality Work Environment * Base salary up to 75K-firm +excellent benefits * Financial Stability * Some Relocation Assistance NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume to: Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. * Please use job code: One/Phoenix/DBA/Carlos We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law OraStaff, Inc-The Proven Connection To Oracle Opportunity -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
RE: * Oracle DBA Needed in Phoenix..
EMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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). Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
set autotrace error ??
We have ORACLE 8.1.6.1 database and I login as DBA and tried to turn on autotrace. I got following error messages: SQL set autot on ERROR: ORA-00904: invalid column name SP2-0611: Error enabling EXPLAIN report Any ideal? Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
