Re: Question on on delete cascade functionality
While a ON DELETE trigger would do what you want, why don't you want to rebuild the constraint? [EMAIL PROTECTED] 07/24/01 08:05AM sounds like a trigger is needed. joe Ranganath K wrote: Dear DBA Gurus, How to add the functionality of on delete cascade to an existing foreign key constraint without dropping the constraint and recreating it using Alter command? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Update ALL colums without knowing their name??-correction
Then do a Delete from table; which will remove all rows while leaving the previous data for the other users until you commit; [EMAIL PROTECTED] 07/24/01 03:35PM Hi, Thank you for your answer. Unfortunatelly I can't truncate, then insert into ... select ( I myself thought about it before )because the tables are always used ( there are always a few users connecting to database). Thank you Zsolt Csillag Hungary At 13:52 2001.07.23. -0800, you wrote: Are you just trying to totally refresh table1 from table 2? how about: 1. TRUNCATE table1; 2. INSERT INTO table1 SELECT * FROM table2; (assuming structures of the two tables are compatible) Or am I just totally missing the mark in what you are looking to do? Jon [EMAIL PROTECTED] -Original Message- From: Csillag Zsolt [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 5:33 PM To: Multiple recipients of list ORACLE-L Subject: Update ALL colums without knowing their name?? Hi, I need an universal update procedure in which I don' t know the colums name. How can I make an update like this: Update Table1 set Every_columns = ( Select * from Table2) I tried set Table1.* wiht no result. How can I work around this? Csillag Zsolt www.star-soft.hu This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] -- 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: get yesterdays date
select sysdate-1 from dual; [EMAIL PROTECTED] 07/23/01 07:35AM Anyone know how to get yesterdays date in PL/SQL? 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). This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] -- 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: Newbie kinda question
Purchase the D2K package from Oracle. However Procedure Builder is being phased out by Oracle. [EMAIL PROTECTED] 07/23/01 10:55AM Hi Everybody, I'm currently studying for some Oracle Certification from a private organization, which will then put me through the Oracle DBA exams. I'm currently working on the PL/SQL programming modules. All the information I have consistently refers to Procedure Builder for programming with PL/SQL. However, I cannot seem to find where I can get a copy of Procedure Builder. I have gotten a copy of TOAD, however I'm not entirely happy with it. Statements which are allowed to run in SQL*Plus are not being run under TOAD for some reason. So, in summary, where can I get a copy of Procedure Builder ? Thanks, Michael. This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] -- 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: Wildly OT. - Air fares
No site that I know of can get you a reservation over a year in the future, but a ticket for mid September 2001 would be $97.00 on Jet Blue Airlines, which is a low cost airlines that runs only brand new jets and is a very good airline. To purchase tickets (later in the year) go to http://www.jetblue.com Jet Blue flies out of JFK airport in New York and into Seattle. You will also need to pay an airline tax of $8.75 to the US Government. Have a great time in the US. [EMAIL PROTECTED] 07/23/01 12:16PM One way, around about mid september 2002 (Grizzly Bear watching at Knights Inlet BC). Regards Lee -Original Message- Sent: 23 July 2001 16:07 To: Multiple recipients of list ORACLE-L One way or round trip. What date? The longer period between the purchase of the ticket and when you are going will usually mean a cheaper flight. [EMAIL PROTECTED] 07/23/01 10:26AM Rachel (or any other NYC listers). Any idea how much an airticket from N.Y to Vancouver/Seattle would be please TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Can't code for s.... peanuts
Have you applied the function against the database. For example if you type select owner,object_name from all_objects where object_name = 'CHECK_FOR_NAME'; If nothing is returned, it has not been stored in the database or you don't have rights to view it using your current schema. If you did put it in the database, did it go in with NO errors. [EMAIL PROTECTED] 07/23/01 02:26PM Hi again everybody, I'll try to be as descriptive as possible, sorry if I leave anything important out. I have the following function which I'm compiling using PL/SQL Developer (tnx Djordje). CREATE OR REPLACE FUNCTION check_for_name ( p_name_to_check VARCHAR) RETURN BOOLEAN IS CURSOR c_namestbl IS SELECT lname FROM names WHERE lname = p_name_to_check; v_return_value BOOLEAN; BEGIN OPEN c_namestbl; IF c_namestbl%NOTFOUND THEN v_return_value := FALSE; ELSIF C_namestbl%FOUND THEN v_return_value := TRUE; END IF; RETURN v_return_value; CLOSE c_namestbl; END check_for_name; It compiles without errors (now). The table 'names' is built like this : SVRMGR DESCRIBE names; Column NameNull?Type -- FNAME VARCHAR2(20) LNAME VARCHAR2(20) SVRMGR With data like this : SVRMGR SELECT * FROM names; FNAMELNAME BruceWillis SalmaHayek Tom Cruise Elle McPherson 4 rows selected. But, whenever I try to do this : EXECUTE check_for_name('Cruise'); so I can run the function from PL/SQL Developer I get the following error : ORA 0900 - Invalid SQL Statment However, If I execute the same statement from SQL*Plus or svrmgrl I get a differant error : SVRMGR EXECUTE check_for_name('Cruise'); check_for_name('Cruise'); * ORA-06550: line 2, column 2: PLS-00221: 'CHECK_FOR_NAME' is not a procedure or is undefined ORA-06550: line 2, column 2: PL/SQL: Statement ignored I'm running Oracle Enterprise Edition 8.1.5.0.0 on Windows 2000. If that's not enough info, please let me know and I will supply whatever I can. Thanks for reading this far :) Michael. -- 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: Update ALL colums without knowing their name??
If all you are trying to do is replace the rows in table1 with the contents of table2 do the following truncate table table1; insert into table1 select * from table2; commit; If you want to append the data, leave out the truncate. [EMAIL PROTECTED] 07/23/01 05:33PM Hi, I need an universal update procedure in which I don' t know the colums name. How can I make an update like this: Update Table1 set Every_columns = ( Select * from Table2) I tried set Table1.* wiht no result. How can I work around this? Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: pls help..
It sounds like someone made a datafile on a raw disk. [EMAIL PROTECTED] 07/20/01 08:46AM hi list, can anyone pls explain it. i've found a datafile related to a new tablespace TABSPACE_2 ( not created by me) in v$datafile view. the path of datafile is also ambiguous.. i.e. something like.. DISKA:TABSPACE_FILE2.DAT no full path is shown.. and also i could'nt find the file on my system. this is surprising me a lot.. the TS is shown created on yesterday and is of 20 mb in size. how do i figure out, why is it so. how do it came here with such file location. i've 815 on NT pls suggest. thanks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] It is O'Brien Gere's policy to respect the privacy of its employees and third parties communicating with O'Brien Gere via e-mail. However, the O'Brien Gere e-mail system may not be used for any illegal purposes or for the transmission of material that is libelous, vulgar, obscene, invasive of another's privacy, unlawful, harassing, abusive, threatening, harmful, or otherwise objectionable [objectionable material]. This includes anything that may infringe on the intellectual property or rights of another. O'Brien Gere may monitor communications but is under no obligation to do so. O'Brien Gere may, in our absolute discretion, remove, block or filter any material if in our view it is objectionable material or otherwise inappropriate. -- 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: how to make PL/SQL wait for 60 seconds
The following code would sleep for 60 seconds. declare val number; begin val := 60; DBMS_LOCK.sleep(t); end; [EMAIL PROTECTED] 07/20/01 08:46AM I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? 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). This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] It is O'Brien Gere's policy to respect the privacy of its employees and third parties communicating with O'Brien Gere via e-mail. However, the O'Brien Gere e-mail system may not be used for any illegal purposes or for the transmission of material that is libelous, vulgar, obscene, invasive of another's privacy, unlawful, harassing, abusive, threatening, harmful, or otherwise objectionable [objectionable material]. This includes anything that may infringe on the intellectual property or rights of another. O'Brien Gere may monitor communications but is under no obligation to do so. O'Brien Gere may, in our absolute discretion, remove, block or filter any material if in our view it is objectionable material or otherwise inappropriate. -- 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: UNIX
What are you trying to do? If you need more space in a tablespace, you can create a datafile on /u03. If you actually need additional space on /u06, you will need to manage your drives with a DISK/Volume management software such as DiskSuite on Solaris. [EMAIL PROTECTED] 07/16/01 01:45PM Is anyone familiar with how to grab space in one file system and allocate it to another? For example, if file system /u03 is at 3% and /u06 is at 80%, how can I grab space from the /u03 file system and allocate to /u06?? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] It is O'Brien Gere's policy to respect the privacy of its employees and third parties communicating with O'Brien Gere via e-mail. However, the O'Brien Gere e-mail system may not be used for any illegal purposes or for the transmission of material that is libelous, vulgar, obscene, invasive of another's privacy, unlawful, harassing, abusive, threatening, harmful, or otherwise objectionable [objectionable material]. This includes anything that may infringe on the intellectual property or rights of another. O'Brien Gere may monitor communications but is under no obligation to do so. O'Brien Gere may, in our absolute discretion, remove, block or filter any material if in our view it is objectionable material or otherwise inappropriate. -- 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: UNIX SA
What UNIX OS are you interested in administering? While many commands are the same, there are differences between the various flavors of Unix. [EMAIL PROTECTED] 07/09/01 11:55AM Dear list ! I'd like to start getting into some beginner level UNIX (Solaris) system administration . I have some knowledge in UNIX (scripting, basic commands , etc ... - user/programmer/DBA level , not a sys. admin. level). Can U please recommend what to start with ? I prefer free resources on the web over the books i'll have to buy, off course. Thanks a lot for your recommendations. Andrey. -- 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: Oracle support phone number
1-800-223-1711 . Please be aware that this number will require you to enter your CSI number and it will only work for those people who have a gold or silver support contract. [EMAIL PROTECTED] 07/09/01 04:05PM Could somebody give me support 800 or long dist. phone number. I know that I need to log itar first but this is a damagement request and I cannot find mine. Alex Hillman -- 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). -- 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: Need help getting started
My first question is what is your field of study in school? Is it computer related? Have you graduated, many employers want to see you graduate before they will hire you. Have you asked any of your larger companies about any IS extern programs that they might have. If you have graduated, have you put your resume into some of the job search engines like monster.com or hotjobs.com? Don't give up, the IS field is still hot, but not equally hot around the country. You might want to think about relocating (after getting a job) to a better job market. [EMAIL PROTECTED] 06/19/01 11:15PM This is kind of a different Oracle question. Does anyone have any suggestions how a person can land an entry level job. I do not work in the Technology field but would very much like to. I have been going to school at night for about two and a half years and have the first two OCP developers tests behind me and am working on the third now. I have a 3.9 GPA and can't even get an interview. How do you get experience if no one will hire you? I have even offered to work for free in the evenings or on my days off. I live in Minneapolis and would really appreciate any suggestions that anyone might have. Thanks, Karen -- 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: SQL DISTINCT alternate
UNIQUE is just another way of saying DISTINCT. They do the same thing. [EMAIL PROTECTED] 06/20/01 02:26PM What about using UNIQUE Select UNIQUE. Seema Singh wrote: Hi In a sql stmt what will be the impact if we used DISTINCT clause and how we can overcomes on the performance bottleneck caused by DISTINCT. like ... SELECT DISTINCT A,B,C FROM TAB_1 I want to get same output without using distinct?Is this possible?If, YES then how? Thanks in advance -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: user defined data type
A date field contains both the date and time. If you only want to display the time use a call to to_char(my_date,'HH:MM:SS'). If for some reason you REALLY only want to store the time of day, I would store the number of seconds since midnight in a number. for example 6:32.35pm would be (18*60*60) + (32*60)+35 or 66755. This would allow the user to sort by the time. A third way would be to use a varchar2 field and store the time as HHMMSS or using my example above '183235'. [EMAIL PROTECTED] 06/20/01 02:54PM Hi, Developers need a datatype which only stores the time portion of date i.e. HH24:MI:SS... Any ideas how to create this data type. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: duel error
And one more thing. The table dual has one column called dummy with is defined as varchar2(1). and contains ONE row with the value of 'X'. [EMAIL PROTECTED] 06/19/01 02:13PM Who were you logged on as when you recreated it? Did you create a public synonym for user.dual? You should create the table as sys.dual and create the public synonym for it. That should fix your problem HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 1:51 PM hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: duel error
Wrong, DUAL is a table owner by the SYS user that contains one row. Check your DBA_TABLES and DBA_OBJECTS views. [EMAIL PROTECTED] 06/19/01 03:56PM Dual is not a table. It just a placeholder. At 11:04 AM 6/19/01 -0800, you wrote: You could always just run catalog.sql as sys. -Original Message- Sent: Tuesday, June 19, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Your email says duel. You created dual, with an a, right? And did you grant select on dual to public? And create a public synonym for it? HTH, Yosi Shirish Khapre wrote: hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hal Wigoda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Working from home
an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYS vs SYSTEM
What account I use depends on what I am doing. For example to set up roles, grant rights, and create users I use the SYSTEM account. For anything else, I use my DBA account. The reason is that if I ever leave and my account is removed, all those rights that I granted and all the roles that I created would go away. The SYSTEM account will never be removed. We learned this the hard way because we had a DBA leave and we removed his user id. [EMAIL PROTECTED] 06/15/01 05:55AM Hi all, I generally use SYSTEM rather than SYS for DBA work, and would like to discourage the use of SYS as much as possible. Partly because it bypasses auditing and the profile, and also because I tend to regard SYS as being for Oracle-specific things (like running scripts from $ORACLE_HOME/rdbms/admin) and SYSTEM for doing the day-to-day tasks (like administering storage, performance monitoring etc). Does this reasoning make sense? And, what would be a good way to explain it to developers who've gotten used to writing app installation scripts than run as SYS (for example, they might refer to AQ$_AGENT rather than SYS.AQ$_AGENT)? Thanks, g. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYS vs SYSTEM
That might be true in Oracle 8, but was a problem in Oracle 7. Just being paranoid. [EMAIL PROTECTED] 06/15/01 11:11AM Bill, Roles created by a user never go away. They are not attached to the user. They belong to the system (I just tried this in 816 - created a user, granted CREATE_ROLE to that user, connected as that user, created a role and dropped the user - the role still exists). Likewise grants to database objects. Once they are established, they exist on their own. Dropping the user who granted the access has nothing to do with the grant itself (unless it is to objects that existed in the dropped users account, because these objects go away). I never user the SYS or SYSTEM accounts to create accounts, roles or perform grants. I use SYS (or internal) for db startup and shutdown and Rman backups only. I create a DBA account (which owns the schema for the database) to do all of the create account, roles and object grants. I actually don't even know the System account password - if I really need to get into it, I alter the password to a new string and connect to it. I'm not saying that you are doing anything wrong. Every DBA has their own way of doing things, and your way is perfectly fine (not that you are asking for approval! :) ). At least you are not using the SYS or SYSTEM account for schema objects. I saw this happen once! Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 15, 2001 9:31 AM To: Multiple recipients of list ORACLE-L What account I use depends on what I am doing. For example to set up roles, grant rights, and create users I use the SYSTEM account. For anything else, I use my DBA account. The reason is that if I ever leave and my account is removed, all those rights that I granted and all the roles that I created would go away. The SYSTEM account will never be removed. We learned this the hard way because we had a DBA leave and we removed his user id. [EMAIL PROTECTED] 06/15/01 05:55AM Hi all, I generally use SYSTEM rather than SYS for DBA work, and would like to discourage the use of SYS as much as possible. Partly because it bypasses auditing and the profile, and also because I tend to regard SYS as being for Oracle-specific things (like running scripts from $ORACLE_HOME/rdbms/admin) and SYSTEM for doing the day-to-day tasks (like administering storage, performance monitoring etc). Does this reasoning make sense? And, what would be a good way to explain it to developers who've gotten used to writing app installation scripts than run as SYS (for example, they might refer to AQ$_AGENT rather than SYS.AQ$_AGENT)? Thanks, g. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: How to re-arrange the nullable columns
It makes no difference in performance where the not null columns are placed. Why do you want to go to the headache of modifying the table structure for something so trivial? [EMAIL PROTECTED] 06/12/01 08:45AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Enforced Costraints ??
access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Digestive
That really turned my stomach 8-) [EMAIL PROTECTED] 06/12/01 01:27PM SET ORACLE-L DIGESTIVE = Hamid Alavi 4268 Flintlock LN Westlake Village 91631 PH: 818-8790966 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hamid alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 9i download
I could never successfully download the file. I ended up getting the CD. [EMAIL PROTECTED] 06/04/01 11:15AM I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Script and control file
see the host command in pl/sql [EMAIL PROTECTED] 05/29/01 11:15AM First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script. Example: - inside the script I want to create a new table TABLE1 - copy some data inside TABLE1 using SQL loader - work on TABLE1 using SQL language. Is it possible do this inside a .sql file ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Script and control file
As Jared pointed out (shame on me), there is no host command in PL/SQL, the only place where the host command is supported in in sqlplus and forms. Jared Still [EMAIL PROTECTED] 05/29/01 02:10PM On Tuesday 29 May 2001 09:07, William Beilstein wrote: see the host command in pl/sql Bill, I know you know this: there is no host command in pl/sql. Assuming you meant sqlplus. :) Jared [EMAIL PROTECTED] 05/29/01 11:15AM First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script. Example: - inside the script I want to create a new table TABLE1 - copy some data inside TABLE1 using SQL loader - work on TABLE1 using SQL language. Is it possible do this inside a .sql file ? Thanks, Andrea -- 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: How to number the retrieved rows
select rownum,column1, column2 from tablename Rownum is the counter of the returned rows. The first row will return 1, the second 2, etc... Rownum is only valid for the select and there is no guaranteed that the same rownum will be attached to the same row in the future. [EMAIL PROTECTED] 05/29/01 05:23PM Hi! Is there a way to show a number in front of every row retrieved through a select statement...? select column1, column2 from tablename The output should look like: 1column1_value column2_value Any idea how I can achieve that? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Nothing to do with Oracle : But is is very important :
My main problem is that his message is of a form that a virus would use. Impersonal and set up to try to get the user to click the link. As soon as I saw it, I immediately deleted it. I would never follow the directions from an email like that. [EMAIL PROTECTED] 05/22/01 10:15AM I suppose this is an invalid address but keep this crap off of the Oracle-L list. You will likely find little sympathy using this spam approach. Both sides in this conflict have a significant amount of blame to accept. Violence breeds violence. Throwing rocks, blowing up innocent civilians, shooting babies will solve nothing but neither side seems to understand this. - Brian --- palestine Qods [EMAIL PROTECTED] wrote: Hello, Please take a look at this and give your reaction : http://www.humanityonhold.com/intifada.html YOUR REACTION PLEASE THANKS A LOT Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: palestine Qods INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! 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: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Table last updated data
Trigger, Oracle doesn't maintain last update date for a table. I would put a last modify column in the table with a trigger to maintain it. then you could see when each row was inserted or modified and could tell when the table was last modified by using the following selectSELECT MAX(LAST_MODIFY) FROM MY_TABLE; [EMAIL PROTECTED] 05/10/01 11:21AM Does Oracle capture a last updated date whenever a table update occurs? Or do I need to create a trigger to handle this? Thanks... D. James Stein Senior Developer/Database Engineer [EMAIL PROTECTED] 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 x165 Cell: 941-633-4698 Fax: 941-337-1605 www.neom.com www.paperclick.com www.qode.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Stein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Taking your time when a crisis occurs
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 Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, === message truncated === = 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). -- 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: list table in schema
If you have dba priviledges, you can issue the select select table_name from dba_tables where owner = 'SCHEMA_NAME' order by table_name; [EMAIL PROTECTED] 05/07/01 01:35AM This won't work. TAB is a synonym for USER_TABLES. Although this is present in current DB releases, it's there for backward compatibility purpose and its use is not recommended. The other two solutions were perfectly alright. HTH, Rajesh -Original Message- Sent: Monday, May 07, 2001 12:10 AM To: Multiple recipients of list ORACLE-L I think even this one should work: select * from Schema_onwer.tab ; Correct me if I am wrong. I did not test it though. Raj. -Original Message- From: Vikas Kawatra [SMTP:[EMAIL PROTECTED]] Sent: Sunday, May 06, 2001 12:05 AM To: Multiple recipients of list ORACLE-L Subject:RE: list table in schema Logon as schema owner : Execute : Select table_name from user_tables ; -Original Message- Sent: Friday, May 04, 2001 10:00 PM To: Multiple recipients of list ORACLE-L hello how can i list all table in a schema ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jimmy Lim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: multiple schema in a database ???
Having multiple schemas is a very normal part of an Oracle Database. For example, our current database has 70 different schemas [EMAIL PROTECTED] 05/07/01 03:00AM Andrea Oracle schrieb: 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). --- This Mail has been checked for Viruses Attention: Encrypted Mails can NOT be checked ! *** Diese Mail wurde auf Viren ueberprueft Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! Hi, I think that you're database won't work that well anymore if you try to get rid of PUBLIC. Why would you want to do that in the first place ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: multiple schema in a database ???
Oh by the way, an easy way to set up the same structure for each user is to build all the tables in a setup schema, then do the following. 1) Export everything in the setup schema using the following command exp userid=setup/pass file=setup.exp 2) Create the new schema (user), making sure to set the temporary tablespace and default tablespace to the correct tablespaces. Make sure that the user is granted the CONNECT role. 3) set the quota on the default tablespace to a unlimited or a reasonable max. In a class environment, I would suggest a set size. Set the quota on all other tablepsaces to none. 4) connected as the dba, import the export from the setup schema into the new schema using the following command. imp userid=dbauser/pass file=setup.exp ignore=y fromuser=setup touser= newuser When you are done, you have an exact copy of the tables, indexes, sequences... that were in the setup schema. [EMAIL PROTECTED] 05/07/01 09:26AM Having multiple schemas is a very normal part of an Oracle Database. For example, our current database has 70 different schemas [EMAIL PROTECTED] 05/07/01 03:00AM Andrea Oracle schrieb: 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). --- This Mail has been checked for Viruses Attention: Encrypted Mails can NOT be checked ! *** Diese Mail wurde auf Viren ueberprueft Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! Hi, I think that you're database won't work that well anymore if you try to get rid of PUBLIC. Why would you want to do that in the first place ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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
RE:
That was totally uncalled for. It is obvious that they were sending a help command to ListGuru and sent to the list instead. Lighten up. [EMAIL PROTECTED] 05/07/01 03:52PM Are you an idiot?? -Original Message- Sent: May 07, 2001 3:31 PM To: Multiple recipients of list ORACLE-L help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hutchins, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Input truncated to 1 characters
I get the exact same message every time and the procedures always work and there are no invalid objects in dba_objects. I think you can safely ignore the message. I have no idea why it comes out, hopefully someone else can spread some light on that. [EMAIL PROTECTED] 05/03/01 11:56AM I noticed when I install procedures, i get this message: Input truncated to 1 characters can someone help explain this to me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: URGENT..not importing previous export!!!!!!!!
Remember use ignore=yes to ignore create errors on existing tables, users. If you don't, the import will probably fail. [EMAIL PROTECTED] 05/02/01 02:06PM import the exported files after making the same structue(tablespace and users) as there were in previous install. You don't have to create the users. The import will create it for you. Also in your case you don't have to create the database as the same path already exists as old database. It may be not importing because you have already created the users and when import file tries to create the user it fails and skips it. Try this -- create fresh 8.1.5 database -- run catexp.sql and import complete database. Brijesh -Original Message- Sent: Wednesday, May 02, 2001 2:46 AM To: Multiple recipients of list ORACLE-L hi all, there is an urgent problem that cropped up while i had some problems with oracle 8(version 8.0.4) database and after taking all the necessary backups, full database exports, physical copy of database and net8 folder.. deinstalled it. i then installed oracle 8i (version 8.1.5) and tried to import the exported files after making the same structue(tablespace and users) as there were in previous install. but there is not even a single table import taking place. will u pls help me in where i'm doing wrong. and how i could restore the earlier export files in this new database. here's some info that may help.. earlier version 8.0.4, sid orcl new version 8.1.5 , sid apex no/name of tablespace and users are exactly matching. -- 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: SQL question
my_string := substr(in_string,instr(in_string,'/',-1)+1); [EMAIL PROTECTED] 05/01/01 04:36PM How would you take the same string /dir1/dir2/test/file.out, and return file.out. Assume you do not know where the last '/' is or how many there are. What I need is a reverse instr function. Find the last occurrance of '/', not the first. Can it be done in sqlplus??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Change email address
You need to UNSUB the list under your old email and SUBSCRIBE to the list under the new. The instructions for doing this are at the end of EVERY email you get from the list. [EMAIL PROTECTED] 04/29/01 11:30PM Hi list member, How do I change the email address in this list so it will send the list messages to my new email address? Searching through HELP of ListGuru but find nothing. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lu Kai Hin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Change email address
Then the old listing is the problem of your previous company. [EMAIL PROTECTED] 04/30/01 11:20AM what if you do not have access to your old email account anymore? -Original Message- Sent: Monday, April 30, 2001 8:00 AM To: Multiple recipients of list ORACLE-L You need to UNSUB the list under your old email and SUBSCRIBE to the list under the new. The instructions for doing this are at the end of EVERY email you get from the list. [EMAIL PROTECTED] 04/29/01 11:30PM Hi list member, How do I change the email address in this list so it will send the list messages to my new email address? Searching through HELP of ListGuru but find nothing. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lu Kai Hin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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: 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: Help - temp tablespace growing constantly
If you have the autoextend off, you might run out of space in your temp tablespace. If you have autoextend on, your temp file will keep growing. If you have a reasonably sized tablespace, you might want to look at the queries or index creations. How big is your entire database and how large is your temp tablespace. For example, we have a database of 35.3 gig and a temp tablespace of 1.5 gig and almost never run out of space. And when we do, it is almost always a bad select that is returning too much data. [EMAIL PROTECTED] 04/30/01 01:10PM No but, when I turned it off it kept running out of space. -Original Message- Sent: Friday, April 27, 2001 4:33 PM To: Multiple recipients of list ORACLE-L Does the temp tablespace has it's autoextend turned off? [EMAIL PROTECTED] 04/27/01 04:55PM Under this situation try to offline temp tablespace and online it immediately. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 26 Apr 2001 13:05:26 -0800 I've got a 8.05(2.6 patch on NT) db that the temp tablespace is constantly growing. It's initially set to 1G , then grows up to around 25G before I drop and recreate it. Called oracle support and they gave me a patch that hasn't helped. Anybody have some hints as to what to look for? -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- 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). -- 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: Windows vs. UNIX
Another reason might be that I have Oracle on a Sun Solaris server and in the last four years, the only time it has gone down is for hardware upgrades and power outages (manually after the building UPS ran down). I don't want to get in a screaming war with all the Bill Gate lovers out there, but UNIX servers are just more stable. On the down side, they do need a more knowledgeable administrator who is comfortable with editing configuration files and using command line tools. I personally like using the command line. You tend to be able to have finer control and much faster command selection. I still shell out to dos on my windows workstation when I want to do mass copies (xcopy), formatiing etc [EMAIL PROTECTED] 04/30/01 05:21PM Roy, Forgive me my lack of understanding, but if you don't know why one would choose Unix over Windows, why are you proposing Unix altogether? Yosi -Original Message- From: Roy Ferguson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 2:46 PM To: Multiple recipients of list ORACLE-L Subject: Windows vs. UNIX this is not to bring up a heated debate over the two platforms... I am making a proposal to move the current access 97 databases to an oralce platform running solaris I would like to put in the proposal a brief reason why a UNIX platform will be better than a Windows platform. the current environment: MS Access 97 databases running on Compaq server. Databases are about 20GB in size... proposed solution: Sun E3500 T3 Storage Array Solaris 8 Oracle 8i Just need a couple FACTS as to why one would choose UNIX over Windows Thanks in advance roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Insert from a table to another
CREATE MY_TABLE(TEST1 NUMBER,TEST2 VARCHAR2(10)); DELETE FROM MY_TABLE; INSERT INTO MY_TABLE SELECT VALUE1,STRING2 FROM MY_OTHER_TABLE WHERE VALUE3 = 7; This insert would insert into MY_TABLE the columns value1 and string2 from the table my_other_table where the column value3 is equal to 7 [EMAIL PROTECTED] 04/27/01 11:26AM Any one whom can give me a good advice, on a pl/sql procedure, that delete data from table a, then runs a query from table b and and that insert this query into table a. Pleas help me with a good example. Thanks Roland Sköldblom -- 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: 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: Help - temp tablespace growing constantly
Does the temp tablespace has it's autoextend turned off? [EMAIL PROTECTED] 04/27/01 04:55PM Under this situation try to offline temp tablespace and online it immediately. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 26 Apr 2001 13:05:26 -0800 I've got a 8.05(2.6 patch on NT) db that the temp tablespace is constantly growing. It's initially set to 1G , then grows up to around 25G before I drop and recreate it. Called oracle support and they gave me a patch that hasn't helped. Anybody have some hints as to what to look for? -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: spool command: echo not work
You can't test the spool that way. Make a file of commands containing the following set echo off set hea off spool test.sql select sysdate from dual; spool off exit Now go into sqlplus and connect then execute the script by issuing the following command. This assumes that the above commands were placed into the file test.sql @test.sql; Your problem is that when the spool command is issued, everything including what you type in will be placed into the file. [EMAIL PROTECTED] 04/25/01 11:15AM Thanks all for replay. I knew echo should work, but for some reason it does not. SQL set echo off SQL set hea off SQL spool test.sql SQL select sysdate from dual; 25-APR-01 SQL spool off SQL !more test.sql SQL select sysdate from dual; 25-APR-01 SQL spool off Any ideas? Thanks. Greg. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Hazelton Sent: Tuesday, April 24, 2001 5:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: spool command SET ECHO OFF Original Message Follows Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 24 Apr 2001 12:12:16 -0800 This is a multi-part message in MIME format. _ 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: Peter Hazelton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gregory Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: spool command
The following command will turn off echoing set hea off pages 0 lines 79 verify off echo off You would issue this just before the spool command [EMAIL PROTECTED] 04/24/01 04:12PM Hi All! It's is possible to spool just output of command , not command itself. SQL select sysdate from dual; 24-APR-01 SQL save sys.sql Created file sys.sql SQL spool test.sql SQL @sys.sql SQL spool off SQL ed test.sql SQL @sys.sql 24-APR-01 SQL spool off I would like to have in my test.sql file just: 24-APR-01. Thanks. Greg. -- 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: PL/SQL-if-statement
v_OWNER_NO:= lpad(to_char(nvl(recCursor.OWNER_NO,0)),6,'0'); [EMAIL PROTECTED] 04/19/01 10:56AM How can I change this pl/sql code, in the while-statement maybe so that if the field OWNER_NO is NULL, then it should be written six characters? The code looks like this: "IF recCursor.OWNER_NO is null then vOWNER_NO := '00'; else v_OWNER_NO:= to_char(recCursor.OWNER_NO); WHILE length(vOWNER_NO) 6 LOOP vOWNER_NO '0'0' || vOWNER_NO; END LOOP; END IF; How shoud I write to fix this script so therw will be written out 6 characters if the field OWNER_NO is empty. I want to use the WHILE LOOP. Any one whom can help me with this? Roland Skldblom -- 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: 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: Oracle's ftp site
ftp://oracle-ftp.oracle.com [EMAIL PROTECTED] 04/17/01 11:00AM Anybody know where oracle has moved (hidden) their ftp address now? What doesn't work: ftp://external-ftp.us.oracle.com ftp://209.246.5.40 ftp://205.227.44.220 ftp://oracle-ftp.oracle.com In case it helps, the error I get says "An error occurred reading the contents of the folder. Make sure the file name is valid and you have permission to access the location specified. Details: The connection with the server was reset." Thanks for any help, Margaret Murray -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: inserting into DATE colum
A database table date column always stores the date and time. For example is the current date and time was 09-apr-2001 at 14:23.32 . INSERT INTO MY_TABLE(MY_DATE) VALUES(SYSDATE); This would store the entire date and time. INSERT INTO MY_TABLE(MY_DATE) VALUES(TRUNC(SYSDATE)); This would store the date with a time of 00:00.00; If you want to insert a date that is formatted in a varchar2 field into a date field you would do the following. insert into TbTABLE values (To_Date('03/09/2001','MM-DD-'), To_Date('03/09/2001','MM/DD/'), To_Date('03/09/2001 11:11:11','MM/DD/ HH:MI:SS)) [EMAIL PROTECTED] 04/09/01 02:26PM Helmut, If you want to insert the date in any format other than 'DD-MON-' or 'DD-MON-YY', you need to specify the date format when you use the to_date function. Prakash -Original Message- Sent: Monday, April 09, 2001 2:01 PM To: Multiple recipients of list ORACLE-L Hi! I have a question concerning inserting data in a DATE column. The deal is that sometimes, I just wanna insert DD/MM/ and in other cases I wanna insert DD/MM/ HH:MI:SS in the same column. How can I handle that? insert into TbTABLE values (To_Date('03/09/2001'), To_Date('03/09/2001'), To_Date('03/09/2001'), To_Date('03/09/2001'), To_Date('03/09/2001 11:11:11')) Do I need to supply formatting information for the date to the insert statement? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Example of pl/sql
If you don't want to do a truncate, delete from my_table; insert into my_table values(1,2,3); commit; [EMAIL PROTECTED] 04/09/01 04:24PM Actually, TRUNCATE is DDL so you can't just issue it in PL/SQL. You'd need to use dbms_sql to issue the truncate. -Original Message- Sent: Friday, April 06, 2001 7:46 AM To: Multiple recipients of list ORACLE-L If you are asking about a code, Probably Begin TRUNCATE ... INSERT INTO COMMIT END In practical this is used for temporary tables I don't know if there is any other use. HTH! Aleem -Original Message- Sent: Friday, April 06, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Subject:Example of pl/sql Anyone who has a good example on a procedure that first deletes all the records in a table and then does an insert? Roland S -- 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A problem to ponder
Have you tried rebuilding your indexes to balance them. If you are running cost based, have you rebuilt your statistics recently? Is this report using a table that is being used as a work table by other processes? [EMAIL PROTECTED] 04/03/01 05:07PM V7.3.4.5 on V2.6 Solaris, if it matters. We generate a bunch 200+ reports (plz don't ask if they are all necessary) nightly via a series of tasks linked togther via shell scripts. In February many, many months before that this one report was averaging 20 minutes plus/minus 4 minutes to complete; night in and night out. Around 5 March this single report would either "never" finish, take 1 - 3 HOURS to complete or complete in about 20 minutes; WITHOUT any apparent reason for the change in elapsed run times. As far as we can tell "nothing has changed"! We've been unable to discern what is different between the nights where it completes in 20 minutes and nights where it does not. On those nights where it "never completes" if the session is KILLED and then re-run manually is ALWAYS completes in about 20 minutes. At this point in time this report is an annoyance and a mystery. We can live with the strange behavior, but would like to better understand why the elapsed times are so erratic. Running bstat/ estat while the report was on the system did not reveal any meaninful results. I'm asking for ideas and suggestions as I'm at a loss. TIA HAND! Charlie M. -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct 858-831-2229 San Diego, CA 92131 The future is here. It is just not evenly distributed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Help - How to declare a cursor inside a FOR ... LOOP ?
It's actually easy. Following is an example declare cursor first is select work_id from my_table; cursor second is select my_desc from my_desc_table where work_id = hold_work_id; hold_work_id number(15); begin for rec in first loop hold_work_id := rec.work_id; for pnt in second loop code to display desc line by referencinf pnt.my_desc end loop; end loop; end; [EMAIL PROTECTED] 04/03/01 04:50PM You're probably right, I think I got stuck on the whole DECLARE BEGIN EXCEPTION END thing. -Original Message- Sent: Tuesday, April 03, 2001 4:36 PM To: Multiple recipients of list ORACLE-L i speak from ignorance, isn't there implicit and explicit cursor declarations and usage? can't you encapsulate that section you have identified in a loop and it will implicitly opens a cursor? then all you have to do is manipulate as needed to generate desired results... === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -Original Message- Sent: Tuesday, April 03, 2001 3:41 PM To: Multiple recipients of list ORACLE-L You can't. It appears that you want to select all the detailed text extries related to a specific problem. You could define a cursor that selects all the detailed entries, or you could read all the detailed entries into a pl/sql table and then search through them. If you use the cursor, then you have to reopen the cursor for each new problem. Dan -Original Message- Sent: Tuesday, April 03, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Hey, Guys: I need to decalre a cursor inside a FOR .. LOOP, because the variables in SELECT statement for the CURSOR are coming from FOR .. LOOP. How could I do this? DECLARE V_AKTIV_NRaktiv.AKTIV_NR%TYPE; V_PROBLEMaktiv.PROBLEM%TYPE; V_ENDDAT aktiv.ENDDAT%TYPE; V_ENDUHR aktiv.ENDUHR%TYPE; V_AUSSAGEW aktiv.AUSSAGEW%TYPE; V_LANGTEXT aktiv.LANGTEXT%TYPE; V_LONGTEXTVARCHAR2(2); V_LONGTEXT_CUR VARCHAR2(13000); V_LONGTEXT_TRIM VARCHAR2(2000); p_PROBLEMPROBLEM.PROBLEM%TYPE; # This part need to be inside FOR.. LOOP, otherwise, I wouldn't get anything. CURSOR AKLangTextCur IS SELECT TO_CHAR(V_ENDDAT, 'MMDD')||' '|| V_ENDUHR||' '|| rtrim(V_AUSSAGEW)||' '|| rtrim(V_LANGTEXT) thisText FROM AKTIV WHERE V_PROBLEM = p_PROBLEM ORDER BY Aktiv_NR; AKLangTextRec AKLangTextCur%ROWTYPE; ### Above BEGIN FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex); V_PROBLEM := pkgFreeText.V_PROBLEM_P(v_LoopIndex); V_ENDDAT := pkgFreeText.V_ENDDAT_P(v_LoopIndex); V_ENDUHR := pkgFreeText.V_ENDUHR_P(v_LoopIndex); V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex); V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex); SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM; ## CURSOR DECLARE should be HERE ## BEGIN OPEN AKLangTextCur; LOOP FETCH AKLangTextCur into AKLangTextRec; EXIT WHEN AKLangTextCur%NOTFOUND; V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText; END LOOP; CLOSE AKLangTextCur; END; V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR; END LOOP; V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000); Thanks a lot for help Wendy _ Do You Yahoo!? Yahoo! Mail http://personal.mail.yahoo.com/?.refer=mailiyfoot Personal Address - Get email at your own domain with Yahoo! Mail. _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- 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 -- Friday Recipe was: Oracle Books on Audio Tapes
(with apologies to the Cookie Monster) Cki!! I love shortbread, go for it [EMAIL PROTECTED] 03/29/01 01:12PM Can you send it through as a .wav file? : ) -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 1:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes Rachel Carmichael wrote: dunno any votes for my shortbread cookie recipe? i move we have the godess' shortbread recipe! seconds?;-) and why do i think it's not going to be good for my diet?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Oracle Books on Audio Tapes
OTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Excel to oracle
Use the save as option in Excel and save as a comma or tab delimited text file. In other words a CSV or TXT file. The CSV is comma delimited, the TXT is tab delimited. SQLLOADER can use either (with the correct control file) [EMAIL PROTECTED] 03/29/01 01:46PM I have a Excel file.How to port the data to Oracle table. I read some artical about using ODBC and things like that.But I am not clear. How can we generate a dat file delimited with comas so that I can use SQlLOADer to port the data. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Excel to oracle
make a tab delimited file and use chr(9) as the delimiter in the control file. [EMAIL PROTECTED] 03/29/01 04:15PM Thanks for all the replies. I am able to load data to the table.the table is having a number column and a varchar column. In the varchar column *some* records are being inserted with double quotes at the beginning and end of the data feild and all witha comma as the end.I don't want these double quote and comma.How do avoid these from going into the table. Thanks Ravindra -Original Message- Beilstein Sent: Thursday, March 29, 2001 11:22 AM To: Multiple recipients of list ORACLE-L Use the save as option in Excel and save as a comma or tab delimited text file. In other words a CSV or TXT file. The CSV is comma delimited, the TXT is tab delimited. SQLLOADER can use either (with the correct control file) [EMAIL PROTECTED] 03/29/01 01:46PM I have a Excel file.How to port the data to Oracle table. I read some artical about using ODBC and things like that.But I am not clear. How can we generate a dat file delimited with comas so that I can use SQlLOADer to port the data. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Real Workstation Requirements
My firm is currently using Oracle Applications 10.7SC and are in the planning stage for 11i. I have been tasked with finding the Workstation requirements for 11i. The Workstations will be running Windows 2000 with Microsoft Office, email client and a number of smaller financial applications. I know that jinitator takes a lot of memory and processor speed to run. Oracle always specifies the absolute minimum requirements for the workstation. I am looking for some real world recommendations for hard drive sizing, memory, processor speed, processor type (Celeron, Pentium...). We don't want the absolute minimum, but allow some room for future growth. Any help would be very much appreciated. William Beilstein. -- 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: Real Workstation Requirements
Thanks [EMAIL PROTECTED] 03/28/01 12:05PM I would say no Celeron processor for sure, I would go with PIII's 500 or above, minimum 128 RAM 256 would be better, at least a 10 gig hd. We use Dell Optiplex workstations, most of them are 500's and we don't run into any problems, most of them have 10 to 20 gig hd's and 256 mb's of RAM. Kev -Original Message- Beilstein Sent: Wednesday, March 28, 2001 11:25 AM To: Multiple recipients of list ORACLE-L My firm is currently using Oracle Applications 10.7SC and are in the planning stage for 11i. I have been tasked with finding the Workstation requirements for 11i. The Workstations will be running Windows 2000 with Microsoft Office, email client and a number of smaller financial applications. I know that jinitator takes a lot of memory and processor speed to run. Oracle always specifies the absolute minimum requirements for the workstation. I am looking for some real world recommendations for hard drive sizing, memory, processor speed, processor type (Celeron, Pentium...). We don't want the absolute minimum, but allow some room for future growth. Any help would be very much appreciated. William Beilstein. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Update existing rows at import
You can't query or modify the same table as the trigger is firing on (The old mutating table problem). What you could do is set up a temp table with a before insert trigger which would query the other table and take the appropriate actions, this would solve you having to run a separate procedure after the temp table was loaded. Or load the temp table and run a procedure. When your done with your insert, truncate the temp table and your ready for your next load. [EMAIL PROTECTED] 03/28/01 04:06PM Can you have a before-insert trigger on your table to do whatever you want and then use conventional sqlldr to load it? winnie "Helmut Daiminger" [EMAIL PROTECTED] on 03/28/2001 12:38:10 PM Please respond to [EMAIL PROTECTED] To: "Oracle DBA List \(Lazy DBA\) \(E-mail\)" [EMAIL PROTECTED], "Oracle List \(Telelist\) \(E-mail\)" [EMAIL PROTECTED], "Joe Sawyer \(E-mail\)" [EMAIL PROTECTED], "Frach Karsten \(E-mail\)" [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Hi! Is there a tool available that allows me to read data from a comma-delimited flat file into Oracle and if a row already exists, updates that record. If the row does not exist, it should insert a new record into the table. Looks to me like SQL*Loader can't do this. How could this be done? This is 8.1.6 on Win2k. Thanks, Helmut 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Request Tracker Call for Assistance
DISTINCT and UNIQUE in a select are synonyms for each other. They produce the same result in Oracle. [EMAIL PROTECTED] 03/27/01 09:31AM Hi All, I have been involved with a perl/DBI trouble ticketing system called Request Tracker. I have done a small piece of the work required to port the system to Oracle. The creators are almost finished but with my new job I cannot devote the time necessary now that they are pushing to a beta release. Jesse needs Oracle testers and both Oracle and perl assistance. The current problem is the use of "DISTINCT" in a select clause from a table that has BLOB/CLOB etc columns. This is an industrial strength web and email ticketing system ala Remedy, but it is under an open source license. http://www.fsck.com/projects/rt/ mailto:[EMAIL PROTECTED] TIA Dave Tobias Brox wrote: Anyone have a helpful suggestion for how to make oracle happy with this: SELECT DISTINCT * from Tablename; Thanks, Jesse I've never tried Oracle, but I'd suggest trying this: SELECT UNIQUE(*) from Tablename; ___ Rt-devel mailing list [EMAIL PROTECTED] http://lists.fsck.com/mailman/listinfo/rt-devel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Exp Imp Overwirte posiible or not?
The DESTROY option on an import indicates whether the CREATE TABLESPACE commands only found in a full export should be executed. Setting DESTROY=Y destroys the data files of the database being imported into. This is only used when you want to rebuild an entire database, not to overwrite data in tables. If you really need the empty all the tables in a schema, disable the constraints on the tables, truncate them, and reenable the constraints. This will only work if the schema is self contained, and it's tables are not used as a foreign key for a table in a different schema. [EMAIL PROTECTED] 03/27/01 01:50PM IIRC, there is a flag for import "destroy=y" to do what you want. This is very dangerous and you should research all the implications before trying it. If you don't have the docs, try http://technet.oracle.com and read up on the import options. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:46 AM To: Multiple recipients of list ORACLE-L Subject: Exp Imp Overwirte posiible or not? Hi All, I want to import data from a user dump file but when i import data, i want to overwrite the existing data . Normally imp utility append data to existing rows. Requirement of application is such that we need to overwrite existing data without dropping objects and its dependent objects. Is it possible with exp , imp utilities or i have to delete data first and then import using imp utility. Is there any other possibility... Environment Oracle8i, Windows NT4 TIA Azhar Siddiq -- 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: 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).
OFFTOPIC - RE: Which is faster, Metalink or...
Water flowing uphill (that never works either) [EMAIL PROTECTED] 03/27/01 02:52PM Turtles walking through peanut butter in January? -Original Message- Sent: Tuesday, March 27, 2001 2:32 PM To: Multiple recipients of list ORACLE-L A snail going uphill through jungle vegetation? Molasses in the northernmost region of the Siberian tundra? _ Do You Yahoo!? Yahoo! Mail Personal http://personal.mail.yahoo.com/?.refer=mailiyfoot Address - Get email at your own domain with Yahoo! Mail. -- 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: Moving user to a different tablespace ...
Export the user, drop it's objects, alter to user to use the correct tablespace as it's default tablespace. Set quota on system to none, set quota on new tablespace to unlimited, import the objects. Done. [EMAIL PROTECTED] 03/23/01 02:07PM look at alter user command, yes break out the documentation and begin reading. joe From: Harsh Agrawal [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Moving user to a different tablespace ... Date: Fri, 23 Mar 2001 08:10:38 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id NAA14937for jtestamail@localhost; Fri, 23 Mar 2001 13:42:01 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Fri, 23 Mar 2001 13:42:02 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2NJjp013747for [EMAIL PROTECTED]; Fri, 23 Mar 2001 13:45:52 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id KAA26614;Fri, 23 Mar 2001 10:29:04 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002D6239; Fri, 23 Mar 2001 08:10:38 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Harsh Agrawal [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: By mistake a user was assigned default tablespace SYSTEM. How we can change it to some new tablespace let's say "TBS1" ? Because if we do export and import it will again import into that "SYSTEM" tablespace. Thanks, - Harsh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 1/2 control file failure - will database halt?
If you have a single corrupted database, replace the bad copy with the good one and restart the database. You should only have to modify the init.ora if the location of the corrupted or missing control file is not reachable. Each control file contains the exact same information. You have multiple control files to protect against losing all your control information. [EMAIL PROTECTED] 03/21/01 03:46PM I've been told a single control file failure will halt the database, even if you've got another control file on a second device; that the database will only come up again after editing the init.ora to remove the reference to the faulty control file and initiating a fresh startup. Is this still true, if it ever was true for any version of Oracle, for Oracle 8.X+? The person who warned me about the halt has been using Oracle since version 5. Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- 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: 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: Why can't I find bug 909635 ?
: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 19, 2001 3:05 AM Hello All, J ust now i got a error select count(*) from s_org_ext. SQLWKS select count(*) from s_org_ext; where S_org_ext is Name of the Table. COUNT(*) -- ORA-01115: ORA-01110: 4: /db/oracle/oradata/tlisuser/data03.dbf ORA-27072: skgfdisp: SVR4 Error: 25: Inappropriate ioctl for device Additional information: 262132 But When I do select x,y,z,t,. from s_org_ext then No error occured. The size of that Table is 2.4GB. Its Initial extent is 1Gb and Next is 1mb. Vesion of Orcale 8.0.5 and OS is Sun solaris 5.6 Developped got this error while executing a procedure. I think that procedurte will be insert into data into s_org_ext. PLease tell me what i will do. I think datafile will be damagaed. can not coiped on OS prompt when last time I took backup. Please help me., Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: djordjej INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: rdbms pricing
Thats a no brainer. You get a single support contract for John Smith, which happens to be the name of everyone working there (wink). [EMAIL PROTECTED] 03/16/01 10:41AM At 06:05 AM 3/16/01 -0800, you wrote: We have a support contract with IBM (for server support), and the support costs could be deceptive if you don't know how IBM works. The cost is on a per user basis. So if you only got one support license, your company would only be allowed to have one NAMED person calling in. If anyone else called in, they would not get any help. And IBM is vey sticky about answering only the named person(s). Yeah, that came up. Interestingly, that quoted price is for 2 named contacts. Dennis Taylor When working towards the solution of a problem it always helps to know the answer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle DBA evolution path - please share your opinion
You should look into getting Palm's wireless pocket DBA, then you could hide in the woods and still get your work done 8-) [EMAIL PROTECTED] 03/15/01 02:50PM -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: jeudi, 15. mars 2001 06:43 nice, very nice. and just in time, as I have decided to "put a stake in the ground" (to quote our CTO) and take back control of my databases. My programmers have been allowed to run riot due to a limited number of hours in the day for me to get things done. No more. Now, where did I leave that kevlar vest? I know the feeling. I've been trying to "organize" our development databases here and encourage some of our QA people / developpers to not install the products in the system tablespace. Also I have mentioned a few times since I've been here that if you want to delete a datafile from the disk, it's best to drop the tablespace from the database first! Of course when the database won't start up they turn to me. This week I'm going through all our databases and changing the sys and system passwords to something else, and creating developper accounts that don't have DBA privilege. When I send out the e-mail outlining my little plan I think I'll have to hire some button men and hit the mattresses. For the next few days I'll be hiding in the bunker. It's probably best if I perform my DBA duties whilst peering out through that little slit. Jacques Kilchoer - master of the Mafia metaphore -- 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).
A question about upgrading Oracle Applications
I am asking in this format because I want the opinion of the DBA who did the work. We are currently using Oracle Applications 10.7SC (Smart Client) with the project module and are looking to go to Oracle Applications 11i. I am looking for any opinions on the ease or headaches of performing an upgrade as opposed to a fresh install. What was your opinion on the Oracle Migration tools. Is there anyone who jumped directly from 10.7SC to 11i? Any information would be appreciated. -- 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).
oracle and America and Microslop
When I ran the original "Oracle and America" e-mail, Windows tried to force a download of an additional package from Microsoft to view it. I don't know what it wants (I wouldn't let it proceed). Microslop is so weak in security, I would NEVER allow a automatic download from anyone without knowing what it was. The other interesting thing is that I was not given an option to exit the download. I had to do the three finger salute and do an end task on the email viewer. I hate Microslop. [EMAIL PROTECTED] 03/12/01 12:35PM I think your friend, well, to put it nicely, was misinformed From: "Bunyamin K.Karadeniz" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: oracle and America Date: Mon, 12 Mar 2001 08:50:26 -0800 one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: number of Mb to add?
Also, expanding the available space on a datafile to handle only the next extent is just not being a proactive DBA. Give it enought room to expand. Also don't forget that the datafile it self can be expanded in size (7.3 and above) up to the available space on the volume or the file size limit of the OS. Unless you have to, you don't have to make another datafile. [EMAIL PROTECTED] 03/12/01 12:20PM Joseph, Well, do you really want to deal with a datafile that small, whether that's KB or bytes? What about when it extends beyond that extent? Usually datafiles less than 100MB are not worth the hassle, and the size should be much larger in a production database. Of course, this is just my opinion... HTH Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -Original Message- Sent: Monday, March 12, 2001 11:20 AM To: Multiple recipients of list ORACLE-L if I get this message, IMP-00058: ORACLE error 1654 encountered ORA-01654: unable to extend index TOTSAPPL.PK_DAILY_OPERATOR_ACTIVITIES by 15006 in tablespace USERS the 15006, is it bytes or rows or what? I just want to know how many bytes to enter as the size of the new ADDFILE. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd) TAR# 1280667.996:Can NT/Win2k server OS defrag
at started the discussion: (thanks!!! ep) -excerpt |Using a little utility called contig I noticed that the Oracle | 8.1.6 datafileson my test NT server are quite fragmented, an | average of 177 fragments perfile, 118 fragments for the OEM | repository datafile. The poor utilitycouldn't do anything with | the database files, they are too large perhaps. | |These were created on an empty server, 8i release 2 went on it | after a defrag,then the OEM. This is on a hard disk with 1.2G of | free space, none of thedatafiles come close to that. | | Why so many fragments? Oracle created thosefiles in one pass, | does NT write randomly to disk or what? | | Won't thishave an impact on my NT database's performance? | | Oracle says tablespacefragmentation is not a big deal, but | fragmentation at the OS level matters.Supposedly that's why NT | and WndowsXX came with defragmentation tools. | |??? | | Is there a registry setting somewhere to tell NT to write | contiguouslyto disk? ---end--- *** CHFREEMA.US 12-MAR-2001 15:40:53 GMT, 12-MAR-01 Local *** The only way to defrag oracle files is to do an export/import. Any 3rd party tool or OEM's defrag option will amount to the same thing. They will take an export and then import the object back in and that will defrag the file. Datafiles, if sized correctly, should never need to be defragged. If you are concerned that there is fragmentation on your oracle file take an export. --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Forgot password for internal , any ideeas what I can do?
Internal is NOT a user, it is the SYS user opened in a special mode. To connect as internal you must have set the Oracle password file to the SYS password and be logged onto the server as the Oracle administrative user. On a Unix system this is normally the "oracle" user with belongs to the "dba" group. Eddy Confer [EMAIL PROTECTED] 03/09/01 04:10PM Pankaj You say that you can change the internal password by connecting as SYS. Connecting from where as SYS? SysMgr. After I connect do I just issues the alter user command to change the internal password. Thanks -Original Message- Sent: Friday, March 09, 2001 1:40 PM To: Multiple recipients of list ORACLE-L Hi Alex, the default is "oracle" if you have not changed that...in case you do...you can change that to whatever you want toby connecting through SYS account.. eNjoy life Technically ;-) Pankaj - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 11:05 PM Hi all, I just forgot the password for internal user, do you have any ideea how I can connect as 'SYSDBA'? Or how I can recover the password. Thx, alex. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Berindei 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pankaj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Re-claiming the space from Table after deleteion
The problem with truncating is that you have to release ALL records and the users procedure is deleting records older then one month, but not the more current records. And while you could move the data into a temp table, truncate, and reinsert the new records into the original table, you can't do this and keep the table available to the users. SHAIBAL TALUKDER [EMAIL PROTECTED] 03/09/01 11:25AM Uttam, I think you are mixing up here. These are two different issues. You are talking about extent allocation and the thread is opened for reclaiming space from a table. As far as I know one can not reclaim space bellow the high water mark from a table. To reclaim the space you have to reduce the high water mark and you can do that by truncating. Thanks Shaibal "Majumdar, Uttam" [EMAIL PROTECTED] wrote: Provided all extents of the desired table are in same size, the incoming data should use the free space. regards; Uttam majumdar -Original Message- Sent: Friday, March 09, 2001 4:56 AM To: Multiple recipients of list ORACLE-L Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- 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). PGE National Energy Group and any other company referenced herein that uses the PGE name or logo are not the same company as Pacific Gas and Electric Company, the regulated California utility. Neither PGE National Energy Group nor these other referenced companies are regulated by the California Public Utilities Commission. Customers of Pacific Gas and Electric Company do not have to buy products from these companies in order to continue to receive quality regulated services from the utility. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Majumdar, Uttam INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. -- 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: Re-claiming the space from Table after deleteion
It has always bothered me that Oracle has the compress=Y option on exp, but not a maximum initial extent size. We have a table that is larger then 2 gig and when you create an export, the table can't be imported without pre creating the table. If they had a max extent in exp, we could set it to maybe 1 gig and never have problems. The problem is that an extent must exist in only one data file and most Unix OS's have a max file size of 2 gig (though this is changing in new releases) SHAIBAL TALUKDER [EMAIL PROTECTED] 03/09/01 11:31AM Raghu, If you go with compress = y you will end up with one big initial extent which is not desirable specifically if you are talking about real big tables. just my $0.02 Shaibal Raghu Kota [EMAIL PROTECTED] wrote: Hi Rafi This is the problem many big databases facing!!If you clean up the database every year and reorganizing the database You would't have see this scenario. For the matter fact iam also facing same problem, My one table grown like 22G, I simply can't do any thing?? Iam doing just for Indexes Rebuild for getting what ever space I can avail. As you said you deleted 40% of data!! You can reorganize your Indexes to avail some space. Other wise Export to Tape and reimport it, But here again problem when you say compress=y, due to heavy data Its another big headche?? May be our friends give some ideas??? Thanks Raghu. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: Re-claiming the space from Table after deleteion Date: Fri, 09 Mar 2001 01:56:07 -0800 Dear All, Platform: Solaris 2.6, Oracle: 7.3.4.0 We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to delete the obselete data from the tables. The problem is that the table does not free the space even after the deletion of 40% of the data. How can we re-claim the unused space which got created due to deletion? How do we ensure that future inserts are done in this unused space? [We can not try exp/imp or truncate option due to the huge size high activity and online use of the tables]. Kind Regards and thanks to all there, Rafi Ahmad -- 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). _ 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: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. -- 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: opinions on naming primary keys in new database
We would use something like curt_id, not just id. That way you can query the dba_tab_columns or user_tab_columns to see everywhere a particular key is referenced. "Jeff Cox" [EMAIL PROTECTED] 03/08/01 11:10AM Hugh, You are right that Richard Barker says not to use an entity name as part of an attribute name. (CASE*METHOD Entity Relationship Moddelling, by Richard Barker, page 3-9) And I believe Oracle still gives out this book in their Data Modeling class. I have seen databases that completely follow this method and others that include the table name in every column. As far as naming your primary key as a column called 'key', I don't like it either. I am also curious to see what is the preference of other list members. Regards, Jeff Cox IPS-Sendero Scottsdale, AZ -Original Message- Sent: Wednesday, March 07, 2001 4:58 PM To: [EMAIL PROTECTED] Hello, I wanted to get the lists opinion on the preference of naming primary keys. Please see my example below with the CUSTOMER table, and the customer TYPE table. The column 'type_id' is a foreign key referencing the TYPE table. This is just an example to get opinions. CUST TYPE +-+ +--+ | id | |id| | name| |desc | | type_id |--| | +-+ +--+ I like having my primary keys called id, and not including the table names in the columns of the original table. For example, in the CUST table, we would not have 'cust_id' as the primary key, we would just call it 'id'. But having 'type_id' as a column of the CUST table is okay because that is a foreign key, and not an attribute of the original CUST entity. Including the table name in a column that is not a foreign key, I believe, is redundant and not necessary. (I also remember reading this in a Richard Barker book.) All foreign keys would then have the standard of table_column, with the exception of tables with multiple foreign keys from the same table, and recursive relationships - which would then just include a more descriptive table_column name. This way, when you do a describe on a table, you will immediately be able to tell what are the foreign keys, and the primary keys. (I also believe in surrogate keys for most tables, so the problem of having a composite key is not an issue here.) I think that this will later make the database easier to understand to new DBAs and duhvelopers, which would have been nice when I worked on my first database. My questions: 1) What is your preference with primary and foreign keys - if you could design a database from scratch? 2) Am I off my rocker thinking that this is a good way to design a database? 3) We have a developer who wants to name all of our primary keys, 'key', and I am trying to convince her that we should use 'id' or 'nbr' instead. Has anyone ever used 'key' as the primary key of a table? This seems like it would be confusing when All constructive criticism is welcomed. Thank you, Hugh 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Re[2]:Oracle Licensing
I doubt it, Oracle will say that their profit margins are too low so they will up their licence costs for everyone else. Larry can you spell greed. [EMAIL PROTECTED] 03/02/01 12:35PM Dennis, I'm sitting in the middle of the East Coast dot bomb area. I know of three dot bombs that paid a total of $100 million between them for Oracle licenses. Now that the dot com sugar daddy has been licked clean maybe reality will strike!! Dick Goulet Reply Separator Author: Dennis Taylor [EMAIL PROTECTED] Date: 3/2/2001 8:30 AM At 06:25 AM 3/2/01 -0800, you wrote: the mire. At any rate, there are suppose to be two basic licensing schemes, and GOD only knows how many "allowed" permutations: 1) Power Units which equates to the number of processors times the speed of the processors in Megahertz. Oh, BTW: it matters if their Intel or Risc processors too. Risc processors are more expensive. In general this is the MOST expensive way to go. I went to the oracle site and did some calcs for adding users to Oracle Enterprise. Kept sayin g to myself, "Naw, they must mean *hundreds* of megahertz". Anyway, for a very behind-the-curve system (2x200mhz ppro's), it works out to $4000 per additional user. Or I can look at Interbase/Firebird, which is free. Today I will be assigning one of my staff the task of downloading, installing, and evaluating Firebird. The only way I can imagine that Oracle thinking can be going is: "Hey, revenues are dropping because of competition from free and less expensive dbms's". "No problem. Raise prices to make up the shortfall". Then I say to myself, "Naw, no-one can be that stupid". Then I check the per-user prices again Dennis Taylor Good we must love, and must hate ill, For ill is ill, and good good still. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Revoke system privilege from user
And the next logical question is... If the user can't be trusted around the tables, why was he given the dba role at all. Just give him the specific priveledges he needs. B N RAMAMOHAN [EMAIL PROTECTED] 03/01/01 02:35AM Hi Chuan, You can not revoke Just drop any table from DBA Role, since drop any tables is not granted explicitly. What you can do is create a copy of DBA role and from that role reovke drop any table table priv. Use this new role to grant DBA without Drop any table priv. Regards, Mohan On Wed, 28 Feb 2001, Chuan Zhang wrote: Hi, All, I have granted DBA role to an user. But I don't want him holding the "Drop Any Table" system privilege. I did as follows: 1. Connect as sysdba. 2. revoke drop any table from ABC-user; And I got the error:" ORA-01952: system privileges not granted to 'ABC-user'". Could anyone help me out? Thanks, Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: B N RAMAMOHAN INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: EJB Oracle Sequence
In sql code we would do the following select my_table_s.nextval into my_variable from dual; insert into my_table values(my_variable,.) And then use my_variable for whatever you need it for. "Apps Sol" [EMAIL PROTECTED] 02/26/01 10:25AM Hello , One of our developers have some issues regarding sequences in Oracle Here is what he is looking for "I'm trying to use CMP for beans that map to tables in which the primary key is an integer that comes from an Oracle SEQUENCE. How do I get the container to get the next number from the appropriate SEQUENCE on a create?" Oracle 8.1.6 on Linux Any help.(**( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: More slower CPUs vs. fewer faster CPUs
..and so is the speed of the processors "Gene Sais" [EMAIL PROTECTED] 02/23/01 09:01AM And don't forget Oracle Power Unit Licensing costs? # cpus is a multiplier. [EMAIL PROTECTED] 02/23 8:20 AM I was wondering if it would be better to have three or four relatively slower CPUs than having only two faster ones. I think I remember that Ixora says fewer faster CPUs is better because the CPUs are constantly negotiating who should do what. The more CPUs exist the more time-consuming the debate (this is very simplified, I realize). Jonathan Lewis in Practical Oracle8i: Building Efficient Databases, Adison Wesley, p. says the opposite. Is this another one of those questions that has "it depends" as the only answer? Or that has very plausible theoretical answers that are mitigated in real life? I imagine that the I/O patterns play a part in the validity of either answer. Has anyone on this list tested to see which would be faster? We are on Compaq Tru64 UNIX alphas, upgrading to ES-40s with up to four CPUs. My database is a mix (mess) of background tables for web apps, ad hoc querying, sporadic intensive data loads and in the near future: replication. Opinons? TIA Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion 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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OFF-TOPIC: A little Friday levity for MS bashers.
I really needed a good laugh. Everyone at my site was laughing their butts off. "Jesse, Rich" [EMAIL PROTECTED] 02/23/01 10:00AM RTFM, I guess. ;D http://support.microsoft.com=support=kb[EMAIL PROTECTED]/pub/mskb/Q20935 4.asp Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: MetaStink, Redux
I called up oracle and they said that they are installing a new version of MetaLink and that is why it has been flaky lately. "Mohan, Ross" [EMAIL PROTECTED] 02/22/01 12:45PM Actually they are on SUN. You know, the "dot in dot com". LOL!! :-) -Original Message- Sent: Thursday, February 22, 2001 12:06 PM To: Multiple recipients of list ORACLE-L They must be testing Windows 2000 as possible platform... -Original Message- Sent: Thursday, February 22, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Is it me, or is MetaBlink on the fritz again? I get truly odd refresh times and behavior.. -- 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: Oracle and Win2k
Developer 2K comes in both a win9x and a winnt version (on the same cd in 4.5). We have loaded the NT version onto a number of NT servers, workstations, and Win frame machines with no problems. [EMAIL PROTECTED] 02/20/01 01:55PM Hello All, Being the netadmin here (not the DBA) I am put in the position of trying to maintain all my various platforms. The management staff has agreed that everyone should be using the same software (great for me) and Win2k should be on all systems (servers and workstations). What kind of headaches can I expect on the DBA's NT4 workstation with the OMS console(?) and OEM configurations, as well as the NT4 Servers that are running 8.1.6? Thanks for any input. Daniel Curry Sr. Systems Engineer [EMAIL PROTECTED] Tsola, Inc. 650.486.2624 Fax:650.486.2650 -- 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: 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: How to find DUPLICATE KEYS FOUND
delete from pa_answer where rowid in (select rowid from p_answer pa where rowid (select min(pa2.rowid) from p_answer pa2 where pa.p_id = pa2.p_id and pa.p_name = pa2.p_name)) Larry Taylor [EMAIL PROTECTED] 02/20/01 03:15PM Thanks William it worked, but how to delete it? -Original Message- Sent: Tuesday, February 20, 2001 9:36 AM To: Multiple recipients of list ORACLE-L how about select rowid,p_id,p_name from p_answer pa where rowid (select min(pa2.rowid) from p_answer pa2 where pa.p_id = pa2.p_id and pa.p_name = pa2.p_name) This will display the p_id,p_name and rowid of all the duplicate rows that have the same p_id and p_name. Larry Taylor [EMAIL PROTECTED] 02/20/01 11:56AM Hi all, How can I find duplicate keys and drop the duplicate? My database is 8.1.6 and I tried the following and got this error: CREATE UNIQUE INDEX I_SA_C_OWNERID_C_NAME ON P_ANSWER (P_ID , P_NAME ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536) LOGGING TABLESPACE USERS; ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found Thanks in advance. Larry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shutdown Abort...Open normal??
STARUP FORCE - Issue a shutdown abort and then try to immediately restart the database. STARTUP RESTRICT - Open the database and only allow access to users with the RESTRICTED SESSION role. STARTUP MOUNT - Mounts the database, but doesn't open it for use. STARTUP NOMOUNT - Does not mount the database STARTUP RECOVER - Similar to the recover database command. It starts the database and attempts a recovery. STARTUP OPEN - Mounts and Opens the database STARTUP - Default open, which is STARTUP OPEN. "Raghu Kota" [EMAIL PROTECTED] 02/16/01 04:10PM Hi Friends Could you explain this.. SVRMGR connect sys as sysoper; Password: Connected. SVRMGR shutdown abort ORACLE instance shut down. SVRMGR startup open; ORACLE instance started. Database mounted. Database opened. SVRMGR I thought recovery is needed, But its opened? Thanks Raghu. _ 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: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Public Synonym SYSTEM causing Problem with Export
How about removing the public synonym and create a private one in the schemas that need it. Except for a table or procedure that is truly global, making a public synonym is never a good idea. "Nisha Patel" [EMAIL PROTECTED] 02/13/01 09:55AM Hi All, I have a really wierd problem with a client who has tried to export the whole database. They get errors because there is a public synonym called System created by a user FCAADMIN. This public synonym caused several oracle supplied objects to go invalid resulting in the failed Oracle exports. I know we should not have a table called System but I had inherited the database and it is too late in the game to rename it. Does anyone have any solution to this problem? Thanks in advance, Nisha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nisha Patel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL parameter for batch runs [NT]
I have shutdown and startup scripts run by the root process via cron or init.d (automatic scripts at startup or shutdown). These scripts shell to the Oracle account, but because they start as root the scripts do not need the Oracle password. If you are running as the Oracle account you connect internal, which needs no password entered, and do your shutdown and startup's "O'Neill, Sean" [EMAIL PROTECTED] 02/08/01 08:50AM Hi Folks, I have some SQL scripts which I use to Shutdown and Startup DBs. The SQL scripts are called from OS batch files and run using AT schedule service. Problem, or so I perceive it as being, is that I use SYSTEM user as part of script to connect to DB to Startup/Shutdown and I have the password for same (horror of horrors???) in the SQL script. So I'm wondering how othger folks manage the same process. Do you use the OS file protection to protect the SQL file from prying eyes or perhaps a particular Oracle account stripped of unecessary privs etc to include in script OR is there a antoher more secure way around this issue that I just have not realised?. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ascii code of tab?
There is a very helpful Microsoft help file available at http://ourworld.compuserve.com/homepages/r_harvey that contains references for everything from ascii to codepages, and the best part is that it is free. David Barbour [EMAIL PROTECTED] 02/05/01 04:25PM ^I Dec - 9 Oct - 011 Hex - 09 David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message- Sent: Monday, February 05, 2001 12:57 PM To: Multiple recipients of list ORACLE-L What is ascii code of TAB? Thanks __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 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). -- 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).