Search Discussions

829 discussions - 2,844 posts

  • Dear Esteemed List, Though I am very familiar with the technical aspects of Oracle, I don't know much about Oracle licensing. I have recently been asked by one of our staff to get more information on ...
    Nick MundiNick Mundi
    Mar 1, 2001 at 11:11 pm
    Mar 8, 2001 at 2:22 am
  • Guys, We r working on a Datawarehouse solution. Our Duhvelopers want to merge all code tables into a single table by adding a codetype column. with reference to this, i came across this article from ...
    Mandar GhosalkarMandar Ghosalkar
    Mar 22, 2001 at 12:34 am
    Mar 26, 2001 at 10:23 pm
  • LOL - great rant! I especially liked: And we especially like the "party" part - y'all do it so well! If anyone hasn't experienced it, do so if you get a chance: most of the Canadians I've met are ...
    Warthling, ChristyWarthling, Christy
    Mar 15, 2001 at 5:55 pm
    Mar 19, 2001 at 8:01 pm
  • Well, I think I can manage the grams to cups and c to f, but can someone translate "muscovado sugar" for me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter ...
    Regina HarterRegina Harter
    Mar 16, 2001 at 7:33 pm
    Mar 20, 2001 at 10:39 pm
  • one of my friends returning from America told that ORACLE is not much used in America. Is it True?? Bunyamin TIA
    Bunyamin K.KaradenizBunyamin K.Karadeniz
    Mar 12, 2001 at 5:34 pm
    Mar 15, 2001 at 5:48 pm
  • Dear list ! Incase if I've 2 databases with different set of data and I want to extract data from few tables in database 1 and data from few tables in database 2 and put the extracted data into 3rd ...
    Mar 13, 2001 at 9:27 am
    Mar 30, 2001 at 8:56 pm
  • Hi all: We have a situation where are no relationships are defined at the database level. i.e no foreign keys constraints have established at the Database. The application is still at the Development ...
    Ramani akhilRamani akhil
    Mar 19, 2001 at 7:21 pm
    Mar 21, 2001 at 6:52 pm
  • Mai, The only thing you have to do is to set your classpath correctly. That of course if you are installing thin drivers. If you are installing any other JDBC drivers (JDBC-OCI, etc., etc.) then you ...
    Mar 13, 2001 at 11:12 pm
    Mar 16, 2001 at 8:03 pm
  • Hi all! I'm in the processing of evaluating different Oracle Monitoring tools. Any suggestions? Thanks. Zhong It's another beautiful day! -----Original Message----- From: Ron Rogers Sent: Tuesday, ...
    Zhong HongZhong Hong
    Mar 13, 2001 at 7:24 pm
    Mar 16, 2001 at 9:49 pm
  • Ummmm, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly ...
    Dasko, DanDasko, Dan
    Mar 20, 2001 at 6:54 pm
    Mar 24, 2001 at 1:06 am
  • Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: apps_sol_at_hotmail.com Fat ...
    Apps SolApps Sol
    Mar 29, 2001 at 12:37 am
    Mar 29, 2001 at 8:46 pm
  • Dear All, Platform: Solaris 2.6, Oracle: We have a few tables which are growing very fast due to large no of insertions. But the data gets obselete after a month and we use a procedure to ...
    Mar 9, 2001 at 10:53 am
    Mar 9, 2001 at 10:19 pm
  • A while back someone posted a method for determining which shared memory segments belonged to an instance. Can someone repost that and CC me? Thanks.Do You Yahoo!? Yahoo! Mail Personal Address - Get ...
    Chuck HamiltonChuck Hamilton
    Mar 21, 2001 at 4:14 pm
    Mar 23, 2001 at 4:52 pm
  • Hi All, Can anyone give me a quick (free!) lesson on the concepts behind timefinder? How does this differ from their standard SRDF which (to my understanding) is to split the mirror and back it up ...
    Mar 21, 2001 at 11:44 am
    Mar 23, 2001 at 3:51 pm
  • Dear Listers, I just made script to know the size of datafile in a tablepace, but I still have no idea to make a script to know the size of each table in a schema ? is there anyone who has the script ...
    Bambang SetiawanBambang Setiawan
    Mar 15, 2001 at 2:44 am
    Mar 19, 2001 at 9:43 am
  • Thanks a lot to all who have responded ! U guys really give me inspiration and motivation to go ahead and learn things . I decided to learn everything i could about Oracle ( mainly from these lists ) ...
    Mar 5, 2001 at 1:15 pm
    Mar 16, 2001 at 9:33 pm
  • I don't think that the experts are telling anyone that Mad Cow Disease is not transferrable to humans. It causes death in humans and cannot be killed by cooking at normal temperature. Hoof and Mouth ...
    Ruth GramoliniRuth Gramolini
    Mar 2, 2001 at 3:13 pm
    Mar 6, 2001 at 12:29 am
  • If we put together a standby db (SUN 4500) is Oracle going to want more license money? Our thinking is, the license(s) we already own on the production server (also a 4500) cover us to keep the ...
    Don Dealy, IIDon Dealy, II
    Mar 9, 2001 at 3:13 pm
    Mar 12, 2001 at 11:05 am
  • dunno.... any votes for my shortbread cookie recipe? Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel ...
    Rachel CarmichaelRachel Carmichael
    Mar 29, 2001 at 5:19 pm
    Mar 30, 2001 at 1:20 pm
  • help! I am by no means the world's best PL/SQL programmer (heck, I can barely program in it, PL/SQL 101 is on my desk at home) I am trying to see how hard it would be to add encryption to sensitive ...
    Rachel CarmichaelRachel Carmichael
    Mar 21, 2001 at 9:34 pm
    Mar 22, 2001 at 10:31 pm
  • Seven years ago I was offered an Oracle DBA job at a chocolate factory and turned it down. (Please don't tell Rachel, she already thinks I'm crazy.) I had two simultaneous offers for the same salary ...
    Steve OrrSteve Orr
    Mar 21, 2001 at 4:46 pm
    Mar 22, 2001 at 8:12 am
  • Using a little utility called contig I noticed that the Oracle 8.1.6 datafiles on my test NT server are quite fragmented, an average of 177 fragments per file, 118 fragments for the OEM repository ...
    Boivin, Patrice JBoivin, Patrice J
    Mar 9, 2001 at 7:25 pm
    Mar 12, 2001 at 9:49 pm
  • Oracle Tru64 4.0f Got in this morning (duh duh duh duh) and found a mail from my alerting script from the DB with the following ORA-1652: unable to extend temp segment by 27309 in ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Mar 9, 2001 at 9:37 am
    Mar 9, 2001 at 5:12 pm
  • Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save $$$$. In fact, our management may even make Standard the de facto standard while requiring ...
    Thomas JeffThomas Jeff
    Mar 28, 2001 at 5:10 pm
    Mar 29, 2001 at 9:02 pm
  • Ouch, big mistake : I added a datafile to a wrong tablespace... I don't know how to drop this datafile.... can anybody help ? Thanx !! L.A. -- Please see the official ORACLE-L FAQ ...
    Mar 7, 2001 at 11:31 am
    Mar 7, 2001 at 9:05 pm
  • Hi Friends I have toad tool for my NT database DBWR Average Scan Depth 1024 **Number of DB_Files too high?? I got doubt due to from v$waitstat I got data block waits some time 8000 and some times ...
    Raghu KotaRaghu Kota
    Mar 1, 2001 at 4:32 pm
    Mar 2, 2001 at 3:15 pm
  • Dennis, So how are things post earth quake?. Did you need to invoke any of your DR Plan?. If so, sharing your experience on this would be useful after the dust settles =:-0 It's a hell of a wake up ...
    O'Neill, SeanO'Neill, Sean
    Mar 1, 2001 at 10:49 am
    Mar 1, 2001 at 11:00 pm
  • RDBMS I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum='****'; exit; I end up with ...
    Mar 29, 2001 at 5:56 pm
    Mar 30, 2001 at 2:08 pm
  • Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP ...
    Joseph S. TestaJoseph S. Testa
    Mar 29, 2001 at 12:46 pm
    Mar 29, 2001 at 7:00 pm
  • Subject line got your attention didn't it? Some may recognize that line from a Bill Cosby routine. I thought it might be an attention grabber. the real purpose of this post Lest we all forget the ...
    Mar 21, 2001 at 9:24 pm
    Mar 26, 2001 at 8:57 pm
  • Hi all, I am testing out Spotlight on Oracle from Quest Software. It is telling me that my log writer process is slow. What it looks like it is saying is that most disks take about 20ms to right the ...
    Kevin KostyszynKevin Kostyszyn
    Mar 22, 2001 at 2:57 pm
    Mar 22, 2001 at 9:47 pm
  • List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=* When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH. Everything is set and available (permissions ...
    Sonja �ehovi�Sonja �ehovi�
    Mar 14, 2001 at 10:22 am
    Mar 16, 2001 at 2:49 am
  • IMHO, the disk toolsuite that is unbeatable is by O&O Defrag. something like oodefrag.com.... i have been using this to great effect for years. and they have some truly and really neat optimization ...
    Mohan, RossMohan, Ross
    Mar 10, 2001 at 2:28 am
    Mar 13, 2001 at 7:01 pm
  • Hi, You are missing an import parameter at step 8. either FULL=Y or FROMUSER=TEDDY Should fix it. Regards Garry ++++++++++++++++++++++++++++++++++++ All internet traffic to this site is automatically ...
    Gillies, GarryGillies, Garry
    Mar 5, 2001 at 3:32 pm
    Mar 7, 2001 at 4:05 am
  • You can save the Excel file in comma delimited formated, CSV and use sql*loader to put the data into the database. You can just ftp it from the machine which has Excel to the server housing the ...
    Ruth GramoliniRuth Gramolini
    Mar 29, 2001 at 6:56 pm
    Mar 30, 2001 at 3:10 pm
  • I have an Oracle 8.1.6 instance on an NT Server. The application has only a few users. Very often throughout the day it seems response time drops to about 20 seconds. By the time I log on to look at ...
    Smith, Ron L.Smith, Ron L.
    Mar 23, 2001 at 4:29 pm
    Mar 26, 2001 at 8:39 pm
  • Hello Listers, I am facing a typical problem. In one of my D2K appliaction I need to first populate the data in a particular itermediate table and then run the reporting job. The data population has ...
    Tapas duttaTapas dutta
    Mar 16, 2001 at 8:06 am
    Mar 19, 2001 at 7:21 pm
  • OK Folks, I got this in the old inbox this morning. Most likely it came from one of the job search services like Monster.com. Funny how those services just can't forget you. Anyway it is of no ...
    Mar 2, 2001 at 3:15 pm
    Mar 5, 2001 at 7:31 pm
  • Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- ...
    Mar 20, 2001 at 3:42 pm
    Mar 21, 2001 at 2:53 pm
  • Ants are not full of citric acid. They do produce formic acid which is what makes the bites of certain species painful. Ants belong to the family Formicidae; a name obviously derived from their ...
    MacGregor, Ian A.MacGregor, Ian A.
    Mar 20, 2001 at 4:51 am
    Mar 20, 2001 at 6:26 pm
  • List, I have an installation of Oracle 8.1.6 on a DBA test server where svrmgrl "connect internal" seems to want a password... Sun Microsystems Inc. SunOS 5.8 Generic February 2000 Configured oracle ...
    Fowler, Kenneth RFowler, Kenneth R
    Mar 7, 2001 at 5:10 pm
    Mar 8, 2001 at 6:08 pm
  • Walt, Last summer we noticed our support bill was split into two pieces--one for support and one for upgrades. You can still buy both. I didn't notice that it was a lot more in total than before, but ...
    Sarah SatterthwaiteSarah Satterthwaite
    Mar 1, 2001 at 1:04 am
    Mar 4, 2001 at 3:22 pm
  • Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank ...
    Sinardy XingSinardy Xing
    Mar 28, 2001 at 12:44 am
    Mar 29, 2001 at 2:26 pm
  • I have the following scripts: insert into table select * from table2; So if use the about bulk statement in my application, and the table2 is big, say 10 million records, my concern is that it's ...
    CC HarvestCC Harvest
    Mar 23, 2001 at 3:25 am
    Mar 27, 2001 at 10:50 am
  • Hello DBA's You know, I read somewhere that you can make your log_buffer 10 percent of your total sga. So if you had a 500mb sga you could have a 50 mb log_buffer? What do you guys think, the ...
    Kevin KostyszynKevin Kostyszyn
    Mar 23, 2001 at 4:51 pm
    Mar 24, 2001 at 6:39 pm
  • Dear Listers, I've download a presentation talking about Calculating PCT_USED . the formula is quite simple : PCT_USED + PCT_FREE < 100 PCT_USED = PCT_FREE + 1 row size but I have no idea to ...
    Bambang SetiawanBambang Setiawan
    Mar 23, 2001 at 1:55 am
    Mar 24, 2001 at 3:45 pm
  • But all is not gloom and doom for Oracle. Excerpts from Chuck Phillips of Morgan Stanley on the last quarter.... It's useful to keep the quarter in perspective. It's a miss but not a financial ...
    Tim SawmillerTim Sawmiller
    Mar 21, 2001 at 7:57 pm
    Mar 22, 2001 at 7:43 pm
  • Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of ...
    Eriovaldo do Carmo AndriettaEriovaldo do Carmo Andrietta
    Mar 21, 2001 at 6:26 pm
    Mar 22, 2001 at 2:07 pm
  • Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests, OCP preparations materials, articles, books, etc ... Please share your resources ! Thanks a lot in ...
    Mar 20, 2001 at 5:51 pm
    Mar 22, 2001 at 1:42 pm
  • Hi all, I've read an interesting section in Oracle Docu (Tuning I/O): --- Separating Tables and Indexes It is not necessary to separate a frequently used table from its index. During the course of a ...
    Michal ZaschkeMichal Zaschke
    Mar 13, 2001 at 4:41 pm
    Mar 22, 2001 at 11:13 am
Group Navigation
period‹ prev | Mar 2001 | next ›
Group Overview
grouporacle-l @

443 users for March 2001

Dgoulet_at_vicr.com: 97 posts Kevin Kostyszyn: 92 posts Rachel Carmichael: 81 posts Mohan, Ross: 74 posts Boivin, Patrice J: 63 posts Jacques Kilchoer: 59 posts Jkstill_at_cybcon.com: 47 posts Mark Leith: 45 posts Kimberly Smith: 44 posts Ruth Gramolini: 41 posts Joseph S. Testa: 40 posts Sinardyxing_at_bcsis.com: 40 posts Eric D. Pierce: 39 posts Thater, William: 36 posts Tim Sawmiller: 36 posts Ron Rogers: 34 posts Trassens, Christian: 34 posts William Beilstein: 34 posts Mandar Ghosalkar: 31 posts Dasko, Dan: 28 posts
show more