SSO on WinNT for Oracle 8iR3 + Web Forms 6i
Hi, did some one implement Web Forms using the Single Sign On concept from Oracle. Coudl you point me to some starting documents please? I have multiple Forms 6i application running on iAS 9i with Oracle 8iR3 databases and I have to implement SSO in a Windwos 2000 environment (server and client alike), but do not know how to start. Every help is highly appreciated. Thanks in advance, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Pentium 4 and Apache - Javac.exe aborts
Hi, I would like to ask, if any one on this list had the same experience as I. We have several desktop Compaq boxes with Windows 2000 installed. I tried to install Oracle 8i server and the Apache web server on one of them. I used the modified installer, as mentioned earlier on this list, to avoid the Pentium 4 related bug. Everything went fine, until I wanted to compile a servelt. The installed Apache javac.exe simply aborts, even without parameters. I checked with one other box - had the luxury to have an other clean box :-) - the result is was the same. Any comments? I feel a little bit lost, Oracle Support is ellaborating on this, but currently to no avail. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Strange problem with charactersets
Title: Strange problem with charactersets Execute the following query: select substr(parameter,1,30),substr(value,1,30) from sys.v_$nls_parameters order by 1; This way you will know the database`s nls settings. If the client has the same settings as the database, there will be no character conversion between the client and the database. If the characters are still displayed in a bad fashon on the client side, then data in the database is not correct andyou have to reloadit. HTH, Tamas Szecsy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 15, 2002 3:13 PMTo: Multiple recipients of list ORACLE-LSubject: Strange problem with charactersets Hi list, I have a strange problem with charctersets, character display. I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. On clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. Now I've installed a Windows 2000 PC with Oracle 8.1.7 client and here a the strange behaviours. Oracle 8.1.7 client shows instead of öäüß (german special characters) oau?. I've never seen this. Normally the special characters would be shown as unreadable signs. On client we tried these different NLS settings, but nothing works: NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 Windows 2000 territory settings are all to german. All infos are welcome. Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
RE: Strange problem with charactersets
Title: Strange problem with charactersets From Oracle 8i and up you do not have to recreate the database, you just have to issue an alter command and reload the data. Unfortunately this would not help Volker any further. Tamas Szecsy -Original Message-From: Nicolai Tufar [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 15, 2002 4:03 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Strange problem with charactersets Unfortunately the only solution is to recreate the database in German character set. Oracle is very strict in this respect. Database character set once chosen can not be changed. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 15, 2002 4:13 PM Subject: Strange problem with charactersets Hi list, I have a strange problem with charctersets, character display. I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. On clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. Now I've installed a Windows 2000 PC with Oracle 8.1.7 client and here a the strange behaviours. Oracle 8.1.7 client shows instead of öäüß (german special characters) oau?. I've never seen this. Normally the special characters would be shown as unreadable signs. On client we tried these different NLS settings, but nothing works: NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 Windows 2000 territory settings are all to german. All infos are welcome. Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
RE: (Fwd) iDS 9.0.2 / Forms 9i Available - migration path from De
Duncan, does / will iDS 9i support the migration of Designer 6i / Developer 6i projects to iDS 9i? I am not thinking of mouse over event, host command, OLE support features. This naturally will not work (I suppose). But it might be of importance for us wether we will have to rewrite our apps from scratch or there is a less painfull and gracefull path to follow. Thank you for your help in advance. Regards, Tamas Szecsy Geometria GIS Systems House Ltd. -Original Message- Sent: Saturday, May 04, 2002 4:13 AM To: Multiple recipients of list ORACLE-L --- Forwarded message follows --- Date sent: Fri, 03 May 2002 10:15:26 -0800 O D T U G - D E V 2 K - L @ f a t c i t y . c o m d u n c a n . m i l l s @ o r a c l e . c o m Organization: Fat City Network Services, San Diego, California For everyone who's been waiting for 9i wait no longer - (except for the download time of course...) http://technet.oracle.com/software/products/ids/content.html I'm an vacation for a week so hold off on all the complaints for at least that long - just kidding you'll love it! Regards Duncan Mills Senior Principal Product Manager Oracle Application Development Tools ... --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 1Z0-007 Exam
Hi, I would like to migrate a database to some somewhat different structure: - Make code table entries of a given table columns - Partionate one table into two separete tables - Convert code values in one database into code values of the other database - etc I could do it by hand and script, but is there an easier way? Do you know of any good tool? TIA, Tamas Szecsy -Original Message-From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]Sent: Saturday, April 13, 2002 1:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 1Z0-007 Exam Its not a Upgrade exam.. in fact its the first exam in Oracle 9i OCP core series -Original Message-From: John Hallas [mailto:[EMAIL PROTECTED]]Sent: Friday, April 12, 2002 12:58 PMTo: Multiple recipients of list ORACLE-LSubject: RE: 1Z0-007 Exam Ken, If this is the 9i upgrade exam then there was a discussion on this recently (about 3-4 weeks ago) Search the archives for a post by Mike Hateley and responses from Robert Freeman. If is not the 9i upgrade which exam is it? John -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of KENNETH JANUSZSent: 12 April 2002 16:26To: Multiple recipients of list ORACLE-LSubject: 1Z0-007 Exam Has anyone taken this exam? If so, I would like your feedback. Thanks, Ken Janusz, CPIM
RE: Stanby Database- Archive Transfer Problem
Title: Stanby Database- Archive Transfer Problem If you find a solution for this, I would be interested in it. We have the same problem, same platform. Somatimes SAP starts some kind of processing and the network load increases enormously. And the archive log transfer fails after a while. Tamas Szecsy -Original Message-From: Hussain Ahmed Qadri [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 04, 2002 10:28 AMTo: Multiple recipients of list ORACLE-LSubject: Stanby Database- Archive Transfer Problem Oracle 8.1.7 and WINNT4 Our Standby database was running smoothly but due to some reasons we had to reconfigure it. We have used the same init parameter file which we used earlier(to have the exact parameters). The standby database was configured alright but this time logs are not properly getting transfered to the standby database, I mean every 3rd or 4th archived log file doesn;t get transfered and is missed. Our 4 redo logs are 1mb and block size is 8192, Log_checkpoint_interval = 1 (the default) and log_checkpoit_timeout = 600 Archive processes are 10(this we had increased to 5 the last time to counter the missin files on our standby database,and it worked fine,but this time we have increased from 5 to 10 and its not) and the view v$Archive_dest shows that both primary and standby database locations are valid. Average time for log switch, under normal conditions, is roughly 12-15 mins, but for some reasons it starts getting missed after a regular transfer of 3-4 archive files. Our network is 10Mbps and is sllow off and on. What could be the reason for the delay. Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
View creation error on a table with grant through a role?
Hi, Is it normal that connect x/x select id, name from y_schema.table1; execuites fine, but connect x/x create or rpelace view v_myview( id, name) as select id, name from y_schema.table1; fails? User X has grants on y_schema's table1 through a role only. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: View creation error on a table with grant through a role?
:-O Thanks. Its funny. Could some one please point me to some online docs (OTN)? Just to see the logic behind this - for me unwanted - feature? Tamas -Original Message- Sent: Thursday, April 04, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Hi To create a view or procedure the rights have to be granten to the person directly and not through a role So yes, quite normal behaviour (maybe not wanted) Jack Szecsy Tamas tszecsy@GEOMETRITo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] A.hucc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: View creation error on a table with grant through a role? [EMAIL PROTECTED] 04-04-2002 13:28 Please respond to ORACLE-L Hi, Is it normal that connect x/x select id, name from y_schema.table1; execuites fine, but connect x/x create or rpelace view v_myview( id, name) as select id, name from y_schema.table1; fails? User X has grants on y_schema's table1 through a role only. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858
RE: View creation error on a table with grant through a role?
I have the grant via a role. You can not grant to a role with grant option! Tamas -Original Message- Sent: Thursday, April 04, 2002 2:39 PM To: Multiple recipients of list ORACLE-L you need grant with admin option for creating view on a table owned by someone else. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: View creation error on a table with grant through a role?
Thanks Jack! Tamas -Original Message- Sent: Thursday, April 04, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hi, From the online generic doc's version 8.1.7 * Data Definition Language Statements and Roles A user requires one or more privileges to successfully execute a data definition language (DDL) statement, depending on the statement. For example, to create a table, the user must have the CREATE TABLE or CREATE ANY TABLE system privilege. To create a view of another user's table, the creator requires the CREATE VIEW or CREATE ANY VIEW system privilege and either the SELECT object privilege for the table or the SELECT ANY TABLE system privilege. Oracle avoids the dependencies on privileges received by way of roles by restricting the use of specific privileges in certain DDL statements. The following rules outline these privilege restrictions concerning DDL statements: All system privileges and schema object privileges that permit a user to perform a DDL operation are usable when received through a role. Examples: System Privileges: the CREATE TABLE, CREATE VIEW and CREATE PROCEDURE privileges. Schema Object Privileges: the ALTER and INDEX privileges for a table. Exception: The REFERENCES object privilege for a table cannot be used to define a table's foreign key if the privilege is received through a role. All system privileges and object privileges that allow a user to perform a DML operation that is required to issue a DDL statement are not usable when received through a role. Example: A user who receives the SELECT ANY TABLE system privilege or the SELECT object privilege for a table through a role can use neither privilege to create a view on another user's table. The following example further clarifies the permitted and restricted uses of privileges received through roles: Example: Assume that a user is: Granted a role that has the CREATE VIEW system privilege Granted a role that has the SELECT object privilege for the EMP table, but the user is indirectly granted the SELECT object privilege for the EMP table Directly granted the SELECT object privilege for the DEPT table Given these directly and indirectly granted privileges: The user can issue SELECT statements on both the EMP and DEPT tables. Although the user has both the CREATE VIEW and SELECT privilege for the EMP table through a role, the user cannot create a usable view on the EMP table, because the SELECT object privilege for the EMP table was granted through a role. Any views created will produce errors when accessed. The user can create a view on the DEPT table, because the user has the CREATE VIEW privilege through a role and the SELECT privilege for the DEPT table directly. ** HTH Jack Szecsy Tamas tszecsy@GEOMETRITo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] A.hucc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: View creation error on a table with grant through a role? [EMAIL PROTECTED] 04-04-2002 15:08 Please respond to ORACLE-L :-O Thanks. Its funny. Could some one please point me to some online docs (OTN)? Just to see the logic behind this - for me unwanted - feature? Tamas -Original Message- Sent: Thursday, April 04, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Hi To create a view or procedure the rights have to be granten to the person directly and not through a role So yes, quite normal behaviour (maybe not wanted) Jack Szecsy Tamas tszecsy@GEOMETRITo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] A.hucc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: View creation error on a table with grant through a role? [EMAIL PROTECTED] 04-04-2002 13:28 Please respond to ORACLE-L Hi, Is it normal that connect x/x select id, name from y_schema.table1; execuites fine, but connect x/x create or rpelace view v_myview( id, name) as select id, name from y_schema.table1; fails? User X has grants on y_schema's table1 through a role only. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron
Hi, I know this is by far off topic, but if some one could help me with this I would be very grateful. I am running Oracle 9i on my home machine (Celeron 300 MHz) and it is pretty slow. I would like to upgrade either to Celeron 1.2 GHz or AMD XP 1400+ GHz. Apart from the (not negligible) cost differences I can not decide which solution would be better in respect to the Oracle 9i performance. Every one here at my company would like to persuade me to buy AMD, because it is MUCH faster than an Intel Celeron solution. Does this hold? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Off topic - Oracle 9i on W2k - AMD Athlon XP or Intel Celeron
Mark, thanks for your comments. Actually I do Forms developement on the maschine and some surfing and email handling. I do no shoot out gaming or video editing :-). I did not look at P4 because it had some problems with Ora9i installs and every body kept saying that AMD is much cheeper. Now I checked out the prices and actually a P4 1.3 hardly differs from the AMD prices. What currently I can not decide and where I need help is if the frontside bus speed of AMD is 266MHz with DDR RAM, while the P4 front side buss is the half of it. I do not know if it matters or not? Tamas -Original Message- Sent: Thursday, March 28, 2002 11:18 To: Multiple recipients of list ORACLE-L Celeron Tamas, I suppose this also depends on what else you use your home machine for? I run 9i on a P4 1.3GHz, and it screams (apart from the fragmented shared pool that I keep on getting - that I need to sort out when I get the time , tips anyone? ;P). Why not put P4 in to the equation? I know it had some bad press when it first came out, but subsequent benchmarks have shown it to be a stable and well performing processor.. Do you do internet gaming? If so, then it has to be either the P4 or the AMD (which supposedly has DirectX built directly in to the processor).. Same goes with any graphic designing.. There you go.. My recommendation would be either P4 or AMD, and since you don't have P4 on the list (and assuming your not willing to put it on the list) then AMD. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Tamas Sent: 28 March 2002 08:38 To: Multiple recipients of list ORACLE-L Hi, I know this is by far off topic, but if some one could help me with this I would be very grateful. I am running Oracle 9i on my home machine (Celeron 300 MHz) and it is pretty slow. I would like to upgrade either to Celeron 1.2 GHz or AMD XP 1400+ GHz. Apart from the (not negligible) cost differences I can not decide which solution would be better in respect to the Oracle 9i performance. Every one here at my company would like to persuade me to buy AMD, because it is MUCH faster than an Intel Celeron solution. Does this hold? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How Could I identify the OS user name?
Thanks, Tamas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: iFS - storing XML via Windows Explorer
No, because the user would like to use copy / paste. Tamas -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 10:09 To: Multiple recipients of list ORACLE-L Have you tried FTPing the file into iFS ? There should be a quote parsemodeoff in FTP. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Szecsy Tamas [EMAIL PROTECTED] 22/03/2002 12:28 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: iFS - storing XML via Windows Explorer Hi, we have a iFS instance. iFS lets you update an attribute of a file by copying a proper XML file into a directory and iFS interprets it as a command. If something is not O.K. with the file, it spits out an error file into the same directory. Now my problem is that I would like to store an XML file in an iFS direcotry by draging the XML file into the iFS directory in Windows Explorer. The result is that I get a error file. Does someone know of a way to override this feature? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
iFS - storing XML via Windows Explorer
Hi, we have a iFS instance. iFS lets you update an attribute of a file by copying a proper XML file into a directory and iFS interprets it as a command. If something is not O.K. with the file, it spits out an error file into the same directory. Now my problem is that I would like to store an XML file in an iFS direcotry by draging the XML file into the iFS directory in Windows Explorer. The result is that I get a error file. Does someone know of a way to override this feature? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
iFS ppt
Hi, Could someone please point me to some good iFS power point slides? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
selecting the nth value from a varray column
Hi, could someone please help me with this? I have a table where a column is of type varray of numbers. I need the 4th and 5th values that are coordinate values. How can I select only these columns` value? Every help will be highly appreciated. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: selecting the nth value from a varray column
I give an example, just to make clear what I mean:
How do I retrieve coordinate values from Oracle Spatial Object model?
1. Create a table:
create table sdo (geometry mdsys.sdo_geometry);
2. Insert a record with coordinate values ( 19.135147 and 47.021199 are the
coordinates)
insert into sdo
values(mdsys.sdo_geometry(2001,NULL,NULL,
mdsys.sdo_elem_info_array(1, 0, 6000, 4, 1,
1),
mdsys.sdo_ordinate_array(.13146,
2.1416E-07, -.1947, 19.135147, 47.021199))
);
Is there a method to retrieve the coordinate values with single select
statement similar to this
select s.geometrysomething1 x_coord, s.geometrysomething2 y_coord
from sdo s;
hopefully resulting this:
x_coord y_coord
--
19.135147 47.021199
Thanks,
Tamas Szecsy
-Original Message-
Sent: Wednesday, March 13, 2002 11:23
To: Multiple recipients of list ORACLE-L
Hi,
could someone please help me with this? I have a table where a column is of
type varray of numbers. I need the 4th and 5th values that are coordinate
values. How can I select only these columns` value?
Every help will be highly appreciated.
Tamas Szecsy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
I hope I aunderstood your issue see this:
rem ---
rem Filename: maxvalue.sql
rem Purpose:Select the Nth highest value from a table
rem Date: 18-Apr-2001
rem Author: Deepak Rai, SSE, Satyam Computer Services Ltd. India
rem ---
select level, max('col_name') from my_table
where level = 'n'
connect by prior ('col_name') 'col_name')
group by level;
-- Example :
--
-- Given a table called emp with the following columns:
-- id number
-- name varchar2(20)
-- sal number
--
-- For the second highest salary:
--
-- select level, max(sal) from emp
-- where level=2
-- connect by prior sal sal
-- group by level
--
Ciprian MAFTEI, Romania
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ciprian Maftei
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Excel's Oracle connectivity
Hi, some monthes back I read about a free utility that one could plugin to Excel. From then on Excel could read any data into it from Oracle. The SQL command could be written into the Excel sheets, so the user could refresh data any time he/she had Oracle connectivity and OLE connection. I forgot the link. Could some one please help me? (It was NOT Oraxcel!!) TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Excel's Oracle connectivity
It was a free utility, Oraxel is a commercial product. Tamas -Original Message- Sent: Monday, March 11, 2002 14:28 To: Multiple recipients of list ORACLE-L sqlxl maybe? -Oorspronkelijk bericht- Van: Szecsy Tamas [SMTP:[EMAIL PROTECTED]] Verzonden:maandag 11 maart 2002 14:13 Aan: Multiple recipients of list ORACLE-L Onderwerp:Excel's Oracle connectivity Hi, some monthes back I read about a free utility that one could plugin to Excel. From then on Excel could read any data into it from Oracle. The SQL command could be written into the Excel sheets, so the user could refresh data any time he/she had Oracle connectivity and OLE connection. I forgot the link. Could some one please help me? (It was NOT Oraxcel!!) TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Excel's Oracle connectivity
I was not too specific on my requirements :-) Yes MS Query is there, but it uses ODBC and it is so sl. This tool that I am looking for was able to store all information (including PL/SQL noname block, SQL queries) in a sheet and by pressing a button it updated the excel sheets' content. It was good for customers that needed data from the database to be displayed in an Excel diagramm, had OO4OLE installed and was selfdisciplined enough not to fidel with the SQL statements in the Excel sheet. -Original Message- Sent: Monday, March 11, 2002 15:03 To: Multiple recipients of list ORACLE-L Heh. ODBC? : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, March 11, 2002 9:13 AM To: Multiple recipients of list ORACLE-L Subject:Excel's Oracle connectivity Hi, some monthes back I read about a free utility that one could plugin to Excel. From then on Excel could read any data into it from Oracle. The SQL command could be written into the Excel sheets, so the user could refresh data any time he/she had Oracle connectivity and OLE connection. I forgot the link. Could some one please help me? (It was NOT Oraxcel!!) TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Excel's Oracle connectivity
Thanks for all who replied! Tamas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Disable certain users from login to database while applying H
Title: RE: Disable certain users from login to database while applying H I agree with using the revoke session solution. All the same you can change a user's password to something else and change it back again without ever knowing what it was: 1. select 'alter user scott identified by values '''||password||''';' from dba_users where username = 'SCOTT'; put away the result 2. change the password to something else 3. change the password back again to what it was previously: execute the result of the first point. Regards, Tamas Szecsy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, February 18, 2002 14:03To: Multiple recipients of list ORACLE-LSubject: RE: Disable certain users from login to database while applying H But then how do you know what to change it back to? I'd steer away from this - head w/ the revoke create session
RE: Standby Databse Problem
Title: Standby Databse Problem I had the same problem recently (NT4+SP6a, Oracle 8.1.7), my network bandwidth was too small for the copy process of archived logs whilea bulk load was running. I did not find a solution yet :-( Tamas Szecsy -Original Message-From: Hussain Ahmed Qadri [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 13, 2002 9:08To: Multiple recipients of list ORACLE-LSubject: Standby Databse Problem Hi, --Winnt 4.0, Oracle 8.1.7.--- We have slight problem with our Standby Database Configuration. All the archives from our Primary Database are not being copied to the Standby Database. When the archives are generated at a normal time, i.e after after a gap of 15-20 minutes ( which is normal, as our logfile size is 500K and it works fine with our normal database behaviour) , the archives get copied completely to the standby site. But due to a few jobs that run over night, the log switch happens very fast,a few times per minute. This kind of fast switching also happens incase of bulk insert or delete. Its in such cases that some of the archive logs are not copied to the standby site. To counter that, we increased the number of archiver processes from 1 to 4 on the Primary site, and when it didn't entirely solve our problem, we increased it to the maximum, i.e is 10. Even now all the archives are not being copied because of the quick switching of logs. Keeping the archiver processes to 10 is also a burden on the resources. Moreover, the second destination for writing archives(standby DB) is optional, and the value for log_archive_min_succeed_dest is set to 0. I am not sure increasing this or changing the site from optional to mandatory would solve the problem. Or would that have any effect? The other thing is that since the problem lies with the files not being copied from one site to the other, so it should not directly have anything to do with the Archiver processes, as server is generating archives properly. But on increasing the number of archiver processes, less number of files were not copied to the standby site, so it did help. Is there something we are missing here. Any help would be appreciated. Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk
RE: Oracle Lite 8i as snapshot site
My probem was, that Oracle Support still does not seem to be able to answer with a simple 'yes' or 'no', wether I can user Oracle Lite as a readonly snapshot site. The Oracle Lite documenation is only talking about EE as a must, but our cutomer has only SE licence. I would need only one way replication ( SE Lite ), that is a readonly replication. Tamas Szecsy -Original Message- Sent: Tuesday, February 12, 2002 15:28 To: Multiple recipients of list ORACLE-L Dick - I believe that some replication is available in Standard Edition. My company is looking to put Oracle in remote sites, with some modest replication, and wanted to avoid the licensing penalty of EE. As I read the Oracle document http://technet.oracle.com/products/oracle9i/pdf/o9i_family_features.pdf (table at the bottom), and it says SE has Basic Replication and EE has Advanced Replication. As I understand it, Basic Replication doesn't do multi-master replication, but snapshot replication should be fine. If anyone on the list can correct my understanding, because I certainly don't want to get a nasty Oracle licensing correction. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, February 11, 2002 9:43 PM To: Multiple recipients of list ORACLE-L To use snapshots or replication you need Enterprise edition. Lite is a single user edition for notebooks and the like Dick Goulet Reply Separator Author: Szecsy Tamas [EMAIL PROTECTED] Date: 2/11/2002 12:43 AM Hi, I would like to implement readonly replication on Oracle 8i Standard Edition with Oracle Lite 8i snapshot sites. Is Oracle Lite different in any way form Oracle SE what read only replication concerns? Can I run the same scripts for Oracle 8i as if I would use Oracle 8i SE for the sanpshot site or do I have to modify them? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Lite 8i as snapshot site
Hi, I would like to implement readonly replication on Oracle 8i Standard Edition with Oracle Lite 8i snapshot sites. Is Oracle Lite different in any way form Oracle SE what read only replication concerns? Can I run the same scripts for Oracle 8i as if I would use Oracle 8i SE for the sanpshot site or do I have to modify them? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Encrypting Oracle Stored procedures
http://technet.oracle.com/doc/oracle8i_816/appdev.816/a77069/c_wrap.htm#1859 Szecsy Tamas -Original Message- Sent: Monday, January 21, 2002 14:25 To: Multiple recipients of list ORACLE-L Dear All, Can anyone please tell me how to encrypt oracle stored procedures Thanks Regards, Brijesh __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: designer6i vs. designer2000
Designer 4 is here since some monthes, you have to download patch 4a from metalink. Tamas Szecsy -Original Message- Sent: Wednesday, January 16, 2002 14:45 To: Multiple recipients of list ORACLE-L Alas, the last time I looked, the OTN download for Designer was missing. The latest is Des6i release 4, which it said was 'coming soon' Simon Anderson Andrea, Designer 6i is the newest one - release 3. You can actually download it from OTN. Designer2000 was renamed to 6i after the Y2K hysteria calmed down (and Uncle Larry got on his i bandwagon). Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 16, 2002 1:05 AM To: Multiple recipients of list ORACLE-L Hi, Is Designer 2000 and Designer 6i similar? They are about data modeling, aren't they. If I'd like to learn one, which one do you recommended? Thanks! Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
checking free space on hard disk drive from RDBMS (Oracle 8i)
Hi, I would like to know if thwere is a way to check free space on a certain hard disk drive from stored proecedure on Windows NT and Oracle 8i. UTL_FILE does not seem to be able to do this for me. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: utl_file example
Thanks Gints,
this was the problem!
Tamas
Just in case
Do You have added correctly entries in utl_file_dir?
If I remeber correctly there was a difference between Unix and NT. On one
You need to put slash on the end, on another not.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Szecsy Tamas
tszecsy@GEOME To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
TRIA.hu cc:
Sent by: Subject: RE: utl_file example
[EMAIL PROTECTED]
om
2001.11.12
16:15
Please respond
to ORACLE-L
Nirmal,
do I have to set some OS acces rights? I get the following exception:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at SYS.UTL_FILE, line 98
ORA-06512: at SYS.UTL_FILE, line 157
ORA-06512: at line 4
If I handle the exception it turns out that it is invalide path. The only
thing I can think about is, that the sys user does not have access right to
the c:\ drive. Do you know, under what account is the utl_file accessing
the OS filesystem?
Tamas
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: utl_file example
Hi,
Verify UTL_FILE_DIR init.ora parameter is defined properly.
In FOPEN function specify, filepath and filename as separate.
[EMAIL PROTECTED] ;
1 DECLARE
2 fid UTL_FILE.FILE_TYPE;
3 BEGIN
4 fid := UTL_FILE.FOPEN('c:\','test.log','w');
5 UTL_FILE.PUT_LINE(fid, 'Test file for usage of UTL_FILE
package');
6 UTL_FILE.FCLOSE(fid);
7* END;
[EMAIL PROTECTED] /
PL/SQL procedure successfully completed.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
HTH.
Rgds,
Nirmal,
-Original Message-
From: Szecsy Tamas [SMTP:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject:utl_file example
Hi,
Sorry for the previous post with a wrong subject in it.
Could somebody help me out with a very short utl_file example for
Windows
NT? I would like write error data into a simple text file, but I
get
exceptions.
TIA,
Tamas Szecsy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Scripting and NT
Hi, could somebody help me out with a very short utl_file example for Windows NT? I would like write error data into a simple text file, but I get exceptions. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
utl_file example
Hi, Sorry for the previous post with a wrong subject in it. Could somebody help me out with a very short utl_file example for Windows NT? I would like write error data into a simple text file, but I get exceptions. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: utl_file example
Title: RE: utl_file example
Nirmal,
do I
have to set some OS acces rights? I get the following
exception:
ORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at
"SYS.UTL_FILE", line 98ORA-06512: at "SYS.UTL_FILE", line 157ORA-06512:
at line 4
If I
handle the exception it turns out that it is invalide path. The only thing I can
think about is, that the sys user does not have access right to the c:\ drive.
Do you know, under what account is the utl_file accessing the OS
filesystem?
Tamas
-Original Message-From: Nirmal Kumar Muthu Kumaran
[mailto:[EMAIL PROTECTED]]Sent: Monday, November 12, 2001 1:00
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
utl_file example
Hi,
Verify "UTL_FILE_DIR"
init.ora parameter is defined properly.
In FOPEN function specify,
filepath and filename as separate.
[EMAIL PROTECTED]
; 1
DECLARE
2 fid UTL_FILE.FILE_TYPE; 3 BEGIN 4
fid := UTL_FILE.FOPEN('c:\','test.log','w'); 5
UTL_FILE.PUT_LINE(fid, 'Test file for usage of UTL_FILE package');
6 UTL_FILE.FCLOSE(fid); 7* END; [EMAIL PROTECTED] /
PL/SQL procedure successfully
completed.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
HTH.
Rgds, Nirmal,
-----Original Message- From: Szecsy Tamas [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject: utl_file example
Hi,
Sorry for the previous post with a wrong subject
in it.
Could somebody help me out with a very short
utl_file example for Windows NT? I would
like write error data into a simple text file, but I get exceptions.
TIA,
Tamas Szecsy -- Please see the official
ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy
Tamas INET:
[EMAIL PROTECTED]
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 San Diego, California --
Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send
an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing:
UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also send the HELP command for other information (like
subscribing).
Identifying user and locked table row in Oracle 8i
Hi, I am facing a locking problem with Forms 6i and Oracle 8iR3 that did not occure with Oracle 8iR2. To pinpoint the problem, I would need to identify the locking user AND the specific record that causes the problem. Does some of you possibly have a script that I can let our customer run when this deadlock situation occures? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Identifying user and locked table row in Oracle 8i
Steve, Dennis, thanks for the tips, it helped me a lot! Regards, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Win XP
The client side seems to work for us. And XP is faster than WinNT or Win2K if you have 256 MB. We could not test the server side yet. Tamas Szecsy -Original Message- Sent: Monday, October 29, 2001 6:00 AM To: Multiple recipients of list ORACLE-L Hi! Has anyone tried installing v8.1.7 or v9i on Windows XP??? Cheers, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Win XP
In Hungary you get it for $25. It's the price of 4-5 McDonald's BigMac menu :-). It is nothing compared to the time you loose waiting and watching the hour glass for a simple process to finish it's job. Tamas Szecsy -Original Message- Sent: Monday, October 29, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Who has 256mb on their clients??? Man...One can only dream Chuck Speaks Database Administrator Lithonia Lighting 770-860-3450 http://www.lithonia.com -Original Message- Sent: Monday, October 29, 2001 04:55 To: Multiple recipients of list ORACLE-L The client side seems to work for us. And XP is faster than WinNT or Win2K if you have 256 MB. We could not test the server side yet. Tamas Szecsy -Original Message- Sent: Monday, October 29, 2001 6:00 AM To: Multiple recipients of list ORACLE-L Hi! Has anyone tried installing v8.1.7 or v9i on Windows XP??? Cheers, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Speaks, Chuck W. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Where is the debugger package in oracle 7 and how is it called?
Hi, we are using TOAD for debugging Oracle PL/SQL packages. I would like to ask if some one knows how to bringt TOAD to debug Oracle 7 PL/SQL packages. According to the Help it can do this, on the other hand I can not seem to find the dbms_debug package neigther in the database, nor in the orant\rdbms73\admin directory. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using Intermedia and Oracle 8i for Web site search engine back-en
Hi, I am not very familiar with Intermedia. We have a web site for our intranet and it is getting too big to know everything where it is. It just occured to me how nice to make a HTML/XML frontend for a search functionality and let Oracle Intermedia search the MS Word and HTML file. Can Intermedia search external files? I would like to avoid loading all files ont the website into CLOB or BLOB columns. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Comparing data between two tables in two schema
-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A range function ??
try using
not between 'a' and 'z' and
not between 'A' and 'Z' ;
-Original Message-
Sent: Wednesday, September 26, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L
Hi,
I would like to exclude an arrange of characters.
there is for instance:
not in ('A','B','C','D','E'...);
Is there not perhaps something easier? ie:
not in ( A-Z, a-z) ;
Does anyone know of a function or some other more economical way of doing
this?
Many Regards
Denham
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denham Eva
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Reraising exceptions
Hi, I am currently writing some pretty complex triggers. In some cases I would need catch all exceptions occuring in a procedure call, make some processing (set a package variable) and then reraise the exception. Can this be done? Every hint will be highly appreciated. Tamas Szecsy
RE: Reraising exceptions
Michael, Thank you for the help! Tamas -Original Message-From: [EMAIL PROTECTED] [mailto:[Szecsy Tamas]]Sent: Wednesday, August 22, 2001 10:06 AMTo: Multiple recipients of list ORACLE-LSubject: AW: Reraising exceptions Tamas, you could usethe "RAISE" statement as last statement in the execption handler to re-reaise the exception. e.g. begin null; exception null; raise end; regards, Michael -Ursprüngliche Nachricht-Von: Szecsy Tamas [mailto:[EMAIL PROTECTED]]Gesendet am: Mittwoch, 22. August 2001 09:00An: Multiple recipients of list ORACLE-LBetreff: Reraising exceptions Hi, I am currently writing some pretty complex triggers. In some cases I would need catch all exceptions occuring in a procedure call, make some processing (set a package variable) and then reraise the exception. Can this be done? Every hint will be highly appreciated. Tamas Szecsy
RE: Is Oracle8.1.7 certified for NT4.0 ?
Yes. Tamas Szecsy -Original Message- Sent: Wednesday, August 08, 2001 1:26 PM To: Multiple recipients of list ORACLE-L dear list ! Is Oracle8.1.7 certified for NT4.0 ? Thanks a lot in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: The number of used cursors?
Thank you for the anwers. If I try Jon's version I get a big number that does not seem to be related to the number of maximum open cursors ( it's much higher). If I query the V$SQL_CURSOR view, then I get a number the could be the value I look for. Could some one shed some light on this? Regards Tamas Szecsy -Original Message- Sent: Monday, July 23, 2001 5:29 PM To: Multiple recipients of list ORACLE-L Try this: select sum(value) as open_cursors from sys.v_$sesstat s , sys.v_$statname n where s.statistic# = n.statistic# and n.name = 'opened cursors current'; Jon Walthour --- Original Message --- From: Szecsy Tamas [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/23/01 9:55:24 AM Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
The number of used cursors?
Hi, I would like to know the the number of used cursors at any given time. Is there a select statement that does this for me? I would like to decide if the growing number of concurent users for a given database has reached the point where the maximum open cursor init ora parameter got to be increased. Thank you in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problem connecting to a db
With previous server manager versions I got this message when I misstyped the internal password. Tamas Szecsy -Original Message- Sent: Tuesday, July 17, 2001 2:30 PM To: Multiple recipients of list ORACLE-L I have someone on a remote site who is having problems connecting to a db in server mgr as internal. connect internal should work, but it replies with insufficient privileges, I must be missing something. Does anyone have a suggestion what this could be? OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as administrator. Thanks, Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Influencing commit interval of read-only replication's refresh gr
Hi, does some one know of a way to force the refresh process of a read-only snapshot group to commit at predefined intervals: by table, by n number of rows or any other way? The problem that we are facing is that a refresh group has some rapidly changing tables and the rollback segment is not big enough. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Install Database and Developer software on the same machine
You should put them into separate Oracle Homes. Tamas Szecsy -Original Message- Sent: Wednesday, June 27, 2001 10:10 AM To: Multiple recipients of list ORACLE-L machine Hello, here is the information you asked me for: developer version:2000 oracle version 8.1.6 OS version: NT /98 The error I get when installing the Developer software, is when the installation program tries to create a new register in the HKEY_LOCAL_MACHINE\software\Oracle. It finds that this register is already created and used (this is the route where the Oracle_Home is...) I hope this information could help, a lot of thanks. Kevin Kostyszyn wrote: What versions, what OS?:) -Original Message- Martinez Jimenez Sent: Tuesday, June 26, 2001 7:01 AM To: Multiple recipients of list ORACLE-L Hello List, I have trying to install both of them (Oracle database software and Developer software) on the same machine, but it has been completely impossible for me. Could anybody tell me whether there is or not any way to do it? Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Multiple Oracle Instances on NT
We are running an Oracle 8i (8.1.6.) server on NT 30-250 concurrent users day and night since two years. It is a dedicated Compaq Proliant server, never had any problems. Since two years the databse is running without a single reboot. Tamas Szecsy -Original Message- Sent: Tuesday, June 26, 2001 7:30 AM To: Multiple recipients of list ORACLE-L Hello Lisa... I have been handling Oracle on NT last 6 months - and I much prefer UNIX. Here are some things I learnt the hard way... - can you run multiple instances of Oracle on one NT machine yes u can. Another lister has replied to u about this - how one uses oradim80 to create instances/SID's Note that the default SID can be set in the registry - so that u dont have to do set ORACLE_SID= everytime Note that there is no oraenv in NT For every SID there will be 2 services in NT - one called OracleServiceURSID and another OracleStartURSID. If u keep the latter as start automatically - ur db will come up auto when NT boots up. The former is always required. U can alter the settings by recreating the instance using oradim - if so, what do I need to look out for (ie. what things are differentthat a Unix installation) - are any of the processes, etc. drastically different - ie. security,networking, logging Dont foreget to create the oradba group. Also Oracle runs as a single process - there are no different shadow processes. So everything is clumped in one. The TaskManager might show u how many threads are running in one process (it does not break up for each app on the machine - so if only the Oracle server is running - the figure u see should correspond to the number of Oracle related processes) Further note that Oracle runs as user system - thats an internal hidden system mode in NT. So there might be occassions when u change permissions on some orcale related directory and then find that oracle cant access the files - thats cause u removed systems access. Just give required permission to system on those files/directory - what type of system requirements (ie. memory, CPU) are needed on NT Well that depends on ur requirements. Try to configure ur NT box so that its dedicated to the job of being a database server. U can find some notes on metalink on this. Ensure that ur NT box does not double as a PDC (primary domain controller). Finally reboot machine as often as u can - I have found memory being allocated and not being released. Keep LOTS of memory - I have seen the NT box freezing and refusing connections when it no longer had memory to create a shadown process. (only soln - crash boot the machine) Further dont use copy command to do ur hotbackups - use the ocopy command instead. Thats all I can think of now.. regards, ~aslam (PS: I had enough of NT - migrating to Solaris in a months time) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Is it possible???
You can achieve this in Oracle 8i with the login trigger. You can check in the login trigger if the application that trie to connect to the database is an allowed one. If not, than raise an exception and the login failes. For earlier versions you can use the product_user_profile table, but it's not a good solution since it limits only Oracle product to access the database, i.e. TOAD will be still able to access you data. You could also use a role that requieres a password, but then you have to hardcode the password into your application. Tamas Szecsy -Original Message- Sent: Monday, June 25, 2001 8:20 AM To: Multiple recipients of list ORACLE-L Hi Friends, I want that user only access data from application not from sql prompt. Any help would be highly appreciated. Shahid. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shahid Malik(IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Can DBA*Studio run on the Web through a browser?
I don't expect much of performance, it's slow enough as a client/server too. All the same, it's much quicker than going to the customer ;-) Thanks for the replies. Tamas Szecsy -Original Message- Sent: Monday, June 25, 2001 9:50 AM To: Multiple recipients of list ORACLE-L Be prepared for poor performance though. Jack Rama Malladi [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Re: Can DBA*Studio run on the Web through a browser? [EMAIL PROTECTED] om 22-06-2001 20:52 Please respond to ORACLE-L Yes. You can enable OEM through the web and DBA Studio comes along with it. That is what I do to maintain all our databases. I am using OEM 2.2 which has HTTP server bundled in the OEM CD. The same can be done with OEM 2.1, but you may have to configure your existing APACHE... webserver to work with OEM. Rama Szecsy Tamas wrote: Hi, is it possible to run DBA*Studio 8.1.7 on the Web through a browser? Thanks in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rama Malladi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL
Locking problem on WinNT 8.1.7 EE
Hi, did some one have locking problems with Oracle 8.1.7 EE? A Forms application, that ran for more than a year day and night, with 10-60 concurent user. It worked fine with oracle 8.1.6. SE. Since the upgrade to 8.1.7. we hade some repeatedly occuring locking problem, though could not investigate, since the users just use Windows NT Task manager to eliminate the problem. Regards, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Can DBA*Studio run on the Web through a browser?
Hi, is it possible to run DBA*Studio 8.1.7 on the Web through a browser? Thanks in advance. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cause for explain plan differences? - probably a basic question
Hi, I have two database instances 816SE and 817EE on WinNT. For the same query I get different result as follows (optimizer_mode=CHOOSE). What actually I don't understand is, that why are there resource costs in the EE 8.1.7. version and not in the SE 8.1.6 version. Both databases are created in the default database as supplied by Oracle and the import utility is used to load data. Could someone shed some light on this? Thank you in advance. Regards, Tamas Szecsy Oracle SE 8.1.6 - The Execution plan + SELECT STATEMENT Optimizer=CHOOSE SORT (ORDER BY) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) TABLE ACCESS (FULL) OF HIBACIM INDEX (UNIQUE SCAN) OF SYS_C0014232 (UNIQUE) INDEX (UNIQUE SCAN) OF PK_KORZNEV_KORZET (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_STATUS_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCHHELY_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCHOKA_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCJELTIP_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCHTIP_CODE (UNIQUE) Oracle SE 8.1.6 - The Execution plan - CHOOSE ++ SELECT STATEMENT Optimizer=CHOOSE (Cost=1578048 Card=6096026 Bytes=1578870734) SORT* (ORDER BY) (Cost=1578048 Card=6096026 Bytes=1578870734) NESTED LOOPS* (OUTER) (Cost=174 Card=6096026 Bytes=1578870734) NESTED LOOPS* (OUTER) (Cost=174 Card=673594 Bytes=172440064) NESTED LOOPS* (OUTER) (Cost=174 Card=410728 Bytes=99806904) NESTED LOOPS* (OUTER) (Cost=174 Card=250444 Bytes=57602120) NESTED LOOPS* (OUTER) (Cost=174 Card=152710 Bytes=33138070) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=18995664) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=17785156) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=16574648) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=15364140) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=14153632) TABLE ACCESS* (FULL) OF HIBACIM (Cost=174 Card=93116 Bytes=12943124) INDEX* (UNIQUE SCAN) OF PK_K_HCHTIP_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCJELTIP_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCHOKA_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCHHELY_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_STATUS_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF SYS_C001136 (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_KORZNEV_KORZET (UNIQUE) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cause for explain plan differences? - probably a basic question
Hi, I have two database instances 816SE and 817EE on WinNT. For the same query I get different result as follows (optimizer_mode=CHOOSE). What actually I don't understand is, that why are there resource costs in the EE 8.1.7. version and not in the SE 8.1.6 version. Both databases are created in the default database as supplied by Oracle and the import utility is used to load data. Could someone shed some light on this? Thank you in advance. Regards, Tamas Szecsy Oracle SE 8.1.6 - The Execution plan + SELECT STATEMENT Optimizer=CHOOSE SORT (ORDER BY) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) NESTED LOOPS (OUTER) TABLE ACCESS (FULL) OF HIBACIM INDEX (UNIQUE SCAN) OF SYS_C0014232 (UNIQUE) INDEX (UNIQUE SCAN) OF PK_KORZNEV_KORZET (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_STATUS_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCHHELY_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCHOKA_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCJELTIP_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX (UNIQUE SCAN) OF PK_K_HCHTIP_CODE (UNIQUE) Oracle SE 8.1.7 - The Execution plan - CHOOSE ++ SELECT STATEMENT Optimizer=CHOOSE (Cost=1578048 Card=6096026 Bytes=1578870734) SORT* (ORDER BY) (Cost=1578048 Card=6096026 Bytes=1578870734) NESTED LOOPS* (OUTER) (Cost=174 Card=6096026 Bytes=1578870734) NESTED LOOPS* (OUTER) (Cost=174 Card=673594 Bytes=172440064) NESTED LOOPS* (OUTER) (Cost=174 Card=410728 Bytes=99806904) NESTED LOOPS* (OUTER) (Cost=174 Card=250444 Bytes=57602120) NESTED LOOPS* (OUTER) (Cost=174 Card=152710 Bytes=33138070) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=18995664) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=17785156) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=16574648) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=15364140) NESTED LOOPS* (OUTER) (Cost=174 Card=93116 Bytes=14153632) TABLE ACCESS* (FULL) OF HIBACIM (Cost=174 Card=93116 Bytes=12943124) INDEX* (UNIQUE SCAN) OF PK_K_HCHTIP_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCJELTIP_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCHOKA_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCHHELY_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_STATUS_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_K_HCDOLG_CODE (UNIQUE) INDEX* (UNIQUE SCAN) OF SYS_C001136 (UNIQUE) INDEX* (UNIQUE SCAN) OF PK_KORZNEV_KORZET (UNIQUE) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cause for explain plan differences? - probably a basic questi
Explicitly no. Perhaps Oracle did on his own, while I imported the dump files. -Original Message- Sent: Monday, June 11, 2001 10:31 AM To: Multiple recipients of list ORACLE-L On Jun 10, 2001 at 11:30:23PM, Szecsy Tamas wrote: Hi, I have two database instances 816SE and 817EE on WinNT. For the same query I get different result as follows (optimizer_mode=CHOOSE). Did you analyze the tables? -- Vladimir Begun | Stability is often more correct than http://vbegun.net/ | correctness. http://vbegun.net/wap/ | -- Larry Wall in [EMAIL PROTECTED]| [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How can send SMS message from Oracle
Shahid, Here in Hungary GSM service providers have email/SMS gateways: 1. You receive an SMS when an email arrives to your email address, given to you by you GSM SP. The SMS contains the subject part fo the email. You can send the information of in the subject part. 2. Or they have a real gateway: you send an email to the [EMAIL PROTECTED] address that is converted to an SMS automatically. You should ask the GSM SP-s at you site if they have such facilities. You can send email from Oracle 8i with the SMTP package. HTH, Tamas Szecsy -Original Message- Sent: Friday, June 08, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Hi , I want to send SMS message from oracle database . any help would be highly appreciated. Tanks in advance. Shahid Latif -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shahid Malik(IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Trouble.. Standby Database. Urgent!!
Actually there may be no problem at all. Your standby
database might be up to date, the last available archive log file has been
applied to your standby database and Oracle tried to apply the next archive log
file 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 and did not find it, since
you did not copied it to the standby server or it does not even exist - yet - in
the primary site.
Check if the file missed by Oracle exists on the
standby site archive directory.
Actually if you use managed standby database, Oracle
can transfer the archived logs to the standby database through SQLNet and can
make the standby database applie them automatically. But you will need
Enterprise Edition Licences to do this:-((
If you move the archived log files from the primary
site to the standby manually, it can work very well too, without additional
licence fees. In this case create soma batch files for moving the files and
applying them to the standby site. The triggering of the batch files can be
achieved by OS specific scheduling commands. Actually we implemented it
this way and it's working fine for us.
HTH,
Tamas Szecsy
-Original Message-From: Saurabh Sharma
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 10:21
AMTo: Multiple recipients of list ORACLE-LSubject:
Trouble.. Standby Database. Urgent!!
hi all,
I need ur help urgently. i've
created a standby database with the below mentioned steps..
1. copied consistent backup of
datafiles folder to standby site.
2. created standby control file
and sent to target location.
3. switch logfile current and
copied to target.
4. copied init.ora and changed
parameters for standby.
at the standby site.
1. startup
nomount
ok
2. alter database mount standby
database. ok
3. recover standby
database
... this last
recovery statement is giving lot of msgs like..log applied..
then same
logfile not needed for this recovery.
can not open
file..etc.
I'm copying the archived log from
primary to standby standby_archive_dest location.
here are the actual errors..
SVRMGR recover standby
database;ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed
for thread 1ORA-00289: suggestion :
D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-00280: change 708915 for
thread 1 is in sequence #505Specify log: {RET=suggested |
filename | AUTO | CANCEL}autoORA-00308: cannot open archived log
'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-27041: unable to open
fileOSD-04002: unable to open fileO/S-Error: (OS 2) The system cannot
find the file specified.
has anybody any idea of what's
causing this problem. what i feel is there i may have wrongly configured the
standby_archive_dest in init.ora at standby.
any help is greatly
appreciated.
thanks.
saurabh sharma
RE: How can I query the SID name from the database
Thanks for all who replied. Probably I will have to solve this some other way, since the customer has several instances on the same box, but the instance name has no correlation to the SID name: they don't accept the default. Regards, Tamas Szecsy -Original Message- Sent: Tuesday, May 29, 2001 7:46 AM To: Multiple recipients of list ORACLE-L U can get the instance name from V$instance and v$database. If u have set the instance name and sid as same in init.ora, then instance name is the SID. BTW SID=system identifier for the OS to identify the Oracle to allocate resource. U can have multiple instance running in same OS. HTH -- On Mon, 28 May 2001 10:20:25 Jared Still wrote: machine_name is found in v$session. You can't query the server for the SID, as it is simply an environment variable. Jared On Monday 28 May 2001 10:10, Szecsy Tamas wrote: Hi, can I query a database's server's maschine name and SID (not database name) through SQL*Plus? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How can I query the SID name from the database
Hi, can I query a database's server's maschine name and SID (not database name) through SQL*Plus? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How can I query the SID name from the database
THNX Tamas -Original Message- Sent: Monday, May 28, 2001 8:20 PM To: Multiple recipients of list ORACLE-L machine_name is found in v$session. You can't query the server for the SID, as it is simply an environment variable. Jared On Monday 28 May 2001 10:10, Szecsy Tamas wrote: Hi, can I query a database's server's maschine name and SID (not database name) through SQL*Plus? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Terminal Emulation Sw.
Though it's not a Terminal Emulator, have a look at http://www.uk.research.att.com/vnc/. It's VNC, made by ATT. Totally free, source code available too, stable, with a small footprint and works even through a very low band width 56 kbaud modem. Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Designer 6i free tutorial?
Hi, does some one know of a Designer 6i tutorial (escpecially Forms generator)? The one supplied with the Designer installation CD is less than basic level. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Real-life Stand-by DB implementation stories?
1. We did not use remote archival in case of a network failaure. (The customer had a pretty overloaded ATM network that crashed two three times a day. 2. What I ment by dedicated server is that we did not allow any other application of functionallity to be installed on the primary or secondary database host, apart from backup and recovery SW. No file server, only the database and the backup SW. Not even print server ( some years back we had our Windows NT server crash because an errorous Word file got stuck in the spool...). 3. Failing back to the primary site is not that difficult, since in our case we can offer an off time for the failing back to primary. In this case we make cold backup from the standby, move it to the primary site via LAN ( it's already a 256 Mbit LAN). After backing up the control files from the newly created primary site, life can go on. Failing back can be done when business is low i.e. on a weekend night. I have got a question about Data Guard: Do you have to have Enterprise Edition for it to work? We did not use Managed Standby Database functionallity, because it needed Enterprise Edition licence - and it meens a huge extra cost. Regards, Tamas Szecsy == -Original Message- Sent: 2001.04.27. 6:31 PM To: Multiple recipients of list ORACLE-L I have recently implemented it at Cox, San Diego. I faced lot of problems in switching between Read Only and sunstained recovery modes with 8.1.6. I could not conclude anything about this, may be bug in 8.1.6. I am observing everyone mentioning about scheduling a job to transfer arch files to secondary.Why not using the feature of remote archival. I have used it and I didn't have any problems. Only script I had to develop was the one to monitor errors on Primary and Standby sites to take care of Archival and recovery breaks. Suren -Original Message- Sent: Friday, April 27, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Yes we did. It's on windows NT. We have implemented manually managed standby database, with a db job on the primary database archiving online redo log files every five minutes to minimize data loss in case of a crash of the primary database. The standby database server ftps *iwth a windows nt scheduled job, running every 15 minutes) new archive log files to it's local drive and applies them to the standby database if it's not in read-only mode for reporting. It's working since a more than a year, never had any problems with it. If Windows NT server is kept away from frequent install/deinstall of various applications then within my experience it is a stable solution. By the way, if Oracle Technet can be believed, Oracle 9i will have an automatic fail over feature for the standby database. My view is that you should use Oracle 8.1.7. Oracle 8.1.6 has some problems with read-only mode combined with managed standby database - or so I heard. Regards, Tamas Szecsy === Anyone implemented SBDBs recenetly? A client is comparing them to a cluster solution involving Fail-Safe. We are recommending SBDB and trying to go to 817 also (on 80521 now). Also this is NT if that makes a difference. Thanks, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list
RE: Real-life Stand-by DB implementation stories?
Yes we did. It's on windows NT. We have implemented manually managed standby database, with a db job on the primary database archiving online redo log files every five minutes to minimize data loss in case of a crash of the primary database. The standby database server ftps *iwth a windows nt scheduled job, running every 15 minutes) new archive log files to it's local drive and applies them to the standby database if it's not in read-only mode for reporting. It's working since a more than a year, never had any problems with it. If Windows NT server is kept away from frequent install/deinstall of various applications then within my experience it is a stable solution. By the way, if Oracle Technet can be believed, Oracle 9i will have an automatic fail over feature for the standby database. My view is that you should use Oracle 8.1.7. Oracle 8.1.6 has some problems with read-only mode combined with managed standby database - or so I heard. Regards, Tamas Szecsy === Anyone implemented SBDBs recenetly? A client is comparing them to a cluster solution involving Fail-Safe. We are recommending SBDB and trying to go to 817 also (on 80521 now). Also this is NT if that makes a difference. Thanks, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on NT/2000 Service shutdown
Cann't it be that shutdown goes quickly and startup is slow? If I remember it well there is a possibility with Oracle 8.1.x(x=?) to set startup time for a database. This is to garantee startup time. Tamas Szecsy -Original Message- Sent: 2001.04.24. 12:40 PM To: Multiple recipients of list ORACLE-L As a side note - I have noticed with 8.1.7 on Win2K that sometimes the service literally shuts down as quick as the listener service! Never saw this happen until 8.1.7 (8.1.6 still took about 20 seconds). Has anybody else noticed this? Mark -Original Message- Daiminger Sent: Tuesday, April 24, 2001 12:55 To: Multiple recipients of list ORACLE-L Hi! I found something interesting on the Windows 2000 FAQ site: Q. How can I increase the time that services have to shut down? A. By default, the OS allows services 20 seconds to stop before it forcefully halts them. For services that have a large amount of information in memory (e.g., Internet Security and Acceleration--ISA--Server 2000), 20 seconds might not be enough time. To increase the time the system allows, perform the following steps: 1. Start regedit.exe. 2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control. 3. Double-click WaitToKillServiceTimeout. 4. Set this value to the desired wait time in milliseconds--6 is 1 minute. 5. Click OK. 6. Close regedit. 7. Reboot the machine. Note that this value applies to ALL services, so setting it to a longer interval might slow your computer's shut down: if a service doesn't shut down correctly, it will have a longer time before the OS halts it. This is certainly useful for all of us who use Oracle on Windows. hth, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sending attachment in a mail with the Oracle SMTP or TCP package
Hi, could some one help me, how can I send an attachment within a mail with the Oracle 8i's built in SMTP or TCP package? The file to be attached is on the server side. Java in the database or shell script is not an option for me right now. Every help or hint will be highly appreciated. Best Regards, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Generating Forms through API or Designer
Hi Listers, I have the following questions: 1. I would like to generate Developer Forms fmb files through my C++ application. Is it difficult? Did any of you do similar things? I know Forms have an API for this, but I don't know how complex is it. I have pretty simple Forms. Should I try or should I forget it? 2. Does Oracle Designer 6i's Forms generator's revers engineering engine preserve or recapture the Form layout modifications I make on the generated Forms? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AT scheduler
My Computer/Scheduled Task might fit your needs better, since it has got a Windows GUI. It's easier to handle than the AT command. The GUI in some places is illogial, but still it might be usefull for you. Tamas Szecsy -Original Message- Sent: 2001.04.03. 8:22 PM To: Multiple recipients of list ORACLE-L If you are running on NT, I strongly recommend you obtain crontab for Windows. AT will run 99.99% of the time... but not 100% of the time. On one of the servers here AT failed to run the very night that we were changing the time last Fall, very suspicious in my opinion. In any case for AT just do: at hh24:mm /every:M,T,W,Th,F,S,Su cmd /c pointer_to_my_script_or_program e.g. at 22:00 /every:M,T,W,Th,F cmd /c c:\pat\coldbackup.cmd That will create an entry: Added a new job with Job ID = some number To see the listing, just type AT [enter] To remove an entry, at ID_num /delete e.g. at 12 /delete Don't try to keep your jobs listing in any particular order, NT shuffles them around sometimes when you do maintenance on the server or when you reboot. For AT jobs to run, of course the Scheduler service must be running. The service has a couple of different names, depending on which service pack you installed on your server. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Subject: "AT" scheduler Can anyone tell me how to schedule a batch job to run every 5 minutes using the "AT" scheduler? Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Forms Server - MS IIS
Thanks to all who replied. This question got suddenly a nice twist: Oracle support told me, that probably - I have to go to sales to know for shure - I would not be able to get Forms Server without iAS although Forms server is a CGI.exe ... Tamas Szecsy -Original Message- Sent: 2001.March.23. 3:41 PM To: Multiple recipients of list ORACLE-L Hi Listers, don't stone me for this question :-), but can Forms Server 6i cooperate with Microsoft IIS to provide Forms over the Web? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Form on the Web - File upload from the client to the Server - How
Hi Listers, does one of you know a way, how could I solve the following problem? I have a Forms application running on the Web with JInitiator with Windows NT IE client. The Forms application should be able to upload binary file to the server. Does some of you know a way how could I do it? (Java script, Java Bean, ??). Every help or hint will be highly appreciated. Regards, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ora 8i OCI application on a Ora7 client - Windows NT
It's crazy: the following happened: The OCI application worked fine on my maschine. I installed Dev6i. Then the OCI app did not work. I copyed the OCI.DLL for Ora8i into the same directory as the OCI app and then it worked again. :-) This caused me to think, that the OCI app needs the OCI.DLL of Ora8i to work. So I copyed the OCI app to an Ora7 client box and to my surprise it did not work. It turned out that if I remove the OCI.DLL of Ora8i everything is fine unless I use Ora 8i functionality. I think that perhaps the OCI.DLL of Dev 6i is not correct, can not cope with az Ora8i client OCI app. Regards, Tamas Szecsy -Original Message- Sent: Thursday, February 08, 2001 4:18 PM To: Multiple recipients of list ORACLE-L Tamas, You've got two choices: 1) install the Oracle8 client wherever the program will be run. 2) rebuild using the Oracle7 OCI library. Dick Goulet Reply Separator Author: Szecsy Tamas [EMAIL PROTECTED] Date: 2/8/2001 5:10 AM Hi, I wrote an OCI application, that I would like to link on a Ora8i client (Windows NT). The problem is, that although I don't user any Ora8i specific functionality, the executable still would not run on a Ora7 client (The Ora8i OCI.DLL is copyed into the same directory on the Ora7 client as the application executable). Can some one please help, how this can be resolved? TIA. Best regards, Tamas Szecsy The cause, I am using the Ora8i OCI.DLL is that the function calls (e.g. OCIDescribe ) are much more readable than the Ora7 version of it (odsc etc.). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ora 8i OCI application on a Ora7 client - Windows NT
Hi, I wrote an OCI application, that I would like to link on a Ora8i client (Windows NT). The problem is, that although I don't user any Ora8i specific functionality, the executable still would not run on a Ora7 client (The Ora8i OCI.DLL is copyed into the same directory on the Ora7 client as the application executable). Can some one please help, how this can be resolved? TIA. Best regards, Tamas Szecsy The cause, I am using the Ora8i OCI.DLL is that the function calls (e.g. OCIDescribe ) are much more readable than the Ora7 version of it (odsc etc.). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
