Start a database with a missing data file

April 2018

In order to start an Oracle database with a misssing data file:
  • First get connected to SQL*DBA or Server Manager and run "shutdown abort"
  • Run startup mount
  • Run the following command to replace the datafile (eg using... /oradata/temp_01.dbf):

Change database datafile: datafile `.../oradata/temp_01.dbf' offline drop;
  • alter database open;
  • drop tablespace TEMP including contents.
Published by jak58. Latest update on August 15, 2010 at 06:56 AM by jak58.
This document, titled "Start a database with a missing data file," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
ORA-00600 internal error code, arguments
ORA-01630 : max # extents (extent) reached in temp segment