No Subject
Registry, services? OH wait must be an NT thing, sorry, i was having an acid flashback that unix was going down the tubes. Sorry, joe Coed-naked Database Administration Find 'em fragmented, leave 'em coalesced. [EMAIL PROTECTED] 07/10/01 01:26PM Hello, I need to recreate a database, basically make a complete copy of one of the existing databases on a new server. My networking people already copied all datafiles, control file, log files, init file, etc to the target server. They also reproduced operating system directory structure. What I need to do is to make the second part of the task work, create the database, services, etc and make it run. I have not done it before and if I was doing it I would probably do export/import type of thing but the higher ups would like to have it done this way. One of the people has an idea suggesting just recreating the registry setting by exporting it from the existing machine to the new one. The other option is to reinstall Oracle but I am not sure how to make it to accept existing physical components(datafiles, control file, etc). If someone has a suggestion I would greatly appreciate it. Thank you in advance. Lyuda Hoska -- 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: what's wrong with this...DBMS_SQL
times that the above code is not forcing a log switch. FYI, I want to track the sequence# of logfiles before and after the hot backup, so that I can backup the files in that range. Am I properly using the DBMS_SQL? Any help is highly appreciated TIA, Suren Oracle DBA Sony -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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).
logminer in the 9i world, etc
Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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).
stupid question about indexes and partitions
Ok i have a table range partitioned on date. I have prefixed local indexes also. so far so good. I created an index, non partitioned, using simple create index index_name on table(field20); Is that now assumed to be a global index? I can't find any docs to say one way or the other. thanks, joe Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: weird bitmap error
for those that care bug# 1666543 is the psycho bitmap count(*) error problem. broke since it looks like 8.0.5 and still not fixed in 8.1.7 joe Joe, I saw this same problem post on lazydba just yesterday. It was a bug that is supposedly fixed in 8.1.7, but you know how that goes. It apparently does not corrupt data. You probably should look up the details on MetaClink. Jared On Tuesday 17 April 2001 08:00, Joseph Testa wrote: Scenario: AIX, 8.1.6.3. Cognos cube building going on. select count(*) from ft_sales, shows up 0 rows, its using a bitmap index out of the explain plan. I force full table scan or force to use other bitmap index, or PK(normal index) and it comes back with correct count(20+ million). Anyone seen anything like this before? thanks, joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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).
weird bitmap error
Scenario: AIX, 8.1.6.3. Cognos cube building going on. select count(*) from ft_sales, shows up 0 rows, its using a bitmap index out of the explain plan. I force full table scan or force to use other bitmap index, or PK(normal index) and it comes back with correct count(20+ million). Anyone seen anything like this before? thanks, joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: FOREIGN KEY to a remote table. Is it possible?
Nope, if you want to enforce RI thru a link, you'll need to implement it via triggers, email me offline, i'll give you the concept, i had to do it about 5 years ago. Joe From: "Andor Gyula" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: FOREIGN KEY to a remote table. Is it possible? Date: Tue, 03 Apr 2001 05:40:45 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id JAA13960for jtestamail@localhost; Tue, 3 Apr 2001 09:33:47 -0400 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Tue, 03 Apr 2001 09:33:47 -0400 (EDT) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f33Ed3527925for [EMAIL PROTECTED]; Tue, 3 Apr 2001 09:39:03 -0500 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA25699;Tue, 3 Apr 2001 06:30:56 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DF715; Tue, 03 Apr 2001 05:40:45 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Andor Gyula" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: HI, Is is possible to create a FOREIGN KEY constraint that references to a remote table through DATABASE LINK? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: OT: RANT ABOUT OCP, Re: Small help
Anyone who's watched the list for a week will know me, no political correctness here :) and thats probably the only reason i am OCP, the company i worked for at the time, paid for the tests and gave me a bonus to complete them. :) joe From: "Thater, William" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT: RANT ABOUT OCP, Re: Small help Date: Thu, 29 Mar 2001 05:00:25 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id IAA04008for jtestamail@localhost; Thu, 29 Mar 2001 08:36:51 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Thu, 29 Mar 2001 08:36:56 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2TEbEl28072for [EMAIL PROTECTED]; Thu, 29 Mar 2001 08:37:14 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA15519;Thu, 29 Mar 2001 05:24:54 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DB44A; Thu, 29 Mar 2001 05:00:25 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Thater, William" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: "Joseph S. Testa" wrote: Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe you know you really should tell us just how you feel and not beat around the bush that way.;-) i got asked yesterday by damagement why i wasn't certified. when i asked if they would pay for the courses/exams they didn't seem to think that was "in the training budget". so i said they's just have to put up with me the way i was and got back to building the database infrastructure.;-) oh well, guess i'll end up loosing out to someone with an OCP.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: changing db_block_size
I'd be interested in seeing that presentation, when are you presenting? I'll be there doing the logminer thing on tuesday late afternoon, last session before BIG BASH. thanks, joe To change the block size you have to recreate the database. How you are going to copy the data that's another issue. You can use full database export/import (pretty long downtime, or problems with data consistency) or you can do a live copy. More on a live copy you can see in: Venkat S. Devraj, Oracle 24x7 Tips Techniques, Osborne Press, 2000. I am currently working on a similar project (live database migration). I will present some results at IOUG if you are there. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:40 PM all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so small database. This is our oracle financials/manufacturing server and is about 30GB in size. Did you recreate the database using imp/exp or another method? Running Oracle 8.0.5 on Sun Solaris 7. thanks in advance...roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson 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: djordjej 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Support rational
well the concept of support is you pay for it and it covers all versions(at leats until desupported which seems quick nowadays). hence the concept of "free" version upgrades :) joe From: "O'Neill, Sean" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Support rational Date: Wed, 28 Mar 2001 07:56:54 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id MAA18674for jtestamail@localhost; Wed, 28 Mar 2001 12:19:34 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Wed, 28 Mar 2001 12:19:35 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2SIIKl23874for [EMAIL PROTECTED]; Wed, 28 Mar 2001 12:18:31 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA26331;Wed, 28 Mar 2001 09:10:32 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DA35F; Wed, 28 Mar 2001 07:56:54 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "O'Neill, Sean" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: I'm kind'a thinkin' out loud on this one. but suppose we have say 3 servers, with 8.1.7 Standard edition, is there any point in paying for Oracle support for all 3 or having problems with "any" one of them logged via one support package. Where are the gotcha's on this line of thinking (I'll hope there are some!)? For those who have differnet versions of Oracle on same site do ye all take support for each flavour/version/server of Oracle or use one to cover for version groups etc.? Sean:) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother. and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Moving user to a different tablespace ...
look at alter user command, yes break out the documentation and begin reading. joe From: Harsh Agrawal [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Moving user to a different tablespace ... Date: Fri, 23 Mar 2001 08:10:38 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id NAA14937for jtestamail@localhost; Fri, 23 Mar 2001 13:42:01 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Fri, 23 Mar 2001 13:42:02 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2NJjp013747for [EMAIL PROTECTED]; Fri, 23 Mar 2001 13:45:52 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id KAA26614;Fri, 23 Mar 2001 10:29:04 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002D6239; Fri, 23 Mar 2001 08:10:38 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Harsh Agrawal [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: By mistake a user was assigned default tablespace SYSTEM. How we can change it to some new tablespace let's say "TBS1" ? Because if we do export and import it will again import into that "SYSTEM" tablespace. Thanks, - Harsh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harsh Agrawal 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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:
Oracle docs at technet.oracle.com joe From: "Chesebro, Eric" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 22 Mar 2001 12:10:28 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id PAA07432for jtestamail@localhost; Thu, 22 Mar 2001 15:37:02 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Thu, 22 Mar 2001 15:37:02 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2MLbm004052for [EMAIL PROTECTED]; Thu, 22 Mar 2001 15:37:48 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA31939;Thu, 22 Mar 2001 12:31:18 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002D5337; Thu, 22 Mar 2001 12:10:28 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Chesebro, Eric" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: O Any one know where to find good documentation on sqlloader? Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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).
link to the free space .sql file
http://www.oracle-dba.com/backup/scripts/freespac.txt Use it as u please, edit, etc. its all yours. its a stored procedure, pretty straight forward, No i didnt give you an example of how to call it, make you think for your own a little bit, for those of you stuck, email me direct at [EMAIL PROTECTED] and i'll get an example out ot you, but at least try it on your own first :) Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Large DB Size? Manage datafiles?
Well(a cohort of mine on this list and) I worked with a 3terabyte(3000 gig) db before the project was dunked. It was interesting to say the least playing with that much data. it was to be an ODS and i played the dba role and the other guy(you know who you are) played the developer role, he discovered some kewl stuff in dealing with hash partitions and how to determine the hash key beforehand, so that we could load millions of rows via sql*loader direct path into a specific partition. joe From: "Joan Hsieh" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Large DB Size? Manage datafiles? Date: Wed, 14 Mar 2001 05:20:27 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id JAA11449for jtestamail@localhost; Wed, 14 Mar 2001 09:21:04 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Wed, 14 Mar 2001 09:21:04 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2EFLXw25355for [EMAIL PROTECTED]; Wed, 14 Mar 2001 09:21:33 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA81733;Wed, 14 Mar 2001 06:17:48 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002CC17E; Wed, 14 Mar 2001 05:20:27 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Joan Hsieh" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: Our typical databases right now are 800gb size. Each datafile is 4gb on raw disk (HP or SUNOS). One tablespace can have 85 datafiles. The data we deal with are blobs. The performance is not that good. Lots of problem. This place is not easy to change things. I think we should partition the table or at least do parallel query. Joan -Original Message- Sent: Wednesday, March 14, 2001 2:55 AM To: Multiple recipients of list ORACLE-L Dear All DBAs, So far, I only manage small Oracle databases, size between 30-40 GB (all datafiles). I just want to know how you will manage large Oracle database with 100 or more GB. What size is the largest database size you ever manage? How much data files and tablespaces you use for that database? Please share your experience as enterprise DBA Thank you in advance Yuzzie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yuzie 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: Joan Hsieh 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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).
LONG: Re: Order of table_name resolution
an 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Am I too hard on the developper ?
Comments inline: From a developer: 1. Although it may not always matter at the database level, the order of the columns within a table often follow a logical sequence. ALTER TABLE does not give you control over where in the column list that column will be added. Example: If you want to add a MIDDLE_NAME column, you would logically want it to be listed near the FIRST_NAME and LAST_NAME columns ... not at the end of the table. Think of it as de-fragmenting the table description ... it just makes things easier in the long run if similar columns appear in logical groupings. You point is moot, oracle does NOT guarantee order of columns, so ignore this point. 2. If the developers want to drop and re-create the tables in a development environment, let them. But also make them responsible for the grants. They can download a tool like TOAD for free (www.toadsoft.com). It will generate complete drop and recreate scripts for a table (or a complete schema), and include the grants, triggers, indexes, synonyms, storage criteria, etc. Generate the script for the table(s) they want to change, edit the script to add the new columns in their proper place, and execute it. Table dropped, re-constructed, and grants re-granted. No DBA involvement needed. Point well taken except for one thing, when the screw them up who they gonna come and see to bail them out, the DBA, so not letting them do that stuff make less work for the dba. ignore this point also. 3. In the future, keep in mind that DBAs and Developers should work as a team, not as opponents. You need each other. I see too many posts here from DBAs who seem to look down on developers. There are good and bad developers, but guess what ... there are also good and bad DBAs. We've had both here. Dave The only valid point you made. Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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).