FAQ

Oracle > oracle-l > August 2002

Search Discussions

666 discussions - 3,028 posts

  • Hi All, We bought a license for a few components of Oracle 11.0.3. For different products we bought license for different number of users depending upon the requirement we anticipated at that time ...
    Naveen NahataNaveen Nahata
    Aug 14, 2002 at 12:48 pm
    Aug 16, 2002 at 4:28 pm
  • Are transcript documents available anywhere? Regards Madhusudhanan S MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the ...
    Madhusudhanan SampathMadhusudhanan Sampath
    Aug 8, 2002 at 4:53 am
    Aug 10, 2002 at 4:38 am
  • Hi all, I write a script to update 10,000 records in my database and noticed it took more than an hour to update 10,000 records. The script just includes 10,000 SQL update commands as shown below. Is ...
    Nguyen, David MNguyen, David M
    Aug 13, 2002 at 4:24 pm
    Aug 15, 2002 at 6:06 pm
  • Hello, I need a nice PL/SQL editor any advice ? Thx for any advice Regards W.B
    Place for oraclePlace for oracle
    Aug 15, 2002 at 3:09 pm
    Aug 30, 2002 at 7:23 am
  • Currently we are duplexing our redo logs and archive logs through oracle. We do this at the oracle level because we are using mirroring (raid0?) and if we lose a redo log or archive file the database ...
    Joe Armstrong-ChampJoe Armstrong-Champ
    Aug 6, 2002 at 6:13 pm
    Aug 8, 2002 at 6:44 pm
  • Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle ...
    Freeman, RobertFreeman, Robert
    Aug 30, 2002 at 4:23 pm
    Aug 31, 2002 at 3:48 am
  • Hi all, On our ERP DB, 8.1.7.2.0 on HP/UX, I'm finally able to implement an automated index rebuild job. I've got two questions: First, I've planned to use the gauge of b*-tree HEIGHT and ...
    Jesse, RichJesse, Rich
    Aug 5, 2002 at 10:38 pm
    Aug 9, 2002 at 7:48 pm
  • Hi Gurus: I have this SQL, see... col segment_name format a30 heading "Segment Name" col maxseg format 9,999,999.9 heading "Largest|Segment (MB)" col segment_type format a15 heading "Segment|Type" ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Aug 19, 2002 at 10:23 pm
    Aug 21, 2002 at 3:43 pm
  • Ok, everybody, let's show up in support of Anjo. This should be a great presentation. Sorry if someone has already posted this to the list today, I just haven't had time to read it yet today. Jared ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Aug 2, 2002 at 10:33 pm
    Aug 9, 2002 at 8:08 am
  • Sounds like KSH scripting, maybe I should look into Perl too! 8-) Personally I like Enterprise Manager, PL/SQL, and Pro*C. Dick Goulet ____________________Reply Separator____________________ Author ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Aug 13, 2002 at 6:07 pm
    Aug 18, 2002 at 2:28 am
  • OK, that was bait, I admit it. So we all know that shutdown abort doesn't damage the database. However, do we have to ever worry about any UNIX shared memory segments hanging out there? I know we do ...
    Post, EthanPost, Ethan
    Aug 6, 2002 at 10:08 pm
    Aug 13, 2002 at 4:08 pm
  • HELLO !!!!!!!! anyone else get this pile of S**T !! Lee -----Original Message----- Sent: 22 August 2002 16:44 To: lerobe_at_acxiom.co.uk STRICTLY CONFIDENTIAL & URGENT. I am a native of Cape Town in ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Aug 22, 2002 at 2:48 pm
    Aug 23, 2002 at 3:33 am
  • Hello all Could any one of you guide me on how to select last 10 records from a table. and also finding out first 10 records.. Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ ...
    Santosh VarmaSantosh Varma
    Aug 14, 2002 at 9:48 am
    Aug 15, 2002 at 7:03 pm
  • I do not know how many of you actually work for Oracle, but for others (Developers who use Oracle Technology) this I do not think is immediate cause for concern. There is no way a team half the world ...
    Senthil RajamanickamSenthil Rajamanickam
    Aug 1, 2002 at 12:18 am
    Aug 2, 2002 at 4:59 pm
  • Hi, I recieved an email today as follows: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: johanna.doran_at_sungard.com Fat City Network Services -- (858) 538-5051 ...
    Johanna.doran_at_sungard.comJohanna.doran_at_sungard.com
    Aug 29, 2002 at 3:13 pm
    Aug 30, 2002 at 6:03 pm
  • Hi! In my .profile of the oracle user (we're mostly using ksh here), I have set up the prompt that it gives me the host name and database SID. # always displays host name and Oracle SID as prompt ...
    Daiminger, HelmutDaiminger, Helmut
    Aug 26, 2002 at 1:48 pm
    Aug 27, 2002 at 9:43 pm
  • Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, ...
    Yechiel AdarYechiel Adar
    Aug 13, 2002 at 4:24 pm
    Aug 15, 2002 at 1:48 am
  • Hello World! User with role "connect" and "resource" attempted to create functional based index on his table, but received error "insufficient privileges". Users "SYS" or "SYSTEM" can create this ...
    Edouard DormidontovEdouard Dormidontov
    Aug 5, 2002 at 6:03 am
    Aug 7, 2002 at 1:58 am
  • I got a request to spec out a machine that could handle 20 separate Oracle instances on a single UNIX server. SGA should total about 500 MB per instance. We have some hosts here with 6-8 instances ...
    Post, EthanPost, Ethan
    Aug 1, 2002 at 9:58 pm
    Aug 6, 2002 at 3:53 pm
  • Hi List, I am planning to start taking backups through RMAN.Database is around 60GB(Solaris Oracle 8.1.5) and therfore i am planning to using Catalog.Since There is no space on our solaris box i am ...
    Pawan DalmiaPawan Dalmia
    Aug 19, 2002 at 11:28 am
    Aug 20, 2002 at 8:43 pm
  • Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. Put all tablespaces in the database in Hot backup ...
    NatNat
    Aug 15, 2002 at 2:58 pm
    Aug 20, 2002 at 8:23 am
  • I am trying to perform an RMAN disaster recovery task. While I use an RMAN catalog to make backups, I am trying to recover using just the control file information. Oracle 8.1.6, Compaq/HP Tru64 I ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Aug 14, 2002 at 8:28 pm
    Aug 16, 2002 at 6:21 pm
  • Guys, Oracle 8.0.5 I am sure a short time ago, someone posted a method of effectively archiveing off statspack information in order to keep the tables at a reasonable size and to ensure that the info ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Aug 6, 2002 at 9:23 am
    Aug 12, 2002 at 2:03 pm
  • Hello All, One our lead developers has just written a Delphi application to process some printing jobs. The application would every other minute query a job table and generate a report to be printed ...
    Mandar A. GhosalkarMandar A. Ghosalkar
    Aug 22, 2002 at 8:41 pm
    Aug 24, 2002 at 1:43 am
  • Unfortunately, we have no choice but to use the java-infested, half-baked ruinStaller. Don't even get me started about the DataBase Cremation Assistant! Don Granaman [OraSaurus] Original Message ...
    Don GranamanDon Granaman
    Aug 1, 2002 at 4:28 am
    Aug 3, 2002 at 1:28 am
  • Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is solaris 8, and I can't find the patches for 7 anymore, I am trying to upgrade via an export and ...
    Ball, TerryBall, Terry
    Aug 29, 2002 at 3:23 pm
    Aug 31, 2002 at 4:28 am
  • Dear Gurus, Could you please help me out with this - I want to increase the maxextents of below segment. TIA, SQL select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENTS,MAX_EXTENTS 2 from dba_segments 3 ...
    Jonny DelmontJonny Delmont
    Aug 28, 2002 at 9:53 am
    Aug 29, 2002 at 12:18 am
  • Sorry for the lack of info. Her it all is: I have tns entries on both database machines that point to each other. I have global_names set to false on both machines. I have the same ID defined with ...
    Kevin LangeKevin Lange
    Aug 8, 2002 at 11:05 pm
    Aug 13, 2002 at 7:29 pm
  • Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any ...
    Adriano FreireAdriano Freire
    Aug 29, 2002 at 2:53 pm
    Aug 30, 2002 at 6:53 pm
  • Hi all, OS: SOlaris 2.8 DB: 8i In the clean up process of the following files, I am trying to list out the files that start with cz. cz-session-returnui177_11Jan02_0959AM_33509.txt ...
    Kommareddy sreenivasaKommareddy sreenivasa
    Aug 29, 2002 at 10:58 am
    Aug 30, 2002 at 3:18 pm
  • Hi All, Where can I get a list of all zip codes,city,states to load into a table. I have searched but cannot find anything to download. Anyone have a URL that I can get this info. Thanks Rick -- ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Aug 21, 2002 at 1:13 pm
    Aug 23, 2002 at 12:33 am
  • Not much going on over here mate. v.low at the moment and we have laid off quite a few recently. John Hallas on the list is your man. I believe he is in the contractor arena. Cheers Lee -----Original ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Aug 16, 2002 at 8:53 am
    Aug 19, 2002 at 10:33 am
  • Hi, This past weekend we experienced a problem on a production database, and I would like to try to determine what went wrong, how to avoid it in the future, and any better ways of dealing with it ...
    Brooks, RussBrooks, Russ
    Aug 20, 2002 at 7:13 pm
    Aug 22, 2002 at 2:38 am
  • Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably ...
    Sackwitz, AntjeSackwitz, Antje
    Aug 15, 2002 at 1:58 pm
    Aug 19, 2002 at 2:58 pm
  • Guys, By changing objects to noparallel, creating bitmapped index containing all columns that was local and prefixed. Moving to 8.1.7.4 I was able to improve performance from minutes to many seconds ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 8, 2002 at 2:23 am
    Aug 9, 2002 at 5:09 pm
  • Position: Oracle DBA Years Exp: 3-5 years Location: Louisville, KY Industry: Financial Services *Relocation Assistance is provided...especially if you have ties to the area. This is a full time staff ...
    OraStaffOraStaff
    Aug 22, 2002 at 8:49 pm
    Aug 23, 2002 at 8:35 pm
  • Dennis Williams DBA Lifetouch, Inc. dwilliams_at_lifetouch.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Aug 21, 2002 at 2:28 pm
    Aug 23, 2002 at 8:23 pm
  • Just an informal survey: Would *you* automatically start a production Oracle instance on a boot of a Unix box? Why or why not? Something version/OS specific (or maybe some crazy OPS reason)? The only ...
    Jesse, RichJesse, Rich
    Aug 22, 2002 at 4:24 pm
    Aug 22, 2002 at 10:34 pm
  • Hi. We have a table in our data warehouse which keeps info about calls made. This table has a child table with some detailed information about parts of the call. There may be any number of "parts" ...
    GureleiGurelei
    Aug 14, 2002 at 1:18 pm
    Aug 16, 2002 at 6:03 pm
  • Hello Listers, We have a database for which the SYSTEM tablespace size is nearly 10 gig, Now I have a plan to reduce the size of it . And database is running on 8.1.7.2. What would be the best and ...
    Reddy, MadhusudanaReddy, Madhusudana
    Aug 15, 2002 at 6:06 pm
    Aug 16, 2002 at 12:33 am
  • No longer OT! Oracle says 9I will run on Apple's new servers? http://www.apple.com/xserve/reaction.html Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | ...
    Boivin, Patrice JBoivin, Patrice J
    Aug 13, 2002 at 5:45 pm
    Aug 13, 2002 at 10:40 pm
  • I am finally looking to implement partitioning and have some issues with rolling partitions by date. (Ie add partion p0802 and drop p0801) Does anybody have or know of a generic procedure/process ...
    Tracy RahmlowTracy Rahmlow
    Aug 6, 2002 at 3:18 pm
    Aug 8, 2002 at 9:27 pm
  • I've been speaking to Veritas people about this lately. They don't like NetApp because it is difficult to backup. Veritas likes to have some hooks into the Filesytem, and apparently this isn't easy ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Aug 6, 2002 at 6:04 pm
    Aug 8, 2002 at 4:03 pm
  • Dear List members, I was wondering if there is a way to monitor the database and tell if there is a possiblility of snapshot too old error occurence. Any input is highly appreciated.. Thanks Mohammed ...
    Mohammed.Ahsanuddin_at_VerizonWireless.comMohammed.Ahsanuddin_at_VerizonWireless.com
    Aug 2, 2002 at 4:13 pm
    Aug 4, 2002 at 8:43 pm
  • I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM < n clause is attached; that makes sense to me. What doesn't ...
    Paul BaumgartelPaul Baumgartel
    Aug 29, 2002 at 3:53 pm
    Aug 29, 2002 at 8:13 pm
  • Hi, I am tuning a system at a client site and notice lots of waits for SQL*Net <http://213.46.46.10/cgi-bin/yappweb206#SQL*Net more data to client#SQL*Net more data to client more data to client ...
    Suhen PatherSuhen Pather
    Aug 20, 2002 at 2:08 am
    Aug 23, 2002 at 1:23 am
  • Hi Everyone! Well, there's been a lot of Oracle vs. Microsoft traffic on the list, but now my Manglement wants a similar comparison to IBM's DB2. Does anyone know of web sites or locations where ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Aug 12, 2002 at 10:38 pm
    Aug 13, 2002 at 7:09 pm
  • Hi, We are transferring data from one table in a schema to another table in another schema with identical fields using INSERT INTO schema1.abc (SELECT * from schema2.abc) The source table has 1.6 ...
    Abdul AleemAbdul Aleem
    Aug 12, 2002 at 4:23 am
    Aug 13, 2002 at 2:48 pm
  • This is not a joke.....!!! This is from a business critical production database that I was asked to 'review' past Friday. The report is from v$system_event taken at 10:30am, Aug 9, 2002. The server ...
    Deshpande, KirtiDeshpande, Kirti
    Aug 11, 2002 at 10:43 pm
    Aug 13, 2002 at 1:03 am
  • Hi, We will develop a new system that has a central database (817/win2000). deployable version of the application in a region without network connection. When the users are back, there should be able ...
    Paquette stephanePaquette stephane
    Aug 1, 2002 at 11:08 pm
    Aug 2, 2002 at 9:03 pm
Aug 2002
12345…14
Group Navigation
period‹ prev | Aug 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions666
posts3,028
users403
websiteoracle.com

403 users for August 2002

Jared.Still_at_radisys.com: 115 posts DENNIS WILLIAMS: 97 posts Rachel Carmichael: 71 posts Dgoulet_at_vicr.com: 66 posts Ltiu: 63 posts Tim Gorman: 56 posts Gogala, Mladen: 53 posts Naveen Nahata: 50 posts Cary Millsap: 48 posts Jamadagni, Rajendra: 44 posts Mercadante, Thomas F: 38 posts Khedr, Waleed: 36 posts Connor McDonald: 35 posts Paula_Stankus_at_doh.state.fl.us: 35 posts Yechiel Adar: 35 posts Jesse, Rich: 34 posts Joe Testa: 33 posts Steven Lembark: 33 posts Fink, Dan: 32 posts Jacques Kilchoer: 28 posts
show more
Archives