FAQ

Oracle > oracle-l > October 2002

Search Discussions

592 discussions - 2,708 posts

  • 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
  • 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
  • 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
  • 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
  • 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
  • As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 24, 2002 at 4:29 pm
    Oct 31, 2002 at 10: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
  • 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
  • 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
  • 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
  • Dear list, Though I won't be attending OOW, I will be in San Francisco during those same dates ( 11/10 - 11/15), just a couple miles from the Moscone Center where OOW is held. Are there any plans yet ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 21, 2002 at 11:19 pm
    Oct 31, 2002 at 10:29 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Hi list Please input why my boss must invest into oracle rather than the cheaper mssql. His opinion is that most features are almost the same but mssql does that at half the price as oracle does. So ...
    GKor_at_rdw.nlGKor_at_rdw.nl
    Oct 23, 2002 at 7:38 am
    Oct 31, 2002 at 9:08 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
  • 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
  • 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
  • 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 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
  • 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
  • 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
  • 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
  • We're moving from RBO to CBO. For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS? And why? My thinking is if it's a database where most of the querying is done on small sets of ...
    Armstead, Michael AArmstead, Michael A
    Oct 29, 2002 at 9:13 pm
    Oct 31, 2002 at 5:54 pm
  • 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
  • I am reposting this. Has anyone tried to convert a dictionary managed table space containing lots of data to locally managed? We have tried this out successfully on empty table spaces or created a ...
    Govind.Arumugam_at_alltel.comGovind.Arumugam_at_alltel.com
    Oct 29, 2002 at 2:43 am
    Oct 31, 2002 at 5:13 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
  • A quick question out to the masses.. How many of you out there are ACTUALLY USING 9i RAC technology? If not already using it - how many have plans to use it (or at least plan to investigate it)? ...
    Mark LeithMark Leith
    Oct 29, 2002 at 4:29 pm
    Oct 31, 2002 at 4:13 pm
  • Yes - and I just completed stress-testing an OLTP database where we went from 2 distinct 'filesystems' for data files to 12 separate filesystems. Average wait times for I/O dropped from 40 - 50 msec ...
    John KanagarajJohn Kanagaraj
    Oct 30, 2002 at 2:13 am
    Oct 31, 2002 at 4:13 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
  • 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
  • Dear gurus ! We are trying to analyze a table partition (estimate 2 %) and it takes forever. analyze table ... partition (P20021022) estimate statistics sample 2 percent; For instance, select ...
    Andrey BronfinAndrey Bronfin
    Oct 29, 2002 at 3:49 pm
    Oct 31, 2002 at 2:03 pm
  • 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
  • Hi guys I am trying to create the following trigger. The user in question is logging in using siebel application and siebel does not allow multiple SQL statements during login so we through this ...
    George Leonard (ZA)George Leonard (ZA)
    Oct 2, 2002 at 3:23 pm
    Oct 31, 2002 at 1:23 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
  • 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
  • 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
  • Hi all System is Siebel Ok I got a couple of tables about 6 GB big, up to 10 million rows. Some of the tables come out of the box with 30+ indexes, now for those not aware Siebel does not support the ...
    Leonard, GeorgeLeonard, George
    Oct 29, 2002 at 8:38 pm
    Oct 31, 2002 at 4:33 am
  • Excellent read. Got mine today from amazon. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: jtesta_at_dmc-it.com Fat City Network Services -- ...
    Joe TestaJoe Testa
    Oct 29, 2002 at 12:59 am
    Oct 31, 2002 at 4:29 am
  • 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
  • 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
  • list, i'm in the process of recommending Oracle as a "completel solution" for a;large data warehouse (for a central bank) . After doing thru some of the documentation on OTN ..i have the following ...
    RahulRahul
    Oct 30, 2002 at 4:18 am
    Oct 31, 2002 at 1:38 am
  • 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
  • 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
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