Re: Need a listserver for :-( ms sql server
Try these... http://www.mssqlserver.com/ http://www.sqlmag.com/ http://www.swynk.com/ ---This is listserv!!! http://www.sqlteam.com/ http://www.sqlwire.com/ http://ls.swynk.com/scripts/lyris.pl > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Friday, December 07, 2001 19:45 > > > > > > > Hi, > > > > > > Anyone know of a good list for mssql? > > > > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Robert Chin > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need a listserver for :-( ms sql server
Wh...what's that ? Robert Chin > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, December 07, 2001 19:45 > > > > Hi, > > > > Anyone know of a good list for mssql? > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Weakest Link
Uhm..Mike, you mean you've come across the *references* to it in prints/chat often, and not in your production db in your role as DBA, right ? Robert - Original Message - > You gotta be kidding! I see this so often I see it in my sleep! > "Snapshot too old: rollback segment...too small" > > Are you getting this error a lot? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Weakest Link
Q: Why does Larry Ellison keeps asking for bigger and bigger rollback segments ? A: Because he never commits ! Anyway I don't mean to rain on your parade but i think this game your scheming is kinda dumb. Personally at Christmas party (heck or any partyesp. when there's alcohol) I DO NOT want to hear NOTHING about Oracle, or MS...NADA ! And with dutch courage I'd probably poison anyone who gets into it and gets "technical". Robert - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 9:20 AM > Hello DBAs, > > I'm having a company holiday party today, and as you all may know my company > employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) > > I'm thinking of having a "DBA Weakest Link" game for fun at some point of > the evening. Yes, I know, the partners/husbands/wives will think it's a bit > of a bore, but imagine the fun for us DBAs! :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001, Number 333
Hey, I did not see Canadian there. I see a discrimination case coming. -Original Message- [EMAIL PROTECTED] Sent: Friday, December 07, 2001 5:20 PM To: Multiple recipients of list ORACLE-L 2001, Number 333 Is that the best you can do? ;) I recall something from the list many years ago where a poster was asking for help with a SQL statement that was unbelievably long. If I recollect correctly, it was about a 64K single SQL statement. It doesn't seem like maintaining something like that would actually be possible. Think of what the explain plan output would look like. Jared "Eric D. Pierce" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001, Sent by: Number 333 [EMAIL PROTECTED] om 12/07/01 04:20 PM Please respond to ORACLE-L 1 UPDATE 2 TRIO_STUDENT_MASTERF00S01part5 T 3 SET 4 ( 5 T.T08_STUDENT_RACE_ETHNICITY 6 ) 7 = ( 8 SELECT 9 decode( 10 decode( X.STU_ETH_CODE, 11 'D', '0', /* Declined to State*/ 12 '8', '0', /* Other (Not Listed)(10/8/1999 ??) */ 13 '9', '0', /* No Response */ 14 '1', '1', /* American Indian/ Native American */ 15 '2', '3', /* Black/ African American */ 16 '3', '4', /* Chicano/ Mexican American*/ 17 '4', '4', /* Other Hispanic (Not Listed) */ 18 'A', '4', /* Central American */ 19 'B', '4', /* South American */ 20 'P', '4', /* Puerto Rican */ 21 'Q', '4', /* Cuban*/ 22 '5', '2', /* Other Asian */ 23 'C', '2', /* Chinese */ 24 'J', '2', /* Japanese */ 25 'K', '2', /* Korean */ 26 'L', '2', /* Laotian */ 27 'M', '2', /* Cambodian*/ 28 'R', '2', /* Asian Indian */ 29 'S', '2', /* Other Southeast Asian*/ 30 'T', '2', /* Thai */ 31 'V', '2', /* Vietnamese */ 32 '6', '6', /* Other Pacific Islander (new 10/8/1999) */ 33 'F', '6', /* Filipino "" */ 34 'G', '6', /* Guamanian "" */ 35 'H', '6', /* Hawaiian "" */ 36 'N', '6', /* Samoan "" */ 37 '7', '5', /* White/ Caucasian */ 38 decode( Z.STU_ETH_CODE, 39 'D', '0', /* Declined to State */ 40 '8', '0', /* Other (Not Listed) (10/8/1999 ??) */ 41 '9', '0', /* No Response */ 42 '1', '1', /* American Indian/ Native American */ 43 '2', '3', /* Black/ African American */ 44 '3', '4', /* Chicano/ Mexican American */ 45 '4', '4', /* Other Hispanic (Not Listed) */ 46 'A', '4', /* Central American */ 47 'B', '4', /* South American */ 48 'P', '4', /* Puerto Rican */ 49 'Q', '4', /* Cuban */ 50 '5', '2', /* Other Asian */ 51 'C', '2', /* Chinese */ 52 'J', '2', /* Japanese */ 53 'K', '2', /* Korean */ 54 'L', '2', /* Laotian */ 55 'M', '2', /* Cambodian */ 56 'R', '2', /* Asian Indian */ 57 'S', '2', /* Other Southeast Asian */ 58 'T', '2', /* Thai */ 59 'V', '2', /* Vietnamese */ 60 '6', '6', /* Other Pacific Islander (new 10/8/1999) */ 61 'F', '6', /* Filipino "" */ 62 'G', '6', /* Guamanian "" */ 63 'H', '6', /* Hawaiian "" */ 64 'N', '6', /* Samoan "" */ 65 '7', '5', /* Wh
Re: Datawarehouse Sizes.....informal poll.
>> My short take on this is that a datawarehouse is a OLTP database.. What ??? I think you should keep that "short take" to yourself for the benefit of those who are seeking to learn/understand about DWH. It's not uncommon to find OLTP databases with de-normalized data, and they are certainly NOT DWH. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001,
I am willing to concede victory to you -Original Message- Kanagaraj Sent: Friday, December 07, 2001 5:15 PM To: Multiple recipients of list ORACLE-L 2001, Hi all, Beat this one: (this is just *one* of the ugly ones in an Apps environment - A developer and I are still working on tuning it) - runs for about 8 hours with *lots* and *lots* of unnecessary LIO due to nested joins on multiple tables each of which are >1 million Cannot tune this using CBO since this is *not* supported in Oracle Apps 10.7/7.3.4 (or even 11.0/8.0.6) for that matter. I win! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Wanna know the reason for the season? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** select ood.organization_code vendor_serial_number , vendor_lot_number , sph.date_shipped parent_serial_number , substr ( mil . segment1 , 2 , 7 ) order_number , msi . segment1 , msi . description , msn . attribute1 , msn . serial_number , sph . date_shipped , rac . customer_name , sha . attribute8 , cis . item_cost , gsb . name , ood . organization_code , gsb . currency_code , sota . name order_type , sha . attribute6 InSync , decode ( msn . serial_number , '' , sum ( moq . transaction_quantity ) , 1 ) trx_qty from snrrrep . cst_item_costs cis , snrrrep . xxg_in_product_structure_v xips , snrrrep . mtl_system_items msi , snrrrep . mtl_serial_numbers msn , snrrrep . mtl_item_locations mil , snrrrep . so_headers_all sha , snrrrep . so_picking_headers_all sph , snrrrep . so_picking_lines_all spl , snrrrep . so_order_types_all sota , snrrrep . ra_customers rac , snrrrep . gl_sets_of_books gsb , snrrrep . org_organization_definitions ood , snrrrep . mtl_secondary_inventories msec , snrrrep . mtl_onhand_quantities moq where ood . organization_id = msi . organization_id and gsb . set_of_books_id = ood . set_of_books_id and sha . customer_id = rac . customer_id (+) and msec.attribute3 = 'SNRR' and moq . locator_id = mil . inventory_location_id and moq . organization_id = mil . organization_id and moq . inventory_item_id = msi . inventory_item_id and moq . organization_id = msi . organization_id and msec . organization_id = moq . organization_id and msec . secondary_inventory_name = moq . subinventory_code and sha . order_type_id = sota . order_type_id (+) and moq . organization_id = msn . current_organization_id (+) and moq . inventory_item_id = msn . inventory_item_id (+) and moq . locator_id = msn . current_locator_id (+) and nvl ( msn . current_status , '' ) != 4 and substr ( mil . segment1 , 2 , 7 ) = to_char ( sha . order_number (+) ) and sha . header_id = sph . order_header_id (+) and sph . picking_header_id = spl . picking_header_id (+) and ( ( moq . inventory_item_id = spl . inventory_item_id ) OR ( substr ( mil . segment1 , 2 , 7 ) is null ) OR ( substr ( mil . segment1 , 2 , 7 ) not in ( Select to_char ( order_number ) from snrrrep . so_headers_all ) ) ) and ( ( spl . picking_line_id = ( select max ( spla1 . picking_line_id ) from snrrrep . so_picking_headers_all spha1 , snrrrep . so_picking_lines_all spla1 where spha1 . order_header_id = sha . header_id and spha1 . picking_header_id = spla1 . picking_header_id and spla1 . inventory_item_id = msi . inventory_item_id ) ) OR ( substr ( mil . segment1 , 2 , 7 ) not in ( Select to_char ( order_number ) from snrrrep . so_headers_all ) ) OR ( substr ( mil . segment1 , 2 , 7 ) is null ) ) and msi . inventory_item_id = xips . inventory_item_id and msi . organization_id = xips . organization_id and cis . inventory_item_id = msi . inventory_item_id and cis . organization_id = msi . organization_id and cis . cost_type_id = 1 and ood . organization_code between nvl ( : p_org_from , ood . organization_code ) and nvl ( : p_org_to , ood . organization_code ) and moq . subinventory_code between nvl ( : p_subinv_from , moq . subinventory_code ) and nvl ( : p_subinv_to , moq . subinventory_code ) and xips . product_line between nvl ( : p_prod_from , xips . product_line ) and nvl ( : p_prod_to , xips . product_line ) and msi . segment1 between nvl ( : p_item_from , msi . segment1 ) and nvl ( : p_item_to , msi . segment1 ) and nvl ( rac . customer_name , '@@@' ) between nvl ( : p_customer_from , nvl ( rac . customer_name , '@@@' ) ) and nvl ( : p_customer_to , nvl ( rac . customer_name , '@@@' ) ) and nvl ( substr ( mil . segment1 , 2 , 7 ) , '000' ) between nvl ( : p_so_from , nvl ( substr ( mil . segment1 , 2 , 7 ) , '000' ) ) and nvl ( : p_so_to , nvl ( substr ( mil . segment1 , 2 , 7 ) , '000' ) ) and nvl ( sha . attribute5 , '@@@' ) between nvl ( : p_insync_from , nvl ( sha . attribute5 , '@@@' ) ) and nvl ( : p_insync_to , nvl ( sha . attribute5 , '@@@' ) ) and nvl ( sph . date_shipped , sysdate ) between nvl ( : p_ship_date_from , nvl ( sph . date_shipped , sysdate ) ) and nvl ( : p_ship_date_to , nvl ( sph . date_shipped , sysdate ) ) and nvl ( msn . att
Re: Embedding perl in Oracle
Geez Andy, where *do* you get the energy. :) Jared On Wednesday 05 December 2001 02:22, Andy Duncan wrote: > Hi Tim, > > > > I've done it, it works. Be aware that setting it up is not trivial, > > > as the documentation is somewhat incomplete. > > > That is being remedied however... > > > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/ > > > > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.rea > >dme I'll take a look and add that to my Perl Whirl talk. > > You can also get hold of all of Jeff's other work, including the latest > extproc_perl, at his personal site: > > => http://www.smashing.org/ > > It's groovy, baby! :-) > > Also, some useful extra utiltities for using Doug MacEachern's > ExtUtils::Embed, which is used to drive extproc_perl, along with > OCIExtProcContext et al, can be found in the full ExtUtils::Embed tarball > download. Particularly useful for Win32 users, is the genmake utility: > > => http://www.cpan.org/authors/id/DOUGM/ > => http://www.cpan.org/authors/id/DOUGM/ExtUtils-Embed-1.14.tar.gz > > The extproc_perl Oracle Perl Procedure Library is, IMHO, an amazing piece > of work. Just for starters, as a super-basic example, you can write a > subroutine in a Perl bootfile, like this: > > sub perl_localtime { >my $x = localtime(time); >return $x; > } > > And get output like this: > > SQL> select perl('perl_localtime') localtime from dual; > > LOCALTIME > - > Wed Dec 5 10:12:20 2001 > > 1 row selected. > > SQL> > > You can also link back to the Oracle database from within the Perl bootfile > script using DBI, stay within the original transaction, and not create a > new connection, as with SQLJ etc. Fantastic stuff!!! > > I really _do_ have to get out more! 8-) > > Rgds, > AndyD > > = > Make Someone Happy. Buy a Copy of: > => http://www.oreilly.com/catalog/oracleopen/ > -BEGIN GEEK CODE BLOCK- > GO/SS/TW d- s+:+ a C++$ U++$ P$ L++$ !E W+ N+ K- W O- > M+ V-- PS+ PE++ Y+ PGP t+@ 5 X- R* tv- b+++ DI++ D G e++ > h r+++ y > --END GEEK CODE BLOCK-- > > __ > Do You Yahoo!? > Buy the perfect holiday gifts at Yahoo! Shopping. > http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAID system max throughput
-- DENNIS WILLIAMS <[EMAIL PROTECTED]> > Whenever I discuss disk waits with my system administrator, I always get > the reply that "the RAID system isn't anywhere near its rated > throughput". Maybe I'm wrong, but I don't see any of the tuning books > mentioning that as a relevant performance characteristic. However, I've > never been able to move the discussion beyond this point. Can anyone > straighten me out on this point or point me to a resource that might be > applicable. > > Our system is Oracle 8.1.6, Compaq Tru64. We use hardware RAID-5 with a > battery-backed RAM cache, and have about 3 RAID sets (plus some extra > disks for redo logs, etc.), and performance is fine, but I'm always > looking as to how we can improve Oracle performance. The application is > our corporate ERP system. Two things will zap you on device I/O: bandwidth or latency. Most people look at bandwidth -- same basic numbers for both networking and disks. Latency is basically the turnaround time. If you screw up the setup of any I/O system then latency can reduce performance to the point where bandwidth is irrelevant. By analogy, you can put concrete tires on a Porsche and go nowhere also. The real measure of what's going on starts at the O/S level looking at the frequency and duration of proc's in a device wait state (a.k.a. "blocked for I/O") on the disks. If this is minimal then forget it. You can also end up with screwy results on large shared disk systems due to competition. SAN's can get placed on overloaded network segments; ERP's can easily get hot-spots from various users colliding. In general RAID5 with a stripe size == system I/O page will perform rather nicely. If your system page sizes vary or the raidset has an offball number of disks (e.g., 6 drives for an 8K page) then you'll take a hit writing extra data to maintain the RAID5 parity. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAID system max throughput
This reminds me of my experiences with IBM a couple of years ago. The IBM Shark is a decent piece of storage HW, but does have some funky aspects. Regarding the vendor claims, when I took a close look at their claimed throughput numbers, it became clear that the only way to achieve their claims was to get a 100% hit rate on the Disk Cache. That didn't seem too likely to me. Here's a tidbit: unless they've changed their architecture, IBM Shark only does Raid 5. And you can't get the same number of physical disks in each physical volume. And you must split a PV into at least 2 LV, as the volume manager couldn't make a logical volume as large as the physical volume. Jared "Don Granaman" .com>cc: Sent by: Subject: Re: RAID system max throughput [EMAIL PROTECTED] om 12/07/01 03:15 PM Please respond to ORACLE-L Whenever someone (especially a vendor) says something like "Don't worry about it...", I worry about it. Who told you that this was "simplistic thinking"? I've been told similar things a number of times - and proved them wrong in every single case. "With hardware RAID, RAID-5 is just as fast as RAID 1+0". "With EMC Symmetrix you don't want to stripe". "SAME - Just splatter all your files randomly across a monster stripe set using every possible disk". And the ever popular one you are encountering now. A lot of those things are at true - to a point. Beyond that point it matters. Hardware RAID, cache, and such can buy you performance, but there is still some threshold beyond which the old-timey DBA intelligent file placement, striping and such will be necessary. There is a difference between "good enough for now" and "optimal". I would rather build it better from the start, even if I don't need the performance immediately, than wait until its a crisis and only then frantically rebuild everything. See Gaja's paper on RAID at http://www.quest.com/whitepapers/Raid1.pdf . -Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 4:31 PM > Jack - Well, that's what I thought. I could see where the disk would be a > lot better about streaming data off the disk if the data was arranged in a > favorable manner rather than randomly located. However, I was told that was > simplistic thinking and that modern RAID systems are much more sophisticated > than that. And I'm willing to concede that a RAID system is more complex > than simple drives. I'm just hoping that someone on this list has more > experience on the database/hardware interface. Thanks. > > -Original Message- > Sent: Friday, December 07, 2001 3:25 PM > To: Multiple recipients of list ORACLE-L > > > Dennis, > > I'm no RAID guru, but I can sure imagine disk heads thrashing around, trying > to satisfy a mix of sequential and random reads and writes, causing the DB > to wait, but not getting anywhere near the rated throughput for the RAID > controller or channel. > > Could that possibly be the case? > > Jack > > > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > > -Original Message- > WILLIAMS > Sent: Friday, December 07, 2001 10:40 AM > To: Multiple recipients of list ORACLE-L > > > Whenever I discuss disk waits with my system administrator, I always get th
RE: DBA Weakest Link
Q: On what platform does Oracle perform the best? A: 16mm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001, Number 333
Is that the best you can do? ;) I recall something from the list many years ago where a poster was asking for help with a SQL statement that was unbelievably long. If I recollect correctly, it was about a 64K single SQL statement. It doesn't seem like maintaining something like that would actually be possible. Think of what the explain plan output would look like. Jared "Eric D. Pierce" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001, Sent by: Number 333 [EMAIL PROTECTED] om 12/07/01 04:20 PM Please respond to ORACLE-L 1 UPDATE 2 TRIO_STUDENT_MASTERF00S01part5 T 3 SET 4 ( 5 T.T08_STUDENT_RACE_ETHNICITY 6 ) 7 = ( 8 SELECT 9 decode( 10 decode( X.STU_ETH_CODE, 11 'D', '0', /* Declined to State*/ 12 '8', '0', /* Other (Not Listed)(10/8/1999 ??) */ 13 '9', '0', /* No Response */ 14 '1', '1', /* American Indian/ Native American */ 15 '2', '3', /* Black/ African American */ 16 '3', '4', /* Chicano/ Mexican American*/ 17 '4', '4', /* Other Hispanic (Not Listed) */ 18 'A', '4', /* Central American */ 19 'B', '4', /* South American */ 20 'P', '4', /* Puerto Rican */ 21 'Q', '4', /* Cuban*/ 22 '5', '2', /* Other Asian */ 23 'C', '2', /* Chinese */ 24 'J', '2', /* Japanese */ 25 'K', '2', /* Korean */ 26 'L', '2', /* Laotian */ 27 'M', '2', /* Cambodian*/ 28 'R', '2', /* Asian Indian */ 29 'S', '2', /* Other Southeast Asian*/ 30 'T', '2', /* Thai */ 31 'V', '2', /* Vietnamese */ 32 '6', '6', /* Other Pacific Islander (new 10/8/1999) */ 33 'F', '6', /* Filipino "" */ 34 'G', '6', /* Guamanian "" */ 35 'H', '6', /* Hawaiian "" */ 36 'N', '6', /* Samoan "" */ 37 '7', '5', /* White/ Caucasian */ 38 decode( Z.STU_ETH_CODE, 39 'D', '0', /* Declined to State */ 40 '8', '0', /* Other (Not Listed) (10/8/1999 ??) */ 41 '9', '0', /* No Response */ 42 '1', '1', /* American Indian/ Native American */ 43 '2', '3', /* Black/ African American */ 44 '3', '4', /* Chicano/ Mexican American */ 45 '4', '4', /* Other Hispanic (Not Listed) */ 46 'A', '4', /* Central American */ 47 'B', '4', /* South American */ 48 'P',
RE: ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001,
Hi all, Beat this one: (this is just *one* of the ugly ones in an Apps environment - A developer and I are still working on tuning it) - runs for about 8 hours with *lots* and *lots* of unnecessary LIO due to nested joins on multiple tables each of which are >1 million Cannot tune this using CBO since this is *not* supported in Oracle Apps 10.7/7.3.4 (or even 11.0/8.0.6) for that matter. I win! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Wanna know the reason for the season? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** select ood.organization_code vendor_serial_number , vendor_lot_number , sph.date_shipped parent_serial_number , substr ( mil . segment1 , 2 , 7 ) order_number , msi . segment1 , msi . description , msn . attribute1 , msn . serial_number , sph . date_shipped , rac . customer_name , sha . attribute8 , cis . item_cost , gsb . name , ood . organization_code , gsb . currency_code , sota . name order_type , sha . attribute6 InSync , decode ( msn . serial_number , '' , sum ( moq . transaction_quantity ) , 1 ) trx_qty from snrrrep . cst_item_costs cis , snrrrep . xxg_in_product_structure_v xips , snrrrep . mtl_system_items msi , snrrrep . mtl_serial_numbers msn , snrrrep . mtl_item_locations mil , snrrrep . so_headers_all sha , snrrrep . so_picking_headers_all sph , snrrrep . so_picking_lines_all spl , snrrrep . so_order_types_all sota , snrrrep . ra_customers rac , snrrrep . gl_sets_of_books gsb , snrrrep . org_organization_definitions ood , snrrrep . mtl_secondary_inventories msec , snrrrep . mtl_onhand_quantities moq where ood . organization_id = msi . organization_id and gsb . set_of_books_id = ood . set_of_books_id and sha . customer_id = rac . customer_id (+) and msec.attribute3 = 'SNRR' and moq . locator_id = mil . inventory_location_id and moq . organization_id = mil . organization_id and moq . inventory_item_id = msi . inventory_item_id and moq . organization_id = msi . organization_id and msec . organization_id = moq . organization_id and msec . secondary_inventory_name = moq . subinventory_code and sha . order_type_id = sota . order_type_id (+) and moq . organization_id = msn . current_organization_id (+) and moq . inventory_item_id = msn . inventory_item_id (+) and moq . locator_id = msn . current_locator_id (+) and nvl ( msn . current_status , '' ) != 4 and substr ( mil . segment1 , 2 , 7 ) = to_char ( sha . order_number (+) ) and sha . header_id = sph . order_header_id (+) and sph . picking_header_id = spl . picking_header_id (+) and ( ( moq . inventory_item_id = spl . inventory_item_id ) OR ( substr ( mil . segment1 , 2 , 7 ) is null ) OR ( substr ( mil . segment1 , 2 , 7 ) not in ( Select to_char ( order_number ) from snrrrep . so_headers_all ) ) ) and ( ( spl . picking_line_id = ( select max ( spla1 . picking_line_id ) from snrrrep . so_picking_headers_all spha1 , snrrrep . so_picking_lines_all spla1 where spha1 . order_header_id = sha . header_id and spha1 . picking_header_id = spla1 . picking_header_id and spla1 . inventory_item_id = msi . inventory_item_id ) ) OR ( substr ( mil . segment1 , 2 , 7 ) not in ( Select to_char ( order_number ) from snrrrep . so_headers_all ) ) OR ( substr ( mil . segment1 , 2 , 7 ) is null ) ) and msi . inventory_item_id = xips . inventory_item_id and msi . organization_id = xips . organization_id and cis . inventory_item_id = msi . inventory_item_id and cis . organization_id = msi . organization_id and cis . cost_type_id = 1 and ood . organization_code between nvl ( : p_org_from , ood . organization_code ) and nvl ( : p_org_to , ood . organization_code ) and moq . subinventory_code between nvl ( : p_subinv_from , moq . subinventory_code ) and nvl ( : p_subinv_to , moq . subinventory_code ) and xips . product_line between nvl ( : p_prod_from , xips . product_line ) and nvl ( : p_prod_to , xips . product_line ) and msi . segment1 between nvl ( : p_item_from , msi . segment1 ) and nvl ( : p_item_to , msi . segment1 ) and nvl ( rac . customer_name , '@@@' ) between nvl ( : p_customer_from , nvl ( rac . customer_name , '@@@' ) ) and nvl ( : p_customer_to , nvl ( rac . customer_name , '@@@' ) ) and nvl ( substr ( mil . segment1 , 2 , 7 ) , '000' ) between nvl ( : p_so_from , nvl ( substr ( mil . segment1 , 2 , 7 ) , '000' ) ) and nvl ( : p_so_to , nvl ( substr ( mil . segment1 , 2 , 7 ) , '000' ) ) and nvl ( sha . attribute5 , '@@@' ) between nvl ( : p_insync_from , nvl ( sha . attribute5 , '@@@' ) ) and nvl ( : p_insync_to , nvl ( sha . attribute5 , '@@@' ) ) and nvl ( sph . date_shipped , sysdate ) between nvl ( : p_ship_date_from , nvl ( sph . date_shipped , sysdate ) ) and nvl ( : p_ship_date_to , nvl ( sph . date_shipped , sysdate ) ) and nvl ( msn . attribute1 , '@@@' ) between nvl ( : p_lo_from , nvl ( msn . attribute1 , '@@@' ) ) and nvl ( : p_lo_to , nvl ( msn . attribute1 , '@@@' ) ) group by substr ( mil . segment1
Re: Siebel.
Yeah, but things do change over time, and that book is a few years old now. There's good reason at times to use RI with a data mart, such as you need it if you expect star joins to work. Oracle has made some changes that reduce the impact of having the RI in place. Jared Scott Shafer .COM>cc: Sent by: Subject: Re: Siebel. [EMAIL PROTECTED] om 11/28/01 04:15 PM Please respond to ORACLE-L I seem to remember Ralph Kimball writing in one of his DW books that the RI and constraints should be enforced in the app layer as well. However I might be wrong (once this year isn't too bad, eh?) ;-P Scott Shafer San Antonio, TX Henry Poras wrote: > > That is probably true to an extent but it doesn't explain some of the messes > I've seen. > > Henry > > -Original Message- > Sent: Wednesday, November 28, 2001 3:14 PM > To: Multiple recipients of list ORACLE-L > > I have heard that they do this on purpose because their products have to be > RDBMS neutral. They have to work on RDBMS's that don't have built-in RI. > > Tom Terrian > Oracle DBA > WPAFB - DAASC > [EMAIL PROTECTED] > 937-656-3844 > > -Original Message- > Sent: Wednesday, November 28, 2001 2:46 PM > To: Multiple recipients of list ORACLE-L > > Does anybody else get the same feeling as me that it is not that vendors are > ignoring proper data models, they don't even know what they are. > > Henry > > -Original Message- > Sent: Wednesday, November 28, 2001 2:14 PM > To: Multiple recipients of list ORACLE-L > > Unfortunately it's the case way too often. Even at the enlightened place > where I work, our RI is done at the application level. > > Not much I can do about it. Our development is done on MySQL and then > "ported" to Oracle. > > --Walt Weaver > Bozeman, Montana, USA > > -Original Message- > Sent: Wednesday, November 28, 2001 11:55 AM > To: Multiple recipients of list ORACLE-L > > > > BAH!! These bloody application providers leaving the integrity to their > bloody applications instead of leaving it in it's rightful place in the > database!!! Makes my life 10 times harder!!! Got no consideration at all > have they? > > > > :P > > Thanks! > > Mark > > -Original Message- > [EMAIL PROTECTED] > Sent: 28 November 2001 17:46 > To: Multiple recipients of list ORACLE-L > > We use Siebel and no it does NOT have RI. > > "Mark Leith" <[EMAIL PROTECTED]>@fatcity.com on 11/28/2001 10:56:07 AM > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > > Hi Gang, > > Does anybody use Siebel - I believe it's a CRM package? > > I'm trying to find out of the Siebel application enforces RI within the > database or the application? Anybody know? > > Cheers > > Mark > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ---
(Fwd) Destination address unreachable
trying again --- Forwarded message follows --- trying again ... > > just catching up from last week, sorry if this was answered already. > > mount points ?? > > ORACLE-L Digest -- Volume 2001, Number 333 > > From: mohammed bhatti <[EMAIL PROTECTED]> > > Date: Wed, 28 Nov 2001 09:03:22 -0800 (PST) > > Subject: OT: Win2K Drive Mapping Question > > > > Anyone know how to map more than 26 drives on Win2K > > workstation? I trying to map 36 servers to a > > workstation. > --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ugly sql contest entry / Re: ORACLE-L Digest -- Volume 2001, Number 333
1 UPDATE 2 TRIO_STUDENT_MASTERF00S01part5 T 3 SET 4 ( 5 T.T08_STUDENT_RACE_ETHNICITY 6 ) 7 = ( 8 SELECT 9 decode( 10 decode( X.STU_ETH_CODE, 11 'D', '0', /* Declined to State*/ 12 '8', '0', /* Other (Not Listed)(10/8/1999 ??) */ 13 '9', '0', /* No Response */ 14 '1', '1', /* American Indian/ Native American */ 15 '2', '3', /* Black/ African American */ 16 '3', '4', /* Chicano/ Mexican American*/ 17 '4', '4', /* Other Hispanic (Not Listed) */ 18 'A', '4', /* Central American */ 19 'B', '4', /* South American */ 20 'P', '4', /* Puerto Rican */ 21 'Q', '4', /* Cuban*/ 22 '5', '2', /* Other Asian */ 23 'C', '2', /* Chinese */ 24 'J', '2', /* Japanese */ 25 'K', '2', /* Korean */ 26 'L', '2', /* Laotian */ 27 'M', '2', /* Cambodian*/ 28 'R', '2', /* Asian Indian */ 29 'S', '2', /* Other Southeast Asian*/ 30 'T', '2', /* Thai */ 31 'V', '2', /* Vietnamese */ 32 '6', '6', /* Other Pacific Islander (new 10/8/1999) */ 33 'F', '6', /* Filipino "" */ 34 'G', '6', /* Guamanian "" */ 35 'H', '6', /* Hawaiian "" */ 36 'N', '6', /* Samoan "" */ 37 '7', '5', /* White/ Caucasian */ 38 decode( Z.STU_ETH_CODE, 39 'D', '0', /* Declined to State*/ 40 '8', '0', /* Other (Not Listed)(10/8/1999 ??) */ 41 '9', '0', /* No Response */ 42 '1', '1', /* American Indian/ Native American */ 43 '2', '3', /* Black/ African American */ 44 '3', '4', /* Chicano/ Mexican American*/ 45 '4', '4', /* Other Hispanic (Not Listed) */ 46 'A', '4', /* Central American */ 47 'B', '4', /* South American */ 48 'P', '4', /* Puerto Rican */ 49 'Q', '4', /* Cuban*/ 50 '5', '2', /* Other Asian */ 51 'C', '2', /* Chinese */ 52 'J', '2', /* Japanese */ 53 'K', '2', /* Korean */ 54 'L', '2', /* Laotian */ 55 'M', '2', /* Cambodian*/ 56 'R', '2', /* Asian Indian */ 57 'S', '2', /* Other Southeast Asian*/ 58 'T', '2', /* Thai */ 59 'V', '2', /* Vietnamese */ 60 '6', '6', /* Other Pacific Islander (new 10/8/1999) */ 61 'F', '6', /* Filipino "" */ 62 'G', '6', /* Guamanian "" */ 63 'H', '6', /* Hawaiian "" */ 64 'N', '6', /* Samoan "" */ 65 '7', '5', /* White/ Caucasian */ 66 '*** no/bad data ***' 67) 68 ), 69 '1', '1', 70 '2', '2', 71 '3', '3', 72 '4', '4', 73 '5', '5', 74 '6', '6', 75 '7', '7', 76 '0', 77 decode( t.student_ssn, 78 '[several deleted]', '5', ... 101'x' 102 ), 103 '*' 104 ) 105FROM 106 TRIO_STUDENT_MASTERF00S01part5 T2, 107 SIS_CSUS_ALL_spring2001_eos1 X, 108 SIS_CSUS_ALL_fall_2000_eos1 Z 109 WHERE 110 T.STUDENT_SSN
Re: ORACLE-L Digest -- Volume 2001, Number 333
I think ugly SQL is appropriate. We certainly see enough of it here anyway. :) Jared "Eric D. Pierce" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: ORACLE-L Digest -- Volume 2001, Number 333 Sent by: [EMAIL PROTECTED] om 12/07/01 02:55 PM Please respond to ORACLE-L do we need to have a "ugliest SQL statement" contest? OT list? I have an entry ready ORACLE-L Digest -- Volume 2001, Number 333 > -- > > From: "Toepke, Kevin M" <[EMAIL PROTECTED]> > Date: Wed, 28 Nov 2001 12:44:29 -0500 > Subject: RE: Longest SQL statements!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Column Title
Title: RE: Column Title Binay, Only this database has cursor_sharing=force in init.ora file. This is a bug, you can check Metalink. Alex. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 4:55 AM To: Multiple recipients of list ORACLE-L Subject: RE: Column Title Thanks Alex, It worked fine. Still wondering how come that this problem is only there in one of the 16 Oracle database instance ? -Binay Binay, It is a bug related to cursor_sharing=force. Try alter session set cursor_sharing=exact. Alex. -Original Message- Sent: Wednesday, December 05, 2001 9:25 AM To: Multiple recipients of list ORACLE-L Hello DBA-Gurus, Executing the same query on 2 databases, but getting different output- the column title. In all the databases its limited to the value of the row except in one database we've. All the databases are of 8.1.7.2 running on IBM/unix server. Database- A -- select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual; SUB --- LET Database-B -- select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual; SUBSTR('LETMEBABYONEMORET LET See the output of Database-B - that's the difference from the others.It seems that its a database specific problem- we tried with all SQLPLUS versions, both Unix and Windows and objerved the same. Eager to know what makes the difference - all your comments are welcome. Thanks -Binay --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need a listserver for :-( ms sql server
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 19:45 > Hi, > > Anyone know of a good list for mssql? > try these: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax282897,0 0.html hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAID system max throughput
Whenever someone (especially a vendor) says something like "Don't worry about it...", I worry about it. Who told you that this was "simplistic thinking"? I've been told similar things a number of times - and proved them wrong in every single case. "With hardware RAID, RAID-5 is just as fast as RAID 1+0". "With EMC Symmetrix you don't want to stripe". "SAME - Just splatter all your files randomly across a monster stripe set using every possible disk". And the ever popular one you are encountering now. A lot of those things are at true - to a point. Beyond that point it matters. Hardware RAID, cache, and such can buy you performance, but there is still some threshold beyond which the old-timey DBA intelligent file placement, striping and such will be necessary. There is a difference between "good enough for now" and "optimal". I would rather build it better from the start, even if I don't need the performance immediately, than wait until its a crisis and only then frantically rebuild everything. See Gaja's paper on RAID at http://www.quest.com/whitepapers/Raid1.pdf . -Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 4:31 PM > Jack - Well, that's what I thought. I could see where the disk would be a > lot better about streaming data off the disk if the data was arranged in a > favorable manner rather than randomly located. However, I was told that was > simplistic thinking and that modern RAID systems are much more sophisticated > than that. And I'm willing to concede that a RAID system is more complex > than simple drives. I'm just hoping that someone on this list has more > experience on the database/hardware interface. Thanks. > > -Original Message- > Sent: Friday, December 07, 2001 3:25 PM > To: Multiple recipients of list ORACLE-L > > > Dennis, > > I'm no RAID guru, but I can sure imagine disk heads thrashing around, trying > to satisfy a mix of sequential and random reads and writes, causing the DB > to wait, but not getting anywhere near the rated throughput for the RAID > controller or channel. > > Could that possibly be the case? > > Jack > > > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > > -Original Message- > WILLIAMS > Sent: Friday, December 07, 2001 10:40 AM > To: Multiple recipients of list ORACLE-L > > > Whenever I discuss disk waits with my system administrator, I always get the > reply that "the RAID system isn't anywhere near its rated throughput". Maybe > I'm wrong, but I don't see any of the tuning books mentioning that as a > relevant performance characteristic. However, I've never been able to move > the discussion beyond this point. Can anyone straighten me out on this point > or point me to a resource that might be applicable. > > Our system is Oracle 8.1.6, Compaq Tru64. We use hardware RAID-5 with a > battery-backed RAM cache, and have about 3 RAID sets (plus some extra disks > for redo logs, etc.), and performance is fine, but I'm always looking as to > how we can improve Oracle performance. The application is our corporate ERP > system. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack C. Applewhite > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
Re: ORACLE-L Digest -- Volume 2001, Number 333
do we need to have a "ugliest SQL statement" contest? OT list? I have an entry ready ORACLE-L Digest -- Volume 2001, Number 333 > -- > > From: "Toepke, Kevin M" <[EMAIL PROTECTED]> > Date: Wed, 28 Nov 2001 12:44:29 -0500 > Subject: RE: Longest SQL statements!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAID system max throughput
Jack - Well, that's what I thought. I could see where the disk would be a lot better about streaming data off the disk if the data was arranged in a favorable manner rather than randomly located. However, I was told that was simplistic thinking and that modern RAID systems are much more sophisticated than that. And I'm willing to concede that a RAID system is more complex than simple drives. I'm just hoping that someone on this list has more experience on the database/hardware interface. Thanks. -Original Message- Sent: Friday, December 07, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Dennis, I'm no RAID guru, but I can sure imagine disk heads thrashing around, trying to satisfy a mix of sequential and random reads and writes, causing the DB to wait, but not getting anywhere near the rated throughput for the RAID controller or channel. Could that possibly be the case? Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- WILLIAMS Sent: Friday, December 07, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Whenever I discuss disk waits with my system administrator, I always get the reply that "the RAID system isn't anywhere near its rated throughput". Maybe I'm wrong, but I don't see any of the tuning books mentioning that as a relevant performance characteristic. However, I've never been able to move the discussion beyond this point. Can anyone straighten me out on this point or point me to a resource that might be applicable. Our system is Oracle 8.1.6, Compaq Tru64. We use hardware RAID-5 with a battery-backed RAM cache, and have about 3 RAID sets (plus some extra disks for redo logs, etc.), and performance is fine, but I'm always looking as to how we can improve Oracle performance. The application is our corporate ERP system. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: simple SQL
create table test1 tablespace test1 as select from test2; tablespace goes right after the new table_name. Terrry -Original Message- Sent: Friday, December 07, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Hi Gurus, Iam creating table from one tablespace to another tablespace, Iam getting error!!! create table test1 as select * from test2 tablespace TEST1; What is the problem with statement?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cannot Drop Column
Title: RE: Cannot Drop Column Why not create newtable as select columns wanted from oldtable, then add your column. Drop old table rename new table to old table if desired. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Cannot Drop Column Ron, You should read the whole thread. ;) Jared "Ron Rogers" tery.org> cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 12:05 PM Please respond to ORACLE-L Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm >>> [EMAIL PROTECTED] 12/07/01 02:25PM >>> Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz list ORACLE-L <[EMAIL PROTECTED]> fsys.com> cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz list ORACLE-L <[EMAIL PROTECTED]> fsys.com> cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
RE: RAID system max throughput
Can you get to the max throughput outside Oracle - for example, a straight read or write test. If you can, then it would reasonable to assume that your db could possibly get some more io throughput squeezed out of it. If the read or write test cannot get up to the claimed max, then maybe its time to ask for an explanation from the raid vendor. hth connor --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > tday6 - Thanks for replying. No, the RAID seems to > perform fine. I can > perform certain Oracle operations (usually DBA > activities) and kick the RAID > I/O really high (considerably below the vendor > specs). In normal usage the > I/O is far below this level. > Statspack analysis shows disk waits to be our > greatest wait. Does > this mean that I have a superbly tuned system and > there is nothing more to > do? If I can get an amen to that then I can leave > happy for the weekend. > Part of what concerned me was that none of the > Oracle tuning books I have > mentions vendor specs for RAID I/O at all. > > Thanks for your ideas. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Friday, December 07, 2001 12:13 PM > To: Multiple recipients of list ORACLE-L > > > I'm not sure that I understand the question. Is it: > > A. Under max load the RAID does not perform up to > its specs? > > or > > B. Oracle does not stress the RAID enough for it to > reach its max > performance. > > If A, then have the RAID vendor fix whatever the > problem is. > > If B, then good for you. You have a well designed > system. > > > > > > DENNIS > > WILLIAMS To: > Multiple recipients of list > ORACLE-L > <[EMAIL PROTECTED]> > > @LIFETOUCH.COcc: > > M> Subject: > RAID system max > throughput > Sent by: root > > > > > > 12/07/2001 > > 11:40 AM > > Please > > respond to > > ORACLE-L > > > > > > > > > > Whenever I discuss disk waits with my system > administrator, I always get > the > reply that "the RAID system isn't anywhere near its > rated throughput". > Maybe > I'm wrong, but I don't see any of the tuning books > mentioning that as a > relevant performance characteristic. However, I've > never been able to move > the discussion beyond this point. Can anyone > straighten me out on this > point > or point me to a resource that might be applicable. > > Our system is Oracle 8.1.6, Compaq Tru64. We use > hardware RAID-5 with a > battery-backed RAM cache, and have about 3 RAID sets > (plus some extra disks > for redo logs, etc.), and performance is fine, but > I'm always looking as to > how we can improve Oracle performance. The > application is our corporate ERP > system. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the na
Re: simple SQL
You have the TABLESPACE clause in the wrong place. create table test1 tablespace TEST1 as select * from test2; Jared "Raghu Kota" mail.com>cc: Sent by: Subject: simple SQL [EMAIL PROTECTED] om 12/07/01 12:40 PM Please respond to ORACLE-L Hi Gurus, Iam creating table from one tablespace to another tablespace, Iam getting error!!! create table test1 as select * from test2 tablespace TEST1; What is the problem with statement?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating a reporting DB
Dick, This is a classic Hot backup problem which has a mirror-split and lots of active datafiles. The reason you are being asked for additional archive logs is this: (and I bet this was for recovering the system.dbf file?) When a tablespace is either put into backup mode or taken out of backup mode, a redo entry that records this event is made in the online redolog. When you break the mirror while still in hot backup mode and copy off the datafiles, SYSTEM.DBF records that you put these tablespaces as being in hot backup mode. On account of the database rename via CCF/RESETLOGS, the online redo logs can now *not* be used and thus the redo vectors that record the fact that the tablespaces came out of hot backup mode are now not available. When the database is opened now with RESETLOGS, all datafiles need to come up to the maximum SCN amongst themselves - details of which is present only in the first archive logs generated *after* the backup completed on the source system. You will then have to apply at least this one archivelog with a CANCEL based recovery before opening the database. If you copied out your archivelog destination via a mirror copy, then you need to add code to the script to 'archivelog current' on the source *after* the hot backup/mirror script is complete and then FTP the last archivelog to the destination server, as well as script the cancel based recovery. There could also be another deeper problem - if the mirror does not contain all the datafiles or parts of the mirror are stale, you will be asked for archivelogs starting from the time the missing datafiles were created or they went stale because of an invalid resilvering or missed filesystems (Been there and been bitten by such an issue, since another DBA created datafiles on non-mirrored filesystems :) Hope this helps - I did not find any 'companion in crime' listed in the address since the Listserv chops it off. I am sending this directly to you in case you have set an autoreply and left for the week - I can then get your alternate contacts. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Wanna know the reason for the season? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** > The sequence of events we're using is: > > 1) Place production DB into hotbackup mode. > 2) Break the mirror. > 3) End backup on production. > 4) Mount the mirror on the second machine. > 5) Startup nomount the new instance, but under a different SID. > 6) Rebuild the control file with a new name while > renaming datafiles, > including the online redo. > 7) Recover the database. This is where the trouble commences. > > Anybody have an idea??? BTW: We're trying to do this as a > complete scripted > operation that the SA can just run. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAID system max throughput
Dennis, I'm no RAID guru, but I can sure imagine disk heads thrashing around, trying to satisfy a mix of sequential and random reads and writes, causing the DB to wait, but not getting anywhere near the rated throughput for the RAID controller or channel. Could that possibly be the case? Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- WILLIAMS Sent: Friday, December 07, 2001 10:40 AM To: Multiple recipients of list ORACLE-L Whenever I discuss disk waits with my system administrator, I always get the reply that "the RAID system isn't anywhere near its rated throughput". Maybe I'm wrong, but I don't see any of the tuning books mentioning that as a relevant performance characteristic. However, I've never been able to move the discussion beyond this point. Can anyone straighten me out on this point or point me to a resource that might be applicable. Our system is Oracle 8.1.6, Compaq Tru64. We use hardware RAID-5 with a battery-backed RAM cache, and have about 3 RAID sets (plus some extra disks for redo logs, etc.), and performance is fine, but I'm always looking as to how we can improve Oracle performance. The application is our corporate ERP system. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Creating a reporting DB
Dick, I've never duplicated a system by breaking a mirror, so please excuse my ignorance. When the mirror(s) is/are broken, how does this affect the online redo log? Is it possible that the SCN in one or more of the data files ( I'm guessing it's a SYSTEM file ) file exceeds that in the redo log? Could this be do to a difference in the time of the break on the data filesystem versus the time of the break on the FS containing the redo? And if so, maybe you need the most recent archived log to finish recovery on the mirror? HTH Jared [EMAIL PROTECTED] om To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: 12/07/01 01:11 Subject: Re[2]: Creating a reporting DB PM Jared, Now, Now are we bad mouthing another vendor? I thought MicroSlop was the prime bad boy. But seriously I understand as we use another lame Lotus product for mail, CCMail. To the topic, we tried that & the darn thing just keeps looking for additional logs past the point. Personally I believe it's due to our trying to do the entire job in one blast. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 12/7/2001 12:55 PM Dick, First, those of us with lame MUA's ( Lotus Notes in this case ) may not be able to dig the address of your coworker out of the address header. As for the archive log, feed it the online redo logs until it gets the one it wants, which should be the most recent one. If you're not copying the online logs, then you'll need to add this into your routine. I've had to do this when doing much the same thing. Then you can proceeed with the 'open resetlogs' Jared [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Creating a reporting DB om 12/07/01 12:15 PM Please respond to ORACLE-L Folks, I'm sure that someone on the list has done this in the past or at least can "see the forest through the trees". I've been a little too close to this and lost the perspective. Anyhow, what we're trying to do is create two replica's of our production PeopleSoft database on a separate machine using the hot backup method (otherwise known as EMC TimeFinder). Now that's two HP 9000 and three instances of Oracle. It does not take a wizard to understand that there is going to be a SID conflict somewhere. SIDs around here are two characters in place and range from '02' to '09' (Please don't ask why, it's a VERY long story). We start out with Dudley:02 and want to end up copying that to Schroeder:06 and Schroeder:05. BTW, the mount points are not the same so we have to not only change the database name, but the file paths too. We've figured out the file renaming part just fine & getting the SID changed. The problem comes with recreating the control file. Oracle recommends using the 'create controlfile set database 06 resetlogs' which sets the sequence in V$log to 0, but leaves us with a database that is looking for an archive log that does not exist. The sequence of events we're using is: 1) Place production DB into hotbackup mode. 2) Break the mirror. 3) End backup on production. 4) Mount the mirror on the second machine. 5) Startup nomount the new instance, but under a different SID. 6) Rebuild the control file with a new name while renaming datafiles, including the online redo. 7) Recover the database. This is where the trouble commences. Anybody have an idea??? BTW: We're trying to do this as a complete scripted operation that the SA can just run. Dick Goulet OH, Also please include my companion in crime (listed in the address area) as I'm off next week. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lis
RE: simple SQL
create table test1 tablespace TEST1 as select * from test2; Look at the syntax diagrams in the manuals. This is explicitly shown. -Original Message- Sent: Friday, December 07, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Hi Gurus, Iam creating table from one tablespace to another tablespace, Iam getting error!!! create table test1 as select * from test2 tablespace TEST1; What is the problem with statement?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Interesting utility
http://freshmeat.net/projects/bos/ But I haven't tried it! JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: simple SQL
The "tablespace TEST1" clause needs to come before the "as select ..." clause. Kent At 12:40 PM 12/7/01 -0800, you wrote: > > >Hi Gurus, > >Iam creating table from one tablespace to another tablespace, Iam getting >error!!! > >create table test1 as select * from test2 tablespace TEST1; > >What is the problem with statement?? > >Thanks >Raghu. > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Raghu Kota > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kent Wayson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating a reporting DB
Step 3.1 Switch archive logs and copy to 2nd machine Rename the datafiles to new location and recover until cancel using the Old sid THEN Recreate the controlfile with the new SID Let me know if I missed anything, or I can give you or Henry (? no 2nd addressee in your post) more details. Mike Hand Polaroid Corp. -Original Message- Sent: Friday, December 07, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Folks, I'm sure that someone on the list has done this in the past or at least can "see the forest through the trees". I've been a little too close to this and lost the perspective. Anyhow, what we're trying to do is create two replica's of our production PeopleSoft database on a separate machine using the hot backup method (otherwise known as EMC TimeFinder). Now that's two HP 9000 and three instances of Oracle. It does not take a wizard to understand that there is going to be a SID conflict somewhere. SIDs around here are two characters in place and range from '02' to '09' (Please don't ask why, it's a VERY long story). We start out with Dudley:02 and want to end up copying that to Schroeder:06 and Schroeder:05. BTW, the mount points are not the same so we have to not only change the database name, but the file paths too. We've figured out the file renaming part just fine & getting the SID changed. The problem comes with recreating the control file. Oracle recommends using the 'create controlfile set database 06 resetlogs' which sets the sequence in V$log to 0, but leaves us with a database that is looking for an archive log that does not exist. The sequence of events we're using is: 1) Place production DB into hotbackup mode. 2) Break the mirror. 3) End backup on production. 4) Mount the mirror on the second machine. 5) Startup nomount the new instance, but under a different SID. 6) Rebuild the control file with a new name while renaming datafiles, including the online redo. 7) Recover the database. This is where the trouble commences. Anybody have an idea??? BTW: We're trying to do this as a complete scripted operation that the SA can just run. Dick Goulet OH, Also please include my companion in crime (listed in the address area) as I'm off next week. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cannot Drop Column
Ron, You should read the whole thread. ;) Jared "Ron Rogers" tery.org>cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 12:05 PM Please respond to ORACLE-L Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm >>> [EMAIL PROTECTED] 12/07/01 02:25PM >>> Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz fsys.com>cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To:Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] F
Re: RE: Has anyone heard of "Mirror Accessible"?
Hehehe... I got it covered on all fronts. And no, it is not a joke. Unfortunately, the DIQ's (Damagement In Question) is local, while all the systems are remote. Gods forbid they should ask the people who are technically competent how long something will take prior to promising a schedule to the client. --S --- Don Granaman <[EMAIL PROTECTED]> wrote: > Is Las Vegas laying odds on this? I've got a few > bucks I would wager > against... > > This is not just unreasonable, but insane - even > assuming that > everything goes perfectly (it won't). It is more > reasonable to assume > that a horse is a perfect sphere or that the > Israeli-Palestinian > problem could be solved once and for all with a coin > toss. Keep the > Uzi around for a while after the upgrades. You may > need it for > self-defense when these same damagers come scapegoat > hunting. > > Don't underestimate the benefit of the "remotely" > part. At least they > won't hear you swearing at them and you won't have > several of them in > your cube at all times - looking over your shoulder, > asking intensely > stupid questions, and constantly talking on their > cell phones relaying > status reports! Also, if you have to make a break > for it, you'll have > a decent lead. > > Only a few years ago, I thought that Dilbert was > comic exaggeration. > I have since come to the profound realization that > it is subtle > understatement. > > -Don Granaman > [OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Thursday, December 06, 2001 1:50 PM > > > > I hear you. Some one came up with the idea that > 30+ > > HPUX 10.20, Oracle 7.3.3 systems could be updated > to > > HPUX 11.x, Oracle 8.1.7 in less than 36 hours, > with > > only 2 dba's and 2 sysadms, remotely. > > > > I shudder to think of the psychoactive compound > > dosages that led to this conclusion. Oh well, > I've > > got spare pillows out in the truck, right next to > the > > postal worker uniform and the uzi... > > > > --S > > > > > > --- [EMAIL PROTECTED] wrote: > > > Ain't being a DBA glamorous??? > > > > > > Me, I'm just in it because I heard that DBA's > get > > > all the chicks :) > > > > > > Believe me, I feel your pain. I have more > Oracle > > > 7.3.4 databases here to upgrade than I can say > > > without embarassment. That's what I get for > being > > > the new hire. :) > > > > > > A fellow DBA, > > > Scott Lockhart > > > Oracle DBA > > > I-Link, Ltd. > > > Draper, UT > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > > (858) 538-5051 > > > San Diego, California-- Public Internet > > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send > an > > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB > > > ORACLE-L > > > (or the name of mailing list you want to be > removed > > > from). You may > > > also send the HELP command for other information > > > (like subscribing). > > > > > > __ > > Do You Yahoo!? > > Send your FREE holiday greetings online! > > http://greetings.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Scott Shafer > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing > Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Don Granaman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Send your FREE holiday greetings online! http
RE: Password Changes
Thanks Mike. Jared "Hand, Michael T" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Password Changes Sent by: [EMAIL PROTECTED] om 12/07/01 12:25 PM Please respond to ORACLE-L Jared, All, The challenge has been accepted. In this episode of "This Old Password" we search for the lost password with the help of sql_trace and a new test profile. And voila, we discover the SYS table user_history$. The moral of the story is that if the aforementioned user is assigned a profile where Password_Reuse_Time or Password_Reuse_Max is not Unlimited (the default), then old passwords will be stored in user_history$.password until they are no longer required to enforce the profile constraints. If the user is not assigned this type of profile you are out of luck. And, of course, you would have to disable the profile to reset the password to an already-been-used value. You never know what you'll start with some questions ;-) Have a great weekend. Mike -Original Message- Sent: Friday, December 07, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Mike, Good point, I obviously was out to lunch on that one. Your mission, should you choose to accept it, is to search out and disseminate the knowledge regarding this old password. Should you choose not to accept this mission, I will disavow all knowledge of this email and claim it was spoofed by persons unknown. This message will not self destruct in 5 seconds, but will probably hang around in various archives for centuries, consuming valuable resources. Now where'd that coffee go to... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Creating a reporting DB
Jared, Now, Now are we bad mouthing another vendor? I thought MicroSlop was the prime bad boy. But seriously I understand as we use another lame Lotus product for mail, CCMail. To the topic, we tried that & the darn thing just keeps looking for additional logs past the point. Personally I believe it's due to our trying to do the entire job in one blast. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 12/7/2001 12:55 PM Dick, First, those of us with lame MUA's ( Lotus Notes in this case ) may not be able to dig the address of your coworker out of the address header. As for the archive log, feed it the online redo logs until it gets the one it wants, which should be the most recent one. If you're not copying the online logs, then you'll need to add this into your routine. I've had to do this when doing much the same thing. Then you can proceeed with the 'open resetlogs' Jared [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Creating a reporting DB om 12/07/01 12:15 PM Please respond to ORACLE-L Folks, I'm sure that someone on the list has done this in the past or at least can "see the forest through the trees". I've been a little too close to this and lost the perspective. Anyhow, what we're trying to do is create two replica's of our production PeopleSoft database on a separate machine using the hot backup method (otherwise known as EMC TimeFinder). Now that's two HP 9000 and three instances of Oracle. It does not take a wizard to understand that there is going to be a SID conflict somewhere. SIDs around here are two characters in place and range from '02' to '09' (Please don't ask why, it's a VERY long story). We start out with Dudley:02 and want to end up copying that to Schroeder:06 and Schroeder:05. BTW, the mount points are not the same so we have to not only change the database name, but the file paths too. We've figured out the file renaming part just fine & getting the SID changed. The problem comes with recreating the control file. Oracle recommends using the 'create controlfile set database 06 resetlogs' which sets the sequence in V$log to 0, but leaves us with a database that is looking for an archive log that does not exist. The sequence of events we're using is: 1) Place production DB into hotbackup mode. 2) Break the mirror. 3) End backup on production. 4) Mount the mirror on the second machine. 5) Startup nomount the new instance, but under a different SID. 6) Rebuild the control file with a new name while renaming datafiles, including the online redo. 7) Recover the database. This is where the trouble commences. Anybody have an idea??? BTW: We're trying to do this as a complete scripted operation that the SA can just run. Dick Goulet OH, Also please include my companion in crime (listed in the address area) as I'm off next week. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing lis
RE: Creating a reporting DB
Dick, I would try: steps 1 thru 4 as you stated. But then, I would: Startup nomount; alter database (rename the data files to the new locations). Recover the database using the old (existing) sid name. Once it is recovered, issue a new backup controlfile to trace and use it to create the new controlfiles using the new sid name. The only difference here is recovering before the renaming. I think you lose the recoverability when you create the new control files. Sorry - didn't see the other persons email in your mail. Good luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 07, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Folks, I'm sure that someone on the list has done this in the past or at least can "see the forest through the trees". I've been a little too close to this and lost the perspective. Anyhow, what we're trying to do is create two replica's of our production PeopleSoft database on a separate machine using the hot backup method (otherwise known as EMC TimeFinder). Now that's two HP 9000 and three instances of Oracle. It does not take a wizard to understand that there is going to be a SID conflict somewhere. SIDs around here are two characters in place and range from '02' to '09' (Please don't ask why, it's a VERY long story). We start out with Dudley:02 and want to end up copying that to Schroeder:06 and Schroeder:05. BTW, the mount points are not the same so we have to not only change the database name, but the file paths too. We've figured out the file renaming part just fine & getting the SID changed. The problem comes with recreating the control file. Oracle recommends using the 'create controlfile set database 06 resetlogs' which sets the sequence in V$log to 0, but leaves us with a database that is looking for an archive log that does not exist. The sequence of events we're using is: 1) Place production DB into hotbackup mode. 2) Break the mirror. 3) End backup on production. 4) Mount the mirror on the second machine. 5) Startup nomount the new instance, but under a different SID. 6) Rebuild the control file with a new name while renaming datafiles, including the online redo. 7) Recover the database. This is where the trouble commences. Anybody have an idea??? BTW: We're trying to do this as a complete scripted operation that the SA can just run. Dick Goulet OH, Also please include my companion in crime (listed in the address area) as I'm off next week. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Are there any Detroit Lions fans on this list?
Title: RE: Are there any Detroit Lions fans on this list? Chris, You are overly-optimistic (about 'First round playoff loss') :) Jared, sorry for 'OT', but it's Friday and also Detroit Lions 'zoo' is too close to home, though I don't have 'enough spinal cord to admit to being a Lions fan' Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Bowes, Chris To: Multiple recipients of list ORACLE-L Sent: Friday, December 07, 2001 2:45 PM Subject: RE: Are there any Detroit Lions fans on this list? As the only person on this list with enough spinal cord to admit to being a Lions fan, I must take exception to your thoughts that the Lions are losing because they stink. This is merely part of a brilliant plan by Marty and the boys to get the first pick of the draft again. It is sheer brilliance! Next season we'll have the cake-est schedule in the league and the first pick of the draft! First round playoff loss, here we come! --Chris [EMAIL PROTECTED] -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 1:17 PM To: Multiple recipients of list ORACLE-L Subject: OT:Are there any Detroit Lions fans on this list? Q. What's the difference between the Detroit Lions & the Taliban? A. The Taliban have a running game Q. How do the Detroit Lions count to 10? A. 0-1, 0-2, 0-3, 0-4, 0-5, 0-6, 0-7, 0-8, 0-9, 0-10 Q. What do the Detroit Lions & Billy Graham have in common? A. They both can make 80,000 people stand up & yell "Jesus Christ" ! Q. How do you keep a Detroit Lion out of your yard? A. Put up goal posts Q. Where do you go in Detroit in case of a tornado? A. To the Silverdone - they never get a touchdown there! Q. What do you call a Detroit Lion with a SuperBowl ring? A. A thief Q. Why doesn't Flint have a professional football team? A. Because then Detroit would want one Q. Why was Marty Mornhinweg upset when the Detroit Lions playbook was stolen? A. Because he hadn't finished coloring it. Q. What's the difference between the Detroit Lions and a dollar bill? A. You can still get four quarters out of a dollar Q. How many Detroit Lions does it take to win a Superbowl? A. Nobody knows and we may never find out! Q. What do you call 47 people sitting around a TV watching the SuperBowl? A. The Detroit Lions Q. What do the Detroit Lions and opossums have in common? A. Both play dead at home and get killed on the road Q. How can you tell when the Detroit Lions are going to run the football? A. The back leaves the huddle with tears in his eyes. Q. Knock knock Who's there. Owen Owen Who? A. Oh an 10. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Creating a reporting DB
Dick, First, those of us with lame MUA's ( Lotus Notes in this case ) may not be able to dig the address of your coworker out of the address header. As for the archive log, feed it the online redo logs until it gets the one it wants, which should be the most recent one. If you're not copying the online logs, then you'll need to add this into your routine. I've had to do this when doing much the same thing. Then you can proceeed with the 'open resetlogs' Jared [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Creating a reporting DB om 12/07/01 12:15 PM Please respond to ORACLE-L Folks, I'm sure that someone on the list has done this in the past or at least can "see the forest through the trees". I've been a little too close to this and lost the perspective. Anyhow, what we're trying to do is create two replica's of our production PeopleSoft database on a separate machine using the hot backup method (otherwise known as EMC TimeFinder). Now that's two HP 9000 and three instances of Oracle. It does not take a wizard to understand that there is going to be a SID conflict somewhere. SIDs around here are two characters in place and range from '02' to '09' (Please don't ask why, it's a VERY long story). We start out with Dudley:02 and want to end up copying that to Schroeder:06 and Schroeder:05. BTW, the mount points are not the same so we have to not only change the database name, but the file paths too. We've figured out the file renaming part just fine & getting the SID changed. The problem comes with recreating the control file. Oracle recommends using the 'create controlfile set database 06 resetlogs' which sets the sequence in V$log to 0, but leaves us with a database that is looking for an archive log that does not exist. The sequence of events we're using is: 1) Place production DB into hotbackup mode. 2) Break the mirror. 3) End backup on production. 4) Mount the mirror on the second machine. 5) Startup nomount the new instance, but under a different SID. 6) Rebuild the control file with a new name while renaming datafiles, including the online redo. 7) Recover the database. This is where the trouble commences. Anybody have an idea??? BTW: We're trying to do this as a complete scripted operation that the SA can just run. Dick Goulet OH, Also please include my companion in crime (listed in the address area) as I'm off next week. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail mess
RE: Cannot Drop Column
Ron: This doesn't work. I'm just ignoring the column and adding the correctly named column. Ken -Original Message- Sent: Friday, December 07, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject:RE: Cannot Drop Column Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm >>> [EMAIL PROTECTED] 12/07/01 02:25PM >>> Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz fsys.com>cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To:Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
simple SQL
Hi Gurus, Iam creating table from one tablespace to another tablespace, Iam getting error!!! create table test1 as select * from test2 tablespace TEST1; What is the problem with statement?? Thanks Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Password Changes
Jared, All, The challenge has been accepted. In this episode of "This Old Password" we search for the lost password with the help of sql_trace and a new test profile. And voila, we discover the SYS table user_history$. The moral of the story is that if the aforementioned user is assigned a profile where Password_Reuse_Time or Password_Reuse_Max is not Unlimited (the default), then old passwords will be stored in user_history$.password until they are no longer required to enforce the profile constraints. If the user is not assigned this type of profile you are out of luck. And, of course, you would have to disable the profile to reset the password to an already-been-used value. You never know what you'll start with some questions ;-) Have a great weekend. Mike -Original Message- Sent: Friday, December 07, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Mike, Good point, I obviously was out to lunch on that one. Your mission, should you choose to accept it, is to search out and disseminate the knowledge regarding this old password. Should you choose not to accept this mission, I will disavow all knowledge of this email and claim it was spoofed by persons unknown. This message will not self destruct in 5 seconds, but will probably hang around in various archives for centuries, consuming valuable resources. Now where'd that coffee go to... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Creating a reporting DB
Folks, I'm sure that someone on the list has done this in the past or at least can "see the forest through the trees". I've been a little too close to this and lost the perspective. Anyhow, what we're trying to do is create two replica's of our production PeopleSoft database on a separate machine using the hot backup method (otherwise known as EMC TimeFinder). Now that's two HP 9000 and three instances of Oracle. It does not take a wizard to understand that there is going to be a SID conflict somewhere. SIDs around here are two characters in place and range from '02' to '09' (Please don't ask why, it's a VERY long story). We start out with Dudley:02 and want to end up copying that to Schroeder:06 and Schroeder:05. BTW, the mount points are not the same so we have to not only change the database name, but the file paths too. We've figured out the file renaming part just fine & getting the SID changed. The problem comes with recreating the control file. Oracle recommends using the 'create controlfile set database 06 resetlogs' which sets the sequence in V$log to 0, but leaves us with a database that is looking for an archive log that does not exist. The sequence of events we're using is: 1) Place production DB into hotbackup mode. 2) Break the mirror. 3) End backup on production. 4) Mount the mirror on the second machine. 5) Startup nomount the new instance, but under a different SID. 6) Rebuild the control file with a new name while renaming datafiles, including the online redo. 7) Recover the database. This is where the trouble commences. Anybody have an idea??? BTW: We're trying to do this as a complete scripted operation that the SA can just run. Dick Goulet OH, Also please include my companion in crime (listed in the address area) as I'm off next week. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cannot Drop Column
Oracle 8i ALTER TABLE name DROP COLUMN name; ROR mô¿ôm >>> [EMAIL PROTECTED] 12/07/01 02:25PM >>> Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz fsys.com>cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To:Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list y
RE: Are there any Detroit Lions fans on this list?
Title: RE: Are there any Detroit Lions fans on this list? As the only person on this list with enough spinal cord to admit to being a Lions fan, I must take exception to your thoughts that the Lions are losing because they stink. This is merely part of a brilliant plan by Marty and the boys to get the first pick of the draft again. It is sheer brilliance! Next season we'll have the cake-est schedule in the league and the first pick of the draft! First round playoff loss, here we come! --Chris [EMAIL PROTECTED] -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 1:17 PM To: Multiple recipients of list ORACLE-L Subject: OT:Are there any Detroit Lions fans on this list? Q. What's the difference between the Detroit Lions & the Taliban? A. The Taliban have a running game Q. How do the Detroit Lions count to 10? A. 0-1, 0-2, 0-3, 0-4, 0-5, 0-6, 0-7, 0-8, 0-9, 0-10 Q. What do the Detroit Lions & Billy Graham have in common? A. They both can make 80,000 people stand up & yell "Jesus Christ" ! Q. How do you keep a Detroit Lion out of your yard? A. Put up goal posts Q. Where do you go in Detroit in case of a tornado? A. To the Silverdone - they never get a touchdown there! Q. What do you call a Detroit Lion with a SuperBowl ring? A. A thief Q. Why doesn't Flint have a professional football team? A. Because then Detroit would want one Q. Why was Marty Mornhinweg upset when the Detroit Lions playbook was stolen? A. Because he hadn't finished coloring it. Q. What's the difference between the Detroit Lions and a dollar bill? A. You can still get four quarters out of a dollar Q. How many Detroit Lions does it take to win a Superbowl? A. Nobody knows and we may never find out! Q. What do you call 47 people sitting around a TV watching the SuperBowl? A. The Detroit Lions Q. What do the Detroit Lions and opossums have in common? A. Both play dead at home and get killed on the road Q. How can you tell when the Detroit Lions are going to run the football? A. The back leaves the huddle with tears in his eyes. Q. Knock knock Who's there. Owen Owen Who? A. Oh an 10. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAID system max throughput
tday6 - Thanks for replying. No, the RAID seems to perform fine. I can perform certain Oracle operations (usually DBA activities) and kick the RAID I/O really high (considerably below the vendor specs). In normal usage the I/O is far below this level. Statspack analysis shows disk waits to be our greatest wait. Does this mean that I have a superbly tuned system and there is nothing more to do? If I can get an amen to that then I can leave happy for the weekend. Part of what concerned me was that none of the Oracle tuning books I have mentions vendor specs for RAID I/O at all. Thanks for your ideas. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 07, 2001 12:13 PM To: Multiple recipients of list ORACLE-L I'm not sure that I understand the question. Is it: A. Under max load the RAID does not perform up to its specs? or B. Oracle does not stress the RAID enough for it to reach its max performance. If A, then have the RAID vendor fix whatever the problem is. If B, then good for you. You have a well designed system. DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L @LIFETOUCH.COcc: M> Subject: RAID system max throughput Sent by: root 12/07/2001 11:40 AM Please respond to ORACLE-L Whenever I discuss disk waits with my system administrator, I always get the reply that "the RAID system isn't anywhere near its rated throughput". Maybe I'm wrong, but I don't see any of the tuning books mentioning that as a relevant performance characteristic. However, I've never been able to move the discussion beyond this point. Can anyone straighten me out on this point or point me to a resource that might be applicable. Our system is Oracle 8.1.6, Compaq Tru64. We use hardware RAID-5 with a battery-backed RAM cache, and have about 3 RAID sets (plus some extra disks for redo logs, etc.), and performance is fine, but I'm always looking as to how we can improve Oracle performance. The application is our corporate ERP system. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are there any Detroit Lions fans on this list?
Tom T. must be having a bad day. After all, it is Friday. Besides, I thought only Jarad could snap the towel! Tom -Original Message-From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]Sent: Friday, December 07, 2001 1:57 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Are there any Detroit Lions fans on this list? oops. SNAP. That's gonna leave a mark. But his post WAS funny. Chuck Speaks Database Administrator Lithonia Lighting 770-860-3450 http://www.lithonia.com -Original Message-From: Terrian, Tom [mailto:[EMAIL PROTECTED]]Sent: Friday, December 07, 2001 13:44To: Multiple recipients of list ORACLE-LSubject: RE: Are there any Detroit Lions fans on this list? Mladen, keep your OT post off of this list please. Apparently the list is already too big and you only want to read about oracle and only oracle. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 28, 2001 11:52 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Burning game CD'sListen pal, this list is already too big as it is. Second, Ianswer questions far more frequently then I ask them. The fact is thatthis is not the forum to ask about burning CDs. If you have a problem withthat, you don't have to respond to any of the questions that I might ask.If you really want to discuss DMCA, DeCSS, 2600 case, Skylarov case andburning CDs then go to Slashdot.org or an appropriate linux newsgroup. Here,I want to read about oracle and only about oracle. Did I make myself clear?-Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Friday, December 07, 2001 1:17 PMTo: Multiple recipients of list ORACLE-LSubject: OT:Are there any Detroit Lions fans on this list?Q. What's the difference between the Detroit Lions & the Taliban? A. The Taliban have a running game Q. How do the Detroit Lions count to 10? A. 0-1, 0-2, 0-3, 0-4, 0-5, 0-6, 0-7, 0-8, 0-9, 0-10 Q. What do the Detroit Lions & Billy Graham have in common? A. They both can make 80,000 people stand up & yell "Jesus Christ" ! Q. How do you keep a Detroit Lion out of your yard? A. Put up goal posts Q. Where do you go in Detroit in case of a tornado? A. To the Silverdone - they never get a touchdown there! Q. What do you call a Detroit Lion with a SuperBowl ring? A. A thief Q. Why doesn't Flint have a professional football team? A. Because then Detroit would want one Q. Why was Marty Mornhinweg upset when the Detroit Lions playbook was stolen? A. Because he hadn't finished coloring it. Q. What's the difference between the Detroit Lions and a dollar bill? A. You can still get four quarters out of a dollar Q. How many Detroit Lions does it take to win a Superbowl? A. Nobody knows and we may never find out! Q. What do you call 47 people sitting around a TV watching the SuperBowl? A. The Detroit Lions Q. What do the Detroit Lions and opossums have in common? A. Both play dead at home and get killed on the road Q. How can you tell when the Detroit Lions are going to run the football? A. The back leaves the huddle with tears in his eyes. Q. Knock knock Who's there. Owen Owen Who? A. Oh an 10.--Mladen Gogala--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Gogala, Mladen INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: OT:Are there any Detroit Lions fans on this list?
Mladen, This is a good candidate for the OT list. Jared "Gogala, Mladen" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: OT:Are there any Detroit Lions fans on this list? Sent by: [EMAIL PROTECTED] om 12/07/01 10:17 AM Please respond to ORACLE-L Q. What's the difference between the Detroit Lions & the Taliban? A. The Taliban have a running game Q. How do the Detroit Lions count to 10? A. 0-1, 0-2, 0-3, 0-4, 0-5, 0-6, 0-7, 0-8, 0-9, 0-10 Q. What do the Detroit Lions & Billy Graham have in common? A. They both can make 80,000 people stand up & yell "Jesus Christ" ! Q. How do you keep a Detroit Lion out of your yard? A. Put up goal posts Q. Where do you go in Detroit in case of a tornado? A. To the Silverdone - they never get a touchdown there! Q. What do you call a Detroit Lion with a SuperBowl ring? A. A thief Q. Why doesn't Flint have a professional football team? A. Because then Detroit would want one Q. Why was Marty Mornhinweg upset when the Detroit Lions playbook was stolen? A. Because he hadn't finished coloring it. Q. What's the difference between the Detroit Lions and a dollar bill? A. You can still get four quarters out of a dollar Q. How many Detroit Lions does it take to win a Superbowl? A. Nobody knows and we may never find out! Q. What do you call 47 people sitting around a TV watching the SuperBowl? A. The Detroit Lions Q. What do the Detroit Lions and opossums have in common? A. Both play dead at home and get killed on the road Q. How can you tell when the Detroit Lions are going to run the football? A. The back leaves the huddle with tears in his eyes. Q. Knock knock Who's there. Owen Owen Who? A. Oh an 10. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cannot Drop Column
Ken, Just add the column with the correct name, and leave the other one alone. You could create a check constraint to make sure it isn't used. Better yet, create a real account and don't use SYS or SYSTEM, as that is never a good idea. As you've already discovered, it really isn't all that convenient. ;) Jared Ken Janusz fsys.com>cc: Sent by: Subject: RE: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 09:50 AM Please respond to ORACLE-L Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To:Multiple recipients of list ORACLE-L Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
RE: Trigger exception problem
Don't worry about it... I was just happy for the solution! Save me time and achoo... trying to strain my brain stuffed with a cold. Thanks again to all! This works like a charm! Just have to adjust my triggers now. And try to make it through today. TGIF! Kathy -Original Message- Sent: Friday, December 07, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Oops:) I didn't remember exact parameter to use when calling 'userenv()'. So I just tried: select userenv('SESSIONID') from ( select * from dual ) ; and then pasted it (as it was) into e-mail message. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 1:43 PM > If you're gonna do that, then why not: > > select decode(process, process, process) > from ( select * from ( select * from v$session ) ) > where decode(audsid, audsid, audsid) = > ( select userenv('SESSIONID') from ( select * from dual ) ); > > Seriously though, why not just use > > select * from v$session where AUDSID = userenv('SESSIONID') > > :-) > > -p > --- > www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN > Smarter than adding another team member, Pythian has new services for > supplementing DBAs: get our help with monitoring, 24x7 on-call, daily > verifications, storage management, performance and more. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, December 07, 2001 1:23 PM > > > If you need current process: > > select process from v$session where AUDSID = (select userenv('SESSIONID') > from dual); > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, December 07, 2001 12:35 PM > > > > I told you I knew it was something stupid. Thanks the process was it. I > got rid of the process code and the duplicate error does now populate the > exception table like I wanted! > > > > I know need to figure out how to capture the specific process. Probably > next week when hopefully my head cold is gone, my kid isn't teething and I > have had some sleep. > > > > Thanks to all and to all a good weekend! > > > > Kathy > > > > -Original Message- > > Sent: Friday, December 07, 2001 5:35 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Kathy, > > > > I beleive the problem is in the exception handler: > > select process into v_process from v$session...This is returning multiple > rows. > > > > Rick > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > Confidential > > This e-mail and any files transmitted with it are the property > > of Belkin Components and/or its affiliates, are confidential, > > and are intended solely for the use of the individual or > > entity to whom this e-mail is addressed. If you are not one > > of the named recipients or otherwise have reason to believe > > that you have received this e-mail in error, please notify the > > sender and delete this message immediately from your computer. > > Any other use, retention, dissemination, forwarding, printing > > or copying of this e-mail is strictly prohibited. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kathy Duret > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Igor Neyman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROT
Re: FILE SIZING
1) In our testing environment log file switch is occuring every 2 minutes. The size of log files is 100M . What shold be the size of log files in Performance testing --- 500M or 1G . Is there any drawback in using large size of log files. For performance testing we will be running in noarchive log mode. 1 gig should work fine. You may want to set log_checkpoint_timeout to a a value to force a checkpoint every 20-30 minutes during periods of inactivity. - 2) Two of our table sizes is 175G and 160G. We are partitioning both the tables into 10 partitions. What should be the ideal datafile size and initial extent size. Is there any drawbacks in using big datafiles. We always used about 2G file size for small databases. 128 Meg extents would work nicely. That's only about 150 extents per partition. -- 3) We will be using locally manages tablespaces . which option is better for large database Uniform size or Autoallocate. Personally I prefer uniform size. no chance of fragmentation, which can be an issue with large extents. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are there any Detroit Lions fans on this list?
oops. SNAP. That's gonna leave a mark. But his post WAS funny. Chuck Speaks Database Administrator Lithonia Lighting 770-860-3450 http://www.lithonia.com -Original Message-From: Terrian, Tom [mailto:[EMAIL PROTECTED]]Sent: Friday, December 07, 2001 13:44To: Multiple recipients of list ORACLE-LSubject: RE: Are there any Detroit Lions fans on this list? Mladen, keep your OT post off of this list please. Apparently the list is already too big and you only want to read about oracle and only oracle. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 28, 2001 11:52 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Burning game CD'sListen pal, this list is already too big as it is. Second, Ianswer questions far more frequently then I ask them. The fact is thatthis is not the forum to ask about burning CDs. If you have a problem withthat, you don't have to respond to any of the questions that I might ask.If you really want to discuss DMCA, DeCSS, 2600 case, Skylarov case andburning CDs then go to Slashdot.org or an appropriate linux newsgroup. Here,I want to read about oracle and only about oracle. Did I make myself clear?-Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Friday, December 07, 2001 1:17 PMTo: Multiple recipients of list ORACLE-LSubject: OT:Are there any Detroit Lions fans on this list?Q. What's the difference between the Detroit Lions & the Taliban? A. The Taliban have a running game Q. How do the Detroit Lions count to 10? A. 0-1, 0-2, 0-3, 0-4, 0-5, 0-6, 0-7, 0-8, 0-9, 0-10 Q. What do the Detroit Lions & Billy Graham have in common? A. They both can make 80,000 people stand up & yell "Jesus Christ" ! Q. How do you keep a Detroit Lion out of your yard? A. Put up goal posts Q. Where do you go in Detroit in case of a tornado? A. To the Silverdone - they never get a touchdown there! Q. What do you call a Detroit Lion with a SuperBowl ring? A. A thief Q. Why doesn't Flint have a professional football team? A. Because then Detroit would want one Q. Why was Marty Mornhinweg upset when the Detroit Lions playbook was stolen? A. Because he hadn't finished coloring it. Q. What's the difference between the Detroit Lions and a dollar bill? A. You can still get four quarters out of a dollar Q. How many Detroit Lions does it take to win a Superbowl? A. Nobody knows and we may never find out! Q. What do you call 47 people sitting around a TV watching the SuperBowl? A. The Detroit Lions Q. What do the Detroit Lions and opossums have in common? A. Both play dead at home and get killed on the road Q. How can you tell when the Detroit Lions are going to run the football? A. The back leaves the huddle with tears in his eyes. Q. Knock knock Who's there. Owen Owen Who? A. Oh an 10.--Mladen Gogala--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Gogala, Mladen INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Password Changes
Sounds like you had better fess up and ask the user what it is ;-) If you know ahead of time that this is what you want to do, there is an old trick to change it and then change it back to the original when done. I just tried it on 8.1.7 and it still works: col password old_value pw10 select password from dba_users where username = upper('&1'); alter user &1 identified by temp1; Open another sqlplus sessions and logon using temp1 as the password. When you're done, change it back to the original password from the original session: alter user &1 identified by values '&pw10'; Mike >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Password Changes >Date: Thu, 06 Dec 2001 16:36:59 -0800 > > > >It can be seen in dba_users. The table is sys.user$. > >Once you've changed it, the old value is gone for good. > >Jared > > > > > > > "Burton, Laura > L." To: Multiple recipients of >list ORACLE-L <[EMAIL PROTECTED]> > plus.com>Subject: Password Changes > Sent by: > [EMAIL PROTECTED] > om > > > 12/06/01 10:29 > AM > Please respond > to ORACLE-L > > > > > > >When you alter a user's password, what table does it update? > > >I need to 'restore' a password for a user back to what it was before I >changed it, but do not know what it was. > > >Any ideas?? Can this be done? > > >Thanks, >Laura > > > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trigger exception problem
Oops:) I didn't remember exact parameter to use when calling 'userenv()'. So I just tried: select userenv('SESSIONID') from ( select * from dual ) ; and then pasted it (as it was) into e-mail message. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 1:43 PM > If you're gonna do that, then why not: > > select decode(process, process, process) > from ( select * from ( select * from v$session ) ) > where decode(audsid, audsid, audsid) = > ( select userenv('SESSIONID') from ( select * from dual ) ); > > Seriously though, why not just use > > select * from v$session where AUDSID = userenv('SESSIONID') > > :-) > > -p > --- > www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN > Smarter than adding another team member, Pythian has new services for > supplementing DBAs: get our help with monitoring, 24x7 on-call, daily > verifications, storage management, performance and more. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, December 07, 2001 1:23 PM > > > If you need current process: > > select process from v$session where AUDSID = (select userenv('SESSIONID') > from dual); > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, December 07, 2001 12:35 PM > > > > I told you I knew it was something stupid. Thanks the process was it. I > got rid of the process code and the duplicate error does now populate the > exception table like I wanted! > > > > I know need to figure out how to capture the specific process. Probably > next week when hopefully my head cold is gone, my kid isn't teething and I > have had some sleep. > > > > Thanks to all and to all a good weekend! > > > > Kathy > > > > -Original Message- > > Sent: Friday, December 07, 2001 5:35 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Kathy, > > > > I beleive the problem is in the exception handler: > > select process into v_process from v$session...This is returning multiple > rows. > > > > Rick > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > Confidential > > This e-mail and any files transmitted with it are the property > > of Belkin Components and/or its affiliates, are confidential, > > and are intended solely for the use of the individual or > > entity to whom this e-mail is addressed. If you are not one > > of the named recipients or otherwise have reason to believe > > that you have received this e-mail in error, please notify the > > sender and delete this message immediately from your computer. > > Any other use, retention, dissemination, forwarding, printing > > or copying of this e-mail is strictly prohibited. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kathy Duret > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Igor Neyman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Vallee > INET: [EMAIL PROTECTED
RE: ORACLE 9i Courses
Check at technet.oracle.com. Sometime back I had rcvd a mail from otn saying 9i stuff is avaialable in CD, I am not sure about the price, thou. -Original Message- Sent: Wednesday, December 05, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Hi, I am looking for good courses on Oracle 9i Database and Oracle 9iAS. Does anybody knows some links or resources??. It could be in Video, CD or something like that. Not interested in online courses (unless they are free :-) ). Thanks for all Gonzalo Romero -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gonzalo Romero INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are there any Detroit Lions fans on this list?
Mladen, keep your OT post off of this list please. Apparently the list is already too big and you only want to read about oracle and only oracle. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 28, 2001 11:52 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Burning game CD'sListen pal, this list is already too big as it is. Second, Ianswer questions far more frequently then I ask them. The fact is thatthis is not the forum to ask about burning CDs. If you have a problem withthat, you don't have to respond to any of the questions that I might ask.If you really want to discuss DMCA, DeCSS, 2600 case, Skylarov case andburning CDs then go to Slashdot.org or an appropriate linux newsgroup. Here,I want to read about oracle and only about oracle. Did I make myself clear?-Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Friday, December 07, 2001 1:17 PMTo: Multiple recipients of list ORACLE-LSubject: OT:Are there any Detroit Lions fans on this list?Q. What's the difference between the Detroit Lions & the Taliban? A. The Taliban have a running game Q. How do the Detroit Lions count to 10? A. 0-1, 0-2, 0-3, 0-4, 0-5, 0-6, 0-7, 0-8, 0-9, 0-10 Q. What do the Detroit Lions & Billy Graham have in common? A. They both can make 80,000 people stand up & yell "Jesus Christ" ! Q. How do you keep a Detroit Lion out of your yard? A. Put up goal posts Q. Where do you go in Detroit in case of a tornado? A. To the Silverdone - they never get a touchdown there! Q. What do you call a Detroit Lion with a SuperBowl ring? A. A thief Q. Why doesn't Flint have a professional football team? A. Because then Detroit would want one Q. Why was Marty Mornhinweg upset when the Detroit Lions playbook was stolen? A. Because he hadn't finished coloring it. Q. What's the difference between the Detroit Lions and a dollar bill? A. You can still get four quarters out of a dollar Q. How many Detroit Lions does it take to win a Superbowl? A. Nobody knows and we may never find out! Q. What do you call 47 people sitting around a TV watching the SuperBowl? A. The Detroit Lions Q. What do the Detroit Lions and opossums have in common? A. Both play dead at home and get killed on the road Q. How can you tell when the Detroit Lions are going to run the football? A. The back leaves the huddle with tears in his eyes. Q. Knock knock Who's there. Owen Owen Who? A. Oh an 10.--Mladen Gogala--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Gogala, Mladen INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Trigger exception problem
If you're gonna do that, then why not: select decode(process, process, process) from ( select * from ( select * from v$session ) ) where decode(audsid, audsid, audsid) = ( select userenv('SESSIONID') from ( select * from dual ) ); Seriously though, why not just use select * from v$session where AUDSID = userenv('SESSIONID') :-) -p --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 1:23 PM If you need current process: select process from v$session where AUDSID = (select userenv('SESSIONID') from dual); Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 12:35 PM > I told you I knew it was something stupid. Thanks the process was it. I got rid of the process code and the duplicate error does now populate the exception table like I wanted! > > I know need to figure out how to capture the specific process. Probably next week when hopefully my head cold is gone, my kid isn't teething and I have had some sleep. > > Thanks to all and to all a good weekend! > > Kathy > > -Original Message- > Sent: Friday, December 07, 2001 5:35 AM > To: Multiple recipients of list ORACLE-L > > > Kathy, > > I beleive the problem is in the exception handler: > select process into v_process from v$session...This is returning multiple rows. > > Rick > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > Confidential > This e-mail and any files transmitted with it are the property > of Belkin Components and/or its affiliates, are confidential, > and are intended solely for the use of the individual or > entity to whom this e-mail is addressed. If you are not one > of the named recipients or otherwise have reason to believe > that you have received this e-mail in error, please notify the > sender and delete this message immediately from your computer. > Any other use, retention, dissemination, forwarding, printing > or copying of this e-mail is strictly prohibited. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kathy Duret > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are there any Detroit Lions fans on this list?
LOL!! --Walt -Original Message- Sent: Friday, December 07, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Q. What's the difference between the Detroit Lions & the Taliban? A. The Taliban have a running game Q. How do the Detroit Lions count to 10? A. 0-1, 0-2, 0-3, 0-4, 0-5, 0-6, 0-7, 0-8, 0-9, 0-10 Q. What do the Detroit Lions & Billy Graham have in common? A. They both can make 80,000 people stand up & yell "Jesus Christ" ! Q. How do you keep a Detroit Lion out of your yard? A. Put up goal posts Q. Where do you go in Detroit in case of a tornado? A. To the Silverdone - they never get a touchdown there! Q. What do you call a Detroit Lion with a SuperBowl ring? A. A thief Q. Why doesn't Flint have a professional football team? A. Because then Detroit would want one Q. Why was Marty Mornhinweg upset when the Detroit Lions playbook was stolen? A. Because he hadn't finished coloring it. Q. What's the difference between the Detroit Lions and a dollar bill? A. You can still get four quarters out of a dollar Q. How many Detroit Lions does it take to win a Superbowl? A. Nobody knows and we may never find out! Q. What do you call 47 people sitting around a TV watching the SuperBowl? A. The Detroit Lions Q. What do the Detroit Lions and opossums have in common? A. Both play dead at home and get killed on the road Q. How can you tell when the Detroit Lions are going to run the football? A. The back leaves the huddle with tears in his eyes. Q. Knock knock Who's there. Owen Owen Who? A. Oh an 10. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need a listserver for :-( ms sql server
I'll try this again - this list may have what you want. It was active enough that I turned it off but I presume it is still going. --- SUBSCRIBING: --- Send a blank message to: mailto:[EMAIL PROTECTED] --- UNSUBSCRIBING: --- Send a message to your personal unsubscribe address: --- mailto:[EMAIL PROTECTED] CONTRIBUTING TO THE LIST: Send a message to: mailto:[EMAIL PROTECTED] -Original Message- Sent: Friday, December 07, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hi, Anyone know of a good list for mssql? TiA, -bill Sorsha: "I dwell in darkness without you," and it *went away*?!!from "Willow" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Messer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trigger exception problem
If you need current process: select process from v$session where AUDSID = (select userenv('SESSIONID') from dual); Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 12:35 PM > I told you I knew it was something stupid. Thanks the process was it. I got rid of the process code and the duplicate error does now populate the exception table like I wanted! > > I know need to figure out how to capture the specific process. Probably next week when hopefully my head cold is gone, my kid isn't teething and I have had some sleep. > > Thanks to all and to all a good weekend! > > Kathy > > -Original Message- > Sent: Friday, December 07, 2001 5:35 AM > To: Multiple recipients of list ORACLE-L > > > Kathy, > > I beleive the problem is in the exception handler: > select process into v_process from v$session...This is returning multiple rows. > > Rick > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > Confidential > This e-mail and any files transmitted with it are the property > of Belkin Components and/or its affiliates, are confidential, > and are intended solely for the use of the individual or > entity to whom this e-mail is addressed. If you are not one > of the named recipients or otherwise have reason to believe > that you have received this e-mail in error, please notify the > sender and delete this message immediately from your computer. > Any other use, retention, dissemination, forwarding, printing > or copying of this e-mail is strictly prohibited. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kathy Duret > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT:Are there any Detroit Lions fans on this list?
Q. What's the difference between the Detroit Lions & the Taliban? A. The Taliban have a running game Q. How do the Detroit Lions count to 10? A. 0-1, 0-2, 0-3, 0-4, 0-5, 0-6, 0-7, 0-8, 0-9, 0-10 Q. What do the Detroit Lions & Billy Graham have in common? A. They both can make 80,000 people stand up & yell "Jesus Christ" ! Q. How do you keep a Detroit Lion out of your yard? A. Put up goal posts Q. Where do you go in Detroit in case of a tornado? A. To the Silverdone - they never get a touchdown there! Q. What do you call a Detroit Lion with a SuperBowl ring? A. A thief Q. Why doesn't Flint have a professional football team? A. Because then Detroit would want one Q. Why was Marty Mornhinweg upset when the Detroit Lions playbook was stolen? A. Because he hadn't finished coloring it. Q. What's the difference between the Detroit Lions and a dollar bill? A. You can still get four quarters out of a dollar Q. How many Detroit Lions does it take to win a Superbowl? A. Nobody knows and we may never find out! Q. What do you call 47 people sitting around a TV watching the SuperBowl? A. The Detroit Lions Q. What do the Detroit Lions and opossums have in common? A. Both play dead at home and get killed on the road Q. How can you tell when the Detroit Lions are going to run the football? A. The back leaves the huddle with tears in his eyes. Q. Knock knock Who's there. Owen Owen Who? A. Oh an 10. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Password Changes
If you have an old full export of the database, you can find in the beginning of the file the users definitions like: Create user identified by values '' Search for the user you're interested in and get the encrypted password '' and run this command: Alter user identified by values '' ; Regards, Waleed -Original Message- Sent: Thursday, December 06, 2001 7:37 PM To: Multiple recipients of list ORACLE-L It can be seen in dba_users. The table is sys.user$. Once you've changed it, the old value is gone for good. Jared "Burton, Laura L." To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Password Changes Sent by: [EMAIL PROTECTED] om 12/06/01 10:29 AM Please respond to ORACLE-L When you alter a user's password, what table does it update? I need to 'restore' a password for a user back to what it was before I changed it, but do not know what it was. Any ideas?? Can this be done? Thanks, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAID system max throughput
I'm not sure that I understand the question. Is it: A. Under max load the RAID does not perform up to its specs? or B. Oracle does not stress the RAID enough for it to reach its max performance. If A, then have the RAID vendor fix whatever the problem is. If B, then good for you. You have a well designed system. DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L @LIFETOUCH.COcc: M> Subject: RAID system max throughput Sent by: root 12/07/2001 11:40 AM Please respond to ORACLE-L Whenever I discuss disk waits with my system administrator, I always get the reply that "the RAID system isn't anywhere near its rated throughput". Maybe I'm wrong, but I don't see any of the tuning books mentioning that as a relevant performance characteristic. However, I've never been able to move the discussion beyond this point. Can anyone straighten me out on this point or point me to a resource that might be applicable. Our system is Oracle 8.1.6, Compaq Tru64. We use hardware RAID-5 with a battery-backed RAM cache, and have about 3 RAID sets (plus some extra disks for redo logs, etc.), and performance is fine, but I'm always looking as to how we can improve Oracle performance. The application is our corporate ERP system. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need a listserver for :-( ms sql server
Hi, Anyone know of a good list for mssql? TiA, -bill Sorsha: "I dwell in darkness without you," and it *went away*?!!from "Willow" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cannot Drop Column
Dave: I am working on a database to do a DB conversion from IMS to 8.1.7. It is only being used to load the data for the conversion process. No application software will be connected to it. So, for convenience I am doing everything as SYS. I am the only person using this DB on a dedicated W2000 server. I accidentally added this column by the wrong name, so I want to delete the column so I can add the column with the correct name. I would change the name of the column but I have not found any syntax to do this. Thanks, Ken -Original Message- Sent: Friday, December 07, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject:Re: Cannot Drop Column Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cannot Drop Column
Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datawarehouse Sizes.....informal poll.
I don't think that size has much to do with it. You can have lots of data but if it's all in a few tables then it doesn't qualify as a datawarehouse (IMHO). My short take on this is that a datawarehouse is a OLTP database with de-normalized data that supports a DSS application. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Rich, Have you zeroed in on the exact circumstance(s) causing your ora-00600 error? If so, I would be interested in hearing about it just so I can watch out for it. For example, I encountered a reproducible 600 error when you had a leading or trailing space in a literal -- e.g. ' This is it'. It varied on different environments, and versions, some would see the error others wouldn't. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jesse, Rich > Sent: Friday, December 07, 2001 9:35 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: DBA Weakest Link > > > I dunno, but it's not 8.1.7.2 on HP > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, > Sussex, WI USA > > -Original Message- > Sent: Friday, December 07, 2001 09:05 > To: Multiple recipients of list ORACLE-L > > > > Q: In what version of Oracle did the cursor sharing feature become > > available? 7.3, 8.0, or 8.1? > > Q: In what version of Oracle did the 'cursor sharing' feature stopped > producing ORA-0600? > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cannot Drop Column
Ken, I think the more important question is "Why are you trying to drop a column in a table owned by Sys?" Jared Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/01 08:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Testing
I think that many of the more vocal members are busy playing, uh I mean *working* at OOW. Jared "Sherman, Edward" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Testing Sent by: [EMAIL PROTECTED] om 12/06/01 10:29 AM Please respond to ORACLE-L It's vewy vewy quiyet. * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Schema Owner
I will be willing to share blame for reasonable compensation. That numbered Swiss account will come in handy yet. Jared "Mercadante, Thomas F" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: ate.ny.us> Subject: RE: Schema Owner Sent by: [EMAIL PROTECTED] 12/07/01 05:10 AM Please respond to ORACLE-L so THAT'S what happened to that company! "I did the same thing at Enron to prevent the duhvelopers from changing account passwords." Jared Joe Testa as.net> cc: Sent by: Subject: Re: Schema Owner [EMAIL PROTECTED] om 12/05/01 07:15 PM Please respond to ORACLE-L You can't revoke the privilege from the schema owner but you CAN keep them from doing ddl and dml by using database triggers. now the catch is this: the trigger HAS to be owned by someone other than the schema owner AND the schema owner can't have the alter any trigger privilege(either direct or via a role). so yes Virgina(since its the xmas season), you can keep the schema owner from altering data in its own schema. joe DENNIS WILLIAMS wrote: > > Hamid - this was discussed recently on this list and as I recall you can't > revoke the schema owner. Can you create a new userid and get them to use > that? Then change the password on the schema owner. Barring that, you could > create a new schema, move the tables and indexes there, then grant select to > the original owner. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, December 05, 2001 1:15 PM > To: Multiple recipients of list ORACLE-L > > May be odd question, but I realy need to do this, I want to revoke the > privilege of the schema owner. > I mean give only select priv to the schema owner. > Thanks > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX
RE: Password Changes
Mike, Good point, I obviously was out to lunch on that one. Your mission, should you choose to accept it, is to search out and disseminate the knowledge regarding this old password. Should you choose not to accept this mission, I will disavow all knowledge of this email and claim it was spoofed by persons unknown. This message will not self destruct in 5 seconds, but will probably hang around in various archives for centuries, consuming valuable resources. Now where'd that coffee go to... Jared "Hand, Michael T" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Password Changes Sent by: [EMAIL PROTECTED] om 12/07/01 07:25 AM Please respond to ORACLE-L Jared, I may be out to lunch (and I haven't create too many users lately) but I though later versions of Oracle could be set to prevent repeating a password over time (and/or length, randomness restrictions). If this is the case, wouldn't the old password have to be kept somewhere? Mike -Original Message- Sent: Thursday, December 06, 2001 7:37 PM To: Multiple recipients of list ORACLE-L It can be seen in dba_users. The table is sys.user$. Once you've changed it, the old value is gone for good. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Trigger exception problem
I told you I knew it was something stupid. Thanks the process was it. I got rid of the process code and the duplicate error does now populate the exception table like I wanted! I know need to figure out how to capture the specific process. Probably next week when hopefully my head cold is gone, my kid isn't teething and I have had some sleep. Thanks to all and to all a good weekend! Kathy -Original Message- Sent: Friday, December 07, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Kathy, I beleive the problem is in the exception handler: select process into v_process from v$session...This is returning multiple rows. Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Retek ERP & ORacle
Anyone in this forum working with Retek ERP. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MRaval INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RAID system max throughput
Whenever I discuss disk waits with my system administrator, I always get the reply that "the RAID system isn't anywhere near its rated throughput". Maybe I'm wrong, but I don't see any of the tuning books mentioning that as a relevant performance characteristic. However, I've never been able to move the discussion beyond this point. Can anyone straighten me out on this point or point me to a resource that might be applicable. Our system is Oracle 8.1.6, Compaq Tru64. We use hardware RAID-5 with a battery-backed RAM cache, and have about 3 RAID sets (plus some extra disks for redo logs, etc.), and performance is fine, but I'm always looking as to how we can improve Oracle performance. The application is our corporate ERP system. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Q: In what year did Oracles Pricing Scheem become reasonable and affordable to smaller companies ?? A: Uhhh. in Two Thousand and One Alex ??? I am sorry . Trick Question .. The answer is NEVER !!! -Original Message- Sent: Friday, December 07, 2001 9:55 AM To: Multiple recipients of list ORACLE-L LMAO.. ;o) -Original Message- Sent: 07 December 2001 15:05 To: Multiple recipients of list ORACLE-L > Q: In what version of Oracle did the cursor sharing feature become > available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 9:20 AM > Hello DBAs, > > I'm having a company holiday party today, and as you all may know my company > employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) > > I'm thinking of having a "DBA Weakest Link" game for fun at some point of > the evening. Yes, I know, the partners/husbands/wives will think it's a bit > of a bore, but imagine the fun for us DBAs! :-) > > So what I'm trying to do is get many, many weakest link-style questions > (with answers) ready. I want them mostly to be easy, but with the odd hard > one snuck in for unfairness. Please help out by submitting your questions, > and I'll summarize and post the complete list back to the list when I'm > done! > > Sound like fun? I'll get us started with a format. > > Q: Name the Oracle error for "Table or view does not exist"? > A: Ora-00942, 942 > > Q: Which of the following return a value? Procedure, Function, Package, > Index? > A: Function > > Q: In what version of Oracle did the cursor sharing feature become > available? 7.3, 8.0, or 8.1? > A: 8.1 > > Q: In Oracle, the function that averages values is called: Average, or AVG? > A: AVG. > > Q: The structure Oracle uses to protect a region from memory from concurrent > access is called: Lock, Latch, or Library Catch? > Q: Latch > > Q: Larger block sizes make more efficient use of the buffer cache, or less > efficient? > A: Less efficient. > > I'd like to get at least a hundred ready for the game, preferably more. > Thanks for your help! > > Paul > --- > www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN > Smarter than adding another team member, Pythian has new services for > supplementing DBAs: get our help with monitoring, 24x7 on-call, daily > verifications, storage management, performance and more. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Vallee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in t
Identify tables not in use
Hi IS there any way to know how to identify which tables are not in use since particular date? Thanks seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Truncate Index??
Truncate also truncates the indexes. You don't have to do it as a separate operation. Dick Goulet Reply Separator Author: "Raghu Kota" <[EMAIL PROTECTED]> Date: 12/7/2001 7:30 AM Hi Friends, Iam truncating some 6Gb data from 3 tables!! So I want get rid of corresponding Indexes too!! Can I truncate index?? or rebuild the index after truncating table??? Any best method?? I don't want to drop any thing!! Just want to get rid of data!! Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Paul, Seriously think about obtaining professional help . -Original Message- Sent: Friday, December 07, 2001 8:20 AM To: Multiple recipients of list ORACLE-L Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a "DBA Weakest Link" game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. Q: Name the Oracle error for "Table or view does not exist"? A: Ora-00942, 942 Q: Which of the following return a value? Procedure, Function, Package, Index? A: Function Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? A: 8.1 Q: In Oracle, the function that averages values is called: Average, or AVG? A: AVG. Q: The structure Oracle uses to protect a region from memory from concurrent access is called: Lock, Latch, or Library Catch? Q: Latch Q: Larger block sizes make more efficient use of the buffer cache, or less efficient? A: Less efficient. I'd like to get at least a hundred ready for the game, preferably more. Thanks for your help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
I dunno, but it's not 8.1.7.2 on HP Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, December 07, 2001 09:05 To: Multiple recipients of list ORACLE-L > Q: In what version of Oracle did the cursor sharing feature become > available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cannot Drop Column
8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Corruption Problem
Hi Guys I Have a funny problem in my alert log i got the following errors for about 15mins *** Corrupt block relative dba: 0x0a877fd8 (file 42, block 491480) Bad header found during buffer read Data in bad block - type: 6 format: 2 rdba: 0x0b801ea2 last change scn: 0x.17a9d140 seq: 0x1 flg: 0x02 consistency value in tail: 0xd1400601 check value in block header: 0x0, block checksum disabled spare1: 0x0, spare2: 0x0, spare3: 0x0 *** now i found which table was at that block analyzed that table with cascade, no errors were reported i then didi a full table scan, no errors, then i did an export of that table no errors were reported ??? what could cause this? I'm running on HP-UX 64 bit and i did apply the 8.1.7.2.1 patch yesterday, could it be related? all Oracle tells me is to keep an eye it. I was hoping someone could give me a little more insight into this or if you have experienced any similiar kind of problems with corruption that wasn't there Thanks for any Help David Hill DBA LeChateau -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FILE SIZING
If you're testing performance, wouldn't you want your test environment to mirror what production would look like? I would think that a performance test of a NOARCHIVELOG db would have limited validity for an ARCHIVELOG mode production, especially with 100M log switches every two minutes. My $.02 :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, December 07, 2001 08:55 To: Multiple recipients of list ORACLE-L Hi, We never worked on large databases but we have to test our application for scability and performance test. It will be great if DBA handling large databases give some input on following : Environment is 9i on SUN 2.8. Database size will be about 375G. 1) In our testing environment log file switch is occuring every 2 minutes. The size of log files is 100M . What shold be the size of log files in Performance testing --- 500M or 1G . Is there any drawback in using large size of log files. For performance testing we will be running in noarchive log mode. 2) Two of our table sizes is 175G and 160G. We are partitioning both the tables into 10 partitions. What should be the ideal datafile size and initial extent size. Is there any drawbacks in using big datafiles. We always used about 2G file size for small databases. 3) We will be using locally manages tablespaces . which option is better for large database Uniform size or Autoallocate. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP
I shall suggest following material to pass OCP : CRAM series of OCP books STS software test questions Material from cramsessions.com MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 07 Dec 2001 06:45:20 -0800 If you can borrow someone's course notes even better as they do not stray from there. Your friend may have simply buckled under pressure or he did nothing but read the books. It helps to go through examples and play in your database. That way, when they throw you a question with different wording then what the book had you will be ok. Reading the manuals wouldn't hurt either (well, skimming them actually). -Original Message- Sent: Friday, December 07, 2001 3:15 AM To: Multiple recipients of list ORACLE-L I will advice you not to concentrate on one book. The reason because of limited knowledgebase, it is always better to hve multple books, even they are expensive. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 5:40 AM > Hi > > I have been a DBA for a few years now, I am consdering doing the OCP exams > > I have bought the Oracle 8i DBA certification Exam Guide. > > However I have been informed by a fellow DBA that he bought the same book, > studied it and took the practice tests and was getting around 90% in > these tests.. however when he came to doing the actual he just failed ! > > Does anyone have any thoughts on this ? > > Also is it possible to get mock exams that are more reflective of the > actual exams , from anywhere > > Regards > > Saj > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sajid Iqbal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lalit batra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
LMAO.. ;o) -Original Message- Sent: 07 December 2001 15:05 To: Multiple recipients of list ORACLE-L > Q: In what version of Oracle did the cursor sharing feature become > available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 9:20 AM > Hello DBAs, > > I'm having a company holiday party today, and as you all may know my company > employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) > > I'm thinking of having a "DBA Weakest Link" game for fun at some point of > the evening. Yes, I know, the partners/husbands/wives will think it's a bit > of a bore, but imagine the fun for us DBAs! :-) > > So what I'm trying to do is get many, many weakest link-style questions > (with answers) ready. I want them mostly to be easy, but with the odd hard > one snuck in for unfairness. Please help out by submitting your questions, > and I'll summarize and post the complete list back to the list when I'm > done! > > Sound like fun? I'll get us started with a format. > > Q: Name the Oracle error for "Table or view does not exist"? > A: Ora-00942, 942 > > Q: Which of the following return a value? Procedure, Function, Package, > Index? > A: Function > > Q: In what version of Oracle did the cursor sharing feature become > available? 7.3, 8.0, or 8.1? > A: 8.1 > > Q: In Oracle, the function that averages values is called: Average, or AVG? > A: AVG. > > Q: The structure Oracle uses to protect a region from memory from concurrent > access is called: Lock, Latch, or Library Catch? > Q: Latch > > Q: Larger block sizes make more efficient use of the buffer cache, or less > efficient? > A: Less efficient. > > I'd like to get at least a hundred ready for the game, preferably more. > Thanks for your help! > > Paul > --- > www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN > Smarter than adding another team member, Pythian has new services for > supplementing DBAs: get our help with monitoring, 24x7 on-call, daily > verifications, storage management, performance and more. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Vallee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Truncate Index??
Hi Friends, Iam truncating some 6Gb data from 3 tables!! So I want get rid of corresponding Indexes too!! Can I truncate index?? or rebuild the index after truncating table??? Any best method?? I don't want to drop any thing!! Just want to get rid of data!! Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
You gotta be kidding! I see this so often I see it in my sleep! "Snapshot too old: rollback segment...too small" Are you getting this error a lot? --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -Original Message- Sent: Friday, December 07, 2001 7:45 AM To: Multiple recipients of list ORACLE-L What is the error message associated with the often seen ORA-01555 error? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP
Just finished this a few months ago. My advice is to use the Oracle Exam Guide, Sybex Exam Guides, and Exam Cram as a third choice, but get the other two first. The ExamCram has much more detail, but does not explain concepts well. The STS (selftestsoftware.com) practice tests are really very good. I only used one, but it was done very well. I passed all tests on the first try with an average of about 90%. The actual tests are MUCH harder than the practice tests in the study guides (any of them). Also note, you not only need to study, but also TRY things. I installed Oracle on Linux at home and tinkered to my heart's content. Make sure you understand the DBA and V$ views or you won't pass. Best of luck, Ed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 4:40 AM > Hi > > I have been a DBA for a few years now, I am consdering doing the OCP exams > > I have bought the Oracle 8i DBA certification Exam Guide. > > However I have been informed by a fellow DBA that he bought the same book, > studied it and took the practice tests and was getting around 90% in > these tests.. however when he came to doing the actual he just failed ! > > Does anyone have any thoughts on this ? > > Also is it possible to get mock exams that are more reflective of the > actual exams , from anywhere > > Regards > > Saj > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sajid Iqbal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Paul, It's very thoughful of you to pre-plan an activity during your party, but, with all due respect, YOU'VE GOT TO BE KIDDING! "Sound like fun?" NOO!! DBA trivia at a Chrismas party?!?!? Come on, think of something EVERYONE (significant others included) can enjoy! DBAs have a bad enough reputation for not "having a life" - you don't need to reinforce it. IMHO, "shop talk" should be strictly banned at parties. Think of something a bit more fun - movie trivia, music lyrics, "the best jokes I've ever heard". There should be plenty of internet sites at which you could find lots of info. for topics such as these. Or - my favorite - have anyone who knows how to dance teach the others a step or two of Swing, Salsa, etc. Get those normally sedentary DBAs off their duffs and on their feet! Have a dance contest! Jokes could have the party-goers rolling on the floor - DBA trivia absolutely WON'T. Respectfully, Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Friday, December 07, 2001 8:20 AM To: Multiple recipients of list ORACLE-L Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a "DBA Weakest Link" game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. ... Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Weakest Link
What is the error message associated with the often seen ORA-01555 error? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datawarehouse Sizes.....informal poll.
Ross - Still hung up on size hmmm. How about this for a definition. A data warehouse encompasses data for the entire organization. A data mart services data for a portion of the organization. The history of this subject is relevant. In the 80's there were Executive Information Systems. Systems couldn't host much data then, but these were an attempt to have the relevant data the executives needed to make decisions. This didn't pan out. Then in the 90's came the Data Warehouse movement. Put all the data for the entire organization into a single database. Problem was that people spent years squabbling over the design and by the time the data warehouse was built, the business had evolved and the data warehouse wasn't very relevant. Some warehouses were successful, but many were not. This made everyone skittish about claiming they had a data warehouse. Meanwhile, some departments got tired of waiting and created their own. These came to be called data marts. Many of these data marts were able to show immediate results, so "data mart" sounds nice. As to size, the data marts at one organization may be larger than another organization's data warehouse. But as data marts matured, problems emerged. One data mart is great, but when an organization has dozens, you can get different results from different data marts because they were built with different data models, extract data at different times, and treat data differently. And if each data mart separately extracts data from the operational systems, this causes a lot of overhead. Now the whole field of data warehousing has matured. People that build them realize that warehouses aren't simple to build and there is more tolerance from management as to the effort required. And many organizations are seeing significant benefits. Ross - well that is about the limit of my knowledge. I don't know where you are heading with the warehousing, but I would highly recommend the mailto:[EMAIL PROTECTED] list. There are some real experts on that list (even Ralph Kimball participates from time to time), yet they are amazingly tolerant of newby questions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 06, 2001 9:00 PM To: Multiple recipients of list ORACLE-L Jared, Thanks. I have the main RK book. Like it. Understand what little i have read of it. I am just interested in what folks thought about "size vs. DW definition" was. I *do* think, tho, that "size does matter". I don't consider my shared E: drive a datawarehouse because it can support a star query, one user, and 300 MB of data. There is 'something' to do with the fact of...alot of dataskewed dimensions...regular updates...data cleaning...supporting mining ( and mining for a few tiny facts in a big haystack requires, after all, the big haystack ) Anyways. I figure anything under 250 GB doesn't even merit being called a data Warehouse. Maybe a data 7-11. Thanks for the pointers and your thoughts. Ross -Original Message- To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 12/6/2001 7:32 PM Ross, A DW is defined by purpose and design, not by size. A collection of Data Marts, ( tables for star joins ) is not a DW either. DW's are used to create data marts. If you don't already have the database books from Kimball, I suggest you acquire them. Data Warehouse Toolkit http://www.amazon.com/exec/obidos/ASIN/0471153370/ref=pd_sim_books/104-7 669992-7054323 Data Warehouse Lifecycle Toolkit http://www.amazon.com/exec/obidos/ASIN/0471255475/ref=pd_sim_books/104-7 669992-7054323 These are must haves for understanding and designing DW. Jared "Mohan, Ross" SMI.com> cc: Sent by: Subject: Datawarehouse Sizes.informal poll. [EMAIL PROTECTED] om 12/06/01 01:55 PM Please respond to ORACLE-L Informal survey: Datawarehousing. Limiting Assumption: "A necessary and sufficient condition for defining something to be a datawarehouse is the amount of data to be stored." Question/Poll: Given the above ridiculous constraint, at/above what size can something be considered a data warehouse? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
FILE SIZING
Hi, We never worked on large databases but we have to test our application for scability and performance test. It will be great if DBA handling large databases give some input on following : Environment is 9i on SUN 2.8. Database size will be about 375G. 1) In our testing environment log file switch is occuring every 2 minutes. The size of log files is 100M . What shold be the size of log files in Performance testing --- 500M or 1G . Is there any drawback in using large size of log files. For performance testing we will be running in noarchive log mode. 2) Two of our table sizes is 175G and 160G. We are partitioning both the tables into 10 partitions. What should be the ideal datafile size and initial extent size. Is there any drawbacks in using big datafiles. We always used about 2G file size for small databases. 3) We will be using locally manages tablespaces . which option is better for large database Uniform size or Autoallocate. Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Generating a SQLLDR Sequence Number
Ken, This is what I did once to do a similar exercise. I defined a seq dk_seq as in my case in the database and used the following control file. The next value of sequence should depend on how you define the sequence. LOAD DATA INFILE 'sysx.csv' TRUNCATE INTO TABLE dk_tmp FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' trailing nullcols ( CUSIP char, ISIN char, SMFchar, STATUS char, REASON char, ELG_DATE char, CURRENCY char, MATURITY char, seqno "dk_seq.nextval" ) -Original Message- Sent: Tuesday, December 04, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Tom: Ran into another problem. I need to generate a sequence number for one of the DB columns. Here is the CTL code: document_number sequence (max,80,1), It runs but I keep getting the 80 that doubles for each record (80, 160, 320, etc.). The book only shows the syntax but doesn't give an example of how it works. Any ideas? Thanks, Ken -Original Message- Sent: Tuesday, December 04, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject:RE: SQL Loader Commit Point? Ken Did you look at the Sql*Loader log file? Maybe all your records were rejected and placed into the .bad file? Does a .bad file exist? Sql*Loader does not really consider rejected records an error - it just moves them there. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 03, 2001 4:33 PM To: Multiple recipients of list ORACLE-L I am working on a control script that I have restricted to only loading 5 records as a test. Basically I am taking data from the load file and putting it into a table SQL Loader runs and gives me this. - SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Commit point reached - logical record count 5 -- When I do a select on this table I get no rows selected. I don't get an error message from SQL Loader. So any ideas as to what the problem is? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illega
RE: Password Changes
Jared, I may be out to lunch (and I haven't create too many users lately) but I though later versions of Oracle could be set to prevent repeating a password over time (and/or length, randomness restrictions). If this is the case, wouldn't the old password have to be kept somewhere? Mike -Original Message- Sent: Thursday, December 06, 2001 7:37 PM To: Multiple recipients of list ORACLE-L It can be seen in dba_users. The table is sys.user$. Once you've changed it, the old value is gone for good. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix account from PL/SQL ??
Assuming you're on Oracle 8i (you don't say): 1) select SYS_CONTEXT('USERENV','OS_USER') from dual; 2) I believe this is because the $ORACLE_HOME/bin/oracle executable has an owner of "oracle" and has the sticky bit set on it's security. If you "ls -l $ORACLE_HOME/bin/oracle", you should see the security on the file as "-rwsr-s--x", with the "s" being the sticky bit. Try a "man chmod" for more info. HTH! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, December 06, 2001 20:25 To: Multiple recipients of list ORACLE-L Hi all, I've got 2 questions here : (Platform : Sun Solaris) : 1. What is the command in PL/SQL to get unix userID who logged in when I execute PL/SQL script ? 2. I have created a new user : ABC123, and the primary group is oinstall. When I start oracle instance using ABC123, how come the process still belong to another user (oracle) ? Any feedback would be greatly appreciated Thanks & Regards Herman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Startup O9i remote / SOLVED
As you said, could be a parameter in the init.ora or also a spfile itself. Since you issue the create spfile from pfile, you generate a spfile in $ORACLE_HOME/dbs. Oracle, first look up for a spfile.ora, then for a spfile.ora and in the end the init.ora.. You could alter this order if you startup the database with pfile clause. Regards. --- [EMAIL PROTECTED] wrote: > > > Hi All, > > > Having a SPFILE doesn't mean you do not need a local > init.ora file anymore. > > It's just that it became a oneliner with just the > SPFILE parameter > specified. > > > Jack > > === > De informatie verzonden met dit E-mail bericht is > uitsluitend bestemd voor > de geadresseerde. Gebruik van deze informatie door > anderen dan de > geadresseerde is verboden. Openbaarmaking, > vermenigvuldiging, verspreiding > en/of verstrekking van deze informatie aan derden is > niet toegestaan. > Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de > inhoud van een verzonden E-mail, noch voor tijdige > ontvangst daarvan. > === > The information contained in this communication is > confidential and may be > legally privileged. It is intended solely for the > use of the individual or > entity to whom it is addressed and others authorised > to receive it. If you > are not the intended recipient you are hereby > notified that any disclosure, > copying, distribution or taking any action in > reliance on the contents of > this information is strictly prohibited and may be > unlawful. Ernst & > Young is neither liable for the proper and complete > transmission of the > information contained in this communication nor for > any delay in its > receipt. > === > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: REMOTE USER CREATION
Hi Raj, What version of Oracle are they running? This can be achieved I believe in 8.0 or later via a remote execution of a procedure that uses dynamic sql to run the create user command. Something like (in 8.1 syntax) procedure createuser (for_user in varchar2, for_pw in varchar2) is begin execute immediate 'create user ' || for_user || ' identified by ' || for_pw || ' default tablespace users temporary tablespace temp ' ; execute immediate 'grant create session to ' || for_user; end; Remember, the user who runs this procedure will require an explicit (not through a role) grant of the create user privilege. HTH, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 9:25 AM Hi Folks, I posted this last evening and it didn't show up yet..so here we go again.. Duhvelopement Grp has decided and developed a program that is inteded to create user in remote database thru DB link. Example. The program/procedure exists in database A. They need to call a procedure in Database B to create a user in Database B. They also need to to be able to supply username and password. Well.when they attempted to do that they got the ORA error. ORA 2064 02064, 0, "distributed operation not supported" // *Cause: One of the following unsupported operations was attempted: // 1. array execute of a remote update with a subquery that references //a dblink, or // 2. an update of a long column with bind variable and an update of //a second column with a subquery that both references a dblink //and a bind variable, or // 3. a commit is issued in a coordinated session from an RPC with //OUT parameters. // *Action: simplify remote update statement Now I am stuck with 'fixing' this. Has anybody done or seen this anywhere. ANy pointer would be welcome and appreciated. TIA Cheers, RS __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: some DBA help.
Lalit, Firstly, you should consider creating seperate instances for developement and live data usage. It's bad practice to have any kind of uncontrolled access to live databases such as developers (or even DBAs), no matter how good they are - sooner or later it will cause problems. To define 'types' of privilege and access rights to different users, you can use ROLES. Basically you can assign privs such as SELECT to various table to a role name 'CASUAL' (for example) and so on. Your 'users' should not create or own any database object such as tables, therefore any default tablespace you assign them will not hold data. Generally I create a tablespace called 'USERS' and set this as defualt TS for all users. The application objects and data will be available to the users via privilages via the Roles and possibly via public synonyms. Your questions are very general so I hope this helps. Regards, Mike. -Original Message- Sent: 07 December 2001 09:55 To: Multiple recipients of list ORACLE-L Assume that you are starting a new database and that you need to start adding user to this database. There are three basic types of users: developers (who can create basically all objects in the database), data processors (who can insert data into a given set of tables -CUSTOMER and ORDER TABLE as well as updates these tables) and casual user (who can view data from the INVENTORY and PARTS table). Assume also that every day there may be an unpredictable number of users to be added to the different types of categories. As a DBA, what can you do to make the task of adding user a little bit simpler? Would we assign developers and data processors to the same table space? Why or why not? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lalit Batra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:REMOTE USER CREATION
Raj, User creation is a DBA's responsibility in my book, therefore I don't understand why your having this problem in the first place. But since you are & since I just finished chasing this down recently. The problem is that a DML operation is attempting to happen over a remote database link. This implies a commit in a way that the two phase commit process can't handle. It's pretty well documented on MetaLink. Dick Goulet Reply Separator Author: "Sakthi ; Raj" <[EMAIL PROTECTED]> Date: 12/6/2001 2:45 PM Hi Folks , Somebody tell me I am not insane...please..!! The problem is this... As usual Everybody else except DBA ( me..) decided and designed a program to create user in other database using a procedure thru db_link. Example. The programme exists in database A. When they want they have to execute a procedure under sys schema in Database B to create a user in database B and they have to be able to pass username and password to teh procedure. well...God had other plans and they are getting ORA - 2064 "distributed operation not supported" NOw I am stuck with troubleshooting. Has anybody seen and/or used anything like this ? ANy pointer is welcome and would be appreciated. TIA Cheers RS __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).