RE: Stubborn Table

Kevin, Fair enough... but ouch on that query! Rachel --- kkennedy <[EMAIL PROTECTED]> wrote: > Hi Rachel, > > Actually, the group by is because I only want one copy of each key. > You see the original query: > SELECT <> FROM MDMA_INPUT_FILE >WHERE <>=1 >ORDER BY record_type, archive_i

RE: MySQL versus Oracle

Title: RE: MySQL versus Oracle -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, 1 June 2002 11:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: MySQL versus Oracle snip This is to satisfy some reporting requirements for users of th

RE: * Certified Oracle DBAs Needed in the Dallas area..

Shucks only 18 years experience, but not OCP, and no 3 years in 8.x... Guess I'm out. :-) Maks. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mercadante, > Thomas F > Sent: Friday, May 31, 2002 11:28 AM > To: Multiple recipients of list ORACLE-L

Re: How to grant privileges on all the tables of owner1 to owner2?

On 2002.05.31 11:33 "Mandal, Ashoke" wrote: > Greetings, > > Here is the scenario. > I have 2 users(owner1, owner2) in an oracle database. > owner1 owns 150 tables. > owner2 needs select,insert,update,delete privilege on all the tables > owned by owner1. > > One option is : login as owner1 and

RE: Veritas Quick io

I just was wondering if you gain anything by putting TEMP on Quick IO or not. I understand the issues. We are probably going to QIO them to see if it buys us anything. I will check out Metaclunk. Thanks Arun for the tip about Cached QIO. We were going to tinker with that as well. We do

RE: MySQL versus Oracle

> MySQL doesn't claim to be ACID Here's a quote from the 4.0 manual about current features: "The table handler InnoDB is now offered as a feature of the standard MySQL server, including full support for transactions and row-level locking." InnoDB is also available starting with version 3.23.5.

RE: MySQL versus Oracle

How about Oracle *and* MySql? Has anyone designed a methodology and/or process for using MySql in mostly read databases to save on licensing? Replication for instance. I am currently replicating portions of 2 different schemas from different databases onto a 3 different schemas in a single dat

Re: ORA-600

Hi, Add event="10015 trace name context forever, level 10" to init.ora and restart db. A trace will be dumped which shows some rbs headers before and after recovery. can you email it ? Nalla Ravi wrote: > Dear All, > > I am gettying the follwoing error on our alert_log > file,though no porblem

RE: Veritas Quick io

Kathy, > The question was not HOW but SHOULD they be quick ioed. > I am asking for your opionions on whether Temp should be or not. I believe the problem is with sparse files (that are created by CREATE TEMPORARY TABLESPACE ...) since QIO cannot handle them. So, I would create (and use) a norm

RE: MySQL versus Oracle

-- "Orr, Steve" <[EMAIL PROTECTED]> on 05/31/02 14:14:20 -0800 > fastest growing database so someday they may be standards compliant. h... people used to say that about Oracle. Fat lot of good it did us... -- Steven Lembark 2930 W. Palmer Workhorse Computing

RE: MySQL versus Oracle

Title: RE: MySQL versus Oracle MySQL is ANSI 88 compliant, so they claim.  As far as ANSI 92, they mislead by saying they "Follow ANSI SQL 92 requirements" Jon -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 6:14 PM To: Multiple recipients

RE: MySQL versus Oracle

Title: RE: MySQL versus Oracle Also depends what you are doing.  The first person to do a read causes a TABLE LOCK.  No row level locking.  MySQL way to assure the data you see back is what it really is. But MySQL does have one nifty little feature, you can load tables into memory exclusively

RE: Stubborn Table

Hi Gary, Didn't try ROWID hint before, did just now. No plan change. I'm starting to re-code the update to use the subquery to bulk load a PL/SQL table then do the update in a forall loop. Seems silly and will be significantly less readable but Probably won't finish before I need to boog

RE: MySQL versus Oracle

-- "Weaver, Walt" <[EMAIL PROTECTED]> on 05/31/02 13:59:22 -0800 > If there's only one user accessing it, yes. > > --Walt > > -Original Message- > Sent: Friday, May 31, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > > > a) It's blindingly fast as a single user database, f

Re: undeliverable email - Yo Jared

Dave, Must be you, no one else is having this problem. :) Jared PS. If you really want me to see a message, cc me. It sometimes takes me a few days to get to everything on the list. "Farnsworth, Dave" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/30/2002 07:43 AM Please respond to OR

RE: ORA-600

Hi Micheal, Thanks, I would do that cheers, Ravi --- Michael P Sale <[EMAIL PROTECTED]> wrote: > This is an error that occurred while recovering from > a rolled back > transaction. Not a "database" recovery. > > This could be caused by doing a control-c while > trying to truncate a > large t

Networking problem

Title: Networking problem Hello list, I am having trouble with clients losing their connections to a 9.2 database. We have a Solaris 7 box running 8.1.7 and 9.2.0 and the clients that connect to this box will lose the connection to the 9.2.0 database after about 20 minutes.  The connecti

RE: Stubborn Table

Kevin, On the second query, try using IN instead of EXISTS ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any

RE: MySQL versus Oracle

If there's only one user accessing it, yes. --Walt -Original Message- Sent: Friday, May 31, 2002 3:44 PM To: Multiple recipients of list ORACLE-L a) It's blindingly fast as a single user database, faster then oracle. Really? Even with a 30 million record table? -Original Message

RE: Stubborn Table

Did you try a rowid hint? Gary -Original Message- Sent: Friday, May 31, 2002 5:49 PM To: Multiple recipients of list ORACLE-L Good point on the first query. The fields are nullable even though they logically should not be. I can feel several of my brain cells coming back to life. On

RE: MySQL versus Oracle

> It uses more or less standard SQL It's still far from ANSI compliant. The biggest criticism/complaint from the user community is the lack of subqueries (or "subselects" in MySQL jargon). They say it's the highest priority enhancement. They said it would be implemented in version 3.5X. Then they

Re: Stubborn Table

Rachel, you have an hawk eye, I had missed it (well, it has been a long day at the end of a long week). What I see, however, in the second statement is an EXISTS which adds nothing. A simple, uncorrelated IN *might* yield a better result since the other table is small. I am not sure that the CBO w

RE: Stubborn Table

Hi Rachel, Actually, the group by is because I only want one copy of each key. You see the original query: SELECT <> FROM MDMA_INPUT_FILE WHERE <>=1 ORDER BY record_type, archive_input_file, meter_identifier, units, data_time_stamp; did a full table scan and a gruesome sort taking 45 minu

RE: RE: Jr.DBA, Mid level DBA, Sr.DBA

So that's why the Gods died out... Hehehe... Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Weaver, Walt [SMTP:[EMAIL PROTECTED]] > Sent: Friday, May 31, 2002 2:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: Jr.DBA, Mid level DBA, Sr.

RE: Stubborn Table

Good point on the first query. The fields are nullable even though they logically should not be. I can feel several of my brain cells coming back to life. On the second query, I would dearly love for the optimizer to figure out that the subquery is a list of rowids and that rowid access is th

RE: MySQL versus Oracle

> MySQL is a fast moving target. August 2001 is a long time ago > in it's history. Tim, I'm an oracle DBA. You did an excellent job with the DBD driver for Oracle. Works like a charm! As far as MySQL is concerned, I'm far from being an expert. There is a good O'Reilly book about it, it comes wi

RE: So, What is a 'Production DBA'?

Mladen, This happened to me last week and was related to the support contract switching over to the new/renewed version. We called our rep and the TAR button was back almost immediately. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, May

RE: So, What is a 'Production DBA'?

I have the button to create tar and read tar privilege. Your admin must have changed it. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that

RMAN - Disk vs Tape backups

I am currently wrestling with whether to implement 'rman disk backups' or 'rman tape backups'. I have put together the following PRO's and CON's list so that I can weigh my options. I am putting this out to those on the list that are working with RMAN and care to add to the points i have made. It

RE: Veritas Quick io

1* Seems to have improved our read times. But I haven't really beachmarked it since we did this and a lot of tuning at the same time. 2* Yes 3* Yes we put in procedures so that you extend the file via qio we aren't giving the file more space on the disk. We are just growing as we go. n

RE: Veritas Quick io

we are using the quick I/O and as well as cached quik I/O also. I had configured this a quite long time ago I have forgotten about temp files issues which u people are talking about. But We did have issues by just using quick I/O cause it acts like a cooked raw file system and hence is write inten

RE: So, What is a 'Production DBA'?

Prod. DBA tends to be more cynical. Speaking of a Prod DBA, did anyone notice that you "iTAR" button in metalink is gone? When you take a look at your profile, you'll see that there is "Read TAR" privilege missing. > -Original Message- > From: Alexandre Gorbatchev [mailto:[EMAIL PROTECTED

RE: SQLServer copy table from 1 db to another

u can use the bcp utility that will be faster than DTS.. -Original Message- Sent: Friday, May 31, 2002 4:19 PM To: Multiple recipients of list ORACLE-L EXPORT the database. -Mensaje original- De: Gene Sais [mailto:[EMAIL PROTECTED]] Enviado el: Viernes, 31 de Mayo de 2002 1

RE: Veritas Quick io

Thanks but The question was not HOW but SHOULD they be quick ioed. I am asking for your opionions on whether Temp should be or not. Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are i

RE: Veritas Quick io

Kathy, > We are using Veritas Quick IO on our Solaris Box 6500 with > Oracle Apps 11.5.6 on 8.1.7.2 database. > > Right now we do not have the temp files converted to quick io > and wonder if we should. The guy who installed Quick IO > didn't seen to think we could but he was a pretty junior

RE: rebuilding indexes

Matt, What sort of indexes are these? What is the DML pattern that affect these indexes? Answers to these questions may give us a clue why this is occuring. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual f

RE: Stubborn Table

Kevin, The optimizer can't use an index on the first query, as it would miss any rows where Record_Type and Archive_Input_File are null, and hence not in the index. Are Record_Type and Archive_Input_File columns defined as not null? As for the 2nd query, what is the index which you expect it to

RE: Using RMAN

Debi, I run a weekly "restore validate" to make sure the tapes are available and working properly. Actually two runs a weekend - one for the database, and one for the archivelog backup. gives me a warm fuzzy every Monday morning. Tom Mercadante Oracle Certified Professional -Original Mes

RE: Stubborn Table

Kevin, If you do not include a "where" clause, how do you expect to use an index? Not gonna happen - sorry. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 31, 2002 3:32 PM To: Multiple recipients of list ORACLE-L Well, it's time to call for the cav

RE: SQLServer copy table from 1 db to another

EXPORT the database. -Mensaje original- De: Gene Sais [mailto:[EMAIL PROTECTED]] Enviado el: Viernes, 31 de Mayo de 2002 15:51 Para: Multiple recipients of list ORACLE-L Asunto: SQLServer copy table from 1 db to another Is there a way to copy a table in 1 sqlserver db to another, simila

Re: SQLServer copy table from 1 db to another

command line bcp bcp out bcp in -Joe --- Gene Sais <[EMAIL PROTECTED]> wrote: > Is there a way to copy a table in 1 sqlserver db to another, > similar to Oracle's exp/imp, or create tablle as select.., etc. It > appears the only way you can do it is thru DTS packages. > > > -- > Please see

Re: Stubborn Table

your first statement SELECT Record_Type, Archive_Input_File FROM MDMA_Input_File GROUP BY Record_Type, Archive_Input_File why GROUP BY and not ORDER BY? I mean, what are you grouping? I *think*, vague recollections, of reading that group by will force a full table scan. would be interesting t

RE: Jr.DBA, Mid level DBA, Sr.DBA

you win :) --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > REAL DBAs have 28 Etch-A-Sketches configured as RAC with Big Chief > Tablets > as their hot standby > > Daniel W. Fink > Sr. Oracle DBA > MICROMEDEX > 303.486.6456 > > > -Original Message- > Sent: Friday, May 31, 2002 1:01 PM > T

SQLServer copy table from 1 db to another

Is there a way to copy a table in 1 sqlserver db to another, similar to Oracle's exp/imp, or create tablle as select.., etc. It appears the only way you can do it is thru DTS packages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED

RE: RE: Jr.DBA, Mid level DBA, Sr.DBA

You guys are rookies. The Gods all use Linux. --Walt -Original Message- Sent: Friday, May 31, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Better run like WIND!! All Real DBA's use HP. Dick Goulet Reply Separator Author: Rachel Carmic

RE: Jr.DBA, Mid level DBA, Sr.DBA

REAL DBAs have 28 Etch-A-Sketches configured as RAC with Big Chief Tablets as their hot standby Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- Sent: Friday, May 31, 2002 1:01 PM To: Multiple recipients of list ORACLE-L AIX? Come on all really senior DBAs work

Stubborn Table

Well, it's time to call for the cavalry. I have a table where the optimizer stubbornly insists on doing full table scans for practically every operation in spite of the fact that full table scans have gruesome performance. Every hint I have tried has either been ignored or doesn't help (and y

RE: rebuilding indexes

Mathew, There has to be something that changed in the index or the storage parameters. The index storage is basically based on the database block size, the pctfree, the average length of the index entry, and the number of rows in the index. If you changed none of these the index should remain th

RE: Jr.DBA, Mid level DBA, Sr.DBA

it's fun so far. and one of these days I'll get to do DBA work too.. right now I'm trying to "Teach yourself Data warehousing in 2 weeks" --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > >> (ducking and running broken field pattern :) ) > > Opens black looking suitcase with secret Nuclear l

RE: Jr.DBA, Mid level DBA, Sr.DBA

>> (ducking and running broken field pattern :) ) Opens black looking suitcase with secret Nuclear launch codes, chanting the mantra, there is always a solution. Enjoying that new job? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: O

Using RMAN

At 10:11 AM 5/31/2002 -0800, DENNIS WILLIAMS wrote: >Pat - I think you've pretty well covered the pros/cons from what I >understand. I haven't implemented in production, so hopefully some people >with some experience of living with RMAN will respond. How about it guys? I have been using RMAN in p

Re:RE: Jr.DBA, Mid level DBA, Sr.DBA

Better run like WIND!! All Real DBA's use HP. Dick Goulet Reply Separator Author: Rachel Carmichael <[EMAIL PROTECTED]> Date: 5/31/2002 11:01 AM AIX? Come on all really senior DBAs work on SUN (ducking and running broken field pattern :) ) ---

RE: Veritas Quick io

Hi Kathy, Here is an excerpt from the Veritas Admin Guide. Chapter 3, Using VERITAS Quick I/O P69 Handling Oracle Temporary Tablespaces and Quick I/O You cannot convert temporary tablespaces using regular files to Quick I/O files. By default, qio_getdbfiles skips any tablespaces marked TE

Re: rebuilding indexes

it's definitely friday :) --- Jack Silvey <[EMAIL PROTECTED]> wrote: > Lose 20 blocks in 10 days! Load as much as you > normally do and still lose index width. > > no segment size restrictions or tiring delete routines > that never seem to finish. easy-to-follow > substr(column,1,1) update ro

RE: Jr.DBA, Mid level DBA, Sr.DBA

AIX? Come on all really senior DBAs work on SUN (ducking and running broken field pattern :) ) --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > A few thoughts... > > Jr. DBA: Asks the Mid or Sr. DBA where to look. > Mid DBA: Kind of knows where the answer is, but takes a bit to find > it.

RE: Veritas Quick io

Hi, The following link has the procedure to convert temp files to qio files.. http://support.veritas.com/docs/233722 We have converted our temp files to qio files and I think from performance point of they should be converted to qio. Mohammed Ahsanuddin Oracle DBA -Original Message-

Re: MySQL versus Oracle

On Fri, May 31, 2002 at 08:40:51AM -0800, Gogala, Mladen wrote: > I read few articles in Linux magazine and had it installed on > my box for a while and here are my impressions: > > a) It's blindingly fast as a single user database, faster then oracle. > b) It uses more or less standard SQL minus

Re: UPGRADE

I second that emotion. Write your plan down and think it through. Do some research about what problems you will encounter. Decide how to backout in the event that the data dictionary goes poof or all the datafile headers become inconsistent. Script and test your upgrade on another system if possib

Re: rebuilding indexes

Lose 20 blocks in 10 days! Load as much as you normally do and still lose index width. no segment size restrictions or tiring delete routines that never seem to finish. easy-to-follow substr(column,1,1) update routine that guarentees a maximum of data loss and a minimum of storage! email to [EMA

Veritas Quick io

We are using Veritas Quick IO on our Solaris Box 6500 with Oracle Apps 11.5.6 on 8.1.7.2 database. Right now we do not have the temp files converted to quick io and wonder if we should. The guy who installed Quick IO didn't seen to think we could but he was a pretty junior person. Anybody

RE: Oracle apps 10.7 client on Windows 2000

Thanks John John Kanagaraj <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/30/2002 03:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle apps 10.7 client on Windows 2000 Jar

RE: Jr.DBA, Mid level DBA, Sr.DBA

A few thoughts... Jr. DBA: Asks the Mid or Sr. DBA where to look. Mid DBA: Kind of knows where the answer is, but takes a bit to find it. Sr. DBA: Answer is dog eared in one or more of his office full of books. Really Sr. DBA: Answer is dog eared in his own book or paper. Jr. DBA: Feels a lot of

RE: rebuilding indexes

then the only thing I can think of is that there was heavy activity on the index prior to the rebuild and the blocks filled and the rebuild evened it out. --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> wrote: > > storage parameter difference? None > > are you moving from one ta

RE: rman duplicate dbid? AND rman catalog config options

Pat - I think you've pretty well covered the pros/cons from what I understand. I haven't implemented in production, so hopefully some people with some experience of living with RMAN will respond. How about it guys? One point bothered me. You didn't explicitly say that you were keeping your

RE: Jr.DBA, Mid level DBA, Sr.DBA

The jr thinks that she knows. The mid knows that she knows. The sr knows that she knows not. Awareness of ignorance is the mark of true knowledge. I like cake. jack silvey --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > I agree, the Jr. DBA must focus on learning. > Mid DBA...is still learning.

Re: rebuilding indexes

I'm sure it's #6 :) --- Jack Silvey <[EMAIL PROTECTED]> wrote: > Matt, > > 1) Storage parameter changes? Do you specify storage > at the index or tablespace (or top partition) > level?pctfree go up? initrans go up? bigger INITIAL or > NEXT? > > 2) did you build it the first time using parallel

Re: UPGRADE

don't do it this afternoon... read the release notes, check for any known bugs on Metalink and PLAN what you are going to do, including backout of the upgrade if necessary. upgrades are not not something you do on the spur of the moment. of course if you decide to do this anyway and it breaks, p

RE: Jr.DBA, Mid level DBA, Sr.DBA

>Attends sessions at IOUG >Junior - Assumes that all speakers know exactly what they are talking >about and all vendor tools work as advertised. >Mid - Listens to and believes Tim, Cary, Craig, Rich, Rachel, Gaja and >all other High Holy Oracle Gurus preach >Senior - Listens to, questions and te

Re: MySQL versus Oracle

Joe, If the interviewee's experience is all MySql, then he/she will not know about: * stored procedures * foreign keys * triggers ( I think ) * probably never heard of an ERD * no check constraints That's about the extent of my MySql knowledge. Depends a lot on the indivual, whether or not

Re: Design question.

Well then, that's not an FK. That's just two columns that the 'duhsigner' is copying to some other table, presenting a nice little update anomaly. You can soon expect different programs to return different answers from the database, depending on which table the data is queried from. Jared

RE: Jr.DBA, Mid level DBA, Sr.DBA

I agree, the Jr. DBA must focus on learning. Mid DBA...is still learning. Many Mid still view tuning/troubleshooting as an art (with a little magic thrown in) Sr. DBA...is still learning. Realizes that database management is a science, requiring research, expirementation and a very healthy dose of

RE: rebuilding indexes

But when you rebuild, it will reestablish the pctfree in all of the index blocks.  If you had a lot of activity this free space would have been used in the original index and is now reclaimed.   Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th Str

Re: rebuilding indexes

Matt, 1) Storage parameter changes? Do you specify storage at the index or tablespace (or top partition) level?pctfree go up? initrans go up? bigger INITIAL or NEXT? 2) did you build it the first time using parallelism and rebuild using single thread? When a PQ processes is used to build an obje

UPGRADE

Hi List, I have decided to Upgrade the database from 8.1.7.0 to 8.1.7.4 this afternoon on sun solaris. Please give me any advise before I go for upgrade. Thanks allot and have a good weekend Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Stat

RE: rebuilding indexes

Title: RE: rebuilding indexes storage parameter difference?  None  are you moving from one tablespace to another without specifying parameters?  No pctfree/pctused influence?  none I should have put this in the original message. Indexes stayed in original tablespace with identical st

RE: rman duplicate dbid? AND rman catalog config options

Bill : I have currently been wrestling with the same issues as you are : How best to configure RMAN. I have put together an 'RMAN Configuration Doc' with 'PROs and CONs' from information that I have scrapped together from this list, papers and books. Like anything in Oracle - no one configuration

RE: * Certified Oracle DBAs Needed in the Dallas area..

It's pretty funny what some people have bookmarked! :D JoJo -Original Message- | Joan Miro, "Man and Woman in Front of a Pile of Excrement" | (Homme et femme devant un tas d'excrements), 1935 97/8 x 125/8", | Joan Miro Foundation, Barcelona http://www.complit.fju.edu.tw/pro

RE: * Certified Oracle DBAs Needed in the Dallas area..

since '98 I've changed jobs about once a year. Of course from '78 to '98 I worked at the same company... wonder which of those they'd look at to determine if I had a "stable work history" --- Whittle Jerome Contr NCI <[EMAIL PROTECTED]> wrote: > I have a stable work history! As a teenager I work

RE: Any Equivalent of SAR command in NT/2000

Well, I was a VAX/VMS system administrator, and we were a spoiled lot who was used to things like the source code (on microfish, can you believe it?) and very good internal books. I once knew precisely at what IPL a page fault occurs (IPL 2), at which IPL is the clock running (IPL_SYNCH=8) and

Re: rebuilding indexes

storage parameter difference? are you moving from one tablespace to another without specifying parameters? pctfree/pctused influence? --- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]> wrote: > Under what conditions would an 'alter index .. rebuild' > actually case the size of the i

Re: Design question.

FK can be on unique columns, not just PK columns and you would not be allowed to add a row in the child table with a value not in the parent table unless the child row had a null in it --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > We have a designer that is adding a FK on two columns fr

RE: partition tables

Jack, Thanks for these great hints. I have not seen lots of these before and they have given me lots of ideas. Here's a question that you've induced: How do you determine what a good value is for INITRANS? What are the downsides of setting it too high? Thanks, Cherie Machler Oracle DBA Ge

RE: * Certified Oracle DBAs Needed in the Dallas area..

| Joan Miro, "Man and Woman in Front of a Pile of Excrement" | (Homme et femme devant un tas d'excrements), 1935 97/8 x 125/8", | Joan Miro Foundation, Barcelona http://www.complit.fju.edu.tw/project/project3/miro3-a.htm ( http://www.supersphere.com/Zinetropa/Article.html?ID=Angry_Tho

RE: MySQL versus Oracle

I read few articles in Linux magazine and had it installed on my box for a while and here are my impressions: a) It's blindingly fast as a single user database, faster then oracle. b) It uses more or less standard SQL minus all the unnecessary functions like substr, decode, nvl and alike whic

Functions

Hello all. I am seeking opinions of experienced database folks on this issue: I am implementing a replication environment between IBM DB2 and UNIX Oracle using DataMirror's Transformation Server (TS) product. TS replicates and transforms data between disparate databases. (Right now I am using

Re: MySQL versus Oracle

This depends on what the interview is for. MySQL, Oracle, Access, PostgresSQL, and SQLServer are all databases and can be accessed with SQL. Other than that, they are all completely different. On Fri, 31 May 2002, Joe Testa wrote: > Anyone on the list done a comparison(or worked with both) MyS

RE: * Certified Oracle DBAs Needed in the Dallas area..

8.x has been out for some time. I was using 8.0.4 back in '96 or so... RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features  Mastering Oracle8i    Clark Griswold

RE: Design question.

Title: RE: Design question. I agree that "Not Good" might characterize this - what it points out is "not good" table design.  the parent table now will have a row with two unique items - the existing primary kay, and a combination of two other columns.   I would review the tabl3e design and

RE: SQL Question

Try this select a.f1, a.d1, a.d2 from (select field1 f1,date1 d1,max(date2) d2 from temp group by field1,date1) a, (select field1 f1,date1 d1,max(date2) d2 from temp group by field1,date1) b where a.f1 = b.f1 and a.d1 < b.d1 and a.d2 > b.d2 -Original Message- Sent: Friday, May 31, 2

CLOBS AND Semicolons

Most of our Oracle databases are not that busy. I decided a week ago to start capturing individual SQL statements. I run a korn shell script every minute to do so. The script invokes the following SQL insert into oracle.statement_info (SID, USERNAME, STATUS, OSUSER, MACHINE, RUNTIME, A

Re: How to grant privileges on all the tables of owner1 to owner2?

try something like this: set serveroutput on size 100; declare v_sql varchar2(4000); cursor c_cur is select table_name from user_tables; begin begin for v_cur in c_cur loop v_sql = 'grant select,insert,update,delete on '||v_cur.table_name||' to owner2'; dbms_output.put_line('did '||v

RE: Design question.

Title: RE: Design question. Chris, Is there a unique constraint based on the two fields in the parent table? If so it might work OK. Still there are the problems of referential integrity, orphan records, etc. If there isn't a unique constraint in the parent table, you can also add in potent

RE: Design question.

Chris, The column in the parent table needs to be the PK or be unique. Should be no problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 31, 2002 11:33 AM To: Multiple recipients of list ORACLE-L We have a designer that is adding a FK on two colu

RE: How to grant privileges on all the tables of owner1 to owner2

Ashoke, Run the following script from the owner1 account: set head off set lines 120 set pages 200 spool grant.sql select 'grant select,insert,update,delete on ' || table_name || ' to owner2;' from user_tables / spool off @grant.sql good luck! Tom Mercadante Oracle Certified Professional ---

RE: MySQL versus Oracle

I'm trying to collect some links of resources that compares various databases Here is the result until today http://www.itsystems.lv/gints/compare_db.htm You all are welcomed to send more! Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/

SQL Question

Hi, I have a table with 1 field and 2 dates: field1, date1, date2. I need to find the max value of date2 for all the field1, date1 combinations. Then I want to join the table to itself on field1 and find all the rows where field1 matches, date1 < date1, and max(date2) > max(date2). I did t

RE: MySQL versus Oracle

Yes, that's exactly what I meant. -Original Message- Sent: Friday, May 31, 2002 9:59 AM To: Multiple recipients of list ORACLE-L The transition to oracle from mysql is a great deal more complicated than the inverse. I am hoping that is what you meant :} --- "Weaver, Walt" <[EMAIL PROT

How to grant privileges on all the tables of owner1 to owner2?

Greetings, Here is the scenario. I have 2 users(owner1, owner2) in an oracle database. owner1 owns 150 tables. owner2 needs select,insert,update,delete privilege on all the tables owned by owner1. One option is : login as owner1 and grant select,insert,update,delete on owner1.table1 to owner2

RE: MySQL versus Oracle

The transition to oracle from mysql is a great deal more complicated than the inverse. I am hoping that is what you meant :} --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > We use both here, use'em as back-end databases for > our hosted web sites. > > MySQL is fast, easy to set up and maintain,

Peoplesoft/EPM Administrator with Oracle/Unix Needed..

Stable Financial Services Company in Memphis, Tennessee needs a Peoplesoft/EPM Administrator for a full time staff position. PLEASE Do Not send your resume UNLESS you have the skills outlined below for this position. * Please do not send your resume unless you have a stable work history. Cand

  1   2   >