RE: Spool to Excel File

Hi Thomas- Pretty interested in your method!! I tried it out but I guess I have to create the WTW_JOB_NOTIFY table and populate it and I can't figure where the mail notification is used. Assit with the table structure and an explanation on how this table is used. Thanks and Cheers, CSW Simon. --

Oracle 8.1.7 can only use the first 15th indexes?

Hello again, I've just been reading a report for one of our systems and it says that Oracle 8.1.7 will only use the first 15 indexes created. Any index created after the 15th will be ignored unless specified via a hint. Is this correct? I haven't heard of this before. TIA, Leng.

Re: pga workarea and ora-04030

No longer having the versions to validate this, what follows might be waffle, but I thought: v7.0 => full allocated space v.7.2 => space allocated more intelligently, never freed v7.3 => space allocated more intelligently, reusable when you delete entries Cheers Connor --- Jonathan Lewis <[EMAI

RE: Unusable partition index -- working funny

My guess it's firing the first time but is not taking effect during the current transaction may be because it fires as a recursive sql within the main sql. Not a good idea to put this in a trigger. Regards, Waleed -Original Message- Sent: Tuesday, January 20, 2004 7:19 PM To: Multiple r

Re: ORA-904 after table rename

On 01/20/2004 03:39:25 PM, "Bobak, Mark" wrote: You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug. Thanks, Mark! I've learned something from you today! Who says that one cannot teach an old bear new tricks. -- Please see the officia

RE: tnsnames.ora not working ?

Open the sqlnet.ora. What is NAMES.DEFAULT_DOMAIN set to. Add that as a suffix to the DEV_DB entry. If there is no sqlnet.ora or it has no NAMES.DEFAULT_DOMAIN entry try adding .world: DEV_DB.{whatever_names.default_domain_is | world} = .. At 11:09 AM 1/20/2004, you wrote: what is the listener s

Re: problem with log version

--- Mauricio Vélez <[EMAIL PROTECTED]> wrote: > Hello everybody > > I'm trying to recover a full database from a hot > backup. > When I execute the following instruction: > > SQL> recover database using backup controlfile > until cancel; > > Then I obtain the error ora-00331, > This is t

Re: Renumber a set of grupped rows?

Maryann The select workes on 8i, but the update part I have to think som time over :-) [EMAIL PROTECTED] oracle]$ sqlplus scott/tiger SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 21 01:43:33 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterp

RE: Spool to Excel File

Title: Message Thank you so much for all your response...   To solve this issue temporarily... I used SYLK But i was planning to go for Perl. Since i am begineer in Perl hope i need to study a bit..   Thank You   Mudhalvan M.M -Original Message-From: [EMAIL PROTECTED]

Re: Renumber a set of grupped rows?

Maryann, Like I said - the analytical functions are available in 8i (I believe 8.1.5 and onwards but it might have been 8.1.7). The PL/SQL engine wasn't made aware of them though so wrap then in "execute immediate" within PL/SQL to get them going. An update is possible in PL/SQL but it's eas

RE: Renumber a set of grupped rows?

At 06:49 PM 1/20/2004, you wrote: Not pretty but it should work: It does, thanks! maa SQL> create or replace procedure emprec 2 is 3cursor empcursor is 4 select empno, recno from emptest order by empno for update of recno; 5v_empno number := 9; 6v_count number

problem with log version

Hello everybody   I'm trying to recover a full database from a hot backup. When I execute the following instruction:   SQL>  recover database using  backup  controlfile until cancel;   Then I obtain the error ora-00331, This is the output: ORA-00279: change 1581950488 generated at 01/18/04 21:00:

Unusable partition index -- working funny

Hello All, I have a strange problem... I have a table on which i am doing an update. Its a partition table and the local index on the column which is being updated is in an unusable state. I have a database trigger at statement level (before update of col_a for ) where i do an execute

RE: All packages under sys is invalid

Yes & it's fix all the invalid objects. Thanks all -Original Message- Sent: Tuesday, January 20, 2004 1:29 PM To: Multiple recipients of list ORACLE-L Have you tried "$ORACLE_HOME/rdbms/admin/utlrp.sql" yet? This will usually recompile all invalid objects. Note that you have to run thi

Re: Parallel Query determined by?

No other replies yet, so here goes. First of all, what does it really mean when you say: users are complaining that Precise is showing a whole lot of time in "Parallel Sync Wait". Are these end users, or developers?  Seems rather curious that users would be mentioning this. Second, what % of

Re: Renumber a set of grupped rows?

Maryann Atkinson wrote: > > I have a 1-rows table with 2 columns, Emp_ID and Req_ID. > > There are about 150 different emp_ids in these 1+ records. > > What I want to do is the following: > > For every different Emp_id, I need the Rec_ids that corresponds to it > to be updated/renumbere

RE: Renumber a set of grupped rows?

Not pretty but it should work: SQL> create or replace procedure emprec 2 is 3cursor empcursor is 4 select empno, recno from emptest order by empno for update of recno; 5v_empno number := 9; 6v_count number := 0; 7 begin 8for x in empcursor loop 9

Re: Renumber a set of grupped rows?

> select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) > from emp > / Hm... but thats not available in 8i, is it? and besides, I want to update the table, not just select from it... ... thx maa At 06:19 PM 1/20/2004, you wrote: Maryann You can use the new windowing function,

RE: Spool to Excel File

> If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet! Didn't realize. In any case, Perl is a much superior tool for this.  The SpreadSheet::WriteExcel module  allow you to write to individual pages in a workbook. Jared

Re: Renumber a set of grupped rows?

Maryann You can use the new windowing function, here is test select working on emp :-) select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) from emp / DEPTNO ROW_NUMBER()OVER(PARTITIONBYDEPTNOORDERBYDEPTNO) -- 10

Re: OT: Developer Mailing List

There is no other list similar to this one. Mark Burgess <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/20/2004 01:29 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        OT: Deve

RE: RAC

Not personally. The testing that I did last year just used regular NBDs. I'm not sure what the difference is. Basically, the NBDs allow you to use container files as raw devices -- it's nice because you don't need to mess around with the disks, just create some files and serve them up through the

Re: Renumber a set of grupped rows?

Hi Maryann, I can do this easily when creating a new table using: create table new_table as select emp_id, row_number() over (partition by emp_id order by rec_id) as rec_id from original_table; Translating this into an update statement is probably a bit awkward for me - I'd just create

Re: Password management using profiles

You have to check for errors in the ORA-28000 range, for this is the range that password problems will use. Add a check in your connection section that will propagate any exception encountered. You can also trap the Oracle errors for password expiration or locked account and display a more under

Re: OT: Developer Mailing List

Hi, There is a newsgroup comp.databases.oracle.tools that covers Oracle development. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for deta

Re: Re[2]: Oracle vs Mysql

At 03:29 PM 1/20/2004, you wrote: I do indeed. Rumor was that rpt/rpf was written by Larry himself. Now I understand! I once applied for a job at Oracle, and got asked: What do you think about RPT/RPF. My answer: Probably som hobby-project of one or another developer, which, after demonstration t

Re: how do I interpret this in bstat/estat

Tim, Thanks a lot. This does help. The data that I have are a result from a test run, so I can't do anything right now, but this does give me something to look at if I see the enqueue timeouts increasing in the database in the future. thank you Gene --- Tim Gorman <[EMAIL PROTECTED]> wrote: >

RE: Re: Oracle vs Mysql

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, 20 January 2004 23:59 > To: Multiple recipients of list ORACLE-L > Subject: Re: Re: Oracle vs Mysql > > > if Oracle is offshoring its develeoping of its database, > eve

Renumber a set of grupped rows?

I have a 1-rows table with 2 columns, Emp_ID and Req_ID. There are about 150 different emp_ids in these 1+ records. What I want to do is the following: For every different Emp_id, I need the Rec_ids that corresponds to it to be updated/renumbered starting from 1 and keep going up by 1. S

RE: MS Access

You may want to look at the Oracle Migration workbench. http://otn.oracle.com/tech/migration/workbench/index.html I don't know if the slides are still available but there was a presentation at IOUG Live! 2002 titled "Migrating a Microsoft

RE: All packages under sys is invalid

So what's the recommendation, how can I recompile all the SYS packages? -Original Message- Sent: Tuesday, January 20, 2004 10:10 AM To: Multiple recipients of list ORACLE-L Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin. Dick Goulet Senior Oracle DBA Oracle Certi

RE: Oracle vs Mysql

Ahh. Re-read my post. The proper name of the product is "postgresql" and not "postgres". You should find 112 hits on books... HTH! :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Messa

how do I interpret this in bstat/estat

Hi. I am looking at the bstat/estat report and see a high number of enqueue timeouts in the statistics section of the report. How do I tackle that? In the Niemec's book he receoomends increasing the enqueue_resources parameter. Metalink says that these may be related to DISTRIBUTED_LOCK_TIMEOUT be

RE: RAC

Any experience with ENBD (Extended NBD), also from SourceForge? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 20, 2004 3:20 PM To: Multiple recipients of

RE: Oracle vs Mysql

Rich Amazon - Enter MySQL - 412 hits. The first screen of books are nearly all devoted to MySQL. Enter Postgres - 94 hits. None of the books on the first screen seem to be devoted to Postgres, but just mention it incidentally. Google - Enter MySQL - 15.6 million hits. Postgres - 733,000

RE: pga_aggregate_target and a memory leak

I have been asking questions on this list recently about a Possible similar problem recently with pl/sql tables. This was on hpux 11.11 with oracle 9.2.0.4 I still haven't found the answer completely but pat=0 and was_pol = manual Is a workaround that seems to be ok. I have a lack of time For furt

RE: Developer Mailing List

If you are looking for Oracle Development Tools, then check out the Oracle Development Tools User Group (ODTUG) at www.odtug.com On the home page you can go to the list serve page where you can sign up for any or all of about a dozen list serves devoted to Oracle tools. They are free so check

RE: Developer Mailing List

Mark - Maybe a good place to start is: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&group=comp.databases.orac le.tools (usenet newslist comp.databases.oracle.tools) If that doesn't suit you, post your request there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Messa

Re: Developer Mailing List

yes. they are listed on fatcity. the jdeveloper one is not active. ask your questions on the dev2k list. Its very active. Also, Ive been told the forums on otn are pretty active too. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January

Impact Analysis or GAP Analysis Document

Title: RE: MS Access Thanks guys, for pointing to the right place for Access issues.   Has some one got a document which you may have written for performing a conversion/migration from Access to Oracle, or for that matter any conversion. I want to look in the document, as to what issues are t

FW: ORA-904 after table rename

WhoopsMeant to send this to the list, not just Stephen. Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message- Sent: Tu

Re: ORA-904 after table rename

Ok, yeap I confused this with READ_EV, which can't read event from other sessions... Great job ;) Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 20, 2004 11:19 PM > For that, there is DBMS_SYSTEM.SET_EV. ;-) > > -Mark

Re: All packages under sys is invalid

Have you tried "$ORACLE_HOME/rdbms/admin/utlrp.sql" yet? This will usually recompile all invalid objects. Note that you have to run this script from SQL*Plus and have to be connected as SYS i.e. "connect / as sysdba". HTH, Faan - Original Message - To: "Multiple recipients of list ORACL

OT: Developer Mailing List

Hi Folks, does anyone know if there is a similar mailing list for Oracle development topics? Regards, Mark http://personals.yahoo.com.au - Yahoo! Personals New people, new possibilities. FREE for a limited time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-

RE: Re[2]: Oracle vs Mysql

If Mr Torvalds needs a security blanket, I'd be happy to send him several. Yes he crafted a wonderful OS & I sincerely hope he knocks Billy Gates down to size. Seems to be doing one heck of a job at it, even with SCO on MicroSlop's side. MS Anderson appears headed for the twilight, thank GOD.

AppsWorld in San Diego

Is anybody on this list attending AppsWorld in San Diego next week?   If so, any plans for an ORACLE-L get together?   Regards,Faan

Re: Re[2]: Oracle vs Mysql

> Dick, when you are talking about big mouth from Finland, you probably > don't refer to Pamela Anderson, also from Finland? The other person > from Finland, whom I will not mention except by the first name (Linus) > should be given credit for a wonderful OS that is successfully breaking > the MS m

RE: ORA-904 after table rename

One thing I've been looking for is a way to set a string parameter in another session, The two you mention handle INTEGER and BOOLEAN. I want a way to set TRACEFILE_IDENTIFIER to a string in another session to make it easier to identify trace files. Any ideas? Stephen >>> [EMAIL PROTECTED] 01/

RE: ORA-904 after table rename

For that, there is DBMS_SYSTEM.SET_EV. ;-) -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message- Sent: Tuesday, Ja

RE: RAC

If you are using Linux, you can use NBD's (network block devices) that will allow you to use a third PC as a storage device. You can download the drivers at http://nbd.sourceforge.net/ There's a pretty good paper out there as well, at http://www.fi.muni.cz/~kripac/orac-nbd/ that will walk you t

Re: Re[2]: Oracle vs Mysql

I know I used to set up RPT and do all sorts of complex updating things. At the State and with things coming from mainframes, the data organization seemed to lend itself well to RPT. Since the organization was like of loops within loops, I could take the high order update and then loop through

RE: Spool to Excel File

"SYLK allows cell references, etc, if needed, which you won't get with CSV. "   Ahh.  but you can with my method!  If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet!   Tom Mercadante Oracle Certified Professional

Re: Re[2]: Oracle vs Mysql

On 01/20/2004 03:29:33 PM, "Goulet, Dick" wrote: Jonathan, The only reason MySql is "known" better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Dick, when you are talking about big

Re: ORA-904 after table rename

But you can't set events with it :( Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 20, 2004 10:39 PM > You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and > DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradeb

Re: Password management using profiles

We're using pl/sql gateway and the Apache server. We've set up a default DAD on the gateway configuration screen, the connect string is our server name. Basic authentication, Package/Session Management Type: Stateless(Reset Package State). I've tried the profile by setting up a test user and

RE: Re[2]: Oracle vs Mysql

But, unless you have old diskettes... you'll never see them. They died with the demise of v5. -Original Message- Sent: Tuesday, January 20, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Yupp. RPF=report formatter or some such. -Original Message- eric king Sent: Tuesday,

Re: Spool to Excel File

Strange, no one has mentioned OWA_SYLK. Do a search on SYLK at asktom.oracle.com There are 2 versions, one for web output and one for excel output. SYLK allows cell references, etc, if needed, which you won't get with CSV. Jared "Mudhalvan, Moovarkku" <[EMAIL PROTECTED]> Sent by: [EMAI

RE: ORA-904 after table rename

You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug. -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him

RE: Re[2]: Oracle vs Mysql

Yupp. RPF=report formatter or some such. -Original Message- eric king Sent: Tuesday, January 20, 2004 1:19 PM To: Multiple recipients of list ORACLE-L What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: "Multiple recipients of list ORACL

RE: Re[2]: Oracle vs Mysql

Jonathan, The only reason MySql is "known" better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:49 PM To: Multiple rec

RE: Re[2]: Oracle vs Mysql

Eric, They were the precusors to Oracle reports. RPT was the report extraction tool, and RPF was the report formatter. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 3:19 PM To: Multiple recipients of list ORACLE-L Wha

Re: how do I interpret this in bstat/estat

Gene, This is the problem with high-level aggregate reports like BSTAT/ESTAT and STATSPACK. A possible problem is highlighted, but there is no detail on the possible cause. One way to get more info is monitor V$SESSION_EVENT view searching for sessions with lots of waits on "enqueue" wait-event:

RE: Oracle vs Mysql

Hence why Sql*Server is out there. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:29 PM To: Multiple recipients of list ORACLE-L Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Uni

Re: Password management using profiles

On 01/20/2004 02:34:45 PM, Ana Choto wrote: I have set up a profile where the passwords expire in 30 days, 6 characters minimum, grace period before the account locks to 6 days. It works as expected when the user logs in to our web site and tries to change the password. Users receive erro

Re: ORA-904 after table rename

On 01/20/2004 02:59:35 PM, Tanel Poder wrote: Hi! Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones. And that, exactly is the problem. First, when you set event using alter system, the setting is system wide. Second, if you wa

Re: Re[2]: Oracle vs Mysql

What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 20, 2004 11:19 AM > RPT was great stuff. In addition to SELECT statements it could do full > DML, DDL, and DCL (

Re: AQ

Hi! I think what Kirti meant here, is that from only database's point of view (scope), the "SQL*Net message from client" waits do not indicate any database bottlenecks. Anyway, when you have network bottleneck, from my experience you usually see other SQL*Net message waits, like "more data to/fro

Re: Oracle vs Mysql

On Tue, 20 Jan 2004, Mladen Gogala wrote: > I have a book devoted to PostgresSQL at home. When I come home, I'll > post the information. O'Reilly has "Practical Postgresql", the full text of which is also available online: http://www.commandprompt.com/ppbook/ I know there are a couple of others

how do I interpret this in bstat/estat

Hi. I am looking at the bstat/estat report and see a high number of enqueue timeouts in the statistics section of the report. How do I tackle that? In the Niemec's book he receoomends increasing the enqueue_resources parameter. Metalink says that these may be related to DISTRIBUTED_LOCK_TIMEOUT be

Re: pga_aggregate_target and a memory leak

[EMAIL PROTECTED] wrote: > > One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 > instance due to a possible memory leak. The only note on memory leaks and > pga_aggregate_target I can find on metalink is: 334427.995 > > doesnt seem to apply to pga_aggregate_targe

Re: ORA-904 after table rename

Hi! Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 20, 2004 4:19 PM > Oradebug is the right way

Password management using profiles

I have set up a profile where the passwords expire in 30 days, 6 characters minimum, grace period before the account locks to 6 days. It works as expected when the user logs in to our web site and tries to change the password. Users receive error messages whenever their password doesn't compl

RE: Spool to Excel File

I have used Microsoft Query in Excel. The syntax is a little tricky but it works pretty good. -Original Message- Sent: Tuesday, January 20, 2004 12:50 PM To: Multiple recipients of list ORACLE-L I've never used it before, but there is a piece to Excel called Microsoft query that allo

Inserts

This may be more on that parallel being set too high, but looking for ways to improve insert speed. I've seen the "APPEND" hint mentioned, but not sure if that speeds things up or simply says "Insert at the end". Also, a co-worker found a PL/SQL on a "degree=4" table that has a cursor, then one

Re[2]: Oracle vs Mysql

Tuesday, January 20, 2004, 1:29:25 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote: DW> I can recall editorials debating whether Unix/Oracle would ever be DW> industrial strength enough to support critical applications. I admit to not being involved in databases that far back, but I've read enough t

Parallel Query determined by?

I've inherited a system that has a whole lot of indexes set to degree 10 and many tables set to 2 & 4. The users are complaining that Precise is showing a whole lot of time in "Parallel Sync Wait". It is an HP box running 8.1.7.4 with 16 processors. The box is normally not very busy. Are there

RE: FW: Disk capacity planning

--- Niall Litchfield <[EMAIL PROTECTED]> wrote: > Hi > > The bad news is that I don't believe that > calculating IO/Sec *can* be done > for a *new* system. At least I'd like to see how it > is done. I'm willing to > bet that any formula for doing it will include (x%) > for 'overhead', which > actu

pga_aggregate_target and a memory leak

One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know ve

CSPP's latest report

If you are interested in latest report of CSPP(Computer Systems Policy Project)... http://www.cspp.org/reports/ChooseToCompete.pdf -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

RE: FW: Disk capacity planning

I found myself working with some "larger" databases in the 500-800 GB range that also spawn into multiple test databases. I take a "df -k" or "bdf" and bring that into excel. Then I take a query on all "autoextend" and break that out by disk. then I put that all together and tell what's left on

Re: Oracle vs Mysql

On 01/20/2004 01:29:25 PM, DENNIS WILLIAMS wrote: Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book "The Difference Between God and Larry Ellison" t

RE: Oracle vs Mysql

Huh???!?? What did you search for? I get many hits searching for "postgresql". Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 20, 2004 12:29 PM To: Multi

Re: Spool to Excel File

I've never used it before, but there is a piece to Excel called Microsoft query that allows you to query the database directly. Check help in Excel, search for query -> ways to retreive data from external sources. HTH, Mike

Re: NEW LYRICS TO BEATLES SONGS - OT but nice

Please, let's not turn this into a bulletin board. Spontaneous humor in a conversation (thread) is one thing, cutting and pasting completely non-relevant articles is another. For those of you that are non-native English speakers, the one thing... another thing  phrase means "don't do this". Jar

RE: tnsnames.ora not working ?

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This

RE: Oracle vs Mysql

Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book "The Difference Between God and Larry Ellison" tries to make is that the technically superior pro

Re[2]: Oracle vs Mysql

Tuesday, January 20, 2004, 12:44:43 PM, Daniel Hanks ([EMAIL PROTECTED]) wrote: DH> nd to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only DH> (iirc) if you use the 'Innodb' table type. My experience recently was just the opposite. I could create foreign key

Re: Re: Re[2]: Oracle vs Mysql

The old IBM System3 machines used 120 col. punch cards. And initially they had no HD's. Everything was done with cards and a reader/sorter. To compile a program you took the code you wrote, punched it into cards and then put it behind a stack of cards that was the compiler. The machine read the

RE: tnsnames.ora not working ?

what is the listener status?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Mess

RE: All packages under sys is invalid

Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 12:45 PM To: Multiple recipients of list ORACLE-L so what's the solution? -Original Message- Sent: Tu

Re: Spool to Excel File

If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/ With that you could slurp data out via DBI, and then build a customized spreadsheet based on the data. But I'd agree with what others have said. Dumping to csv

RE: FW: Disk capacity planning

Chris, Thanks. When people do what you say, it's kind of like what would have happened if NASA had used the following assumption throughout the Apollo project: "Assume adequate quantities of breathable air..." It would have made the planning phase much simpler, but it would have been a touch mor

Re: Oracle vs Mysql

On Wed, 14 Jan 2004, eric king wrote: > I think he is talking about 100GB database. Can PostgreSQL and MySQL handle > that size? We used MySQL in some of the web projects, but it just stores > small set of operational data and later on those data are moved to Oracle as > a permenant store. For sma

RE: All packages under sys is invalid

so what's the solution? -Original Message- Sent: Tuesday, January 20, 2004 4:10 AM To: Multiple recipients of list ORACLE-L Someone is messing with standard package ... so it would seem. Raj Rajendra dot J

RE: FW: Disk capacity planning

I agree wholeheartedly. This is why I think that anyone who attempts to size a system with formulas alone (that is, without testing) is almost 100% certain to either overspend miserably or downright fail. There are two things that are really important about testing. One is that it shows you how mu

Re: tnsnames.ora not working ?

On Tuesday 20 January 2004 11:20 am, Scott Canaan wrote: > Are you using Oracle Services? I've seen this happen before and we > change SERVICE_NAME to SID and everything works fine. That does not work for me either. RDB > -Original Message- > Reuben D. Budiardja > Sent: Tuesday, January

RE: RAC setup on linux [again]

There's a new-ish RAC/Linux install guide on OTN: http://otn.oracle.com/tech/linux/pdf/RAC_1030.pdf Interestingly enough the guide specifically shows *not* to alias "localhost" at all (page 9). Hmmm... Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED]

RE: Re[2]: Oracle vs Mysql

YES! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:10 AM To: Multiple recipients of list ORACLE-L Do you remember IBM System 3/10? RPGII & flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM

RE: Oracle vs Mysql

Inprocess actually. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:54 AM To: Multiple recipients of list ORACLE-L On 01/20/2004 09:19:44 AM, "Goulet, Dick" wrote: > Well, PostGreSql has all of those features, but handling 100G

RE: tnsnames.ora not working ?

If you have a line like this on your sqlnet.ora names.default_domain = world Then try putting an entry like this in tnsnames.ora dbname.world=(etc. etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Netwo

  1   2   >