vicker313 tech blog

November 7, 2009

Drop Data File from Oracle Database

Filed under: Oracle — Tags: , — vicker313 @ 9:29 am

You want to start an Oracle Database, but fail because of 1 particular data file is missing (for some reason). And you want to drop the data file in order to start the database:

  1. Log in SQLPLUS as SYSDBA
    sqlplus / as sysdba
  2. Start database in mount mode
    start mount
  3. Then remove the missing data file with statement below
    alter database datafile 'missing datafile' offline drop

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at

%d bloggers like this: