RE: how to schedule an execution in PL/SQL
Title: RE: how to schedule an execution in PL/SQL hi! i guess you should just have a look at the DBMS_JOB package! i would start with reading the documentation of this standard oracle package. cheers -dieter -Original Message- From: mac [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 14:33 To: Multiple recipients of list ORACLE-L Subject: how to schedule an execution in PL/SQL Any idea how to schedule the execution of a PL/SQL package? and if a certain condition is acomplished to execute again (later in the night) the same package until the same condition is not anymore fulfilled? In PL/SQL not using a script for the operating system for example. Ciprian MAFTEI Telequote Network Computer Systems Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mac INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Free ware databases: which are worth the money?
Title: RE: Free ware databases: which are worth the money? hi! is PostgreeSQL also available on the windows platform and are there supported (commercial) versions around? thank you -Original Message- From: Daniel Wisser [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 14:58 To: Multiple recipients of list ORACLE-L Subject: Re: Free ware databases: which are worth the money? hi! i can strongly recommend PostgreSQL. i have worked with it modelling data for a java application and perl cgis using it. it supports transactions, functions in pure sql, a procedural language similar to PL/SQL etc. etc. and is very robust. the only thing i miss is handling tablespaces as on oracle. i have sofar only used it on debian, but it should also be fine on other linuxes and some elitist bigots work with it on sun. there is also good literature and a very good o'reilly book on it. on the web htpp://www.postgresql.org regards Mark Teehan wrote: Hi, we are investigating some freeware databases for deployment on systems that dont justify the cost of an oracle license, on linux. What databases out these can cope with a OLTP load, all transaction based, with some reporting? Uncomplicated databases, with mid size volumes of transactions (say low millions) and some reporting queries? I guess reliability is the primary concern, if something can be built as solidly as an oracle instance, with whatever OS protection this would need, then its a starting point for making a non oracle freeware enterprise database. Anyone have any suggestions on what I should download first? Thanks! Mark Teehan Singapore ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: [EMAIL PROTECTED] Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Excel to Oracle
Title: RE: Excel to Oracle hi! i would probably just export the table in a portable csv format and then use the oracle sql*loader to import it into oracle. simple but it works! cheers dieter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 16:44 To: Multiple recipients of list ORACLE-L Subject: Excel to Oracle Hi All, What is the best/quickest way to move data from excel to Oracle? Thanks 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).
RE: How to do a bulk bind to load data into a table
Title: RE: How to do a bulk bind to load data into a table from my understanding the FORALL statement only helps you when processing data in collections or with BULK when retrieving rows into collections. the bulk bind functionality is btw only available starting with 9i. you might want to try to bulk retrieve the data in a collection and then to bulk insert it in the new table but i would guess that the only real way to optimize your statement might by to go for the insert into b select a construct if this is an option in your case. DO -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 22:05 To: Multiple recipients of list ORACLE-L Subject: How to do a bulk bind to load data into a table I'm looking at a way to speed up a huge insert (100K records at a time). In looking at FORALL, it looks like it could do what I want, but I'm not sure how to set it up correctly. What I currently do is: set up a cursor, selecting the rows from table a for cursor_rec in cursor_data loop insert into table b commit evey 2K rows end loop Is there a better way to do this? Thank you for your help. -- 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: script to kill session
Title: RE: script to kill session if you want to do this interactively you might also want to have a look at a small shareware win32 tool called osession at http://www.materialdreams.com/oracle/products.html D -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 16:04 To: Multiple recipients of list ORACLE-L Subject: Re: script to kill session Here is a shell script I use in UNIX, restrict_and_kill. I included the sql command to build the sql with the kill commands, killuser_build. It excludes users with restricted session access and puts the database into restricted session mode. You can modify these scripts to suit your needs. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 11, 2002 4:58 PM Hi, We are looking for a script that will grep the sid from v$session and kill all the sessions of a particular user. The script will prompt the username and kill all the related sessions. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ok... this is driving me nuts!
Title: RE: Ok... this is driving me nuts! i can't really remember the call command in pl/sql. where do you call it from? if you are in a pl/sql block you don't need a call but you might want to assign the return value to a variable! in sql*plus you need to assign the return value to a variable. D -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 16:03 To: Multiple recipients of list ORACLE-L Subject: RE: Ok... this is driving me nuts! The first thing that strikes me is that you seem to be calling a function like a procedure. Try v_somenumber := RAKNAUPP.FAKTURANUMMER. HTH! GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Original Message- Sent: Wednesday, February 13, 2002 8:23 AM To: Multiple recipients of list ORACLE-L I have the following package defined PACKAGE RAKNAUPP AS FUNCTION FAKTURANUMMER RETURN NUMBER; FUNCTION MEDLEMSNUMMER RETURN NUMBER; FUNCTION OCRNUMMER RETURN NUMBER; FUNCTION INBETNUMMER RETURN NUMBER; END RAKNAUPP; . . . It works fine, except when I try to run it with call: call RAKNAUPP.FAKTURANUMMER; Then I get: ORA-06576: not a valid function or procedure name call ERROR'raknaupp.fakturanummer' And I'm about at my wits end here... I can't for my life figure out why this isn't working as it is suposed to! Could someone please figure out what I am doing wrong? Stefan Jakobsson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
used segment space in bytes
Title: Dieter Oberkofler Stationery hi guys! what would be the easiest way to compute the space in bytes used by a segment? it is rather easy to determine the # of used blocks by a specific segment by looking at the dba_extents for example. but how many blocks have been really used in one of those extents. i guess i would be able to compute the free blocks by using the dbms_space package but it just seems to complicated. any hints ... ? thank you -do
No Subject
Title: set oracle-l nodigest