Home » RDBMS Server » Server Administration » Oracle 9i/10g Dropping a datafile from a tablespace
Oracle 9i/10g Dropping a datafile from a tablespace [message #246003] Tue, 19 June 2007 09:42 Go to next message
sk003
Messages: 16
Registered: November 2006
Location: atlanta,ga
Junior Member
What is the best way to drop datafile from tablespace with multiple datafiles if the datafile is no longer needed ?

Thanks.

Report message to a moderator

Re: Oracle 9i/10g Dropping a datafile from a tablespace [message #246023 is a reply to message #246003] Tue, 19 June 2007 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In 9i, you can't drop a datafile in a tablespace, you have to drop the whole tablespace.
In 10g, you can use "alter tablespace ... drop datafile ...", if the file is empty.

Regards
Michel

Report message to a moderator

Re: Oracle 9i/10g Dropping a datafile from a tablespace [message #246041 is a reply to message #246023] Tue, 19 June 2007 11:14 Go to previous messageGo to next message
sk003
Messages: 16
Registered: November 2006
Location: atlanta,ga
Junior Member
In 9i, what is the purpose of alter database datafile ... offline drop ?

Thanks.

Report message to a moderator

Re: Oracle 9i/10g Dropping a datafile from a tablespace [message #246042 is a reply to message #246041] Tue, 19 June 2007 11:19 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You put the datafile offline and you say to Oracle that you want to drop it but this has no effect in Oracle.
It is bad named; in 10g, this clause has been renamed to a better "offline FOR drop".

Regards
Michel

Report message to a moderator

Previous Topic: 10gR2 monitoring
Next Topic: Unable to extend extent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:37:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.