Re: Increase size of data files and rollback segments
Behave children. ;) No, I wasn't reading the list. Another story... Jared On Tuesday 10 December 2002 10:20, Rachel Carmichael wrote: 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
From bitter experience: Do not allow your datafile to autoextend across 4GB boundary. There is a bug that cause this datafile to be unusable. We had an all night session after this bug hit us. We had to call Oracle to come with the DUL utility to recover the data. Now we define our datafiles to be 1900MB each. Also each tablespace has an extra datafile with 200MB size with autoextend up to 1900MB. Our checks check that each tablespace has datafile with 200MB size. If not we get an alert and check the situation. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:46 AM David, As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
On Wed, 11 Dec 2002, Yechiel Adar wrote: Do not allow your datafile to autoextend across 4GB boundary. There is a bug that cause this datafile to be unusable. I think the 4Gb limit is confined to a handfull of older operating system versions or older Oracle versions. For about the last five years I have been accustomed to creating 16Gb datafiles with no problem. Imagine trying to build a 5 terabyte data warehouse out of 1900Mb datafiles! It would require 2760 datafiles! Can anyone confirm that this is no longer a problem after certain versions of O/S and Oracle? Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you specify no size for a datafile, then adds it to the controlfile /data dictionary in a way that makes it look like it has a ton (like a terabyte) of free space. The datafile can't be resized or offline dropped, and the tablespace must be dropped and recreated (unless you get the patch). Let one segment extend into there and watch the ORA-600s. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:46 AM As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Increase size of data files and rollback segments
Hello Jeremiah I did some research on metalink and it says: 1) Do not use datafiles more then 4GB on NT systems. 2) There is a bug on NT, W2K that if you resize datafile (direct command or autoextend) to 4GB boundary, i.e 4,8,12, then there are two conditions: 2.1) No archive log - database crashes but you can start again and resize the datafiles. 2.2) Archive log - restore and regenerate to a point in time prior before the resize. This bug was reported also on 9.2. The work around is to resize to 4.1, 8.1 GB datafiles. Bug number 1668488. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 12:54 PM On Wed, 11 Dec 2002, Yechiel Adar wrote: Do not allow your datafile to autoextend across 4GB boundary. There is a bug that cause this datafile to be unusable. I think the 4Gb limit is confined to a handfull of older operating system versions or older Oracle versions. For about the last five years I have been accustomed to creating 16Gb datafiles with no problem. Imagine trying to build a 5 terabyte data warehouse out of 1900Mb datafiles! It would require 2760 datafiles! Can anyone confirm that this is no longer a problem after certain versions of O/S and Oracle? Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you specify no size for a datafile, then adds it to the controlfile /data dictionary in a way that makes it look like it has a ton (like a terabyte) of free space. The datafile can't be resized or offline dropped, and the tablespace must be dropped and recreated (unless you get the patch). Let one segment extend into there and watch the ORA-600s. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:46 AM As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Increase size of data files and rollback segments
Yechiel, Thanks for pointing out the potential issues with autoextending onto an exact 4 Gb boundary (as I forgot to include them). Reading the bug you referenced (at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUGp_id=1668488) it says: ... Does not reproduce on 8.1.7 Sun Solaris. ... Rediscovery Information: Resize a datafile file to [exactly] 4GB, 8G, 12G, 16G, etc. After resizing a datafile to 4G, alter system checkpoint was failing with ORA-27069 ... This fix is in 8.1.7.4.1 and 9.0.1.4.0 but not in 9.2.0.2.1 I am on 8.1.7.4.5 and so am not affected by this issue - I can't remember the version the original poster was on. Anyone using 817x may also want to check note 120607.1 (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=120607.1) titled Support Status and Alerts for Oracle8i Release 3 (8.1.7.X) for information on this and other issues. This refers you to Note 148894.1 (http://metalink.oracle.com/metalink/plsql/showdoc?db=Notid=148894.1) titled ALERT: Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms This contains the information ... A fix is now available in 8.1.7.1.4 Bug.1823173 and will be included in8.1.7.3 BUG.1794199 ... For general Oracle information on 2Gb files see http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=62427.1p_database_id=NOT titled 2Gb or not 2Gb - File limits in Oracle. This contains links to other notes with Port specific information. I hope this helps. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 11 December 2002 11:19 PM Hello Jeremiah I did some research on metalink and it says: 1) Do not use datafiles more then 4GB on NT systems. 2) There is a bug on NT, W2K that if you resize datafile (direct command or autoextend) to 4GB boundary, i.e 4,8,12, then there are two conditions: 2.1) No archive log - database crashes but you can start again and resize the datafiles. 2.2) Archive log - restore and regenerate to a point in time prior before the resize. This bug was reported also on 9.2. The work around is to resize to 4.1, 8.1 GB datafiles. Bug number 1668488. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 12:54 PM On Wed, 11 Dec 2002, Yechiel Adar wrote: Do not allow your datafile to autoextend across 4GB boundary. There is a bug that cause this datafile to be unusable. I think the 4Gb limit is confined to a handfull of older operating system versions or older Oracle versions. For about the last five years I have been accustomed to creating 16Gb datafiles with no problem. Imagine trying to build a 5 terabyte data warehouse out of 1900Mb datafiles! It would require 2760 datafiles! Can anyone confirm that this is no longer a problem after certain versions of O/S and Oracle? Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you specify no size for a datafile, then adds it to the controlfile /data dictionary in a way that makes it look like it has a ton (like a terabyte) of free space. The datafile can't be resized or offline dropped, and the tablespace must be dropped and recreated (unless you get the patch). Let one segment extend into there and watch the ORA-600s. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:46 AM As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network
RE: Increase size of data files and rollback segments
Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
David, If my three year old said that, he'd be on the step immediately. Jeremiah has helped a lot of people on this list. The point is that you need to take a certain amount of responsibility to do some research before posting a question (i.e. metalink, tahiti.com, ...). Also, all answers should be checked out. All obvious points (I hope). Now please take a deep breath and try again. Henry -Original Message- David M Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Increase size of data files and rollback segments Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments What bothers me is why can't you use sqlplus? Why do you need GUI tool? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Henry Poras [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Increase size of data files and rollback segments David, If my three year old said that, he'd be on the step immediately. Jeremiah has helped a lot of people on this list. The point is that you need to take a certain amount of responsibility to do some research before posting a question (i.e. metalink, tahiti.com, ...). Also, all answers should be checked out. All obvious points (I hope). Now please take a deep breath and try again. Henry -Original Message- David M Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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 message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Increase size of data files and rollback segments
Speak for yourself, man. I think the type of people we don't welcome here is those who don't bother to read a doc on something as trivial as how to increase the size of datafile and can't take a joke. Richard -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments Au contraire, I welcome Jeremiah just about anywhere, as long as he doesn't drink too much of my beer. Read between the lines, David.There's a message there. :) --Walt Weaver Bozeman, Montana -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Increase size of data files and rollback segments Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
David, Wrong. we very much welcome Jeremiah here. He has helped countless people on this list, and if he on occasion chooses to make a joke (as do we all), then so be it. He was a good deal gentler and nicer than my first thought, which was to tell you to read the fine manual before asking basic questions. Many of us spend a LOT of time on this list, helping others. It is very discouraging though to continually get questions that can be answered by a very simple read of the manuals. I suggest that in the future, you attempt to investigate a problem yourself before asking a question. Besides the fact that you will learn much more by doing your own research, you will not annoy the members of the list who try to help. Rachel --- Nguyen, David M [EMAIL PROTECTED] wrote: Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
I welcome David input always, especially when he is yanking the leg of someone who did not troubled himself to open the SQL manual and look at obvious commands like alter rollback segment and alter tablespace. I liked his answer. BTW, Please do not tell ANYONE on this list to shut up. It is bad behavior and, believe me, you need those guys the same as me. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 5:49 PM Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments ORACLE ORACLE ORACLE ORACLE SQL*NET Just bringing it back on topic :) Nick -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:21 AM To: Multiple recipients of list ORACLE-L Subject: Re: Increase size of data files and rollback segments 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
Walt, Your french is pretty good ! --- Weaver, Walt [EMAIL PROTECTED] a écrit : Au contraire, I welcome Jeremiah just about anywhere, as long as he doesn't drink too much of my beer. Read between the lines, David. There's a message there. :) --Walt Weaver Bozeman, Montana -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
Thanks, I had to drop off the Lazy DBA list because of all the sniping. I would hate to have to drop off Jared's list too. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 1:20 PM 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services--
RE: Increase size of data files and rollback segments
Alright guys, just because you know Jeremiah better than me so you can take his joke. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. If you were in my situation, you would understand. -Original Message- Sent: Tuesday, December 10, 2002 1:26 PM To: Multiple recipients of list ORACLE-L Thanks, I had to drop off the Lazy DBA list because of all the sniping. I would hate to have to drop off Jared's list too. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 1:20 PM 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an
RE: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard...
RE: Increase size of data files and rollback segments
David, As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/dfiles.htm -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Monday, December 09, 2002 5:24 AMTo: Multiple recipients of list ORACLE-LSubject: Increase size of data files and rollback segments How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Thanks,David
Re: Increase size of data files and rollback segments
On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Increase size of data files and rollback segments
A cruel joke Jeremy! BTW may be you can help me out here. I am not receiving back any of the messages I send to the the list and I do not know if list is receiving my messages either. Do you know how to solve this problem? Thanks in advance Shaleen Garg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 3:38 AM On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).