FAQ

Search Discussions

728 discussions - 2,358 posts

  • I posted a message to this listserv at least an hour ago, and it hasn't shown up in the listserv. Why the long delay? Patrice Boivin Systems Analyst (Oracle Certified DBA)
    Boivin, Patrice JBoivin, Patrice J
    Jul 27, 2000 at 3:35 pm
    Jul 31, 2000 at 4:44 pm
  • Sending this again, Because I did not have a subject last time. I sure would appreciate some opinions on this. At my place of work we have two teams in our division. One team is the application ...
    Donna_M_Vail_at_sd.fisc.navy.milDonna_M_Vail_at_sd.fisc.navy.mil
    Jul 24, 2000 at 2:54 pm
    Jul 26, 2000 at 8:20 am
  • 2) why do we get a hit ratio of less than 50 % while we execute select * query on a single table contaiining 100000 rows and each db_block contains aroud 40 rows of table. Arvind From: "Suhen Pather"
    Aheda_at_cdotd.ernet.inAheda_at_cdotd.ernet.in
    Jul 4, 2000 at 1:51 pm
    Jul 31, 2000 at 9:04 pm
  • Why is are so many people on the list so big on OCP, learn to be a DBA first, the OCP will be easy enough after you learn the basics. Being OCP does NOT make you a good DBA( recruiters on the list ...
    Joseph S. TestaJoseph S. Testa
    Jul 20, 2000 at 11:00 am
    Jul 21, 2000 at 2:30 pm
  • Some passwords are lost, others are in clear text, others are operational (somewhere in production), but not known due to turnover. Rather than possibly break running systems by changing passwords, ...
    Linda HagedornLinda Hagedorn
    Jul 13, 2000 at 7:07 pm
    Jul 17, 2000 at 7:51 am
  • Hi All, We are using ETL(extraction,transformation and loading) tool to load data from source databases to warehouse database. This tool allows us to write custom sql and does not allow DDL ...
    Prasada R GundaPrasada R Gunda
    Jul 12, 2000 at 8:01 pm
    Jul 17, 2000 at 4:12 pm
  • Hi All, I have some queries which take too long to execute, perform too many disk reads and affects very small no of rows. I have analyzed the table,indexes and there are no chained rows for this ...
    PK JPK J
    Jul 7, 2000 at 9:56 am
    Jul 13, 2000 at 5:37 pm
  • I've noticed that on the Internet as a whole, and particularly among engineers of various flavors, very few people spell the word lose with one 'o'. Okay, this is a really trivial, old technical ...
    Gait, ChristopherGait, Christopher
    Jul 18, 2000 at 9:52 pm
    Jul 26, 2000 at 4:19 pm
  • Hello, I have created 25 rollback segments. Now whenever i restart the database few rollback segments are offline. To one procedure i have assigened one rollback segment with the help of 'set ...
    Ravi BabuRavi Babu
    Jul 11, 2000 at 12:38 pm
    Jul 12, 2000 at 7:45 pm
  • Yesterday evening I started the following delete: delete from ojs_main_multiple where docnum not in (select docnum from ojs_main); ojs_main contains about 250.000 rows and ojs_main_multiple about ...
    Andreas JungAndreas Jung
    Jul 28, 2000 at 7:21 am
    Jul 31, 2000 at 3:06 pm
  • Does anyone out there use DBartisan. Can you tell me where I can find more information on this? Is is a must have tool etc. Thanks..
    DESANTIS77_at_aol.comDESANTIS77_at_aol.com
    Jul 25, 2000 at 1:52 pm
    Jul 27, 2000 at 8:28 pm
  • One of my devlopers came to me today and asked me if our database was synchronous or asynchronous??? My response was WHAT??? He is stating that Segate Crystal reports is requiring us to be ...
    Christine TurnerChristine Turner
    Jul 18, 2000 at 3:58 pm
    Jul 21, 2000 at 2:39 pm
  • Is anyone currently running on HP-UX 11.0 64-bit? We have this new box and were trying to figure whether to install Oracle 8.1.5 32-bit or 64-bit. Has anyone had any positive or negative experiences ...
    Grabowy, ChrisGrabowy, Chris
    Jul 18, 2000 at 12:44 pm
    Jul 19, 2000 at 8:14 pm
  • We have a consultant at our shop who is convinced that Oracle is inadequate for a serious multi-user environment because of the lack of record locking and dynamic result sets. We have been using it ...
    Seth DunehewSeth Dunehew
    Jul 27, 2000 at 1:50 pm
    Jul 28, 2000 at 7:42 pm
  • --openmail-part-09772308-00000001 Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT" Content-Disposition: inline; filename="BDY.TXT" Content-Transfer-Encoding: 7bit Hi Listers, Came across ...
    John.j.kanagaraj_at_shell.com.bnJohn.j.kanagaraj_at_shell.com.bn
    Jul 7, 2000 at 1:34 am
    Jul 11, 2000 at 6:31 pm
  • This is a multi-part message in MIME format. --Boundary_(ID_yfLHQgKciZ+K6GWet43b/Q) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit I wanted to ask how people are ...
    Glenn TravisGlenn Travis
    Jul 12, 2000 at 4:03 pm
    Jul 20, 2000 at 5:05 pm
  • Hi again, listers! I had to suspend the test I was doing on AIX 4.3.2 because the = enviroment I really have to test is Oracle 8.1.5 on AIX 4.3.3 and prove that our applications work without any ...
    Veronica LevinVeronica Levin
    Jul 13, 2000 at 10:53 pm
    Jul 15, 2000 at 7:57 pm
  • I've just completed the installation of OEM 2.1 on an NT client, to manage = our 7.3.4 databases on Solaris. It appears that I do not have the = Intelligent Agent installed on my Unix boxes. Is it ...
    Kristen CameronKristen Cameron
    Jul 25, 2000 at 6:00 pm
    Jul 31, 2000 at 3:14 pm
  • Hi I have a table called EMP EMPNO NAME JOB 001 Scott DBA 002 Tiger DEV 003 King MAN ...... 0010 Arthur PROG If I need to update the column EMPNO and change all the values in the = beginning from 00 ...
    Suhen PatherSuhen Pather
    Jul 25, 2000 at 9:45 am
    Jul 26, 2000 at 7:57 am
  • Hi, One of my customer has forgotten the password for sys and system user.Is there anyway of changing the password. Ravindra
    B, RavindraB, Ravindra
    Jul 19, 2000 at 5:30 am
    Jul 19, 2000 at 3:44 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0011_01BFF015.BB654960 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi all, i had a ...
    PaulPaul
    Jul 17, 2000 at 10:37 pm
    Jul 19, 2000 at 11:23 am
  • Hi all, We are currently on 8051 on DG (dgux dev R4.20MU03 generic AViiON) platform, and are considering 816 upgrade. Generally speaking will this be a smooth upgrade or there are things to worry ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jul 17, 2000 at 3:44 pm
    Jul 18, 2000 at 9:08 pm
  • hi, all, I decide to pass my OCP DBA in two months. But I do not if I directly choose Oracle8i test package or choose Oracle8 test package and then have a Oracle8i new features test. One of my friend ...
    Xiaoliang ChenXiaoliang Chen
    Jul 12, 2000 at 5:05 pm
    Jul 14, 2000 at 9:47 am
  • I just want a SQL query to give me the freespace in all tablespaces. This doesn't work: select a.tablespace_name, sum(a.bytes) TOTAL_SPACE, sum(b.bytes)a FREE_SPACE from sys.dba_data_files a, ...
    Blair_at_pjm.comBlair_at_pjm.com
    Jul 11, 2000 at 12:50 pm
    Jul 11, 2000 at 6:02 pm
  • Hello everyone, OK, I was hoping this would be a really simple update, and that I could knock it out real quick. After working on it unsuccessfully for three hours now, I'm beginning to worry about ...
    Yexley Robert D SSgt AFIT/SCAYexley Robert D SSgt AFIT/SCA
    Jul 21, 2000 at 7:00 pm
    Jul 24, 2000 at 5:14 pm
  • Oracle was brought down for unknown reason. Does anybody know where is the syslog file for Sun? Thanks Linda
    Linda WangLinda Wang
    Jul 13, 2000 at 2:45 pm
    Jul 17, 2000 at 4:35 pm
  • We're getting the following messages in the alert log. Can a kind soul in the list enlighten me with potential problems and the possible cause? Thanks in advance. Thread 1 advanced to log sequence ...
    Achoto_at_american.eduAchoto_at_american.edu
    Jul 12, 2000 at 2:21 pm
    Jul 12, 2000 at 7:52 pm
  • I can connect remotely from other tools (Toad, Oracle for NT), and I can connect by just typing: connect system/manager ... but if I try to connect through: connect system_at_lat I lose - and it ...
    Adam TurnerAdam Turner
    Jul 7, 2000 at 9:24 pm
    Jul 10, 2000 at 3:17 pm
  • Hello, For security reasons i have changed the internal password with the help of ORAPWD80. After that whenever i restart the server, oracle is not auto started and i have to start it explicitly. I ...
    Ravi BabuRavi Babu
    Jul 6, 2000 at 9:19 am
    Jul 6, 2000 at 10:37 pm
  • But is that really where we belong? I know a lot of users and managers consider us to be some kind of lackeys who exist only to serve their whims, but I think there's a professional element to the ...
    Gait, ChristopherGait, Christopher
    Jul 1, 2000 at 3:07 am
    Jul 3, 2000 at 8:58 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_01BFF63D.D174B3AC Content-Type ...
    Babu.nagarajan_at_mail.iflexsolutions.comBabu.nagarajan_at_mail.iflexsolutions.com
    Jul 25, 2000 at 12:37 pm
    Jul 31, 2000 at 10:06 am
  • Does anyone on the list have any experience with the use of Terminal Server (on a Windows 2000 server) to deploy in-house applications? We have decided to evaluate the deployment of several ...
    Gary NorwellGary Norwell
    Jul 24, 2000 at 8:23 pm
    Jul 27, 2000 at 4:42 pm
  • Hi all, Yeah yeah, I should know this, but I'm just out of a two weeks 'Forget it all'-vacation, and I simply can't remember and don't have the necessary docs to find it. There are several ...
    Weerd de E.C. KirstenWeerd de E.C. Kirsten
    Jul 26, 2000 at 8:35 am
    Jul 26, 2000 at 8:27 pm
  • Anyone have a link to oracle white papers? Specifically, I am looking for the one on minimizing fragmentation, but I would like a link where I can browse many of the others. Thanks, Dave Turner
    David TurnerDavid Turner
    Jul 12, 2000 at 10:36 pm
    Jul 18, 2000 at 6:58 am
  • Hi All, Oracle 8.1.6 appears to think that ... trunc(log(2, 4)) = 1. SQL select trunc(log(2,4)) from dual; TRUNC(LOG(2,4)) --------------- 1 Does it reproduce on earlier versions? Regards, Steve ...
    Steve AdamsSteve Adams
    Jul 12, 2000 at 4:10 am
    Jul 12, 2000 at 5:07 pm
  • What is the executable under $ORACLE_HOME that I run to see what Oracle7 products (and versions) are installed? tia, ..tom
    Blair_at_pjm.comBlair_at_pjm.com
    Jul 5, 2000 at 7:13 pm
    Jul 10, 2000 at 10:37 pm
  • Hi list - CA (Computer Associates) has a HUGE (approximately 115x90 cm - I haven't = found a place to hang it yet - and I have a real office, not a cubicle) 8i Data= Dictionary poster. They gave it ...
    Oracle DBA ShluchotOracle DBA Shluchot
    Jul 5, 2000 at 9:57 am
    Jul 10, 2000 at 12:43 pm
  • A third party is doing an install with Oracle 8i on and NT box that we've provided. It happens to have 2 NIC cards in it. They say they can't get the listener to work because it has 2 NIC cards. I've ...
    Robert EskridgeRobert Eskridge
    Jul 5, 2000 at 3:40 pm
    Jul 6, 2000 at 9:01 am
  • To: Multiple recipients of list ORACLE-L Subject: DO I GIVE PROGRAMMERS ORACLE DBA ACCOUNT? Sending this again, Because I did not have a subject last time. I sure would appreciate some opinions on ...
    Khedr, WaleedKhedr, Waleed
    Jul 24, 2000 at 8:51 pm
    Jul 31, 2000 at 11:14 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_04D6_01BFF65E.C031EF80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear All =20 Can ...
    JohnsonJohnson
    Jul 25, 2000 at 12:05 pm
    Jul 29, 2000 at 1:46 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_01BFF79D.885F61D0 Content-Type ...
    Uma Sankara_SivadanamUma Sankara_Sivadanam
    Jul 27, 2000 at 7:37 am
    Jul 28, 2000 at 5:05 pm
  • --0-846930886-964201580=:7528 Content-Type: text/plain; charset=us-ascii Some time ago I thought I saw something on the list about 8i having the ability to automatically collecet statistics on tables ...
    Chuck HamiltonChuck Hamilton
    Jul 21, 2000 at 5:46 pm
    Jul 28, 2000 at 3:01 pm
  • Hi listers! I was wondering if there is a way to cut a 63MB text file into small = pieces without opening it with vi. Thanks in advance! Saludos, Ver=F3nica Levin Enr=EDquez Administrador AIX ...
    Veronica LevinVeronica Levin
    Jul 27, 2000 at 4:34 pm
    Jul 28, 2000 at 1:55 pm
  • Hello good people (a little flattery never hurts!) - Has anybody found a way to pass a variable in a stored procedure that contains a " & " symbol without having to parse the data selected, search ...
    David BarbourDavid Barbour
    Jul 21, 2000 at 2:43 pm
    Jul 26, 2000 at 5:48 am
  • Hello All Our 24x7 database is in archive log mode, we do online backups to tape every other day.. However the archive logs (which there are a lot of) we only back them up when the destination dir is ...
    Sajid IqbalSajid Iqbal
    Jul 24, 2000 at 2:00 pm
    Jul 25, 2000 at 6:51 pm
  • Good afternoon Listers, env't: HP-UX 11.0, Oracle 8.1.5 (64 bit) I remember seeing on this list, some time back, a shell script that can be used to import a list of tables from a (compressed) schema ...
    StevenHaas_at_ebico.comStevenHaas_at_ebico.com
    Jul 18, 2000 at 6:34 pm
    Jul 20, 2000 at 9:05 am
  • I can't find a timer function in PL/SQL. Without a major development effort I'd like to QUICKLY write a monitoring script which executes a query at a given interval over a certain period of time ...
    Steve OrrSteve Orr
    Jul 18, 2000 at 4:00 pm
    Jul 19, 2000 at 3:05 am
  • Hi all, Could someone give me a brief about Oralce Rdb ?, What is ? What platform does it works? Thank you in advance for your atention, Jorge Alves.
    Jorge Luiz AlvesJorge Luiz Alves
    Jul 18, 2000 at 1:21 pm
    Jul 19, 2000 at 2:26 am
  • Hi all, I am asking this ques. only for my info. Suppose my online redolog corrupt then,what will be the message given by database and what action should be taken at this condition. My Oracle version ...
    Vijay PatidarVijay Patidar
    Jul 12, 2000 at 9:49 am
    Jul 17, 2000 at 7:36 am
  • Not sure what OS you are on, but with VMS the process just continues automatically without any restarts. You just end up with a trc file and mutiple entries in the alert log. Ernest Simard System ...
    Ernest SimardErnest Simard
    Jul 12, 2000 at 4:39 pm
    Jul 13, 2000 at 4:25 pm
Group Navigation
period‹ prev | Jul 2000 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions728
posts2,358
users487
websiteoracle.com

487 users for July 2000

Eric D. Pierce: 54 posts Jared Still: 41 posts Paquette stephane: 34 posts Steve Adams: 34 posts Ruth Gramolini: 33 posts Rachel Carmichael: 30 posts Dgoulet_at_vicr.com: 28 posts ARUN K C: 25 posts Thapliyal, Deepak: 25 posts Boivin, Patrice J: 24 posts Chuck Hamilton: 24 posts Suzy Vordos: 24 posts A. Bardeen: 21 posts Gaja Krishna Vaidyanatha: 21 posts Rahul: 21 posts Sandeep Kurliye: 21 posts Siva_Chintalapati: 21 posts Kimberly.smith_at_gmd.fujitsu.com: 20 posts Alex Hillman: 18 posts Janardhana Babu: 18 posts
show more
Archives