FAQ

Oracle > oracle-l > June 2002

Search Discussions

584 discussions - 2,654 posts

  • I am seriously considering pursuing one, since it can be sold to hiring managers as a sign of professional competence. Look at it from a cost/benefit ratio standpoint. Will someone with this ...
    Jack SilveyJack Silvey
    Jun 20, 2002 at 10:50 pm
    Jun 28, 2002 at 3:43 pm
  • Position: Oracle DBA with Top Secret SCI Clearance (Please do not send your resume unless you have the required clearance) Location: Dayton, Ohio Salary Range: Depends on experience. Relocation ...
    OraStaffOraStaff
    Jun 26, 2002 at 3:33 pm
    Jun 28, 2002 at 4:38 pm
  • Simple question, but I can't seem to find the answer in the oracle docs: Let's say I insert a record into an updatable snapshot, and then I update the same row. When I refresh the snapshot, will the ...
    Buddy BrewerBuddy Brewer
    Jun 10, 2002 at 2:38 pm
    Jun 24, 2002 at 12:08 pm
  • could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and ...
    Santosh VarmaSantosh Varma
    Jun 25, 2002 at 9:48 am
    Jun 27, 2002 at 3:48 am
  • Hi guys. Here's my problem. I want to check the new values (when inserting&updating a table) against the ones in the existing rows. Something like checking for duplicate values, but using a unique ...
    Iulian.ILIES_at_orange.roIulian.ILIES_at_orange.ro
    Jun 4, 2002 at 1:58 pm
    Jun 10, 2002 at 5:18 pm
  • Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table ...
    Deshpande, KirtiDeshpande, Kirti
    Jun 18, 2002 at 7:06 pm
    Jun 26, 2002 at 2:08 pm
  • We are in the process of rolling out a Web Appl that uses BEA WebLogic and Oracle JDBC, thin driver calls to connect to database. These are dedicated connections (No MTS). The listener is overwhelmed ...
    Deshpande, KirtiDeshpande, Kirti
    Jun 27, 2002 at 3:53 pm
    Jun 28, 2002 at 11:13 pm
  • Tom, As I recall DB2 on a PC came about way back in the dark days of the 8080 processor and DOS (no version) somewhere around 1980 I believe. I seem to vaguely remember running it on a very old (now ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Jun 25, 2002 at 2:58 pm
    Jun 26, 2002 at 3:38 pm
  • Hi list, Scenario Sun 880 Solaris 8, Oracle 8.1.7.3, 8GB Ram, 4 processors Redo logs 200MB size 4 groups in 1 disk DBWriter = 2 log buffer 200 BM Shared Pool 1 GB db block buffers 100,000 db block ...
    Com.banilejas_at_codetel.net.doCom.banilejas_at_codetel.net.do
    Jun 19, 2002 at 1:33 am
    Jun 21, 2002 at 2:13 pm
  • Good Morning All! One of my SA's came to me asking if I know what it means to have 'hypernormalized' tables in a database. I am clueless. Has anyone heard of this, and if so can you point me to some ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Jun 17, 2002 at 4:48 pm
    Jun 18, 2002 at 2:33 pm
  • Hi List, Friday afternoon I try to upgrade database(8.1.7.0 on sun solaris) to 8.1.7.4 but after few minutes I got the following message: "There are no Patches need to be applied from the patch set ...
    Hamid AlaviHamid Alavi
    Jun 3, 2002 at 4:18 pm
    Jun 4, 2002 at 2:38 pm
  • Ferenc Mantfeld£¬ For cold backup, oracle does not recommend backup the online redo log. And if you restore the whole cold backup, why need the online redo log? I am sure people doing cold backup ...
    Chal_pingChal_ping
    Jun 19, 2002 at 12:38 pm
    Jun 24, 2002 at 5:38 am
  • Hello all, I want to remove lock on a Table by using this command: Alter system kill session '&sid,&serial' Is this enough or I have to do something else! Regards Ashraf Salaymeh System Analyst
    ASHRAF SALAYMEHASHRAF SALAYMEH
    Jun 17, 2002 at 10:13 am
    Jun 21, 2002 at 5:07 pm
  • Speaking of OCP...I got this from the OCP newsletter...I guess Oracle needs more revenue streams... Dear Oracle Certified Professional, Please acknowledge this correspondance as an official ...
    Grabowy, ChrisGrabowy, Chris
    Jun 17, 2002 at 6:14 pm
    Jun 18, 2002 at 3:13 pm
  • All, Oracle 8.0.5.0.0 Tru64 v4.0f We are running a job and statspack reports show that our only problem (it is running like a dog) is the following SQL*Net more data from client. Done some reading ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Jun 13, 2002 at 3:23 pm
    Jun 14, 2002 at 7:55 pm
  • I have just been moved to a group with several hundred developers, and to say the least the environment is chaotic. Without putting limits on my developers (such as via READONLY user, etc.), is there ...
    Ray GordonRay Gordon
    Jun 25, 2002 at 12:53 am
    Jun 28, 2002 at 1:03 am
  • I have an instance that is waiting on log file synchs. I suspect that the waits are a result of a overly large redo log buffer. There are also considerable waits on direct path writes. The redo logs ...
    Erik WilliamsErik Williams
    Jun 21, 2002 at 7:48 pm
    Jun 26, 2002 at 6:04 pm
  • Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Jun 13, 2002 at 3:33 pm
    Jun 26, 2002 at 9:58 am
  • I'd like to ask another question. Hope you don't mind... How did you get a job in Switzerland/Germany/Holland? How is market and demand there? I know a year or two ago Germany was screaming for ...
    Lyuda HoskaLyuda Hoska
    Jun 11, 2002 at 5:13 pm
    Jun 12, 2002 at 11:23 am
  • Hi List, What's the diffrent between unique constrint & unique index, when we have to use which, I think both are the same. Any Idea? And what about normal index & reverse index? when we have to use ...
    Hamid AlaviHamid Alavi
    Jun 7, 2002 at 7:46 pm
    Jun 10, 2002 at 2:23 pm
  • Oracle 8.1.6.3 on Sun 2.6. I have tried reviewing the docs, but I didn't see anything that answered the question. Is it possible to limit the number of records being loaded? We have a file that has ...
    Ball, TerryBall, Terry
    Jun 4, 2002 at 3:38 pm
    Jun 11, 2002 at 12:33 pm
  • Hi! Our Oracle database is installed on second partition of the drive capacity 7GB. Last night one the developers executed a query to create and populate a table from another table. The query wasn't ...
    Abdul AleemAbdul Aleem
    Jun 4, 2002 at 7:58 am
    Jun 6, 2002 at 11:04 pm
  • Hello Gurus, Ours is basically a Sybase shop. But moving towards Oracle. We are in the process of conversion. I have a problem in deleting a large number of rows. To delete 400,000 rows approx., it ...
    Vasu RamasamyVasu Ramasamy
    Jun 26, 2002 at 4:49 pm
    Jun 27, 2002 at 1:58 am
  • JoJo, take a hint from someone who'd been doing oracle for 11 years now. The docs are ALOT better than they were in 5.x/6.x days. Heck you dont even have to buy oracle anymore to read the docs. They ...
    Joe TestaJoe Testa
    Jun 10, 2002 at 2:13 am
    Jun 26, 2002 at 4:49 pm
  • My manager has told me that he has budget to send me for a training course of my choice, 4 to 5 days, preferably in the local area (Long Island or NYC). A bit of background on myself: Current ...
    Schauss, PeterSchauss, Peter
    Jun 20, 2002 at 6:51 pm
    Jun 21, 2002 at 5:07 pm
  • NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html no matter what default i set! Hi lists, I am using Quest Shareplex product for Oracle to Oracle one way replication. I have two ...
    Johanna.doran_at_sungard.comJohanna.doran_at_sungard.com
    Jun 6, 2002 at 2:32 pm
    Jun 18, 2002 at 10:38 am
  • I've been pretty quiet while you all said that the OCP program was pretty worthless because I can see your point. I don't believe that it proves that the holder is technically better than someone has ...
    Hately MikeHately Mike
    Jun 27, 2002 at 9:33 am
    Jun 29, 2002 at 5:24 pm
  • Guys, Building scripts from SQL generating SQL in Oracle on Unix. I know that there are set commands so that Oracle does not put CR or LF in the middle of a long command. Does anyone know these off ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Jun 10, 2002 at 1:58 pm
    Jun 11, 2002 at 3:13 pm
  • Solved Database OPENed Successfully on another HP-UX Box Without any ORA-1092 The Same Oracle & OS Versions Existed on Both HP-UX Boxes . NOTE Though ORA-1092 was often succeeded by the message :- ...
    VIVEK_SHARMAVIVEK_SHARMA
    Jun 4, 2002 at 9:41 pm
    Jun 6, 2002 at 11:18 am
  • Kevin Loney's Oracle8i DBA Handbook says you need to know the "operating system's I/O buffer size" in order to set the init param DB_FILE_MULTIBLOCK_READ_COUNT correctly. What is the definition of ...
    Carmen RusuCarmen Rusu
    Jun 12, 2002 at 1:53 pm
    Jun 14, 2002 at 5:49 pm
  • SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE ROWNUM < 10; VOUCHER_ 00003394 00003395 00003396 00003397 00003398 00003399 00003400 00003401 00003402 set feedback on 1 SELECT VOUCHER_ID FROM ...
    MacGregor, Ian A.MacGregor, Ian A.
    Jun 9, 2002 at 2:58 am
    Jun 10, 2002 at 9:55 pm
  • I beg to differ. All Real DBA's should be "platform independent". (and if that platform comes from M$FT, they should probably be undergoing intense therapy). James dgoulet_at_vicr.com wrote: < SNIP < ...
    James J. MorrowJames J. Morrow
    Jun 1, 2002 at 9:53 pm
    Jun 6, 2002 at 7:53 am
  • If you create a new database and do a full online backup (this also includes future regular full online backups) is it ever necessary to do a full offline backup? I have heard conflicting answers, ...
    Tracy RahmlowTracy Rahmlow
    Jun 18, 2002 at 10:58 pm
    Jun 26, 2002 at 6:53 am
  • Yes, I know I need to RTFM, but if some kine soul has a quick answer for me, I'd appreciate it. ORACLE instance started. Total System Global Area 168788768 bytes Fixed Size 729888 bytes Variable Size ...
    Charlie MenglerCharlie Mengler
    Jun 24, 2002 at 10:05 pm
    Jun 25, 2002 at 9:18 pm
  • Hello All, I have a set of Materialized views in my DB . we refresh ( COMPLETE) these MVs, couple of times a day. Web server ( application ) will hit these MVs to show the data on web pages. But the ...
    Reddy, MadhusudanaReddy, Madhusudana
    Jun 21, 2002 at 6:58 pm
    Jun 24, 2002 at 1:33 pm
  • In the US one can put training on their income tax forms, but the IRS will disallow it. Dick Goulet One of the disallowed! ____________________Reply Separator____________________ Author: "Boivin ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Jun 17, 2002 at 9:22 pm
    Jun 20, 2002 at 8:53 am
  • Hi All, I am setting up a 9i instance and am wondering if there are any tablespaces that you would not set up as locally managed. Would system and rollback tablespaces be set up as dictionary managed ...
    Marmdba_at_aol.comMarmdba_at_aol.com
    Jun 13, 2002 at 4:40 pm
    Jun 14, 2002 at 8:15 pm
  • We have an application that is periodically encountering what appears to be a self-deadlock. Only one session is listed and it holds an exclusive (X) lock and is waiting for a share (S) lock with NO ...
    Walter KWalter K
    Jun 6, 2002 at 4:33 pm
    Jun 12, 2002 at 3:33 pm
  • Hi guys, Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can ...
    ChetanChetan
    Jun 26, 2002 at 10:18 am
    Jun 28, 2002 at 5:08 pm
  • Having never been to either and wanting to plan for one, am I to infer from some of this discussion that for real content (as opposed to marketing fluff), THE conference to attend would be IOUGLive, ...
    Magaliff, BillMagaliff, Bill
    Jun 26, 2002 at 9:15 pm
    Jun 27, 2002 at 4:48 pm
  • Hallo, anyone whom can give me an example on how to pick out field id and name from table one and get only the id's that exists in table one doesnt exist in table2. Thanks in advance Roland -- Please ...
    Roland.Skoldblom_at_ica.seRoland.Skoldblom_at_ica.se
    Jun 26, 2002 at 1:13 pm
    Jun 27, 2002 at 1:48 am
  • Hello, I have encountered a performance problem. I use "Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production." I have two tables. "phonenumber" and "person", each person has none, one or many ...
    Nils HöglundNils Höglund
    Jun 25, 2002 at 1:08 pm
    Jun 25, 2002 at 6:17 pm
  • oracle-lHi, grurus: This is a production database 8.1.7.2 on aix 4.3.3, there are 17 instances running on the same box. I shutdown immediate the database and it hangs.After wait for one hour, i do a ...
    Chal_pingChal_ping
    Jun 19, 2002 at 8:13 am
    Jun 20, 2002 at 6:51 pm
  • Hi, I have 2 data files file1 & file2. I want to get all those records which are present only in file2 & not in file1. Also want records which are present in both,separately. I tried to use diff, but ...
    Cosltemp-g.manoj_at_orbitech.co.inCosltemp-g.manoj_at_orbitech.co.in
    Jun 19, 2002 at 7:13 am
    Jun 20, 2002 at 8:23 am
  • I have a system when I issued a select statement, I get the following error. ORA-00604 Error Occur at recursive level 1 ORA-01578 Oracle Datablock corrupted. File 6 Block 2853 ORA-01110 Datafile 6 ...
    Peter.lee_at_honeywell.comPeter.lee_at_honeywell.com
    Jun 11, 2002 at 5:28 pm
    Jun 14, 2002 at 9:28 am
  • All, We have a new info security group that is going to do all the object grants on our warehouse. I don't want them to login as schema owners to do this. Until this time, I have been granting access ...
    Jack SilveyJack Silvey
    Jun 10, 2002 at 8:50 pm
    Jun 11, 2002 at 12:28 am
  • Hi All does anyone have any white paper or info on how to configure a dedicated portion of real memory as a virtual drive on Solaris ? I want to move my online redo logs (4 X 128 M single threaded) ...
    Ferenc MantfeldFerenc Mantfeld
    Jun 24, 2002 at 2:53 am
    Jun 28, 2002 at 4:58 am
  • Is there any way to discover the location of the pfile from a running oracle instance. It is possible that pfile is not at its default location i.e. $ORA_HOME/dbs/init.ora also it could have any ...
    Bharat digheBharat dighe
    Jun 26, 2002 at 10:38 am
    Jun 26, 2002 at 5:28 pm
  • Hi List, I want to create a sequence which will be used by some external process to generate some unique number . since this sequence will be used very frequently I would prefer to cache around 10000 ...
    BigPBigP
    Jun 14, 2002 at 1:23 am
    Jun 20, 2002 at 4:58 pm
  • Hi DBAs We are upgrading from 8.1.5 to 9.x. I thought of finding out which release of 9i is more stable. As We have got 9.2 couple of weeks back, I was just wondering what is worth going for 9.2 ...
    Raj GopalanRaj Gopalan
    Jun 12, 2002 at 5:10 pm
    Jun 14, 2002 at 5:49 pm
Jun 2002
12345…12
Group Navigation
period‹ prev | Jun 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions584
posts2,654
users397
websiteoracle.com

397 users for June 2002

Rachel Carmichael: 83 posts DENNIS WILLIAMS: 76 posts Alexandre Gorbatchev: 61 posts Deshpande, Kirti: 49 posts Dgoulet_at_vicr.com: 48 posts Tim Gorman: 45 posts Jared.Still_at_radisys.com: 44 posts Jamadagni, Rajendra: 42 posts Jesse, Rich: 41 posts Joe Testa: 41 posts Jack Silvey: 40 posts Hamid Alavi: 34 posts Johanna.doran_at_sungard.com: 33 posts Mercadante, Thomas F: 33 posts Ferenc Mantfeld: 32 posts Khedr, Waleed: 32 posts Yechiel Adar: 31 posts Aponte, Tony: 30 posts Stephane Faroult: 29 posts Jared Still: 28 posts
show more
Archives