FAQ

Oracle > oracle-l > September 2001

Search Discussions

692 discussions - 2,990 posts

  • The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have ...
    Boivin, Patrice JBoivin, Patrice J
    Sep 11, 2001 at 2:09 pm
    Sep 13, 2001 at 12:34 pm
  • One of our datafiles is about to reach it's maxsize. Is the only way around this to do an alter tablespace add datafile? Can the database be up and running for this? After I create the new datafile ...
    Sujatha MadanSujatha Madan
    Sep 6, 2001 at 1:30 am
    Sep 7, 2001 at 1:18 pm
  • Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server ...
    Smith, Ron L.Smith, Ron L.
    Sep 25, 2001 at 1:26 pm
    Sep 26, 2001 at 11:55 pm
  • Thought this would interest you guys.. http://www.theitportal.com/ITPFrameSetBottom.asp?Path=http%3A%2F%2Fwww%2Emac world%2Eco%2Euk%2Fnews%2Fmain%5Fnews%2Ecfm%3FNewsID%3D3442&Domain=www.macwor ...
    Mark LeithMark Leith
    Sep 4, 2001 at 12:53 pm
    Sep 11, 2001 at 10:58 pm
  • been to a place (Oracle install) where all power was shutdown each night at midnight in the entire building. talk about having a short backup window ... also, I wonder - if a mouse, hamster or other ...
    Paul DrakePaul Drake
    Sep 1, 2001 at 12:38 am
    Sep 5, 2001 at 1:10 pm
  • I'd say this deal represents the final nail in the coffin of what was once DEC. HP-UX will supersede Tru64, VMS (Alpha VMS; it hasn't been VAX/VMS for a long time) will slowly fade away (it will take ...
    Paul BaumgartelPaul Baumgartel
    Sep 4, 2001 at 5:45 pm
    Sep 12, 2001 at 1:26 pm
  • I've been presented with an opportunity to justify requirements for a 2nd DBA at our site. As I see it there are an number of paths this presents: 1 - Justify and get a 2nd DBA. Pro's: Gives me more ...
    O'Neill, SeanO'Neill, Sean
    Sep 20, 2001 at 3:33 pm
    Sep 24, 2001 at 11:21 am
  • Hi list, hope you guys can help us decide this issue. We are a shop that 's currently running 2 MS SQL7 servers 2 MS 2k Servers 6 Sybase 12.1.1 ASE servers and 5 Oracle 8.1.7.1 servers The MS servers ...
    Bryan, MiriamBryan, Miriam
    Sep 24, 2001 at 6:39 pm
    Sep 26, 2001 at 6:37 pm
  • What is the purpose of having a dba if he is not allowed to do anything? "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and ...
    Christopher SpenceChristopher Spence
    Sep 5, 2001 at 12:30 pm
    Sep 10, 2001 at 3:22 pm
  • List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits ...
    Mark LeithMark Leith
    Sep 11, 2001 at 2:17 pm
    Sep 13, 2001 at 4:02 am
  • I have a question about how the export/import utility works. My situation is that damagement had me put my live and test environments on the same server. Now they realize that this is not a good ...
    Farnsworth, DaveFarnsworth, Dave
    Sep 4, 2001 at 6:57 pm
    Sep 6, 2001 at 1:35 am
  • We have tablespaces in acceptance and production that are being resized for growth. Pctincrease is set at 0. Would it also help to coalesce the tablespace? What are the benefits of this command? ...
    Sandi.McClary_at_flyingj.comSandi.McClary_at_flyingj.com
    Sep 20, 2001 at 6:30 pm
    Sep 26, 2001 at 12:24 pm
  • I am confused by the output from tkprof below. An fast full index scan is being performed. However, from the statistics, it looks as thought 649 physical disk reads are being performed. Is that ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Sep 6, 2001 at 7:42 pm
    Sep 11, 2001 at 4:07 pm
  • !! Please do not post Off Topic to this List !! I am planning setting up a new database with the redo logs on RAID 1 array (mirror). The amount of space available on the array is 16Gb and only the ...
    Bill BuchanBill Buchan
    Sep 14, 2001 at 12:21 pm
    Sep 19, 2001 at 1:20 pm
  • hi everyone can anybody help me with a script that recreates user definitions and the granted roles ? thanks g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com ...
    GKor_at_rdw.nlGKor_at_rdw.nl
    Sep 10, 2001 at 8:40 am
    Sep 15, 2001 at 7:10 am
  • List, OLTP application with 24x7 requirement. 300,000 records per day are inserted into the transaction table. Environment: Solari 7. Oracle 817. The transaction table layout. Security ID Account ID ...
    Rao, MaheswaraRao, Maheswara
    Sep 21, 2001 at 3:23 pm
    Sep 25, 2001 at 2:26 am
  • Guru's In my test oracle server, i created two different database with SID 'orclsvr' and 'ora817'. Is't possisle to create two oracle database instances on the same server?. Presently am able to ...
    Nirmal Kumar Muthu KumaranNirmal Kumar Muthu Kumaran
    Sep 19, 2001 at 6:50 am
    Sep 20, 2001 at 6:02 pm
  • We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that do not have a 24x7 restriction. Now, management is looking to bring in new products that will need to be 24X7. They are ...
    Tracy RahmlowTracy Rahmlow
    Sep 17, 2001 at 2:12 pm
    Sep 19, 2001 at 11:04 am
  • !! Please do not post Off Topic to this List !! Hi All, Does anybody here on the list have experience with EMC/symmetrix storage units.? We have our databases on this machine and I have a feeling the ...
    nlzanen1_at_EY.NLnlzanen1_at_EY.NL
    Sep 13, 2001 at 10:57 am
    Sep 14, 2001 at 7:48 pm
  • -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: Arich_at_valleycare.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, ...
    Arich HennemanArich Henneman
    Sep 5, 2001 at 11:58 pm
    Sep 6, 2001 at 3:55 pm
  • I am wondering how my fellow DBA's fit into their IS organization. My situation is this. I was hired just a little over a year ago as a DBA but my official title is network programmer. Except for ...
    Farnsworth, DaveFarnsworth, Dave
    Sep 15, 2001 at 11:00 am
    Sep 18, 2001 at 8:03 pm
  • I try to create a database link named Custom, it ends up as: Custom.us.oracle.com when I query the dba_db_links table. I don't want the .us.oracle.com extension. What can I do, where does this ...
    Kathy DuretKathy Duret
    Sep 22, 2001 at 5:44 am
    Sep 26, 2001 at 4:14 pm
  • Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to ...
    Barry DeeveyBarry Deevey
    Sep 18, 2001 at 4:11 pm
    Sep 20, 2001 at 9:02 am
  • Did anyone see this? 2 small jets crashed into World Trade Center in NY shortly before 9am. I feel horrible and sorry for all the people suffered. Raj Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot ...
    Jamadagni, RajendraJamadagni, Rajendra
    Sep 11, 2001 at 2:42 pm
    Sep 12, 2001 at 7:18 pm
  • Not for me .... SQL select 62.323/62.323 from dual; 62.323/62.323 1 SQL exit Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option JServer Release ...
    Jamadagni, RajendraJamadagni, Rajendra
    Sep 25, 2001 at 3:05 pm
    Sep 26, 2001 at 6:18 pm
  • !! Please do not post Off Topic to this List !!Hi List, did anybody notice that sometimes CBO ignores USE_NL hint without ORDERED The following example was taken from oracle docs: SQL SQL SQL select ...
    Shevtsov, EduardShevtsov, Eduard
    Sep 13, 2001 at 11:38 am
    Sep 17, 2001 at 10:46 am
  • I give anyone respect who can do it and doesn't mind. I do about 77 miles round trip everyday to the office and the commute is starting to reaeeeellly annoy me!! Of course, I have to share the road ...
    Kevin KostyszynKevin Kostyszyn
    Sep 1, 2001 at 12:11 am
    Sep 4, 2001 at 9:50 pm
  • select add_months(sysdate, -1) from dual; HTH Raj Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN ...
    Jamadagni, RajendraJamadagni, Rajendra
    Sep 17, 2001 at 3:55 pm
    Sep 18, 2001 at 6:22 am
  • SET ORACLE-L DIGEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Urban.Svanberg_at_astrazeneca.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 ...
    Urban.Svanberg_at_astrazeneca.comUrban.Svanberg_at_astrazeneca.com
    Sep 6, 2001 at 12:54 pm
    Sep 24, 2001 at 8:57 am
  • Let's assume that SQL statement was parsed by user X. If this or another user reexecute this same statement what are the conditions that this SQL statement will be reparsed? Let's assume that ...
    Hillman, AlexHillman, Alex
    Sep 6, 2001 at 7:31 pm
    Sep 23, 2001 at 1:44 pm
  • !! Please do not post Off Topic to this List !! Hello DBAs I have a tablespace, who has 10 datafiles of 200MB each, it was here before I even joined. I was thinking for the contention and want to ...
    KishoreKishore
    Sep 13, 2001 at 11:31 pm
    Sep 14, 2001 at 11:31 pm
  • Hi Listers Just wanted to express it. Sad about the bombings.. Sadder about people rushing to defend it. Sadder about people rushing to own it! Hope you are all safe. Regards Just another Human -- ...
    Cyril ThankappanCyril Thankappan
    Sep 12, 2001 at 9:32 am
    Sep 13, 2001 at 7:57 pm
  • to you all: someone once said "those who hate war the most are those best trained in it's use". trust me, you DON'T want to fight in a war. you may end up doing just that, but you don't want to. i ...
    Thater, WilliamThater, William
    Sep 11, 2001 at 4:25 pm
    Sep 12, 2001 at 6:15 pm
  • I would like to know your opinion about the developments under for example perl for handling large amounts of datas (sets of flats files larger than 50 gigs) vs the option of using oracle for exmaple ...
    AgcAgc
    Sep 9, 2001 at 6:34 pm
    Sep 10, 2001 at 10:06 pm
  • Does anyone know how to change the message that Oracle displays when an error occurs. For example: SQL select * from fjfjfjfjf; select * from fjfjfjfjf * ERROR at line 1: ORA-00942: table or view ...
    Terrian, TomTerrian, Tom
    Sep 6, 2001 at 7:41 pm
    Sep 7, 2001 at 10:08 pm
  • Hey, I'll bet you're from Missoula. : ) --Walt Weaver Bozeman, Montana -----Original Message----- Sent: Tuesday, September 04, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Harrisburg, PA ...
    Weaver, WaltWeaver, Walt
    Sep 5, 2001 at 1:35 pm
    Sep 7, 2001 at 2:52 pm
  • Back in 8.0 days, we were running into space problems for temp segments while rebuilding indexes on our large partitioned tables. Someone on this list suggested that we use the "wake SMON" approach, ...
    Bellefeuille, Wayne SBellefeuille, Wayne S
    Sep 20, 2001 at 5:58 pm
    Sep 26, 2001 at 11:14 pm
  • For those who have not heard, one of the towers, I believe the south one, has collapsed. I dare to say that someone else's skyline will be different in the next 48 hours as well. Guess the members of ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Sep 11, 2001 at 4:23 pm
    Sep 12, 2001 at 5:23 pm
  • Any suggestions what to check for in alert.log besides ORA- ? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET ...
    Hillman, AlexHillman, Alex
    Sep 5, 2001 at 2:41 pm
    Sep 6, 2001 at 2:34 pm
  • If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the "enable ...
    O'Neill, SeanO'Neill, Sean
    Sep 26, 2001 at 1:20 pm
    Sep 27, 2001 at 2:15 am
  • Thanks! It's this personality (or lack of) that has made me very sucessful at my age. I was driving a 45k dollar car (which you rode in) and owned my first house at age 23. Now at 26, I also own a ...
    Satar naghshinehSatar naghshineh
    Sep 21, 2001 at 6:58 pm
    Sep 26, 2001 at 1:45 am
  • I did a complete recovery of an Oracle instance. Everything looked great but when I bounced the instance and tried to bring it back up I got the following Oracle error. I have checked everything ...
    Smith, Ron L.Smith, Ron L.
    Sep 20, 2001 at 1:23 pm
    Sep 21, 2001 at 3:01 pm
  • !! Please do not post Off Topic to this List !! Cherie - We have been using the autoextend feature for 6 months now and have been really pleased with it. I am now studying the Oracle White Papers on ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Sep 13, 2001 at 8:08 pm
    Sep 14, 2001 at 5:26 pm
  • how to write a query to find top 3 customer based on their sales . eg. TABLE A customer sales A100 100 A101 200 A102 105 A103 109 A104 108 RESULTS should be.. A101 200 A103 109 A104 108 Thanks in ...
    Oracle DBAOracle DBA
    Sep 10, 2001 at 1:45 pm
    Sep 11, 2001 at 8:42 am
  • List, Has any one received un solicited emails from "SYMPHONY_at_acmemail.net" or "mary_4ra_at_excite.com" about business opportunities. I can't get the email to respond to the remove option at ...
    Ron RogersRon Rogers
    Sep 4, 2001 at 2:22 pm
    Sep 5, 2001 at 8:35 am
  • Just to add to my previous comment: I'm working at a company with small ( 40 or so ) IS shop. The weak do not survive in this environment. The developers I work with here are great. They're bright, ...
    Jared StillJared Still
    Sep 1, 2001 at 7:38 pm
    Sep 4, 2001 at 7:31 pm
  • Hi Folks, Need some backing up here! I have a MSSQL dba at my place of employment who enjoys emailing me with either Websites or reports that compare MSSQL and ORACLE, with MSSQL in a favouable light ...
    Denham EvaDenham Eva
    Sep 4, 2001 at 8:40 am
    Sep 4, 2001 at 5:52 pm
  • Hello, I am trying to log in the sqlplus (from command line) as the internal user but I can´t remember its password. Is there any way to change it? TIA
    Beatriz Martínez JiménezBeatriz Martínez Jiménez
    Sep 25, 2001 at 9:30 am
    Sep 25, 2001 at 4:39 pm
  • Friends : I tried to create a rollback segment in 9i and its said to me : CREATE PUBLIC ROLLBACK SEGMENT "RBS01" TABLESPACE "RBS" * ERROR at line 1: ORA-30019: Illegal rollback Segment operation in ...
    Eca EcaEca Eca
    Sep 21, 2001 at 12:44 am
    Sep 25, 2001 at 12:33 pm
  • I have a "what if" question. Say you had a complete cold backup, including control files from a few days ago. You also had all the archive logs for the past few days. Today you lost your server and ...
    Smith, Ron L.Smith, Ron L.
    Sep 21, 2001 at 4:09 pm
    Sep 24, 2001 at 3:12 pm
Sep 2001
12345…14
Group Navigation
period‹ prev | Sep 2001 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions692
posts2,990
users407
websiteoracle.com

407 users for September 2001

Christopher Spence: 158 posts Arich Henneman: 92 posts Rachel Carmichael: 72 posts Jared Still: 54 posts Dgoulet_at_vicr.com: 52 posts Mohan, Ross: 49 posts Thomas, Kevin: 44 posts Boivin, Patrice J: 40 posts Koivu, Lisa: 39 posts Mercadante, Thomas F: 39 posts Mark Leith: 34 posts JOE TESTA: 33 posts Jamadagni, Rajendra: 32 posts Kimberly Smith: 32 posts Nirmal Kumar Muthu Kumaran: 32 posts Christian Trassens: 31 posts Eric D. Pierce: 31 posts Ruth Gramolini: 31 posts Don Granaman: 30 posts Kevin Lange: 30 posts
show more
Archives