RE: Oracle Expert and FK indexes
Hello, Patrice -- I realize that you wrote this last month. Did you ever draw any conclusions about this behavior? I am trodding the foreign key ground right now hoping to find the golden key to a huge performance issue. I found many unindexed foreign keys (using the scripts per Note:16428.1), however none were in the areas I was researching. I wonder if Expert wanted you to drop them if your table has few rows or if it has very little variability in the values. Did you ever find the answer to why Expert suggested this? Just wondering. -Original Message- Sent: Thursday, November 15, 2001 10:30 AM To: Multiple recipients of list ORACLE-L Does someone know why the Oracle Expert would recommend dropping indexes on FK columns? Maybe it calculates there is a low likelihood of the table being locked during referential integrity checks ? I thought it was a good idea to have indexes on FK columns... this is an old 7.3.4.5. database. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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: Shreter, Hilary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: recovery
Title: RE: recovery Perhaps preserve the CURRENT redo logs so that after the archived ones bring you up to their lasttime, you can use the currents to come up to the last moments? (I've not tried this exact scenario though) -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 26, 2001 4:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: recovery The control files are all intact and the database is open. Only one datafile (for an offline tablespace) is missing. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 4:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: recovery It is correct if the files weren't renamed or physically removed. In that case, you have to re-create the controlfile and do recovery using backup controlfile (which means that it doesn't have the target SCN). -Original Message- Sent: Wednesday, September 26, 2001 4:05 PM To: Multiple recipients of list ORACLE-L It's been a while for this scenerio for me. Other dba takes a tablespace offline to shuffle files around. Accidently nukes on of the files clear out of exsistence. DB is in archivelog mode. Recovery steps as I recall them. 1) get missing file from last backup 2) Get needed archive log files from backup 3) issue 'alter database recover tablespace blah' correct? Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Applications patches
Dear Patrice, The megapatches are worth installing, since they fix lots of bugs. There is a pulldown list in the patch getter screen that lets you ask for all megapatches or similar. Also check the release notes to see if there are any interoperability patches. (Interops let this version of Apps work with that version of Server, etc. all down the technology stack UGGG!) Have you dicided which products to install? That will tighten up the list! US Payroll has a lot of patches as the legislatures of the 50 states and numerous municipalities create scope creep (however it keeps people employed to apply the resulting patches). -Original Message- Sent: Tuesday, August 28, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I did a quick search in Metalink for Oracle Applications patches... and Metalink returned 500 items! Are there patches that are more critical than others? I have a copy of Oracle Applications for NT, I just want to learn to install it, configure, and play with it a little. (500! Unbelievable). 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] 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: Shreter, Hilary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 do they get the answer?
They can't give any raises this year. They have to hire a data modeler using those monies. There were at least four raises that could be used for this purpose. -Original Message-From: Brian McGraw [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 3:26 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How do they get the answer?It's possible, but not the only possibility. Therefore you can't answer A. And if you're not certain, you can't answer the question. Because this is the Oracle OCP exam. The thing that you've studied night and day for. Everything you learned in the two-night class preparing you for database administration and nuclear physics. This is crunch time, baby - right or wrong? You make the call. Pressure's on. Which will it be? What if this is the question that will put me under that passing grade. A or C? A or C? Which will it be? What will I do? You want the truth? You want the truth? You can't handle the truth! I'm heading back to the espresso machine now... Brian JOE TESTA wrote: i still stand by(reading into the question) that it could be only 2 teachers get a raise, if the same 2 teachers teach both of those courses. would they get twice as much of a raise? :)joe [EMAIL PROTECTED] 08/21/01 12:52PM in the where clause, the IN says "any teachers that are in any of these subjects. Since there are two subjects in the IN set and at least 2 teachers have to teach each subject, 2*2=4. Basic mathematics: at least 4 teachers will get a raise. Jon Walthour From: [EMAIL PROTECTED] Date: 2001/08/21 Tue PM 12:25:54 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How do they get the answer? I am taking the Self-Test software test for the SQL exam and don't see how they get the answer to this problem. They don't explain how it is arrived at. Any help you can give me will be appreciated. Thanks, Ken Janusz, CPIM -- Examine the structure of the TEACHER table: Name Null? Type ID NOT NULL NUMBER(9) SALARY NUMBER (7,2) SUBJECT_ID NOT NULL NUMBER(3) SUBJECT_DESCRIPTION VARCHAR2(2) There are 200 teachers and 15 subjects. Each subject is taught by at least 2 teachers. Evaluate this PL/SQL block: DECLARE v_pct_raise number := 1.10; BEGIN UPDATE teacher SET salary = salary * 1.10 WHERE subject_id IN (102, 105); COMMIT; END; Which result will the PL/SQL block provide? (A) Only two teachers will receive a 10% salary increase. (B) All of the teachers will receive a 10% salary increase. (C) At least four teachers will receive a 10% salary increase. (D) A syntax error will occur. Answer: (C) -- 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: 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). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | --
RE: SMP/MPP and PQO
"In Search of Clusters" by Gregory F. Pfister, 2nd edition, Prentice-Hall (Saddle River, NJ) 1998 isbn 0-13-899709-8 and it is a wonderful book. I wish there were other technical books like this. The book isreadable, fun, and excruciatingly technical all at the same time. -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SMP/MPP and PQO I think it was just updated, too. Great book. -Original Message-From: Henry Poras [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SMP/MPP and PQO Lisa, If you are interested in more detail on the differences between SMP, NUMA, and clusters, there is a great book "In search of clusters". It's one of the best technical books I've read. I can't remember the author's name, but maybe another list member can help. I picked it up because someone else on the list recomended it a while ago. Henrh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 12:48 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SMP/MPP and PQOHi Lisa SMP - In SMP many CPUs share the same memory. Typical example would be E450, 4 processors, 4GB memory. Only L2 cache in the CPUs need to be co-ordinated when a memory buffer is changed or intended to change. MPP - In MPP each CPU has its own memory and its own disks that they control (typically). An example would be nCUBE or IBM RS6000, where each processor runs its own OS and messaging is used heavily to coordinate the access to the resources. NUMA - Nun -uniform memory access - Group of CPUs share the same memory and the messaging is used between the group of the CPUs to coordinate the access to the resource. An example would be Sequent NUMA-Q, where there are multiple quads and each quad has 4 cpus and 2GB memory (typically) and IQ-link coordinates the access to the resources between the quads. HP has ccNUMA for this. Now, I don't think, E10k domain would qualify for a MPP, since there is no coordination or access restrictions between the domains ( at least that I know of). Each domain can manipulate its own disk / memory /devices without any messaging between the domains, in a non-clustered environment. PQ architecture splits the FTS or long running operations on non-partitioned tables, in to multiple chunks based upon the rowid ranges. It is not a simple split though. First, work is divided in to degree of parallelism. For example, if the QC process determines that it has to scan 100,000 blocks and parallelism is determined as 4 then 25000 would be the split. But not all 25000 block is handed over to the slave processes. QC uses 9/13 rule. QC hands over 9/13 of the work (i.e. 25000 * 9/13=17307) blocks equally to the slave processes. When the slave processes finishes up the 9/13 work, then they get 3/13 of the work (25000 *3/13=5769) blocks and 1/13 of the work when the second set of 3/13s are exhausted. This is done to evenly distribute the load. For example, there could data skew such that one process could finish up its 9/13 work much faster than other processes and hence those processes can take up the rema! in! ! ing work. The suitability of PQO parallelism should be defined by IO sub system in conjunction with CPU power. If you have many spindles in 2 cpu server my take on it would be to use parallelism of 2 to4 depending upon the cpu clock speed, disk speed, memory etc.. ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com "Koivu, Lisa" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/12/01 09:17 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SMP/MPP and PQOHello everyone, I was reading up on the differences between SMP, MPP and how they may affect PQO (Parallel Query). My understanding is that MPP is a host with defined domains (like an e10k with virtual machines on it). SMP is a standalone host with no domains and multiple processors. I am not considering clustering here. It seemed to me the only requirement that you really need to run PQO is to have available resources to power it. For example, a little 2-cpu box that is pinned a majority of the time is
RE: OT: Archiving not possible with SQL Server?
Bet you aren't an idiot: bet you're suffering from Microsoft-induced aphasia. I hate MS's habit of taking perfectly good industry vocabulary and making the words mean too-specific proprietary things. Works in MS's favor: helps the MSCEs makes the rest of the world feel like idiots! As far as the archiving, I curse both houses Oracle and Microsoft. On my old RDB (when it was Digital) database, I could take a reliable fast full backup any old time, and throw away any old backups that I'd created before. Not like Oracle where I have to quilt together old redo logs/datafiles or SQL Server where I have to keep all of the silly transaction logs to make any kind of reliable copy. Before you flame: yes I could quilt together RDB with the After-Image Journals, and I could take am Oracle backup with export/import or use a fancy Sql Server utility and have a semi-reliable backup. I'm only arguing that the scale of work associated with the task at hand seemed much more appropriate in RDB. 'Course RDB ran on proprietary operating system OOPS! start a new flame! -Original Message- Sent: Thursday, May 31, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Yeah? But you know what? After few hours with SQL manual I'm starting to feel like an idiot. Supreme Council says: All Aboard MS SQL! Me says: Abandon Ship! Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Patrice J Sent: Thursday, May 31, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Jared is having a bad day. : ) 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] -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 3:51 AM To: Multiple recipients of list ORACLE-L Subject:Re: OT: Archiving not possible with SQL Server? Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote: Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always have the possibility of another long transaction starting. HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Shreter, Hilary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MICROSOFTDTPROPERTIES
Is this table residing in an Oracle database ?? This is the special table that MS Access sets up in order to hold 2-3 little properties that it wanted. I don't want to cause Microsoft to drag me to court so I'm not clipping... Please get to www.microsoft.com, see explanation to Q247828 which describes this table and OTHER stuff that gets added!! -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 5:16 PM To: Multiple recipients of list ORACLE-L The developer created the table and now doesn't know what is does??? As penance, said developer(s) must write I will document all changes fully and RTFM in their own blood, 10,000 times on the floor without using their hands. Then: 1) export tables=MICROSOFTDTPROPERTIES ...desired options here 2) DROP TABLE MICROSOFTDTPROPERTIES; 3) see who/what/if anything breaks, whines, or snivels... All assuming this is a development instance. You WERE NOT letting them poke around in a production instance, correct? Your Friend in Evil, Scott Shafer San Antonio, TX 210-581-6217 And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Gras via your Ninja Death Touch, you step on a beer bottle and fall backwards into the juke box and get your head stove in by a drunk with a pool cue. --Jay Trigg -Original Message- From: Armstead, Michael A [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Subject: MICROSOFTDTPROPERTIES I have developers who have created this table. Now they've come to me to find out what the table does. I think it is used by the Microsoft Transaction Server software. Does anyone know for sure the purpose of the MICROSOFTDTPROPERTIES table? Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael 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). -- 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: Shreter, Hilary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Another Database Down
Title: Another Database Down No need to panic yet! Check out Metalink note 1034037.6 which has about 4 possible reasons for this -- all pretty simple. -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 7:27 PMTo: Multiple recipients of list ORACLE-LSubject: Another Database Down Well, I think the time for jubilation has been short-lived for me. The production database was recovered successfully due to archiving and luck. I also have a small, inhouse, remedy (help desk) database that I haven't done anything with and now recovery is necessary for it as well. The bad news is I wasn't archiving, and although I do have a physical backup, the database was not down. I restored the datafiles, control files, and redo logs so that everything would be for the same time, but when I try to open the database I get the error "cannot mount database in exclusive mode." The error states that an instance already has it open in exclusive or parallel mode. I am assuming this is because the database was not closed when the backup was executed. I have tried a few things to 'trick' it, but I guess my magic tricks are not good enough to fool the crowd. I am already bracing myself for what I will probably read in response to this...but I am hopeful that someone will find that rabbit in the hat. Thank you in advance, Laura
RE: Oracle Books on Audio Tapes
Might want to have a chat with Recording for the Blind and Dyslexic. They might have such books, or they might advise you on how to structure an audio for this purpose. It's convenient that the docs come as small HTML files all linked together -- a voice-activated PC might be able to handle this requirement. -Original Message- Sent: Thursday, March 29, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Surely there's a Reader's Digest Condensed Version Or how about Cliff Notes? [EMAIL PROTECTED] 03/29/01 10:45AM Also, for Oracle 7 at least, the documentation is about 10,000 pages long, that would take a lot of tapes. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: dana Sent: Thursday, March 29, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Books on Audio Tapes --- Apps Sol [EMAIL PROTECTED] wrote: Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK I doubt it. From what I understand, audio books are primarily made from best-selling fiction. What non-fiction audio books exist are probably limited to stuff with the broadest general appeal (best-sellers). I've personally never heard of technical books on tape/audio CD. However, you might be able to make your own, rather tediously, if you receive a PDF version along with a "dead tree" technical book. 1. Copy-paste the text from the PDF to your word processor of choice. 2. Use text-to-speech software to creave WAV files 3. Burn to CD. Or, you may want to purchase some Oracle Computer-Based-Training CDROMs and burn the audio tracks to an audio CD(if they're in a standard audio format or a format you could convert to WAVs) - or convert and download to an MP3 player. That's probably your best choice, though an expensive one. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Shreter, Hilary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Books on Audio Tapes
Good point on visuals. RBD readers describe those features for the tape. Makes the reading job challenging, and very useful value-added for the recipient. -Original Message- Sent: Thursday, March 29, 2001 3:12 PM To: Multiple recipients of list ORACLE-L Bill, There are some graphic technologies available ("tactile" stuff?), from what I recall, they are rather specialized/esoteric, and not "one size fits all" (we have a federal grant here to provide remedial math instruction including visually impaired students - including some "learning disabilities" that are caused by "visual processing" deficits). also, the above mentioned solutions tend to be big $$$, either for the product, or related set up, training and maintenance (or all), and it isn't unusual for only the more "nerdy" disabled types to be able to use the stuff effectively. regards, ep ps, federal education programs grant site pages: http://www.ed.gov/offices/OPE/ - http://www.ed.gov/offices/OPE/HEP/sitemap.html - (look at: TRIO, etc: http://www.ed.gov/offices/OPE/HEP/cfda.html ) On 29 Mar 2001, at 11:15, William Beilstein wrote: My problem is not with the blind, I'm blind in one eye myself, but how you would represent tables, flow diagrams ... -- 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: Shreter, Hilary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Which account do I need to change password besides system,sys
Careful!! You need to use the SAME password for APPS and APPLSYS. Also (maybe new in 11i?): p. 171 of the Admin manual says that ALL the schema passwords have to be the same. I'm referring to the section "Change Oracle Apps Password" in Ch. 6 of "Maintaining Oracle Applications Rel 11i" part A83525-01. I'm just starting on 11i myself else I'd know the answers for sure instead of quoting you the manual! Good luck to you and the system. - Hilary. -Original Message- Sent: Thursday, March 08, 2001 3:01 AM To: Multiple recipients of list ORACLE-L and Hi, We are about to implement the HRMS 11I Applications. The password for the following accounts has to be changed : SYS, SYSTEM, APPS (for HRMS 11I Applications) Is there any account that I've missed out ? Please advise. Thanks. Regds, ChorLing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Shreter, Hilary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).