FAQ

Oracle > oracle-l > November 2002

Search Discussions

471 discussions - 2,199 posts

  • Dear List, Believe me, I am not trying to rehash an old topic, start any flame wars, nor look for supporting evidence for my admitted bias toward unix operating systems. Now that that's out of the ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Nov 11, 2002 at 11:13 pm
    Nov 14, 2002 at 3:54 pm
  • Challenge: present SQL results hierarchically and sort the nodes. Use sort column without changing data. Here's the DDL/DML to start: create table treenode ( id number not null constraint pk_treenode ...
    Orr, SteveOrr, Steve
    Nov 5, 2002 at 5:24 pm
    Nov 7, 2002 at 4:44 pm
  • Dear List, I need some inputs from you all regarding purging data from the database. This is the requirement We define a retention period for all the data in the system. When the retention period is ...
    Prem_at_ibsplc.comPrem_at_ibsplc.com
    Nov 6, 2002 at 9:13 am
    Nov 12, 2002 at 3:39 pm
  • Dear list, Let me toss a hypothetical situation at you. Say some auditors looked at some of your primary systems, and concluded that they had no assurance that someone with admin access to the server ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Nov 26, 2002 at 11:05 pm
    Nov 29, 2002 at 11:18 pm
  • Any rumours about what might be included in 10i? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | ...
    Boivin, Patrice JBoivin, Patrice J
    Nov 12, 2002 at 12:59 pm
    Nov 25, 2002 at 7:50 pm
  • Hi: We have oracle 8173 running on Sun Solaris box. The current redo files are: /oracle/oradata/RPT1/redo101.log /oracle/oradata/RPT1/redo201.log /oracle/oradata/RPT1/redo301.log ...
    Guang MeiGuang Mei
    Nov 26, 2002 at 1:54 am
    Nov 30, 2002 at 3:44 pm
  • Board - If you had to choose the 10 top posters here at Oracle-L who provided the biggest input and knowledge, who would they be? Who are the top 10 Oracle Guru's on this news group? I'm asking ...
    Freeman, RobertFreeman, Robert
    Nov 25, 2002 at 10:04 pm
    Nov 27, 2002 at 1:18 pm
  • We are on 9.2.0.2, Solaris 8 on Sunfire 3800 with 16 GB memory and 128 MB on a hardware-controlled, mirrored RAID5 StorEdge T-3 Array. Periodically throughout the day the LGWR background process ...
    Deborah LorraineDeborah Lorraine
    Nov 26, 2002 at 6:00 pm
    Nov 29, 2002 at 3:43 pm
  • I've got a real hot project (8.1.7.2 on HP/UX 11.0) that needs to have NULLs converted to spaces on three different columns. Each is a CHAR, so I shouldn't need to worry about chaining, since that ...
    Jesse, RichJesse, Rich
    Nov 25, 2002 at 9:03 pm
    Nov 27, 2002 at 8:04 pm
  • Don't believe me?? Try this: create table test(the_date date); insert into test values (to_date('10-05-1582','mm-dd-yyyy') ); select to_char(the_date, 'mm/dd/yyyy') from test; What do you get? :-)) ...
    Freeman, RobertFreeman, Robert
    Nov 22, 2002 at 5:55 pm
    Nov 25, 2002 at 1:49 pm
  • Has anyone heard when Oracle will be releasing version 10i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pall, Tom [Contractor] INET: tpall02_at_sprintspectrum.com Fat ...
    Pall, Tom [Contractor]Pall, Tom [Contractor]
    Nov 7, 2002 at 6:09 pm
    Nov 12, 2002 at 3:04 pm
  • Hello Everyone, I have now made the humungous decision to start studying and to write the OCP exams. Do I study out of the Oracle Manuals? I do have the Sybex Study Guides, would studying these be ...
    Denham EvaDenham Eva
    Nov 5, 2002 at 12:08 pm
    Nov 6, 2002 at 9:08 pm
  • Dear All, We are in the process of making a DB monitoring tool, can anyboyd suggest what all things can be monitored. I know that OEM can be used, but then this cannot be distributed to the client ...
    Prem_at_ibsplc.comPrem_at_ibsplc.com
    Nov 1, 2002 at 7:23 am
    Nov 4, 2002 at 1:13 pm
  • Okay, so I'm trying to get costs for conferences etc so my boss can budget for them. I go to the IOUG site and look at costs for the 2003 conference. I see "register online" so I click on it. They ...
    Rachel CarmichaelRachel Carmichael
    Nov 27, 2002 at 3:03 pm
    Nov 28, 2002 at 3:48 pm
  • Anyone interested in an Oracle-L get together at UKOUG for those of us poor souls who were not able to attend Oracle World? OW attendees welcome also! Dan Fink -- Please see the official ORACLE-L ...
    Fink, DanFink, Dan
    Nov 19, 2002 at 8:19 pm
    Nov 22, 2002 at 11:38 am
  • So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), ...
    Jesse, RichJesse, Rich
    Nov 11, 2002 at 4:58 pm
    Nov 13, 2002 at 1:48 pm
  • I am just starting to look at converting to the cost based optimizer, and am hoping a few of you can share insights from having done so in the past. Our application is an oltp system developed on ...
    Steve McClureSteve McClure
    Nov 19, 2002 at 9:13 pm
    Nov 26, 2002 at 4:58 am
  • Stephen, This is the *same* restaurant (just across the street from Moscone in fact) that we met last OOW, again reserved by Gerardo. I am sure that Gaja will find some 'veggie' stuff, as he did the ...
    John KanagarajJohn Kanagaraj
    Nov 1, 2002 at 9:18 am
    Nov 4, 2002 at 12:43 am
  • Friends ... I have a (sort of) problem ... what are the best practices to manage code releases to production environment ... currently we get a bunch of scripts from development team, and we release ...
    Jamadagni, RajendraJamadagni, Rajendra
    Nov 13, 2002 at 3:29 pm
    Nov 14, 2002 at 5:54 pm
  • I have a 9.2 database running on Solaris 8. I'm creating some test tables with indexes. The USER_INDX tablespace's datafile is set to autoextend (as are TEMP and USER_DATA). When the system attempts ...
    Fink, DanFink, Dan
    Nov 7, 2002 at 3:39 pm
    Nov 10, 2002 at 3:48 pm
  • Hello, What are the major differences between AIX and Solaris regarding operating system features? We are planning a new machine purchase; currently we are on a Sun machine running Solaris, but IBM ...
    Becker.bill_at_marshfieldclinic.orgBecker.bill_at_marshfieldclinic.org
    Nov 13, 2002 at 6:48 pm
    Nov 20, 2002 at 2:13 pm
  • I create a table to store user account information and set "userid" column to be primary key. I now want to set "username" to be primary key instead of "userid", how do I change it? There are couple ...
    Nguyen, David MNguyen, David M
    Nov 7, 2002 at 8:33 pm
    Nov 11, 2002 at 9:23 am
  • Fellow DBAs and other DBA wannabes, Ever wondered the best path into a DBA career? Microsoft offers a brilliant way. MSN Careers at http://editorial.careers.msn.com/articles/nofuture/ suggests some ...
    Arup NandaArup Nanda
    Nov 26, 2002 at 1:48 am
    Nov 28, 2002 at 2:48 pm
  • ORACLE -L NO MAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: prem_at_ibsplc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, ...
    Prem_at_ibsplc.comPrem_at_ibsplc.com
    Nov 1, 2002 at 11:58 am
    Nov 26, 2002 at 12:08 am
  • Dist - Since nobody seems to have responded, I'll take a crack at it. The Oracle9i documentation specifically says (in the Oracle9i Database Reference) that either FAST_START_IO_TARGET or ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Nov 19, 2002 at 1:58 pm
    Nov 20, 2002 at 5:58 pm
  • I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet. We now have a need for this. Could anyone enlighten me? Thank you in advance. Laura -- Please see ...
    Burton, Laura L.Burton, Laura L.
    Nov 6, 2002 at 6:48 pm
    Nov 7, 2002 at 2:24 pm
  • OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move. So, is there any other option to move these tables from one ...
    Hand, Michael THand, Michael T
    Nov 25, 2002 at 3:59 pm
    Nov 29, 2002 at 12:43 am
  • Is there an easy query to get a list of tables that don't have any primary key? I've tried a couple of different ones, but none of them work quite right. Seems like this should be easy. -- Please see ...
    Mike SardinaMike Sardina
    Nov 26, 2002 at 7:25 pm
    Nov 27, 2002 at 10:19 am
  • Good morning, Can anyone send my the sql to find the system process being used by an oracle session. I know this has been out here before, but I can't find it in my saved stuff. Thanks in advance, ...
    Ruth GramoliniRuth Gramolini
    Nov 22, 2002 at 2:53 pm
    Nov 22, 2002 at 7:13 pm
  • I just found out today that we have a major development initiative that is starting and they are planning on using Pro*Cobol to develop the application. (my head is still shaking in disbelief!!!) So ...
    Babette Turner-UnderwoodBabette Turner-Underwood
    Nov 15, 2002 at 10:24 pm
    Nov 21, 2002 at 4:58 am
  • The Sys. Admin. team wants to consolidate storage (and probably get a new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to ...
    David WagonerDavid Wagoner
    Nov 8, 2002 at 2:58 pm
    Nov 18, 2002 at 5:58 pm
  • Hi How to make search fast? We are building some application and this application need to build more efficient fast search. WIth regards -Dinesh Add photos to your messages with MSN 8. Get 2 months ...
    Seema SinghSeema Singh
    Nov 13, 2002 at 3:38 pm
    Nov 13, 2002 at 6:19 pm
  • Hi List, We are facing with some CPU problem (cpu 100% usage!), Just want to get some idea from you guys, any clue what can cause this problem: Here is a copy of some part of ora.ini This happen ...
    Hamid AlaviHamid Alavi
    Nov 7, 2002 at 9:04 pm
    Nov 8, 2002 at 5:44 pm
  • Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the ...
    Doug CDoug C
    Nov 25, 2002 at 3:13 am
    Nov 28, 2002 at 6:53 am
  • Robert, I guess what you say makes sense. But why the need to move the release level from 8, to 8i, to 9i to 10i all within 5 years? Granted, there were huge improvements from 8 to 9i. I guess what ...
    Mercadante, Thomas FMercadante, Thomas F
    Nov 8, 2002 at 8:13 pm
    Nov 11, 2002 at 2:58 pm
  • I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a ...
    Markham, RichardMarkham, Richard
    Nov 7, 2002 at 1:59 pm
    Nov 8, 2002 at 5:33 pm
  • Hello Guru's I have run a script which indicates that of the three redo log latches two had occurences of sleeps. To overcome this usually you increase SPIN_COUNT by 50% or so. When trying to ALTER ...
    Denham EvaDenham Eva
    Nov 7, 2002 at 11:33 am
    Nov 8, 2002 at 5:43 am
  • Hi everyone, I was always under the impression that the only concern with shmmax was that it be large enough for the SGA to fit into it. One of my System Administrators has just told me that the ...
    Miller, JayMiller, Jay
    Nov 23, 2002 at 6:48 pm
    Nov 29, 2002 at 11:23 pm
  • Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : " " export DISPLAY=:0.0 # xhost + Xlib : connection to client refused "" Xlib : cannot set display to "" ...
    VIVEK_SHARMAVIVEK_SHARMA
    Nov 26, 2002 at 2:39 pm
    Nov 27, 2002 at 3:34 pm
  • Dear List Have a look at the sql !!! SQL create table trnid 2 ( trn_id number(10)); Table created. SQL insert into trnid(trn_id) values('1111111111');/* 10 1's inserted*/ 1 row created. SQL insert ...
    Sathyanaryanan_K/VGIL_at_vguard.satyam.net.inSathyanaryanan_K/VGIL_at_vguard.satyam.net.in
    Nov 22, 2002 at 11:23 am
    Nov 23, 2002 at 8:48 pm
  • Does their has way that can download (or purchase CD) all the ORACLE Openworld documents? Thanks. MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus ...
    Dist cashDist cash
    Nov 16, 2002 at 2:23 pm
    Nov 19, 2002 at 4:33 pm
  • Any Good Docs, Links, sources ? Need to present a paper to the Managers Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: VIVEK_SHARMA_at_infosys.com ...
    VIVEK_SHARMAVIVEK_SHARMA
    Nov 15, 2002 at 2:39 pm
    Nov 19, 2002 at 2:53 am
  • Hamid, This is one of those instances where I'll heartly agree with Cary in ALL respects. We run PeopleSoft and have found many a query that seems to spinn around and around creating a pile of ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Nov 14, 2002 at 8:44 pm
    Nov 16, 2002 at 6:08 pm
  • Qs What would be the FASTEST way to Load ALL Data from a Source Database Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ? NOTE - Creation Fresh (NEW) Database is a Must because Some of ...
    VIVEK_SHARMAVIVEK_SHARMA
    Nov 13, 2002 at 5:03 pm
    Nov 14, 2002 at 11:48 am
  • Hey all, I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to take the opportunity to convert the datafiles of the TEMP tablespace to tempfiles. My reason for this change is ...
    Jesse, RichJesse, Rich
    Nov 6, 2002 at 3:56 pm
    Nov 8, 2002 at 12:34 am
  • If you are an Oracle DBA With SAP experience looking for a stable company where you can work within a great team environment, this company in Toledo, Ohio is the place for you. This Fortune 500 ...
    OraStaffOraStaff
    Nov 6, 2002 at 2:49 pm
    Nov 6, 2002 at 9:08 pm
  • I cannot fathom Raid 5 being faster than Raid 1 tor writes. The real question is, is it fast enough for your users. We happen to have a 650 terabyte database here. Even using Raid 5 disk storage ...
    MacGregor, Ian A.MacGregor, Ian A.
    Nov 1, 2002 at 12:48 am
    Nov 5, 2002 at 1:23 am
  • Sqlplus won't work. This is SAP. If you're not familiar with SAP, sqlplus is not an adequate reporting tool. Though all SAP data is stored in tables in the database, there are some that are stored as ...
    Jared StillJared Still
    Nov 1, 2002 at 6:43 am
    Nov 5, 2002 at 12:28 am
  • Dear List, Number of times I've seen that one of prerequsites for switching from single node DB to OPS/RAC is to have an application specifically designed / architectured to run on RAC. Can somebody ...
    Boris DaliBoris Dali
    Nov 26, 2002 at 9:34 pm
    Nov 29, 2002 at 10:53 pm
  • ver 8i NT4.o all services have been set to automatic and start fine however the NT Event Viwer and the oracle "alert.log" show that the instance being shutdown just after the box boots up. how do we ...
    JohnJohn
    Nov 23, 2002 at 11:23 pm
    Nov 25, 2002 at 6:47 pm
Nov 2002
12345…10
Group Navigation
period‹ prev | Nov 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions471
posts2,199
users358
websiteoracle.com

358 users for November 2002

DENNIS WILLIAMS: 99 posts Jared.Still_at_radisys.com: 64 posts Yechiel Adar: 60 posts Rachel Carmichael: 54 posts Stephen Lee: 54 posts Jkstill_at_cybcon.com: 50 posts Jesse, Rich: 48 posts Stephane Faroult: 48 posts Tim Gorman: 43 posts Fink, Dan: 42 posts Dgoulet_at_vicr.com: 39 posts Connor McDonald: 35 posts Jamadagni, Rajendra: 33 posts Cary Millsap: 30 posts Freeman, Robert: 30 posts VIVEK_SHARMA: 27 posts Gogala, Mladen: 26 posts Arup Nanda: 25 posts Boivin, Patrice J: 24 posts Mercadante, Thomas F: 24 posts
show more
Archives