Re: Database down
Well, I think the issue is two-fold. 1. They have been tinkering with user sessions, and the trace file output below is discussed on Steve Adams' website. PMON unable to acquire latch 80002060 modify parameter values possible holder pid = 58 ospid=29937 2001.12.09.15.27.43.000 I'm reviewing the settings in /etc/system. It is my belief that the additional application server pushed Oracle over some threshhold set in /etc/system. We are not running multi-threaded server, and we now have three application servers. 2. The issue with the patch has to do with my inability to restart the damn server due to an 'ORA-27123: unable to attach to shared memory segment'. I've asked our UNIX admin to verify we have the following patch: PATCH 105181-07 We are running 8.0.6 on Solaris 2.6. There are some issues with the sgadef.dbf file upon shutdown. This is only supposed to occur on a shutdown abort, but I've seen it occur on a shutdown immediate. I do not know if this patch specifically addresses the lingering sgadef.dbf file. Jeff [EMAIL PROTECTED] 12/11/01 12:10AM Jeff, I had a similar situation last week. I would like to know what patch are talking about and what's your version of Oracle? Regards, Ed I discovered the trace file after restarting Oracle - so that process ID is no longer out there. I've also discovered that there is a specific patch for this problem, which appears not to have been applied. I will move forward with this, but would like to provide management with an explanation as to why we had problems now, after so many days of uptime. Thanks for your help. Jeff [EMAIL PROTECTED] 12/10/01 03:35PM I don't suppose you've run ps -ef | grep 29937 yet, just out of curiousity, have you? -Original Message- Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around. Briefly, here is what occured: I restarted Oracle because our application was unable to connect. I could connect through svrmgrl, but a 'select sysdate from dual' just hung. So I brought the database down, and recieved the memory segment error. So we were having problems while the database was up. Here is a trace file dump that may be linked to the problem: PMON unable to acquire latch 80002060 modify parameter values possible holder pid = 58 ospid=29937 *** 2001.12.09.15.27.43.000 We added a third application server last week. Could that somehow be the source of these problems? This application has been running problem free for over 100 days. Thanks for your input Jeff -- 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 '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: Jeff Wiegard 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: Edward Shevtsov 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: Jeff Wiegard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Database down
ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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: Database down
Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around. Briefly, here is what occured: I restarted Oracle because our application was unable to connect. I could connect through svrmgrl, but a 'select sysdate from dual' just hung. So I brought the database down, and recieved the memory segment error. So we were having problems while the database was up. Here is a trace file dump that may be linked to the problem: PMON unable to acquire latch 80002060 modify parameter values possible holder pid = 58 ospid=29937 *** 2001.12.09.15.27.43.000 We added a third application server last week. Could that somehow be the source of these problems? This application has been running problem free for over 100 days. Thanks for your input Jeff [EMAIL PROTECTED] 12/10/01 02:27PM Hi Jeff, 1. the previous killed instance that still holds a shared memory segment ? 2. unappropriatedly large parameters of shared_pool and/or db_block_buffers ? Regards, Ed ORA-27123: unable to attach to shared memory segment SVR4 Error: 12: Not enough space Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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: Jeff Wiegard 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: Database down
I discovered the trace file after restarting Oracle - so that process ID is no longer out there. I've also discovered that there is a specific patch for this problem, which appears not to have been applied. I will move forward with this, but would like to provide management with an explanation as to why we had problems now, after so many days of uptime. Thanks for your help. Jeff [EMAIL PROTECTED] 12/10/01 03:35PM I don't suppose you've run ps -ef | grep 29937 yet, just out of curiousity, have you? -Original Message- Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around. Briefly, here is what occured: I restarted Oracle because our application was unable to connect. I could connect through svrmgrl, but a 'select sysdate from dual' just hung. So I brought the database down, and recieved the memory segment error. So we were having problems while the database was up. Here is a trace file dump that may be linked to the problem: PMON unable to acquire latch 80002060 modify parameter values possible holder pid = 58 ospid=29937 *** 2001.12.09.15.27.43.000 We added a third application server last week. Could that somehow be the source of these problems? This application has been running problem free for over 100 days. Thanks for your input Jeff -- 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 '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: Jeff Wiegard 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).
Snapshot Problems
Good Day. I have a problem with recreating some snapshots. I would like to add to the current set of snapshots. They were created in the following manner: create snapshot snap_test as select * from test@test_DB; They are executed nightly in the following manner: execute DBMS_SNAPSHOT.REFRESH('SCOTT.TEST','?'); However, when I try and create them, I get an ORA-01406 error, due to truncation of the varchar2(4000) . According to Oracle, this is a bug. Does someone know of a work-around? Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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: Altering Indexes
Ken, Try executing the following: select 'I am rebuilding my index '||index_name||' and putting it in another tablespace;' from user_indexes / and of course, spool the sucker, set heading off, set pagesize. Merry Spooling and Happy Selecting [EMAIL PROTECTED] 11/27/01 08:25AM I have this large DB (approx. 250 tables) that has the tables and indexes in the same tablespace (not my design). Is there a way I can move all of the indexes to a separate tablespace en-mass? I know I can move them one at a time with the alter index command, but that would be rather time consuming. 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: Jeff Wiegard 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).
Solaris - db_file_multiblock_read_count
Hi. I was hoping for some confirmation here. I'm running 8.0.5 on Solaris 2.7, with block size set to 8192. There is no 'maxphys' parameter in /etc/system. After some testing, I've decided to set the db_file_multiblock_read_count = 24, based on the following: 1. SQL alter session set db_file_multiblock_read_count = 1000; 2. select value from v$parameter where name = 'db_file_multiblock_read_count'; This gave me a value = 128 3. alter session set events '10046 trace name context forever, level 8'; 4. select /*+ FULL(t) */ count(*) from sys.source$ t; The trace file gave me the following: WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=660 p3=25 WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1167 p3=25 WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1207 p3=25 WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1272 p3=25 WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1312 p3=25 So then setting db_file_multiblock_read_count to 24 would be about right ... right? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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: W2000 Unix Command Equivalent
Install Cygwin, and you have access to a full set of UNIX commands - even a BASH environment. If you add the Cygwin/bin directory to your path, you can sit at the DOS prompt, and run most UNIX commands. You can also execute Windows commands from the BASH shell. I have Oracle 8i and 9i running on W2K, and I've modified some backup scripts to utilize the UNIX commands. You even get the 'man' pages. Jeff [EMAIL PROTECTED] 11/12/01 03:10PM Does anyone know where I can find a list of the W2000 equivalent commands for Unix. Such as show, set, etc. 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: Jeff Wiegard 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).
Oracle Label Security
Hi. I've been asked to look into this component for 8i, and I wasn't aware this even existed. Couldn't you just create views, or am I being naive? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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).
Oracle Data Guard
Hi. I'm looking into implementing a read-only stand-by database. I'd like to have it read-only for periodic reporting during the day. Is this possible under 8.1.7, or 9i? Are there any drawbacks to having the stand-by database opened for read-only? I would have two goals in mind: 1. A stand-by, read-only reporting db. 2. Easy switch-over to the stand-by. Are these two goals compatible? I can't find any documention on Data Guard for 8.1.7, as the links on Technet are broken. Thanks Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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).
Messy Messy SQL
I've been asked to review some troublesome SQL queries, and since I don't know what to do with this one, I thought I'd see what you all can come up with. They are doing the following: select A.value 1, C.value2, A.value3 from Table A, Table B, Table C where A.id = B.id and B.id = C.id and (A.ZIPS like ('%54016%') or A.ZIPS like ( '%54021%') or A.ZIPS like ( '%54351%') or A.ZIPS like ( '%54025%') or A.ZIPS like ( '%54246%') or A.ZIPS like ( '%54071%') or A.ZIPS like ( '%54023%') or A.ZIPS like ( '%54029%') or A.ZIPS like ( '%54078%') or A.ZIPS like ( '%54651%') or A.ZIPS like ( '%54901%') or A.ZIPS like ( '%55514%')) The only problem is that the actual data in the ZIPS field could be in the format of one of the following 3 samples: 55306:50 55358:100 56601:100 56301:25 56304:25 56379:25 The joins are on 400,000 row tables, and it's doing a full table scan on all three tables because of the first % wildcard in the like clause. It would be easy to get the values if they were all like the first format, because I could use 'substr(A.zips,1,5) = '55514'', but I don't know what to do with the second two samples, where there is more than one zipcode in the field. I would like to be able to find the ':' character and subtract 5 to get the zipcode, but there could be 3 ':' characters corresponding to 3 zips in one field. Any ideas? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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: Messy Messy SQL
Thanks - I was thinking about breaking it out as well, but thought there might be some trick out there from SQL For Smarties or something. [EMAIL PROTECTED] 10/31/01 11:37AM Jeff, That's a pretty silly way to store zip codes. Could you create a zipcode-id table, where you break out each zip and its id? Then search that table and join back to table a? Or, if you're at 8i, and if you only get up to a really small number (like the 3 you display) of zips in a combined zip field, you could create the first index on the zip field, and two additional function- based indexes on the second and third zip codes. Then instead of using like '%9%', you could use the function with which you created the index, like where substr(instr(zip_field, ' ')+1) like '9%'. Some thoughts, hope they help. God bless America. Yosi Jeff Wiegard wrote: I've been asked to review some troublesome SQL queries, and since I don't know what to do with this one, I thought I'd see what you all can come up with. They are doing the following: select A.value 1, C.value2, A.value3 from Table A, Table B, Table C where A.id = B.id and B.id = C.id and (A.ZIPS like ('%54016%') or A.ZIPS like ( '%54021%') or A.ZIPS like ( '%54351%') or A.ZIPS like ( '%54025%') or A.ZIPS like ( '%54246%') or A.ZIPS like ( '%54071%') or A.ZIPS like ( '%54023%') or A.ZIPS like ( '%54029%') or A.ZIPS like ( '%54078%') or A.ZIPS like ( '%54651%') or A.ZIPS like ( '%54901%') or A.ZIPS like ( '%55514%')) The only problem is that the actual data in the ZIPS field could be in the format of one of the following 3 samples: 55306:50 55358:100 56601:100 56301:25 56304:25 56379:25 The joins are on 400,000 row tables, and it's doing a full table scan on all three tables because of the first % wildcard in the like clause. It would be easy to get the values if they were all like the first format, because I could use 'substr(A.zips,1,5) = '55514'', but I don't know what to do with the second two samples, where there is more than one zipcode in the field. I would like to be able to find the ':' character and subtract 5 to get the zipcode, but there could be 3 ':' characters corresponding to 3 zips in one field. Any ideas? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield 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: Jeff Wiegard 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).
Consistent Gets
Hi. What exactly does Consistent Gets mean? Thanks Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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: Java in the database
Yes, I'd be interested to hear about peoples experience too. We developed a web portal for WWWRRR Inc. It was a Servlet framework. We found more success avoiding Oracle's Java technologies, as you're stuck with outdated Java classes, and/or Oracle-specific Java classes. Try getting the OCI drivers to work. It is an effort of a scale similar to the hunt for Osama ... [EMAIL PROTECTED] 10/25/01 12:16PM Out of curiosity, is anyone using the java engine for procedural code, or are most people still using PL/SQL? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Jeff Wiegard 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: Reallocate Table Storage
Thanks. Leaves are at their peak, but it's about to get COLD! Temp in the upper 20's when we wake up Saturday morning. Koivu, Lisa [EMAIL PROTECTED] 10/04/01 02:00PM Hi Jeff, Well if you have the time, export/import and reset your storage parms either in the dump file or with LMT's Or you can alter table move ... set new storage Or you could create table as as select new table name, drop initial table and rename new table. These are just a few options. How's beautiful Minnesota? I read that the leaves peaked last week. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Jeff Wiegard [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 2:55 PM To: Multiple recipients of list ORACLE-L Subject: Reallocate Table Storage good day ... I'm looking at a production, test, development environment tight on space. I've noticed there are a slew of tables that aren't used at all, or are improperly sized. In fact, I could recapture perhaps 20 percent of the used space, which measures in the gigabyte range. I have an idea of how I want to do this, but thought I'd post for how others have accomplished this. thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard 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: Jeff Wiegard 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).