RE: Happy Thanksgiving
DWI = DDL while inebriated? On Wed, 2003-11-26 at 10:49, Goulet, Dick wrote: And may you all be back here on Monday, in one piece, safe sound. No DWI's now, you hear! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Guys, Happy Thanksgiving to everyone. May your bellies be full but your waistline not expand, may you enjoy the time with your family and friends and avoid any of the other drama Thanks so much to everyone for their help and camaraderie. Just enjoy yaself! -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- A loving person lives in a loving world. A hostile person lives in a hostile world. Everyone you meet is your mirror. -- Ken Keyes Jr. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: unix question
How about something like dir=foo if [ `ls -1 $dir` -lt 4 ]; then find $dir -mtime +4 | xargs rm fi On Wed, 2003-11-19 at 15:20, [EMAIL PROTECTED] wrote: I want to store some files. I make a new copy every night. I want to archive it back 4 days. So after 4 days, I want to delete the old copy. How do I do this? However, if i miss a nightly batch and have less than 4 copies, I do not want to delete any? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- Please give me some good advice in your next letter. I promise not to follow it. -- Edna St. Vincent Millay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: ORA-911 during DBD::Oracle prepare
Hey, don't forget about me! This was a very timely thread. Named bind variables in perl solves a problem I'm working on today. :) Time to go home and have a beer. Thanks all! On Fri, 2003-11-07 at 14:09, Mladen Gogala wrote: Count me in, too. On 11/07/2003 12:34:26 PM, STEVE OLLIG wrote: That's alright Rich - you aren't the only idiot here ;) -Original Message- Sent: Friday, November 07, 2003 8:55 AM To: Multiple recipients of list ORACLE-L The thing about it is that I distinctly remember complaining in a comment in one of my Perl/DBI progs about having to use positional binds. And now I can't find it. Oh well. Live and learn and hope no one else comes across that bit of code to see what an idiot I am. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA Disclaimer: I'm an idiot. The difference between me and other idiots is that I know I'm an idiot. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 4:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-911 during DBD::Oracle prepare It works! It works, it works! On 11/06/2003 05:14:24 PM, Alan Gano wrote: DBI is able to use named binds e.g., my $cursor=$$self{conn}-prepare(q{ select column_name from dba_cons_columns where (owner,constraint_name) = ( select owner, constraint_name from dba_constraints where owner = :table_owner AND table_name = :table_name AND constraint_type = 'P' ) }); $cursor-bind_param(:table_owner,uc($owner)); $cursor-bind_param(:table_name,uc($table)); $cursor-execute(); $$self{pk_columns}=[]; my @columns; while(my $row=$cursor-fetchrow_arrayref()) { push @columns,$$row[0]; } [EMAIL PROTECTED]; Alan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: STEVE OLLIG 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). Mladen Gogala Oracle DBA Note: 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. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor 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 the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- Never get angry. Never make a threat. Reason with people. -- Mario Puzo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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
Re: Re[3]: How do you generate primary keys?
The only reliable solution in this case is to serialize which of course means forget about scaling. On Thu, 2003-11-06 at 09:14, Jonathan Gennick wrote: Wednesday, November 5, 2003, 1:14:26 PM, Jamadagni, Rajendra ([EMAIL PROTECTED]) wrote: JR hypothetically, When you have a requirement that no gaps allowed in a sequence no matter what, JR would you still use sequences? Ah! This is a good question. If no gaps are acceptable, period, end of story, then what is a viable solution? I do not think sequences are it. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- If you would stand well with a great mind, leave him with a favorable impression of yourself; if with a little mind, leave him with a favorable impression of himself. -- Samuel Taylor Coleridge -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: ORA-911 during DBD::Oracle prepare
Don't you want SELECT machine, program, SYS_CONTEXT(?, ?), SYS_CONTEXT(?, ?)... DBI uses positional binds as opposed to named binds. On Thu, 2003-11-06 at 16:29, Jesse, Rich wrote: Hey all, I'm trying to get a simple query running in Perl 5.6.1, DBI 1.30, DBD::Oracle 1.14, Oracle 8.1.7 on HPUX 11.0 talking to a 9.2.0.4 RAC DB on Linux (whew!). Here's the pertinent part of the code: #!/usr/bin/perl -w use strict; use DBI; use DBD::Oracle qw(:ora_types); my ($dbh, $sth); $dbh = DBI-connect(dbi:Oracle:mysid,myuser,mypass); $sth = $dbh-prepare(q{ SELECT machine, program, SYS_CONTEXT(:userenv, :ipaddress), SYS_CONTEXT(:userenv, :osuser) FROM v$session VS; }); At this point, I get an ORA-911: invalid character on the prepare. I thought perhaps the $ was hosing me in v$session, so I tried escaping it to v\$session (along with the underscores and parens) and using qq instead of q, but to no avail. I knew I shouldn't have unsub'd from the DBI mailing list... Anyone? TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- If you would stand well with a great mind, leave him with a favorable impression of yourself; if with a little mind, leave him with a favorable impression of himself. -- Samuel Taylor Coleridge -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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).
2G trace files
I'm tracing a session with 10046 event level 8. Here's the method I use: sys.dbms_system.set_sql_trace_in_session( p_sid, p_serial#, TRUE ); sys.dbms_system.set_bool_param_in_session(p_sid, p_serial#, 'timed_statistics', true); /* Max dump file size is 2G */ sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 2147483647); sys.dbms_system.set_ev(p_sid, p_serial#, 10046, p_level, ''); If I set max_dump_file_size greater than 2G I get an error. But with trace level 8, I'm easily overrunning this limit. How do you guys get around this? BTW - Just got Optimizing Oracle Performance last night and if I didn't have to work so much I would have read it through by now. Maybe I'll take tomorrow off. Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- When the character of a man is not clear to you, look at his friends. -- Japanese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: 2G trace files
If I set max_dump_file_size greater than 2G I get an error. Perhaps I should be more specific: sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 'unlimited'); gives: ORA-06502: PL/SQL: numeric or value error: character to number conversion error sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 2147483647 + 1); gives: ORA-01426: numeric overflow On Wed, 2003-10-29 at 14:24, Tim Fleury wrote: Set the dump file size to unlimited. -Original Message- Sent: Wednesday, October 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L I'm tracing a session with 10046 event level 8. Here's the method I use: sys.dbms_system.set_sql_trace_in_session( p_sid, p_serial#, TRUE ); sys.dbms_system.set_bool_param_in_session(p_sid, p_serial#, 'timed_statistics', true); /* Max dump file size is 2G */ sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 2147483647); sys.dbms_system.set_ev(p_sid, p_serial#, 10046, p_level, ''); If I set max_dump_file_size greater than 2G I get an error. But with trace level 8, I'm easily overrunning this limit. How do you guys get around this? BTW - Just got Optimizing Oracle Performance last night and if I didn't have to work so much I would have read it through by now. Maybe I'll take tomorrow off. Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- When the character of a man is not clear to you, look at his friends. -- Japanese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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 Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- [Long hair] is considered bohemian, which may be why I grew it, but I keep it long because I love the way it feels, part cloak, part fan, part mane, part security blanket. -- Marge Piercy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: 2G trace files
Yes. I'm tracing a single session. What made you think I wasn't? What does statspack have to do with this? 2G is not such a large amount... On Wed, 2003-10-29 at 14:44, Paul Drake wrote: Richard, Are you sure that you are targeting your diagnostic efforts appropriately? If all users are using dedicated servers, then each trace file should only have the info for one session. If your interval for a statspack report is an entire week, its going to be pretty tough to find the particular query that you're looking for. Are you tracing all sessions, all the time? The feds don't put up routine checkpoints on federal interstates just to check for expired registration. It would bottleneck the entire system and generate too much info to be processed effectively. From the Heisenburg angle, I would think that generating such a large amount of trace would clearly be impacting the server's I/O subsystem in a big way. Pd Quintin, Richard [EMAIL PROTECTED] wrote: I'm tracing a session with 10046 event level 8. Here's the method I use: sys.dbms_system.set_sql_trace_in_session( p_sid, p_serial#, TRUE ); sys.dbms_system.set_bool_param_in_session(p_sid, p_serial#, 'timed_statistics', true); /* Max dump file size is 2G */ sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 2147483647); sys.dbms_system.set_ev(p_sid, p_serial#, 10046, p_level, ''); If I set max_dump_file_size greater than 2G I get an error. But with trace level 8, I'm easily overrunning this limit. How do you guys get around this? BTW - Just got Optimizing Oracle Performance last night and if I didn't have to work so much I would have read it through by now. Maybe I'll take tomorrow off. Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- Whe! n the character of a man is not clear to you, look at his friends. -- Japanese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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). __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- If you haven't forgiven yourself something, how can you forgive others? -- Dolores Huerta -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: 2G trace files - solved...sort of
Thanks to everyone who responded. It turns out initialization parameter max_dump_file_size was set to *20M* and the trace files were getting cut off at that point. I didn't look at the ls closely enough and thought it was getting cut off at 2G. Apparently the init parameter overrides the session parameter On Wed, 2003-10-29 at 15:09, Quintin, Richard wrote: If I set max_dump_file_size greater than 2G I get an error. Perhaps I should be more specific: sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 'unlimited'); gives: ORA-06502: PL/SQL: numeric or value error: character to number conversion error sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 2147483647 + 1); gives: ORA-01426: numeric overflow On Wed, 2003-10-29 at 14:24, Tim Fleury wrote: Set the dump file size to unlimited. -Original Message- Sent: Wednesday, October 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L I'm tracing a session with 10046 event level 8. Here's the method I use: sys.dbms_system.set_sql_trace_in_session( p_sid, p_serial#, TRUE ); sys.dbms_system.set_bool_param_in_session(p_sid, p_serial#, 'timed_statistics', true); /* Max dump file size is 2G */ sys.dbms_system.set_int_param_in_session(p_sid, p_serial#, 'max_dump_file_size', 2147483647); sys.dbms_system.set_ev(p_sid, p_serial#, 10046, p_level, ''); If I set max_dump_file_size greater than 2G I get an error. But with trace level 8, I'm easily overrunning this limit. How do you guys get around this? BTW - Just got Optimizing Oracle Performance last night and if I didn't have to work so much I would have read it through by now. Maybe I'll take tomorrow off. Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- When the character of a man is not clear to you, look at his friends. -- Japanese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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 Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- [Long hair] is considered bohemian, which may be why I grew it, but I keep it long because I love the way it feels, part cloak, part fan, part mane, part security blanket. -- Marge Piercy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- If you would persuade, you must appeal to interest rather than intellect. -- Benjamin Franklin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: stupid dbms_job question
An interval of trunc(sysdate)+(trunc(to_char(sysdate,'s')/900)+1)*5/24/60 ought to give you every 5 minutes. Courtesy of Tom... On Thu, 2003-10-23 at 10:29, Gene Sais wrote: It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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). Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- Magnificent promises are always to be suspected. -- Theodore Parker -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: OT: How to call unix shell scripts from 'C'?
fork() and exec() are what you're looking for. I haven't done it in a while, but you should be able to find plenty of info online. On Wed, 2003-10-22 at 11:44, [EMAIL PROTECTED] wrote: The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- If my hands are fully occupied in holding on to something, I can neither give nor receive. -- Dorothee Solle -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: Change Character sets
: Original database created with US7ASCII and then changed to WE8ISO8859P1. Client workstation was set up as WE8ISO8859P1 from WAY back, prior to database character set change. Export was taken using NLS_LANG=American_america.US7ASCII. Import doen using NLS_LANG=American_america.WE8ISO8859P1 Lots of data started showing up with '?''s in the middle of words, etc... Solution: Take a new export of the affected tables from the original database using the right NLS_LANG setting use that to replace them in the new database. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, October 22, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Actually, WE8ISO8859P1 *is* a superset of US7ASCII, which is how we were able to do the same ALTER DATABASE (in 8.1.7.2 at the time) you mentioned. Check out http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=11 9164.1p_database_id=NOT (pasting the link together) for a list of valid supersets. Your combo is sixth in the list. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: Change Character sets I have a database that was populated using an export from an US7ASCII Oracle database. The current database is WE8ISO8859P1 which is not a superset of US7ASCII. So I can't change the characterset using the ALTER DATABASE as the manual suggests. The alternative is to export the database, drop the current instance, create a new instance with the correct characterset and import the old database. But I know that there is no data in the database that was not supported in the US7ASCII database. Is there a shortcut? The UPDATE sys.PROPS$ trick is a no-go. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Goulet, Dick 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: Thomas Day 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 Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- The only factor becoming scarce in a world of abundance is human attention. -- Kevin Kelly -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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: Question about sql
insert into table3(company_id,lev_id,vare_id) select company_id,lev_id,vare_id from table2 where vare_id = 56 AND exists (select 1 from table1 where table1.company_id = table2.company_id) On Thu, 2003-10-16 at 10:20, [EMAIL PROTECTED] wrote: Hallo, Anyone whom could gve me some good help on this. I have a table with one field, called Company_id Like this Company_id 16 45 50 In table 2 I have this field and values: Company_id Lev_idVare_id 16 45 56 34 10 20 67 10 20 45 15 30 50 12 12 I would like to from table 2 do a select and find the Company_ids from table1 and find out the responding lev_id and vare_id in table2and then insert them into a new table(table3) so it would look like this: Company_idLev_idVare_id 1645 56 Anyone whom could give me some help on this how to write the sql- query. I have tried with this sql query. What is wrong? insert into table3(company_id,lev_id,vare_id) select company_id,lev_id,vare_id from table2 where vare_id = 56 (where exists select company_id from table1) Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- Living in the moment brings you a sense of reverence for all of life's blessings. -- Oprah Winfrey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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).