FAQ

Search Discussions

865 discussions - 3,421 posts

  • Hi all, I have taken an offer from a company in Europe to work in Saudi Arabia for 2 years. But I must learn the living conditions there. Ýf there is an Arabian here, can you answer these.. 1) How ...
    Bunyamin K. KaradenizBunyamin K. Karadeniz
    May 16, 2001 at 1:01 pm
    May 22, 2001 at 1:08 pm
  • List, I have created a test server using Linux 7.1 and Oracle 8.1.7.3 and it works great. The major problem I am having is "I am NOT a typist" and make errors at the SQL prompt. What do I set or ...
    Ron RogersRon Rogers
    May 25, 2001 at 4:15 pm
    May 31, 2001 at 2:39 pm
  • FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - lastnameinitial_at_logica.com eg SMITHK_at_logica.com. Emails ...
    Hallas, JohnHallas, John
    May 4, 2001 at 10:08 am
    May 9, 2001 at 6:09 pm
  • Hello Does anybody know what the following ora 600 relates to, ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Wed May 2 20:51:16 2001 Errors in file ...
    Zabair ahmedZabair ahmed
    May 3, 2001 at 9:21 am
    May 31, 2001 at 8:40 pm
  • List, My company is considering Quest - Shareplex. We are considering to use this in our dataware house. Basically, this will pull all the transactions from OLTP database and populate staging area in ...
    Rao, MaheswaraRao, Maheswara
    May 29, 2001 at 4:18 pm
    May 31, 2001 at 1:54 pm
  • i was trying to get commands from listguru and obviously typed the wrong address ...and no Mr. Hutchins, an idiot would be the jerk who sends that type of misanthropic respone to an obvious error.
    LandoLando
    May 7, 2001 at 7:44 pm
    May 8, 2001 at 7:30 pm
  • HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=8450000 . We have adjusted the rollback segment to ...
    Azhar_at_mathtech-pk.comAzhar_at_mathtech-pk.com
    May 30, 2001 at 9:49 am
    May 31, 2001 at 10:53 am
  • i hope this thread is still alive.... and my reply makes it to the list... by removing Steve from the list, we all will miss the insight into oracle internals, which he provided, thru his answers and ...
    RahulRahul
    May 25, 2001 at 4:46 am
    May 25, 2001 at 9:55 pm
  • Hi Which book is good for oracle tuning(8i)? Thanks -Seema Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author ...
    Seema SinghSeema Singh
    May 7, 2001 at 9:09 pm
    May 9, 2001 at 5:26 pm
  • All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee The information contained in this communication is confidential, is intended only ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    May 30, 2001 at 10:37 am
    May 31, 2001 at 1:22 pm
  • Just thought I'd share what I learned today with everyone. This is Oracle 8.1.7 on a VA Linux 4450, Linux Red Hat 6.2. I'm migrating customers from MySQL to Oracle, using Sqlloader to load the data ...
    Weaver, WaltWeaver, Walt
    May 7, 2001 at 11:37 pm
    May 10, 2001 at 9:10 pm
  • All, Anyone heard of this utility for Oracle ?. Someone mentioned it today and I didn't have a clue. They said it would be in $ORACLE_HOME/bin. Nothing there !! Regards Lee The information contained ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    May 21, 2001 at 4:07 pm
    May 22, 2001 at 10:44 pm
  • Another spiky one. Situation is this: V8.0.6.0, HP/UX 11, Peoplesoft Financials 7.52(heck, does it sound like I'm involved with this mob? ) Block size in DB was 16K. Totally inappropriate for the ...
    Nuno SoutoNuno Souto
    May 9, 2001 at 2:59 pm
    May 10, 2001 at 7:50 pm
  • Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg ...
    Greg MooreGreg Moore
    May 31, 2001 at 2:03 am
    May 31, 2001 at 10:55 pm
  • "If you live to be a hundred, I want to live to be a hundred minus one day,so I never have to live without you. -- Winnie the Pooh" Dear me, Bill, where on earth did you get that from? I think I can ...
    Campbell, JamesCampbell, James
    May 25, 2001 at 12:11 am
    May 25, 2001 at 8:49 pm
  • Hi, After reading Steve Adams' tip on making temp files quick io. I posed this question to Veritas as they had told us not do so. The answer they give is the following. Temporary datafiles should not ...
    Johnson PoovathummoottilJohnson Poovathummoottil
    May 17, 2001 at 12:56 pm
    May 18, 2001 at 5:53 pm
  • what is the ls command to view only a list of directories? ls -la lists both files and directories...I want to view only a list of directories... environment is sun sparc solaris 2.6 thanks in ...
    Roy FergusonRoy Ferguson
    May 1, 2001 at 9:08 pm
    May 3, 2001 at 12:30 am
  • Hi everybody! I have some questions about parallel server. Now we have only one instance "stand-alone" (no parallel), but we are thinking to switch to parallel server because we have a couple of ...
    Fernando PapaFernando Papa
    May 30, 2001 at 9:09 pm
    May 31, 2001 at 11:50 pm
  • ep, Any idiot can see we're the freest country in the world! Free to do what is expected, or get thrown in jail at a rate exceeding most other "civilized" nations. Free to subsidize tobacco and ...
    Mohan, RossMohan, Ross
    May 17, 2001 at 7:12 pm
    May 21, 2001 at 6:59 pm
  • Any scripts (sql or pl/sql) out there to compute various statistical things in Oracle? regards - john f. lewis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis ...
    John LewisJohn Lewis
    May 14, 2001 at 9:07 pm
    May 15, 2001 at 10:46 pm
  • Hi Is metalink available under 'bronze' support? How do u live 'with bugs' without metalink support? Thanks ------------- Original Message -------------- "Cale, Rick T (Richard)" wrote: To:Multiple ...
    Cyril ThankappanCyril Thankappan
    May 10, 2001 at 7:22 pm
    May 14, 2001 at 12:50 am
  • I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ...
    Smith, Ron L.Smith, Ron L.
    May 31, 2001 at 1:32 pm
    May 31, 2001 at 11:23 pm
  • Halo, Windoz 2000/SQL Server 2000 Bringing an axuliary MS SQL db online. Trying to setup "archiving". Am I reading documentation right, SQL does NOT automatically archive transaction log? This ...
    Gary WeberGary Weber
    May 30, 2001 at 5:58 pm
    May 31, 2001 at 8:56 pm
  • Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution ...
    Ahmadsyah Algozhi NugrohoAhmadsyah Algozhi Nugroho
    May 16, 2001 at 9:56 pm
    May 18, 2001 at 1:25 am
  • My boss just received a cold call from Oracle that he let me listen in on. They have a new push on for their i-dba support package. For just a little more money (they did not define little), "we will ...
    Bowes, ChrisBowes, Chris
    May 25, 2001 at 2:57 pm
    May 31, 2001 at 11:13 pm
  • For those of you that have implemented a standby database, what method do you use to rebuild your indexes tablespace. My plan was to create a new tablespace and rebuild the indexes into the new ...
    Richard HuntleyRichard Huntley
    May 31, 2001 at 1:45 pm
    May 31, 2001 at 9:53 pm
  • I have an Oracle 8.0.5 database residing on a Windows NT operating system which uses Raid5. The 'almost never' has happened; two disks have gone bad at the same time. As fate would have it the ...
    Burton, Laura L.Burton, Laura L.
    May 23, 2001 at 5:32 am
    May 24, 2001 at 7:28 am
  • A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores ...
    Haskins, EdHaskins, Ed
    May 15, 2001 at 5:52 pm
    May 17, 2001 at 7:14 pm
  • "Are you an idiot?";-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: MohanR_at_STARS-SMI.com Fat City Network Services -- (858) 538-5051 FAX: (858) ...
    Mohan, RossMohan, Ross
    May 8, 2001 at 4:56 pm
    May 8, 2001 at 9:43 pm
  • Hi, I am aware that 817 supports UTL_SMTP for this same functionality. But how can one send email from pl/sql in 806? thanx Vicky D. Foster, Senior Oracle DBA: email: acur8dba_at_yahoo.com
    Oracle DBAOracle DBA
    May 23, 2001 at 2:45 am
    May 31, 2001 at 7:45 pm
  • Does anyone know if it is 'safe' to add additional columns to user_tab_columns? I am running 8.1.5. I would use the new columns to tell the application software which columns on any one table are ...
    Greg SchraiberGreg Schraiber
    May 18, 2001 at 3:42 pm
    May 22, 2001 at 12:33 am
  • I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration ...
    Smith, Ron L.Smith, Ron L.
    May 16, 2001 at 6:49 pm
    May 17, 2001 at 3:21 pm
  • If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -----Original Message----- Sent: Tuesday, May 15, 2001 2:26 ...
    Cale, Rick T (Richard)Cale, Rick T (Richard)
    May 15, 2001 at 6:04 pm
    May 16, 2001 at 4:38 pm
  • I used to be of the same school of thought as you. But on Solaris 2.7 with Oracle v8.1.7 I have seen the various processes hang on to the old log for days if I "mv alertSID.log alertSID.log.old ...
    Brian MacLeanBrian MacLean
    May 14, 2001 at 11:17 pm
    May 16, 2001 at 3:00 pm
  • There is another thread going on about no database on a single server, I have another question to ask. We have nearly 30 databases across Sun and Win 2000 Platforms. We are finding it tedious to keep ...
    Johnson PoovathummoottilJohnson Poovathummoottil
    May 11, 2001 at 4:31 pm
    May 14, 2001 at 3:45 pm
  • Hi All, Here is my environment; NT v4 Db Oracle Workgroup v8.1.6 Rollback Segments SEGMENT_NAME OWNER TABLESPACE_NAME ------------------------------ ------ ------------------------------ SYSTEM SYS ...
    Nixon_Villanueva_at_manulife.comNixon_Villanueva_at_manulife.com
    May 9, 2001 at 8:25 am
    May 11, 2001 at 11:12 pm
  • As this seems urgent and it is still daytime the Pacific timezone, I can offer some limited advice. In order of importance they would be ... 1. Recovery of the database. 2. Slow shutdown. 3. SQL ...
    Glen MitchellGlen Mitchell
    May 2, 2001 at 5:17 am
    May 4, 2001 at 5:20 am
  • Another example, to illustrate. Those of you who have kids may identify with this one. Twenty or thirty years ago you could have asked a 5 year old to play the word-association game too: "McDonald's" ...
    Boivin, Patrice JBoivin, Patrice J
    May 1, 2001 at 2:08 pm
    May 2, 2001 at 12:14 pm
  • All, I have recently ran an analysis on a table and when calculating the table size using num_rows*avg_row_len this came out at about 420Mb. Nothing strange about that, however the amount of space ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    May 10, 2001 at 3:38 pm
    May 16, 2001 at 7:08 am
  • Hi List, As a regular maintainance work,I have moved the listener.log file to listener.log.old and 'touch'ed the listener.log, expecting the logging into this new file. But I am observing the logging ...
    Tirumala, SurendraTirumala, Surendra
    May 24, 2001 at 2:51 pm
    May 29, 2001 at 2:43 pm
  • Disclaimer: I have no affiliation with LazyDba or the owner of the LazyDba mailing list, and have not subscribed to that list. My personal opinion, for what it's worth: I don't think that this list ...
    Jacques KilchoerJacques Kilchoer
    May 25, 2001 at 4:38 pm
    May 26, 2001 at 1:06 am
  • Hi, I wish to test Parallel Query . HP-UX 10.2 K Class machines, 4 CPU 2 GB RAM, Oracle 7.3.4.4 When the background processes are created, Can I bind ( a slave process related to Parallel query ...
    Shreepad VaidyaShreepad Vaidya
    May 22, 2001 at 11:22 am
    May 23, 2001 at 7:20 pm
  • Can anyone tell me what the syntax is to start, stop, or reload the listener when there is a password on it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L ...
    Smith, Ron L.Smith, Ron L.
    May 9, 2001 at 9:49 pm
    May 16, 2001 at 1:02 pm
  • Hello, I'm having difficulty coding this loop and am hoping someone can see how this can be done. I have two tables, one on each instance reg.docalert_responses_at_ncp and ...
    Hagedorn, LindaHagedorn, Linda
    May 8, 2001 at 5:44 pm
    May 11, 2001 at 8:02 am
  • So, I need to re-create a database to prepare for migration. The current DB is 8.0.6, and I need to create an 8.1.7 copy. Does anyone have a script to reverse engineer the CREATE TABLESPACE commands? ...
    Jesse, RichJesse, Rich
    May 23, 2001 at 6:27 pm
    May 24, 2001 at 4:05 pm
  • Jacques, I am not sure, but are you running out of semaphores? (possible as your default limit may be too low for the 8 databases you serve). Look at /etc/system together with the UIG - add us all ...
    John KanagarajJohn Kanagaraj
    May 22, 2001 at 6:57 pm
    May 23, 2001 at 10:29 pm
  • DDOS Attacks On The Rise Whitehouse.gov was laid low by distributed-denial-of-service attacks over the weekend. The FBI's National Infrastructure Protection Center issued a warning Saturday stating ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    May 8, 2001 at 2:35 pm
    May 10, 2001 at 10:07 am
  • Here is Linus's response .... http://web.siliconvalley.com/content/sv/2001/05/03/opinion/dgillmor/weblog/t orvalds.htm a good read ... Raj Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ...
    Jamadagni, RajendraJamadagni, Rajendra
    May 4, 2001 at 6:29 pm
    May 7, 2001 at 5:44 pm
  • Hi Rukmini could tell me what's that hash-join GSK "Rukmini Devi" To: Multiple recipients of list ORACLE-L rain.com cc: Sent by: Subject: Re: 4 join methods? root_at_fatcity. com 31-05-01 09:55 AM ...
    Senthil GanapathiSenthil Ganapathi
    May 31, 2001 at 8:38 am
    May 31, 2001 at 7:37 pm
  • We have un-ordered data in a table that needs to be inserted into a transaction table in order of the date that the transaction took place. Oracle does not allow "INSERT ..... AS SELECT ..... ORDER ...
    Browett, DarrenBrowett, Darren
    May 25, 2001 at 9:58 pm
    May 30, 2001 at 5:54 pm
Group Navigation
period‹ prev | May 2001 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions865
posts3,421
users484
websiteoracle.com

484 users for May 2001

Jared Still: 165 posts Mohan, Ross: 123 posts Dgoulet_at_vicr.com: 107 posts Rachel Carmichael: 106 posts Christopher Spence: 103 posts Eric D. Pierce: 99 posts Kevin Kostyszyn: 66 posts Boivin, Patrice J: 64 posts Thater, William: 62 posts Jacques Kilchoer: 50 posts A. Bardeen: 45 posts Hillman, Alex: 45 posts Diana_Duncan_at_ttpartners.com: 40 posts Connor McDonald: 38 posts Robertson Lee - lerobe: 37 posts Ron Rogers: 35 posts Scott.Shafer_at_dcpds.cpms.osd.mil: 35 posts Tim Sawmiller: 32 posts Deshpande, Kirti: 31 posts Steve Adams: 30 posts
show more
Archives