Re: Help! Error in ORA file

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Sun, 29 Aug 1999 11:18:12 +0100
Message-ID: <7qau0k$6s6$1@news.comcity.de>

There is a command

Alter database offline drop datafile <DATAFILE>

I'm not sure about the exact syntax, so look in the online-help. You can use this command with the tool 'svrmgrl' (or svrmgrl). Start this program (in Oracle_HOME/BIN), connect
as internal and try the command. Be careful, this command seems to be sort of buggy.

Bye
Uli

> I have serious problem with Oracle 8 server.
> Because of HDD fauilure one of ORA files has been damaged. This file
> refers to tablespace containing sample data and lost of these data is
> acceptable. But I must immedietly export data, contained in another
> tablespace. Oracle server is not able to open database (error ORA -
> 01110 - file not available...). Database is mounted.
> What can I do?
> Can I, for example, define in parameters file (or in another place)
> files to be skiped at database startup? Or - Can I remove from MOUNTED
> (not open) database tablespace with errors?
Received on Sun Aug 29 1999 - 05:18:12 CDT