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.
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: 64139
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
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.
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: 64139
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
Previous Topic: 10gR2 monitoring
Next Topic: Unable to extend extent
Goto Forum:
  


Current Time: Thu Dec 08 08:29:24 CST 2016

Total time taken to generate the page: 0.25157 seconds