Re: Newbie questions ???

Perform the following steps:

  1.) mount the database

  2.) alter database datafile 'name' offline drop;

  3.) open the database

  4.) drop tablespace tablespacename including contents;

NiteOwl wrote:

> Hi,
>
> How can I drop a tablespace without a datafile ?
> Example, temp tablespace with data file '/ora73/dbf/temp/my_temp.dbf'
> deleted.
>
> The database will detect the error and would not open. How can
> I fix this problem... Any hints will be appreciated.
>
> NiteOwl
Received on Tue Nov 10 1998 - 12:00:12 CST