RE: Database Comparison
Srini, But be careful - the Change Management pack for OEM is a purchaseable option. It is not free. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 09, 2002 11:20 PM To: Multiple recipients of list ORACLE-L Srini, Use the change manager that comes with Oracle Enterprise manager. The initial set-up is little bit difficult. But once u r through, then it is an handy tool. Venkat -- On Wed, 09 Jan 2002 11:00:36 Paul Baumgartel wrote: >There's a very good script available at http://www.dbspecialists.com. > >--- [EMAIL PROTECTED] wrote: >> Hi: >> >> I need to compare my Production database with QA database. I would >> like to >> generate a report that shows differences in schemas across these two >> databases(tables, indexes, views, object definition, etc..). I >> would >> appreciate it if you could forward me a script that would accomplish >> this or >> any websites where I can find one. >> >> Thanks >> >> Srini Rajendran. >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >__ >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: Paul Baumgartel > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database Comparison
Srini, I would suggest going to http://www.toadsoft.com and downloading the freeware version in order to use the "Schema Compare" tool. All it would require would be a database link between your Production DB and your QA DB, or vice-versa. It will show you all object differences. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 09, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Hi: I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one. Thanks Srini Rajendran. -- 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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-600 Parser...
I ran across something that I have not seen before when logging a TAR via MetaLink. Oracle now has an ORA-600 parser and lookup. Thought you might all be interested if you have access to MetaLink: http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=153788.1&blackfr ame=0 Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Best practices for data warehousing in 9i
Materialized views with query_rewrite enabled. Can work wonders for long-running reports. This was available in 8i, so not exactly new to 9i, but something you left off your list. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 08, 2002 2:53 PM To: Multiple recipients of list ORACLE-L What are considered to be some of the best practices for physical database layout in 9i for data warehouses. This would be on Sun Solaris 2.6 and 9.0.1 (or possibly 9.0.2 if it comes out anytime soon). Would be using partitioning and star schema as well as bit-map indexes. Anything important to consider in 9i in terms of new features for data warehousing? Any thing to watch out for? Thanks for any experience you might have in this area. Cherie Machler Oracle DBA Gelco Information Network -- 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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: EMC Not Releasing Space
Walter, We had the same exact problem on our SAP installation running on EMC Symmetrix. The space would not be release until the database was bounced. We never did find a work-around. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 08, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Hi, Just curious if anyone has any experience with an EMC Symmetrix not releasing the space for a deleted datafile. If so, is there a solution or work-around? Yesterday, we took a tablespace offline, dropped it and then deleted the associated datafile. The file was 1G in size and today the space has still not been released as indicated by 'df -k'. According to another DBA here, they have seen this in the past and said bouncing the DB remedied the problem. It sounds like the inodes are still in use by Oracle but I can't imagine why. I've worked with Symmetrix systems before and have never experienced this behavior. We are running 8.1.7.2 (64bit) on Solaris 2.8. Any suggestions? As always, your feedback is appreciated. -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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL to find duplicate rows...
Thank you everyone! We found the culprits Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 06, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Jim, Oops! Right after I sent this, I saw that you asked to find, not delete, duplicates. Sorry, I've spent the last two days de-duping a bunch of tables, so I've got deletion on the brain. How about: Select SomeColumn >From MyTable Where MyColumn In ( Select MyColumn From My Table Group By MyColumn Having Count(*) > 1 ) ; Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Thursday, December 06, 2001 3:34 PM To: [EMAIL PROTECTED] Jim, An option that handles multiple duplicates is: Delete >From MyTable Where (MyColumn,RowID) In ( Select MyColumn,RowID From MyTable Minus Select MyColumn,Min(RowID) From MyTable Group By MyColumn ); You could use Max(RowID) as well, depending on your needs. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- JAMES W [IT/1000] Sent: Thursday, December 06, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Hello all, I know this has come across many times now, and I thought I had it saved somewhere - you know how that goes... I need to query a table to find all duplicate rows based on a given column. Don't feel like re-inventing the wheel... Thanks in advance, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL to find duplicate rows...
Hello all, I know this has come across many times now, and I thought I had it saved somewhere - you know how that goes... I need to query a table to find all duplicate rows based on a given column. Don't feel like re-inventing the wheel... Thanks in advance, Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BMC Patrol DBXray / CA Unicenter
We looked at Quest extensively, and even began rolling it out. I/Watch fell apart at the seams when we tried to scale... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 04, 2001 9:55 PM To: Multiple recipients of list ORACLE-L Tools! Tools! Tools! Did you look at Quest at all? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/4/01 5:35 PM CA Unicenter sucks, CA support sucks. CA sucks. Stay away. -Original Message- Sent: Tuesday, December 04, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BMC Patrol DBXray / CA Unicenter
We looked at Quest extensively, and even began rolling it out. I/Watch fell apart at the seams when we tried to scale... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 04, 2001 9:55 PM To: Multiple recipients of list ORACLE-L Tools! Tools! Tools! Did you look at Quest at all? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/4/01 5:35 PM CA Unicenter sucks, CA support sucks. CA sucks. Stay away. -Original Message- Sent: Tuesday, December 04, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BMC Patrol DBXray / CA Unicenter
Title: RE: BMC Patrol DBXray / CA Unicenter Lisa, We are now concluding a very lengthy selection process, and it looks like we will go with BMC Patrol/DB X-Ray. We refuse to do business with CA, and had a very bad experience with Quest I/Watch. None of these are easy to roll-out enterprise wide, but the functionality is exhaustive. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 04, 2001 2:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: BMC Patrol DBXray / CA Unicenter Hi Lisa, CA Unicenter has been a source of many nightmares and sleepless nights in the past for me. I was very glad when I quit that job... Just my .02 Lisa Koivu Certified Monkey Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: YTTRI Lisa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Subject: BMC Patrol DBXray / CA Unicenter Hi - Does anyone have experience with either of these products? I'm interested in ease of installation, ease of use, and quality of support. I realize they are both pricey, but they both seem to do a lot. I've been asked to look at alternatives (I'm sure the cost will be prohibitive, but we'll see). Also if you know of any comparable tools, I'm very interested to hear about them. Thanks much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rman restore & arclogs
Title: RE: rman restore & arclogs
Lisa,
I
believe Oracle tries to restore the most recent version of the archivelogs,
according to the timestamp in the catalog. But if that's corrupted or not
found for whatever reason, you can get it from the other
backupset.
Jim
P.S. Sorry for the vague answer, but I haven't ever had to do this
so I'm not sure myself. I can ask our RMAN Guru if you really want to know
; )
__ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise
Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314)
694-4417 Cellular (314) 724-9664 Pager (314)
294-9797
[EMAIL PROTECTED]
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001
2:46 PMTo: '[EMAIL PROTECTED]'; HAWKINS, JAMES W
[IT/1000]Subject: RE: rman restore &
arclogs
Interesting. Does rman ever get
confused during a restore or does it just grab the most convenient backup set
with the required archive logs on it? I don't suppose you can parallel restore
your arclogs from different files/tapes? (There goes that monkey
again)
Thanks for your response Jim.
Lisa
-Original Message- From: HAWKINS, JAMES W [IT/1000]
[SMTP:[EMAIL PROTECTED]] Sent: Monday, December
03, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: rman restore & arclogs
I just wanted to throw something
else out there - it may have already come up though. We backup the
archivelogs first without deleting them, and then immediately backup another
set with the "delete" specified. Obviously, this is because anything
can happen to that first set (corruptions, etc.), and if that's your only
set, then you're screwed. The chances of the same archivelog
being corrupt in both sets is very low (unless the source archivelog is
corrupted), but at least you are protected against all the copy
errors. Also, it's very probable (for us, anyway) that each copy of
the archivelog will be on different physical tapes, which in itself is
important to us since operations is outsourced ; )
Jim
__Jim
HawkinsOracle Database AdministratorData Management Center of
Expertise
Pharmacia Corporation800 North
Lindbergh Blvd.St. Louis, Missouri 63167Work (314)
694-4417Cellular (314) 724-9664Pager (314)
294-9797
[EMAIL PROTECTED]
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED]]Sent: Monday,
December 03, 2001 12:56 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: rman restore & arclogsLisa, I guess
I'm lazy (or cautious) in that I would allow the first backup to take this
archive log files back to tape where they belong, rather than determine
(by running reports) which log files I may delete (by hand).
The
cautious part of me says that if Rman decided to back these monkeys up
within the first save set after the recovery, it may have decided that it
needs them for a future recovery. If you did remove them by hand,
Rman may complain that it was expecting them and did not find them.
Did you try this - remove one that was restored by the recovery process
and then tried a backup?
Depending on the kind of restore you do - a full, or a point
in time - the archivelog may be of no use anyway (a point in time makes
them invalid because you had to perform an "open db reset logs", while a
full restore could still use these again).
Glad
you are at least experimenting with the tool before you put it in
production - it actually is fun to do a restore as it happens so
infrequently!
Good
Luck!
Tom MercadanteOracle Certified
Professional
-Original
Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday,
December 03, 2001 10:30 AMTo: Multiple recipients of
list ORACLE-LSubject: rman restore &
arclogs
Good morning all -
I've been practicing rman restores. It's a
lot easier than I originally thought. I've noticed that when you
restore and the arclogs are needed, it restores them. Which is
expected. However, when I take another backup, these arclogs are
included in the backup set. This is unnecessary in my opinion and
makes my backup files larger than they need to be.
Is it standard practice to just delete the arclogs
that were already in a backup set prior to taking the immediate backup
after
RE: rman restore & arclogs
Title: rman restore & arclogs I just wanted to throw something else out there - it may have already come up though. We backup the archivelogs first without deleting them, and then immediately backup another set with the "delete" specified. Obviously, this is because anything can happen to that first set (corruptions, etc.), and if that's your only set, then you're screwed. The chances of the same archivelog being corrupt in both sets is very low (unless the source archivelog is corrupted), but at least you are protected against all the copy errors. Also, it's very probable (for us, anyway) that each copy of the archivelog will be on different physical tapes, which in itself is important to us since operations is outsourced ; ) Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 12:56 PMTo: Multiple recipients of list ORACLE-LSubject: RE: rman restore & arclogs Lisa, I guess I'm lazy (or cautious) in that I would allow the first backup to take this archive log files back to tape where they belong, rather than determine (by running reports) which log files I may delete (by hand). The cautious part of me says that if Rman decided to back these monkeys up within the first save set after the recovery, it may have decided that it needs them for a future recovery. If you did remove them by hand, Rman may complain that it was expecting them and did not find them. Did you try this - remove one that was restored by the recovery process and then tried a backup? Depending on the kind of restore you do - a full, or a point in time - the archivelog may be of no use anyway (a point in time makes them invalid because you had to perform an "open db reset logs", while a full restore could still use these again). Glad you are at least experimenting with the tool before you put it in production - it actually is fun to do a restore as it happens so infrequently! Good Luck! Tom Mercadante Oracle Certified Professional -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: rman restore & arclogs Good morning all - I've been practicing rman restores. It's a lot easier than I originally thought. I've noticed that when you restore and the arclogs are needed, it restores them. Which is expected. However, when I take another backup, these arclogs are included in the backup set. This is unnecessary in my opinion and makes my backup files larger than they need to be. Is it standard practice to just delete the arclogs that were already in a backup set prior to taking the immediate backup after a recovery? I can verify what arclogs are where in the backup sets with a report. Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117
RE: Oracle 9i and OEM
Sepi, Just a guess - are all three instances listed in your /etc/oratab file? I'm pretty sure OEM looks at that to determine what instances the Agent should monitor. I could be wrong on this though - it's been a while since I've looked at OEM. JIm __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 20, 2001 10:50 PM To: Multiple recipients of list ORACLE-L Hi, I have a problem with Enterprise Manager. I am trying to refresh a node in order to get information of all instances on that machine. I am able to see two of three instances. Why I cannot see all of them. Setting up the preferences are ok, I have tested all user-id's and passwords. TIA, Sepi _ 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: Seppo Kaasalainen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Disk to Disk backups and RMAN
clude a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Disk to Disk backups and RMAN
g list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Operating Systems
Scott, NT? I think the habaneros and tequila have finally taken over... ;) Seriously, stay away from NT. I have the unfortunate task of monitoring a few minor databases on NT in addition to my Unix ones, and I hate every minute of it. The locks it places on open files prevent you from doing a lot of things with the database up, it has to be rebooted every month, and it is a nightmare to administer remotely. We use pcAnywhere which only allows one user in at a time. I curse NT and Gates every day... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 14, 2001 12:13 PM To: Multiple recipients of list ORACLE-L Linux or Solaris Intel. And maybe (gods help me! ) NT? Scott Shafer San Antonio, TX Regina Harter wrote: > > Hi Guys, > > Our SA/DBA is considering dumping Unixware and moving to a different > OS. Sun is out for reasons that are not being shared with me, probably > because they don't want to buy new hardware, so aside from that, would > anyone care to weigh in with opinions on what OS is most stable with > Oracle? AAnd will run on an intel based box? Ours is not a high > transaction system, mostly reads, maybe 100 users a day. > > Thanks for your opinions, > Regina > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Regina Harter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need script to generate DDL for snapshot/materialized view recrea
hy, I ask, does the Jewish people generate so much suffering, why do we inflict - on others and ourselves - so much pain. What is the source of the Israeli sense of pride, why is the act of killing considered so great in our eyes. I am a soldier in the Israeli army, imprisoned for refusal to take part in repression, arising from a sense that it is out of the question to be a Jew, the son of a people of refugees, and yet repress a people of refugees (there's no disagreement in the Israeli public regarding repression of the Palestinians, merely over whether or not it's justified). I am a God-fearing Jew, and as such forbidden to take part in denying freedom and serving in occupied territory. I am imprisoned, but yet feel freer than most of the Israelis I've met, for one simple reason: I don't bear the burden of vindictiveness and the perverse gratification attending it. I don't bear the burden of denial and callousness. I am concerned for humans as such. For those denied the right to live like me, with food and clothes and fun and good health and dreams of success and a car. I am concerned for people who are humiliated every day, who are denied the right to work, who are imprisoned within their towns and villages. I am concerned for those whose homes have been demolished and their fruit groves devastated. I am concerned because I know that the terrible hatred towards me is justified. This hatred has led to horrifying and perverted manifestations, like the young suicide bombers, but we create the conditions that lead to this monstrosity. I am concerned because I know that the cries of exultation over the killings drown out the sobs of the numerous victims, Jews and Arabs, of the widows and orphans, of the cripples who will suffer for the rest of their lives because of that pride and callousness. This is a concern unlike that of most of the Israeli people. For this concern demands correction [tikkun] whereas the other concern merely calls for more destruction. I am a prisoner yet free, but the pain runs deep. I hope my imprisonment, and that of others, will lead many in our society to contemplation - contemplation of the Palestinians, and by way of them, contemplation of ourselves. I regard my imprisonment as the true way to participate in presentday Israeli society. I don't think my imprisonment releases me from responsibility. Even if I weren't serving in the army, I'd continue to share responsibility for these actions. I'm not the victim. On the contrary: precisely because I regard myself as sharing responsibility, I refuse to take part in the repression. I am a soldier and wish to serve my country. I am a part of Israeli society: that is where I find people I love, including some who act contrary to my convictions. They include right and left. I just want us Israelis - strong, triumphant - to look into the eyes of those we repress, and try to understand them. For the victory of might is no victory. Our fears will leave us only when we consent to equality between peoples and between individuals. We too shall continue to live in fear as long as we implement oppression and deny elementary rights. Instead of justifying suffering - that which we inflict, and our own - we should try to solve it by self correction [tikkun atzmi]. Faith in tikkun is a weapon more powerful than tanks. I regard my imprisonment as a foundation for tikkun, and hope that by way of thinking about it, others will look at the reality about us, and contribute to change. David Haham-Herson was born and raised in Israel. WE WANT TO HEAR from you! Use our direct link to share your views. [ http://www.tikkun.org/magazine/index.cfm/action/your_views.html ] Or write to "Letters," Tikkun Magazine, 2107 Van Ness Ave., Suite 302, San Francisco, CA 94109; Fax: (415) 575-1434. Please include your name, address, and daytime phone number. Letters may be edited for space and clarity. --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKI
RE: OT: Duhvelopers and DB-ehs?
gt; <> > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > > Sent: Wednesday, August 29, 2001 1:43 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: !! Keeping the list alive > > > > > > > > > > > > > > > > This list is apparently a more valuable resource to many of you > > > > > >than I > > > > > > > realized. > > > > > > > > I'm literally bowled over by the generosity. I've received > > > > so many emails > > > > about > > > > this that I really can't personally reply to them all right now. > > > > > > -- > > > 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: Boivin, Patrice J > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > >San Diego, California-- Public Internet access / Mailing Lists > > > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > >the message BODY, include a line containing: UNSUB ORACLE-L > > >(or the name of mailing list you want to be removed from). You may > > >also send the HELP command for other information (like subscribing). > > > > _ > > 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: Jan Pruner > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Thomas, Kevin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > - > This Mail has been checked for Viruses > Attention: Encrypted mails can NOT be checked! > > ** > > Diese Mail wurde auf Viren geprueft > Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! > --------- -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE you
RE: OT: football fan-hood
list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: football fan-hood
ail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. Northern Electric plc Carliol House Market Street Newcastle-upon-Tyne NE1 6NE Registered in England and Wales: Number 2366942 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Garner, John (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: football fan-hood
Rachel, Passed out is when she should like me the most - it's the only time she has control over the TV remote ;) Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 30, 2001 12:27 PM To: Multiple recipients of list ORACLE-L I think it's that "pass out" part she's upset with :) >From: "HAWKINS, JAMES W [IT/1000]" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT: football fan-hood >Date: Thu, 30 Aug 2001 07:00:51 -0800 > >Lisa, > >I, for one, hold you in the highest esteem and wish you would talk some >sense into my wife. My typical Sunday during Rams home games goes >something >like this: > >6AM - Coffee, breakfast, read the Sports section for today's matchup. >8:30AM - Meet at my house and depart for TWA Dome. >9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. >Noon - 3:15PM - Watch "The Greatest Show on Earth" beat up on defenses. >3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday >Ticket. > Note: I have the ability to watch all three games at once using a >well-developed channel-flipping technique. >6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. >7:00PM - 10:00PM - Watch whoever's playing, more beer. >10:01PM - Pass out. > >My wife just doesn't get it... > >Jim > > >__ >Jim Hawkins >Oracle Database Administrator >Data Management Center of Expertise > >Pharmacia Corporation >800 North Lindbergh Blvd. >St. Louis, Missouri 63167 >(314) 694-4417 > >[EMAIL PROTECTED] > >-Original Message- >Sent: Thursday, August 30, 2001 8:27 AM >To: Multiple recipients of list ORACLE-L > > > >BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare >say they will be better than the Vikings this year. > >Charge that $5 to my account. Sorry. > >The short story is: >Grew up in MN... my whole family watched the Vikings... my grandfather was >one of the announcers... I was going to Purple Crush games at 6 years old >with my mother in the Met Stadium. I was (still am) a tomboy and there was >no girls football or hockey back then. There. I said it. > > -Original Message- >Sent: Thursday, August 30, 2001 9:01 AM >To: Multiple recipients of list ORACLE-L > > I thought that she was s overwhelmed by the choices available >that she decided to be an "outsider" and pick a team from snow-bird country >so she would be accepted in Ft.Laud. > > After all she does have 3 Florida football teams to choose from. >Very confusing and it can upset your pears, neighbors, and friends of you >choose the wrong one. > >You can tell that she is not solid in her choice and committed by >the unique, colorful, and subliminal signature? She is screaming for >guidance and understanding. I offer to her that she support the BRONCO'S >and >I will have my daughter-in-law ( devout BRONCO fan) get with her and >tailgate party to relieve the stress. > > ROR mª¿ªm > > > > -- >Please see the official ORACLE-L FAQ: http://www.orafaq.com ><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). > _ 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: 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
RE: OT: football fan-hood
Title: RE: OT: football fan-hood Well, I'm trying to get her to like hockey...that's a good hobby, right? Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 10:43 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood Jim, for the life of me, I can't see the issue here. sounds like your wife needs a hobby. -Original Message-----From: HAWKINS, JAMES W [IT/1000] [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 11:01 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch "The Greatest Show on Earth" beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 8:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: football fan-hood I thought that she was s overwhelmed by the choices available that she decided to be an "outsider" and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- 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: OT: football fan-hood
Title: RE: OT: football fan-hood Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch "The Greatest Show on Earth" beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 8:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: football fan-hood I thought that she was s overwhelmed by the choices available that she decided to be an "outsider" and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- 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: but will it run windows?
poor Unix geeks that use unix to provide for our everyday's bread > and Dom Perignon. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 stop a killed session bothering me ?
If you did a "shutdown abort", wouldn't you still have to wait for the rollback to happen during instance recovery on the startup? I've never tried this - I usually just suffer through the rollback. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 07, 2001 8:21 AM To: Multiple recipients of list ORACLE-L You should wait for PMON ending its job of rollback the transaction of that killed session. Since one of the releases of 8i that duty is a new one for the SMON. You have few options. If you are in a hurry, you could do shutdown abort. First issue an alter system checkpoint; just in case a maybe possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear all ! > I have killed a session while it was populating a > big table. > Now the session is marked KILLED in v$session. > It's serial# is keeping being incremented , so i > assume that a rollback (of > rows inserted into that big table by that session) > is going on there in the > background. > This rollback runs for several hours already > preventing me from DMLing that > big table. > Is there a way to stop that rollback / drop / > truncate that table ? > Thanks a lot in advance . > Andrey. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: computer history stories - Now: Age discrimination?
ttp://www.orafaq.com > > > -- > > > Author: Kevin Kostyszyn > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > ---------------- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > > name of mailing list you want to be removed from). You may also > > > send the HELP command for other information (like subscribing). > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Ruth Gramolini > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > >message BODY, include a line containing: UNSUB ORACLE-L (or the name of > >mailing list you want to be removed from). You may also send the HELP > >command for other information (like subscribing). > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Christopher Spence > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > >message BODY, include a line containing: UNSUB ORACLE-L (or the name of > >mailing list you want to be removed from). You may also send the HELP > >command for other information (like subscribing). > > >_ >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: Rachel Carmichael > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the >message BODY, include a line containing: UNSUB ORACLE-L (or the name of >mailing list you want to be removed from). You may also send the HELP >command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Christopher Spence > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ 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: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- suggestions to ensure nerdiness in potential IT
I don't know if any of these guys played in the same movie or not, but I can guarantee you they all are within six degrees of Kevin Bacon... http://www.cs.virginia.edu/oracle/ i.e.: The Oracle says: Red Skelton has a Bacon number of 2. Red Skelton was in Fuller Brush Girl, The (1950) with Eddie Albert Eddie Albert was in Big Picture, The (1989) with Kevin Bacon __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Friday, August 03, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Actually, Davy Crockett was dead before the invention of TV. But he was played by Fess Parker in the TV movies with the same name. Having said that, I don't beleive that Fess Parker, Red Skelton and Danny Kaye ever together, but I have been know to be wrong before. Terry "Gogala, Mladen" wrote: > Have Bullwinkle,Davy Crockett, Red Skelton and Danny Kaye ever been in the > same movie > together? What about Rocky, he and Bullwinkle used to be inseparable. I > didn't know > that Bullwinkle was moonlighting with Danny Kaye and Skelton? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr
o: <[EMAIL PROTECTED]> Date sent: Sat, 28 Jul 2001 17:45:32 -0700 Dear IT Professional, The training division of Telecommand, Inc. is conducting a 1-Day rigorous hands-on class on Oracle8i database administration. The training will take place in the latest Sun Solaris 8 environment. You will be learning in a ultra small class of 12 students. Ravi Verma who has over 12 years of experience in Oracle database administration is teaching the course. At the end of the day you will be among the very best in the field of Oracle 8i Database administration. Please sign up at http://www.telecommand.com/training/ Following are the details: Date: Friday 09/07/2001 and Saturday 09/08/2001 Place: Computer Science Laboratory at the California State University, Sacramento Time: 9:30 AM to 5:00 PM Class Size: 12 Fee: $250.0 We can keep the cost low because we have no overheads!!! Telecommand, Inc. is CMAS certified for classroom training. Instructor: Ravi Verma Sign up: http://www.telecommand.com/training/ Course detail: This course will teach students the fundamental skills required to manage Oracle databases. Students will learn database administration skills by designing, setting up, configuring, and managing their own Oracle8i server. By the end of the class, each student will have gone through the main tasks necessary to manage Oracle8i databases. New Oracle8i features such as the Oracle8i JVM, locally-managed tablespaces, partitioned tables, global and local indexes, index-organized tables, function-based indexes, object-relational features, the large pool and the Java pool will be covered. Audience: Database administrators, application developers, and system administrators. Prerequisites: Oracle for Application Developers. Previous working experience with Oracle is recommended. A solid understanding of SQL and PL/SQL is required. A base understanding of the operating system used for class (UNIX or NT) is needed as well. ** ... --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
