Re: Drop tablespaces with missing datafiles

From: <eric_peterson_at_maurices.inrg.com>
Date: Thu, 29 Jul 1999 14:13:48 GMT
Message-ID: <7npnik$lf7$1@nnrp1.deja.com>

Try offlining the tablespace and then dropping.

Eric Peterson
Programmer/Analyst DBA
Maurices Inc.

In article <379DA9B7.BB3FD38_at_spin.ch>,
sjo_at_spin.ch wrote:
> Hi
>
> I would like to drop a tablespace, which doesn't have any content.
> By some mistake the datafiles are gone. Now Oracle refuses to
> drop the tablespace, because the datafiles aren't present, and I
> can't rebuild the tablespace because it's still present. Any ideas
> how to solve that?
>
> bye
> --
> Sam Jordan
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 29 1999 - 09:13:48 CDT