FAQ

Search Discussions

592 discussions - 2,708 posts

  • I know this has been discussed before and I have monitored the discussions but I am not sure that I have seen a clear summary and set of conclusions. I am trying to identify how much memory is used ...
    John.Hallas_at_vodafone.co.ukJohn.Hallas_at_vodafone.co.uk
    Oct 4, 2002 at 10:38 am
    Oct 7, 2002 at 2:38 pm
  • Hi, I have a 817 db on Win2000. The service is configured to be started automatically. But the database is not start up automatically. Everyday I need to manually issue Startup command. Also my ...
    Leslie LuLeslie Lu
    Oct 3, 2002 at 9:38 pm
    Oct 5, 2002 at 12:38 am
  • Hi all, Just thought I'd comment on the fact 9i R2 dbassist-created databases actually prompt for SYS and SYSTEM passwords now ... no more you-know-what. This just isn't on! You can't just go ...
    Grant AllenGrant Allen
    Oct 3, 2002 at 5:13 am
    Oct 4, 2002 at 1:38 am
  • Hi all, I'll be seeing the dark side of the force as I'll be the DBA on a DB2 UDB project. Is there a list like this one for DB2 ? Any links to DB2 stuff ? I'd be interested in documents showing the ...
    Paquette stephanePaquette stephane
    Oct 2, 2002 at 3:03 am
    Oct 2, 2002 at 3:43 pm
  • Does anyone here have the scoop on the Oracle Store? It's been down for at least a week. The web page says down for maintenance, but given the amount of time, I don't believe it. Thanks, Jared -- ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 31, 2002 at 8:23 pm
    Oct 31, 2002 at 10:28 pm
  • Hi, We are in a process of purchasing Oracle Database. This deal will include hands-on training as well. The course outline given by the dealer is as follows: * Database physical & logical ...
    Abdul AleemAbdul Aleem
    Oct 30, 2002 at 6:38 am
    Oct 31, 2002 at 6:29 pm
  • Hi I have setup dataguard on v8.1.7.4.I have been noticing some times the same archived log files shipped multiple at standby archival destination like arch_1_18959.arc ...
    Seema SinghSeema Singh
    Oct 18, 2002 at 8:03 pm
    Oct 31, 2002 at 6:08 pm
  • Am I looking for trouble by mixing an OLTP type database with a DSS type database? I currently have a relatively small database that is used for quick lookup type actions. The company wants to add a ...
    Rick StephensonRick Stephenson
    Oct 29, 2002 at 6:19 pm
    Oct 31, 2002 at 4:23 am
  • Hi, I want to get the list of rows which were updated(then commited) in a particular table say X on a specific date e.g yesterday. Is this possible and how ? Thanks Manoj. -- Please see the official ...
    Cosltemp-g.manoj_at_orbitech.co.inCosltemp-g.manoj_at_orbitech.co.in
    Oct 29, 2002 at 4:23 am
    Oct 30, 2002 at 4:13 pm
  • This is a multi-part message in MIME format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: jtesta_at_dmc-it.com Fat City Network Services -- 858-538-5051 ...
    Joe TestaJoe Testa
    Oct 26, 2002 at 3:03 am
    Oct 30, 2002 at 3:23 pm
  • Looks like I'm gonna implement a stand-by database on Windows 2000 using Oracle 8.1.7.4 Anyone have any good article, how-tos, caviots I need to consider or read up on? Lizz
    Lizz PenaLizz Pena
    Oct 29, 2002 at 3:23 pm
    Oct 30, 2002 at 5:09 am
  • This COPY script failure occurred when running in SQL*Plus on Windows NT. In SQL*Plus on (Unix) database server, runs just fine, so immediate problem solved. Shouldn't it work from PC, though? Paul ...
    Paul BaumgartelPaul Baumgartel
    Oct 25, 2002 at 8:24 pm
    Oct 29, 2002 at 4:29 pm
  • Hi, I'm trying to incorporate a procedure in a package that needs to run using a dblink name supplied at runtime. The dblink is used in the dml inside the procedure, but when I compile the package I ...
    Magaliff, BillMagaliff, Bill
    Oct 25, 2002 at 5:09 pm
    Oct 27, 2002 at 9:43 pm
  • One of our developers (not a duhveloper) has asked if I know how (step by step instructions) to deploy a 6i form to the web. He has only found theoretical info and needs more hands on info. I have no ...
    Fink, DanFink, Dan
    Oct 23, 2002 at 10:14 pm
    Oct 27, 2002 at 3:38 am
  • can some one point me in right direction to look for oracle applications documentations. I am specially interested in manufacturing and financials . thanks, oramagic
    Ora akOra ak
    Oct 25, 2002 at 9:01 pm
    Oct 26, 2002 at 12:18 am
  • Hi Listers, I am trying to find a way to know the schema name. Say, if I logged in as jjin01_at_ngd. When I run a program, how can I get the schema name which should be "ngd"? If I logged in as ...
    Joan HsiehJoan Hsieh
    Oct 24, 2002 at 9:34 pm
    Oct 25, 2002 at 8:53 pm
  • Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the ...
    Sam BootsmaSam Bootsma
    Oct 24, 2002 at 6:26 pm
    Oct 24, 2002 at 9:26 pm
  • I have ORACLE 8.1.7 on SUn Server. I have wield problem on create view. If I only use "select ..", I don't have error. But if I use "createor replace view ..select ...", I got error and I have DBA ...
    Dist cashDist cash
    Oct 24, 2002 at 12:13 am
    Oct 24, 2002 at 9:18 pm
  • Hi all, Trying here now since have tried to find it online and build the query myself. I need to figure out how much space a user/session is using of a rollback segment. I got the queries to show ...
    Leonard, GeorgeLeonard, George
    Oct 23, 2002 at 5:02 pm
    Oct 23, 2002 at 6:51 pm
  • You might be able to find what you need at this site. http://web.singnet.com.sg/~petermag/oracle.html Dave -----Original Message----- Sent: Tuesday, October 22, 2002 8:39 PM To: Multiple recipients ...
    Farnsworth, DaveFarnsworth, Dave
    Oct 23, 2002 at 2:43 pm
    Oct 23, 2002 at 6:46 pm
  • OS:WIN2K DB:Oracle 9.0.1 (ArchiveLog & Production) I'm facing those error with one my datafile. The datafile is 4GB. The datafile is in autoextend mode, so I don't aware about the datafile ...
    LynxidajaxLynxidajax
    Oct 23, 2002 at 6:58 am
    Oct 23, 2002 at 11:23 am
  • Thanks folks for your replies on my initial query. Just to clarify by example, how many named user licences would I need for a database with following users. Forgetting minimum purchase requirements ...
    O'Neill, SeanO'Neill, Sean
    Oct 22, 2002 at 11:58 am
    Oct 22, 2002 at 1:29 pm
  • Hi, I need to insert the total number of records all the tables into the table, MIGRATION_TABLE. I want to use the How do I obtain the count(*) into a variable in "dbms_sql.parse(cid, 'SELECT ...
    CHAN Chor Ling Catherine (CSC)CHAN Chor Ling Catherine (CSC)
    Oct 17, 2002 at 9:18 am
    Oct 21, 2002 at 4:53 pm
  • Anyone got an example for the following... I have a SQL Script that expects &1 passed into it, however, if &1 is not supplied I would like to use a default value and not stop to prompt the user. I am ...
    Post, EthanPost, Ethan
    Oct 18, 2002 at 9:23 pm
    Oct 18, 2002 at 10:58 pm
  • Hi, how do i round dates like this: Date = 01-01-1996 Return = 01-01-2000 or Date = 01-01-1992 Return = 01-01-1990 Thanks.
    Imran AshrafImran Ashraf
    Oct 18, 2002 at 10:08 am
    Oct 18, 2002 at 1:44 pm
  • Hi Everybody, Can anyone tell me how to use MD5 hashing algorithm in Oracle8I Or is there any built in package to encrypt the data in Oracle 8i. I have created the Application user table there I am ...
    Suman S KSuman S K
    Oct 16, 2002 at 12:48 pm
    Oct 16, 2002 at 6:46 pm
  • Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes ...
    Noble, Larry H.Noble, Larry H.
    Oct 16, 2002 at 2:34 pm
    Oct 16, 2002 at 5:28 pm
  • All I apologise I haven't had time to thank those who responded to my question about passing a list of variables to a stored procedure. There have been many fires burning here... so I haven't had ...
    Bob MetelskyBob Metelsky
    Oct 16, 2002 at 2:59 pm
    Oct 16, 2002 at 4:25 pm
  • Howdy, I have a table that has almost 2 million rows called eventqueueentry. The layout looks like this: Name Null? Type ----------------------------------------- -------- ...
    Carle, William T (Bill), ALCASCarle, William T (Bill), ALCAS
    Oct 15, 2002 at 9:10 pm
    Oct 16, 2002 at 4:04 pm
  • Hello Esteemed Gurus Pls advise....... We are trying to get Double Take to work on our site. Does anyone actually have this product working??? Salesperson claims Double Take is certified by Oracle - ...
    Denham EvaDenham Eva
    Oct 15, 2002 at 7:28 am
    Oct 16, 2002 at 2:59 pm
  • Hi all, For some reason my 9.0.1 windows install has no tkprof binary, so I'm trying to decipher some 10046 output. I've got a bunch of WAIT #1: nam='db file sequential read' ela= 6467 p1=7 p2=219340 ...
    Grant AllenGrant Allen
    Oct 16, 2002 at 3:03 am
    Oct 16, 2002 at 2:34 pm
  • I am looking for suggestions on how to brush up my skills and continue learning on a regular basis. Large blocks of "free time" are hard to come by, but if I had only 30 minutes (or an hour) a day, ...
    Warkentien, StephenWarkentien, Stephen
    Oct 15, 2002 at 10:33 pm
    Oct 16, 2002 at 12:03 pm
  • Dear List, We need to remove data from our database everyday, so we are plannning to have a scheduled process for this. But the case is that we cannot simply remove the data. This data has to be made ...
    Prem_at_ibsplc.comPrem_at_ibsplc.com
    Oct 15, 2002 at 12:38 pm
    Oct 16, 2002 at 12:46 am
  • Is there a way to make the autolayout feature produce a concise layout in Designer Entity Relationship Diagrammer? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & ...
    Boivin, Patrice JBoivin, Patrice J
    Oct 15, 2002 at 1:28 pm
    Oct 15, 2002 at 9:53 pm
  • On Moving the Storage Box from a SF6800 machine to SF15000 machine CPU Consumption has Shot by 25 % Particulars :- Number of CPUs on SF6800 = 24 with 750 MHz Clock Speed Number of CPUs on SF15000 = ...
    VIVEK_SHARMAVIVEK_SHARMA
    Oct 15, 2002 at 1:03 pm
    Oct 15, 2002 at 7:55 pm
  • Over the weekend we migrated all our production systems on 9201 on AIX. I know it is not all that important, but thought I'd let everyone know. I also learned the magic of commit=y/n setting on imp ...
    Jamadagni, RajendraJamadagni, Rajendra
    Oct 14, 2002 at 3:23 pm
    Oct 15, 2002 at 7:38 am
  • Hello All, This problem pertains to local bitmap index in dw env. We are using informatica to load our fact tables. i have a fact table partitioned on period key (range partition). We have built ...
    Sat0789_at_fastmail.fmSat0789_at_fastmail.fm
    Oct 14, 2002 at 11:03 pm
    Oct 15, 2002 at 4:18 am
  • Listers, I'll be digging into this a bit more, playing around with a 10053 trace, reviewing the stats, and trying to tie back why this occurs, but here's the scenario. 8.1.7.4 Partitioned table, by ...
    Larry ElkinsLarry Elkins
    Oct 12, 2002 at 4:03 pm
    Oct 14, 2002 at 12:23 am
  • Hi, found the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. Product ...
    Amar Kumar PadhiAmar Kumar Padhi
    Oct 9, 2002 at 10:08 am
    Oct 12, 2002 at 7:33 am
  • we plan to upfrade our database from ORACLE 8.1.7 to 9.2. The database on SUn Solaris server. My question are: will following version of ORACLE client(on PC) work with ORACLE 9.2 server? 7.3.4 client ...
    Dist cashDist cash
    Oct 11, 2002 at 2:23 pm
    Oct 12, 2002 at 3:53 am
  • We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships ...
    Schauss, PeterSchauss, Peter
    Oct 11, 2002 at 8:05 pm
    Oct 11, 2002 at 9:14 pm
  • Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL ...
    Freeman, RobertFreeman, Robert
    Oct 10, 2002 at 2:58 pm
    Oct 11, 2002 at 3:53 pm
  • INDEX ORACLE-L Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Joshua=20Becker?= INET ...
    Joshua BeckerJoshua Becker
    Oct 10, 2002 at 5:18 am
    Oct 10, 2002 at 4:34 pm
  • Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but ...
    Peter BarnettPeter Barnett
    Oct 9, 2002 at 7:09 pm
    Oct 10, 2002 at 3:44 pm
  • I don't work with Oracle Reports but one of my co-workers does. His problem --- TNS can't find the database. He has three Oracle homes. I've copied the good tnsnames.ora to all of his homes (I know ...
    Thomas DayThomas Day
    Oct 8, 2002 at 5:33 pm
    Oct 9, 2002 at 2:24 pm
  • Sure THanks Omar But I was looking for a 'non-file based' solution :) Thanks anyway -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET ...
    Cyril ThankappanCyril Thankappan
    Oct 8, 2002 at 8:23 am
    Oct 8, 2002 at 7:23 pm
  • Hi! Using a form, for sending messages with outlook, from Peter Koltez's site, I get this error ORA-305500, but unfortunately it is not listed in documentation. Any Help? TIA! Aleem -- Please see the ...
    Abdul AleemAbdul Aleem
    Oct 5, 2002 at 10:13 am
    Oct 7, 2002 at 7:03 am
  • Hi All, Oracle 8.1.6, WinNT I have view TIMEVIEW. I can do select * from timeview with no errors. If I select a individual column I get 904 error. I am doing everything from the schema owner. Any ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Oct 4, 2002 at 8:05 pm
    Oct 4, 2002 at 8:53 pm
  • Hi All, OPS 8.0.6.2 on Sun 2.6 nodes. The other day, the users reported that they were unable to complete transactions, and before we could take a proper look, the database was shutdown aborted, and ...
    Rajesh.Rao_at_jpmchase.comRajesh.Rao_at_jpmchase.com
    Oct 3, 2002 at 10:34 pm
    Oct 4, 2002 at 4:05 pm
  • Can anyone send me sample Pro*C code depicting how they've handled TAF in 8iOPS or 9iRAC ? We've got some application servers running Pro*C programs which don't seem to able to handle failover ...
    Hemant K ChitaleHemant K Chitale
    Oct 2, 2002 at 4:13 pm
    Oct 3, 2002 at 3:53 pm
Group Navigation
period‹ prev | Oct 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions592
posts2,708
users383
websiteoracle.com

383 users for October 2002

DENNIS WILLIAMS: 106 posts Jared.Still_at_radisys.com: 95 posts Tim Gorman: 79 posts Rachel Carmichael: 70 posts Deshpande, Kirti: 65 posts Dgoulet_at_vicr.com: 53 posts Yechiel Adar: 50 posts Jamadagni, Rajendra: 49 posts Naveen Nahata: 47 posts Fink, Dan: 45 posts Mercadante, Thomas F: 44 posts Jesse, Rich: 43 posts Rajesh.Rao_at_jpmchase.com: 38 posts Igor Neyman: 37 posts Gogala, Mladen: 36 posts Ray Stell: 35 posts Connor McDonald: 33 posts Grabowy, Chris: 31 posts Paquette stephane: 31 posts Rick_Cale_at_teamhealth.com: 31 posts
show more
Archives