| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent..RE: Temp problem
Thankyou all people!!
>From: "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Urgent..RE: Temp problem
>Date: Mon, 23 Jul 2001 10:20:24 -0800
>
>Raghu,
>
>I would try and create a new tablespace (name it TEMP1, type=temporary)
>while running, and alter the user's accounts to point to the new
>tablespace.
>Wait awhile, and try and drop the old TEMP tablespace.
>
>Seems to me that if there are temporary segments in use, Oracle will not
>let
>you drop the tablespace.
>
>If all else fails, kick the users off, drop and re-create the TEMP
>tablespace.
>
>hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Monday, July 23, 2001 1:35 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>
>It seems for me the block 134552 was corrupted!!.I think I have option to
>repair that block or drop temp tablespce!! So How can I drop temp tablespce
>in production!!! and If you any body to repair that block let me
>know..Thanks to all
>
>TIA
>Raghu.
>
> >From: "Hitchman, Peter" <peter.hitchman_at_derwent.co.uk>
> >To: 'Raghu Kota' <raghukota_at_hotmail.com>, "LazyDBA.com Discussion"
> ><oracledba_at_lazydba.com>
> >Subject: RE: Temp problem
> >Date: Mon, 23 Jul 2001 15:38:30 +0100
> >
> >Hi,
> >I have no experience of AIX, but to me the error message indicates that
>you
> >are creating
> >data files that are too large. Assuming that you are on a 32 bit system,
> >make sure that each
> >datafile is <= 2Gb. So if you require tablespaces greater than 2Gb, you
> >create many datafiles per tablespace.
> >
> >Regards
> >
> >Pete
> >
> >[END]
> >
> >-----Original Message-----
> >From: Raghu Kota [mailto:raghukota_at_hotmail.com]
> >Sent: Monday, July 23, 2001 3:23 PM
> >To: LazyDBA.com Discussion
> >Subject: Temp problem
> >
> >
> >
> >
> >Hi Friends
> >
> >I have problem with TEMP tablespace!! I tried to resize my
> >datafile,But that
> >too giving errors!! So I shutdown my production database and
> >restarted still
> >getting same errors??..Any Ideas why even after shudown???
> >
> >Mon Jul 23 08:53:30 2001
> >Errors in file /software/app/oracle/admin/baanIV/udump/ora_44226.trc:
> >ORA-00600: internal error code, arguments: [3509], [2], [], [],
> >[], [], [],
> >[]
> >ORA-01114: IO error writing block to file 166 (block # 134552)
> >ORA-07376: sfwfb: write error, unable to write database block.
> >IBM AIX RISC System/6000 Error: 27: File too large
> >Additional information: 134552
> >
> >
> >
> >**********************************************************************
> >This email and any files transmitted with it are confidential and
> >intended solely for the use of the individual or entity to whom they
> >are addressed. If you have received this email in error please notify
> >the system manager.
> >
> >This footnote also confirms that this email message has been swept by
> >MIMEsweeper for the presence of computer viruses.
> >
> >www.mimesweeper.com
> >**********************************************************************
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Raghu Kota
> INET: raghukota_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
>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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Raghu Kota INET: raghukota_at_hotmail.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jul 23 2001 - 15:49:50 CDT
 |
 |