[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| 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 12: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.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1530.1 | Got it! | NEWVAX::BUCHMAN | Rosalie's Uncle | Fri Mar 14 1997 13:08 | 6 |
| 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.
|