Search Discussions

642 discussions - 2,862 posts

  • 57


    Ok, I need to vent a little. Last week, I was asked to do some tech interviews over the phones for a mid level DBA position. Someone with about 2-3 years experience. I don't consider myself a real ...
    Jul 22, 2002 at 2:58 pm
    Jul 23, 2002 at 5:18 pm
  • Anyone whom has a good example on how to check "how many rows (without opening the file) does a text file consists of? What is the command? Thanks in advance Roland -- Please see the official ...
    Jul 3, 2002 at 8:43 am
    Jul 4, 2002 at 7:33 pm
  • only a dba would think of drinking coffee as something that would calm one down! har har har ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET ...
    Eric D. PierceEric D. Pierce
    Jul 22, 2002 at 5:13 pm
    Jul 23, 2002 at 9:09 pm
  • What I wouldn't give for "./orainst /c" right now. Where is the productivity and ease of use of the #$%^#@ OUI when it takes hours and hours just to load up all the java crap! Piece of garbage is ...
    Jul 9, 2002 at 8:47 pm
    Jul 14, 2002 at 10:23 am
  • All... Will some of you please provide some insight on your table naming conventions? I'm in the very early planning stages of what will likely be a large and complex schema (IT asset inventory). I ...
    Gary ChambersGary Chambers
    Jul 30, 2002 at 8:36 pm
    Jul 31, 2002 at 11:27 pm
  • For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the init.ora file? I created the database using dbca. It created an init.ora in admin/{db_name}/pfile. I moved this to ...
    Jul 11, 2002 at 3:43 pm
    Jul 16, 2002 at 7:45 pm
  • Guys, I have been working hard on Oracle systems at various levels - various platforms, etc. for 8 years. It has been a long time since I have taken a course. Would like to go to IOUG. Reading ...
    Jul 25, 2002 at 5:53 pm
    Jul 30, 2002 at 9:28 pm
  • Hi gurus... I friend newly bought a laptop with windows XP. He wants to install oracle 8i on it. Is it possible to install oracle 8i in XP?. Is there any patch i need apply. Thanks. Nirmal. -- Please ...
    Nirmal Kumar Muthu KumaranNirmal Kumar Muthu Kumaran
    Jul 27, 2002 at 12:03 pm
    Jul 31, 2002 at 7:09 pm
  • Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. I thought ...
    MacGregor, Ian A.MacGregor, Ian A.
    Jul 25, 2002 at 5:08 am
    Jul 26, 2002 at 8:48 pm
  • Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland ...
    Jul 2, 2002 at 8:43 am
    Jul 3, 2002 at 1:13 am
  • What I sometimes use is alter system checkpoint startup force restrict shutdown normal -Rich -----Original Message----- Sent: Monday, July 22, 2002 10:53 PM To: Multiple recipients of list ORACLE-L ...
    Gesler, RichGesler, Rich
    Jul 23, 2002 at 3:18 pm
    Jul 25, 2002 at 6:28 pm
  • Hello! I am developing cost estimates for my company to possibly send a couple of people to next year's IOUG meeting. Can some one tell me where it will be, when it is, and the cost to attend? TIA -- ...
    Angel TironeAngel Tirone
    Jul 5, 2002 at 3:43 pm
    Jul 10, 2002 at 12:08 am
  • I have been reading this list for the past several months as I prepare to move my universe of databases from 7.3 to 9 (probably 9) and I have a rant of my own. It seems that the implicit expectation ...
    Robert MonicalRobert Monical
    Jul 22, 2002 at 5:23 pm
    Jul 24, 2002 at 4:02 pm
  • Okay, I'm working on what feels like 30 new projects all at once and I WILL be RTFM'ing as soon as I can get more than 5 minutes out of meetings but.... first: has anyone heard of any problems with ...
    Rachel CarmichaelRachel Carmichael
    Jul 17, 2002 at 5:08 pm
    Jul 18, 2002 at 8:59 pm
  • hi ! i might start another war, but i can't resist a part of me which wants to ask : what do you, seasoned gurus, think of everybody's (as it seems to be) plans to abandon the "classic" unix for ...
    Andrey BronfinAndrey Bronfin
    Jul 14, 2002 at 6:58 pm
    Jul 17, 2002 at 9:23 pm
  • Hi list, What is the point to use "alter database rename file" command to move datafile? as we will need to update controle file anyway. So why not do the following directly to move datafile: alter ...
    Jalil ZabourdineJalil Zabourdine
    Jul 9, 2002 at 12:48 pm
    Jul 10, 2002 at 4:53 pm
  • Hi, Is there a way of resetting sequence numbers back to zero???The application we have needs to have the sequence numbers reset... Thanks in advance Rgds Fawzia Information in this email is ...
    Malik, FawziaMalik, Fawzia
    Jul 5, 2002 at 12:23 pm
    Jul 5, 2002 at 3:33 pm
  • Listers, I was 'volunteered' to participate in a task force charged with finding quick solutions (in less than 2 weeks) to support following Dgmt decision: Clone 14 production databases in their ...
    Deshpande, KirtiDeshpande, Kirti
    Jul 19, 2002 at 2:08 am
    Jul 22, 2002 at 12:58 pm
  • Anybody have any experience with "Cognos"? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the ...
    John WeathermanJohn Weatherman
    Jul 18, 2002 at 4:08 pm
    Jul 19, 2002 at 12:43 pm
  • Heard on the BBC radio at lunch that Oracle Corp. is moving alot of operations to India, 1800 new jobs. Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ ...
    Ray StellRay Stell
    Jul 31, 2002 at 7:39 pm
    Jul 31, 2002 at 10:27 pm
  • Thanks Ron, Beth, That is the last option. Do we have anything that can be used without a supporting web server? I'd like to run this off my file system. TIA Raj Rajendra Jamadagni MIS, ESPN Inc ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jul 29, 2002 at 7:23 pm
    Jul 30, 2002 at 9:40 pm
  • Env: OpenVMS 7.2-1 Oracle VB code feeding data to a Crystal report This query runs in less than a second without the bind variables. Same query takes about 10 minutes with the bind ...
    Baker, BarbaraBaker, Barbara
    Jul 19, 2002 at 6:23 pm
    Jul 23, 2002 at 12:28 pm
  • Check this out that i got in email, legitimate? joe Original Message -------- Date: Tue, 09 Jul 2002 17:19:30 -0700 Organization: Antics Online, Inc. To: susan_at_anticsonline.com Dear Oracle User, ...
    Joe TestaJoe Testa
    Jul 10, 2002 at 3:08 am
    Jul 11, 2002 at 2:43 pm
  • Good day, all: Am curious to hear opinions on how to model a child table that has multiple parent tables (i.e., foreign key to multiple parents) Example: There's a table that stores Addresses (table ...
    Magaliff, BillMagaliff, Bill
    Jul 31, 2002 at 8:43 pm
    Jul 31, 2002 at 11:02 pm
  • I have a request from one of our developers to create two new sequences on the DUAL table. This seems like a bad idea to me. I've never had such a request in the past. I asked for clarification on ...
    Jul 30, 2002 at 5:53 pm
    Jul 30, 2002 at 11:03 pm
  • To OCP or not to OCP... I found an interesting Job Description Job description: Oracle Certified OCP DBA 8i and 9i with Des 2000 -Oracle Database Administrator10 plus yrs. experience in IT with at ...
    Gesler, RichGesler, Rich
    Jul 27, 2002 at 2:58 pm
    Jul 29, 2002 at 8:14 pm
  • That's very funny. INFP DBA... Wow! You do what you want with verve and to Hell the consequences whenever you blow up. Being a P, you are pragmatic about your outbursts... ? I am an INTJ most of the ...
    Boivin, Patrice JBoivin, Patrice J
    Jul 23, 2002 at 2:18 am
    Jul 23, 2002 at 8:49 pm
  • I have Oracle 8.1.7 running on NT. I do cold backups nightly and have a batch file that is called by the NT 'AT' scheduler. I recently changed some lines of commands in the batch file and since then ...
    Farnsworth, DaveFarnsworth, Dave
    Jul 17, 2002 at 1:43 pm
    Jul 17, 2002 at 5:17 pm
  • hi i have 3 databases(A,B,X) on 3 diff boxes. i have created 1 dblink each from A to X & from B to X. The syntax for dblink creation is exactly same for both dblinks. I am able to query from dblink ...
    Ratnesh Kumar SinghRatnesh Kumar Singh
    Jul 10, 2002 at 12:53 pm
    Jul 16, 2002 at 9:58 am
  • Is there any way to remove all numbers from a string? The string might look like this: 'abc123def432' and I wan't it to look like this: 'abcdef'. I'm using Oracle 8. Thanks in advance! -- /Nils ...
    Nils HöglundNils Höglund
    Jul 1, 2002 at 11:18 am
    Jul 2, 2002 at 6:19 pm
  • It really OAS and not iAS? If it is, you need to upgrade your software. There is a published exploit against the version of Apache used by Oracle's latest iAS release. Oracle has released a patch ...
    MacGregor, Ian A.MacGregor, Ian A.
    Jul 17, 2002 at 5:23 pm
    Jul 19, 2002 at 4:53 pm
  • Hi List, In system_event i find total_waits, total_timeouts, time_waited and avg_wait . If total_waits and total_timeouts are high but there are 0 value for time_waited and avg_wait . What does this ...
    Jul 1, 2002 at 5:33 pm
    Jul 2, 2002 at 7:27 pm
  • Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with "session marked for kill" and the status of the session is now "Killed". I presume that the reason is that Oracle ...
    Jul 15, 2002 at 9:39 pm
    Jul 16, 2002 at 8:43 pm
  • Fellow listers, In addition to the usual SAP system that runs most of our company, we have Oracle Apps 10.7 HR. For some reason the HR folks didn't like the SAP HR module, so I have SAP and Oracle ...
    Jul 5, 2002 at 10:43 pm
    Jul 10, 2002 at 2:18 am
  • I am in the process of designing a small database which may have as many as 250 to 300 users. We are reaching a stage where we need to decide how we will control access to this database. As I see it ...
    Schauss, PeterSchauss, Peter
    Jul 29, 2002 at 8:58 pm
    Jul 31, 2002 at 7:59 pm
  • ...from <http://www.gksoft.com/a/fun/unix-c-hoax.html ... Creators admit: UNIX and C Hoax! In an announcement that has stunned the computer industry, Ken Thompson, Dennis Ritchie, and Brian Kernighan ...
    Tim GormanTim Gorman
    Jul 30, 2002 at 9:48 pm
    Jul 31, 2002 at 5:38 pm
  • Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? Seán O' Neill Organon (Ireland) Ltd. [subscribed ...
    O'Neill, SeanO'Neill, Sean
    Jul 24, 2002 at 9:03 am
    Jul 25, 2002 at 7:28 am
  • Busted... Software vendor Computer Associates International is suing competitor Quest Software, alleging that Quest stole code and trade secrets from a CA product ...
    James HowertonJames Howerton
    Jul 10, 2002 at 8:10 pm
    Jul 11, 2002 at 5:48 pm
  • All, I've just been rolling out statspack against all of our production DBs. What I am not sure about is how often I should take a snapshot ? I am planning on holding one months worth of data and ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Jul 10, 2002 at 9:43 am
    Jul 11, 2002 at 3:25 pm
  • All, We are tuning a new vital process on our data warehouse, and it is IO intensive - lots of parallel direct reads and writes. During our testing we are driving IO wait to ~60% (per top) ...
    Jack SilveyJack Silvey
    Jul 23, 2002 at 3:58 pm
    Jul 25, 2002 at 6:18 am
  • Hi all, Can any of our Unix gurus here transform my script below to work properly? The intention is to print the last line of the sqlplus output. With set -x, it appears anything after the last EOF ...
    Ross ColladoRoss Collado
    Jul 24, 2002 at 4:53 am
    Jul 24, 2002 at 5:05 pm
  • A colleague of mine has encountered something strange. When the HOME environement variable is set to the oracle users home (/usr/users/oracle) we can't connect to any oracle databases. When it is set ...
    Stephen AndertStephen Andert
    Jul 19, 2002 at 5:53 pm
    Jul 21, 2002 at 6:58 pm
  • Hello, Guys, Thought of making all of you aware with dirty game played by Crescent Cc (www.crescent.cc). I got trapped with this company's offer letter and lost money, lost job, got lots of ...
    SK OracleDBASK OracleDBA
    Jul 18, 2002 at 1:13 pm
    Jul 19, 2002 at 4:23 am
  • http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci832443,00.html http://ixora.com.au/scripts/sql/dd_cluster_sizes.sql Humm...my money is on Steve as the original author. Ethan -- Please see ...
    Post, EthanPost, Ethan
    Jul 11, 2002 at 7:25 pm
    Jul 13, 2002 at 6:33 am
  • Ok, I log in as oracle, touch a file I get 664 permission on it. But when I create a file through OEM or a plsql procedure I get 644 permissions. My umask is 02. On another system - solaris ...
    Kathy DuretKathy Duret
    Jul 8, 2002 at 8:07 pm
    Jul 10, 2002 at 6:10 pm
  • Hi, Can anyone help me with this delete statement? I have the following table: Name Null? Type ----------------------------------------- -------- ------------- USER_ID NOT NULL NUMBER(15) PASSWORD ...
    Steven HovingtonSteven Hovington
    Jul 9, 2002 at 4:59 pm
    Jul 9, 2002 at 8:30 pm
  • We need to move our standby database to a new location. I put together a plan for this. My boss said that I needed to draw pictures in Visio showing the old location and new location since his boss ...
    Miller, JayMiller, Jay
    Jul 23, 2002 at 7:44 pm
    Jul 23, 2002 at 10:11 pm
  • OJNK? Your term Larry? Or do I need to RTFM? Didn't realize this had a name. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: jkstill_at_cybcon.com ...
    Jared StillJared Still
    Jul 2, 2002 at 2:59 pm
    Jul 23, 2002 at 2:38 pm
  • 11


    trying again... Forwarded message follows ------- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 Responsibility / Re: = OT That sounds really cynical to me. Are you just speculating, ...
    Eric D. PierceEric D. Pierce
    Jul 16, 2002 at 5:13 am
    Jul 17, 2002 at 8:51 pm
  • We have developers who occassionally want to be able to kill their sessions in a dev instance. We are concerned about giving them alter system priviledge and were wondering what people do about ...
    Joe Armstrong-ChampJoe Armstrong-Champ
    Jul 11, 2002 at 6:51 pm
    Jul 12, 2002 at 9:23 am
Group Navigation
period‹ prev | Jul 2002 | next ›
Group Overview
grouporacle-l @

397 users for July 2002

Jared.Still_at_radisys.com: 105 posts Rachel Carmichael: 96 posts Dgoulet_at_vicr.com: 92 posts DENNIS WILLIAMS: 61 posts Eric D. Pierce: 57 posts Khedr, Waleed: 54 posts Jesse, Rich: 52 posts Boivin, Patrice J: 42 posts Igor Neyman: 41 posts Kkennedy: 41 posts Yechiel Adar: 39 posts Mercadante, Thomas F: 38 posts Freeman, Robert: 37 posts Jamadagni, Rajendra: 34 posts Farnsworth, Dave: 33 posts Grabowy, Chris: 29 posts MacGregor, Ian A.: 29 posts Orr, Steve: 29 posts Deshpande, Kirti: 28 posts Alexandre Gorbatchev: 27 posts
show more