Re: HELP! can't get database open

Jacek Jakubowski wrote:
>
> Hi,
>
> Is there an method to open the databse after i have removed an
> tablespace-file. I really
> don't need this dataspace. My problem is, i can not open database,
> becuse oracle looks for it file. So i can't drop this tablespace or
> switch it offline.
>
> What can i even do. (except to reinstall whole databse )
>
> P.S: Oracle 8 under on Linux
>
> Jacek

1. startup mount
2. alter database datafile '<full path name>' offline drop ... each of the datafiles for this tablespace
3. alter database open
4. drop tablespace <tablespace name>

--
-Kevin Cook Received on Mon Apr 19 1999 - 07:24:03 CDT