RE: Schema comparison

"Smith, Ron L." wrote: > > I need to compare the schemas for two databases. I tried Toad, which will > tell me there are differences but it won't say what the differences are. > Does anyone have a script that will show the differences in detail? > > Ron Smith > DBA > Kerr-McGee Corp > There i

Re: PATCH?

Why, did you find a bug in the current version? Jared "Koivu, Lisa" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/29/2002 01:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:PATCH? How to

Oracle & Windows

This message bounced back to me as undeliverable. Just in case it got through, the 3rd link was bad and I have replaced it with the correct URL. I had copies still on my hard drive so I uploaded them. I emphasize that these are not my work but the work of the authors whose names appear on the p

Re: Which Unix command (part 2)

Here is another jewel I picked up from the shell news groups years and years ago. 6409:oracle@bart> cat dtree #!/bin/ksh # usage: vtree [-a] [dir] : make a tree printout of the specified directory. [ X$1 = X-a ] && andfiles=ON shift [ $# = 0 ] && set . set X "$@" until shift [ $# = 0 ]

Re:

[EMAIL PROTECTED] wrote: > HELP > no. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, Y

Re: Certification of Brainbuzz and BrainBench

Thank you Dennis... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday,

DB Creation Question

9i on XP Prof. on DELL PC.   I used DB Config. Assist. to create a DB and it looked like it worked (I have not used this tool before).  When I go out on the C drive I cannot find a subfolder with this DB name for the control files, redo logs, etc.  Where can I look to determine if this DB was

RE: Oracle Financials Sys Admin. Needed in South Carolina

Try out the Silicon valley, people! An *old* 3 bedroom townhome will start around 380/400k, with new ones going all the way upto the high 400s. *Not-new* single family homes start around 500s And add the 8% sales tax as well as the State Income tax, and your take home packet looks pretty meek.

[no subject]

HELP

Slow select distinct

I got a query that selects a list of addresses based an occurence at that location. this query comes back in less than 2 seconds without a distinct clause on the concatenated name. When I add the distict clause it takes over 40 seconds. I've tried adjusting various sort area sizes and buffer sizes

Re: PATCH?

When you find out, let me know... my patch bundle is scheduled to arrive September. "Koivu, Lisa" wrote: > > How to give birth? Please advise. > > Thx. --Lisa > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Koivu, Lisa > INET: [EMAIL PROTECTED] > > Fat

RE: PATCH?

RTFM. http://www.bcpl.net/~rgarriqu/babyman.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 29 Apr 2002, [EMAIL PROTECTED] wrote: > > EPIDURAL.. > > advice from the recently hatched (eight month old little girl:>) > > > -Original Message- > From: [E

SQL help

Hello all, I need some SQL help .. I have a table with containing duplicate records but because they have differents status they really are duplicate .. i need to find these .. here is an example of what the table contains : IDCompany Country Status 5521 ABC US 1

RE: Slow select distinct

John, If you don't use the DISTINCT, how many records are returned? The problem is that DISTINCT forces a sort, no way around it. Are you sorting in memory or disk? Dan Fink -Original Message- John-P55297 Sent: Monday, April 29, 2002 3:44 PM To: Multiple recipients of li

Re: access another user's data in a stored procedure - BECOME USER pr

For 3), you might hit a problem with executing PL/SQL. The error is PLS-00201 which appears to be related to bug 1724703 with current_schema. The workaround is to create a public synonym. "Magaliff, Bill" wrote: > > I'm writing a stored procedure to be run by the dba. I want to provide the

Re: Compare Schemas

Ron, For compares within Oracle, Oracle<-->SQLServer<-->DB2, etc., we think this is the best: http://www.iraje.com/compare-diff.htm links: http://www.iraje.com/acc_comparemain.htm http://www.iraje.com/ActiveCompare_viewlet.html DOWNLOAD: http://www.iraje.com/downloadmain.htm Keith Date: Mon,

RE: SQL help

This should get you a list of the combos of ID, Company & Country that are repeated in the table: SELECT ID, Company, Country, COUNT(*) NumRecs FROMmy_table GROUP BY ID, Company, Country HAVING COUNT(*) > 1 Or if you need all the records that belong to repeated combos of ID, Company & Coun

Re: Slow select distinct

Shaw John-P55297 wrote: > > I got a query that selects a list of addresses based an occurence at that > location. > this query comes back in less than 2 seconds without a distinct clause on > the concatenated name. When I add the distict clause it takes over 40 > seconds. I've tried adjusting var

RE: PATCH?

That is to much. Since we're trying to create a new process, this is very helpful. A possible enhancement is -money. The default value would false since the parent processes are often plagued by the undocumented options of -childcare, -clothing, -food, -sports, -cars, and -private_school. Pare

Re: SQL help

Here is your answer, SELECT ID,COMPANY,COUNTRY FROM table_name a WHERE rowid >(SELECT min(rowid) FROM table_name b WHERE b.ID = a.ID and a.COMPANY= b.COMPANY and a.COUNTRY=b.COUNTRY) ; Replace Select witth DELETE if you want to delete duplicates. Bunyamin K. Kar

pl/sql is INTERPRETED?

Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth? Can someone elab

Re: Oracle Financials Sys Admin. Needed in South Carolina

Something is horribly wrong with that calculator! From San Francisco or Manhattan to some small town in western Nebraska, salaries for DBAs only vary about 15-30%. These posts from OraStaff always seem to be for low-paying jobs, wanting significant experience in a number of technologies, demandi

Re: SQL help

k k wrote: > > Hello all, > > I need some SQL help .. I have a table with containing duplicate records but > because they have differents status they really are duplicate .. i need to > find these .. here is an example of what the table contains : > > IDCompany Country Status > 5521

RE: pl/sql is INTERPRETED?

See this note: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=151224.1 Regards, Waleed -Original Message- Sent: Monday, April 29, 2002 6:53 PM To: Multiple recipients of list ORACLE-L Can this be true? How can this be? If it's optimized

RE: PATCH?

At least you got it. Tell Brian to squeeze... Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]] > Sent: Monday, April 29, 2002 3:54 PM > To: Multiple recipients of list ORACLE-L > Subject: PATCH? > > How to give birt

Re: SQL help

HI K, You didn't say whether you have (or want) a unique constraint on these fields, but if you did (or do) you may consider the use of the exceptions table to identify which rows violate these constraints. An example below: SQL> create table junk (id varchar2(4), company varchar2(3), 2 cou

RE: Oracle Financials Sys Admin. Needed in South Carolina

i rather suspect you are right Don considering that Oracle 9i was released when ? summer of 2001 ? how can one have 2 years of experience on 9i ? they probably meant to say 2 years of Oracle DBA experience or something to that effect , but have no idea what the hell that means anyway. a

Re: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD

You silly! I was talking about the email admin at the guy's company, not fatcity. It has subsequently been explained to me that damagement is at fault (surprise) and ought to be blamed for all evil, not the email admin. http://www.dogdoo.com Ross can explain how brown fits into the metaphys

RE: pl/sql is INTERPRETED?

Waleed, have you actually tried this? Or anyone else for that matter? Jared "Khedr, Waleed" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/29/2002 04:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:

Re: ORACLE-L Digest -- Volume 2002, Number 117

http://www.dogdoo.com ORACLE-L Digest -- Volume 2002, Number 117 > -- > > From: [EMAIL PROTECTED] > Date: Fri, 26 Apr 2002 15:15:11 +0200 > Subject: Ms Access user forum > > Hallo, > > any one whom knows how where to find a good MsAccess user forum where I > ca

RE: PATCH?

Alter Mother Set Morhpine_Level = 10; Alter Mother Have_Baby_Now = TRUE; Alter Father Learn_To_Change_Diapers = TRUE; Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa > Sent:

fwd: Oracle/ODBC

Date sent: Sat, 27 Apr 2002 01:05:32 -0800 > -- > > From: "Gardiner, Steve" <[EMAIL PROTECTED]> > Date: Fri, 26 Apr 2002 13:07:15 -0500 > Subject: Oracle ODBC On Windows95 (Don't ask) :) > > ORACLE ODBC BRAIN DUMP from [EMAIL PROTECTED] > > The follow

RE:

CALL 911 -Original Message-From: Ravindra B [mailto:[EMAIL PROTECTED]]Sent: 30 April 2002 05:39To: Multiple recipients of list ORACLE-LSubject: HELP

RE: pl/sql is INTERPRETED?

I've just seen when I posted it. I knew Oracle had this feature for its Java engine. I will try to run something in native mode and compare its performance with the INTERPRETED one. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/29/02 7:48 PM Walee

RE:

F1   -Original Message-From: Ravindra B [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 30, 2002 3:09 AMTo: Multiple recipients of list ORACLE-LSubject: HELP

<    1   2