| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Urgent..RE: Temp problem
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
>**********************************************************************
-- 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 - 11:52:14 CDT
 |
 |