FAQ

Oracle > oracle-l > September 2000

Search Discussions

746 discussions - 2,265 posts

  • Hi Folks, I've put together a document which specifies configuration standard guidelines for Oracle on Win NT platform. If anyone would like to review it I will send it to them backchannel in PDF ...
    O'Neill, SeanO'Neill, Sean
    Sep 20, 2000 at 1:39 pm
    Sep 30, 2000 at 1:12 am
  • This is a multi-part message in MIME format. ------=_NextPart_000_0048_01C0289E.1C78B370 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Any Oracle DBA ...
    Lu Kai HinLu Kai Hin
    Sep 27, 2000 at 8:15 am
    Sep 30, 2000 at 10:05 am
  • Is there any sort of rule-of-thumb for how many database that a DBA should be expected to support? I realize that the answer would vary based on size of databases, stability, production vs ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Sep 13, 2000 at 5:28 pm
    Sep 15, 2000 at 5:22 pm
  • 20

    OOW

    Hey Lady, When are u leaving LA? Just curious, I'm not sure if leaving friday or saturday, but leaning towards friday and was wondering when others where leaving. Susan Get Your Private, Free E-mail ...
    Susan mcclainSusan mcclain
    Sep 25, 2000 at 1:52 pm
    Sep 27, 2000 at 3:00 am
  • We have an installation of Oracle 8 on Unix that we use only for demonstrations. We have forgotten the sys password. Anything we can do? John
    John DunnJohn Dunn
    Sep 14, 2000 at 10:16 am
    Sep 18, 2000 at 7:21 am
  • Hi, I've been having a problem connecting internal with sqlplus on the server running Oracle. It's NT 4.0 and Oracle 8.1.6.0. Server manager connects OK with connect internal, but sqlplus insists on ...
    Steve O'DonnellSteve O'Donnell
    Sep 6, 2000 at 9:50 pm
    Sep 16, 2000 at 12:01 am
  • Hi Guru's, Platform: Oracle7.3.4/Sco-Unix Open Server/D2K forms6 / Win-98 What are the situations in which I can ensure Data recovery as I am taking Scheduled Export Backup's (Full,Cumulative and ...
    Ajay KothariAjay Kothari
    Sep 1, 2000 at 8:48 am
    Sep 29, 2000 at 7:19 pm
  • --0-1973594324-968790456=:11682 Content-Type: text/plain; charset=us-ascii I have a query with a RULE hint, but the execution plan is show hash joins. Is this something new in the 8.1.5 optimizer? It ...
    Chuck HamiltonChuck Hamilton
    Sep 12, 2000 at 8:27 pm
    Sep 21, 2000 at 11:50 pm
  • I have a table with rows currently populating. I wish to resize the table for better performance. What is the best way I should figure out how to size my INITIAL and NEXT extent sizes for this ...
    Fred SmithFred Smith
    Sep 25, 2000 at 3:32 pm
    Sep 28, 2000 at 10:00 pm
  • I accidentally created a datafile at 2 blocks instead of 2G. I had to add another datafile after that to expand the tablespace. I am using 7.3.6. Is there any way to utilize or get rid of the ...
    Smith, Ron L.Smith, Ron L.
    Sep 19, 2000 at 5:50 pm
    Sep 20, 2000 at 5:27 pm
  • Hummm : I was under the impression ( not to say I was almost sure ) after some testing that if you have an ALTER TABLESPACE ADD DATAFILE running in one session, and you perform another one elsewhere, ...
    Ddorr.cs_at_clearstream.comDdorr.cs_at_clearstream.com
    Sep 15, 2000 at 1:52 pm
    Sep 19, 2000 at 6:51 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0195D.019F6490 Content-Type ...
    Nikolay KumanovNikolay Kumanov
    Sep 8, 2000 at 6:21 am
    Sep 12, 2000 at 9:19 pm
  • Hi everyone; I would like to generate a create table and index script for an existing database which can be used to create tables and indices whenever it is required. You help highly appreciate it ...
    Majid KazemiMajid Kazemi
    Sep 29, 2000 at 2:45 pm
    Sep 29, 2000 at 11:57 pm
  • Anyone have a good link to info on the Stats Pack? Thanks, Dave Turner
    David TurnerDavid Turner
    Sep 21, 2000 at 9:13 pm
    Sep 28, 2000 at 12:52 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C0224A.422D4040 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Gurus, Is it possible to ...
    Mark LeithMark Leith
    Sep 19, 2000 at 1:59 pm
    Sep 21, 2000 at 7:25 am
  • List, how can i remove 25,000 files from a unix directory ?? if i try rm -f * it returns "ksh: /usr/bin/rm: 0403-027 The parameter list is too long" if i give wild card it would take too long... ...
    RahulRahul
    Sep 20, 2000 at 10:58 am
    Sep 21, 2000 at 2:36 am
  • Does anyone have a script or tool which will output a database schema (tables, indexes, constraints) to html format?
    Glenn TravisGlenn Travis
    Sep 13, 2000 at 2:48 pm
    Sep 17, 2000 at 10:43 pm
  • hi, Everybody I created over 50 sequences in a schema and would like to import all these sequences to another database. How can I do that? Thanks in advance for the info. Mosy Lo email ...
    Mosy LoMosy Lo
    Sep 26, 2000 at 7:46 pm
    Sep 28, 2000 at 9:54 pm
  • Hi Folks, Please read this very carefully. I was reading a article in eweek magazine(September) on oracle. Following are exact words. " Oracle has been quietly alerting customers that systems running ...
    Sanjeev SinghSanjeev Singh
    Sep 27, 2000 at 6:30 pm
    Sep 28, 2000 at 3:16 pm
  • DBA's Has anyone done an Informix to Oracle conversion? I need a little help to = get started with the Oracle conversion kit. Please contact me off list. Thanks Jim Howerton jhowerton_at_uabmc.edu
    James HowertonJames Howerton
    Sep 11, 2000 at 8:47 pm
    Sep 22, 2000 at 7:49 pm
  • Hi all. I am battling with OEM, I am currently running the console on version 2.0.4 on a Windows 2000 pro box. The Oracle db is version 8.1.5 on a Solaris SunOS 5.8. The repository is also on the Sun ...
    Clinton NaudeClinton Naude
    Sep 14, 2000 at 7:33 am
    Sep 15, 2000 at 5:43 pm
  • Hi All, I've got an email from someone who says that it used not to be possible to drop a tablespace that had ever been the temporary tablespace for SYS. This is news to me. Has anyone ever heard of ...
    Steve AdamsSteve Adams
    Sep 12, 2000 at 12:29 pm
    Sep 14, 2000 at 5:07 am
  • Hello, Just one Question. Have someone any hint for the Oracle Openworld conf. I'm fly from Sweden. Is it possible to me someone from the list ( I have seen some mail about that). Regards Henrik ...
    Henrik EkenbergHenrik Ekenberg
    Sep 11, 2000 at 9:48 am
    Sep 13, 2000 at 5:05 pm
  • Hi, Since Temp and Rollbacks are almost all writes you may want to put them on a mirror set rather than Raid 5. There is a bit of a write penalty but not a major one. _Ernie ----- Original Message ...
    Ernest SimardErnest Simard
    Sep 1, 2000 at 8:49 pm
    Sep 12, 2000 at 9:45 am
  • I'm new to PL/SQL and I am trying to use same to send output of name from v$database to screen. The code I'm using is as below but the output is not being sent to screen and I can't figure why not ...
    O'Neill, SeanO'Neill, Sean
    Sep 4, 2000 at 1:35 pm
    Sep 6, 2000 at 10:59 am
  • Hi all, the alert log of my 8.1.5 database (OS is RedHat 6.1) constantly says: Wed Sep 20 18:12:02 2000 Load Indicator not supported by OS ! Wed Sep 20 18:12:36 2000 Load Indicator not supported by ...
    Langnickel, ChristophLangnickel, Christoph
    Sep 21, 2000 at 12:08 pm
    Sep 28, 2000 at 9:41 am
  • Hi All, I was just checking DBVERIFY. Can it really check the DATAFILES even when it is ONLINE?? I mean to say if the database is UP and Running can DBVERIFY work??? All manuals say that it works on ...
    Rajesh DayalRajesh Dayal
    Sep 27, 2000 at 4:15 am
    Sep 28, 2000 at 4:21 am
  • ------------------------------------------------------------------------= - ------------------------------------------------------------------------=
    Alexander OrdonezAlexander Ordonez
    Sep 20, 2000 at 10:13 pm
    Sep 25, 2000 at 2:05 pm
  • Hi all - I am wondering if there is a way to limit the number of CPUs used by oracle on a unix machine (Sun Solaris in particular). If so, is this done through oracle or through unix. I have been ...
    Lisa YttriLisa Yttri
    Sep 14, 2000 at 4:25 pm
    Sep 18, 2000 at 7:32 pm
  • I want to create a view where one column is a combination of two columns (from two different tables). i.e. course_id and sessions_id are both numbers, for example if course_id=123 and ...
    Bajwa, Sandeep SBajwa, Sandeep S
    Sep 14, 2000 at 1:59 pm
    Sep 15, 2000 at 8:01 am
  • Hello, We are a small, but growing data warehouse using Oracle 8.1.6 on Solaris 2.7. We have several tables whose size exceeds 1 GB, and are considering purchasing the partitioning option from ...
    Bill BeckerBill Becker
    Sep 12, 2000 at 6:48 pm
    Sep 13, 2000 at 10:44 pm
  • We have several Sun boxes (Solaris 2.6) running Oracle 8, 8i. One of the boxes (description given below) Kept rebooting and this machine happens to run one of the most critical billing systems ...
    Rama MalladiRama Malladi
    Sep 6, 2000 at 8:39 pm
    Sep 11, 2000 at 9:31 am
  • Anyone have any ideas\situations\comments about 7.3.4 and 8.1.6 being on the same machine? Is it possible??? Thanks, Christine Turner DBA IPS SENDERO Scottsdale, Arizona 85251 From: "Kamalakannan, D ...
    Christine TurnerChristine Turner
    Sep 1, 2000 at 9:51 am
    Sep 8, 2000 at 5:52 pm
  • Hi! I am studying a book it says that you can store your forms and Reports to database. It does mention that if the report or form builder does not allow you save to database you need to run a ...
    Abdul AleemAbdul Aleem
    Sep 27, 2000 at 10:59 am
    Sep 27, 2000 at 5:17 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01C024B9.2A568E80 Content-Type ...
    Satar NaghshinehSatar Naghshineh
    Sep 22, 2000 at 5:18 pm
    Sep 27, 2000 at 9:23 am
  • --0-771151432-969454605=:18612 Content-Type: text/plain; charset=us-ascii Has anyone succesfully used OPS in a mission critical production environment? I'd like to hear about it.
    Chuck HamiltonChuck Hamilton
    Sep 20, 2000 at 12:56 pm
    Sep 26, 2000 at 5:22 pm
  • Hi Listers, I am wondering how to find the high water mark of number transactions as daily basis. I tried v$resource_limit, but max_utilization of transactions always reached the max value which is ...
    Joan HsiehJoan Hsieh
    Sep 18, 2000 at 5:55 pm
    Sep 20, 2000 at 12:40 am
  • Hi guys goin thru a brain freeze here .. ur help appreciated in advance here is the deal ... #!/bin/ksh # .. .. ksh code .. ksh code .. ksh code .. $ORACLE_HOME/bin/sqlplus -s / < select value into ...
    Thapliyal, DeepakThapliyal, Deepak
    Sep 13, 2000 at 10:01 pm
    Sep 14, 2000 at 6:06 pm
  • Hi! I do have a weird problem to solve. I wanna check if a specific record already exists in a table (select * from table where PrimaryKey = 1234). If it does, I wanna do an update on that record and ...
    Helmut DaimingerHelmut Daiminger
    Sep 12, 2000 at 11:57 pm
    Sep 13, 2000 at 3:09 pm
  • Hi Babu, I can't tell you how this happened, but I can suggest an unsupported way of making sure that it never happens again. The APT script "replace_dual.sql" at ...
    Steve AdamsSteve Adams
    Sep 7, 2000 at 3:12 pm
    Sep 12, 2000 at 11:46 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_002B_01C01968.D1EF2DA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable What I have to do ...
    Slavica SadzakovicSlavica Sadzakovic
    Sep 8, 2000 at 5:45 am
    Sep 11, 2000 at 6:17 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C018C8.2A72A57A Content-Type ...
    Koivu, LisaKoivu, Lisa
    Sep 7, 2000 at 12:35 pm
    Sep 7, 2000 at 11:04 pm
  • Hello all, Can anyone tell me if you can change the sample size used when you analyze a schema with the 'estimate' option. I would like to make it bigger. Thanks in advance, Ruth B. Gramolini ORACLE ...
    Ruth GramoliniRuth Gramolini
    Sep 6, 2000 at 3:29 pm
    Sep 7, 2000 at 12:03 pm
  • Hi Gaja, Yes, I do still have that old thread, and in fact we dropped it without reaching any agreement. On Wednesday, 21 October 1998 9:20, I disagreed with your claim about the cost of multiple ...
    Steve AdamsSteve Adams
    Sep 1, 2000 at 5:26 am
    Sep 6, 2000 at 7:12 am
  • i'm quite new here.....and i noticed almost everyone in the list is onto this openworld.....it's seems a very big event. what is it? do all of guys going to be presentors? do you need to submits ...
    Grace limGrace lim
    Sep 1, 2000 at 12:56 am
    Sep 1, 2000 at 8:38 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C028B2.4948485C Content-Type ...
    Koivu, LisaKoivu, Lisa
    Sep 27, 2000 at 6:39 pm
    Sep 28, 2000 at 12:30 pm
  • All, I have a problem with searching a name column within the database where the case of the data must be preserved. This name is then used in the search criteria of many queries in the application ...
    Stuart HoulstonStuart Houlston
    Sep 25, 2000 at 3:45 pm
    Sep 26, 2000 at 1:49 am
  • This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C02014.F446F6A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I get the following ...
    Adisekaran MurugaianAdisekaran Murugaian
    Sep 16, 2000 at 11:33 pm
    Sep 20, 2000 at 3:24 pm
  • How can I get all the contacts which start with numbers? PLEASE NOTE: contact_name is a character field. select contact_name from contact where contact_name like '[0-9]%' does not work (like other ...
    Glenn TravisGlenn Travis
    Sep 18, 2000 at 9:39 pm
    Sep 20, 2000 at 11:37 am
  • Hello Gurus I am posting this question again, in anticipation of that some ideas would come over. I have a question that how do I calculate the required initial and next extent on a tablespace and a ...
    Mukesh GhildiyalMukesh Ghildiyal
    Sep 7, 2000 at 6:53 pm
    Sep 13, 2000 at 10:56 pm
Sep 2000
12345…15
Group Navigation
period‹ prev | Sep 2000 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions746
posts2,265
users468
websiteoracle.com

468 users for September 2000

Rachel Carmichael: 65 posts Eric D. Pierce: 50 posts Steve Adams: 40 posts Ron Rogers: 34 posts Thapliyal, Deepak: 32 posts Rahul: 26 posts Bunyamin karadeniz: 25 posts Ddorr.cs_at_clearstream.com: 25 posts Jared Still: 25 posts Ruth Gramolini: 25 posts Joseph S. Testa: 24 posts Tom Pall: 24 posts Khedr, Waleed: 22 posts David Turner: 21 posts Kimberly Smith: 21 posts Koivu, Lisa: 21 posts Satar Naghshineh: 21 posts Boivin, Patrice J: 20 posts Diana Duncan: 20 posts Oliver Artelt: 19 posts
show more
Archives