Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help : Database verification error
While installing tables for the Oracle Data Mart Suite onto an Oracle
8.0.5 development server, I noticed that the system tablespace had
grown very large (4GB). As the original tablespace size was 200Mb, I
removed the new tables, set the default tablespace object size to 512Kb
and reinstalled - no obvious problems and the tablespace was back down
to c100Mb.
Later in the day, developers reported that other tables in their
schemas "disappeared" and Oracle returned an "object no longer exists"
error. Users were asked to log off and the database was shutdown
(immediate) and restarted. The following error was received:
Oracle Server Manager Release 3.0.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production
SVRMGR> connect internal_at_londw01
Password:
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 109518848 bytes Fixed Size 49152 bytes Variable Size 27377664 bytes Database Buffers 81920000 bytes Redo Buffers 172032 bytesDatabase mounted.
ORA-01122: database file 1 failed verification check ORA-01110: data file 1: 'D:\ORADATA\LONDW01\SYS1DW01_01.ORA' ORA-01200: actual file size of 918216 is smaller than correct size of1043205 blocks
Any ideas?
--
Tom Lewis
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 18 1999 - 12:48:13 CDT