Spooling data containing Umlaut character (DB characterset UTF8)
Hi, We are trying to extract the data from the oracle database 8.1.7. which contains special characters like umlaut. The Characterset of Oracle db is UTF8 and the Character set at Client side is AMERICAN_AMERICA.UTF8. While we spool the data from the Oracle db an extra space (byte) is added if umlaut character exists. For example : 'MĂNCHEN' - If we query the size it shows 7 bytes but while spooling to a flat file it takes 8 bytes. This problem exists only when the umlaut character and normal character exists like the above eg. If data contains only umlaut then we dont get this problem. Any info on this would be of great help. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYSDBA privilege with ORAPWD utility
Tom , I set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE, gave the same name to the pw file as suggested by you (though it was not mentioned anyewhere) and tried; but still it's not working. I can't figure out what can be the problem. Pls help. Chetan -- From: Mercadante, Thomas F[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 6:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: SYSDBA privilege with ORAPWD utility Chetan, The NAME of the password file should be: PWD{sidname}.ORA. For example, if your Oracle Sid name is SB815, your password file should be named PWDSB815.ORA On NT boxes, upper/lower case of the file name does not matter. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 8:38 AM To: Multiple recipients of list ORACLE-L Hi List , I have Oracle 8.1.5 server on Win 2K machine. When I try to connect as SYSDBA using SYS account from a remote machine it says ORA-01017: invalid username/password; logon denied. Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BINcd ..\dbs D:\Oracle\Ora815\DBSorapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBSsvrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR connect internal Password: Connected. SVRMGR grant SYSDBA to SYS; Statement processed. SVRMGR select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYSDBA privilege with ORAPWD utility
Hey , Im able to connect as SYSDBA from all other users (for e.g. WIP, SYSTEM) except SYS. Can anyone pls advise on this. Thanks, Chetan -- From: Yechiel Adar[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 6:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: SYSDBA privilege with ORAPWD utility Hello Chetan I think that you need to have administrator permission on the NT domain to be able to logon as sysdba. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 2:38 PM Hi List , I have Oracle 8.1.5 server on Win 2K machine. When I try to connect as SYSDBA using SYS account from a remote machine it says ORA-01017: invalid username/password; logon denied. Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BINcd ..\dbs D:\Oracle\Ora815\DBSorapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBSsvrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR connect internal Password: Connected. SVRMGR grant SYSDBA to SYS; Statement processed. SVRMGR select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYSDBA privilege with ORAPWD utility
Yechiel , I have administrator permission on the NT domain; but its still not working. What can be possible cause of this ? Thx, Chetan -- From: Yechiel Adar[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 6:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: SYSDBA privilege with ORAPWD utility Hello Chetan I think that you need to have administrator permission on the NT domain to be able to logon as sysdba. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 2:38 PM Hi List , I have Oracle 8.1.5 server on Win 2K machine. When I try to connect as SYSDBA using SYS account from a remote machine it says ORA-01017: invalid username/password; logon denied. Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BINcd ..\dbs D:\Oracle\Ora815\DBSorapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBSsvrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR connect internal Password: Connected. SVRMGR grant SYSDBA to SYS; Statement processed. SVRMGR select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYSDBA privilege with ORAPWD utility
Hei... Is your sys password is correctly mentioned while logon?. I tested your case, it's doing proper, while i misspelled sys pwd, it thrown the error as u mentioned... HTH, Nirmal -Original Message- Sent: Wednesday, September 11, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Hi List , I have Oracle 8.1.5 server on Win 2K machine. When I try to connect as SYSDBA using SYS account from a remote machine it says ORA-01017: invalid username/password; logon denied. Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BINcd ..\dbs D:\Oracle\Ora815\DBSorapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBSsvrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR connect internal Password: Connected. SVRMGR grant SYSDBA to SYS; Statement processed. SVRMGR select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: SYSDBA privilege with ORAPWD utility
Check for these things... 1. REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE in initSID.ora 2. ORA_SID_PWFILE = location_of_ur_passwordfile in the WINDOWS REGISTRY of the server. 3. Check the SYS password, or from some other USER do a 'ALTER USER sys IDENTIFIED BY ...' and then try connecting I hope this works out. Most of the times we miss a very small and obvious thing. Go systematically. Regards Naveen -Original Message- Sent: Friday, September 13, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Yechiel , I have administrator permission on the NT domain; but its still not working. What can be possible cause of this ? Thx, Chetan -- From: Yechiel Adar[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 6:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: SYSDBA privilege with ORAPWD utility Hello Chetan I think that you need to have administrator permission on the NT domain to be able to logon as sysdba. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 2:38 PM Hi List , I have Oracle 8.1.5 server on Win 2K machine. When I try to connect as SYSDBA using SYS account from a remote machine it says ORA-01017: invalid username/password; logon denied. Then I created a password file using ORAPWD utility and granted SYS and WIP (a newly created schema) the SYSDBA privilege. I also ensured that REMOTE_LOGIN_PASSWORDFILE is set to TRUE, but still I can not connect as SYSDBA. Following are the steps which I took. Step 1. Created a password file as followed : D:\Oracle\Ora815\BINcd ..\dbs D:\Oracle\Ora815\DBSorapwd file=orapwsb815 password=oracle8i entries=30 Step 2. Grant SYS user the SYSDBA privilege by the following method D:\Oracle\Ora815\DBSsvrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Release 8.1.5.0.0 - Production With the Java option PL/SQL Release 8.1.5.0.0 - Production SVRMGR connect internal Password: Connected. SVRMGR grant SYSDBA to SYS; Statement processed. SVRMGR select * from v$pwfile_users ; USERNAME SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chindarkar,Chetan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
recovery scenarios
Hello all, when sometimes, oracle will ask tool old archive logs that are even 2-3 days older, when recovering a datafile that is taken from todays backup. does it mean the datafile is not properly backed up or something wrong with controlfile. todya there is another scenario: creating a database with gmittest from the cold backup of production. when we tried to open up after mount, it is saying system datafile needs recovery. I copied all datafiles, ctl files and logfiles too. does anybody have come across such situation. thaks and regards, srinivas __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
killing nohup processes
Hello all, solaris: 2.8 there is a strange problem with nohup compress in unix. I am trying to compress all my export dmp files with nohup compress *.dmp But later I realized and not to do that and grep the process and killed it. But the system is skipping compression of the current file and moving to next file for compression. is there a way to kill the whole process (submitted with nohup) thanks and regards, srinivas __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 11i DBA position in Wisconsin..
You betcha, hey. -Original Message- Sent: Thursday, September 12, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Why yes I can: M-cow Actually, the Dells area (Baraboo is a few miles south) is pretty nice if you're an outdoorsy-type. Or if you just like to live in or near a town that's one big waterpark (including the largest waterpark in the USA). It's about 40 minutes from Madison and 5 minutes to complete privacy. But of course, non-Wisconsinites will be required to drink beer, eat cheese, drink beer, live and die with each Packers game, and drink beer like the rest of us, der hey. Rich Cheesehead Jesse SA/DBA/Beer Drinker [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: * Oracle 11i DBA position in Wisconsin.. Can you say moo-cow. -- 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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Locking Problem
Hi Everybody, I am facing problem while invoice Processing. We have Invoice_Header table and Invoice_Lines Table. One Record in Invoice_Header table can have multiple related records in Invoice_Lines. We have not implemented locking mechanism at header level. So whenever two user working on same invoice it creates problem. Say One Invoice has 10 lines in Invoice_Lines Table and first user pressed the Process Invoice button. It does so many validation and insert records in subledger. Mean while another user can add new lines in same Invoice result is discrepancy in printed copy and system records. Can anybody tell me how to resolve this issue. Thanks Suman DISCLAIMER: Information contained and transmitted by this E-MAIL is proprietary to Mascot Systems Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Before opening attachments, please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suman S 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).
RE: SQL help
Thanks but unfortuneately we only have standard edition so I do not have these features. Rick Larry Elkins elkinsl@flash To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .netcc: Sent by: Subject: RE: SQL help [EMAIL PROTECTED] om 09/13/2002 02:08 AM Please respond to ORACLE-L If you don't want to apply criteria to the first part to see if data from the second part is returned, you can avoid it by using an analytic function. Ok, the examples below might look a little complex, but basically you have your UNION ALL in the inner most in-line view. In the in-line view enclosing that you use the count(*) over to know the total count of rows. You then evaluate that count in the outer most in-line view. If the bottom half returned rows, and you already know the top half will return 1, then a count greater than 1 means you found rows in the bottom query. In this example, note the bottom part of the UNION ALL says 1=2, no row will be returned by the bottom query, and since the total count of rows will be one, no rows are returned (the header is suppressed): 1 select y.x 2 From (select x.x, count (*) over () cnt 3from (select 'x' x 4 from dual 5 UNION ALL 6 Select 'y' 7 from dual 8 where 1=2) x ) y 9* where y.cnt 1 SQL / no rows selected In this case, the bottom half returns a row (1=1), so you will get rows since the cnt is 1: SQL ed Wrote file afiedt.buf 1 select y.x 2 From (select x.x, count (*) over () cnt 3from (select 'x' x 4 from dual 5 UNION ALL 6 Select 'y' 7 from dual 8 where 1=1) x ) y 9* where y.cnt 1 SQL / X - x y Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Subject: SQL help Hi DBAs, I have a query something like SELECT sysdate,'txt1','txt2' FROM dual UNION SELECT date1,txtfield1,txtfield2 FROM t1,t2,...,tn WHERE ... ; The output would be one header record from the first select then the data from the second select. If there are no records selected in second select the header record is still selected. If there are no records in second select I do not want header record selected. How can I suppress it? I do not want to apply the where clause in 2nd select to the first because of the complexity. Thanks Rick -- 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: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
Re: * Oracle 11i DBA position in Wisconsin..
Baraboo is in a fairly rural area more than an hour from Madison or from Milwaukee. Neither of those cities are a vast metropolis. Not everyone is keen to live in the country. Plus I would imagine that a DBA job in this part of the country wouldn't pay a massive salary. However, the cost of living in Baraboo should be very reasonable and Wisconsin Dells is a beautiful area. Cherie Machler Raised on a Wisconsin farm and loves Wisconsin Dells and the Barnum Bailey Circus Museum in Baraboo. Brian_P_MacLean@ eFunds.Com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: * Oracle 11i DBA position in Wisconsin.. 09/12/02 03:18 PM Please respond to ORACLE-L Can you say moo-cow. This is most likely http://www.foremostfarms.com/aboutus/contacts/contact.asp, and if so, I think they have been trying to fill it for about 9 months. H, wonder why? OraStaff orastaff@mindsprTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ing.com cc: Sent by: Subject: * Oracle 11i DBA position in Wisconsin.. [EMAIL PROTECTED] 09/11/02 10:29 AM Please respond to ORACLE-L If outdoor life is your thing then consider this company in the Wisconsin Dells, Wisconsin area that needs an Oracle 11i DBA to join their staff. This area is well known for its' boating, fishing, camping, etc. Relocation Assistance is provided. PLEASE DO NOT send your resume for this position UNLESS you have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *Requirements: -Degree preferred. -Solid Oracle DBA experience that MUST include at least 1 yr with 11i. -Must be a U.S. citizen or perm. resident Base Salary is open and depends on experience. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: One/Wisconsin Dells/11i DBA/Judy I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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')
RE: Another Character Set Problem
The utility is called csscan for character set scan. It runs at the unix prompt with additional parameters (some optional and some not) much as export or import would. Before you use it the first time, you need to run csminst.sql from $ORACLE_HOME/rdbms/admin to set up the work tables, etc. Cherie Machler Oracle DBA Gelco Information Network Ron/Sarah YountTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ronwy@SWBELL. cc: NET Subject: RE: Another Character Set Problem Sent by: [EMAIL PROTECTED] om 09/12/02 09:23 PM Please respond to ORACLE-L Scott, 1) I have to agree with Oracle's statement that you need to have a UTF8 database to handle Chinese and Japanese characters. These characters require multi-byte encoding to be stored and therefore a UTF8 database is the way to go. 2) I am not sure where the Chinese and Japanese characters are stored, but it is quite likely that you will fail to store them correctly in a P1 database. 3) You can run a utility... Name escapes me that will check your contents to see if changing character sets will result in a loss of current data (this is an oracle supplied utility). 4) Alternately, you could export the contents of the database and import them into a new WE...P1 database. Make sure that you review metalink docs on setting your NLS_LANG correctly for such imports and exports. HTH, -Ron- -Original Message- Canaan Sent: Thursday, September 12, 2002 8:18 AM To: Multiple recipients of list ORACLE-L We are currently having a character set problem. We have a third-party product that is used for on-line courses (Prometheus from Blackboard, Inc.). The character set that the instance was created with was US7ASCII. The vendor says it should be WE8ISO8859P1, but we need to support Chinese and Japanese characters. I contacted Oracle support, and was told that the specified character set would not support those characters, but that I should use UTF8. I altered the instance to use UTF8 and ran into a CLOB problem. We installed patchset 4 (so we are now 8.1.7.4.0 on Sun Solaris 2.8) and that problem went away. However, none of the CLOB data is rendered properly in the application and I don't have a tool that allows me to see it directly out of the database. I am tempted to try to change the character set to WE8ISO8859P1, as the vendor requested, with the hope that any deficiencies in that character set have been handled by their product. At this point, can I change the instance from UTF8 to WE8ISO8859P1? I do have a tar open on this issue and will be asking the same question there, but I'm hoping I'll get a response here faster (ok, I'm expecting that I will). Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You