FAQ

Oracle > oracle-l > October 2002

Search Discussions

592 discussions - 2,708 posts

  • Hello List, Has anyone installed Oracle 9.2.0.1 Enterprise on an HP machine running hpux 11i using VPAR's (Virtual Partitions)? I currently have an HP rp5470 with 2 virtual partitions (prod and ...
    Scott StefickScott Stefick
    Oct 31, 2002 at 11:01 pm
    Oct 31, 2002 at 11:01 pm
  • Dear List, I wrote the following bit of code yesterday to cause a process to kick off at a particular time. This was not doable via DBMS_JOB, as the code that follows this bit is a sqlplus script ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 31, 2002 at 10:35 pm
    Oct 31, 2002 at 11:04 pm
  • When a vendor says it isn't certified for a version, then it's best that you follow what the vendor says. I've seen a number of apps break when the database was upgraded. Sometimes just changing a ...
    Stephen LeeStephen Lee
    Oct 31, 2002 at 10:29 pm
    Oct 31, 2002 at 10:29 pm
  • There is a desire to consolidate some Unix servers. A couple of the servers are using Oracle 8.0.6 Standard (formerly Workgroup server) and the intended target servers already have 8.1.7 Enterprise ...
    David DavisDavid Davis
    Oct 31, 2002 at 9:49 pm
    Oct 31, 2002 at 9:49 pm
  • Dear List, First, a little background. A coworker and I have been charged with developing and implementing a 'short term' 'Reporting Solution'. Glossary: short term: low cast, fast to implement, ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 31, 2002 at 9:48 pm
    Oct 31, 2002 at 10:45 pm
  • Hi Hoyt, Let me know exactly what you need . I can give some ideas . May not be the code, cuz my company closed recently and I am looking out for another job . :)Let me know you if you have something ...
    BigPBigP
    Oct 31, 2002 at 9:14 pm
    Oct 31, 2002 at 9:14 pm
  • Looks like new articles are now formatted in the familiar Oracle Portal style: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=107182.1 At least these ...
    Jesse, RichJesse, Rich
    Oct 31, 2002 at 9:14 pm
    Oct 31, 2002 at 9:14 pm
  • Announcement Optimising Oracle: Performance by Design a 3-day seminar by Jonathan Lewis Jonathan Lewis will conduct his "Optimising Oracle" seminar in the Dallas/Fort Worth area this November 19-21 ...
    Cary MillsapCary Millsap
    Oct 31, 2002 at 8:59 pm
    Oct 31, 2002 at 11:38 pm
  • free linux cluster s/w, have not tried it, but will: http://slashdot.org/article.pl?sid=02/10/30/1858241 http://clic.mandrakesoft.com/index-en.html Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC ...
    Ray StellRay Stell
    Oct 31, 2002 at 8:53 pm
    Oct 31, 2002 at 8:53 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, What do you think about multiples schemas versus 1 schema, pros and cons. For example, having the schemas: stage, dw, metadata or only dw. I have my ideas but I want to check if do not missed ...
    Paquette stephanePaquette stephane
    Oct 31, 2002 at 8:09 pm
    Oct 31, 2002 at 9:28 pm
  • Reboot and open a TAR. Jared "Sinardy Xing" Sent by: root_at_fatcity.com 10/31/2002 12:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: Subject: RE: Unkillable Background ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 31, 2002 at 7:44 pm
    Oct 31, 2002 at 10:40 pm
  • I always like to create my databases by hand via the create database statement. However, whenever a new version comes out I use the dbca assistant to generate the create database script so I can see ...
    Adams, Matthew (GECP, MABG, 088130)Adams, Matthew (GECP, MABG, 088130)
    Oct 31, 2002 at 7:41 pm
    Oct 31, 2002 at 10:40 pm
  • I'm trying to set up auditing for granting and revoking privileges on objects. I thought this could be done with the command: audit grant on default; When I issued this command on a development ...
    Miller, JayMiller, Jay
    Oct 31, 2002 at 6:23 pm
    Oct 31, 2002 at 6:23 pm
  • Solaris 8 Oracle 8.1.7.3 We have a field level_id defined as raw(5) in a table called objects. I can pull data from this table from sqlplus as follows: select name, obj_id, level_id from objects ...
    Baker, BarbaraBaker, Barbara
    Oct 31, 2002 at 5:49 pm
    Oct 31, 2002 at 8:28 pm
  • What is the next release of Oracle 9i database (92020 ??) and when will it be released for Windows 2000 (Next Week ??;-) ) Thanks Steve Parker E Mail: steve.parker_at_lis.co.uk -- Please see the ...
    Steve.Parker_at_lis.co.ukSteve.Parker_at_lis.co.uk
    Oct 31, 2002 at 5:28 pm
    Oct 31, 2002 at 8:03 pm
  • I have 2 questions regarding the machine column in V$SESSION. It shows just the machine name of the server for all the background processes, but for all user connections it shows domain\machine_name ...
    Naveen NahataNaveen Nahata
    Oct 31, 2002 at 4:28 pm
    Oct 31, 2002 at 9:08 pm
  • Hello Red Hat advanced server or Suse Enterprise ? What is better with Oracle ? What is more recent (kernel 2.4.19, asynch I/O, big mem, etc) ? -- Please see the official ORACLE-L FAQ ...
    Juan MirandaJuan Miranda
    Oct 31, 2002 at 3:53 pm
    Oct 31, 2002 at 8:38 pm
  • Hi, We're in the process of writing functionnal specs for a system which is like a DW but instead of a DW the staging area push the data in Siebel. If we replaced null by something else. What would ...
    Paquette stephanePaquette stephane
    Oct 31, 2002 at 2:58 pm
    Oct 31, 2002 at 9:14 pm
  • Our developers are proposing a database design for an OLTP application in which each table has a PK of the same type and size. In addition, each possible PK value can belong to at most one table ...
    Brian P AndrewsBrian P Andrews
    Oct 31, 2002 at 1:33 pm
    Oct 31, 2002 at 11:04 pm
  • Dear Friends, Does anybody help me to defrag / reorganise the user tablespaces which is large in size. Is there any script for that ? If available can somebody send it to me ? Regards, Pradeep ...
    Pradeep_at_ibsplc.comPradeep_at_ibsplc.com
    Oct 31, 2002 at 12:13 pm
    Oct 31, 2002 at 4:28 pm
  • May sound a bit naive, but what is the difference(if any) between Hidden and Undocumented Parameters Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen ...
    Naveen NahataNaveen Nahata
    Oct 31, 2002 at 11:33 am
    Oct 31, 2002 at 11:58 am
  • Jared, We are certainly going to be performing extensive testing to ensure performance of our applications under Raid5+ is acceptable. That means it is as good if not better than that experienced ...
    John HallasJohn Hallas
    Oct 31, 2002 at 8:33 am
    Oct 31, 2002 at 5:34 pm
  • hi list We are planning to migrate our database from 8i to 9i soon, i had the idea to use the migrate utility from oracle. So far so good, but at one moment i have 2 OFA compliant software trees on ...
    GKor_at_rdw.nlGKor_at_rdw.nl
    Oct 31, 2002 at 8:13 am
    Oct 31, 2002 at 3:43 pm
  • Hi all, When I do shutdown abort my LGWR and CKPT still around and also kill -9 cannot get rid of them anyone know why ? because of this my cluster fail to failover Thanks Sinardy -- Please see the ...
    Sinardy XingSinardy Xing
    Oct 31, 2002 at 7:43 am
    Oct 31, 2002 at 8:28 am
  • Is there any way to set the LONG chunk size on the database for all queries? The "set long " command works fine in SQL Plus to set the chunk size of LONG but when .NET pulls info, it doesn't work. Is ...
    Mike SardinaMike Sardina
    Oct 31, 2002 at 1:08 am
    Oct 31, 2002 at 3:13 pm
  • Friends I would like to know about snapshots. Can I create a index on snapshot ? How to do it ? Why refresh with rowid is not recomended ? How to do when master table doesn't have a PK ? Regards ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Oct 31, 2002 at 1:03 am
    Oct 31, 2002 at 2:03 pm
  • Advice for those seeking to have the Internals seminars presented in their area/region/continent (from Lex de Haan, original curriculum developer of the Internals seminars series, based in Oracle ...
    Tim GormanTim Gorman
    Oct 30, 2002 at 11:58 pm
    Oct 31, 2002 at 8:38 pm
  • forwarded on at Dave's request. Bruce Reardon -----Original Message----- Sent: Thursday, 31 October 2002 4:03 AM To: Reardon, Bruce (CALBBAY) Hi Bruce The application user owns the AQ tables and put ...
    Reardon, Bruce (CALBBAY)Reardon, Bruce (CALBBAY)
    Oct 30, 2002 at 10:34 pm
    Oct 30, 2002 at 10:34 pm
  • Robin, I will copy this reply to the Oracle list as there are many more experienced people there. Have you followed the steps in Metalink note 146599.1? If so, what results did you get from the ...
    Reardon, Bruce (CALBBAY)Reardon, Bruce (CALBBAY)
    Oct 30, 2002 at 10:29 pm
    Oct 30, 2002 at 10:29 pm
  • Hi Gurus, Hardware: HP rp5470 OS: HP-UX 11i (11.11) Oracle Version: Enterprise Edition 9.2.0.1.0 I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is trying to create and start the ...
    Scott StefickScott Stefick
    Oct 30, 2002 at 10:03 pm
    Oct 31, 2002 at 11:48 pm
  • Hi listers, We are testing the Windows 2000 Server Terminal Server to execute a payroll application developed in Developer6i (reports,forms). Users can execute and print locally, but when they ...
    Veronica LevinVeronica Levin
    Oct 30, 2002 at 9:48 pm
    Oct 30, 2002 at 9:48 pm
  • There is an oracle bug where rmjvm.sql is not on the 8.1.6 distribution kit. If anyone has it can you send offline as I cannot locate it on the web. Oracle says unix and version are the same so ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Oct 30, 2002 at 9:23 pm
    Oct 30, 2002 at 9:23 pm
  • Is it possible to set database time to GMT while server time is local? Is this possible on 8.1.7.4 on HP-UX and 9.0.1 on Windows2000? Any advice is appreciated as I am starting to look into this ...
    Fedock, John (KAM.RHQ)Fedock, John (KAM.RHQ)
    Oct 30, 2002 at 8:58 pm
    Oct 30, 2002 at 10:58 pm
  • I thought I'd pass on the following link to a data dictionary article of mine that just went live on the O'Reilly Network: http://www.oreillynet.com/pub/a/network/2002/10/28/data_dictionary.html?p= ...
    Listmail_at_gennick.comListmail_at_gennick.com
    Oct 30, 2002 at 6:42 pm
    Oct 31, 2002 at 4:23 am
  • We have problem on ORACLE on NT (Oracle 8.1.7). The oracle.exe show it use 100% CPU usage, but their is NO user inside ORACL (select usrname from v$session). I used to remember NT resource kit have ...
    Dist cashDist cash
    Oct 30, 2002 at 6:34 pm
    Oct 31, 2002 at 1:43 pm
  • Yes we are using AQ quite a lot for interacting with external processes . We are having separate tablespace to hold queue data . -oramagic Original Message ----- To: "Multiple recipients of list ...
    BigPBigP
    Oct 30, 2002 at 5:33 pm
    Oct 30, 2002 at 5:33 pm
  • I am having problems getting OS authentication to work on a Win2K oracle server (8.1.7.1.1). All parameters are set properly (from what I can see). There cannot be a prefix so the following parameter ...
    Mike SardinaMike Sardina
    Oct 30, 2002 at 5:24 pm
    Oct 31, 2002 at 7:40 pm
  • Our Data Warehouse application is using 8.1.7.3 of Oracle. We have been experiencing the following in our production database : "Errors in file ...
    Rudy MorenoRudy Moreno
    Oct 30, 2002 at 5:24 pm
    Oct 30, 2002 at 5:24 pm
  • Hello list... has anyone participated in head-to-head benchmarks for DSS - data warehouse - specific environments... using Oracle, DB2 or Teradata? I am tyring to identify appropriate comparison ...
    Nathan WenigNathan Wenig
    Oct 30, 2002 at 5:13 pm
    Oct 30, 2002 at 5:13 pm
  • Tres Bien! ____________________Reply Separator____________________ rofesi=F3n_ Author: "Sherman; Paul R." Date: 10/29/2002 2:49 PM Hello, Well, I for one got enough of the message to make me curious, ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 30, 2002 at 4:49 pm
    Oct 30, 2002 at 5:24 pm
  • Good day, all Has anyone come across (or put together) a feature comparison of the various large-scale db's? Looking for stuff as detailed as max length for table/column names, ability to create/use ...
    Magaliff, BillMagaliff, Bill
    Oct 30, 2002 at 4:23 pm
    Oct 30, 2002 at 4:23 pm
  • I was reading one of the papers on the quest website about data modeling. An example was presented and I did not believe the results so I tried it out. Of course the writer ( Phd) was correct. Does ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Oct 30, 2002 at 4:08 pm
    Oct 31, 2002 at 1:33 am
  • the only way i see it can work is to implement a snapshot in the remote database and create a trigger there. regards Paulo -----Original Message----- Sent: quarta-feira, 30 de Outubro de 2002 15:09 ...
    Paulo GomesPaulo Gomes
    Oct 30, 2002 at 3:38 pm
    Oct 30, 2002 at 6:20 pm
  • Greetings All, We have a before insert trigger on a table. We want this trigger to fire when the data is inserted locally and don't want this trigger to fire when the insert is done from a remote ...
    Mandal, AshokeMandal, Ashoke
    Oct 30, 2002 at 3:09 pm
    Oct 30, 2002 at 3:09 pm
  • I'm sitting in front of a networked PC, running RedHat 7.2 and Oracle 9i 9.0.1.0.0. I also have a networked Windows2000 box with Forms 6i on it, upon which I have managed to build a simple form on ...
    Maria QuinnMaria Quinn
    Oct 30, 2002 at 12:03 pm
    Oct 30, 2002 at 12:48 pm
  • Hello What are the limitations of partitioning a table in Oracle. Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: PK_Deepa/VGIL_at_vguard.satyam.net.in ...
    PK_Deepa/VGIL_at_vguard.satyam.net.inPK_Deepa/VGIL_at_vguard.satyam.net.in
    Oct 30, 2002 at 8:43 am
    Oct 30, 2002 at 5:39 pm
  • Hi, I've sent a couple of questions on queues and got no answers - that's fine and I understand we're all busy. What I'm wondering though is whether anyone is actually using Oracle queues at all? Any ...
    Reardon, Bruce (CALBBAY)Reardon, Bruce (CALBBAY)
    Oct 30, 2002 at 6:58 am
    Oct 30, 2002 at 6:14 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
  • Hello We are doing database design for a project. We have 10 distinct transactions types and the total number of records is expected to be around 5,00,000 taking all transactions together.We have ...
    PK_Deepa/VGIL_at_vguard.satyam.net.inPK_Deepa/VGIL_at_vguard.satyam.net.in
    Oct 30, 2002 at 6:28 am
    Oct 31, 2002 at 4:53 am
Oct 2002
12345…12
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