Fwd: files needed
-- Forwarded Message -- Date: Fri, 04 May 2001 11:18:51 +0530 To: [EMAIL PROTECTED] Hi, We are in the process of migrating our NT based Oracle applications to Unix. Sun Solaris was the choice. We have also many applications written in Pro*C in NT. We want to migrate those also to Unix. Acc to Oracle Docs, pcscfg.cfg file is needed to compile the pro*c progs to C and then compile them. but in $ORACLE_HOME/precomp/admin dir pcscfg.cfg is a 0 byte file . Can u pl send me copy of pcscfg.cfg file and also sample make file. TIA -- 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).
Re: EXPORT vs. Hot Physical Backup
Hi, Ever tried to export a let's say 50Gb database, let alone import it again?? I'd say the export utility should only be used to recover an accidentally dropped/corrupted table and datafile backup (either hot, or if you have the luxury, cold) is the way for backup Recovery of entire database. Jack Chris Rezek crezek@dotcli To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ck.com cc: Sent by: Subject: EXPORT vs. Hot Physical Backup [EMAIL PROTECTED] om 03-05-2001 21:30 Please respond to ORACLE-L Which is a better way to back up a database - use EXPORT/IMPORT or physical datafile backups? Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.
Re: wrong setting of sort_area_size
Hi, Setting the sort_area_size to something so big it sounds silly may actually improve some querries dramatically. I don't see why it should degrade performance if you have the physical memory to spare. We had a batch job that took about 60 hours but had to be tuned so it fitted in the 4 hours maintenance window. Apart from some funky compute statistics we increased the sort_area_size to 100Mb after which it did a hash join i.s.o nested loops and finished well within half hour Jack CC Harvest ccharvest@yah To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] oo.com cc: Sent by: Subject: wrong setting of sort_area_size [EMAIL PROTECTED] om 03-05-2001 22:06 Please respond to ORACLE-L we had a customer of the sort_area_size=1000 in their database, the temp table space is 256MB, the db_block_size is 8k. They have some performance problem, I think it's probably related to the setting of sort_area_size(we have only one user). So what's the benefits/disadvantage of too big sort_area_size? Thanks, Chris __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Taking your time when a crisis occurs
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. David, I support what you say about taking your time entirely. In fact at any interviews I attend backup/recovery question(s)n are always asked. My standard answer is the at then first thing I will do is go for a cup of coffee. After their jaws have finished dropping I explain how thinking time is required etc. On a similar theme a few years ago I was interviewing for a contract DBA and he made the statement along the lines of 'you are paying me more because I have made mistakes before and I have learnt from them so you will be safe with me'. ( I am sure he phrased it more eloquently than that). After the interview the senior manager at the interview said that he would not have anyone as self-obsessed and over-confident as that on board. I disagreed and said that what the contractor was offering was exactly what we wanted. We took him on and he fitted in very well. This story fits in with the concept of getting a coffee and thinking about things first, which is all about using your experience well. John Logica/ESIS Tel 0115 945 6643 -Original Message- From: David A. Barbour [mailto:[EMAIL PROTECTED]] Sent: 03 May 2001 18:46 To: Multiple recipients of list ORACLE-L Subject:Re: Fwd: please help Jared, I think you hit the nail on the head when you said Best practice of course is to make a backup of your database in it's current condition prior to restoring it. Too many recoveries are failures because DBAs tend to forget basics when confronted with the pressures from management, users, and the constraints of time (primary key). I made this mistake once early on. Now if I have a possible recovery scenario, the first thing I do is take a deep breath, get a cup of coffee, and THINK about what I'm going to do before I ever touch the keyboard. Absent all that, I still make a copy of the redo logs whenever I do a backup. Yeah, you could mess up and apply them inadvertently, but hopefully you will have practiced recovery scenarios (see Training a DBA by Kimberly Smith) and be comfortable with your tapes, disks, commands, systems administrator, etc. At least if you've got them, and everything goes to h*%$ in a handbasket, you can always give 'them' back something. David A. Barbour Jared Still wrote: Dick, Backing up the redo logs can have some serious consequences. Let's say you are restoring the database files, and a number of archived logs to roll forward through. Following that, you are going to roll forward through all archived logs that are still online, and then through your current redo logs for a complete recovery. Restoring old redo logs would render this strategy ineffective. Backing them up can be a good thing, but it would be very easy to inadvertently wipe out the current ones when restoring from tape. Best practice of course is to make a backup of your database in it's current condition prior to restoring it. It would also be prudent to make copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA
rename indexes
When I create tables with primary keys, Oracle gives the indexes a default name. Can I rename these indexes with meaningful names, or do I need to drop and recreate my tables, amending create table statements to explicitly name the indexes? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anybody heard of LECCO?
We actually distribute SQLExpert in the UK market place - and it really is a hell of a tool - no marketing jargon! What it will do is take your SQL (you can free format, harvest from source binary/forms/text files, online (SQLArea), S.C.L.D files, and COBOL) then, it will rewrite as many semantically equivalent SQL statements as is possible, and will show you all the ones with alternate execution plans. You can then run the source and alternates through a batch process to determine the ones with better response elapsed times, generate a report or simply save your optimised code to source. You can monitor instances and harvest poor code for optimisation at a later date too. I'm currently testing the new beta version of LSE (V.3) which has now got a PL/SQL module (formatting/debugging), and a new DDL extraction tool. It's a hell of a tool, call your local sales rep and get a demo of it is my personal opinion! It is reasonably priced - with two versions, one for a DBA (with the interactive production monitoring) and a cut down version for developers with all but interactive monitoring. The license is also on a client basis, meaning that you don't have to license the tool against an instance or server - one cost gives you everything! There are versions for Oracle, Sybase SQLServer with one for DB2 in development. Enough information for now? If you have any specific questions contact me off the list and I'll see if I can clear them up for you. Regards Mark -Original Message- Messer Sent: Thursday, May 03, 2001 11:51 To: Multiple recipients of list ORACLE-L Found this on Dogpile, looks like they have an evaluation download. LECCOTECH: Where the Experts go for Performance * LECCOTECH is a worldwide company delivering leading edge Relational Database Management System performance enhancement tools designed specifically for development teams and DBAs. Our award-winning flagship product, LECCO SQL Expert , automates t www.leccotech.com HTH, DM -Original Message- [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:22 PM To: Multiple recipients of list ORACLE-L Has anyone heard about a company called LECCO Technology and their products which supposedly use artificial intelligence to re-write and optimize SQL statements? -- 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: David Messer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: OT -- history of Sybase spawning MS SQL Server
Patrice, That's a hell of a write up! I knew the background to the SQLServer product, but not in so much detail! I also have a write up on the Ashton Tate/Microsoft/Sybase relationship, to give a little more info on the early days: Back then the PC database Market was dominated by Ashton Tate's dBase product. dBase IV had just been released and had been having a difficult time overcoming industry criticism that its memory management did not meet Ashton Tate's claims. They wanted to start to build on what they saw as their solid foundation in the PC market and start moving onto bigger systems. They moved to bring out a version of dBase IV on UNIX and in 1988, together with Microsoft, jointly announced a deal with Sybase to port SQLServer down to the intel platform using the new IBM multi-tasking operating system OS/2. Sybase's interest was obviously to license more copies of SQLServer and penetrate a new, lower end market. Ashton Tate's goal was equally clear - to promote dBase as the database application for everyone. It's ease of use was designed to make it open to fairly inexperienced users while its programming language was to make an ideal tool for developers. By buying the Server Edition, developers would be able to connect to more serious data sources, like SQLServer, to store their data. (A vision remarkably similar to another PC database that was to come to market later). Microsoft's interest in the deal was less clear, although everyone seemed to assume they were only out to sell copies of LAN Manager, their network software built on OS/2 - the operating systems they had just coded for IBM. After all - as the contemporary gossip went, Microsoft knew nothing about databases! The deal gave Asthon Tate full marketing rights to the product, which was badged with the Ashton Tate logo. Microsoft's cut came from sales of LAN Manager and Sybase's came from commission of every copy, who retained all intellectual rights on the SQLServer software. Ashton Tate were licensed only to add to the product. Ashton Tate had apparently, signed a clause in the deal, that committed them to deliver dBase IV Server Edition by a specific date. Failure would result in the company loosing any rights in the deal. This indeed occurred and full marketing rights switched to Microsoft almost immediately. So that is was happened in a more detailed summary than was on Page 8. Microsoft did pretty well out of the deal don't you think? Regards Mark -Original Message- Patrice J Sent: Thursday, May 03, 2001 09:49 To: Multiple recipients of list ORACLE-L More info since this is s-u-c-h a fascinating topic. In case you're wondering, it's past the end of the work day here for me, so I'm not wasting time... ironically I'm staying late to study for a SQL Server 7 Administration exam! Here goes, mind you this is from the lead developer for MS SQL Server, so keep that in mind. Inside SQL Server 6.5, p. 5 Ashton-Tate, Microsoft and Sybase would work together to debut SQL Server on OS/2. (This was the first use of the name SQL Server. Sybase later renamed its DataServer product for UNIX and VMS Sybase SQL Server, the name by which it is known today.) Continuing with the quotes on the history: p.8 loosely summarized, MS and Sybase dropped Ashton-Tate because that company was focusing on their dBase IV Server Edition product, and SQL Server 1.0 was not much of a priority for them. At the time though Microsoft still saw SQL Server primarily as a way to push LAN Manager. So Sybase appears to have been the key developer for this project, the ones with the most stake in it. p.9. in 1991 SQL Server 1.1. was released to work with Windows 3.0.. Here the shift begins. p.10 - exact quote: It was a great day in the SQL Server group at Microsoft when in early 1991 Microsoft's agreement with Sybase was amended to give Microsoft read-only access to the source code, for the purpose of customer support. [...] As a small group of developers at Microsoft became adept with the SQL Server source code and internal workings, Microsoft began to do virtual bug fixes. Although we were still not permitted to alter the source code, we could identify line-by-line the specific modules that needed to be changed to fix a bug. Obviously, when we handed the fix directly to Sybase, high-priority bugs identified by Microsoft got resolved much quicker. Continuing, still p.10: After a few months of working in this way, the extra step was eliminated. By mid-1991, Microsoft could finally fix bugs directly. They still had to let Sybase review the fixes before applying them, because Sybase at that time was still nominally the owner of the base code for the database engine. p.11 on the purpose of SQL Server at that time: No hard limit was established, but in general, SQL Server for OS/2 was used for workgroups of 50 users or less. For larger groups, customers would buy a version of Sybase SQL Server for higher performance UNIX-based or
RE: tech help needed
Hi, Sinha indexing = for easy searching something like building table of content in your book sorting = you know SORT hasing = using sort of formula for search particular item, there will be hashing algorithm here Have a nice day Sinardy -Original Message- Sent: Friday, 4 May 2001 12:01 PM To: LazyDBA mailing list Please tell me what is indexing, sorting, hashing Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Security, Password policy
Hi, For Oracle related information 1) You could go through PART V Database security of Oracle 8i Administrator's guide . 2) You could refer to Oracle Security by O'REILLY Publications. HTH shreepad To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Shreepad Vaidya/EMEA/ALLTELCORP) Hi all, Do you guys have any password policy knowledge to share? For Solaris 7, and Oracle 8i 8.1.6, Can anyone introduce me some good URL sites for those white paper ? Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Getting ORA-01732 trying to insert into table (NOT view)
Are you sure the public synonym isn't pointing to an object in some other database
thru a link?
[EMAIL PROTECTED] 05/03/01 04:55PM
Why do I keep getting this error even though this object is not a view??? I am in as
the owner of the table, which has the DBA role to boot.
SQL show user
USER is FARS_OWNER
SQL select owner, object_name, object_type from dba_objects where object_name like
'%ALIASTYPE%';
OWNER OBJECT_NAME OBJECT_TYPE
--- -- --
PUBLIC MFGALIASTYPE SYNONYM
FARS_OWNER MFGALIASTYPE TABLE
FARS_OWNER MFGALIASTYPE_VALUE_PK INDEX
SQL select * from MFGALIASTYPE;
VA I ATTRIBUTE PROMPTNAME SORTORDER
-- - -- --- -
T F SN Temic Accelerometer SN 30
T SN Actual Serial Number 10
A F SN Accelerometer SN 40
C F SN Customer SN 20
D F SN Daughter Board SN 60
S F SN Sensor SN 50
6 rows selected.
SQL insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80);
insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80)
*
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
BTW, the synonym is for the table so other users can access it without adding the
owner's name. I had already tried insert into FARS_OWNER.MFGALIASTYPE ... as well,
but didn't include that here.
Here's the table definition:
CREATE TABLE FARS_OWNER.MFGALIASTYPE (VALUE VARCHAR2(2),
ISDEFAULT VARCHAR2(1), ATTRIBUTE VARCHAR2(45), PROMPTNAME
VARCHAR2(45) NOT NULL ENABLE, SORTORDER NUMBER(2, 0)) PCTFREE 10
PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING TABLESPACE TBL_TINY ;
ALTER TABLE FARS_OWNER.MFGALIASTYPE ADD CONSTRAINT
MFGALIASTYPE_VALUE_PK PRIMARY KEY (PROMPTNAME) USING INDEX
PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE USER_DATA ENABLE
NOVALIDATE ;
This is using 8.1.5 EE on NT 4 SP6a.
Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Ray
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Need oracle patch 8.1.7.1.1
I just downloaded patch 8.1.7.1.2 from metalink - in the readme (yes I actually read it before installing ) it states that the earliest version that this patch may be applied to is 8.1.7.1.1 - I can't find this patch on metalink anybody know where I can get it? . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw Intergraph Public Safety mailstop LR24A4 [EMAIL PROTECTED] 256-730-8038 All the usual disclaimers and some of the certifications -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Getting ORA-01732 trying to insert into table (NOT view)
..or that the public synonym is really pointing at the object you think it is?
[EMAIL PROTECTED] 05/03/01 04:55PM
Why do I keep getting this error even though this object is not a view??? I am in as
the owner of the table, which has the DBA role to boot.
SQL show user
USER is FARS_OWNER
SQL select owner, object_name, object_type from dba_objects where object_name like
'%ALIASTYPE%';
OWNER OBJECT_NAME OBJECT_TYPE
--- -- --
PUBLIC MFGALIASTYPE SYNONYM
FARS_OWNER MFGALIASTYPE TABLE
FARS_OWNER MFGALIASTYPE_VALUE_PK INDEX
SQL select * from MFGALIASTYPE;
VA I ATTRIBUTE PROMPTNAME SORTORDER
-- - -- --- -
T F SN Temic Accelerometer SN 30
T SN Actual Serial Number 10
A F SN Accelerometer SN 40
C F SN Customer SN 20
D F SN Daughter Board SN 60
S F SN Sensor SN 50
6 rows selected.
SQL insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80);
insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80)
*
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
BTW, the synonym is for the table so other users can access it without adding the
owner's name. I had already tried insert into FARS_OWNER.MFGALIASTYPE ... as well,
but didn't include that here.
Here's the table definition:
CREATE TABLE FARS_OWNER.MFGALIASTYPE (VALUE VARCHAR2(2),
ISDEFAULT VARCHAR2(1), ATTRIBUTE VARCHAR2(45), PROMPTNAME
VARCHAR2(45) NOT NULL ENABLE, SORTORDER NUMBER(2, 0)) PCTFREE 10
PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING TABLESPACE TBL_TINY ;
ALTER TABLE FARS_OWNER.MFGALIASTYPE ADD CONSTRAINT
MFGALIASTYPE_VALUE_PK PRIMARY KEY (PROMPTNAME) USING INDEX
PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE USER_DATA ENABLE
NOVALIDATE ;
This is using 8.1.5 EE on NT 4 SP6a.
Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Ray
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: might be really old topic, but please take a look
I think most of us here will prefer Oracle Sinardy -Original Message- Sent: Friday, 4 May 2001 1:37 AM To: Multiple recipients of list ORACLE-L Probably this has been posed million times, but I really like to know. We'll have a meeting about this in our company, and I'd love to contribute someting. Any idea on the following issue, any link, paper, etc, will be greatly appreciated. pros and cons of 1. Oracle vs Sybase 2. Unix vs NT Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rename indexes
Title: RE: rename indexes -Original Message- From: John Dunn [mailto:[EMAIL PROTECTED]] When I create tables with primary keys, Oracle gives the indexes a default name. Can I rename these indexes with meaningful names, or do I need to drop and recreate my tables, amending create table statements to explicitly name the indexes? You can use alter index rename to change the name of the index. Or (a better solution) you can name the enforcing index when you create the primary key. Examples: -- In both cases an index will be created with the same name -- as the primary key constraint create table t ( n number constraint t_pk primary key using index tablespace indx, d date ) ; create table movie ( movie_name varchar2 (30), director_name varchar2 (30), year number, studio_name varchar2 (30), constraint movie_pk primary key (movie_name, director_name, year) using index tablespace indx ) -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Re: How can I cut off a query after 3 lines?
SELECT machine_name, login, Count(login) AS CountOfLogin FROM login_history WHERE ROWNUM 4 group by machine_name, login order by count(login) desc; [EMAIL PROTECTED] 05/04/01 01:25PM Q: how can you specify with a select statement how many rows are given as a result? I would only like to get the first three lines. here is what I have 1 SELECT machine_name, login, Count(login) AS CountOfLogin FROM login_history 2 group by machine_name, login 3* order by count(login) desc 4 ; MACHINE_NAME LOGIN COUNTOFLOGIN -- mochaJeff 3 reeses Paul 3 spiceTamara3 mochaRudy 2 reeses Jeff 1 reeses Ravie 1 reeses Tonya 1 spiceRudy 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MKirk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OT -- MS makes a statement about open-source software movemen t
Don't forget breaking up common industry design standards like incompatible data requirements for Kerberos implementations and the use of the latest COM+ for all IPC -- you know -- the ones that require you to buy and run Microsoft products ;-). David Messer wrote: Sounds like MS is afraid Open Source Software (OSS) will undermine MS. Hard to imagine a big company like MS being upset that it's competitors are selling ``flimsy,'' ''flawed,'' products that might 'jeopardizing property rights'. David -Original Message- Patrice J Sent: Thursday, May 03, 2001 2:22 PM To: Multiple recipients of list ORACLE-L movemen t http://dailynews.yahoo.com/h/nm/20010503/tc/microsoft_linux_dc_2.html http://dailynews.yahoo.com/h/nm/20010503/tc/microsoft_linux_dc_2.html Let me know what you think. : ) 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] mailto:[EMAIL PROTECTED] -- 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: David Messer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
RE: OT -- MS makes a statement about open-source software movemen
Here is Linus's response http://web.siliconvalley.com/content/sv/2001/05/03/opinion/dgillmor/weblog/t orvalds.htm a good read ... 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 ! * This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: in addition -- ORA-04091: table mutating problem?
What's your version of Oracle? I usually have a stock answer on how to solve this type of problem, but I just tried out your problem on my little Personal Oracle here, and to my INCREDIBLE surprise, the trigger worked and I didn't get an error. Does anyone know if that's just because I'm using Personal Oracle, or did they actually manage to guarantee consistency when the tables are mutating in 8.1.6? This is the trigger text I used: create or replace trigger bir_tableB before insert on tableB for each row declare cursor get_max_date is select max(create_date) from tableB; maxDate date; begin open get_max_date; fetch get_max_date into maxDate; close get_max_date; if (:new.create_date nvl(maxDate, :new.create_date)) then raise_application_error(-20101, 'New date must be greater than any existing record.'); end if; end bir_tableB; Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Leslie Lu leslie_y_lu@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.com cc: Sent by: Fax to: root@fatcity.Subject: in addition -- ORA-04091: table mutating problem? com 05/03/2001 07:11 PM Please respond to ORACLE-L In addition to my previous question: supposed you cannot use Max(date), and MUST use the cursor. (may be my example is not a good one), anyway, I'd like to know how to get around this mutating problem. Thank you! --- Leslie Lu [EMAIL PROTECTED] wrote: Hi all, I got ORA-04091: table mutating problem. Here is the case: select from table A and insert them into table B. A trigger is used to check that new DATE must be later than every DATE in B. So I open an cursor, loop through cursor to compare new DATE value. If I tested using hard coded value, the trigger works; if do a insert ... select, I got ORA-04091. I looked through metalink, didn't see anything that can help. Thank you in advance. Leslie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: images question
For me it's more a question of performance than fragmentation. At my last client (www.houra.fr), the images were store at the OS level to speed up the showing of the web pages and in Oracle so that each managers could associate comments to the images. --- David A. Barbour [EMAIL PROTECTED] a écrit : Check out BLOBs. They're stored externally. Can be tough to work with but also can be very worthwhile. Regards, David A. Barbour Oracle DBA,OCP Casas, Claudia wrote: Do you recommend storing images in an oracle database or just storing the directory path to them instead. Somebody told me it would cause database fragmentation if I store images or binary data in databases?? --Claudia Casas- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casas, Claudia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Getting ORA-01732 trying to insert into table (NOT view)
Why would 0racle even consider the public synonym? I thought this might be a
materialized view, but I would expect to see an
undefined object type.
Ian MacGregor
-Original Message-
Sent: Friday, May 04, 2001 8:21 AM
To: Multiple recipients of list ORACLE-L
Are you sure the public synonym isn't pointing to an object in some other database
thru a link?
[EMAIL PROTECTED] 05/03/01 04:55PM
Why do I keep getting this error even though this object is not a view??? I am in as
the owner of the table, which has the DBA role to boot.
SQL show user
USER is FARS_OWNER
SQL select owner, object_name, object_type from dba_objects where object_name like
'%ALIASTYPE%';
OWNER OBJECT_NAME OBJECT_TYPE
--- -- --
PUBLIC MFGALIASTYPE SYNONYM
FARS_OWNER MFGALIASTYPE TABLE
FARS_OWNER MFGALIASTYPE_VALUE_PK INDEX
SQL select * from MFGALIASTYPE;
VA I ATTRIBUTE PROMPTNAME SORTORDER
-- - -- --- -
T F SN Temic Accelerometer SN 30
T SN Actual Serial Number 10
A F SN Accelerometer SN 40
C F SN Customer SN 20
D F SN Daughter Board SN 60
S F SN Sensor SN 50
6 rows selected.
SQL insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80);
insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80)
*
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
BTW, the synonym is for the table so other users can access it without adding the
owner's name. I had already tried insert into FARS_OWNER.MFGALIASTYPE ... as well,
but didn't include that here.
Here's the table definition:
CREATE TABLE FARS_OWNER.MFGALIASTYPE (VALUE VARCHAR2(2),
ISDEFAULT VARCHAR2(1), ATTRIBUTE VARCHAR2(45), PROMPTNAME
VARCHAR2(45) NOT NULL ENABLE, SORTORDER NUMBER(2, 0)) PCTFREE 10
PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING TABLESPACE TBL_TINY ;
ALTER TABLE FARS_OWNER.MFGALIASTYPE ADD CONSTRAINT
MFGALIASTYPE_VALUE_PK PRIMARY KEY (PROMPTNAME) USING INDEX
PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE USER_DATA ENABLE
NOVALIDATE ;
This is using 8.1.5 EE on NT 4 SP6a.
Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Ray
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Unique Constraint question
I've scoured the docs and found nothing. My situation is this: How do I set up a constraint on a table, where I want a unique combination of fields, only when one of them equals a certain value? For instance: Col1 Col2 -- N 1 = OK N 0 = OK N 0 = OK N 1 = NOT OK It obviously cannot be done through basic column constraints, since it is OK to have multiple N,0 combinations. My sense is that there would have to be a trigger to affect a query lookup of the N,1 combination prior to insert. However, I desparately want to avoid that for performance reasons. Any help is appreciated. Thanks David Curiel Bioinformatics Software Engineer Pioneer Hi-Bred Int'l -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Curiel, David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle DBA needed in Lansing Michigan (jr-mid level)..
Financial services company in Lansing, Michigan is looking for a jr-mid level Oracle DBA to join its I.T. staff. Only candidates in Michigan or closeby states will be considered. This is a full time staff position, so no contractors or third parties please. Requirements: - Degree in C.S. or related field - 1+ years Oracle DBA experience - Data Warehousing and partitioning experience - U.S. citizens or permanent residents only This position offers: * Opportunity to become a key member of the I.T. team * Base Salary of 60K + competitive benefits * Annual bonus paid in April of each yr. 15-25% For immediate consideration, please send your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please do not send a resume or call if you need sponsorship or are a third party! Please use job code: One/Lansing/DBA/Liz Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills who are U.S. citizens or permanent residents. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
More oracle news from the ether.
- 4) NEWS: Clouds Over Oracle - Oracle's executive vice president of North American sales, George Roberts, said at a technology conference in San Francisco recently that the sales outlook for Oracle remained cloudy. With the scheduled release of Oracle9i - - the latest database version -- in May, Roberts was optimistic that Oracle's revenues should get a boost. But analysts have recently raised concerns that Oracle is losing its hold on the database market, particularly to IBM. For more information, go to: http://dailynews.yahoo.com/h/nm/20010430/tc/tech_oracle_software_dc_1.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 cut off a query after 3 lines?
UNTESTED, PLEASE VERIFY BEFORE USE:
---original message follows---
D a t e : Fri, 11 Jul 1997 14:41:53 +0100
R e p l y - T o : ORACLE database mailing list. [EMAIL PROTECTED]
F r o m : Jones, David (Oxford) [EMAIL PROTECTED]
S u b j e c t : Can i write a query for this.
This utility gives top/bottom values for a specified column in a
specified table. If you need other columns you will need to adapt it a
little. I would not recommend it on large tables if the column is not
indexed. Whether indexed or not, you can almost certainly do it more
simply in PL/SQL (Define a cursor with order by, loop through n
times.?)
HTH.
rem ...
rem . Program Name: GIVEME.SQL
rem . Written by: David Jones - January 1995
rem . Purpose: Returns either:
rem . - The top 'n' values for a column
rem . - The bottom 'n' values for a column
rem . - The 'nth' value for a column
rem . - the 'nth lowest' value in a column
rem . If the nth (or nth lowest) value is 'x',
rem . all the records with a value of 'x' will be rem
. returned.
rem . Called by:Any user
rem . Calls:nothing
rem . Tables: as specified in input variable 4
rem . Syntax: The following are all valid:
rem . GIVEME 6 topcolumn_name table_name
rem . GIVEME 6 bottom column_name table_name
rem .
rem . GIVEME 1 st column_name table_name
rem . GIVEME 2 nd column_name table_name
rem . GIVEME 3 rd column_name table_name
rem . GIVEME 4 th column_name table_name
rem .etc..
rem . GIVEME 1 stlast column_name table_name
rem . GIVEME 2 ndlast column_name table_name
rem . GIVEME 3 rdlast column_name table_name
rem . GIVEME 4 thlast column_name table_name
rem .etc..
rem .(can abbreviate bottom to bot, stlast to stl,
rem . ndlast to ndl etc.)
rem
set pages 96
set lines 110
set hea off
set verify off
set termout off
col head new_v head
col topbot new_v topbot
col allorone new_v allorone
col maxormin new_v maxormin
col bracket new_v bracket
select decode(upper(substr(ltrim(rtrim('2')),3,1)),
'P', '',
'', '',
'T', '',
'L', '',
'') topbot,
decode(upper(substr(ltrim(rtrim('2')),3,1)),
'P', '',
'T', '',
'L', 'max(',
'', 'min(',
'' ) maxormin,
decode(upper(substr(ltrim(rtrim('2')),3,1)),
'P', '',
'T', '',
'L', ')',
'', ')',
'' ) bracket
from sys.dual
/
select 'The '||'1'||' '||'2'||' value'||
decode(upper(substr( '2' ,2,1)), 'O', 's', '')||
' for '||upper( '3' )||' in '||upper( '4' ) head
from dual
/
spool giveme
prompt head
prompt
select maxormin a.3 bracket
from 4 a
where exists
(select 'How many are bigger/smaller than me?'
from 4 b
where b.3 topbot a.3
having count(*) 1 )
order by 1 desc
/
spool off
set verify on
set termout on
set hea on
undef head
undef topbot
undef allorone
undef maxormin
undef bracket
clear columns
_
- Regards
--
David Jones
Oracle DBA, Systems Dept, Tel : (01865) 742742 Ext:
2507
ACNielsen, Oxford. OX3 9RX e-mail: [EMAIL PROTECTED]
And now a message from today's ORACLE-L sponsor---
To subscribe, unsubscribe or change subscription options
to ORACLE-L, send a message to [EMAIL PROTECTED]
ORACLE-L is a service of Kapur Business Systems, Inc.
--
---end---
--
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).
RE: How can I cut off a query after 3 lines?
where rownum 4 Sunil Nookala Dell corp Austin, TX -Original Message- Sent: Friday, May 04, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Q: how can you specify with a select statement how many rows are given as a result? I would only like to get the first three lines. here is what I have 1 SELECT machine_name, login, Count(login) AS CountOfLogin FROM login_history 2 group by machine_name, login 3* order by count(login) desc 4 ; MACHINE_NAME LOGIN COUNTOFLOGIN -- mochaJeff 3 reeses Paul 3 spiceTamara3 mochaRudy 2 reeses Jeff 1 reeses Ravie 1 reeses Tonya 1 spiceRudy 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MKirk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
multiple schema in a database ???
Hi all, We'll have a meeting about the following issue: Due to large amount of transactions each trainee has, the existing training database in Sybase used multiple databases to handle each trainee's transactions. To implement this in Oracle, we may need to create multiple schemas in one Oracle database, instead of creating multiple Oracle databases. Let's investigate the impact of having multiple schema in a database. Looks like Public synonym needs to be get rid off. Any other idea about the impact of having multiple schema? And is there an easy way to create a schema which is identical to another one? Thank you. Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-04091: table mutating problem?
Mutating simply means you're trying to access the table that you're trigger is currently firing on (in a row level trigger). The basic workaround is typically... before-statement-level - initialise a PL/SQL table before-row-level - store information you need in the PL/SQL table, eg rowid's of rows being inserted after-statement-level - loop thru the PL/SQL table and take any action you need to do hth connor --- Leslie Lu [EMAIL PROTECTED] wrote: Hi all, I got ORA-04091: table mutating problem. Here is the case: select from table A and insert them into table B. A trigger is used to check that new DATE must be later than every DATE in B. So I open an cursor, loop through cursor to compare new DATE value. If I tested using hard coded value, the trigger works; if do a insert ... select, I got ORA-04091. I looked through metalink, didn't see anything that can help. Thank you in advance. Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MTS Problem
I am configuring multithreaded server configuration of an WIN2000 Advanced server with Oracle 8i Rel3 EE. All the parameter are set accurately and checked the MTS configuration through loopback and see connection entries in v$circuit accordinglybut when we connect through some other PC it does'nt worked.infact the other client get 'Target host or object does not exists' error. when i checked the listener.log file at the server it has the entries for those bad connection request as 'connection established'. socan any body tell me what's the problem going on. Regards, Adnan. __ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muhammed Adnan Ansari INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FW: standby database in managed recovery mode
Check the size of the archive log which it complains on primary.I have seen situation when the log has transmitted partially and the recovery comes to a standstill. After getting all the archives properly, run a recover automatic standby database; then try to put it in managed recovery mode. HTH. Jyoti Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti Randive INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rename indexes
Couldn't you just drop and rebuild the index with a new name? -Original Message- Sent: Friday, May 04, 2001 11:12 AM To: Multiple recipients of list ORACLE-L When I create tables with primary keys, Oracle gives the indexes a default name. Can I rename these indexes with meaningful names, or do I need to drop and recreate my tables, amending create table statements to explicitly name the indexes? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: Unique Constraint question
You should use table level check constraint. See docs. Alex Hiilman -Original Message- Sent: Friday, May 04, 2001 11:22 AM To: Multiple recipients of list ORACLE-L I've scoured the docs and found nothing. My situation is this: How do I set up a constraint on a table, where I want a unique combination of fields, only when one of them equals a certain value? For instance: Col1 Col2 -- N 1 = OK N 0 = OK N 0 = OK N 1 = NOT OK It obviously cannot be done through basic column constraints, since it is OK to have multiple N,0 combinations. My sense is that there would have to be a trigger to affect a query lookup of the N,1 combination prior to insert. However, I desparately want to avoid that for performance reasons. Any help is appreciated. Thanks David Curiel Bioinformatics Software Engineer Pioneer Hi-Bred Int'l -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Curiel, David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Removing Oracle products from NT
You wouldn't trigger long discussions :-) if you mention thatremoval ofservices is done deleting these services from registry from HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and from HKEY_LOCAL_MACHINE\SYSTEM\ControlSetxxx\Services Alex Hillman -Original Message-From: Jyoti Randive [mailto:[EMAIL PROTECTED]]Sent: Friday, May 04, 2001 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Removing Oracle products from NT You can try the Oracle universal Installer to unistall. More rough way is to shutdown oracle db,listener, etc. , shutdown the services, remove/disbale the services. ..and then go to registry and remove everything under (local_machine-software -oracle) Then you can delete the whole Oracle home tree. The reinstall or whatever you want to do! Believe me , sometimes windows Oracle is a pain,specially cleaing up for a reinstall. But after all we are Unix guys! Just the beat the .. out of windows! Hope I do not trigger another long discussion here! :-) HTH. Jyoti Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti Randive INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9iAS Forms Server Stability
Jenny, Just to make sure we are on the same page, when I was talking about web deployed, I was talking strictly internal networks, lan, wan, etc using the web forms approach. Anyway, I don't know that you should nervous based on just my comments alone. It is kind of interesting, though, that no one has chimed in saying things work great. And from what I understand, it was a pretty difficult install for them with a lot of hiccups, restarts, and missteps along the way. And at the same time, there is a lot of other tweaking and stuff going on with the test box. That's why they are looking to do a clean install on another machine, one on which nothing else is begin done. There are so many things that could be playing a role in the current instability they are seeing. Today, for example, I don't think it ever went down. They've still got a full 2 months before going live and getting things smoothed out. I've now been pulled over to the operations side to help, with my role being primarily focused on using native IE instead of Jinitiator. And frankly, I don't know what I am doing -- I have no experience with this. They just want another body to throw at it. I can read the install manuals, Metalink and Technet doc's, etc. I run 9iAS 1.0.2 with Forms 6i and native mode = IE here on my home machine (Win2K), but, that's a far cry from a real production environment. And it took a good 3 days to get everything working with each other. I guess I will be spending a lot of time on Metalink this weekend looking for potential pitfalls. They have already opened a TAR to get answers to certain questions regarding using IE's native JVM instead of JInitiator. And I've already come across stuff indicating that certain MS patches/upgrades still might need to applied. And their hope is to not have the users, or local techs, have to do anything. We will see. Regards, Larry G. Elkins [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jenny Jacob Sent: Friday, May 04, 2001 3:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: 9iAS Forms Server Stability I have persuaded my manager to go with 9iAS to deploy dev2k forms on the web. We have dev2k client/server applications and 8.1.6 database but we've never deployed forms on the web - except for webdb stuff. It is pretty urgent to have an application in place. From your comments I am not sure whether I have made the right choice. (my manager was thinking of a non-Oracle application but as usual I pushed him towards Oracle) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9iAS Forms Server Stability
Jared, Thanks for taking the time to reply. I don't know if they are working on any contingency plans, but, I guess they could stay on OAS and Forms 5.0 if things don't stabilize. I'm hoping that it is just a little configuration issue here, a tweak there, and so on. We will see -- they don't plan to go live for another 2 months so there is time to still work through issues. They've been bitten by a few packages that wouldn't compile under 8.1.7 that worked fine in 7.3.5. I've been able to work through those issues. And we've seen some other strange things, both DB side and Forms side (especially window sizing going bonkers). But, the only real issue that I have seen so far is a bit of instability with the Forms server component. Regards, Larry G. Elkins [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jared Still Sent: Wednesday, May 02, 2001 7:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9iAS Forms Server Stability Larry, I haven't worked with 9iAS yet, but have set up the previous version of iAS on Solaris with Forms 6i. This also uses the Apache server, Jakarta, etc, and we did not experience the problems that you are. Could be that 9iAS is still a bit on the bleeding edge. :) Also, I was using the CGI method. Jared -- 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).
