Re: Drop tablespace Problem

From: Robert Young <rcyoung_at_groupz.net>
Date: 1997/10/12
Message-ID: <AC43556EA646F435.29CC2B47BBA6ADEA.8CE84ED125DD43CF@library-proxy.airnews.net>#1/1

Are there any other tables with foreign key constraints on the tables in the tablespace you were dropping?

Greg Westendorf wrote in message <01bcd593$57ff4ff0$8e0112c7_at_gwestendorf>...
>Hi and thanks in advance,
>This is Oracle 7.3 for WinNT. I'm trying to drop a tablespace using 'drop
>table DATACS including contents;'.
>It keeps returning an oracle error 'ORA-00959 tablespace does not exists'.
>I have already truncated and then dropped any tables in the tablespace.
>I've searched DBA_TABLES for any tables that might be left over in that
>tablespace. WHen I search on the dba_tablespace_names the tablespace is
>listed (and status is ONLINE). I've tried to delete that datafile and
>Oracle has a thread on it because I get a locked error .
>So, does anybody have any ideas? I'd like to delete this so I can free the
>disk space on the server.
>
>thanks again
>greg
>
>westendorf_at_NOSPAMcp-consulting.com
>remove nospam from address before responding
Received on Sun Oct 12 1997 - 00:00:00 CDT