dbsnmp/intelligent agent for linux
i have read and read about this beast but most of the documentation is very confusing (more reference than howto) and the 'tips' seems to be folkloreish or guesses. i gather there are some things that need to be done to these files: $ORACLE_HOME/network/admin/snmp_rw.ora $ORACLE_HOME/network/admin/listener.ora and that the 'lsnrctl' should have the dbsnmp_(start|stop) options. mine doesnt but i assume that is because it isnt configured properly or i mooked something else up. any help you can give me would be great ... thanks --- Gabriel C. Millerd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Urgent: Retrieving Disk Space
Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
profile
Hello guru How can I set a performance of CPU for 1 session at 15 % in profile I hawe Oracle 8.1.7 . R 3 . Thanks Oto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Otakar =?iso-8859-2?q?Mou=E8ka?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Index creating
Hi Can we able to create index for a particular partition or for the data load on a particular day? Ayap This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- 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: dbsnmp/intelligent agent for linux
Hi Gabriel The agent configuration is very version dependent so please inform the version of Oracle you are trying to use. Here is how to start the Agent with 9.2, 9i and properly 8.1.7 [oracle@mirpgr bin]$ agentctl Usage: agentctl start|stop|status|restart [agent] agentctl start|stop|status blackout [target] [-d/uration timefmt] [-s/ubsystem subsystems] The following are valid options for blackouts targetname of the target. Defaults to node target. timefmt is specified as [days] hh:mm subsystem is specified as [jobs events collections] defaults to all subsystems [oracle@mirpgr bin]$ agentctl start DBSNMP for Linux: Version 9.2.0.1.0 - Production on 04-JUN-2002 08:59:54 Copyright (c) 2002 Oracle Corporation. All rights reserved. Starting Oracle Intelligent Agent Agent started [oracle@mirpgr bin]$ agentctl status DBSNMP for Linux: Version 9.2.0.1.0 - Production on 04-JUN-2002 09:00:04 Copyright (c) 2002 Oracle Corporation. All rights reserved. Version : DBSNMP for Linux: Version 9.2.0.1.0 - Production Oracle Home : /home2/oracle/product/9.2.0 Started by user : oracle Agent is running since 06/04/02 08:59:56 Gabriel C Millerd wrote: i have read and read about this beast but most of the documentation is very confusing (more reference than howto) and the 'tips' seems to be folkloreish or guesses. i gather there are some things that need to be done to these files: $ORACLE_HOME/network/admin/snmp_rw.ora $ORACLE_HOME/network/admin/listener.ora and that the 'lsnrctl' should have the dbsnmp_(start|stop) options. mine doesnt but i assume that is because it isnt configured properly or i mooked something else up. any help you can give me would be great ... thanks --- Gabriel C. Millerd -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk /* The process of preparing programs for a digital computer is especially attractive, not only because it can be economically and scientifically rewarding, but also because it can be an aesthetic experience much like composing poetry or music Donald Knuth */ smime.p7s Description: application/pkcs7-signature
Re: Urgent: Retrieving Disk Space
Hi What has grown? you don't mention datafiles. So if there is only the three types of files you mention there I can only assume that the part that has grown is the number of archive logs. These are needed for recovery since last backup and can not be thrown away. can be zipped though. If I'm not mistaken if you use the insert /*+ APPEND */ hint it uses direct load and does not create so much redo (archives) and is faster as well Jack Abdul Aleem dmit@beaconhouseTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .edu.pk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Urgent: Retrieving Disk Space [EMAIL PROTECTED] 04-06-2002 09:58 Please respond to ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has
RE: profile
Set Resource_Limit = TRUE in the Parameter File. Then Create a Profile that uses Cpu_Per_Call and CPU_Per_Session values so that CPU Usgae is restricted. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Hello guru How can I set a performance of CPU for 1 session at 15 % in profile I hawe Oracle 8.1.7 . R 3 . Thanks Oto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Otakar =?iso-8859-2?q?Mou=E8ka?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent: Retrieving Disk Space
All the files you mention here are critical files. What is the Temp File Size. Did u see that. Why did the table not get created. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent: Retrieving Disk Space
Thanx Jack, The size of System01.dbf has grown from 1GB to 4GB The size of temp01.dbf is around 1GB now. Best Regards, Aleem -Original Message- Sent: Tuesday, June 04, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Subject:Re: Urgent: Retrieving Disk Space Hi What has grown? you don't mention datafiles. So if there is only the three types of files you mention there I can only assume that the part that has grown is the number of archive logs. These are needed for recovery since last backup and can not be thrown away. can be zipped though. If I'm not mistaken if you use the insert /*+ APPEND */ hint it uses direct load and does not create so much redo (archives) and is faster as well Jack Abdul Aleem dmit@beaconhouseTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .edu.pk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Urgent: Retrieving Disk Space [EMAIL PROTECTED] 04-06-2002 09:58 Please respond to ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing
Re: Urgent: Retrieving Disk Space
Aleem, Did you mention control files, redo log files, archive log files with recovery in mind? If so, you probably don't need it. Read next if you have all the files for the database on this one poor hard drive: Review the cause for create table as select... command. If it is the message like unable to allocate extent... something (don't remeber exact phrase) then your datafiles have AUTOEXTEND ON option. Once they extended to take all the space on the disk, you've got the error message. And your log information has probably also noticeable grown as Jack sad in another answer. You can shrink you datafile(s). But should not trash you archive logs (unless of course you want to have you database safe). To get rid of archive log info you may perform a full backup. -- Alexandre Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent: Retrieving Disk Space
SYSTEM @ 4GB i have never seen this kind of size for a system datafile UNLESS .. objects other than the data dictionary reside in system tablespace ... if that's the case... u have to cleanup all objects which does not belong to SYS/SYSTEM and are in the SYSTEM tablespace .. TEMP will keep the space occupide even if a transaction failed.. , sometimes on my version 7.3.4 i have to bounce the DB to cleanup the temp segments... also, after you clean up the SYSTEM tablespaces... you should switch off the autoextend for SYSTEM's datafile too. HTH PS: this is all assuming that the SYSTEM01.dbf does indeed belong to the SYSTEM tablespace. !!! -- From: Abdul Aleem[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: Urgent: Retrieving Disk Space Thanx Jack, The size of System01.dbf has grown from 1GB to 4GB The size of temp01.dbf is around 1GB now. Best Regards, Aleem -Original Message- Sent: Tuesday, June 04, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Urgent: Retrieving Disk Space Hi What has grown? you don't mention datafiles. So if there is only the three types of files you mention there I can only assume that the part that has grown is the number of archive logs. These are needed for recovery since last backup and can not be thrown away. can be zipped though. If I'm not mistaken if you use the insert /*+ APPEND */ hint it uses direct load and does not create so much redo (archives) and is faster as well Jack Abdul Aleem dmit@beaconhouseTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .edu.pk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Urgent: Retrieving Disk Space [EMAIL PROTECTED] 04-06-2002 09:58 Please respond to ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information
FW: Can we drop and re-create tablespace without deleting the corresponding datafile thru operating system command?
My apologies for excluding the list from my email. Regards Theo -Original Message- Sent: 04 June 2002 09:21 To: '[EMAIL PROTECTED]' corresponding datafile thru operating system command? Sorry for the delay, but this is to our time difference. Please find a more detailed explanation below: Dropping Datafiles and Tempfiles Unlike files that are not Oracle managed, when an Oracle-managed datafile or tempfile is dropped, the filename is removed from the control file and the file is automatically deleted from the file system. The statements that delete Oracle-managed files when they are dropped are: DROP TABLESPACE ALTER DATABASE TEMPFILE ... DROP Dropping Online Redo Log Files When an Oracle-managed online redo log file is dropped its Oracle-managed files are deleted. You specify the group or members to be dropped. The following statements drop and delete online redo log files: ALTER DATABASE DROP LOGFILE ALTER DATABASE DROP LOGFILE MEMBER In Oracle9i Rel.2 you can use the following: AND DATAFILES clause When you specify INCLUDING CONTENTS, the AND DATAFILES clause lets you instruct Oracle to delete the associated operating system files as well. Oracle writes a message to the alert log for each operating system file deleted. This clause is not needed for Oracle-managed files. The following example drops the tbs_02 tablespace and deletes all associated operating system datafiles: DROP TABLESPACE tbs_02 INCLUDING CONTENTS AND DATAFILES; I hope that this was more helpful. Regards Theodoros -Original Message- Sent: 04 June 2002 06:19 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Theodoros Demosthenous corresponding datafile thru operating system command? Dear Mr Theo, Thanks for your enclosed mail. You mean to say if it is some earlier version, then we need to drop the tablespace, delete corresponding dbf file thru operating system command and recreate the tablespace the corresponding dbf datafile thru create tablespace command? Please elaborate. Regards Kamal Mutneja --- Theodoros Demosthenous [EMAIL PROTECTED] wrote: Only in Oracle9i Rel.2 this can be done. Regards Theo -Original Message- Sent: 03 June 2002 09:53 To: Multiple recipients of list ODTUG-SQLPLUS-L corresponding datafile thru operating system command? Hi Can we drop and re-create tablespace without deleting the corresponding datafile thru operating system command? Regards Kamal Mutneja __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com Become an ODTUGer and be a voice to Oracle! Join now at www.odtug.com/join.htm ODTUG 2002 at Caesars Palace in Las Vegas, NV, June 17-21, 2002 -- Author: Kamal Mutneja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Become an ODTUGer and be a voice to Oracle! Join now at www.odtug.com/join.htm ODTUG 2002 at Caesars Palace in Las Vegas, NV, June 17-21, 2002 -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L (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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dbsnmp/intelligent agent for linux
On Tue, 4 Jun 2002, Peter Gram wrote: Hi Gabriel The agent configuration is very version dependent so please inform the version of Oracle you are trying to use. Here is how to start the Agent with 9.2, 9i and properly 8.1.7 i am sorry ... i somehow removed that paragraph while editing the text ... i am using 'Oracle9i Enterprise Edition Release 9.0.1.0.0' i tried that and was told dbsnmp (for unix blanketly) was the command of choice. here is its output ... $ ./agentctl start DBSNMP for Linux: Version 9.0.1.0.0 - Production on 04-JUN-2002 03:07:21 Copyright (c) 2001 Oracle Corporation. All rights reserved. NMS-00010: Parsing parameter file failed. nmiclbg_ensureAlive:: Initialize error for nmigenctx ... is there a file i need to tweak for this? --- Gabriel C. Millerd | To choose one's victim, to prepare one's plan Script Monkey | minutely, to slake an implacable vengeance, and | then go to bed... There is nothing sweeter in the | world. --Josef Stalin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent: Retrieving Disk Space
The size of System01.dbf has grown from 1GB to 4GB Try to never make a user with the SYSTEM as a default tablespace, neither create files there, which is probaly your case. -- Alexandre The size of temp01.dbf is around 1GB now. Best Regards, Aleem -Original Message- Sent: Tuesday, June 04, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Urgent: Retrieving Disk Space Hi What has grown? you don't mention datafiles. So if there is only the three types of files you mention there I can only assume that the part that has grown is the number of archive logs. These are needed for recovery since last backup and can not be thrown away. can be zipped though. If I'm not mistaken if you use the insert /*+ APPEND */ hint it uses direct load and does not create so much redo (archives) and is faster as well Jack Abdul Aleem dmit@beaconhouseTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .edu.pk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Urgent: Retrieving Disk Space [EMAIL PROTECTED] 04-06-2002 09:58 Please respond to ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Urgent: Retrieving Disk Space
Ganesh, The query didn't get completed because of the disc space. Temp01.dbf size is about 1GB System01.dbf size is nearly 4GB against last nearly 1GB Aleem -Original Message- Sent: Tuesday, June 04, 2002 1:53 PM To: Multiple recipients of list ORACLE-L Subject:RE: Urgent: Retrieving Disk Space All the files you mention here are critical files. What is the Temp File Size. Did u see that. Why did the table not get created. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: foreign key what???? help!!
you might want to disable the FK's before loading. This will speed up the loading, and it will not upset you with ugly error messages. After loading... enable keys. Keith Date: Mon, 03 Jun 2002 15:28:22 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California It is probably a question of timing when Child records are loaded before Parents. It can be a question of table order or even record order (self referencing relationship). Once the data is loaded, enforcement of the constraint is easy because all of the data exists. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 4:13 PM To: Multiple recipients of list ORACLE-L Okay guys, Have foreign keys defined on large dw tables. When loading get foreign key errors. However, after load (w/o change in data and supposedly data it was barking on) could create fk's just fine on the same data elements involving the same data - I SWEAR. This does not make sense to me. Any ideas? __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent: Retrieving Disk Space
Alexandre, I mentioned these files to know if any of these can be deleted/copied elsewhere safely? How do I check upon the reason of failure of a particular query? The developer recalls that the message was something like low disc space. TIA! Aleem -Original Message- Sent: Tuesday, June 04, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject:Re: Urgent: Retrieving Disk Space Aleem, Did you mention control files, redo log files, archive log files with recovery in mind? If so, you probably don't need it. Read next if you have all the files for the database on this one poor hard drive: Review the cause for create table as select... command. If it is the message like unable to allocate extent... something (don't remeber exact phrase) then your datafiles have AUTOEXTEND ON option. Once they extended to take all the space on the disk, you've got the error message. And your log information has probably also noticeable grown as Jack sad in another answer. You can shrink you datafile(s). But should not trash you archive logs (unless of course you want to have you database safe). To get rid of archive log info you may perform a full backup. -- Alexandre Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Urgent: Retrieving Disk Space
I am just going to repeat the question all the people here have asked what was the users Temp Segment when he ran the CTAS. You have Made a Mistake there. Try Resizing the system Tablespace. To a Lower Value but that may not happen. If that does not happen u will have to move the temp tablespace out of that disk and don't ever have your system Tablespace for a User Other Than Sys not even System. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Ganesh, The query didn't get completed because of the disc space. Temp01.dbf size is about 1GB System01.dbf size is nearly 4GB against last nearly 1GB Aleem -Original Message- Sent: Tuesday, June 04, 2002 1:53 PM To: Multiple recipients of list ORACLE-L Subject:RE: Urgent: Retrieving Disk Space All the files you mention here are critical files. What is the Temp File Size. Did u see that. Why did the table not get created. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Tuesday, June 04, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: foreign key what???? help!!
Another option: make constraint DEFFERABLE and INITIALLY DEFFERED (if i spelled this correctly) In that case inforcement is done on the moment of commit. There is some limitations, however. PK must be base on a non-unique index in order to be defferable. But all FK should be fine. HTH, -- Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 11:49 AM you might want to disable the FK's before loading. This will speed up the loading, and it will not upset you with ugly error messages. After loading... enable keys. Keith Date: Mon, 03 Jun 2002 15:28:22 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California It is probably a question of timing when Child records are loaded before Parents. It can be a question of table order or even record order (self referencing relationship). Once the data is loaded, enforcement of the constraint is easy because all of the data exists. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 4:13 PM To: Multiple recipients of list ORACLE-L Okay guys, Have foreign keys defined on large dw tables. When loading get foreign key errors. However, after load (w/o change in data and supposedly data it was barking on) could create fk's just fine on the same data elements involving the same data - I SWEAR. This does not make sense to me. Any ideas? __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: trial version of Oracle Financial ??
On Mon, 3 Jun 2002, Leslie Lu wrote: Does anyone know where to get a trial version of Oracle Financial, or other components of 11i? Leslie: One way is to go to technet.oracle.com and click on the Store link, and navigate to the 40-50 set CD-PACK for Oracle Apps. It includes all the docs in PDF and HTML formats, and various installations. It's $40, not bad considering how much stuff you get. Think of it as buying a cheap book on Oracle Press! Sean -.-..-.-..-.--..- Heavyweight Internet Consulting (http://www.iheavy.com) O'Reilly Author, Oracle Opn Src (http://www.oreilly.com/catalog/oracleopen) -- 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: Urgent: Retrieving Disk Space
Jack, I had asked the developer to use another table space instead of system, he did that, but when restoring, the backup he missed that and the tables were restored in system table space. The default table space name is STD. I am not sure of the original size of temp table space. As I have understood from Alexendre's message that the system table space has grown in size (one way process), does not actually occupy that much. So there probably isn't much worry, unless, some DML says out of disc space. Aleem -Original Message- Sent: Tuesday, June 04, 2002 2:43 PM To: Multiple recipients of list ORACLE-L Subject:RE: Urgent: Retrieving Disk Space Hi, Autoextend is on for system tablespace (why?). What's the default tablespace for the account the developer used to create the object (system?), if not system his objects should not go to system tablespace so than maybe his temporary tablespace is system and he used this tablespace to perform a massive sort operation in order to fill that newly created table. Temp is 1GB, mine is 13Gb (on one of our databases) and I don't worry about it. Question is did it grow also or was it 1Gb to begin with? Jack Abdul Aleem dmit@beaconhouseTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .edu.pk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Urgent: Retrieving Disk Space [EMAIL PROTECTED] 04-06-2002 11:03 Please respond to ORACLE-L Thanx Jack, The size of System01.dbf has grown from 1GB to 4GB The size of temp01.dbf is around 1GB now. Best Regards, Aleem -Original Message- Sent:Tuesday, June 04, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Hi What has grown? you don't mention datafiles. So if there is only the three types of files you mention there I can only assume that the part that has grown is the number of archive logs. These are needed for recovery since last backup and can not be thrown away. can be zipped though. If I'm not mistaken if you use the insert /*+ APPEND */ hint it uses direct load and does not create so much redo (archives) and is faster as well Jack Abdul Aleem dmit@beaconhouseTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .edu.pk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Urgent: Retrieving Disk Space [EMAIL PROTECTED] 04-06-2002 09:58 Please respond to ORACLE-L Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te
Re: Urgent: Retrieving Disk Space
I mentioned these files to know if any of these can be deleted/copied elsewhere safely? You MUST move you archive redo logs if you want your database to be recoverable. You need them if you make backups at all. Anyway you should periodically clean up the space for your archive redo logs, or else your database will hang somewhen because oracle will not be able to write log info. If you dont backup, then disable archivelog mode.(I should say: then backup :), but be sure you understand consequences. You should not delete control files and redo log files, of course. How do I check upon the reason of failure of a particular query? The developer recalls that the message was something like low disc space. If you have SQL_TRACE parameter enabled for the whole database, see the .trc files in the directory set by USER_DUMP_DEST parameter. If not, than your developer probably didn't enabled it for the session as well and you canot see exact error message. Probably, as been told before, server couldn't extend datafile of system tablespace. Almost 100% sure, you problem has just been described by several people anwering here. Take the precautitions adviced. -- Alexandre TIA! Aleem -Original Message- Sent: Tuesday, June 04, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: Urgent: Retrieving Disk Space Aleem, Did you mention control files, redo log files, archive log files with recovery in mind? If so, you probably don't need it. Read next if you have all the files for the database on this one poor hard drive: Review the cause for create table as select... command. If it is the message like unable to allocate extent... something (don't remeber exact phrase) then your datafiles have AUTOEXTEND ON option. Once they extended to take all the space on the disk, you've got the error message. And your log information has probably also noticeable grown as Jack sad in another answer. You can shrink you datafile(s). But should not trash you archive logs (unless of course you want to have you database safe). To get rid of archive log info you may perform a full backup. -- Alexandre Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't successful i.e., the table couldn't get created. However the database size has grown enormous almost occupying the whole disc space. There are control files, redo log files, archive log files. What to do? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing
Re: profile
DBMS_RESOURCE_MANAGER does just that. See tha manual (supplied PL/SQL packages reference) and Metablink. On 2002.06.04 04:08 Otakar Mouèka wrote: Hello guru How can I set a performance of CPU for 1 session at 15 % in profile I hawe Oracle 8.1.7 . R 3 . Thanks Oto -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Otakar =?iso-8859-2?q?Mou=E8ka?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 connection
hai all. my database connection has a problem. when user start to establish connection... an error returns End of communication channel. So no user can log in. I've already checked the status of listener , reinstall net8 component, trace file. Seems those are oke. what should i do ? thanks rgds fico -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Softhome - Fico INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 connection
Hi, It's a client side message. You say trace files OK. did you turn on tracing on the client and tried it. Should've generated a trace file when tracing turned on. Jack Softhome - Fico ficomail@softhomTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] e.net cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: oracle connection [EMAIL PROTECTED] 04-06-2002 14:08 Please respond to ORACLE-L hai all. my database connection has a problem. when user start to establish connection... an error returns End of communication channel. So no user can log in. I've already checked the status of listener , reinstall net8 component, trace file. Seems those are oke. what should i do ? thanks rgds fico -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Softhome - Fico INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of
Re: oracle connection
End of communication channel is common message when server process is terminated. You may take a look at alert.log on server-side to see what could cause it to terminate. It's often there. Also trace file for that session on the server. -- Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:08 PM hai all. my database connection has a problem. when user start to establish connection... an error returns End of communication channel. So no user can log in. I've already checked the status of listener , reinstall net8 component, trace file. Seems those are oke. what should i do ? thanks rgds fico -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Softhome - Fico INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DataWarehouse Design Training
Hello! Can anyone recommend a good training class on DataWarehouse design/implementation? I have a basic understanding of the concepts,etc from reading books, but would like a hands-on course to get more of a feel for the subject. TIA Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DataWarehouse Design Training
Check the Datawarehouse Institute : http://www.dw-institute.com --- Toepke, Kevin M [EMAIL PROTECTED] a écrit : Hello! Can anyone recommend a good training class on DataWarehouse design/implementation? I have a basic understanding of the concepts,etc from reading books, but would like a hands-on course to get more of a feel for the subject. TIA Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: trial version of Oracle Financial ??
Leslie, Even if you do get a trial version, there is a slim chance that you could get it working without the help of consultants and Oracle support. I often ask folks at our company if anybody ever considered Quickbooks. These tier 1 financial systems are applications from hell! Jay [EMAIL PROTECTED] 06/03/02 05:53PM Ron, That's fine for everything BUT E-Business Applications (and isn't that what most people want?) from the web page - * We do not offer trial licenses for our E-Business Suite Applications. Leslie, Be prepared to spend at least $40 and LOTS of learning time to install to try. I don't think trial versions come with support - and I'm not sure it can be done without patches and many (sometimes hundreds, depending on how many and which modules) iTars. The Vision database is the seeded database with somewhat useful data. Margaret -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: trial version of Oracle Financial ?? Leslie, Go to the Oracle web site and click on the store icon and check out the CDPACKS for $40 each. You can get anything for your own play evaluation purposes. Ron ROR mô¿ôm [EMAIL PROTECTED] 06/03/02 04:58PM Hi, Does anyone know where to get a trial version of Oracle Financial, or other components of 11i? Thank you! Leslie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrade peopletools 7.5 to People tools 8 and Oracle upgrade to 8.1.7.3
Hi List, Anybody on the list gone through above upgrade that would like to share the pitfalls. THX Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Complex Integrity Checking
Normalize your application so that tables describe only one type of objects and do not implement row_type flags. When the design is streamlined you'll be able to use unique constraints. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Subject: Complex Integrity Checking Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Complex Integrity Checking
I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been
RE: Upgrade Question
FWIW : Here is what we have been doing to keep a tab on this oraInventory stuff and make 8.1.6, 8.1.7, 9.0.1 releases work on the same server with their respective patches etc. 1) Keep a separate oraInst.loc file for each release, by renaming it (oraInst.loc.816, oraInst.loc.817 etc) so that there is none with default name (oraInst.loc). 2) Prior to installing Oracle s/w, we set ORACLE_BASE to ORACLE_HOME, so that the oraInventory directory for that release is created in the respective ORACLE_HOME. By default it is created in ORACLE_BASE. (As Ron mentioned, there is a Note on Metalink about this. I forget the Note#. Sorry.) 3) Prior to patching a particular Oracle release, we rename the corresponding oraInst.loc.NNN file to the default name (oraInst.loc), set ORACLE_BASE to ORACLE_HOME, run Installer to apply the patch. Also, we create the 'oui' directory within the respective ORACLE_HOME. We let the Java VM stuff take Oracle's defaults. This process adds more work in the steps while applying patch sets. And we do need to *remember* to follow this process. But is has been working fine without any problems. We came up with this process when our patching of 8.1.6.2 aborted for some reason, but it left the oraInventory directory in a corrupted state and prevented me from re-running the patching process. Per Oracle Support, the corruption in oraInventory directory structures is irreparable, and I had to install 8.1.6.0 and start again. Hope this helps... Regards, - Kirti -Original Message- Sent: Monday, June 03, 2002 8:09 PM To: Multiple recipients of list ORACLE-L You said: There isn't a separate orainventory for each ORACLE_HOME. A single orainst.loc file defines where orainventory is located, and the Not necessarily (and not recommended). It is very easy to setup an orainventory file for each installation. Check metalink for details. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. stuff deleted -- 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: Complex Integrity Checking
Hi iulian, In the row level insert, update trigger you can log somewhere (in package PL/SQL-table or in other table) changes you are making. Than in the stalement level triggers AFTER UPDATE, INSERT you may perform you checks and raise an exception if needed. You cannot access modified table from row level triggers, but can do that from statement level trigger. And this is the only way to go. Of course, you can check it on Application level, but that's another story. This is not a strait forward way for checking for duplicate values. Try to re-state your requirements. Make use of additional calculated columns maybe, that you can to use regular unique constraints of Oracle. Perhaps, function-based indexes could help you. HTH, -- Alexandre Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Complex Integrity Checking
maybe I'm being simplistic and I know this will impact performance but why not simply do a select to see if the condition exists before the insert or update? --- [EMAIL PROTECTED] wrote: I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed.
SQL*Loader question
Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Complex Integrity Checking
I'm reticent about putting the checking code in the application before insertupdate statement, although I'm not sure why. I'm just thinking about concurency and all the implications. On the other hand I wanted to put the bussiness rules on the database side. Anyway, I'll use this approach, you told me, after all. But what if after I check for overlapped intervals, but before inserting, another user insert another record with an interval extending over mine. I know it sounds crazy but I really like to know how this kind of stuff are implemented. That's the way the unique values constraint work, I guess, and I'd like to know more about it. iulian -Original Message- Sent: Tuesday, June 04, 2002 6:24 PM To: Multiple recipients of list ORACLE-L maybe I'm being simplistic and I know this will impact performance but why not simply do a select to see if the condition exists before the insert or update? --- [EMAIL PROTECTED] wrote: I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat
RE: SQL*Loader question
I don't know if you can load the first 100 records, but you could load the last 100 by setting the skip value to the total - 100. HTH, Beth -Original Message- Sent: Tuesday, June 04, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: Oracle and Tru64
Tru64 = 5.0 being desupported for new releases of 9i is OK. We are upgrading our Tru64 installations from 4.0F to 5.1/5.1A along with the database upgrades to 9iRelease2. But Tru64 on Alpha, as such, will continue for some more years. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, 03 June, 2002 11:18 PM Well, from a browse of Metalink, if your on a version of TRU64 = 5.0 you are desupported. Dick Goulet Reply Separator Author: Hemant K Chitale [EMAIL PROTECTED] Date: 6/3/2002 6:53 AM I'd never heard that Oracle has stopped or is stopping support for Tru64. We have more than 35 production databases on Tru64 and have no intention of moving out of Alpha-Tru64 in a hurry. We're even looking at upgrading a mission critical 8iOPS cluster on Tru64 to 9iRAC on Tru64. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, 02 June, 2002 9:28 PM Stephane Faroult wrote: ...Historically, Oracle was a port to Digital (remember this brand?) Interesting. I'm reading this list because of a recent project to retire the Digital-Alpha workstations. The main reason that these machines must be de-commissioned is because Oracle stopped supporting Tru64. (Although it needs to be done EVENTUALLY, since Alpha is basicly dead anyway.) The Alphas were bought to retire the VMS from 4-7 years ago! Talk about unfortunate planning! -- Aaron Birenboim | The top three attributes of a good programmer: Albuquerque, NM |Laziness, Impatience, and Hubris [EMAIL PROTECTED] | boim.com/~aaron | -- Randall Schwartz, author of perl references -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aaron Birenboim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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*Loader question
I don't know of any such option in sqlloader. But, you can do one thing copy the 100 records from the file and create a new file and try to load that one. Hope this helps. Regards, Inder -Original Message- Sent: Tuesday, June 04, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle Migration Questions
1. You'd have to do a fresh *install* of 8.1.7 + Patchset 1 or higher on the F15K. Copying an OUI-installed ORACLE_HOME [and attempting to relink it] is not supported. 2. You can copy the Database Files and just startup the database. [unless you change the mount points / directory names in which case you must do an ALTER DATABASE RENAME FILE before you OPEN the database]. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, 04 June, 2002 7:18 AM Migrating 35 Oracle 8.1.7.1 instances, all on external EMC disk, from: Sun E10K domain running Solaris 8 maint 04/01 to: Sun F15K domain running Solaris 8 maint 02/02 These instances support CRP, conversion and development for the Banner ERP -- Higher Ed from SCT Corp. Apps will be installed on F15K with Forte for Java and MicroFocus COBOL. Questions: 1) Would you relink Oracle binaries on F15K? 2) Would you export/import from E10K to F15K? DBA, Server Support, App Dev and ERP Project Management disagree on procedure, even though we're in the midst of our second complete migration of three Sun Enterprise servers in the past six months and all have been gloriously successful! Thanks in advance for weighing in on this!! Carole Stephenson University of Illinois at Urbana-Champaign -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephenson, Carole INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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*Loader question
why not just create a smaller input file? head -100 ...filename... testfilename and use the test file? --- Ball, Terry [EMAIL PROTECTED] wrote: Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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: Complex Integrity Checking
Title: RE: Complex Integrity Checking I would look into combining a before-insert row-level trigger with an autonomous transaction procedure. The procedure would execute the validating query using parameters passed by the trigger. If your new row values would cause an overlap then return a user defined exception to the trigger. The trigger should trap this exception and cause a failure in the transaction. I think it would work something like this: You attempt to insert an interval that will violate your rule. In the trigger on INTERVALS you pass the 2 :NEW values to the procedure. The procedure queries INTERVALS and sees the table as it existed before your insert but does not cause a mutating table condition (because it's defined as an autonomous transaction procedure.) The procedure finds that the new row will cause an overlap and returns an exception. The trigger receives an exception and propagates it with some meaningful message. The insert fails. Let us know how (if) this works for you. Tony Aponte -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: Complex Integrity Checking I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.ro To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde
RE: SQL*Loader question
Terry - Use Unix head command to create a small test file. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 04, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Alert on Upgrades to 9.2.0.1
Corruption / Internal Errors Possible after Upgrading a Database to Oracle 9.2.0.1It is vital that you read this alert if upgrading to Oracle 9.2.0.1 from an earlier release Versions Affected This problem affects Oracle databases upgraded from pre-9.0.1 to 9.0.1.X and then to 9.2.0.1. Platforms Affected The problem is GENERIC - all platforms are affected. Description Silent database corruption and / or internal ORA-600 errors can occur if an Oracle database is upgraded as follows: An object is created in a pre-9.0 database The database is upgraded to Oracle 9.0.1 (any Patch Set level) and the object is truncated. The database is subsequently upgraded to Oracle 9.2.0.1 and inserts performed on the object. If any previously truncated objects in the database use FREELIST GROUPS then data corruption can occur in the above scenario . (FREELIST GROUPS are generally used in Parallel Server (OPS) or Real Application Clusters (RAC) environments but may exist in single instance databases.) Where FREELIST GROUPS are not used freelist corruption can occur which results in internal ORA-600 errors when the truncated object/s are inserted into. Likelihood of Occurrence There is a strong possibility of hitting this problem for databases upgraded as described above. The problem is most likely to occur on heavily used objects and only where TRUNCATE has been used in 9.0.1. Data corruption can only occur when the truncated object has FREELIST GROUPS but this corruption can affect any other object in the database. This problem does not affect automatic space managed segments. Possible Symptoms The possible symptoms of this issue include: Database corruption of any object in the database. Corruption can occur if an object with FREELIST GROUPS has been truncated in 9.0 as the bug can leave a freelist entry pointing at space which is no longer part of the truncated object. In this case an insert into this incorrect "free" block can corrupt some other database object. Hence a number of different errors can occur when the affected block is accessed. For objects without FREELIST GROUPS an insert using the bad freelist entry is like to result in an ORA-600 [ktsgsp5] or ORA-600 [kdddgb2] error in the inserting session. In this case the actual freelist is corrupt but the ORA-600 prevents any subsequent data corruption. Workaround If you are Upgrading / Planning to upgrade After upgrading to Oracle9i Release 2 (9.2) the freelists should be rebuilt for all objects which fit the above scenario, especially if they use FREELIST GROUPS. This should be done PRIOR to any insert activity on the database: Identify any objects using FREELIST GROUPS. These are the most important objects to rebuild the freelists for if they have been truncated: SELECT * FROM dba_segments WHERE freelist_groups1; Identify any objects which may have been truncated. The following query will show objects which may have been truncated in the past (it will also show indexes which have had ALTER INDEX .. REBUILD used on them, and similar operations). SET PAGES 1000 SET LINES 200 SELECT object_type, owner, substr(object_name,1,30) object_name, subobject_name, created FROM dba_objects o, sys.clu$ c WHERE object_id!=data_object_id AND data_object_id=c.dataobj#(+) AND ( c.dataobj# is null /* Not in a CLUSTER */ OR c.obj# = object_id /* OR is the cluster itself */ ) ORDER BY 1,2,3 ; For each of these objects rebuild its freelists using the DBMS_REPAIR.REBUILD_FREELISTS procedure, starting with the object which have FREELIST GROUPS.Eg: execute dbms_repair.rebuild_freelists('SCOTT','EMP',null,dbms_repair.table_object);See Detecting and Repairing Data Block Corruption in the Database Administrators Guide for details of using this procedure. Note that you should rebuild freelists for all potentially affected objects REGARDLESS of whether they have FREELIST GROUPS or not. If DBMS_REPAIR.REBUILD_FREELISTS reports an error for any objects make a note of the details and contact Oracle Support. If you have already encountered a corruption If you have already upgraded and encountered a corruption from this problem the only solution is to rebuild the affected object/s. If you encounter the ORA-600 [ktsgsp5] or ORA-600 [kdddgb2] No data corruption should have occurred - only the objects freelist is corrupt. It should be possible to rebuild the freelists as described above. Note that these ORA-600 errors do not mean you have hit this particular problem - these errors can have other root causes. Patches This bug will be fixed in Oracle 9.2.0.2 . Patches for this bug for 9.2.0.1 can be found on Metalink by
RE: Oracle and Tru64
It's a shame that Digital had such good computer scientists and such lousy marketing. Digital Unix and the AlphaServer were the most stable Unix boxes in the world. Compaq never did understand the gem it purchased and HP will never admit that their current generation of hardware was outclassed by Digital 10 years ago. All good runs must come to an end. It is just too bad that the end is an execution by technical nitwits. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Stephane, Hemant Below is the official word that I pulled off HP's website. It is straight PR material, so read between the words as you choose. As I recall, Compaq had already decided not to build the next-generation Alpha chip before the merger arose. If you are interested, I would suggest that you attend the HP roadshow when it comes to a city near you and ask them the hard questions yourself. Having worked for a computer manufacturer in the past, I can assure you that the manufacturer would appreciate it if you bought the last system to come off the production line, then never called them for support. My company plans to continue operating our Tru64 systems for several years to come, and they have provided wonderful service. But we're purchasing new Sun systems. In this session, an HP Executive will highlight the important current and future role HP's business critical and high performance AlphaServer(tm) products play. We will also discuss the latest advancements across the hp AlphaServer product family, the latest on the future Itanium® processor family, and provide an update on the related operating systems strategy. In particular, we will share the updated OpenVMS(tm) roadmap for continued development and support on the AlphaServer platform as well as a review of the progress to date for porting OpenVMS to Itanium®-based systems. Discussion will also include the most up-to-the-minute plans for integrating Tru64(tm) UNIX® into HP-UX on the Itanium® architecture and the continued development and support of Tru64 UNIX on the AlphaServer platform. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 03, 2002 9:53 AM To: Multiple recipients of list ORACLE-L I'd never heard that Oracle has stopped or is stopping support for Tru64. We have more than 35 production databases on Tru64 and have no intention of moving out of Alpha-Tru64 in a hurry. We're even looking at upgrading a mission critical 8iOPS cluster on Tru64 to 9iRAC on Tru64. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, 02 June, 2002 9:28 PM Stephane Faroult wrote: ...Historically, Oracle was a port to Digital (remember this brand?) Interesting. I'm reading this list because of a recent project to retire the Digital-Alpha workstations. The main reason that these machines must be de-commissioned is because Oracle stopped supporting Tru64. (Although it needs to be done EVENTUALLY, since Alpha is basicly dead anyway.) The Alphas were bought to retire the VMS from 4-7 years ago! Talk about unfortunate planning! -- Aaron Birenboim | The top three attributes of a good programmer: Albuquerque, NM |Laziness, Impatience, and Hubris [EMAIL PROTECTED] | boim.com/~aaron | -- Randall Schwartz, author of perl references -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aaron Birenboim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services
Database link performance
Title: Message Hi, Could anybody help me with thedatabase link problem? I have two databases db_A and db_B, and link from db_A to db_B. In the database db_B there is table B with 1.6 million records. I created simple test to query data from the table B via database link (I am connected to db_A) - declare v_record B%rowtype; cursor cB is select * from [EMAIL PROTECTED] where rownum 2; begin for c in cB loop v_record :=c; end loop; end; --- I tried to check performance of data querying through the link, so I had two tests: - via the link 19.8 sec - locally 1.5 sec Difference is too large, as far as I can expect! I have been REALLY surprised. At this time there was mostly no other activity on the network (databases are on the same subnet, at the same hierarchical level). Could anybody explain is it normal results? Thanks, Michael Rosenblum, Dulcian Inc.
Re: Oracle and Tru64
1. Per Oracle's Platform Strategy Advisory [last updated 28-May-02], Tru64 Unix will continue to be Supported. 2. Per Compaq at http://www.compaq.com/hps/download/Tru64UNIX_OpenVMS_Times_Rev2_052202.pdf from http://www.compaq.com/hps/commitment.html a. HP plans to sell AlphaServers till at least 2006 and support till at least 2011. b. Tru64Unix will sell till at least 2006 and support till at least 2011 [of course, it will be renamed as hp Tru64 Unix]. c. Tru64 features will start appearing in HPUX from 11.23 in 2003 and HPUX with TruCluster and ADVFS in 2004. d. Tru64Unix will NOT be ported to Itanium. It will be HPUX that will go to Itanium. The years 2006 and 2011 are sufficiently far in the future : Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, 03 June, 2002 11:53 PM Stephane, Hemant Below is the official word that I pulled off HP's website. It is straight PR material, so read between the words as you choose. As I recall, Compaq had already decided not to build the next-generation Alpha chip before the merger arose. If you are interested, I would suggest that you attend the HP roadshow when it comes to a city near you and ask them the hard questions yourself. Having worked for a computer manufacturer in the past, I can assure you that the manufacturer would appreciate it if you bought the last system to come off the production line, then never called them for support. My company plans to continue operating our Tru64 systems for several years to come, and they have provided wonderful service. But we're purchasing new Sun systems. In this session, an HP Executive will highlight the important current and future role HP's business critical and high performance AlphaServer(tm) products play. We will also discuss the latest advancements across the hp AlphaServer product family, the latest on the future Itanium® processor family, and provide an update on the related operating systems strategy. In particular, we will share the updated OpenVMS(tm) roadmap for continued development and support on the AlphaServer platform as well as a review of the progress to date for porting OpenVMS to Itanium®-based systems. Discussion will also include the most up-to-the-minute plans for integrating Tru64(tm) UNIX® into HP-UX on the Itanium® architecture and the continued development and support of Tru64 UNIX on the AlphaServer platform. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 03, 2002 9:53 AM To: Multiple recipients of list ORACLE-L I'd never heard that Oracle has stopped or is stopping support for Tru64. We have more than 35 production databases on Tru64 and have no intention of moving out of Alpha-Tru64 in a hurry. We're even looking at upgrading a mission critical 8iOPS cluster on Tru64 to 9iRAC on Tru64. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, 02 June, 2002 9:28 PM Stephane Faroult wrote: ...Historically, Oracle was a port to Digital (remember this brand?) Interesting. I'm reading this list because of a recent project to retire the Digital-Alpha workstations. The main reason that these machines must be de-commissioned is because Oracle stopped supporting Tru64. (Although it needs to be done EVENTUALLY, since Alpha is basicly dead anyway.) The Alphas were bought to retire the VMS from 4-7 years ago! Talk about unfortunate planning! -- Aaron Birenboim | The top three attributes of a good programmer: Albuquerque, NM |Laziness, Impatience, and Hubris [EMAIL PROTECTED] | boim.com/~aaron | -- Randall Schwartz, author of perl references -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aaron Birenboim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
Package with DB-Link including recursive function call returns in
we've created a package which analyzes data in a remote database and fills a table with the results of the analysis in the local db. in order to analyze the data across the db-link it's necessary to call a function recursively as shown in the script below. the function GET_PHYSICAL_DATACHANNEL is called recursively. the function IS_EVAL analyzes the data of the remote db using a synonym which describes the db-link. we are using Oracle 8.1.6 at the remote site, and 9.0.1 at the local site, this was also tested with Oracle Version 9.0.1 at both sites. when executing the package the select statement as you can see in IS_EVAL returns the result with the previous p_iDatachannelID, this happens after a couple of regards, Thomas Schmid CREATE OR REPLACE PACKAGE BODY DBI_PROFILE IS FUNCTION IS_EVAL(p_iDatachannelID IN PLS_INTEGER) RETURN BOOLEAN IS v_iRetCode PLS_INTEGER := 0; v_iState PLS_INTEGER := 0; v_iEvalCnt PLS_INTEGER := 0; BEGIN SELECT count(id) INTO v_iEvalCnt FROM dbi_datachannel_lnk_def WHERE result_channel_id = p_iDatachannelID; IF (v_iEvalCnt 0) THEN RETURN TRUE; ELSE RETURN FALSE; END IF; RETURN TRUE; END IS_EVAL; FUNCTION GET_PHYSICAL_DATACHANNEL(p_iDatachannelID IN PLS_INTEGER) RETURN PLS_INTEGER IS v_fIsEval BOOLEAN := FALSE; v_iDatachannelIDPLS_INTEGER := p_iDatachannelID; BEGIN -- the datachannel represents a evaluation ??? v_fIsEval := IS_EVAL(v_iDatachannelID); IF (v_fIsEval) THEN v_iDatachannelID := GET_PHYSICAL_DATACHANNEL(v_iDatachannelID); ELSE RETURN v_iDatachannelID; END IF; END GET_PHYSICAL_DATACHANNEL; BEGIN -- initializes the package END DBI_PROFILE; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schmid Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Complex Integrity Checking
I don't believe that you can check for overlapping interval within a database trigger. For that, you'd need two tables: one to enter interval and one to check against. Of course, the second table should also be populated, most likely by a 'AFTER INSERT' trigger. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Complex Integrity Checking I'm reticent about putting the checking code in the application before insertupdate statement, although I'm not sure why. I'm just thinking about concurency and all the implications. On the other hand I wanted to put the bussiness rules on the database side. Anyway, I'll use this approach, you told me, after all. But what if after I check for overlapped intervals, but before inserting, another user insert another record with an interval extending over mine. I know it sounds crazy but I really like to know how this kind of stuff are implemented. That's the way the unique values constraint work, I guess, and I'd like to know more about it. iulian -Original Message- Sent: Tuesday, June 04, 2002 6:24 PM To: Multiple recipients of list ORACLE-L maybe I'm being simplistic and I know this will impact performance but why not simply do a select to see if the condition exists before the insert or update? --- [EMAIL PROTECTED] wrote: I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** ** ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** ** ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: linux vs any other os
Although not very scientific, this one is always fun to watch. http://srom.zgp.org/ Good Luck, Ed -Original Message- Sent: Monday, June 03, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Hi All, Anyone have any sites where they are doing performance compares of linux vs solaris or any other OS. TiA, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Complex Integrity Checking
iulian - If it makes you feel better, write a PL/SQL procedure to do the checking and always call it rather than the table directly. That way you've put your rule in the database. If you are going to adhere to this philosophy, you're going to be into PL/SQL in a big way. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 04, 2002 11:08 AM To: Multiple recipients of list ORACLE-L I'm reticent about putting the checking code in the application before insertupdate statement, although I'm not sure why. I'm just thinking about concurency and all the implications. On the other hand I wanted to put the bussiness rules on the database side. Anyway, I'll use this approach, you told me, after all. But what if after I check for overlapped intervals, but before inserting, another user insert another record with an interval extending over mine. I know it sounds crazy but I really like to know how this kind of stuff are implemented. That's the way the unique values constraint work, I guess, and I'd like to know more about it. iulian -Original Message- Sent: Tuesday, June 04, 2002 6:24 PM To: Multiple recipients of list ORACLE-L maybe I'm being simplistic and I know this will impact performance but why not simply do a select to see if the condition exists before the insert or update? --- [EMAIL PROTECTED] wrote: I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde.
Re: More parses than eecutes
It is the application code or the interface drivers... For example, if you SQL trace an application executing through ODBC from connect to disconnect, you'll see lots of statements like SELECT * FROM table-or-view where they only parse but never execute. My guess is that the ODBC driver is using those calls to perform rough describes or something of that purpose. I see it more often from the MS-supplied ODBC drivers for Oracle rather than the Oracle-supplied ODBC drivers. The Oracle-supplied drivers tend to query ALL_OBJECTS directly, instead... I don't know if you're using ODBC and MS-supplied Oracle ODBC drivers in particular, but that's one possible scenario. If they're not using ODBC, then the PSFT tools may themselves be doing something similar as a platform-independent way of get descriptions of database objects...? One trick to get good SQL traces from connect to disconnect for specific user accounts: embed the DBMS_SESSION.SET_SQL_TRACE procedure inside an AFTER LOGON database-event trigger (i.e. Oracle8i new feature) for a specific user account. Once created, you can enable and disable the trigger to turn tracing on and off. Just remember to disable (or drop) this trigger when you're done tracing -- otherwise you'll *never* forget the time when you forgot! I learned the hard way, and its a good thing the production DBAs affected were so good-natured about it (beers all around go a long way!)... Hope this helps... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 7:38 AM Hi All, From where comes the problem that when I check v$sqlarea v$sqltext I get 2 executes and 4 parses or something similar. Why would a statement that executes once be parsed twice? Oracle 8.1.7.3 People tools 8 THX === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: foreign key what???? help!!
Title: RE: foreign key what help!! Nope!! -Original Message-From: Magaliff, Bill [mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 7:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE: foreign key what help!! are you loading more than one table? could you be loading child records b4 the parents are inserted? -bill -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 6:13 PMTo: Multiple recipients of list ORACLE-LSubject: RE: foreign key what help!! Okay guys, Have foreign keys defined on large dw tables. When loading get foreign key errors. However, after load (w/o change in data and supposedly data it was barking on) could create fk's just fine on the same data elements involving the same data - I SWEAR. This does not make sense to me. Any ideas?
RE: Database link performance
Title: Message Use a 10046 level-8 trace, and the resulting trace file will show what is significantly impacting your time. I would expect its either the time tallied to SQL*Net message from dblink or a difference in execution plans. Cary Millsap Hotsos Enterprises, Ltd. [EMAIL PROTECTED] http://www.hotsos.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Michael Rosenblum Sent: Tuesday, June 04, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject: Database link performance Hi, Could anybody help me with thedatabase link problem? I have two databases db_A and db_B, and link from db_A to db_B. In the database db_B there is table B with 1.6 million records. I created simple test to query data from the table B via database link (I am connected to db_A) - declare v_record B%rowtype; cursor cB is select * from [EMAIL PROTECTED] where rownum 2; begin for c in cB loop v_record :=c; end loop; end; --- I tried to check performance of data querying through the link, so I had two tests: - via the link 19.8 sec - locally 1.5 sec Difference is too large, as far as I can expect! I have been REALLY surprised. At this time there was mostly no other activity on the network (databases are on the same subnet, at the same hierarchical level). Could anybody explain is it normal results? Thanks, Michael Rosenblum, Dulcian Inc.
Docs dilemna Was: Where is README
There it is! I knew someone would know...however, in 8.1.7 it was a text file, now it's html. So my problem is now how to enable our system analysts/developers who do not have x-windows to view these files. We have an apache server running--the ideal solution would be to create an alias for a doc directory and copy all html files there. However, there are almost 1200 html files, not all install docs, many called index.html. I could copy the html files with their directory structure...or tell the developers to go to technet!!! Thanks for the help. Debi At 06:28 PM 6/3/2002 -0800, Lyubomir Petrov wrote: What about $ORACLE_HOME/rdbms/doc/README_rdbms.htm? HTH Lyubomir Petrov - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 03, 2002 4:48 PM I can't find the generic rdbms README anywhere on my server for 9iR2. There are 42 readme.txt files on the server in a variety of formats/cases making it difficult to find: README.txt, readme.txt, Readme.txt, and even readmeXX.txt where XX is a one or more character code. Some are in specific product doc subdirectories, but not all...others are in a higher doc directory. Where is the RDBMS server readme that must have been installed with 9iR2 software? Thanks, Debi -- 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: Lyubomir Petrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Debi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Type problems with PL/SQL function as a Java wrapper.
Hey all, Trying to get into this new fangled Java thingy in 8.1.7.2.0 on HP/UX. Simple OS exec test, mostly plagarized: // qlp.java import java.lang.Runtime; import java.lang.Process; import java.io.IOException; import java.lang.InterruptedException; public class qlp { public static int main(String args) { int retval = 0; try { String lpCommand; lpCommand = /usr/bin/lp + args; Process p = Runtime.getRuntime().exec(lpCommand); try { p.waitFor(); } catch (InterruptedException intexc) { System.out.println(Interrupted Exception on waitFor: + intexc.getMessage()); } retval = p.exitValue(); } catch (IOException e) { e.printStackTrace(); } return (retval); } } // End of Java code I run javac to compile it, then loadjava the class file into the DB. I can then create a PL/SQL procedure as a wrapper: CREATE OR REPLACE PROCEDURE qlp_proc (file_and_parms IN VARCHAR2) AS LANGUAGE JAVA NAME 'qlp.main (java.lang.String[])'; / And it works, but I need to test for success/fail. But if I try a FUNCTION wrapper: CREATE OR REPLACE FUNCTION qlp_func (file_and_parms IN VARCHAR2) RETURN NUMBER AS LANGUAGE JAVA NAME 'qlp.main (java.lang.String[]) return int'; / I get PLS-00311: the declaration of qlp.main (java.lang.String[]) return int is incomplete or malformed. Two questions: 1) Every example I've seen of the wrapper excludes the brackets from the java.lang.String parameter def, but I can't get a compile without it. Why? And 2) Anyone know what's wrong with my FUNCTION def? Desperately needing a good Java tutorial, too! TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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).
RE: SQL*Loader question
$ sqlldr help=y userid ORACLE username/password control Control file name log Log file name bad Bad file name dataData file name discard Discard file name discardmax Number of discards to allow skipNumber of logical records to skip loadNumber of logical records to load -Original Message- Sent: Tuesday, June 04, 2002 12:09 PM To: Multiple recipients of list ORACLE-L I don't know if you can load the first 100 records, but you could load the last 100 by setting the skip value to the total - 100. HTH, Beth -Original Message- Sent: Tuesday, June 04, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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*Loader question
It is supported on the machines that have implemented RPM instruction in their CPUs. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL*Loader question I don't know of any such option in sqlloader. But, you can do one thing copy the 100 records from the file and create a new file and try to load that one. Hope this helps. Regards, Inder -Original Message- Sent: Tuesday, June 04, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cache vs. Oracle
Title: RE: foreign key what help!! Okay, I admit it I am somewhat of an Oracle bigot. Does anyone have objective comparisons between Cache vs. Oracle or any opinions on subject?
Re: SQL*Loader question
Get a copy of SQL*Loader the Definitive Guide by Gennick Mishra / O'Reilly. You can use command-line parameters in the control file via a the OPTIONS command. For example: OPTIONS (parameter=value[,parameter=value...]) You can use: SKIP=logical_record_count LOAD=logical_record_count (the number of records to load) etc. You can also extract the number of rows you want to load and place the data in the control file. Use the keyword BEGINDATA data data data My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 11:53 AM $ sqlldr help=y userid ORACLE username/password control Control file name log Log file name bad Bad file name dataData file name discard Discard file name discardmax Number of discards to allow skipNumber of logical records to skip loadNumber of logical records to load -Original Message- Sent: Tuesday, June 04, 2002 12:09 PM To: Multiple recipients of list ORACLE-L I don't know if you can load the first 100 records, but you could load the last 100 by setting the skip value to the total - 100. HTH, Beth -Original Message- Sent: Tuesday, June 04, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: foreign key what???? help!!
Title: RE: foreign key what help!! Nope, The parent table has remained unchanged since early April. -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 7:28 PMTo: Multiple recipients of list ORACLE-LSubject: RE: foreign key what help!! It is probably a question of timing when Child records are loaded before Parents. It can be a question of table order or even record order (self referencing relationship). Once the data is loaded, enforcement of the constraint is easy because all of the data exists. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 4:13 PMTo: Multiple recipients of list ORACLE-LSubject: RE: foreign key what help!! Okay guys, Have foreign keys defined on large dw tables. When loading get foreign key errors. However, after load (w/o change in data and supposedly data it was barking on) could create fk's just fine on the same data elements involving the same data - I SWEAR. This does not make sense to me. Any ideas?
RE: SQL*Loader question
Terry, Type SQLLDR at the command prompt, and all the help is displayed. The answer to your question is : sqlldr load=50 will load only 50 records. Another option is to copy your data file and delete everything except for the number of records to load for testing purposes. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 04, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has records in the 6 digit range. I'd like to test the controlfile, but I don't want to load the whole file. Is there a way to tell loader to only load, say the 1st 100 records? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database link performance
Title: Message Level 8? I was using level 10 for all events. -Original Message-From: Cary Millsap [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002 1:33 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database link performance Use a 10046 level-8 trace, and the resulting trace file will show what is significantly impacting your time. I would expect its either the time tallied to SQL*Net message from dblink or a difference in execution plans. Cary Millsap Hotsos Enterprises, Ltd. [EMAIL PROTECTED] http://www.hotsos.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Michael RosenblumSent: Tuesday, June 04, 2002 11:18 AMTo: Multiple recipients of list ORACLE-LSubject: Database link performance Hi, Could anybody help me with thedatabase link problem? I have two databases db_A and db_B, and link from db_A to db_B. In the database db_B there is table B with 1.6 million records. I created simple test to query data from the table B via database link (I am connected to db_A) - declare v_record B%rowtype; cursor cB is select * from [EMAIL PROTECTED] where rownum 2; begin for c in cB loop v_record :=c; end loop; end; --- I tried to check performance of data querying through the link, so I had two tests: - via the link 19.8 sec - locally 1.5 sec Difference is too large, as far as I can expect! I have been REALLY surprised. At this time there was mostly no other activity on the network (databases are on the same subnet, at the same hierarchical level). Could anybody explain is it normal results? Thanks, Michael Rosenblum, Dulcian Inc.
Re:RE: Oracle and Tru64
Peter, Please allow me to disagree. I came from the USAF with a very deep love for DEC hardware and software (VAX/VMS), only to be VERY disappointed by them when I was presented with DEC Ultrix. Their straying into the Unix world was a real nightmare. First off their sales folks over sold the capabilities of the 5000/240 workstation. A database server it was not. Ultrix was a failure right out of the gate. That monster combination was a guarantee that I would get a page every night that it was here and the server a re-boot. It finally took me three years to get a Ultrix tech to admit that they had not implemented a TCP_KEEP_ALIVE capability into Ultrix and that I would never see it. At that time the only path was to upgrade to an Alpha with OSF-1 which was crashing on a daily basis. Oracle back then recommended a cold backup of the database twice a day. One of the soccer dads whose's daughter was on the same team as mine was a DEC/Compaq employee. His recommendation was to stay away from OSF at all costs. He was one of the lucky ones when Compaq sold off the CASE tools operation. Oh how I would have loved moving back onto a VAX, but DEC was not interested in that platform any more and HP's 9000 platform was not only cheaper to acquire and support, but faster and more capable as well. We benchmarked a DEC Ultrix box specifically tailored by DEC to database work against an HP9000 that 'just happen to between owners'. The DEC was a multi processor unit, stuffed with every bite of RAM it could hold, multi scsi ports with load balancing on their (at that time) best disk system and a custom Oracle install with a highly tuned (by DEC engineers) Ultrix kernel. We passed then a dmp file with 1 million rows of data for two tables and 4 SQL scripts to run against the data. Took them all day to get the results. Did the same test with the HP that had minimal RAM, one scsi port and only the internal drives and a default Oracle install and only that tweaking of the HP kernel in Oracle's install manual. Same test ran in 4.5 hours hands down. I left DEC behind at that time, never to return. As of today, I love the HP's I have to work with. I do not believe them to be outclassed anywhere and that they do outclass all in terms of reliability and dependability. I must admit to really enjoying a server platform that does it's job day in and day out for months or years without so much as a burp. I'm sure that part of that are three very good SA's, but the hardware/OS speaks for itself as well. I did not shed one tear when DEC fell to Compaq, and will not now that Compaq is falling to HP. I am sure that the good of DEC/Compaq will find it's way into HP-UX as well as the HP9000 series. So we've only good things to look forward to. Dick Goulet Reply Separator Author: Peter Barnett [EMAIL PROTECTED] Date: 6/4/2002 8:08 AM It's a shame that Digital had such good computer scientists and such lousy marketing. Digital Unix and the AlphaServer were the most stable Unix boxes in the world. Compaq never did understand the gem it purchased and HP will never admit that their current generation of hardware was outclassed by Digital 10 years ago. All good runs must come to an end. It is just too bad that the end is an execution by technical nitwits. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Stephane, Hemant Below is the official word that I pulled off HP's website. It is straight PR material, so read between the words as you choose. As I recall, Compaq had already decided not to build the next-generation Alpha chip before the merger arose. If you are interested, I would suggest that you attend the HP roadshow when it comes to a city near you and ask them the hard questions yourself. Having worked for a computer manufacturer in the past, I can assure you that the manufacturer would appreciate it if you bought the last system to come off the production line, then never called them for support. My company plans to continue operating our Tru64 systems for several years to come, and they have provided wonderful service. But we're purchasing new Sun systems. In this session, an HP Executive will highlight the important current and future role HP's business critical and high performance AlphaServer(tm) products play. We will also discuss the latest advancements across the hp AlphaServer product family, the latest on the future ItaniumR processor family, and provide an update on the related operating systems strategy. In particular, we will share the updated OpenVMS(tm) roadmap for continued development and support on the AlphaServer platform as well as a review of the progress to date for porting OpenVMS to ItaniumR-based systems. Discussion will also include the most up-to-the-minute plans for integrating Tru64(tm) UNIXR into HP-UX on the ItaniumR architecture and the continued development and support
RE: linux vs any other os
Ite misa est, Linux is the best! -Original Message- From: Sherman, Edward [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: linux vs any other os Although not very scientific, this one is always fun to watch. http://srom.zgp.org/ Good Luck, Ed -Original Message- Sent: Monday, June 03, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Hi All, Anyone have any sites where they are doing performance compares of linux vs solaris or any other OS. TiA, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cache vs. Oracle
Title: RE: foreign key what help!! Cache? What is cache? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Cache vs. Oracle Okay, I admit it I am somewhat of an Oracle bigot. Does anyone have objective comparisons between Cache vs. Oracle or any opinions on subject?
db link service name resolution via Oracle Names?
Has anyone had success gettin db links to resolve service names using Oracle Names? seem to recall reading something that required the local TNS entry for db links to successfully resolve, but also read that Names automatically creates a global db link for every service name registered with it. bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and Tru64
Guess we had different experiences. OSF was being replaced in favor of digital unix when I started my sys admin days on DECs. They were also Oracle's preferred platform at the time. Things have changed a lot since then. --- [EMAIL PROTECTED] wrote: Peter, Please allow me to disagree. I came from the USAF with a very deep love for DEC hardware and software (VAX/VMS), only to be VERY disappointed by them when I was presented with DEC Ultrix. Their straying into the Unix world was a real nightmare. First off their sales folks over sold the capabilities of the 5000/240 workstation. A database server it was not. Ultrix was a failure right out of the gate. That monster combination was a guarantee that I would get a page every night that it was here and the server a re-boot. It finally took me three years to get a Ultrix tech to admit that they had not implemented a TCP_KEEP_ALIVE capability into Ultrix and that I would never see it. At that time the only path was to upgrade to an Alpha with OSF-1 which was crashing on a daily basis. Oracle back then recommended a cold backup of the database twice a day. One of the soccer dads whose's daughter was on the same team as mine was a DEC/Compaq employee. His recommendation was to stay away from OSF at all costs. He was one of the lucky ones when Compaq sold off the CASE tools operation. Oh how I would have loved moving back onto a VAX, but DEC was not interested in that platform any more and HP's 9000 platform was not only cheaper to acquire and support, but faster and more capable as well. We benchmarked a DEC Ultrix box specifically tailored by DEC to database work against an HP9000 that 'just happen to between owners'. The DEC was a multi processor unit, stuffed with every bite of RAM it could hold, multi scsi ports with load balancing on their (at that time) best disk system and a custom Oracle install with a highly tuned (by DEC engineers) Ultrix kernel. We passed then a dmp file with 1 million rows of data for two tables and 4 SQL scripts to run against the data. Took them all day to get the results. Did the same test with the HP that had minimal RAM, one scsi port and only the internal drives and a default Oracle install and only that tweaking of the HP kernel in Oracle's install manual. Same test ran in 4.5 hours hands down. I left DEC behind at that time, never to return. As of today, I love the HP's I have to work with. I do not believe them to be outclassed anywhere and that they do outclass all in terms of reliability and dependability. I must admit to really enjoying a server platform that does it's job day in and day out for months or years without so much as a burp. I'm sure that part of that are three very good SA's, but the hardware/OS speaks for itself as well. I did not shed one tear when DEC fell to Compaq, and will not now that Compaq is falling to HP. I am sure that the good of DEC/Compaq will find it's way into HP-UX as well as the HP9000 series. So we've only good things to look forward to. Dick Goulet Reply Separator Author: Peter Barnett [EMAIL PROTECTED] Date: 6/4/2002 8:08 AM It's a shame that Digital had such good computer scientists and such lousy marketing. Digital Unix and the AlphaServer were the most stable Unix boxes in the world. Compaq never did understand the gem it purchased and HP will never admit that their current generation of hardware was outclassed by Digital 10 years ago. All good runs must come to an end. It is just too bad that the end is an execution by technical nitwits. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Stephane, Hemant Below is the official word that I pulled off HP's website. It is straight PR material, so read between the words as you choose. As I recall, Compaq had already decided not to build the next-generation Alpha chip before the merger arose. If you are interested, I would suggest that you attend the HP roadshow when it comes to a city near you and ask them the hard questions yourself. Having worked for a computer manufacturer in the past, I can assure you that the manufacturer would appreciate it if you bought the last system to come off the production line, then never called them for support. My company plans to continue operating our Tru64 systems for several years to come, and they have provided wonderful service. But we're purchasing new Sun systems. In this session, an HP Executive will highlight the important current and future role HP's business critical and high performance AlphaServer(tm) products play. We will also discuss the latest advancements across the hp AlphaServer product family, the latest on the future ItaniumR processor family, and provide an update on the related operating systems strategy. In
RE: Complex Integrity Checking
Title: RE: Complex Integrity Checking Iulian, The solution for ORA-4091 is to create two triggers--a row level and a statement level. In the row level you simply record the values of :new.start_time and :new.end_time into a PL/SQL table. Then in the statement level trigger you perform the check based on the recorded values in the PL/SQL table. Record the values using a PL/SQL table in a package, that way you won't have to worry about simultaneous updates by different sessions. Something like this... Interval s date e date create or replace package INTERVAL_PACKAGE as type t_start is table of interval.s%TYPE index by binary_integer; type t_end is table of interval.e%TYPE index by binary_integer; v_s t_start; v_e t_end; v_count binary_integer :=0; end INTERVAL_PACKAGE; create or replace trigger RINTERVAL before insert or update on interval for each row begin /* recored new time intervals in interval_package */ interval_package.v_count := interval_package.v_count + 1; interval_package.v_s(interval_package.v_count) := :new.s; interval_package.v_e(interval_package.v_count) := :new.e; end RINTERVAL; create or replace trigger SInterval after insert or update on interval declare v_start interval.s%TYPE; --from pl/sql table v_end interval.e%TYPE; v_start_curr interval.s%TYPE; --from interval table v_end_curr interval.e%TYPE; begin /* loop through each date interval inserted or updated and verify no overlap */ for v_i in 1..interval_package.v_count loop v_start := interval_package.v_s( v_i ); v_end := interval_package.v_e( v_i ); /* TEST */ ...some test goes here... if ... then --raise_application_error(-2,'date overlap'||v_start||v_end); end if; end loop; interval_package.v_count := 0; interval_package.v_s.DELETE; interval_package.v_e.DELETE; end SInterval; / -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: Complex Integrity Checking I don't believe that you can check for overlapping interval within a database trigger. For that, you'd need two tables: one to enter interval and one to check against. Of course, the second table should also be populated, most likely by a 'AFTER INSERT' trigger. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Complex Integrity Checking I'm reticent about putting the checking code in the application before insertupdate statement, although I'm not sure why. I'm just thinking about concurency and all the implications. On the other hand I wanted to put the bussiness rules on the database side. Anyway, I'll use this approach, you told me, after all. But what if after I check for overlapped intervals, but before inserting, another user insert another record with an interval extending over mine. I know it sounds crazy but I really like to know how this kind of stuff are implemented. That's the way the unique values constraint work, I guess, and I'd like to know more about it. iulian -Original Message- Sent: Tuesday, June 04, 2002 6:24 PM To: Multiple recipients of list ORACLE-L maybe I'm being simplistic and I know this will impact performance but why not simply do a select to see if the condition exists before the insert or update? --- [EMAIL PROTECTED] wrote: I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.ro To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in
Re:RE: linux vs any other os
Interesting, Windows sucks harder that Linux rules!! BTW: anyone here on the Lindows Beta test?? Dick Goulet Reply Separator Author: Gogala; Mladen [EMAIL PROTECTED] Date: 6/4/2002 10:09 AM Ite misa est, Linux is the best! -Original Message- From: Sherman, Edward [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: linux vs any other os Although not very scientific, this one is always fun to watch. http://srom.zgp.org/ Good Luck, Ed -Original Message- Sent: Monday, June 03, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Hi All, Anyone have any sites where they are doing performance compares of linux vs solaris or any other OS. TiA, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: oracle connection
Hi, It's another bad error to diagnose. But, there should be a good note for ora-3113 at metalink. Also, If Oracle can not know that a process is being terminated, there will be no trace for this error. Because Oracle will not have a chance to dump trace file. regards... Alexandre Gorbatchev wrote: End of communication channel is common message when server process is terminated. You may take a look at alert.log on server-side to see what could cause it to terminate. It's often there. Also trace file for that session on the server. -- Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:08 PM hai all. my database connection has a problem. when user start to establish connection... an error returns End of communication channel. So no user can log in. I've already checked the status of listener , reinstall net8 component, trace file. Seems those are oke. what should i do ? thanks rgds fico -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Softhome - Fico INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]:RE: Oracle and Tru64
YUP they sure have. I wonder what they'll look like in another 20 years? Reply Separator Author: Peter Barnett [EMAIL PROTECTED] Date: 6/4/2002 10:31 AM Guess we had different experiences. OSF was being replaced in favor of digital unix when I started my sys admin days on DECs. They were also Oracle's preferred platform at the time. Things have changed a lot since then. --- [EMAIL PROTECTED] wrote: Peter, Please allow me to disagree. I came from the USAF with a very deep love for DEC hardware and software (VAX/VMS), only to be VERY disappointed by them when I was presented with DEC Ultrix. Their straying into the Unix world was a real nightmare. First off their sales folks over sold the capabilities of the 5000/240 workstation. A database server it was not. Ultrix was a failure right out of the gate. That monster combination was a guarantee that I would get a page every night that it was here and the server a re-boot. It finally took me three years to get a Ultrix tech to admit that they had not implemented a TCP_KEEP_ALIVE capability into Ultrix and that I would never see it. At that time the only path was to upgrade to an Alpha with OSF-1 which was crashing on a daily basis. Oracle back then recommended a cold backup of the database twice a day. One of the soccer dads whose's daughter was on the same team as mine was a DEC/Compaq employee. His recommendation was to stay away from OSF at all costs. He was one of the lucky ones when Compaq sold off the CASE tools operation. Oh how I would have loved moving back onto a VAX, but DEC was not interested in that platform any more and HP's 9000 platform was not only cheaper to acquire and support, but faster and more capable as well. We benchmarked a DEC Ultrix box specifically tailored by DEC to database work against an HP9000 that 'just happen to between owners'. The DEC was a multi processor unit, stuffed with every bite of RAM it could hold, multi scsi ports with load balancing on their (at that time) best disk system and a custom Oracle install with a highly tuned (by DEC engineers) Ultrix kernel. We passed then a dmp file with 1 million rows of data for two tables and 4 SQL scripts to run against the data. Took them all day to get the results. Did the same test with the HP that had minimal RAM, one scsi port and only the internal drives and a default Oracle install and only that tweaking of the HP kernel in Oracle's install manual. Same test ran in 4.5 hours hands down. I left DEC behind at that time, never to return. As of today, I love the HP's I have to work with. I do not believe them to be outclassed anywhere and that they do outclass all in terms of reliability and dependability. I must admit to really enjoying a server platform that does it's job day in and day out for months or years without so much as a burp. I'm sure that part of that are three very good SA's, but the hardware/OS speaks for itself as well. I did not shed one tear when DEC fell to Compaq, and will not now that Compaq is falling to HP. I am sure that the good of DEC/Compaq will find it's way into HP-UX as well as the HP9000 series. So we've only good things to look forward to. Dick Goulet Reply Separator Author: Peter Barnett [EMAIL PROTECTED] Date: 6/4/2002 8:08 AM It's a shame that Digital had such good computer scientists and such lousy marketing. Digital Unix and the AlphaServer were the most stable Unix boxes in the world. Compaq never did understand the gem it purchased and HP will never admit that their current generation of hardware was outclassed by Digital 10 years ago. All good runs must come to an end. It is just too bad that the end is an execution by technical nitwits. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Stephane, Hemant Below is the official word that I pulled off HP's website. It is straight PR material, so read between the words as you choose. As I recall, Compaq had already decided not to build the next-generation Alpha chip before the merger arose. If you are interested, I would suggest that you attend the HP roadshow when it comes to a city near you and ask them the hard questions yourself. Having worked for a computer manufacturer in the past, I can assure you that the manufacturer would appreciate it if you bought the last system to come off the production line, then never called them for support. My company plans to continue operating our Tru64 systems for several years to come, and they have provided wonderful service. But we're purchasing new Sun systems. In this session, an HP Executive will highlight the important current and future role HP's business critical and high performance AlphaServer(tm) products play. We will also discuss the
Remove Duplicates
I know I have seen this posted before... We have a large range partitioned table that has duplicates in it. What is the fastest way to remove the dups.? I have the following scripts which do it but may be fast or slow. What do you guys use? DELETE FROM tablename WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM tablename GROUP BY fieldnames); Or alter table table_name add constraint duplicate_cons unique key (column_name) exceptions into exception table; How to find duplicates: select column_name, count(column_name) from table_name group by column_name having count(column_name) 1; Tom
RE: Database link performance
Title: Message Michael, Queries across database link's are notoriusly slow. I've just been thru this and came to the conclusion that you should create views on the source database (in your case db_B) to limit the records to be queried via the db link. I'm not absolutely sure, but in my opinion, any "where" clauses get processed on the local machine. Your example provides further evidence. I would guess that Oracle is bringing all 1.6 million rows across the link first, and then applying the "rownum" clause after the fact. I've had this exact same scenario, except with a more complicated multi-table query where there are millions of rows in each table. When I did not use a view, the query literally ran forever (I gave up). When I created a view, joining all the tables together on the source machine, things worked reasonably well. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Michael Rosenblum [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002 12:18 PMTo: Multiple recipients of list ORACLE-LSubject: Database link performance Hi, Could anybody help me with thedatabase link problem? I have two databases db_A and db_B, and link from db_A to db_B. In the database db_B there is table B with 1.6 million records. I created simple test to query data from the table B via database link (I am connected to db_A) - declare v_record B%rowtype; cursor cB is select * from [EMAIL PROTECTED] where rownum 2; begin for c in cB loop v_record :=c; end loop; end; --- I tried to check performance of data querying through the link, so I had two tests: - via the link 19.8 sec - locally 1.5 sec Difference is too large, as far as I can expect! I have been REALLY surprised. At this time there was mostly no other activity on the network (databases are on the same subnet, at the same hierarchical level). Could anybody explain is it normal results? Thanks, Michael Rosenblum, Dulcian Inc.
RE: Complex Integrity Checking
Create a unique function based index on your table (start_time, end_time) that will return a number that uniquely identify the range. If an overlap took place you should get a duplicate error. I think you should use these PRAGMA's in the function code to fool Oracle that the function is very pure and does not see the changes that are happening, something like this. Hope it helps, Waleed -Original Message- Sent: Tuesday, June 04, 2002 10:38 AM To: Multiple recipients of list ORACLE-L I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden.
Re:RE: Oracle and Tru64
I never saw Ultrix but have heard other horror stories on this list and elsewhere. My first exposure to Dec was in '93 on the brand new Alpha's running openVMS. 64 bit and VLM long before any other vendor (and long before Oracle supported 64 bit, unfortunately)...and if the DEC wire-heads I worked for were right, a superior implementation of RISC architecture. Later on, we had to migrate our application to OSF which very soon after was renamed DEC Unix...which COMPAQ marketing renamed TRU64. Very fast and reliable. Now I get to do another platform migration in my spare time... Kip Bryant |Guess we had different experiences. OSF was being |replaced in favor of digital unix when I started my |sys admin days on DECs. They were also Oracle's |preferred platform at the time. Things have changed a |lot since then. |--- [EMAIL PROTECTED] wrote: | Peter, | | Please allow me to disagree. I came from the | USAF with a very deep love for | DEC hardware and software (VAX/VMS), only to be VERY | disappointed by them when I | was presented with DEC Ultrix. Their straying into | the Unix world was a real | nightmare. First off their sales folks over sold | the capabilities of the | 5000/240 workstation. A database server it was not. | Ultrix was a failure right | out of the gate. That monster combination was a | guarantee that I would get a | page every night that it was here and the server a | re-boot. It finally took me | three years to get a Ultrix tech to admit that they | had not implemented a | TCP_KEEP_ALIVE capability into Ultrix and that I | would never see it. At that | time the only path was to upgrade to an Alpha with | OSF-1 which was crashing on a | daily basis. Oracle back then recommended a cold | backup of the database twice a | day. One of the soccer dads whose's daughter was on | the same team as mine was a | DEC/Compaq employee. His recommendation was to stay | away from OSF at all costs. | He was one of the lucky ones when Compaq sold off | the CASE tools operation. Oh | how I would have loved moving back onto a VAX, but | DEC was not interested in | that platform any more and HP's 9000 platform was | not only cheaper to acquire | and support, but faster and more capable as well. | We benchmarked a DEC Ultrix | box specifically tailored by DEC to database work | against an HP9000 that 'just | happen to between owners'. The DEC was a multi | processor unit, stuffed with | every bite of RAM it could hold, multi scsi ports | with load balancing on their | (at that time) best disk system and a custom Oracle | install with a highly tuned | (by DEC engineers) Ultrix kernel. We passed then a | dmp file with 1 million rows | of data for two tables and 4 SQL scripts to run | against the data. Took them all | day to get the results. Did the same test with the | HP that had minimal RAM, one | scsi port and only the internal drives and a default | Oracle install and only | that tweaking of the HP kernel in Oracle's install | manual. Same test ran in 4.5 | hours hands down. I left DEC behind at that time, | never to return. As of | today, I love the HP's I have to work with. I do | not believe them to be | outclassed anywhere and that they do outclass all in | terms of reliability and | dependability. I must admit to really enjoying a | server platform that does it's | job day in and day out for months or years without | so much as a burp. I'm sure | that part of that are three very good SA's, but the | hardware/OS speaks for | itself as well. | | I did not shed one tear when DEC fell to Compaq, | and will not now that | Compaq is falling to HP. I am sure that the good of | DEC/Compaq will find it's | way into HP-UX as well as the HP9000 series. So | we've only good things to look | forward to. | | Dick Goulet | | Reply | Separator | Author: Peter Barnett [EMAIL PROTECTED] | Date: 6/4/2002 8:08 AM | | It's a shame that Digital had such good computer | scientists and such lousy marketing. Digital Unix | and | the AlphaServer were the most stable Unix boxes in | the | world. Compaq never did understand the gem it | purchased and HP will never admit that their current | generation of hardware was outclassed by Digital 10 | years ago. | | All good runs must come to an end. It is just too | bad | that the end is an execution by technical nitwits. | | | --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: | Stephane, Hemant |Below is the official word that I pulled off | HP's | website. It is | straight PR material, so read between the words as | you choose. As I recall, | Compaq had already decided not to build the | next-generation Alpha chip | before the merger arose. If you are interested, I | would suggest that you | attend the HP roadshow when it comes to a city | near | you and ask them the | hard questions yourself. Having worked for a | computer manufacturer in the | past, I can assure you that
RE: oracle connection
Title: RE: oracle connection Are you using MTS or dedicated connection? If MTS, first do a client trace, if that turns up nothing, just for kicks try adding (SERVER=dedicated) to your client tnsnames.ora file and see if allows you to log in by bypassing MTS. -Original Message- From: Danisment Gazi Unal (ubTools) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: oracle connection Hi, It's another bad error to diagnose. But, there should be a good note for ora-3113 at metalink. Also, If Oracle can not know that a process is being terminated, there will be no trace for this error. Because Oracle will not have a chance to dump trace file. regards... Alexandre Gorbatchev wrote: End of communication channel is common message when server process is terminated. You may take a look at alert.log on server-side to see what could cause it to terminate. It's often there. Also trace file for that session on the server. -- Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:08 PM hai all. my database connection has a problem. when user start to establish connection... an error returns End of communication channel. So no user can log in. I've already checked the status of listener , reinstall net8 component, trace file. Seems those are oke. what should i do ? thanks rgds fico -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Softhome - Fico INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:db link service name resolution via Oracle Names?
Just a couple of notes w/ names I just learned of when our primary Oracle names server failed. Change the default failover time using these parameters in your sqlnet.ora. NAMES.INITIAL_RETRY_TIMEOUT = 5 # Wait # Seconds before going to next nameserver, def=15 NAMES.REQUEST_RETRIES = 2 # Number of retries for nameserver, def=5 hth, Gene PS. 75 seconds sure appears to be a long time to fail, esp. when the help desk keeps calling :). [EMAIL PROTECTED] 06/04/02 02:53PM Bill, With Onames you don't need the TNSnames.ora file anymore. It does resolution of database service names automatically no matter if it's a database or client doing the lookup. Now previous versions of ONames did a very nice job of allowing you to create global database links, but version 8.1 messed that up REAL bad. Dick Goulet Reply Separator Author: Magaliff; Bill [EMAIL PROTECTED] Date: 6/4/2002 10:31 AM Has anyone had success gettin db links to resolve service names using Oracle Names? seem to recall reading something that required the local TNS entry for db links to successfully resolve, but also read that Names automatically creates a global db link for every service name registered with it. bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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:RE: Oracle and Tru64
I worked w/ ultrix, was horrendous! Dec OSF/1 never took off, better than Ultrix but bad unix. Then came Digital Unix, not bad, but still not the best. But I did like the advanced filesystem, esp. cloning filesets, great for quick backups! Gene [EMAIL PROTECTED] 06/04/02 03:13PM I never saw Ultrix but have heard other horror stories on this list and elsewhere. My first exposure to Dec was in '93 on the brand new Alpha's running openVMS. 64 bit and VLM long before any other vendor (and long before Oracle supported 64 bit, unfortunately)...and if the DEC wire-heads I worked for were right, a superior implementation of RISC architecture. Later on, we had to migrate our application to OSF which very soon after was renamed DEC Unix...which COMPAQ marketing renamed TRU64. Very fast and reliable. Now I get to do another platform migration in my spare time... Kip Bryant |Guess we had different experiences. OSF was being |replaced in favor of digital unix when I started my |sys admin days on DECs. They were also Oracle's |preferred platform at the time. Things have changed a |lot since then. |--- [EMAIL PROTECTED] wrote: | Peter, | | Please allow me to disagree. I came from the | USAF with a very deep love for | DEC hardware and software (VAX/VMS), only to be VERY | disappointed by them when I | was presented with DEC Ultrix. Their straying into | the Unix world was a real | nightmare. First off their sales folks over sold | the capabilities of the | 5000/240 workstation. A database server it was not. | Ultrix was a failure right | out of the gate. That monster combination was a | guarantee that I would get a | page every night that it was here and the server a | re-boot. It finally took me | three years to get a Ultrix tech to admit that they | had not implemented a | TCP_KEEP_ALIVE capability into Ultrix and that I | would never see it. At that | time the only path was to upgrade to an Alpha with | OSF-1 which was crashing on a | daily basis. Oracle back then recommended a cold | backup of the database twice a | day. One of the soccer dads whose's daughter was on | the same team as mine was a | DEC/Compaq employee. His recommendation was to stay | away from OSF at all costs. | He was one of the lucky ones when Compaq sold off | the CASE tools operation. Oh | how I would have loved moving back onto a VAX, but | DEC was not interested in | that platform any more and HP's 9000 platform was | not only cheaper to acquire | and support, but faster and more capable as well. | We benchmarked a DEC Ultrix | box specifically tailored by DEC to database work | against an HP9000 that 'just | happen to between owners'. The DEC was a multi | processor unit, stuffed with | every bite of RAM it could hold, multi scsi ports | with load balancing on their | (at that time) best disk system and a custom Oracle | install with a highly tuned | (by DEC engineers) Ultrix kernel. We passed then a | dmp file with 1 million rows | of data for two tables and 4 SQL scripts to run | against the data. Took them all | day to get the results. Did the same test with the | HP that had minimal RAM, one | scsi port and only the internal drives and a default | Oracle install and only | that tweaking of the HP kernel in Oracle's install | manual. Same test ran in 4.5 | hours hands down. I left DEC behind at that time, | never to return. As of | today, I love the HP's I have to work with. I do | not believe them to be | outclassed anywhere and that they do outclass all in | terms of reliability and | dependability. I must admit to really enjoying a | server platform that does it's | job day in and day out for months or years without | so much as a burp. I'm sure | that part of that are three very good SA's, but the | hardware/OS speaks for | itself as well. | | I did not shed one tear when DEC fell to Compaq, | and will not now that | Compaq is falling to HP. I am sure that the good of | DEC/Compaq will find it's | way into HP-UX as well as the HP9000 series. So | we've only good things to look | forward to. | | Dick Goulet | | Reply | Separator | Author: Peter Barnett [EMAIL PROTECTED] | Date: 6/4/2002 8:08 AM | | It's a shame that Digital had such good computer | scientists and such lousy marketing. Digital Unix | and | the AlphaServer were the most stable Unix boxes in | the | world. Compaq never did understand the gem it | purchased and HP will never admit that their current | generation of hardware was outclassed by Digital 10 | years ago. | | All good runs must come to an end. It is just too | bad | that the end is an execution by technical nitwits. | | | --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: | Stephane, Hemant |Below is the official word that I pulled off | HP's | website. It is | straight PR material, so read between the words as | you choose. As I recall, | Compaq had already decided not to build the |
RE: Type problems with PL/SQL function as a Java wrapper.
Main is a reserved function in Java you cannot use that in your programs. I just did this by changing the name to test. And it works. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Rich Sent: Tuesday, June 04, 2002 9:09 PM To: Multiple recipients of list ORACLE-L Hey all, Trying to get into this new fangled Java thingy in 8.1.7.2.0 on HP/UX. Simple OS exec test, mostly plagarized: // qlp.java import java.lang.Runtime; import java.lang.Process; import java.io.IOException; import java.lang.InterruptedException; public class qlp { public static int main(String args) { int retval = 0; try { String lpCommand; lpCommand = /usr/bin/lp + args; Process p = Runtime.getRuntime().exec(lpCommand); try { p.waitFor(); } catch (InterruptedException intexc) { System.out.println(Interrupted Exception on waitFor: + intexc.getMessage()); } retval = p.exitValue(); } catch (IOException e) { e.printStackTrace(); } return (retval); } } // End of Java code I run javac to compile it, then loadjava the class file into the DB. I can then create a PL/SQL procedure as a wrapper: CREATE OR REPLACE PROCEDURE qlp_proc (file_and_parms IN VARCHAR2) AS LANGUAGE JAVA NAME 'qlp.main (java.lang.String[])'; / And it works, but I need to test for success/fail. But if I try a FUNCTION wrapper: CREATE OR REPLACE FUNCTION qlp_func (file_and_parms IN VARCHAR2) RETURN NUMBER AS LANGUAGE JAVA NAME 'qlp.main (java.lang.String[]) return int'; / I get PLS-00311: the declaration of qlp.main (java.lang.String[]) return int is incomplete or malformed. Two questions: 1) Every example I've seen of the wrapper excludes the brackets from the java.lang.String parameter def, but I can't get a compile without it. Why? And 2) Anyone know what's wrong with my FUNCTION def? Desperately needing a good Java tutorial, too! TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Remove Duplicates
your second query will identify the rowids that are duplicates but will not delete them. You'd have to then go through the exceptions table to actually delete the rows. however, the exceptions table is a good way to get an idea of how many rows will be deleted. If you do have a large number of rows to be deleted that might cause either out of space on the rollback segment or an ora-1555, you can loop through that table and do intermittent commits while deleting. The first query is an all or nothing situation. I've used both ways, but tend to use the delete when it's a small table. --- Terrian, Tom [EMAIL PROTECTED] wrote: I know I have seen this posted before... We have a large range partitioned table that has duplicates in it. What is the fastest way to remove the dups.? I have the following scripts which do it but may be fast or slow. What do you guys use? DELETE FROM tablename WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM tablename GROUP BY fieldnames); Or alter table table_name add constraint duplicate_cons unique key (column_name) exceptions into exception table; How to find duplicates: select column_name, count(column_name) from table_name group by column_name having count(column_name) 1; Tom __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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).
FW: UPGRADE PROBLEM
Hi I have sent the following message to list this morning, but unfortunaitly havn't received any response for that, don't know is any body recived it or not? Your respond to this one is very valuable for me thanks -Original Message- From: Hamid Alavi Sent: Tuesday, June 04, 2002 7:45 AM To: 'ORACLE-L (E-mail) Subject: UPGRADE PROBLEM Hi List, I am still facing with my Upgrade Problem, Today I findout some thing which can be the cause of problem, Just want to check with you guys. I am using runInstaller for installing the patch4 on 8.1.7.0, today I just check the runInstaller and findout that there is a link for runInstaller to my 8.1.6 home directory, I mean I am using runInstaller 8.1.6 for this purpose, Now my question is this could be a problem or NOT, If this is a problem how can I change this link to point to the runInstaller to 8.1.7 instead. Here is more detail 8.1.7 home /u04/app/oracle 8.1.6 home .u01/app/oracle runinstaller under /u04/app/oracle/bin just a link to runinstaller on /u01/app/oui/install Can I just copy runinstaller 8.1.7 to /u01/app/oui/install directory and use the link or not? Thanks for your Help Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]:db link service name resolution via Oracle Names?
Jared, Onames 8.1 did not mess up global names, but it did mess up global database links. In the earlier versions you could specify what service name you wanted to use as a global database link to a server and what account it would loggin to. In 8.1 they made a real mess of that capability so now you've got to define database links in the database once again. Of course if you did not make use of database links before, your probably not affected. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 6/4/2002 11:10 AM Dick, How did 8.1 mess up global names? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/04/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:db link service name resolution via Oracle Names? Bill, With Onames you don't need the TNSnames.ora file anymore. It does resolution of database service names automatically no matter if it's a database or client doing the lookup. Now previous versions of ONames did a very nice job of allowing you to create global database links, but version 8.1 messed that up REAL bad. Dick Goulet Reply Separator Author: Magaliff; Bill [EMAIL PROTECTED] Date: 6/4/2002 10:31 AM Has anyone had success gettin db links to resolve service names using Oracle Names? seem to recall reading something that required the local TNS entry for db links to successfully resolve, but also read that Names automatically creates a global db link for every service name registered with it. bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle and Tru64
Well said, Peter. I always admired Digital technology and have come to appreciate its virtues even more after experiences with its competitors. A shame, indeed. --- Peter Barnett [EMAIL PROTECTED] wrote: It's a shame that Digital had such good computer scientists and such lousy marketing. Digital Unix and the AlphaServer were the most stable Unix boxes in the world. Compaq never did understand the gem it purchased and HP will never admit that their current generation of hardware was outclassed by Digital 10 years ago. All good runs must come to an end. It is just too bad that the end is an execution by technical nitwits. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Complex Integrity Checking
Pragma restrict_references is an old mechanism. The new trick is to declare function as deterministic. For pragma, the function had to be a part of a package. Deterministic function, on the other hand, does not have to be a part of anything. -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Complex Integrity Checking Create a unique function based index on your table (start_time, end_time) that will return a number that uniquely identify the range. If an overlap took place you should get a duplicate error. I think you should use these PRAGMA's in the function code to fool Oracle that the function is very pure and does not see the changes that are happening, something like this. Hope it helps, Waleed -Original Message- Sent: Tuesday, June 04, 2002 10:38 AM To: Multiple recipients of list ORACLE-L I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian ** ** ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** ** ** -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden
Re: Complex Integrity Checking
I think that something such as insert into my_table select new_start_time, new_end_time (both constants) from dual (well known view on x$dual) where not exists (select null from my_table where new_start_time between start_time and end_time union select null from my_table where new_end_time between start_time and end_time) should do the trick, making of course wildly optimistic assumptions about indices etc. And you can always check SQL%WHATITSNAME for the number of row processed if you need to keep track of rejects. Rachel Carmichael wrote: maybe I'm being simplistic and I know this will impact performance but why not simply do a select to see if the condition exists before the insert or update? --- [EMAIL PROTECTED] wrote: I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Remove Duplicates
Tom, EXCEPTIONS, without the shadow of a doubt. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:FW: UPGRADE PROBLEM
Normally I run the installer from the original CD. Dick Goulet Reply Separator Author: Hamid Alavi [EMAIL PROTECTED] Date: 6/4/2002 12:02 PM Hi I have sent the following message to list this morning, but unfortunaitly havn't received any response for that, don't know is any body recived it or not? Your respond to this one is very valuable for me thanks -Original Message- From: Hamid Alavi Sent: Tuesday, June 04, 2002 7:45 AM To: 'ORACLE-L (E-mail) Subject: UPGRADE PROBLEM Hi List, I am still facing with my Upgrade Problem, Today I findout some thing which can be the cause of problem, Just want to check with you guys. I am using runInstaller for installing the patch4 on 8.1.7.0, today I just check the runInstaller and findout that there is a link for runInstaller to my 8.1.6 home directory, I mean I am using runInstaller 8.1.6 for this purpose, Now my question is this could be a problem or NOT, If this is a problem how can I change this link to point to the runInstaller to 8.1.7 instead. Here is more detail 8.1.7 home /u04/app/oracle 8.1.6 home .u01/app/oracle runinstaller under /u04/app/oracle/bin just a link to runinstaller on /u01/app/oui/install Can I just copy runinstaller 8.1.7 to /u01/app/oui/install directory and use the link or not? Thanks for your Help Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Complex Integrity Checking
wouldn't an INSTEAD OF trigger solve the problem here? that way, he could program an insert/update any way he wants to... Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 04, 2002 4:26 PM To: Multiple recipients of list ORACLE-L I think that something such as insert into my_table select new_start_time, new_end_time (both constants) from dual (well known view on x$dual) where not exists (select null from my_table where new_start_time between start_time and end_time union select null from my_table where new_end_time between start_time and end_time) should do the trick, making of course wildly optimistic assumptions about indices etc. And you can always check SQL%WHATITSNAME for the number of row processed if you need to keep track of rejects. Rachel Carmichael wrote: maybe I'm being simplistic and I know this will impact performance but why not simply do a select to see if the condition exists before the insert or update? --- [EMAIL PROTECTED] wrote: I said something like the way the unique constraints work. Ok. Here's my context. I have a table say intervals and 2 columns start_time and end_time. I want to check for overlapped intervals. I know what conditions to check but I can't implement them. Thanks! iulian -Original Message- Sent: Tuesday, June 04, 2002 5:13 PM To: Multiple recipients of list ORACLE-L ** This email has been tested for viruses by F-Secure Antivirus administered by IT Network Department. ** Hi if unique does not suit your need what exactly do you need to check? duplicates: use primary key Jack Iulian.ILIES@oran ge.roTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Complex Integrity Checking 04-06-2002 15:58 Please respond to ORACLE-L Hi guys. Here's my problem. I want to check the new values (when insertingupdating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique constraint doesn't suit my needs. I think of a before insertupdate trigger, wherein checking my condition and raise a error if not valid. The problem is, in case of an update statement, I get the mutating ORA-04091 table my table is mutating. I read a lot of doc but I didn't find any helping ideas. Can you give me some, or maybe a new approach to this kind of problem? Thanks in advance! iulian -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UPGRADE PROBLEM
you did not install the new runInstaller for 817 so it is using the old version. You have to use the runInstaller from the CD or your install directory. Basically install the new runInstaller and you should be ok. -Original Message- Sent: Tuesday, June 04, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Hi List, I am still facing with my Upgrade Problem, Today I findout some thing which can be the cause of problem, Just want to check with you guys. I am using runInstaller for installing the patch4 on 8.1.7.0, today I just check the runInstaller and findout that there is a link for runInstaller to my 8.1.6 home directory, I mean I am using runInstaller 8.1.6 for this purpose, Now my question is this could be a problem or NOT, If this is a problem how can I change this link to point to the runInstaller to 8.1.7 instead. Here is more detail 8.1.7 home /u04/app/oracle 8.1.6 home .u01/app/oracle runinstaller under /u04/app/oracle/bin just a link to runinstaller on /u01/app/oui/install Can I just copy runinstaller 8.1.7 to /u01/app/oui/install directory and use the link or not? Thanks for your Help Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James 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: Database link performance
Michael, Did you try this with the DRIVING_SITE hint? (May not help, but worth trying). My understanding is that where a STOPKEY such as rownum is involved, the table (or the result of the query) would be brought across the dblink into the local TEMP tablespace and the STOPKEY applied lare on. What you are seeing is the time for the whole table to be brought across via the DBlink and the condition applied after that. A look at 'V$MYSTAT' for that session should normally show an inordinately large value for 'bytes received via SQL*Net from dblink', and you should also see corresponding waits on 'SQL*Net message from dblink. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Tuesday, June 04, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Hi, Could anybody help me with the database link problem? I have two databases db_A and db_B, and link from db_A to db_B. In the database db_B there is table B with 1.6 million records. I created simple test to query data from the table B via database link (I am connected to db_A) - declare v_record B%rowtype; cursor cB is select * from [EMAIL PROTECTED] where rownum 2; begin for c in cB loop v_record :=c; end loop; end; --- I tried to check performance of data querying through the link, so I had two tests: - via the link - 19.8 sec - locally- 1.5 sec Difference is too large, as far as I can expect! I have been REALLY surprised. At this time there was mostly no other activity on the network (databases are on the same subnet, at the same hierarchical level). Could anybody explain is it normal results? Thanks, Michael Rosenblum, Dulcian Inc. -- 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).
RE: Remove Duplicates
Hi Ferenc, Welcome back !! We missed you - Kirti -Original Message-From: Ferenc Mantfeld [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002 3:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Remove Duplicates Tom. Replies below. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia -Original Message-From: Terrian, Tom [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 4 June 2002 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: Remove Duplicates I know I have seen this posted before... We have a large range partitioned table that has duplicates in it. What is the fastest way to remove the dups.? I have the following scripts which do it but may be fast or slow. What do you guys use? DELETE FROM tablename WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM tablename GROUP BY fieldnames); [Ferenc Mantfeld]This will be your fastest way, provided you have an index on thecolumns searched for. Actually the format of the statement would be delete from INVOICE_DETAILS A where A.rowid (select min(rowid) from INVOICE_DETAILS B where B.INV_NUM=A.INV_NUM and B.LINE_NUM=A.LINE_NUM) ; Ensure you have a composite index on INVOICE_DETAILS (INV_NUM, LINE_NUM). Or alter table table_name add constraint duplicate_cons unique key (column_name) exceptions into exception table;[Ferenc Mantfeld]Problem with this is when you want to delete the duplicates, you have no way of telling, unless you code the min function again.If you have triplicates, andwant to keep one of them and blow away the other two, this is a tedious way,and all this does is to help you identify the duplicates. How to find duplicates: select column_name, count(column_name) from table_name group by column_name having count(column_name) 1; [Ferenc Mantfeld]Same as above. only identifies the duplicates, does nothing to remove them. Tom
any sql or pl/sql distribution list
Hi, Like this any sqlplus or pl/sql message board where I can clear doubts. Thanks, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: db link service name resolution via Oracle Names?
thanks to both of you . . . will change SQLNET params Dick - are you saying that Names v8i doesn't create the global db links any more? -Original Message- Sent: Tuesday, June 04, 2002 3:28 PM To: Multiple recipients of list ORACLE-L Just a couple of notes w/ names I just learned of when our primary Oracle names server failed. Change the default failover time using these parameters in your sqlnet.ora. NAMES.INITIAL_RETRY_TIMEOUT = 5 # Wait # Seconds before going to next nameserver, def=15 NAMES.REQUEST_RETRIES = 2 # Number of retries for nameserver, def=5 hth, Gene PS. 75 seconds sure appears to be a long time to fail, esp. when the help desk keeps calling :). [EMAIL PROTECTED] 06/04/02 02:53PM Bill, With Onames you don't need the TNSnames.ora file anymore. It does resolution of database service names automatically no matter if it's a database or client doing the lookup. Now previous versions of ONames did a very nice job of allowing you to create global database links, but version 8.1 messed that up REAL bad. Dick Goulet Reply Separator Author: Magaliff; Bill [EMAIL PROTECTED] Date: 6/4/2002 10:31 AM Has anyone had success gettin db links to resolve service names using Oracle Names? seem to recall reading something that required the local TNS entry for db links to successfully resolve, but also read that Names automatically creates a global db link for every service name registered with it. bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Production Database Open Fails after Mount
Solved Database OPENed Successfully on another HP-UX Box Without any ORA-1092 The Same Oracle OS Versions Existed on Both HP-UX Boxes . NOTE Though ORA-1092 was often succeeded by the message :- Error Num 23 NO Idea what Error Num 23 Stands for ? Thus This seems to be Some OS /Hardware Issue with the Previous Production Database on which the Database would NOT Open after OS RE_Installation . For Problem Details Go Below . For Complete Details Either E-mail me Or See Tar Nums - 2263888.995 , 9505435.7 (If accessible) Thanks to All List Vivek -Original Message- Sent: Monday, June 03, 2002 11:57 PM To: LazyDBA.com Discussion Hi Gopal,List What are those UNdocumented Events ? Thanks again Vivek -Original Message- Sent: Monday, June 03, 2002 4:51 PM To: LazyDBA.com Discussion Vivek: I guess SMON runs the command to get the details for regular cleanup. You can use few undocumented events to get the things done depending on the seriousness of the database. These events just asks the SMON to skip few things during recovery and pretty harmless. Best Regards, K Gopalakrishnan - Original Message - From: VIVEK_SHARMA [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Monday, June 03, 2002 4:29 PM Subject: RE: Production Database Open Fails after Mount Problem Still Existing . ora_3263.trc file :- ORA-01092: ORACLE instance terminated. Disconnection forced Current SQL statement for this session: select line#, sql_text from bootstrap$ where obj# != :1 bootstrap$ seems to tbe the CAUSE . Any Advice ? 1) STATUS in V$LOG shows 2 Groups as INACTIVE the 3rd as CURRENT NOTE - Log Switches are Happening even in Mount State due to some internal Database Activity at the rate of about 5 Switched in 12 Hours . Size of Redo Logfile = 5M 2) RECOVER DATABASE UNTIL CANCEL Succeeds , But ALTER DATABASE OPEN RESETLOGS Also Fails with ORA-1092 like ALTER DATABASE OPEN 3) We Created a SMALL Dummy Database on the Same machine using the Same ORACLE_HOME which we were able to open eith the Same SGA as the Production Database . Thus Prima-facie the O.S. Oracle S/w seem OK . We relinked the network rdbms Components of Oracle 7.3.4.0 too though 4) Due to Root Disk Crash OS was RE-Installed , But Oracle Software Existed Existed on another Hard Disk was Simply Mounted back without any Change after the OS RE-Installation 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 -- Author: VIVEK_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).
RE: Type problems with PL/SQL function as a Java wrapper.
Woo-hoo! That's it! Thanks, Ganesh! :) Look out World, I can print from an Oracle procedure now! ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Ganesh Raja [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 2:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Type problems with PL/SQL function as a Java wrapper. Main is a reserved function in Java you cannot use that in your programs. I just did this by changing the name to test. And it works. HTH Best Regards, Ganesh R -- 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).
custom DD views to allow users to see source without needing exe rights
Good afternoon co-listers, Recently we had a problem with TOAD and I thought I would share our solution. TOAD looks at the views ALL_ARGUMENTS and ALL_OBJECTS to see procedural code. Unless a user has the ability to execute a package/procedure/function, they cannot see the source code through these views, and can't see the source in TOAD. This limitiation is hard-coded in the view structure. Upon reflection, it occured to me that I could recreate these views in the users' schema, customized to remove the necessity of having execute priv to see the code, and since Oracle looks local first during object name resolution, it would probably use these views instead of the data dictionary views. This worked. The two views that I customized are below - feel free to use. jack silvey ALL_ARGUMENTS: select u.name owner, /* OWNER */ nvl(a.procedure$,o.name) object_name, /* OBJECT_NAME */ decode(a.procedure$,null,null, o.name) package_name, /*PACKAGE_NAME */ o.obj# object_id, /* OBJECT_ID */ decode(a.overload#,0,null,a.overload#) overload, /*OVERLOAD */ a.argument argument_name, /* ARGUMENT_NAME */ a.position# position, /* POSITION */ a.sequence# sequence, /* SEQUENCE */ a.level# data_level, /* DATA_LEVEL */ decode(a.type#, /* DATA_TYPE */ 0, null, 1, decode(a.charsetform, 2, 'NVARCHAR2', 'VARCHAR2'), 2, decode(a.scale, -127, 'FLOAT', 'NUMBER'), 3, 'NATIVE INTEGER', 8, 'LONG', 9, decode(a.charsetform, 2, 'NCHAR VARYING', 'VARCHAR'), 11, 'ROWID', 12, 'DATE', 23, 'RAW', 24, 'LONG RAW', 29, 'BINARY_INTEGER', 69, 'ROWID', 96, decode(a.charsetform, 2, 'NCHAR', 'CHAR'), 102, 'REF CURSOR', 104, 'UROWID', 105, 'MLSLABEL', 106, 'MLSLABEL', 110, 'REF', 111, 'REF', 112, decode(a.charsetform, 2, 'NCLOB', 'CLOB'), 113, 'BLOB', 114, 'BFILE', 115, 'CFILE', 121, 'OBJECT', 122, 'TABLE', 123, 'VARRAY', 178, 'TIME', 179, 'TIME WITH TIME ZONE', 180, 'TIMESTAMP', 181, 'TIMESTAMP WITH TIME ZONE', 231, 'TIMESTAMP WITH LOCAL TIME ZONE', 182, 'INTERVAL YEAR TO MONTH', 183, 'INTERVAL DAY TO SECOND', 250, 'PL/SQL RECORD', 251, 'PL/SQL TABLE', 252, 'PL/SQL BOOLEAN', 'UNDEFINED') data_type, default$ default_value, /* DEFAULT_VALUE */ deflength default_length, /* DEFAULT_LENGTH */ decode(in_out,null,'IN',1,'OUT',2,'IN/OUT','Undefi ned') in_out, /* IN_OUT */ length data_length, /* DATA_LENGTH */ precision# data_precision, /* DATA_PRECISION */ scale data_scale, /* DATA_SCALE */ radix radix, /* RADIX */ decode(a.charsetform, 1, 'CHAR_CS', /* CHARACTER_SET_NAME */ 2, 'NCHAR_CS', 3, NLS_CHARSET_NAME(a.charsetid), 4, 'ARG:'||a.charsetid) char_cs, a.type_owner type_owner, /* TYPE_OWNER */ a.type_name type_name, /* TYPE_NAME */ a.type_subname type_subname, /* TYPE_SUBNAME */ a.type_linkname type_link, /* TYPE_LINK */ a.pls_type pls_type /* PLS_TYPE */ from sys.obj$ o,sys.argument$ a,sys.user$ u where o.obj# = a.obj# and o.owner# = u.user# ALL_OBJECTS: select u.name owner, o.name object_name, o.subname subobject_name, o.obj# object_id, o.dataobj# data_object_id, decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 39, 'LOB PARTITION', 40, 'LOB SUBPARTITION', 43, 'DIMENSION', 44, 'CONTEXT', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 56, 'JAVA DATA', 'UNDEFINED') object_type, o.ctime created, o.mtime last_ddl_time, to_char(o.stime, '-MM-DD:HH24:MI:SS') timestamp, decode(o.status, 0, 'N/A', 1, 'VALID', 'INVALID') status, decode(bitand(o.flags, 2), 0, 'N', 2, 'Y', 'N') temporary, decode(bitand(o.flags, 4), 0, 'N', 4, 'Y', 'N') generated, decode(bitand(o.flags, 16), 0, 'N', 16, 'Y', 'N') secondary from sys.obj$ o, sys.user$ u where o.owner# = u.user# and o.linkname is null and (o.type# not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (o.type# = 1 and 1 = (select 1 from sys.ind$ i where i.obj# = o.obj# and i.type# in (1, 2, 3, 4, 6, 7, 9 and o.name != '_NEXT_OBJECT' and o.name != '_default_auditing_options_' union all select u.name, l.name, NULL, to_number(null), to_number(null), 'DATABASE LINK', l.ctime, to_date(null), NULL, 'VALID','N','N', 'N' from sys.link$ l, sys.user$ u where l.owner# = u.user# __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Remove Duplicates
Ferenc, I agree with your improvement on the first query but I disagree about your opinion about the EXCEPTIONS method. Especially if there are not too many (in proportion) duplicates you can remove them as follows : create table my_table_dup as select distinct * from my_table where rowid in (select row_id from exceptions); delete my_table where rowid in (select row_id from exceptions); insert into my_table select * from my_table_dup; Granted, not a single shot, but fairly straighforward and relatively easy to follow. The big advantage here is that you do one sort (the SELECT DISTINCT) but it is performed on the limited subset of the duplicate rows. All statements involved perform fast, and the current indexing is pretty irrelevant. Concerning the ADD CONSTRAINT itself, this is the kind of operation where the Oracle kernel guys usually write good code. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Production Database Open Fails after Mount
VIVEK_SHARMA wrote: Solved Database OPENed Successfully on another HP-UX Box Without any ORA-1092 The Same Oracle OS Versions Existed on Both HP-UX Boxes . NOTE Though ORA-1092 was often succeeded by the message :- Error Num 23 NO Idea what Error Num 23 Stands for ? Thus This seems to be Some OS /Hardware Issue with the Previous Production Database on which the Database would NOT Open after OS RE_Installation . For Problem Details Go Below . For Complete Details Either E-mail me Or See Tar Nums - 2263888.995 , 9505435.7 (If accessible) Thanks to All List Vivek grep 23 /usr/include/errno.h -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).