Re: deleted files

1. startup mount
2. alter database datafile <datafilename> offline drop
3. alter database open
4. export all tables from the users tablespace
5. drop and recreate the tablespace

Yossie Mousalli wrote:
>
> By mistake I create a new table under USERS and deleted it.
> The problem is that when I try to startup my db I get an error that the file
> doesn't exists. This file was new and empty.
> Can I remove this configuration and startup my db?
> The errors are:
> SQLDBA> connect internal
> Connected.
> SQLDBA> startup
> ORACLE instance started.
> Database mounted.
> ORA-01157: cannot identify data file 10 - file not found
> ORA-01110: data file 10: '/project/oracle/dbs/newfilename'
> Attempting to dismount database........Database dismounted.
> Attempting to shutdown instance........ORACLE instance shut down.
> Sincerely
> Yossie
Received on Fri Oct 30 1998 - 19:39:33 CET