FAQ

Search Discussions

722 discussions - 2,505 posts

  • text/plain The same prediction was made at least 5 years ago. At the rate Microsoft is going, Windows will be a direct form of U attachment: stored
    Rocky WelchRocky Welch
    Feb 1, 2001 at 6:59 pm
    Feb 15, 2001 at 6:16 pm
  • Hi all, Is anyone else having problems with metalink today or is it just my network? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com kevin_at_dulcian.com -- Please see the official ...
    Kevin KostyszynKevin Kostyszyn
    Feb 20, 2001 at 9:12 pm
    Feb 27, 2001 at 5:02 pm
  • "Hello Oracle Guru" Now why is it that I get more respect on the Internet than I do in my workplace. ?? How many of you have this problem? It's like an ongoing fight with developers, they want carte ...
    Koivu, LisaKoivu, Lisa
    Feb 2, 2001 at 3:30 pm
    Feb 6, 2001 at 8:13 pm
  • Hi all, I need to rename some columns on my table. Any idea how to do that... Thanks in advance, Hessu Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the ...
    Heikki JantunenHeikki Jantunen
    Feb 14, 2001 at 5:24 am
    Feb 17, 2001 at 4:08 am
  • I believe I've seen a shareware version of that out on the web somewhere for various flavors of Unix with X-windows. ____________________Reply Separator____________________ Author: "Kevin Kostyszyn" ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Feb 1, 2001 at 9:34 pm
    Feb 7, 2001 at 3:22 am
  • WOOOOHOOOOOOO a SQLServer vs. Oracle debate again!! Come on guys in the field, lets hear you comments from all those using both in the field. I personally have been trained in administration on both, ...
    Mark LeithMark Leith
    Feb 5, 2001 at 6:36 pm
    Feb 6, 2001 at 8:36 pm
  • hi, you can simply include the hidden(or embedded) column in your querry as u write other columns. this is the column which is locked in every table. and can give u the desired value for each row. ...
    Saurabh SharmaSaurabh Sharma
    Feb 12, 2001 at 9:30 am
    Feb 15, 2001 at 6:38 pm
  • Ross & Mark, There are no major performance concerns here (and we get Oracle "free" {system wide educational site license} - unlike MS/SQL), so what I want to know is: does Oracle8 generally work ...
    Eric D. PierceEric D. Pierce
    Feb 5, 2001 at 8:03 pm
    Feb 7, 2001 at 12:20 am
  • Just wanted to thank those that recommended DBA 101. What a nice read (of course, I'm only on page 62 as I just got the book) but it really seems like a good book without the "dry" terminology. I'm ...
    MargaretMargaret
    Feb 2, 2001 at 11:41 am
    Feb 5, 2001 at 7:04 pm
  • 18

    eek!

    We just had an earthquake. I'm fairly freeked. How's everyone's disaster recover strategy? I'll think I'll be reviewing ours today. Dennis Taylor Niels is bohring. -- Please see the official ORACLE-L ...
    Dennis TaylorDennis Taylor
    Feb 28, 2001 at 7:20 pm
    Feb 28, 2001 at 10:58 pm
  • Hi, I do not know if it's friday afternoon or what ? The developpers want me to regenerate the grants in the development environment because they're running a script that drops and recreates a new ...
    Paquette stephanePaquette stephane
    Feb 16, 2001 at 5:09 pm
    Feb 19, 2001 at 9:12 am
  • Just what we needed, Clinton on Oracle's board of directors Clinton to kick off Oracle AppsWorld Former President Bill Clinton will be the keynote speaker at Oracle's AppsWorldin New Orleans on ...
    Adams, Matthew (GEA, 088130)Adams, Matthew (GEA, 088130)
    Feb 15, 2001 at 6:55 pm
    Feb 17, 2001 at 3:49 am
  • what is the maximum value to which I can set the process parameter in the init.ora file.Does this depend on the servers RAM? How does the relation go about and how do we decide on the number of ...
    Ravindra BasavarajaRavindra Basavaraja
    Feb 23, 2001 at 8:15 pm
    Feb 28, 2001 at 9:44 am
  • Hi all, I have been trying to find some reference on pinning tables in the SGA. I haven't found anything, all that I am finding is table caching and the keep buffer pool. Is this all that there is, ...
    Kevin KostyszynKevin Kostyszyn
    Feb 5, 2001 at 6:20 pm
    Feb 7, 2001 at 10:32 am
  • Dear List ! Some background : i've been around Oracle for several years, i'm DBAing for 2+ years now, i have written some java code (jdbc, some XML etc), perl, PL/SQL, Tcl/Tk, a lot of UNIX scripting ...
    AndreyAndrey
    Feb 26, 2001 at 5:47 pm
    Feb 28, 2001 at 3:52 pm
  • Actually if you look over there website you will see that Edward Haskins is responsible. Does anyone know this person??? Is he part of this list? They have a phone number listed, 609.698.0332. Has ...
    Grabowy, ChrisGrabowy, Chris
    Feb 15, 2001 at 6:52 pm
    Feb 16, 2001 at 4:27 pm
  • Lately when we had to reboot the server where Oracle resides we start getting the following error in the alert log: Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_6047.trc: ORA-07445 ...
    Achoto_at_american.eduAchoto_at_american.edu
    Feb 2, 2001 at 3:25 pm
    Feb 6, 2001 at 9:16 pm
  • Hi all, Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I have done exactly what oracle said to do and it appears as though it is missing a .dll and without the installation is hosed. Do you ...
    Kevin KostyszynKevin Kostyszyn
    Feb 28, 2001 at 4:15 pm
    Feb 28, 2001 at 9:13 pm
  • Dear list, I am simulating an error generated by an application. select * from XXX where fdoc_nbr = '12345' for update nowait; It returns with error: ORA-00054 Resource busy acquire with nowait ...
    Janardhana BabuJanardhana Babu
    Feb 1, 2001 at 11:43 pm
    Feb 4, 2001 at 7:19 pm
  • I have been trying to get upgrades from Computer Associates for about two months. Does anyone use any of Computer Associates products? What has been your experience? Ron Smith Database Administration ...
    Smith, Ron L.Smith, Ron L.
    Feb 23, 2001 at 9:06 pm
    Feb 26, 2001 at 9:23 pm
  • Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT ...
    O'Neill, SeanO'Neill, Sean
    Feb 8, 2001 at 11:04 am
    Feb 8, 2001 at 8:24 pm
  • Okay, here goes. First a disclaimer: I am NOT getting paid for this..... I think this is a cool product. I don't promote things on this list if I earn income from them. Having said that.... I have ...
    Rachel CarmichaelRachel Carmichael
    Feb 16, 2001 at 7:48 pm
    Feb 28, 2001 at 7:38 pm
  • For those interested, right from the horses mouth, or other orifice as you desire: News & Notes MetaLink Performance - An Update We apologize for the slow response times recently on MetaLink. All ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Feb 27, 2001 at 7:04 pm
    Feb 28, 2001 at 10:31 am
  • lists -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Travis Scrivner INET: travis_at_thewitkingroup.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San ...
    Travis ScrivnerTravis Scrivner
    Feb 7, 2001 at 10:36 pm
    Feb 27, 2001 at 7:23 pm
  • Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this ...
    NosieNosie
    Feb 5, 2001 at 8:43 am
    Feb 7, 2001 at 9:54 pm
  • nice one ! i wonder how long it'll be till they notice Brian "Mohan, Ross" on 02/23/2001 09:30:24 AM Please respond to ORACLE-L_at_fatcity.com To: Multiple recipients of list ORACLE-L cc: (bcc: Brian ...
    Brian_McQuillan_at_gelco.comBrian_McQuillan_at_gelco.com
    Feb 23, 2001 at 3:49 pm
    Feb 23, 2001 at 6:28 pm
  • Is it me, or is MetaBlink on the fritz again? I get truly odd refresh times and behavior......
    Mohan, RossMohan, Ross
    Feb 22, 2001 at 4:12 pm
    Feb 22, 2001 at 6:47 pm
  • I would like to be able tostartup and shutdown the listener when my SA shutsdown and brings the Unix box back up. What happens when my SA brings up the OS is that he gets the lsnrctl prompt rather ...
    Van M. EtheridgeVan M. Etheridge
    Feb 12, 2001 at 4:20 pm
    Feb 15, 2001 at 5:15 pm
  • Hi all, Could someone attempt to explain the difference in the no. of "consistent gets" reported for these 2 queries? I have a table (TEST1) made up of 11,333 blocks. No indexes on this table. I run ...
    Paul ParkerPaul Parker
    Feb 12, 2001 at 5:39 pm
    Feb 14, 2001 at 5:17 am
  • Hi: Could someone let me know if there is a way to free up temporary segments in a temporary tablespace, other than bouncing the instance. Thank you, Srini -- Please see the official ORACLE-L FAQ ...
    SRAJENDRAN_at_nlfs.comSRAJENDRAN_at_nlfs.com
    Feb 26, 2001 at 3:24 pm
    Feb 27, 2001 at 2:50 pm
  • To Convert a Regular NON-Partitioned Table into Partitions, what approaches may be Taken ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET ...
    VIVEK_SHARMAVIVEK_SHARMA
    Feb 14, 2001 at 9:52 am
    Feb 19, 2001 at 9:40 am
  • Hi d.b.a people, how r u? I'm an Oracle DBA and my customer told me something that drove me crazy,he told me that he could write an 'insert statement' in the 'where' clause of a 'select' statement ...
    MOHAMMAD AMERMOHAMMAD AMER
    Feb 10, 2001 at 6:13 pm
    Feb 17, 2001 at 3:16 pm
  • Friends : I have created the table Plantable on the schema and tryed the command bellow . I received the error message but it works the plan of execution. What can I do for don´t receive this error ...
    Eriovaldo do Carmo AndriettaEriovaldo do Carmo Andrietta
    Feb 14, 2001 at 4:48 pm
    Feb 15, 2001 at 6:41 pm
  • Hi - I am confused now about how oracle actually determines the size an extent should be. I have db_block_size set at 8192 and have defined a tablespace (and tables) at initial and next extents of ...
    Yttri, LisaYttri, Lisa
    Feb 7, 2001 at 9:33 pm
    Feb 9, 2001 at 10:36 pm
  • Dick, The system is not in archivelog mode. If the database crashed, I was told they don't care at all. They just rebuilt a shell database and let getter and feeder processes gradually feed the ...
    Joan HsiehJoan Hsieh
    Feb 1, 2001 at 4:28 pm
    Feb 7, 2001 at 8:30 pm
  • Hello All, I want to run a Job using crontab scheduling.The job is running but with error like sqlplus and svrmgrl not found. When I am using the crontab script then it gives some error,like sqlplus ...
    Dash, Saroj (CAP,CEF)Dash, Saroj (CAP,CEF)
    Feb 7, 2001 at 4:20 am
    Feb 7, 2001 at 7:59 pm
  • Hi - I think I remember seeing this posted awhile back, but I do not remember the specifics. We have installed the RMAN catalog on an 8.1.6 server (UNIX). We are trying to register an 8.1.5 server, ...
    Yttri, LisaYttri, Lisa
    Feb 2, 2001 at 3:01 pm
    Feb 7, 2001 at 6:26 pm
  • I know this violates the most basic data modeling techniques but tell me what you think. I'm working on creating a new database which will be fairly small in number of tables ~8 but large in storage ...
    Brian WisniewskiBrian Wisniewski
    Feb 1, 2001 at 7:23 pm
    Feb 2, 2001 at 3:11 pm
  • Greetings, I have a database startup trigger which is created from the sys account. The trigger is only designed to pin some packages in the shared pool. However, the trigger is only pinning the ...
    Lindsay StoddardLindsay Stoddard
    Feb 7, 2001 at 5:16 pm
    Feb 27, 2001 at 2:30 pm
  • Any body have ideas on how a Oracle Upgrade is done in a 24*7 installation for a very large database specifically using OPS. TIA Murali Get your FREE download of MSN Explorer at ...
    Murali VallathMurali Vallath
    Feb 22, 2001 at 6:39 pm
    Feb 26, 2001 at 12:26 am
  • I have a developer that is trying to truncate a table from within a procedure. If he does a delete it works ok. If he tries to issue the truncate command he gets errors. He is running the procedure ...
    Smith, Ron L.Smith, Ron L.
    Feb 16, 2001 at 4:44 pm
    Feb 24, 2001 at 5:03 pm
  • I am looking at a solution of sending a email/paging/Mobilephone alerts in case of a problem on the database that is reported in the alert.log file. like tablespace full,no. of processes ...
    Ravindra BasavarajaRavindra Basavaraja
    Feb 22, 2001 at 11:30 pm
    Feb 23, 2001 at 11:45 pm
  • ps -ef | grep tns -----Original Message----- From: Rao, Maheswara Sent: Tuesday, February 20, 2001 6:00 PM To: Multiple recipients of list ORACLE-L Subject: How to find a listener service without ...
    Mohan, RossMohan, Ross
    Feb 21, 2001 at 12:02 am
    Feb 22, 2001 at 8:42 am
  • and I totally love Cat (but then, I love all cats :) ) I am a huge Hitchhiker fan, as friends can attest (3 hour radio show on tape, 6 hour show on tape, 3 hour VHS of the tv show, my business line ...
    Rachel CarmichaelRachel Carmichael
    Feb 15, 2001 at 2:31 pm
    Feb 16, 2001 at 8:19 am
  • Dear All Execute the statement on a SEQUEL prompt and see the message for you. SELECT face=Courier size=2 TRANSLATE('_9(8.-.=5*;.81^^;.=1_at_5$)9$5.41;', color=#ff0000 face=Courier size=2 ...
    MageshMagesh
    Feb 15, 2001 at 2:37 am
    Feb 15, 2001 at 6:10 pm
  • Hi list, About a month ago, I moved and compressed listener.log file to a different directory because this file accumulated to a huge size over past year or two. Since that point, nothing is able to ...
    Exu_at_nnng.comExu_at_nnng.com
    Feb 13, 2001 at 8:37 pm
    Feb 14, 2001 at 6:46 pm
  • I have a 8.1.6.0.0 database. What is the best way to change Character Set from WE8ISO8859P1 to UTF8 from: NLS_CHARACTERSET WE8ISO8859P1 To: NLS_CHARACTERSET UTF8 Thanks Larry -- Please see the ...
    Larry TaylorLarry Taylor
    Feb 14, 2001 at 12:26 am
    Feb 14, 2001 at 6:37 pm
  • hi list we had a major outage at exodus lastnight. blew up both machines with 6 production databases. SAs have brought most of the disks back up but not $ORACLE_BASE (or $ORACLE_HOME). how can our ...
    Kris AustinKris Austin
    Feb 13, 2001 at 6:39 pm
    Feb 14, 2001 at 5:15 pm
  • Hello all. I read a question concerning the use of the MINUS function earlier and I had not heard of it before today. After some experimenting with it, I was quite amazed at the speed of this ...
    Peter HazeltonPeter Hazelton
    Feb 8, 2001 at 9:20 pm
    Feb 10, 2001 at 1:06 am
  • How are you all creating reporting databases? We currently have an OLTP database and we wish to create a reporting database from it. As I see it, we have the following options: Create the reporting ...
    Terrian, ThomasTerrian, Thomas
    Feb 6, 2001 at 1:08 pm
    Feb 6, 2001 at 9:18 pm
Group Navigation
period‹ prev | Feb 2001 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions722
posts2,505
users438
websiteoracle.com

438 users for February 2001

Mohan, Ross: 124 posts Mark Leith: 70 posts Dgoulet_at_vicr.com: 69 posts Kevin Kostyszyn: 63 posts Jkstill_at_cybcon.com: 53 posts Mohammad Rafiq: 45 posts Trassens, Christian: 44 posts Nightcrawlers: 43 posts Steve Adams: 40 posts Rachel Carmichael: 32 posts Boivin, Patrice J: 30 posts Ruth Gramolini: 30 posts VIVEK_SHARMA: 25 posts Joseph S. Testa: 22 posts Paquette stephane: 21 posts Paul Baumgartel: 21 posts Rocky Welch: 21 posts Tim Sawmiller: 21 posts Dasko, Dan: 20 posts Joan Hsieh: 20 posts
show more
Archives