Re: Cannot delete Tablespace without datafile

From: Sudarshan Sampath <ssampath_at_home.com>
Date: 2000/06/02
Message-ID: <3937B049.19190D6@home.com>#1/1

Thank you so much. This solution worked like a charm....and I was finally able to open the database.

Thanks again for your great help.

Bob Fazio wrote:

> I have had to do this before, and I can't remember all of the syntax, but I
> believe this is what you will have to do.
>
> First you need to drop the file from the database.
>
> svrmgrl> alter database datafile '...' offline drop;
> The tablespace is now offline (and you should be able to open the database);
> svrmgrl> alter database open;
> svrmgrl> drop tablespace ... including contents cascade constraints;
>
> --
> Robert Fazio, Oracle DBA
> rfazio_at_home.com
> remove nospam from reply address
> http://24.8.218.197/
Received on Fri Jun 02 2000 - 00:00:00 CDT