FAQ

Search Discussions

653 discussions - 3,044 posts

  • As someone with 7 years in the HR (Compensation) field, and now in the IT/ERP field working on my Oracle DBA OCP, I can speak with some knowledge and experience. Using the term "Entry Level" on a ...
    Edward LockEdward Lock
    Jan 2, 2002 at 12:21 am
    Jan 8, 2002 at 4:07 am
  • The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I ...
    Craig MundayCraig Munday
    Jan 29, 2002 at 6:37 am
    Jan 31, 2002 at 4:03 pm
  • Anyone care to comment on the following, IMHO it's about time: --- Introducing two new levels of Oracle Certified Professional (OCP) Achievement A recent *IDC report on IT Education and Training ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Jan 10, 2002 at 2:39 pm
    Jan 14, 2002 at 3:12 pm
  • 32

    OPS$

    Does anyone have any information on security problems using the OPS$ account? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: rlsmith_at_kmg.com Fat ...
    Smith, Ron L.Smith, Ron L.
    Jan 30, 2002 at 6:58 pm
    Jan 31, 2002 at 6:53 pm
  • Hi, I was reading in the book "Oracle 24/7 Tips and Techniques" about Standby Instances. Note, this is not a standby database. There is only one database. The database files exist on a shared disk ...
    James McCannJames McCann
    Jan 17, 2002 at 1:08 pm
    Jan 20, 2002 at 11:31 pm
  • Hi List, I have a white paper for Backup Strategy on Microsoft NT but I am looking for Backup Strategy for Oracle8i on Solaris, If anybody have any doc or link I realy appreciate. Hamid Alavi Office ...
    Hamid AlaviHamid Alavi
    Jan 17, 2002 at 5:55 pm
    Jan 25, 2002 at 9:09 pm
  • Can anyone provide some criteria of what you look for when a data model is handed off from production? We are starting a large development project and I lobbied management to hire a data architect ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Jan 4, 2002 at 8:24 pm
    Jan 8, 2002 at 2:07 pm
  • How does one stop access to prod instance by any product other than supplied homegrown Forms application? I mean no sqlplus, toad, tora and similar tools and their renamed derivatives?? All this ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jan 4, 2002 at 3:20 pm
    Jan 8, 2002 at 3:47 pm
  • Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard ...
    Babich , SergeyBabich , Sergey
    Jan 18, 2002 at 7:38 pm
    Jan 22, 2002 at 5:47 pm
  • Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone suggest me some very good book on Oracle Tunning worth purchasing Binay Kumar Oracle ...
    BINAY.KUMAR_at_ponl.comBINAY.KUMAR_at_ponl.com
    Jan 30, 2002 at 10:35 am
    Jan 31, 2002 at 7:09 pm
  • Hi, Henry, Please, post it. I am terribly sorry for asking dumb questions, but hey! I've come a long way to be a part of this country, learned the language, become a DBA and proud of it! Time to ...
    Babich , SergeyBabich , Sergey
    Jan 23, 2002 at 7:03 pm
    Jan 31, 2002 at 3:25 pm
  • Good morning everyone, Can anyone give me the command to analyze a partitioned tabled? To analyze this table unpartitioned I use: analyze table schema.table_name compute statistics; I am partitioning ...
    Ruth GramoliniRuth Gramolini
    Jan 3, 2002 at 2:14 pm
    Jan 29, 2002 at 2:13 am
  • Hi, A user in our data warehousing group is running into the old ORA-01555 (snapshot too old) error every time she runs a massive (20 million rows) select against one table via a view. I confirmed ...
    Walter KWalter K
    Jan 25, 2002 at 4:28 pm
    Jan 28, 2002 at 4:07 am
  • I just joined a new Oracle/Java project using Tomcat app server. On this project they decided to create an update procedure and insert procedure for every table. This procedure is then called in the ...
    Grabowy, ChrisGrabowy, Chris
    Jan 14, 2002 at 3:58 pm
    Jan 16, 2002 at 5:47 am
  • Hi there - I'm trying to convince a client that multiple extents for a table will not hurt their performance. It's a PeopleSoft app, and PeopleSoft is telling them that they need to reorg any object ...
    Cunningham, GeraldCunningham, Gerald
    Jan 17, 2002 at 10:34 pm
    Jan 25, 2002 at 4:48 am
  • Hi Folks, Wonder if anyone would like to comment, my MSSQL DBA sent me a couple of emails from a MSSQL mailing list, they were discussing the future of MSSQL. Some of the comments included comments ...
    Denham EvaDenham Eva
    Jan 8, 2002 at 2:55 pm
    Jan 9, 2002 at 3:54 pm
  • We are seeing a lot of shared pool waits (for libary cache pin) on our 8.1.5 web-based application. We are seeing this via Precise/Indepth SQL monitoring tool. I haven't been able to find much ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Jan 2, 2002 at 8:40 pm
    Jan 7, 2002 at 3:17 pm
  • Hi, Assume INITIAL * MINEXTENT = 2M and also = OPTIMAL Do you think ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M; will work ? Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com ...
    Sinard XingSinard Xing
    Jan 30, 2002 at 7:09 am
    Jan 31, 2002 at 1:23 pm
  • Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ... I have been asked a simple question, and I am stumped ... Given a set of users, how to calculate the load they are putting on the system ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jan 16, 2002 at 8:43 pm
    Jan 22, 2002 at 6:53 pm
  • http://www.fixedsys.com/context/ (yes, Virginia, it's oracle-related....read the site...!) Apologies to the OFF TOPIC list for this ON topic crap! Ross "Data bin Loaden" Mohan -- Please see the ...
    Mohan, RossMohan, Ross
    Jan 8, 2002 at 6:58 pm
    Jan 11, 2002 at 1:27 am
  • When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual ...
    Thomas, KevinThomas, Kevin
    Jan 29, 2002 at 8:58 am
    Jan 29, 2002 at 9:44 pm
  • The one I have heard is Scott being the main developer way back when.. and Tiger was the name of his pet cat.. -----Original Message----- Sent: 23 January 2002 16:45 To: Multiple recipients of list ...
    Mark LeithMark Leith
    Jan 23, 2002 at 6:36 pm
    Jan 24, 2002 at 11:26 pm
  • Hello, I am looking for any pointers to white papers, etc. that discuss the differences/similarities among WAFL, SAME and RAID (shake, rattle and roll? - sorry) file systems. We have some systems ...
    Bill BeckerBill Becker
    Jan 15, 2002 at 4:58 pm
    Jan 20, 2002 at 10:00 am
  • Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating ...
    Relika ShettyRelika Shetty
    Jan 14, 2002 at 1:02 pm
    Jan 15, 2002 at 7:25 pm
  • Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data located at "hardy".(which is a computer) to the other database hakon ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Jan 9, 2002 at 7:42 am
    Jan 29, 2002 at 2:49 pm
  • We are in the process of setting up a SAN using RAID 0+1 for our database. In our current environment, we are able to separate our tables, indexes, rollback segments, and archive logs on different ...
    Jon BehnkeJon Behnke
    Jan 14, 2002 at 9:13 pm
    Jan 22, 2002 at 1:37 am
  • Hi All, Currently I am the only DBA for the 15 productin databases in our company. I have written shell scripts on all database servers to parse the alert.log file and look for Oracle errors and send ...
    Dmeng_at_focal.comDmeng_at_focal.com
    Jan 7, 2002 at 7:11 pm
    Jan 12, 2002 at 8:31 pm
  • Hello list, I new to clone a database for changing between test to production. The new database is going to be in a different host. I have the copy obtained through the enterprise manager (I suppose ...
    Beatriz Martínez JiménezBeatriz Martínez Jiménez
    Jan 9, 2002 at 10:08 am
    Jan 10, 2002 at 1:01 pm
  • ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file. Is there such a thing in the windoze world. a registry entry maybe? thanks, joe
    JOE TESTAJOE TESTA
    Jan 2, 2002 at 2:35 pm
    Jan 2, 2002 at 9:20 pm
  • Hi, We are evaluating databases to our web site and the candidates are Oracle and MS. We already have Oracle running on our production environments, but, mainly a cost-based decision, management ...
    Antonio.belloni_at_hstern.com.brAntonio.belloni_at_hstern.com.br
    Jan 25, 2002 at 11:10 am
    Jan 28, 2002 at 5:50 pm
  • How much referential integrity should be implemented in Oracle? We are starting a large new Java project. Our current applications keep their referential integrity inside their own dictionary, so I ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Jan 21, 2002 at 10:01 pm
    Jan 22, 2002 at 6:48 pm
  • Hi I deleted millions of rows from diffrent tables and I have not seen any impact on database size.What I have to do to get that free space? Is it necessary to shutdown the database? Thx -Seema MSN ...
    Seema SinghSeema Singh
    Jan 17, 2002 at 9:13 pm
    Jan 20, 2002 at 3:42 pm
  • We have done some preliminary testing and found prepared statements about 20% faster than stored procedures. We inserted 200,000 records at a time (28-50 columns in a table ) using stored procedures ...
    Rakesh GuptaRakesh Gupta
    Jan 15, 2002 at 4:17 pm
    Jan 16, 2002 at 8:43 pm
  • Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ...
    Lhoska_at_calibresys.comLhoska_at_calibresys.com
    Jan 28, 2002 at 10:32 pm
    Jan 29, 2002 at 5:09 pm
  • Hallo, why do I get the error message "No such file or directory". when I try to run unix script loadfiles.sh which is located in the directory /konto/tmp. This file, loadfiles.sh really exists in ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Jan 11, 2002 at 12:45 pm
    Jan 28, 2002 at 4:50 pm
  • Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join ...
    Kempf, ReedKempf, Reed
    Jan 16, 2002 at 5:30 pm
    Jan 16, 2002 at 11:58 pm
  • hi SQL wizards, Can any body help me with the tjis SQL. I need a SQL records with top 100 values of a table ( not rownum < 101 ). Thanks Deen -- Please see the official ORACLE-L FAQ ...
    Deen DayalDeen Dayal
    Jan 10, 2002 at 4:18 pm
    Jan 10, 2002 at 7:43 pm
  • Okay, I don't have the manuals with me and can't for the life of me remember the correct syntax to do this... Is it: shutdown database startup no noumt (or startup mount) alter tablesapce evisions ...
    Joe LaCascioJoe LaCascio
    Jan 31, 2002 at 1:26 am
    Jan 31, 2002 at 6:57 pm
  • Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with ...
    SRAJENDRAN_at_nlfs.comSRAJENDRAN_at_nlfs.com
    Jan 29, 2002 at 3:48 pm
    Jan 29, 2002 at 9:56 pm
  • Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Jan 21, 2002 at 3:25 pm
    Jan 21, 2002 at 8:23 pm
  • We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data ...
    O'Neill, SeanO'Neill, Sean
    Jan 10, 2002 at 12:30 pm
    Jan 12, 2002 at 2:17 am
  • Hi all, I just tried to install Oracle 9i personal edition for Win98 on my Win98 PC. After quite a bit of installation, it got to a part where it was creating some database or something, and I got an ...
    JoJo Al-ZawawiJoJo Al-Zawawi
    Jan 12, 2002 at 2:54 am
    Jan 13, 2002 at 6:17 pm
  • I am having a problem setting up a user on my DB (W2000 / 8.1.7). I have my self as user KENNETH and the new user is KIMV. She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus ...
    Ken JanuszKen Janusz
    Jan 2, 2002 at 9:38 pm
    Jan 3, 2002 at 11:11 pm
  • Dear list ! I'm reposting this, since got no replies yet. I need to design a backup policy for a VLDB sized some 10TB, running as close to 24X7 as possible. I need 2 versions of the policy: One is ...
    Andrey BronfinAndrey Bronfin
    Jan 2, 2002 at 3:07 pm
    Jan 2, 2002 at 9:33 pm
  • Seems to be down this morning .... must be the flu ... 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 ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jan 30, 2002 at 1:41 pm
    Jan 30, 2002 at 7:18 pm
  • TNX for your answers. What I need is exactly what Oracle doesn't support. Logging "who" changed "what" in a special area of our database. I think triggering the events will be much more specific and ...
    Foelz.FrankFoelz.Frank
    Jan 29, 2002 at 7:11 am
    Jan 30, 2002 at 4:57 pm
  • Okay ... does anyone know what are Microsoft's own inventions? Raj Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jan 29, 2002 at 6:51 pm
    Jan 30, 2002 at 2:05 pm
  • I was wondering if anyone could offer any suggestions to this issue, or the pro's and con's... We are trying to shorten the time frame that it takes to complete our Oracle hot backups, and the ...
    Traci.l.rebman_at_rrd.comTraci.l.rebman_at_rrd.com
    Jan 26, 2002 at 3:52 pm
    Jan 29, 2002 at 4:31 pm
  • Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, & I love it. VERY stable, easy to use, although I don't do the admin ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Jan 18, 2002 at 10:45 pm
    Jan 22, 2002 at 2:06 pm
  • Dear All, Does Oracle confirm to all 12 Codde's Rules. Can anyone point out the Rules violated by each version (6/7/8/9) of Oracle. Thanks, Vikas Chat with friends online, try MSN Messenger ...
    Vikas SVikas S
    Jan 18, 2002 at 11:02 am
    Jan 21, 2002 at 2:34 pm
Group Navigation
period‹ prev | Jan 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions653
posts3,044
users415
websiteoracle.com

415 users for January 2002

Rachel Carmichael: 142 posts Jared.Still_at_radisys.com: 120 posts Kimberly Smith: 84 posts ��� �����: 69 posts Deshpande, Kirti: 66 posts Mohan, Ross: 59 posts Boivin, Patrice J: 52 posts DENNIS WILLIAMS: 52 posts Jared Still: 50 posts Jamadagni, Rajendra: 46 posts Dgoulet_at_vicr.com: 44 posts Orantdba: 43 posts Roland.Skoldblom_at_ica.se: 39 posts Ron Rogers: 37 posts Stephane Faroult: 37 posts Babich , Sergey: 36 posts Igor Neyman: 33 posts Mercadante, Thomas F: 31 posts Johnston, Tim: 30 posts nlzanen1_at_EY.NL: 30 posts
show more
Archives