test
test. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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).
Linux profile - a little offtopic
Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. T.I.A. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Linux profile - a little offtopic
On June 30, 2001 01:30 pm, Csillag Zsolt wrote: Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. Take a look at /etc/profile - this is the default system-wide user profile (be aware that all changes to this file will affect all non-root users on the system). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: ADMIN: Results of voting
Title: RE: ADMIN: Results of voting Sorry listers. THat was supposed to go to Ashoke directly and not to the list. I forgot to paste the email address... --Chris [EMAIL PROTECTED] -Original Message- From: ASHOKE MANDAL [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 30, 2001 2:10 AM To: Multiple recipients of list ORACLE-L Subject: Re: ADMIN: Results of voting I am not sure what is this regarding. I might have missed the original e-mail. Without understanding the issue I just want to say that I like to remain subscribed with this group. Thanks, Ashoke From: Bruce Bergman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ADMIN: Results of voting Date: Fri, 29 Jun 2001 17:35:23 -0800 Sorry I haven't gotten back to y'all sooner; I've been busy with the ODTUG conference. The voting completed last week and here are the results: Open: 6 Close: 44 Abstentions: 1157 (apathy wins again) Thus I will be making the subscriber list unavailable to anyone this weekend. Thanks to everyone who responded! bruce ListMaster, Fat City Network Services -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce Bergman 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: ASHOKE MANDAL 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: Function slows the select
What version of database? On Wednesday 27 June 2001 04:20, Csillag Zsolt wrote: Hi, In the following select statement I have a function GetSid that slows the update for hours even if the Link_keszit updatable table consists of a few rows. Update UpdateTable--Varosokat updatel Set UpdateTable_Column1= -- ( Select distinct 'Some string here'||GetSid||UpdateTable_Column2||Logo.Logo_Filenev From VarosTorzs,Logo, Link_keszit Where logo_varos_unique_az = link_keszit_varos_az and logo.logo_azonosito1= 'KKEPX' and logo.logo_azonosito2= '20200' and logo_varos_unique_az = varos_unique_azonosito ) Where UpdateTable_Column2 Is Not Null ; The GetSid function is: CREATE OR REPLACE Function GetSid Return VarChar2 AS BEGIN return(SYS_GUID()); END GetSid; So the problem is that _with_ GetSid function it takes many hours instead of a few minutes. Thank you in advance Zsolt Csillag, Hungary Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- 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: Install Oracle 9i on SUSE Linux 7.1
i'm w/jared, i've yet to get unattended install to work. joe Jared Still wrote: Oliver, Have you actually seen the non-interactive setup work? I've tried, no go. I'll try scp when I can get non-interactive to work. Jared On Friday 29 June 2001 10:53, Oliver Artelt wrote: Hi, read the chapter 'Non-Interactive Installation and Configuration' in your platform-dependant Oracle9i Installation Guide. BTW Are there any hardcore dba's out there which installing via scp from one to another machine? oli [EMAIL PROTECTED] wrote: So basically I encountered not one single problem. It just took a hell of a time to do the install. I work for a client with more than 200 databases (small, but a lot of big ones), so we need to optimize the install or upgrade. Off course the machines are a whole lot bigger than my portable. -- -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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).
ALTER SYNONYM?
Is there a way to do what would be an ALTER SYNONYM? I've got a synonym created that rotates between pointing to two different tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is so that behind the scenes, I can truncate and reload TABLE_A, and then swap, etc. so the table never disappears.) However, when I want to switch the SYNONYM from pointing to TABLE_A to pointing to TABLE_B, the only way is to: drop synonym table_syn; create synonym table_syn for table_b; Is there a way to make that instantaneous for the database? If someone does a select at the exact instant between those two commands, it'll error out, because the table won't exist. -Rick +--+ | Rick Osterberg [EMAIL PROTECTED]| | Database Applications Specialist FAS Computer Services | +--+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rick Osterberg 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).
temp problem when rebuilding Index
Hi Friends Iam rebuilding my 6Gb index, But Iam getting problem with TEMP tablespace. What is solution for this?? iam using alter index index_name rebuild tablespace_name; ORA-1652: unable to extend temp segment by 128 in tablespaceTEMP Any Ideas?? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- 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: temp problem when rebuilding Index
You can drop the index and recreate it again, it would be faster and would need less space Ramón Estévez *809-565-3121 x 225 * [EMAIL PROTECTED] -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Raghu Kota Enviado el: Saturday, 30 June, 2001 4:36 PM Para: Multiple recipients of list ORACLE-L Asunto: temp problem when rebuilding Index Hi Friends Iam rebuilding my 6Gb index, But Iam getting problem with TEMP tablespace. What is solution for this?? iam using alter index index_name rebuild tablespace_name; ORA-1652: unable to extend temp segment by 128 in tablespaceTEMP Any Ideas?? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- 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: Ramon Estevez 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: temp problem when rebuilding Index
On June 30, 2001 06:35 pm, Raghu Kota wrote: Hi Friends Iam rebuilding my 6Gb index, But Iam getting problem with TEMP tablespace. What is solution for this?? iam using alter index index_name rebuild tablespace_name; ORA-1652: unable to extend temp segment by 128 in tablespace TEMP You need to either partition your table or increase the size of temp. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: temp problem when rebuilding Index
Yeah I can't do parition, I think I have increase TEMP. But How much can I increase?? Is there any measurement?? Thanks to all responses. From: Gregory Conron [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: temp problem when rebuilding Index Date: Sat, 30 Jun 2001 14:41:01 -0800 On June 30, 2001 06:35 pm, Raghu Kota wrote: Hi Friends Iam rebuilding my 6Gb index, But Iam getting problem with TEMP tablespace. What is solution for this?? iam using alter index index_name rebuild tablespace_name; ORA-1652: unable to extend temp segment by 128 in tablespace TEMP You need to either partition your table or increase the size of temp. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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 Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- 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: Linux profile - a little offtopic
What shell are you using? Different shell uses different startup filename. If you are using bash, then it's .bashrc [EMAIL PROTECTED] 06/30/01 12:30PM Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. T.I.A. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Richard Ji 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: Re: Sizing Raw Vols and Oracle Datafiles
Hmmm, it is just me or did everyone get the same message multiple times (like ten or more)? [EMAIL PROTECTED] 06/29/01 05:02PM Folks, Have a question regarding sizing raw volumes and Oracle datafiles. I'm using Veritas 3.1, Solaris 2.6 and Oracle 8i (R2) This is what I did. Using Volume Manager, I resized a raw volume from 1GB to 2GB (the raw volume belonged to an Oracle datafile). I then went into Oracle and did a alter database datafile 'temp.dbf' resize 1999M. I did this after making sure that the raw volume had enough room to grow and that it would not overwrite any other volumes. When discussing this with an SA, he said that he has never done this or has been asked to do this either in an Oracle shop or Sybase shop. He's been told by other DBAs' that this should never be done and it is best to add new volumes and then do 'alter tablespace add datafile ...'. I was unable to get an answer as to why this is bad and should'nt be done. So, my question is, is this a myth; can it done and if not, what is the reason for not doing this? Any opinions or facts? Thanks mkb __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti 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: Richard Ji 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: temp problem when rebuilding Index
On June 30, 2001 08:30 pm, Raghu Kota wrote: Yeah I can't do parition, I think I have increase TEMP. But How much can I increase?? Is there any measurement?? Thanks to all responses. How much free disk space do you have? If your index is 6gigs, you will need a like amount of temp space to accomodate the sorting. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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).
Calculating The Median: Error Discovered in Oracle SQL 101 Code
I ran the code from Oracle SQL 101 which Jared posted modifying it to find the median of the sal column on that table SQL select 2 rownum, 3 sal 4 from ( 5 select sal 6 from scott.emp 7 where sal is not null 8 union 9 select 1 from dual where 1=2 10 ) 11 group by sal, rownum 12 having rownum = ( 13 select decode( mod(total_freq,2), 141,trunc(total_freq/2 + 1), 150,trunc(total_freq/2) 16 ) 17 from ( 18select count(*) total_freq 19from scott.emp 20where sal is not null 21 ) 22 ) 23 and rownum = ( 24 select decode( mod(total_freq,2), 251,trunc(total_freq/2 + 1), 260,trunc(total_freq/2 + 1) 27 ) 28 from ( 29select count(*) total_freq 30from scott.emp 31where sal is not null 32 ) 33 ) 34 / values averaged ROWNUM in median -- -- 7 1600 8 2450 -- Median 2025 -- This answer is different from the result of the code I posted which uses the new analytical functions. select case when mod(number_salaried,2) = 0 then (select sum(sal)/2 from(select sal, row_number() over ( order by sal) as salrank from scott.emp) where salrank = number_salaried/2 or salrank = number_salaried/2 +1) else (select sal from(select sal, row_number() over ( order by sal) as salrank from scott.emp) where salrank = ceil(number_salaried/2)) end median from (select sal,rank() over (order by sal) as rk from scott.emp), (select count(sal) number_salaried from scott.emp) where rk = 1 / MEDIAN - 1550 Emp is a 14 row table . The median should be the average of the seventh and eighth values. I cleared the computes and columns and ran the first part of the SQL 101 code clear computes utes cleared select rownum, sal from ( select sal from scott.emp where sal is not null union select 1 from dual where 1=2 ) group by sal, rownum / ROWNUMSAL -- -- 1800 2950 3 1100 4 1250 5 1300 6 1500 7 1600 8 2450 9 2850 10 2975 11 3000 ROWNUMSAL -- -- 12 5000 and also ran the part of my code which corresponded. I changed my code slightly so the salrank column would print. SQL select salrank, sal from(select sal, row_number() 2 over ( order by sal) as salrank 3 from scott.emp) 4 / SALRANKSAL -- -- 1800 2950 3 1100 4 1250 5 1250 6 1300 7 1500 8 1600 9 2450 10 2850 11 2975 SALRANKSAL -- -- 12 3000 13 3000 14 5000 14 rows selected. -- The reason for the different answers is now apparent. The SQL 101 code is tossing duplicate records. It's been a long time since my stats classes, but I'm about 99.99% confident you don't purge duplicates when computing a median. But even if I'm wrong about this, the SQL 101 code has reduced the set to 12 members, but it is still computing the median as if there were 14 members; that is, it is taking the average of the 7th and 8th values and not the average of the 6th and 7th. I hope there was a caveat in SQL 101 book stating the code only worked against columns with unique values, not including nulls. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: Linux profile - a little offtopic
also, try man bash (or whatever your shell is). It will explain what files are sourced under which circumstances. george On Saturday, June 30, 2001, at 01:20 PM, Gregory Conron wrote: On June 30, 2001 01:30 pm, Csillag Zsolt wrote: Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. Take a look at /etc/profile - this is the default system-wide user profile (be aware that all changes to this file will affect all non-root users on the system). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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: George Schlossnagle 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: temp problem when rebuilding Index
Title: RE: temp problem when rebuilding Index This will have to be decided based on the key fields for the index. You will have to arrive at an approximate value and increase temp accordingly. rgds amar -Original Message- From: Gregory Conron [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 01, 2001 3:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: temp problem when rebuilding Index On June 30, 2001 08:30 pm, Raghu Kota wrote: Yeah I can't do parition, I think I have increase TEMP. But How much can I increase?? Is there any measurement?? Thanks to all responses. How much free disk space do you have? If your index is 6gigs, you will need a like amount of temp space to accomodate the sorting. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron 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).