[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference eps::oracle

Title:Oracle
Notice:For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010
Moderator:EPS::VANDENHEUVEL
Created:Fri Aug 10 1990
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1574
Total number of notes:4428

1530.0. "Dropping a tablespace with nonexistent data file" by NEWVAX::BUCHMAN (Rosalie's Uncle) Fri Mar 14 1997 15:23

    I'm having trouble getting rid of an obsolete tablespace. The main file
    associated with this tablespace was deleted a while ago. Now, when I
    try to drop it, I get error messages on accessing the data file. Is
    there any way to get around this? I've tried creating an empty file, or
    copying in a file from a different table space, and just get different
    variants on the same message.
    			Thanks,
    				Jim B.
T.RTitleUserPersonal
Name		DateLines
1530.1Got it!NEWVAX::BUCHMANRosalie's UncleFri Mar 14 1997 16:086
    Got a quick response from Oracle Support on this one: first, get rid of
    the file reference:
    	alter database datafile 'pathname' offline drop;
    
    Then drop the tablespace.
    				Jim  B.