Re: RE: Mailing frm Oracle
I also had same problem before, but dbms_job.broken procedure takes care of it. I first broke the job and then removed it. It works. Regs, - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 23, 2001 5:11 AM > one caution: > > If you're using Oracle 8.1.x on NT (NT4 - W2K) > you will have some serious issues with killing dba_jobs. > okay - its very easy to kill a dbms_job. > shutdown abort takes care of it - no problem. > I had a dbms_job emptying a mail queue that opened 3976 connections to a > Sendmail server last night - it stopped at port 4999 (testing code). The > mail server didn't even blink. > > I could not kill a dbms_job - as it deferred the kill session. > 7.3 use to have a parameter that allowed you to not keep the connection > alive. > That parameter isn't available in 8.1.6. > > So once again, less ways to get at the OS - less ways to maintain processes. > If you actually have users that don't want to have their instance shutdown, > better test that code very well ... > > Paul > > > Original Message > Date: Thu, 22 Feb 2001 14:40:27 -0800 > Reply-To: [EMAIL PROTECTED] > Organization: Fat City Network Services, San Diego, California > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > On 8.1.6+ you can use UTL_SMTP. > Vadim Gorbounov > Oracle DBA > > -Original Message- > Sent: Thursday, February 22, 2001 3:11 PM > To: Multiple recipients of list ORACLE-L > > > Hi Everybody, > > I wanted to forward a mail to a particular Id thru an Oracle Procedure , > can anybody tell me whether I can do that thru an Oralce Procedure > if so pls inform how to do the same. > > I dont want to mail to a Unix Login id , I want to mail to a mail server > > For e-g [EMAIL PROTECTED] > > > Thanks In Advance, > > Shankar Swamy. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shankar Shanmugaswamy > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vadim Gorbounov > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Drake > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjali R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Oracle 8i On solaris
but hey!!! is an ICG available for Oracle 8i on Solaris 10??? " am about to install Oracle 8i Enterprise on Sun Solaris version 10." Please let me know more about Solaris 10! - Original Message -- Diana Duncan <[EMAIL PROTECTED]> wrote: To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> From:Diana Duncan <[EMAIL PROTECTED]> Date:Fri, 23 Feb 2001 15:11:06 -0800 Subject:RE: Oracle 8i On solaris Follow the installation guide VERY CAREFULLY. Most people fail to install Oracle on Unix because they don't read the instructions. You must modify kernal parameters and do other Unix admin steps prior to installation. One thing to ignore (at least in my opinion) -- the instruction to create an "oinstall" user. I've found this causes more trouble than it's worth when it comes to patching. Just use the "oracle" user in the "dba" group. Go to technet.oracle.com for the installation guide. Regards, Diana -Original Message- Sent: Friday, February 23, 2001 11:06 AM To: Multiple recipients of list ORACLE-L Hi everyone: I am about to install Oracle 8i Enterprise on Sun Solaris version 10. Any Practical documentation or site which could help me on installing and configuring this system will be appreciated. I was away from Unix for a while. I have already checked the Oracle.com. I appreciate your help in advance. Majid -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Majid Kazemi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Diana Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: I want a suggestion for data transfer
If the customer needs read only information, one thought is to have a standby database which is kept in read only mode during the required time and recover during the off peak time. -Original Message- Sent: Friday, February 23, 2001 9:11 PM To: Multiple recipients of list ORACLE-L Hi! I need a suggestion for my problem. I have an Oracle 8i database on Windows NT and a front end application in Developer 2000 for data entry purposes. The system maintains all the information about the orders from clients,the stock position, other related accounts,etc. I want to design a website which could provide online information to clients about the status of their orders and other necessary information.For this purpose, I need to use the database that I have. The problem is that the Oracle 8i setup on NT is on an intranet and is not connected to the internet all the time. The system can be connected to the internet as and when needed using dial-up connectivity. I want to design an application which would make a copy of the database from the local database on to an oracle database on some web server at frequent intervals after I connect to the internet. What is the best way in which I can tranfer my data from the local database on to the server database? And this is not one time..this will be done very frequently. Can multimaster replication be a solution and if so how can that be done? Kindly help me. Thanking you. Kumar __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kumar iyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Jyoti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Truncate in a procedure?
For Oracle 8.1.6, I have a few packages in which I have procedures which
issue the following statement:
EXECUTE IMMEDIATE 'TRUNCATE TABLE table_name';
The statement is usually issued in connection with wiping out any old report
contents from a table when a new report is requested.
The packages are created and owned by the schema owner and execute fine.
They can also be executed by our app_user as well by creating public
synonyms for the packages and granting EXECUTE on the package to the
app_user. The app_user then executes with privileges of the package owner
through the application.. Since the app_user does not have any truncate
privileges outside of these packages for the owner schema, app_user cannot
issue a truncate statement through application code. Code must use DELETE
dml statements (as delete has been granted to app_user for tables).
HTH,
Bryan
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 11:55 AM
> No, but you have to do it with dynamic sql like:
>
> PROCEDURE exec_sql(p_string IN VARCHAR2 )
> IS
> l_cursor_name INTEGER;
> l_help INTEGER;
> BEGIN
> l_cursor_name := dbms_sql.open_cursor;
> dbms_sql.parse(l_cursor_name, p_string, DBMS_SQL.V7);
> l_help := dbms_sql.execute(l_cursor_name);
> dbms_sql.close_cursor(l_cursor_name);
> END;
> END coa_sql;
>
> exec_sql('truncate table a_table');
>
> Met vriendelijke groet,
>
> /'^'\
> Arno ( o o )
> ---oOOO--(_)--OOOo--
>
> Arno Disser
> SFS/Pensioenen en Verzekeringen
> FAD/ICT/DBA
> Postbus 11
> 2280 AA RIJSWIJK The Netherlands
> Tel +31 (0)70 33 66 389
> Fax +31 (0)70 31 93 884
> email
>
>
> -Oorspronkelijk bericht-
> Van: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Verzonden: vrijdag 16 februari 2001 16:50
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: Truncate in a procedure?
>
>
> I have a developer that is trying to truncate a table from within a
> procedure. If he does a delete it works ok. If he tries to issue the
> truncate command he gets errors. He is running the procedure as the
schema
> owner. Is there a problem with issuing a truncate command from within a
> procedure?
>
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Disser, Arno
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be 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: Bryan Sirtosky
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Oracle DBA with 8i experience needed in Tampa..
*Description: We have a client company in the greater Tampa Bay,Florida area that needs an Oracle DBA with 8i experience to join its' I.T. team. * Requirements: - B.S. Computer Science or equivalent - 3+ years of relevant work experience in an Oracle database environment - Oracle 8i experience is requied. - U.S. Citizenship or permanent residency This position offers: * Opportunity to become a key member of the team * Base Salary D.O.E * Excellent relocation package if needed NO sub contracting positions available. *U.S. citizenship or green card holders only PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Bill Law, Oracle Placement Specialist OraStaff, Inc. Ph: 1-800-549-8502-Please do not call if you need sponsorship Email: [EMAIL PROTECTED] Please use job code: One/Tampa/DBA 8i/Lisa -- Please see the official ORACLE-L FAQ: 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).
Fwd: I want a suggestion for data transfer
Note: forwarded message attached. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ Hi! I need a suggestion for my problem. I have an Oracle 8i database on Windows NT and a front end application in Developer 2000 for data entry purposes. The system maintains all the information about the orders from clients,the stock position, other related accounts,etc. I want to design a website which could provide online information to clients about the status of their orders and other necessary information.For this purpose, I need to use the database that I have. The problem is that the Oracle 8i setup on NT is on an intranet and is not connected to the internet all the time. The system can be connected to the internet as and when needed using dial-up connectivity. I want to design an application which would make a copy of the database from the local database on to an oracle database on some web server at frequent intervals after I connect to the internet. What is the best way in which I can tranfer my data from the local database on to the server database? And this is not one time..this will be done very frequently. Can multimaster replication be a solution and if so how can that be done? Kindly help me. Thanking you. Kumar __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kumar iyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
