RE: SCOTT/TIGER
The one I have heard is Scott being the main developer way back when.. and Tiger was the name of his pet cat.. -Original Message- Sent: 23 January 2002 16:45 To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Mark Leith 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: Connecting INGRES using database link
Golly, that looks an awful lot like VMS. I think what it's trying to tell you is that the node you specified is not reachable, or that the SID you've specified is not on the node listed. There's some kind of connection problem there. Try doing a select from the Ingres side over the connection. If it works, I don't know what to tell you. If it fails, drop and recreate the connection string. The important thing is that this error is NOT an Oracle error... it is a wrapper around what it's getting from the Ingres side... and it looks for all the world like it's not purely an Ingres error either. That E_ is a VMS level error (W would be warning, F would be fatal). Unfortunately, I've been largely off of VMS since 93, so I'm not going to be able to help a lot there either. Wish you would have asked this question about 10 years ago... ;) Bambi. -Original Message- Sent: Tuesday, January 22, 2002 9:05 PM To: Multiple recipients of list ORACLE-L thank you Bambi. I already tried to create database link using HSODBC, but failed. It returned this messages : == SQL select * from cond@hsodbc; select * from cond@hsodbc * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES driver][INGRES]E_LQ0001 Failed to connect to DBMS session. E_LC0001 GCA protocol service (GCA_REQUEST) failure. Internal service status E_GC0132 -- User provided a vnode as part of the database name (vnode::dbname), but connection information for that vnode i (SQL State: S1000; SQL Code: -38100) ORA-02063: preceding 6 lines from HSODBC == Is someone familiar with this kind of error... TIA, Holly -Original Message- Sent: Wednesday, January 23, 2002 4:20 AM To: Multiple recipients of list ORACLE-L Holly -- It has been a long time since I have done Oracle and Ingres at the same time (about 12 years (Oracle v6/Ingres v5)). Back then, while there was kinda-sorta ODBC to and from both Oracle and Ingres, they weren't able to access each other directly. Generally, data transfers were to and from flat files, and queries between objects in the two databases utilized a third party tool (Passport). HTH, Bambi. -Original Message- Sent: Monday, January 21, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Dear all, Can I create database link using generic connectivity (ODBC)? Was there someony already try this? I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on VAX/VMS. TIA, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho 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: Bellows, Bambi 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: Ahmadsyah Alghozi Nugroho 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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: SCOTT/TIGER
I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Conboy, Jim 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).
FW: Electrical background
Title: FW: Electrical background Sorry folks, that went to the wrong list. I apologize. We now return you to your regularly scheduled Oracle discussion. Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: Let the programmers by many and the managers few, Then all will be productive - The Tao of Programming -Original Message- From: Adams, Matthew (GEA, 088130) Sent: Wednesday, January 23, 2002 1:10 PM To: 'olist' Subject: Electrical background Anybody got a EE or electronics background? I've got a question about relays. Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: Let the programmers by many and the managers few, Then all will be productive - The Tao of Programming
RE: SCOTT/TIGER
I do. -Original Message- Sent: Wednesday, January 23, 2002 9:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Weaver, Walt 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: SCOTT/TIGER
Ed Scott was one of the founders of Oracle and that was a sign on he liked to use. -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Ben Poels 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: Backup/Recovery questions ...
Fred, one of the easier ways is this: 1. on ur prod take a control file backup to trace 2. copy the trace to server b and edit the path/drives 3. copy init file from prod to server b 4. set the env vars in server b and startup nomount 5. create the control file using edited trace on B 6. restore database {rman} 7. recover database {rman} 8. open resetlogs alternate method: all steps are similar except 1,2,5 instead u can restore controlfile (rman backup) and then manualkly rename the file before u mount and restore your database. let me know if this still does not answer your q Thx Deepak --- Fred Smith [EMAIL PROTECTED] wrote: List, I am attempting to verify the validity/integrity of a full cold backup I did off of my production server. I backed up the datafiles,logfiles, controlfiles. The production server (server A) is much larger with dozens of drives. I now wish to apply this backup to another server (server B). Server B does not have the same drive configurations as server A. Based on this I'm assuming that my controlfiles from Server A are useless. How can I bring this database up on server B now? There are over 100 datafiles. OS: SunOS 5.6 Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production Thank you, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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: Session_wait
Hi, Henry, Please, post it. I am terribly sorry for asking dumb questions, but hey! I've come a long way to be a part of this country, learned the language, become a DBA and proud of it! Time to learn! Thanks a bunch in advance! Sincerely, Sergey -Original Message- Sent: Wednesday, January 23, 2002 1:02 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait Couldn't hurt. Also why not do some deltas of your session statistics (before and after snapshots) Henry PS: After you have the trace file, I put together an awk statement to sum up the number and elapsed time of the wait states for each SQL statement. I can post that if you would like. -Original Message- Sent: Wednesday, January 23, 2002 11:21 AM To: Multiple recipients of list ORACLE-L Hi, Henry, Since I didn't expect that to happen, I had just SQL trace turned on for that particular session. Do you suggest entering event=10046 trace name errorstack level 12 into init.ora? Thanks, Regards, Sergey -Original Message- Sent: Wednesday, January 23, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait Sergey, At what level did you trace? Henry -Original Message- Sent: Wednesday, January 23, 2002 8:15 AM To: Multiple recipients of list ORACLE-L Thank you, guys, for your help, just got back to work. Unfortunately, it's too late to run the query, but later on we'll run the OLTP again, and then I'll do it and post the output. Currently I'm analyzing the trace file which is about 130M (did not tkprof it yet), and that size does NOT sound healthy to me. Best regards, Sergey Babich -Original Message- Sent: Tuesday, January 22, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait Sergey, please run this and post values. Just curious. select name, value from v$sesstat vs, v$statname sn where vs.statistic#=sn.statistic# and value is NOT NULL and value0 and sid=11; hth, - Ross p.s. shadow process - your client connection's 'footprint' in the os. if a local host connect, look for LOCAL=YES. If not, look for LOCAL=NO. Sort out all not in your instance name. -Original Message- Sent: Tuesday, January 22, 2002 4:57 PM To: Multiple recipients of list ORACLE-L Well, now it's finished, but the timing is terrible... I should've queried v$lock. RAID had a lot of activity while that was going on. File #10 is a data datafile. I am not sure what is meant by shadow process, sorry. I guess we'll repeat this tomorrow. Thank you, guys, I really appreciate your help. Best regards, Sergey -Original Message- Sent: Tuesday, January 22, 2002 4:36 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait well, then it's an entirely different kettle of fish. Jeremiah is on track. don't suppose you can query v$lock where sid=11 or block0 or lmode=6 while this is going on, can you? and...in the OSwhat is going on w/disk? and with the shadow process? and, lastly, what is file# 10? Probably a data datafile... -Original Message- Sent: Tuesday, January 22, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Thanks for your input, but P2 was not changing as u can c from the last one I caught: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- --- 11 40019 db file sequential readfile# 10 000A block# 221571 00036183 blocks 1 0001 -1 1594 WAITED SHORT TIME After that the SQL changed Regards, Sergey Babich -Original Message- Sent: Tuesday, January 22, 2002 3:32 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait it was reading blocks into SGA buffers. No big deal. As the wait time went up, so likely were the values of P2 changing. A longish read by sid 11. shrug -Original Message- Sent: Tuesday, January 22, 2002 3:19 PM To: Multiple recipients of list ORACLE-L Hi, listers, One of the sessions seems to be a problem: SELECT * FROM V$SESSION_WAIT WHERE SID=NUM / Output: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- --- 11 40019 db file sequential readfile# 10 000A block# 221571 00036183 blocks 1 0001 -1 335 WAITED SHORT TIME Then wait_time was 689, then 749 and
Re: Electrical background
-- Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] on 01/23/02 10:15:31 -0800 Anybody got a EE or electronics background? I've got a question about relays. See: The Art Of Electronics, 2nd ed Horowitz Hill Cambridge U. Press. Excellent descriptions of using and configuring relays -- and just about anything else that moves electrons. Heavy avoidence of unnecessary math is one of the book's best features. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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).
RE: SCOTT/TIGER
LMAO! -Original Message- Kirti Sent: 23 January 2002 18:21 To: Multiple recipients of list ORACLE-L Prepareing for the OCP, eh? -Kirti -Original Message- Sent: Wednesday, January 23, 2002 10:46 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Deshpande, Kirti 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: Mark Leith 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: Backup/Recovery questions ...
First load all the datafiles and logfiles to server B in the locations you want them. Load the controlfiles as well, they aren't useless. Now. edit the init.ora file on server B to point to where the control files are. create a sql script file that contains (for every datafile and logfile) alter database rename file 'original file name' to 'new file name'; the file names should include the full path specification. now go into svrmgrl: connect internal startup mount run the script alter database open; exit and you have moved the database and files to the new server --- Fred Smith [EMAIL PROTECTED] wrote: List, I am attempting to verify the validity/integrity of a full cold backup I did off of my production server. I backed up the datafiles,logfiles, controlfiles. The production server (server A) is much larger with dozens of drives. I now wish to apply this backup to another server (server B). Server B does not have the same drive configurations as server A. Based on this I'm assuming that my controlfiles from Server A are useless. How can I bring this database up on server B now? There are over 100 datafiles. OS: SunOS 5.6 Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production Thank you, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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).
RE: SCOTT/TIGER - the rumor mill
I heard from unnamed sources that it was a developer named Tiger and Scott was his monkey. Unknown -Original Message- Sent: Wednesday, January 23, 2002 12:26 PM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Conboy, Jim 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).
RE: SCOTT/TIGER
Ok...it's true. Take the Oracle Technical seminars and you too may get to meet Scott, Live and In Person. Unfortunately, Tiger is waiting for Scott at the Rainbow Bridge, but Scott is still there (at least he was last year...you know how Oracle's been lately). -Original Message- Sent: Wednesday, January 23, 2002 10:26 AM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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:FW: Electrical background
SO, what did you want? Dick Goulet Ancient Electronics Tech tinkerer, Also certified relay NUT Reply Separator Author: Adams; Matthew (GEA; 088130) [EMAIL PROTECTED] Date: 1/23/2002 10:30 AM Sorry folks, that went to the wrong list. I apologize. We now return you to your regularly scheduled Oracle discussion. Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: Let the programmers by many and the managers few, Then all will be productive - The Tao of Programming -Original Message- From: Adams, Matthew (GEA, 088130) Sent: Wednesday, January 23, 2002 1:10 PM To: 'olist' Subject: Electrical background Anybody got a EE or electronics background? I've got a question about relays. Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: Let the programmers by many and the managers few, Then all will be productive - The Tao of Programming !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.19 TITLEFW: Electrical background/TITLE /HEAD BODY PFONT SIZE=2Sorry folks, that went to the wrong list./FONT BRFONT SIZE=2I apologize.nbsp; We now return you to your /FONT BRFONT SIZE=2regularly scheduled Oracle discussion./FONT /P PFONT SIZE=2/FONT BRFONT SIZE=2Matt Adams - GE Appliances - [EMAIL PROTECTED]/FONT BRFONT SIZE=2Thus spake the master programmer:/FONT BRFONT SIZE=2nbsp;quot;Let the programmers by many and the managers few,/FONT BRFONT SIZE=2Then all will be productivequot;nbsp; - The Tao of Programming/FONT /P PFONT SIZE=2gt; -Original Message-/FONT BRFONT SIZE=2gt; From: Adams, Matthew (GEA, 088130) /FONT BRFONT SIZE=2gt; Sent: Wednesday, January 23, 2002 1:10 PM/FONT BRFONT SIZE=2gt; To: 'olist'/FONT BRFONT SIZE=2gt; Subject: Electrical background/FONT BRFONT SIZE=2gt; /FONT BRFONT SIZE=2gt; /FONT BRFONT SIZE=2gt; Anybody got a EE or electronics background?/FONT BRFONT SIZE=2gt; I've got a question about relays./FONT BRFONT SIZE=2gt; /FONT BRFONT SIZE=2gt; /FONT BRFONT SIZE=2gt; Matt Adams - GE Appliances - [EMAIL PROTECTED]/FONT BRFONT SIZE=2gt; Thus spake the master programmer:/FONT BRFONT SIZE=2gt;nbsp; quot;Let the programmers by many and the managers few,/FONT BRFONT SIZE=2gt; Then all will be productivequot;nbsp; - The Tao of Programming/FONT BRFONT SIZE=2gt; /FONT /P /BODY /HTML -- 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).
Re: Backup/Recovery questions ...
Would I be better off doing that or doing a backup controlfile to trace from server A, moving the datfiles logfiles to server B, and then editing the newly created trace file into a script that creates a new controlfile with the new datafile/logfile locations? From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Backup/Recovery questions ... Date: Wed, 23 Jan 2002 11:00:36 -0800 First load all the datafiles and logfiles to server B in the locations you want them. Load the controlfiles as well, they aren't useless. Now. edit the init.ora file on server B to point to where the control files are. create a sql script file that contains (for every datafile and logfile) alter database rename file 'original file name' to 'new file name'; the file names should include the full path specification. now go into svrmgrl: connect internal startup mount run the script alter database open; exit and you have moved the database and files to the new server --- Fred Smith [EMAIL PROTECTED] wrote: List, I am attempting to verify the validity/integrity of a full cold backup I did off of my production server. I backed up the datafiles,logfiles, controlfiles. The production server (server A) is much larger with dozens of drives. I now wish to apply this backup to another server (server B). Server B does not have the same drive configurations as server A. Based on this I'm assuming that my controlfiles from Server A are useless. How can I bring this database up on server B now? There are over 100 datafiles. OS: SunOS 5.6 Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production Thank you, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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).
RE: SCOTT/TIGER - the rumor mill
Poor thing got spanked a lot, eh? Scott Shafer San Antonio, TX 210-581-6217 Common sense will not accomplish great things. Simply become insane and desperate. -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 23, 2002 1:11 PM To: Multiple recipients of list ORACLE-L Subject: RE: SCOTT/TIGER - the rumor mill I heard from unnamed sources that it was a developer named Tiger and Scott was his monkey. Unknown -Original Message- Sent: Wednesday, January 23, 2002 12:26 PM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Conboy, Jim 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). -- 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).
RE: Yet Another Off Topic Discussion
Thanks Larry. I had forgotten about the 75 message per day problem. That was really a pain. This list finally came about when the 'other' list was down for 10 days. The list owner would not answer his emails or his phone. ( I had to track down his phone #, for all the good it did ) I think this was in April or May of 1998, though I'm not sure. Jared OCP and Part Time Perl Evangelist :) Larry Elkins [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/02 04:15 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Yet Another Off Topic Discussion Since even Jared has replied to this thread and taken us a little more off topic, I will risk alienating a few people by throwing in a me too response ;-) I look towards this list and others for exchanging ideas and technical information. And as some others have already said so well, the one thing that makes this list stand out to me (besides the strong technical content) is the sense of personality and community. I think that goes a long way in building a group of people who want to collaborate and bounce things off others. OT posts *have* gotten a bit out of hand at times but invariably things get back on topic. And with Joe starting the oracle-l-ot list, you can get both. And though I've only personally met or know a handful of people on this list, it seems like I kind of know a lot of the people I've never met. And for those newer to the list, you have probably figured out by now that Jared is the list owner. You might also be interested in knowing that a few years back, there was a 75 message limit per day, and when you hit that limit your post would come through 4 months later. It was Jared who started the new Oracle-L, and who has taken us through various hosts as things changed to keep this list alive. Anyway, a big thanks to Jared (and the silent others who have also given time). I'm willing, personally, to deal with a few OT posts (and many of them I enjoy), especially when you consider the overall quality of posts and the general desire of people on this list to help one another. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: Yet Another Off Topic Discussion Thank you. :) Jared -- 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) 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).
RE: ROLLBACK SEGMENT?
I think one should not be running export of those tables when heavy DML is being done against those. - Kirti -Original Message- Sent: Wednesday, January 23, 2002 3:11 AM To: Multiple recipients of list ORACLE-L If you want to avoid snapshot too old set the DB (or tablespaces) to read-only. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wed, January 23, 2002 2:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: ROLLBACK SEGMENT? H ... COULD help in avoiding snapshot too old errors. Raj Jeremiah Wilton [EMAIL PROTECTED]@fatcity.com on 01/22/2002 06:35:21 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: On Tue, 22 Jan 2002, Jason Rowski wrote: ... you can use the following trick to assign export a particular rollback segment - 1) Create a rollback segment tablespace with one large segment and bring it online before export. 2) Offline all existing rollback segments. 3) Export the database 4) Offline the large tablespace created earlier. 5) Bring back the orginals rollback segments online. So what does it accomplish to assign export [to] a particular rollback segment? Export doesn't generate any rollback, right, so what is it supposed to accomplish by doing this incantation? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton --- Seema Singh [EMAIL PROTECTED] wrote: Can I use one rollback segment at time of export?Is yes,then SET TRANSACTION USE ROLLBACK SEGMENT rollbacksegmentname; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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: Deshpande, Kirti 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: Column Rename
Both an Oracle DBA instructor and myself have encountered some rather nasty results from changing column names in the data dictionary. I was able to recover from my predicament. :) He wasn't. :( Jared Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/02 07:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Column Rename Simple answer is no. There is no single command to do it, officially. However, there other tricks to achieve the goal. One involves messing with data dictionary objects. Search Steve Adam's site http://www.ixora.com.au/. I believe he had a script to demo how it can be done. But with a WARNING that this operation is not supported by Oracle. Other suppored solutions involve re-creating the table, one way or the other. One way is to exchange the table with a partition and back to table. The note detailing this with an example is on Metalink. Or you can build a view for this table with correct column name. Even Oracle 9.0.1 does not have an easy way to it. One has to use the new procedure of 'table redefinition' to achieve this. HTH, - Kirti -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 23, 2002 5:25 AM To: Multiple recipients of list ORACLE-L Hello Is it possible to rename a column in Oracle 8 ( Release 8.0.3.0.0 )? Regards Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- n 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: Deshpande, Kirti 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).
RE: dropped datafile problem
ORACLE-L Digest -- Volume 2002, Number 023 -- From: [EMAIL PROTECTED] Date: Tue, 22 Jan 2002 09:09:23 -0500 Subject: Re:RE: dropped datafile problem While the damage here has already been done, it should be a point of caution for us all. I make a point of dropping the tablespace in Oracle first followed by judicious use of the 'fuser' command in HP-UX to see that all processes have released the file. Now you know it's deletable. BTW: anyone know of an equivalent to fuser for NT/2000?? (coming in late since I am in digest mode, sorry if this was already answered) Dick, Since (for better or worse) Oracle is threaded on NT, other than the main Oracle process, there aren't any processes to be concerned about are there? regards, ep -- 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).
Re: ORACLE-L Digest -- Volume 2002, Number 023
?? ORACLE-L Digest -- Volume 2002, Number 023 -- From: [EMAIL PROTECTED] Date: Tue, 22 Jan 2002 11:00:47 -0800 Subject: RE: Yet Another Off Topic Discussion VGhhbmsgeW91LiAgOikNCg0KSmFyZWQNCg0KDQoNCg0KDQrXkNeT16gg15nXl9eZ15DXnCA8YW Rh cnlAbWVoaXNoLmNvLmlsPg0KU2VudCBieTogcm9vdEBmYXRjaXR5LmNvbQ0KMDEvMjIvMDIgMD U6 MzAgQU0NClBsZWFzZSByZXNwb25kIHRvIE9SQUNMRS1MDQoNCiANCiAgICAgICAgVG86ICAgIC BN ... snipped several hundred lines of encoded stuff 5j bHVkZSBhIGxpbmUgY29udGFpbmluZzogVU5TVUIgT1JBQ0xFLUwNCihvciB0aGUgbmFtZSBvZi Bt YWlsaW5nIGxpc3QgeW91IHdhbnQgdG8gYmUgcmVtb3ZlZCBmcm9tKS4gIFlvdSBtYXkNCmFsc2 8g c2VuZCB0aGUgSEVMUCBjb21tYW5kIGZvciBvdGhlciBpbmZvcm1hdGlvbiAobGlrZSBzdWJzY3 Jp YmluZykuDQoNCg0KDQo= -- -- 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).
RENAME DATAFILE
Hi Rename data file from one location to another location is riskly process? If some thing wrong what will happened?Can I do it database on condition? Can I do it when db is running?If yes then it is risky? Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- 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).
Re: Trace/Event Info
If you have access to Oracle on a unix system, take a look at $ORACLE_HOME/rdbms/admin/oraus.msg. Events 1 - 10999 are of interest here. You may also note that it says they are for debugging Oracle. As such you will likely never find documentation for some of them. A few of them are documented in the file. Jared Walter K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/02 06:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Trace/Event Info Howdy! Is a document available somewhere that explains the different trace levels and also the commonly used events for tracing? For instance, I know to use event 10046 with level 4 to get the bind variable values in a trace, but why this particular combination of event and trace level? What are the different levels and how are they used? How are process state and system state dumps performed? I'm also interested in some info that explains how to interpret the various trace files that are produced, other than just looking for SQL in them. Etc... Thanks again! -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter 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). -- 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).
RE: Backup/Recovery questions ...
Fred, Either method works fine. You have the same amount of data editing in both methods (Either issue alter database rename commands, or edit the create controlfile file. The other consideration is that in Rachel's method, you are simply opening the database afterword. With the re-creation of the control file, you must (I think) alter database open resetlogs. A minor difference. Whichever way you decide to do it would be fine. The end result is a ton of typing. Something to consider is, on your production box, create disk directories based on a Unix soft link, and place your database files into these directories. This would facilitate your moving of the database in the future, as your soft links are at the operating system level, and can be changed more easily than issuing the alter database commands. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 23, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Would I be better off doing that or doing a backup controlfile to trace from server A, moving the datfiles logfiles to server B, and then editing the newly created trace file into a script that creates a new controlfile with the new datafile/logfile locations? From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Backup/Recovery questions ... Date: Wed, 23 Jan 2002 11:00:36 -0800 First load all the datafiles and logfiles to server B in the locations you want them. Load the controlfiles as well, they aren't useless. Now. edit the init.ora file on server B to point to where the control files are. create a sql script file that contains (for every datafile and logfile) alter database rename file 'original file name' to 'new file name'; the file names should include the full path specification. now go into svrmgrl: connect internal startup mount run the script alter database open; exit and you have moved the database and files to the new server --- Fred Smith [EMAIL PROTECTED] wrote: List, I am attempting to verify the validity/integrity of a full cold backup I did off of my production server. I backed up the datafiles,logfiles, controlfiles. The production server (server A) is much larger with dozens of drives. I now wish to apply this backup to another server (server B). Server B does not have the same drive configurations as server A. Based on this I'm assuming that my controlfiles from Server A are useless. How can I bring this database up on server B now? There are over 100 datafiles. OS: SunOS 5.6 Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production Thank you, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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). _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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
Re: How to calculate Last and First Day of Month?
I would have thought that the first day of the month is ALWAYS the 1st, as in 1 (ONE)! Please explain why it needs to be calculated or could be a value other than ONE. [EMAIL PROTECTED] 01/23/02 10:35AM Hey guys, I know this is propablby easy, but I'm a bit overwhelmed here this week. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards -- 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).
Re:RENAME DATAFILE
Renaming or moving a datafile is a two step proposition. Whether or not you do it with the database running depends on the archive log mode of the database. If at all possible the OS portion should be done with the database shutdown. If your in noarchive log mode then you have no choice. If your in archive log mode then you can take the tablespace and datafile offline, move/rename the file, alter database rename file old to new, recover the tablespace, and bring it back online. If at all possible, take a cold backup BEFORE and AFTER. In all cases use the 'alter database backup controlfile to trace' command, just in case you end up rebuilding your control file(s). Dick Goulet Reply Separator Author: Seema Singh [EMAIL PROTECTED] Date: 1/23/2002 12:43 PM Hi Rename data file from one location to another location is riskly process? If some thing wrong what will happened?Can I do it database on condition? Can I do it when db is running?If yes then it is risky? Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- 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: 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: RENAME DATAFILE
Seema, It is not a risky process. The proper way to do it is: Alter tablespace {name} offline; ! host copy filename to newlocation; Alter database rename file 'oldname' to 'newname'; alter tablespace {name} online; * backup your database! * if all goes well, remove the old file. You obviously need to be able to take the tablespace offline to do this, so no queries or transactions may be running while you do this. You also need to perform a backup (at least alter database backup controlfile to trace). Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 23, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Hi Rename data file from one location to another location is riskly process? If some thing wrong what will happened?Can I do it database on condition? Can I do it when db is running?If yes then it is risky? Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- 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: 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).
Re: How to calculate Last and First Day of Month?
Charlie Mengler wrote: I would have thought that the first day of the month is ALWAYS the 1st, as in 1 (ONE)! Please explain why it needs to be calculated or could be a value other than ONE. [EMAIL PROTECTED] 01/23/02 10:35AM Hey guys, I know this is propablby easy, but I'm a bit overwhelmed here this week. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards Another case of 'On what day does Xmas fall this year? - on December 25th'. I think that using the TRUNC() function with the suitable parameter must help you truncate SYSDATE to the first day of the month - perhaps TRUNC(SYSDATE, 'MM') or similar (too tired to RTFM). Then TO_CHAR with the suitable format should return whatever you want. For the last day, I presume that identifying the first day of the NEXT month and substracting 1 must simplify the 'is this 30/31/28/29' question. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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 calculate Last and First Day of Month?
It is the 1st. I've already got quick help on that... thanks --- Charlie Mengler [EMAIL PROTECTED] wrote: I would have thought that the first day of the month is ALWAYS the 1st, as in 1 (ONE)! Please explain why it needs to be calculated or could be a value other than ONE. [EMAIL PROTECTED] 01/23/02 10:35AM Hey guys, I know this is propablby easy, but I'm a bit overwhelmed here this week. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards -- 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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).
RE: How to calculate Last and First Day of Month?
select last_day(add_months(sysdate,-1)) from dual; -Original Message- Sent: Wednesday, January 23, 2002 2:38 PM To: Multiple recipients of list ORACLE-L It is the 1st. I've already got quick help on that... thanks --- Charlie Mengler [EMAIL PROTECTED] wrote: I would have thought that the first day of the month is ALWAYS the 1st, as in 1 (ONE)! Please explain why it needs to be calculated or could be a value other than ONE. [EMAIL PROTECTED] 01/23/02 10:35AM Hey guys, I know this is propablby easy, but I'm a bit overwhelmed here this week. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards -- 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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: Weaver, Walt 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 calculate Last and First Day of Month?
First day calculations; select last_day(add_months(sysdate,-1))+1 form dual; for current month 1st day. select last_day(add_months(sysdate,-1)) from dual ; for end of previous month. ROR [EMAIL PROTECTED] 01/23/02 10:35AM Hey guys, I know this is propablby easy, but I'm a bit overwhelmed here this week. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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: 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).
Re: How to calculate Last and First Day of Month?
Well, yes the first day of the month is always 1. Representing it as the first day of the current month requires you to use the SYSDATE function. Returning the first day of the month can be done in several ways, some more reasonable than others. there's the new to SQL basic programmer DBA wannabe method: select substr(to_char(sysdate,'MM/DD/'), 1,2) || '/01/' || substr(to_char(sysdate,'MM/DD/'), 7) from dual; There's the slightly better: select to_date(to_char(sysdate,'MM') || '01','MMDD') from dual; The obtuse date math method ( my favorite ): select last_day(add_months(sysdate,-1))+1 from dual; ( there are several variations on this method ) A little RTFM will reveal a much cleaner method: select trunc(sysdate,'mm') from dual; So, the answer is always 1, but there is more than one way to get there. Jared SA, OCP, and Part Time Perl Evangelist Charlie Mengler [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/02 12:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: How to calculate Last and First Day of Month? I would have thought that the first day of the month is ALWAYS the 1st, as in 1 (ONE)! Please explain why it needs to be calculated or could be a value other than ONE. [EMAIL PROTECTED] 01/23/02 10:35AM Hey guys, I know this is propablby easy, but I'm a bit overwhelmed here this week. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards -- 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: 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: Backup/Recovery questions ...
With the re-creation of the control file, you must (I think) alter database open resetlogs. A minor difference. But one worth noting. If this method is chosen and the database must be opened with resetlogs, you must take a cold backup before allowing the database to be used. As to the reasons why, they can be found in the archives at www.fatcity.com. Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/02 12:37 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Backup/Recovery questions ... Fred, Either method works fine. You have the same amount of data editing in both methods (Either issue alter database rename commands, or edit the create controlfile file. The other consideration is that in Rachel's method, you are simply opening the database afterword. With the re-creation of the control file, you must (I think) alter database open resetlogs. A minor difference. Whichever way you decide to do it would be fine. The end result is a ton of typing. Something to consider is, on your production box, create disk directories based on a Unix soft link, and place your database files into these directories. This would facilitate your moving of the database in the future, as your soft links are at the operating system level, and can be changed more easily than issuing the alter database commands. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 23, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Would I be better off doing that or doing a backup controlfile to trace from server A, moving the datfiles logfiles to server B, and then editing the newly created trace file into a script that creates a new controlfile with the new datafile/logfile locations? From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Backup/Recovery questions ... Date: Wed, 23 Jan 2002 11:00:36 -0800 First load all the datafiles and logfiles to server B in the locations you want them. Load the controlfiles as well, they aren't useless. Now. edit the init.ora file on server B to point to where the control files are. create a sql script file that contains (for every datafile and logfile) alter database rename file 'original file name' to 'new file name'; the file names should include the full path specification. now go into svrmgrl: connect internal startup mount run the script alter database open; exit and you have moved the database and files to the new server --- Fred Smith [EMAIL PROTECTED] wrote: List, I am attempting to verify the validity/integrity of a full cold backup I did off of my production server. I backed up the datafiles,logfiles, controlfiles. The production server (server A) is much larger with dozens of drives. I now wish to apply this backup to another server (server B). Server B does not have the same drive configurations as server A. Based on this I'm assuming that my controlfiles from Server A are useless. How can I bring this database up on server B now? There are over 100 datafiles. OS: SunOS 5.6 Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production Thank you, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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
RE: How to calculate Last and First Day of Month?
the first is always the first and the last may be calculated by using last_day function. -Original Message- Sent: Wednesday, January 23, 2002 4:32 PM To: Multiple recipients of list ORACLE-L Charlie Mengler wrote: I would have thought that the first day of the month is ALWAYS the 1st, as in 1 (ONE)! Please explain why it needs to be calculated or could be a value other than ONE. [EMAIL PROTECTED] 01/23/02 10:35AM Hey guys, I know this is propablby easy, but I'm a bit overwhelmed here this week. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards Another case of 'On what day does Xmas fall this year? - on December 25th'. I think that using the TRUNC() function with the suitable parameter must help you truncate SYSDATE to the first day of the month - perhaps TRUNC(SYSDATE, 'MM') or similar (too tired to RTFM). Then TO_CHAR with the suitable format should return whatever you want. For the last day, I presume that identifying the first day of the NEXT month and substracting 1 must simplify the 'is this 30/31/28/29' question. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
performance problem with partitioned table query.
Oracle 8.1.7.0.0 table event_t range partitioned by column poid_id0. only 1 partition called p_1 out of the 14 contains data. A query on event_t became significantly slow after rows increase: select poid_DB, poid_ID0, poid_TYPE, poid_REV, start_t, end_t, sys_descr from event_t where event_t.end_t = :1 and event_t.end_t :2 and event_t.poid_TYPE like :3 and (event_t.account_obj_ID0 = :4 and event_t.account_obj_DB = 1 ) order by event_t.end_t desc Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0PARTITION RANGE (ALL) PARTITION: START=1 STOP=14 0 TABLE ACCESS GOAL: ANALYZED (BY LOCAL INDEX ROWID) OF 'EVENT_T' PARTITION: START=1 STOP=14 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'I_EVENT__ACCTOBJ_END_T' (NON-UNIQUE) PARTITION: START=1 STOP=14 Index I_EVENT__ACCTOBJ_END_T was created on event_t ( account_obj_id0, end_t ) using LOCAL. Other 2 columns involved in the where clause have either only one distinct value or a few. So are not indexed. column account_obj_id0 has 1 million unique values in event_t and remain unchanged during the tests. when rows insert, average rows per account_obj_id0 value increase as well. Trace shows always the same execution plan but elapsed time increased enormously! I did 2 rounds of tests, every round I dropped and recreated event_t empty: In test round 1: 1.) inserted 1 million rows into event_t with same end_t value. Query returned: call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse 23 0.02 0.09 0 0 0 0 Execute156 0.02 0.29 0 0 0 0 Fetch 156 0.14 1.09 8 2698 0 195 --- -- -- -- -- -- -- total 335 0.18 1.47 8 2698 0 195 2.) inserted ANOTHER 1.5 million rows into event_t with 10,000+ different end_t values. Query returned: Parse 36 0.00 0.04 0 0 0 0 Execute118 0.01 0.01 0 0 0 0 Fetch 118 0.61 86.71 1385 5045 0 587 --- -- -- -- -- -- -- total 272 0.62 86.76 1385 5045 0 587 In test round 2: 1.) inserted 1 million rows into event_t with same end_t value. Query returned as round1 step 1.) 2.) inserted ANOTHER 5 million rows into event_t with ANOTHER end_t value. Query returned: Parse 40 0.00 0.11 0 0 0 0 Execute139 0.02 0.12 0 0 0 0 Fetch 139 0.25 4.66303 2868 0 761 --- -- -- -- -- -- -- total 318 0.27 4.89303 2868 0 761 3.) inserted ANOTHER 2 million rows into event_t with 12,000+ different end_t values. Query returned: Parse 34 0.01 0.01 0 0 0 0 Execute 97 0.00 0.06 0 0 0 0 Fetch 97 0.58 89.93 1257 4260 0 614 --- -- -- -- -- -- -- total 228 0.59 90.00 1257 4260 0 614 In test round 1 elapsed time increased 60 times from 1 million to 2.5 million rows. In round 2 it increased 3 times from 1 to 6 million rows, and 18 times from 6 to 8 million rows. So #-of-rows in event_t is not the #1 convict for large physical reads. It's more likely the #-of-different-end_t-values. Before I always thought that to an indexed column the more different values the better. But what's going on in this case? Am I missing anything? Top wait event in statspack report is 'db file sequential read'. oradebug event 10046 shows 'db file sequential read' is waiting on object event_t. Thank you! Jessica Mao Portal Software, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jessica Mao 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
creating a procedure
I want to create a stored procedure that takes the following information and puts it into a table. How would I do this? CREATE OR REPLACE Procedure Used_license as Begin Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH' and A.pc_date =SYSDATE -1 minus Select B.Pc_session_id From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date =SYSDATE -1 End; I am tying to do it this way but getting errors: PLS-00103: Encountered the symbol END when expecting one of the following: * - + ; / for mod rem an exponent (**) and or group having intersect minus order start union where connect || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais 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: creating a procedure
I think you need a ; at the end of the select statement. -Original Message- Sent: Wednesday, January 23, 2002 6:20 PM To: Multiple recipients of list ORACLE-L I want to create a stored procedure that takes the following information and puts it into a table. How would I do this? CREATE OR REPLACE Procedure Used_license as Begin Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH' and A.pc_date =SYSDATE -1 minus Select B.Pc_session_id From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date =SYSDATE -1 End; I am tying to do it this way but getting errors: PLS-00103: Encountered the symbol END when expecting one of the following: * - + ; / for mod rem an exponent (**) and or group having intersect minus order start union where connect || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais 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: Seefelt, Beth 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: SCOTT/TIGER
there are several instructors named Scott how do you know which one it is or even if it's one of the instructors? --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Ok...it's true. Take the Oracle Technical seminars and you too may get to meet Scott, Live and In Person. Unfortunately, Tiger is waiting for Scott at the Rainbow Bridge, but Scott is still there (at least he was last year...you know how Oracle's been lately). -Original Message- Sent: Wednesday, January 23, 2002 10:26 AM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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).
RE: creating a procedure
You used an incorrect name for the procedure. Here is one that compiles flawlessly: CREATE OR REPLACE Procedure RTFM Begin Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH' and A.pc_date =SYSDATE -1 minus Select B.Pc_session_id From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date =SYSDATE -1; End; The procedure will now compile run without a glitch. It will not do anything, but it will compile. Name is everything! Oh, what the heck, it has been a long day in the office! -Original Message- Sent: Wednesday, January 23, 2002 6:20 PM To: Multiple recipients of list ORACLE-L I want to create a stored procedure that takes the following information and puts it into a table. How would I do this? CREATE OR REPLACE Procedure Used_license as Begin Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH' and A.pc_date =SYSDATE -1 minus Select B.Pc_session_id From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date =SYSDATE -1 End; I am tying to do it this way but getting errors: PLS-00103: Encountered the symbol END when expecting one of the following: * - + ; / for mod rem an exponent (**) and or group having intersect minus order start union where connect || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: creating a procedure
I think that all you need is a ; before the end You need to close your statement within the procedure body -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Lance Prais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 24/01/2002 09:20 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:creating a procedure I want to create a stored procedure that takes the following information and puts it into a table. How would I do this? CREATE OR REPLACE Procedure Used_license as Begin Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH' and A.pc_date =SYSDATE -1 minus Select B.Pc_session_id From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date =SYSDATE -1 End; I am tying to do it this way but getting errors: PLS-00103: Encountered the symbol END when expecting one of the following: * - + ; / for mod rem an exponent (**) and or group having intersect minus order start union where connect || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais 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 transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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).
RE: Backup/Recovery questions ...
and most importantly of all, if you don't want to have to repeat (and repeat) this exercise... BACKUP THE NEW DATABASE --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Fred, Either method works fine. You have the same amount of data editing in both methods (Either issue alter database rename commands, or edit the create controlfile file. The other consideration is that in Rachel's method, you are simply opening the database afterword. With the re-creation of the control file, you must (I think) alter database open resetlogs. A minor difference. Whichever way you decide to do it would be fine. The end result is a ton of typing. Something to consider is, on your production box, create disk directories based on a Unix soft link, and place your database files into these directories. This would facilitate your moving of the database in the future, as your soft links are at the operating system level, and can be changed more easily than issuing the alter database commands. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, January 23, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Would I be better off doing that or doing a backup controlfile to trace from server A, moving the datfiles logfiles to server B, and then editing the newly created trace file into a script that creates a new controlfile with the new datafile/logfile locations? From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Backup/Recovery questions ... Date: Wed, 23 Jan 2002 11:00:36 -0800 First load all the datafiles and logfiles to server B in the locations you want them. Load the controlfiles as well, they aren't useless. Now. edit the init.ora file on server B to point to where the control files are. create a sql script file that contains (for every datafile and logfile) alter database rename file 'original file name' to 'new file name'; the file names should include the full path specification. now go into svrmgrl: connect internal startup mount run the script alter database open; exit and you have moved the database and files to the new server --- Fred Smith [EMAIL PROTECTED] wrote: List, I am attempting to verify the validity/integrity of a full cold backup I did off of my production server. I backed up the datafiles,logfiles, controlfiles. The production server (server A) is much larger with dozens of drives. I now wish to apply this backup to another server (server B). Server B does not have the same drive configurations as server A. Based on this I'm assuming that my controlfiles from Server A are useless. How can I bring this database up on server B now? There are over 100 datafiles. OS: SunOS 5.6 Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production Thank you, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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). _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith INET: [EMAIL PROTECTED] Fat
RE: SCOTT/TIGER
The name I was given is Scott Gossett. My team leader and one of our team members took the advanced seminars last year, and their instructor was Scott, and he admitted his notoriety. -Original Message- Sent: Wednesday, January 23, 2002 4:00 PM To: Multiple recipients of list ORACLE-L there are several instructors named Scott how do you know which one it is or even if it's one of the instructors? --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Ok...it's true. Take the Oracle Technical seminars and you too may get to meet Scott, Live and In Person. Unfortunately, Tiger is waiting for Scott at the Rainbow Bridge, but Scott is still there (at least he was last year...you know how Oracle's been lately). -Original Message- Sent: Wednesday, January 23, 2002 10:26 AM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
link error - gnu compiler / cygwin / Pro*C / Oracle 8.1.7 / Windo
Title: link error - gnu compiler / cygwin / Pro*C / Oracle 8.1.7 / Windows 2000 My apologies for this non-strictly DBA question. Has anyone successfully used Oracle 8.1.7 Pro*C on Windows 2000 using the Gnu Compiler (gcc) that comes with Cygwin? I've tried the following commands in Cygwin proc iname=test.pc oname=test.c include=C:\Oracle817\precomp\public - command successful (I see file test.c) gcc -I/cygdrive/c/Oracle817/precomp/public -c -o test.o test.c - command successful (I see file test.o) gcc -o test.exe /cygdrive/c/Oracle817/oci/lib/bc/oci.lib /cygdrive/c/Oracle817/precomp/lib/msvc/orasql8.LIB test.o - command fails: /cygdrive/c/Oracle817/oci/lib/bc/oci.lib: file not recognized: File format not recognized collect2: ld returned 1 exit status Related question: in my 8.1.7 Oracle Home, I see the following files oci\lib bc\oci.lib bc\ociw32.lib msvc\oci.lib msvc\ociw32.lib precomp\lib msvc\oraSQL8.LIB msvc\oraSQX8.LIB which of those are required to link when you create a Pro*C program? i.e. which would I supply as a filename to gcc -l?
RE: creating a procedure
Title: RE: creating a procedure -Original Message- From: Lance Prais [mailto:[EMAIL PROTECTED]] I want to create a stored procedure that takes the following information and puts it into a table. How would I do this? CREATE OR REPLACE Procedure Used_license as Begin Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH' and A.pc_date =SYSDATE -1 minus Select B.Pc_session_id From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date =SYSDATE -1 End; I am tying to do it this way but getting errors: PLS-00103: Encountered the symbol END when expecting one of the following: * - + ; / for mod rem an exponent (**) and or group having intersect minus order start union where connect || You are going to have to store the result of a query into a variable. Does the query return one row or more? If you just want to put the results of your query in to a table, use an insert ... select ... Some examples: create or replace procedure x as my_dummy sys.dual.dummy%type ; my_object_name sys.dba_objects.object_name%type ; cursor c_obj_name (c_owner in varchar2) is select object_name from dba_objects where owner = c_owner ; begin /* example of query that returns only one row */ select dummy into my_dummy from dual ; /* example of query that returns several rows */ for c_obj_rec in c_obj_name ('SYSTEM') loop my_object_name := c_obj_rec.object_name ; end loop ; end ; /
Re: ORACLE-L Digest -- Volume 2002, Number 023
Ethan, Thanks for the alternative code. I got the exact same time either way. table a = 7000 records, table b = 30,000 records. old netware/oracle7 server. 1 select 2 count( m.student_ssn ) 3from 4 student_master m, 5 SIS_CSUS_ALL_FALL_2001_eos1 x 6 where 7 m.student_ssn = x.stu_id (+) 8 and 9*x.stu_id is null SQL / COUNT(M.STUDENT_SSN) 5406 (35 seconds) 1 select 2 count( m.student_ssn ) 3from 4 student_master m 5 where 6 not exists 7 ( 8 select 9null 10 from 11SIS_CSUS_ALL_FALL_2001_eos1 x 12 where 13m.student_ssn = x.stu_id 14* ) SQL / COUNT(M.STUDENT_SSN) 5406 (35 seconds) best regards, ep On 23 Jan 2002 at 1:05, Oracle RDBMS Community Forum wrote: ORACLE-L Digest -- Volume 2002, Number 023 -- From: Post, Ethan [EMAIL PROTECTED] Date: Tue, 22 Jan 2002 17:17:23 -0600 Subject: RE: Sql query I believe this will work also and may be faster... select c1 from t1 a where not exists (select null from t2 b where a.c1 = b.c1); -- 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).
RE: creating a procedure
I am not one to usually shout RTFM from the mountain top, but I somehow feel compelled because I have read a couple of responses that hadn't mentioned that age old mantra. Your procedure might be salvagable by putting a ; at the end of your select statement, but I don't believe it will do anything more than compile. You need to look into The Oracle Docs on PL/SQL. Because while you might have created a procedure, it isn't very procedural. Steve McCLure -Original Message- Sent: Wednesday, January 23, 2002 3:20 PM To: Multiple recipients of list ORACLE-L I want to create a stored procedure that takes the following information and puts it into a table. How would I do this? CREATE OR REPLACE Procedure Used_license as Begin Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH' and A.pc_date =SYSDATE -1 minus Select B.Pc_session_id From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date =SYSDATE -1 End; I am tying to do it this way but getting errors: PLS-00103: Encountered the symbol END when expecting one of the following: * - + ; / for mod rem an exponent (**) and or group having intersect minus order start union where connect || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais 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: Steve McClure 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).
Eval copy of 91
I have purchased an eval copy of 9i for my PC using XP Prof. The eval is for 30 days. What happens at the end of the eval period? Does my PC melt, does the DB lock up, or nothing? TIA, Ken Janusz, CPIM -- 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).
RE: SCOTT/TIGER
So who was SYS, and why on earth did s/he name his/her pet CHANGE_ON_INSTALL??? :-) [EMAIL PROTECTED] 24/1/2002 12:00:27 This message has been scanned by MAILSweeper. The name I was given is Scott Gossett. My team leader and one of our team members took the advanced seminars last year, and their instructor was Scott, and he admitted his notoriety. -Original Message- Sent: Wednesday, January 23, 2002 4:00 PM To: Multiple recipients of list ORACLE-L there are several instructors named Scott how do you know which one it is or even if it's one of the instructors? --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Ok...it's true. Take the Oracle Technical seminars and you too may get to meet Scott, Live and In Person. Unfortunately, Tiger is waiting for Scott at the Rainbow Bridge, but Scott is still there (at least he was last year...you know how Oracle's been lately). -Original Message- Sent: Wednesday, January 23, 2002 10:26 AM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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 email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Connecting INGRES using database link
Dear Bambi, Unfortunatly, 10 years ago I still a kid.. ^_^ Did you know any web site/mailing list/or other resources relate with this problem (INGRES), so I can solve this problem? Thanks in advance Holly -Original Message- Sent: Thursday, January 24, 2002 1:02 AM To: Multiple recipients of list ORACLE-L Golly, that looks an awful lot like VMS. I think what it's trying to tell you is that the node you specified is not reachable, or that the SID you've specified is not on the node listed. There's some kind of connection problem there. Try doing a select from the Ingres side over the connection. If it works, I don't know what to tell you. If it fails, drop and recreate the connection string. The important thing is that this error is NOT an Oracle error... it is a wrapper around what it's getting from the Ingres side... and it looks for all the world like it's not purely an Ingres error either. That E_ is a VMS level error (W would be warning, F would be fatal). Unfortunately, I've been largely off of VMS since 93, so I'm not going to be able to help a lot there either. Wish you would have asked this question about 10 years ago... ;) Bambi. -Original Message- Sent: Tuesday, January 22, 2002 9:05 PM To: Multiple recipients of list ORACLE-L thank you Bambi. I already tried to create database link using HSODBC, but failed. It returned this messages : == SQL select * from cond@hsodbc; select * from cond@hsodbc * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES driver][INGRES]E_LQ0001 Failed to connect to DBMS session. E_LC0001 GCA protocol service (GCA_REQUEST) failure. Internal service status E_GC0132 -- User provided a vnode as part of the database name (vnode::dbname), but connection information for that vnode i (SQL State: S1000; SQL Code: -38100) ORA-02063: preceding 6 lines from HSODBC == Is someone familiar with this kind of error... TIA, Holly -Original Message- Sent: Wednesday, January 23, 2002 4:20 AM To: Multiple recipients of list ORACLE-L Holly -- It has been a long time since I have done Oracle and Ingres at the same time (about 12 years (Oracle v6/Ingres v5)). Back then, while there was kinda-sorta ODBC to and from both Oracle and Ingres, they weren't able to access each other directly. Generally, data transfers were to and from flat files, and queries between objects in the two databases utilized a third party tool (Passport). HTH, Bambi. -Original Message- Sent: Monday, January 21, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Dear all, Can I create database link using generic connectivity (ODBC)? Was there someony already try this? I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on VAX/VMS. TIA, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho 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: Bellows, Bambi 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: Ahmadsyah Alghozi Nugroho 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
Re: Eval copy of 91
Yes your PC melts down. my question is why would you purchase an eval copy when you can join technet and download the latest version and play with it to your heart's content(single user developer license)? joe [EMAIL PROTECTED] wrote: I have purchased an eval copy of 9i for my PC using XP Prof. The eval is for 30 days. What happens at the end of the eval period? Does my PC melt, does the DB lock up, or nothing? TIA, Ken Janusz, CPIM -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- 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).
Re: SCOTT/TIGER
That was Scott's Dad, and system was his mother and Yes Jared, i'm moving it to the OT list :) joe Arn Klammer wrote: So who was SYS, and why on earth did s/he name his/her pet CHANGE_ON_INSTALL??? :-) [EMAIL PROTECTED] 24/1/2002 12:00:27 This message has been scanned by MAILSweeper. The name I was given is Scott Gossett. My team leader and one of our team members took the advanced seminars last year, and their instructor was Scott, and he admitted his notoriety. -Original Message- Sent: Wednesday, January 23, 2002 4:00 PM To: Multiple recipients of list ORACLE-L there are several instructors named Scott how do you know which one it is or even if it's one of the instructors? --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Ok...it's true. Take the Oracle Technical seminars and you too may get to meet Scott, Live and In Person. Unfortunately, Tiger is waiting for Scott at the Rainbow Bridge, but Scott is still there (at least he was last year...you know how Oracle's been lately). -Original Message- Sent: Wednesday, January 23, 2002 10:26 AM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- 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).
Re: Eval copy of 91
Nothing, really. But it is quite likely that an Oracle sales rep will be giving you a call sometime during your evaluation. Chuck - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 23, 2002 10:15 PM I have purchased an eval copy of 9i for my PC using XP Prof. The eval is for 30 days. What happens at the end of the eval period? Does my PC melt, does the DB lock up, or nothing? TIA, Ken Janusz, CPIM -- 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: Charles Wolfe 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 the Form6i on Web
When I migrate the Form5 to Form6i and deploy the form into WEB, I encounter a problem. In Form5, I use a form to call all the functions forms and process the login. So, the functions forms can get the login user's information by :Global variable. Now, in Web method, I use a jsp to process the login and functions hyperlinks, and the problem is how can I build a global variable in jsp and access by form in form server? Thank you very much! Best Rgds, Leslie
Re: Oracle 9i installation Java RunTime Environment was not found.
Dear Friends, I am trying to install Oracle 9i on Sun Solaris 5.8.But while installting i get the following error hi, you need JRE for installation. I think your system didn't installed or have a problem. You can download , install and try to install Oracle again. -Onder Kokturk