Friday 10 January 2014

How to Remove Data Files before Opening a Database?

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1824624640 bytes
Fixed Size                  1337184 bytes
Variable Size            1090521248 bytes
Database Buffers          721420288 bytes
Redo Buffers               11345920 bytes
Database mounted.
SQL> alter database datafile '/d01/oracle/oradata/prod/abdulwasiq01.dbf' offline drop;

Database altered.

SQL> alter database open;

Database altered.

No comments:

Post a Comment