Re: How to delete Tablespace when datafile is missing ?

From: Peng Hu <hup_at_nms.otc.com.au>
Date: 1995/04/18
Message-ID: <3mv3os$d8o_at_deagol.pad.otc.com.au>#1/1

cracraft_at_rice-chex.ai.mit.edu (Stuart Cracraft) writes:

>Restore the datafile from backup tape. Then proceed normally.
>I wouldn't recommend any "hackish" solutions to this one. 
>This is what your backups are meant to help avoid!

Oracle v6 hackish solusions will be less used since starting from Oracle7, the RDBMS allows you to recover a damaged or missing datafile without terminating the operations in order to restore database from the backup even if it is available.

This new feature should really be remembered by DBAs The syntax to recover a missing datafile is:

        ALTER DATABASE CREATE DATAFILE 'file1' AS 'file2';

where, file1 - old datafile

       file2 - new datafile

Once the datafile is recovered, the tablespace can then be dropped. Everything is nicely done ON-LINE.

Regards.

Peng Hu
Database Consultant

---

| International Network Systems | Mid Range Group |
| Telstra OTC Australia | IBM Australia |
| 363 Oxford Street | PO Box 400 |
| Paddington, NSW 2012 | Pennant Hills, NSW 2120 |
| Australia | Australia |
| Tel: +61-2-3393886 | Tel: +61-2-3547749 |
| Fax: +61-2-3393985 | Fax: +61-2-3547766 |

|-------------------------------------------------------------------------|


|     Email: Peng.Hu_at_pad.otc.com.au                                       |


|     Pager: 016 020 quoting 267 675                                      |


 -------------------------------------------------------------------------

Received on Tue Apr 18 1995 - 00:00:00 CEST