RE: SQLPLUS on UNIX
Ave ! Set environment variable EDITOR=vi Br.Jorma -Original Message- Sent: 13 September, 2003 10:09 To: Multiple recipients of list ORACLE-L Dear Friends, ed command in SQLPLUS( on UNIX ports )not working. I hope there is some EDITOR setting to use VI editor, but forgot where to do that. Can somebody give a thought. Thanks Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Transparent database objects after merging
Ave ! If it's so, that user_a like to use customer table and user_b customer_b table with same application, why You can't use synonyms? User_a synonyms points to customer table and user_b synonyms points customer_b table etc. Or is there some decision making before start using application: "Now I want use customer table and now I want user customer_b table"? If so, create two database users, whose synonyms points to different tables. When user logs in, he selects appropriate login username depends, which tables he wants to use. Too simple :) ? HTH Jorma -Original Message-From: ext [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 16 July, 2003 07:29To: Multiple recipients of list ORACLE-LSubject: Re: Transparent database objects after mergingThank you for your idea, Mark, To explain more about the problem Before we have 2 databases which they both have same sturcture and same database objects names. We have 2 set of D2K forms and reports to access to each database. After merging, we looking for move data from database B to database A but still be able to access by using the different of forms and reports. However the tables which be move from database B to datbase A, will be rename to table_B. The developer just throw me a fire ball that what-if they don't modify the forms and reposts, is it possible to have one set of the forms access the table_B UK "Mark Richard" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2003 12:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: Transparent database objects after mergingAlso, depending on your requirements (which I don't fully understand)another approach may involve using views:The CUSTOMERS view could point to either CUSTOMERS_A, CUSTOMERS_B or eventhe merge of both tables (select * from customers_a union all select * fromcustomers_b) if required. Of course you may introduce primary and foreignkey problems, but like I said - I don't fully understand your requirementso I'm just throwing ideas up in the air.Regards, Mark. "Arup Nanda" [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: Re: Transparent database objects after merging [EMAIL PROTECTED] .com 16/07/2003 13:59 Please respond to ORACLE-L You can drop or rename CUSTOMERS to, say, CUSTOMERS_A, and then createsynonym CUSTOMERS pointing to CUSTOMERS_B. Or rename CUSTOMERS_B toCUSTOMERS.HTH.Arup Nanda- Original Message -From: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-LSent: Tuesday, July 15, 2003 11:29 PMSubject: Transparent database objects after mergingHello Gurus, I'm working merging 2 databases which have sane structure ofdatabase objects into one database. However, after merging, the businesspolicies and regulations force us to have 2 set of database objects; forexample :Database A has CUSTOMERS table.Database B has CUSTOMERS table.After merging database A will have CUSTOMERS and CUSTOMERS_B (data fromdatabase B). I just wonder that is there any way that we don't need tochange our script in forms and reports to point into a new table name butstill can access to the data in the new table ( CUSTOMERS_B) notCUSTOMERS.Thank you for any comment and suggestion.Ukrit K, Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone.In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltdshall be
RE: Rollback Segs
Ave ! Is there any reason not to keep maxextents always unlimited :) Extentsize should be reasonable of course. Br. Jorma -Original Message-From: ext venkat Rama [mailto:[EMAIL PROTECTED]Sent: 16 July, 2003 07:34To: Multiple recipients of list ORACLE-LSubject: Rollback Segs Hi Friends, I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some ofbig tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use rollback segment rbs_big? I tried to set as first stmt, but its not using rbs_big segment, its using some other rollback segment. Is that good idea to make all my rollback segs maxextents unlimited to avoid maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw one time, one of my rbs segment extented 2gb and failed transaction with maxextents reached with 5m initial and next, minextents 20 and optimal 100M. Any help will be appreciated Thanks venkat. Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!
RE: How to stop script
Ave ! Here is one possible solution. Create two tiny scripts. First script let say ex.sql which includes only word exit and linefeed and second one cont.sql which has only one space character, nothing else. Then in Your sql script: -- column NAME noprint new_value SCRIPT_NAME select decode(name,'TEST','cont.sql','ex.sql') NAME from v$database; @SCRIPT_NAME -- So if Your database is TEST, then You run cont.sql (nothing happens), but if it's something else, You run ex.sql which stops Your sqlplus session. HTH Jorma -Original Message- Sent: 17 June, 2003 07:39 To: Multiple recipients of list ORACLE-L I have a script and can be run on commandline like: sqlplus usrname/password@TEST @import.sql However, I want to check database name at the beginning of import.sql. I knew select name from v$database can obtain database name. But how can I stop the script if I found it is not TEST database? In import.sql, it is like: drop user A cascade; create user A ; host imp A/[EMAIL PROTECTED] file=a.dmp full=yes; // some PL/SQL ... Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: What is wrong with this?
You should: select sys_store_id.nextval from dual; or similar to get a value from sequence. Br.Jorma Hallo, I have this sequence, CREATE SEQUENCE SYS_STORE_ID START WITH 1 INCREMENT BY 1 NOMAXVALUE NOCYCLE CACHE 10; I am trying to run this script, sys_store_id.nextval: but get this errormessage: unknown command beginning SYS_STORE_... - rest of line ignored. How can I solve this problem? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Error extensions in the alrtXXX.log
Title: Error extensions in the alrtXXX.log I think the only erros which can exists in alert.og are ORA- -Original Message-From: ext Denham Eva [mailto:[EMAIL PROTECTED]]Sent: 24 January, 2003 11:04To: Multiple recipients of list ORACLE-LSubject: Error extensions in the alrtXXX.log Hello List, Pls help, I am busy playing with a Perl script which I want to read through the error log file each day and mail me when an error has occurred. I have already created the part that will be backing up the alrtXXX.log to another file. So that it starts afresh each morning. OK here are the obvious ones I personally can remember, please let me know of others that I can scan for. ORA- PLS- Errors IMP- Jared would probably have a far better script. Anyway how else dose one learn? without the proverbial "Roll up the sleeves and climb in under the hood" right? Hey, Jared I still intend to buy your book this year, perhaps in the next few months when I hopefully will get something back from the Taxman. Regards Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: Delete duplicate records
Ave ! How about something like: delete from varukorgtmp where varutyp = 3 and EAN = (select EAN from varukorgtmp a where rowid != (select min(rowid) from varukorgtmp b where a.EAN = b.EAN)); Should work, but not tested :) Br.Jorma - Name: Jorma Vuorio Phone: +358-9-7180 67759 Company: Nokia Business Infrastucture Fax:+358-9-7180 67465 Address: P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND Internet: [EMAIL PROTECTED]Mobile: +358-50-486 8043 - -Original Message- Sent: 08 January, 2003 10:24 To: Multiple recipients of list ORACLE-L Hallo, I have this sql, SELECT * FROM varukorgtmp where varukorgid= 120 That makes the result of this testfile.xls (See attached file: start.xls) There are two values in EAN-field, which are the same 23324614 in row 2 and 3 Now I want in an sql script to check out which are the duplicates of EAN in that table. Then then the script will check which is VARUTYP = 3, then delete the record(s) which have VARUTYP =3. So the result should be like this, with only two rows left in this case). (See attached file: result.xls) I would really appreciate if anyone could help me with this sql I have tried several sql, but with no luck. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).