| datafile [message #50143] |
Mon, 04 March 2002 02:24  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
What is the command for dropping a datafile. I tried to drop the tablespace(including contents) which contained the datafile.
The tablespace gets dropped but the associated datafile does not get dropped. What do i do?
|
|
|
|
| Re: datafile [message #50145 is a reply to message #50143] |
Mon, 04 March 2002 03:29  |
David Rooney
Messages: 5
Registered: March 2002
|
Junior Member |
|
|
I take it you used Drop tablespace x command
This command only removes the pointer in the Control file, The datafile has to be removed using OS commands manually
|
|
|
|
| Re: datafile [message #50166 is a reply to message #50143] |
Mon, 04 March 2002 23:07 |
irfan
Messages: 19
Registered: July 2001
|
Junior Member |
|
|
No, datafiles are not meant to be dropped once added. Here is a support note
with some methods you can use. (Doing an alter database OFFLINE DROP is not a
method either).
Before we start with detailed explanations of the process involved, please note
that Oracle does not provide an interface for dropping datafiles in the same way
that you could drop a schema object such as a table, a view, a user, etc. Once
you make a datafile part of a tablespace, the datafile CANNOT be
removed, although we can use some workarounds.
Article-ID: <Note:111316.1>
Circulation: PUBLISHED (EXTERNAL)
Folder: server.Rdbms.DBA.Admin
Topic: Managing Controlfiles and Datafiles
Title: How to 'DROP' a Datafile from a Tablespace
[mod-edit]Removed copyrighted metalink content.
[Updated on: Tue, 28 March 2006 04:58] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
